Work

Creating a Data Warehouse using SQL Server.

Year: 1999
Type: conference-paper
Abstract: : In this paper we construct a Star Join Schema and show how this schema can be created using the basic tools delivered with SQL Server 7.0. Major objectives are to keep the operational database unchanged so that data loading can be done without disturbing the business logic of the operational database. The operational database is an expanded version of the Pubs database [Sol96]. 1 Introduction SQL Server 7.0 is at the time of writing the latest release of Microsoft's "large" database. This version of the database is a significant upgrade of the previous (version 6.5) both with respect to user friendliness as well as with respect to capabilities. There is therefore in our minds no question about the importance of this release to the database world. The pricing and the aggressive marketing push behind this release will soon make this one of the most used, if not the most used, database for small to medium sized companies. Microsoft will most likely also try to make companies ...
Language: English
Open Access status: green
OpenAlex ID: W58358713
FWCI: 0.534
Cites: 1
Cited by: 2
Related to: 10