|
|
|
|
What is a Data Warehouse?Just after the dawn of computing, timesharing (1960s and 1970s) gave non-programmers a mechanism to work directly with computers to solve their business and scientific problems. As timesharing matured (1980s) and timesharing was migrated from external service bureaus to internal IT organizations, they were given the name, Information Center. Initially information centers were mainframe based. As PCs were introduced, information centers facilititated their integration into organizations. As the capabilities of relational databases matured in the 1990s, The information center concept was recast as the Data Warehouse. The data warehouse includes sophisticated data preparation tools, very high volume databases, and end-user oriented query, analysis and reporting tools. And yes, many tools are available to publish data warehouse data on the web. Our Approach:A data warehouse starts with a clear understanding of the business objectives and a sound database design. Operational and external data sources are mapped into various data warehouse databases. As data structures are built for the analysis tools, the database design is optimized to support reporting, not transaction processing. Specialized databases are built to match the features supported by analysis tools. These specialized databases often called Data Marts. Finally, business views are built in the analysis tools to provide the business users with "friendly" access to this data. Qualifications:We have been working in the information center and data warehouse discipline since 1982. Kuhlmey Systems has recently been involved in a major data warehousing project using ORACLE and related Oracle tools along with Microsoft tools. Prior development projects included Dbase, IBM SQL/DS and NOMAD database management systems. We attend many training sessions and conterences to keep current with data warehousing related technologies.
|
|
.
Send mail to
webadmin@kuhlmeysystems.com with questions or
comments about this web site.
|