Title :
Building a star join schema using SQL Server
Author :
Sørensen, Jens Otto ; Alnor, Karl
Author_Institution :
Dept. of Inf. Sci., Aarhus Sch. of Bus., Denmark
Abstract :
We construct a star join schema and show how this schema can be created using the basic tools delivered with SQL Server 7.0. The 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 (a sample database about a fictitious book distribution company)
Keywords :
SQL; data warehouses; file servers; publishing; relational databases; Pubs database; SQL Server 7.0; book distribution company; business logic; data loading; operational database; star join schema; Buildings; Data warehouses; Databases; Hardware; Information science; Logic; Packaging; Pricing; Prototypes; Web server;
Conference_Titel :
Scientific and Statistical Database Management, 1999. Eleventh International Conference on
Conference_Location :
Cleveland, OH
Print_ISBN :
0-7695-0046-3
DOI :
10.1109/SSDM.1999.787649
