DocumentCode
3093956
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
fYear
1999
fDate
36373
Firstpage
282
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;
fLanguage
English
Publisher
ieee
Conference_Titel
Scientific and Statistical Database Management, 1999. Eleventh International Conference on
Conference_Location
Cleveland, OH
Print_ISBN
0-7695-0046-3
Type
conf
DOI
10.1109/SSDM.1999.787649
Filename
787649
Link To Document