Evolution of Data Warehousing
June 13th, 2008 |TanmayKumar | 796 views | Random | Comment (0)
In the 1970s, the data-processing department was not able to handle huge backlogs of requests for data analysis. Applications data was hidden behind mainframe files and databases, and it was periodically recorded in tapes for specific information manipulation.
In the 1980s, real computer applications were decentralized. DDBMS (distributed database management system) became a hit. But accessing data directly from the transactional databases did not work in real life, and “islands of data” were still a problem.
Since the 1990s, data warehousing has become the most feasible solution to optimize and manipulate data. The current practice is to gather the data that is needed in an optimized database, regardless of the number of different applications and different platforms that are used to generate the source data.
The use of data warehouse technology has been widespread among Fortune 1000 companies for over 20 years. However the tools, expertise, and costs associated with a data warehouse have placed it well out of reach of most, if not all, small to mid-sized companies. The typical cost of an ETL(Extraction Transformation Loading) program alone is often $40,000 or more. This is just one single component of a data warehouse. When considering the additional costs of installation, data file mapping, customization, and other services, industry experts have estimated the minimum cost of a complete data-warehouse solution at close to $100,000.
CARY, NC (Sept. 20, 2006) – According to a report issued by a top analyst firm, SAS is the world’s number one vendor in both data warehouse generation and data warehouse access software sales.
In its “Worldwide Data Warehousing Tools 2005 Vendor Shares” report (Doc #203229, Aug. 2006), IDC showed sales of SAS’ data warehouse generation software increasing from $198.8 million in 2004 to $224.0 million in 2005, a 12.7 percent increase. Also, SAS saw a 12.3 percent increase in revenue for its data warehouse access software, rising from $502.3 million in 2004 to $564.3 million in 2005.
(to be continued………….)
If you enjoyed this post, make sure you subscribe to my RSS feed!