Tag Archives: data

Extracting Data from Internet in Excel 2007

June 21, 2009 – 11:53 am | By Gatt | Posted in Software | Also tagged , , , | Comments (0)

Excel 2007 comes with the option of querying web to export table data from internet. This is a very good option if you rely on constantly updated data such as exchange rates etc. Read More »

OLTP vs OLAP

May 12, 2009 – 12:43 pm | By Gatt | Posted in Enterprise apps | Also tagged , , , , | Comments (4)

OLTP (Online transaction processing system) is a traditional term used for transaction system used to carry out day to day business functions such as ERP, CRM etc. OLTP system solved a critical business problem of automating daily business functions and running real time reports and analysis. But these systems were not designed for analysis and queries. Frustration started to build in Business management as OLTP systems could not provide the analysis on the data. Resource heavy management analytical queries started to affect performance of OLTP systems and users of OLTP system also got frustrated. Read More »

Are we ready to create Wikipedia for Data?

April 9, 2008 – 9:59 pm | By Gatt | Posted in Internet | Also tagged , , | Comments (0)

An article from Bred Taylor titled “We need Wikipedia for Data“, created lot of buzz. As the name suggests article covers need to create freely licensed data that every programmer can access. Later, ReadWriteWeb summarized some of the projects already creating free data. Question remains are we ready to create something as big and useful as Wikipedia? Read More »