There are some basic database concepts and topics that everyone reading this book should know, and these will be covered in this first chapter. The following topics will be covered:
  • History of relational database structures: Brief overview of why relational databases began

  • OLTP and data warehousing: Compares online transaction processing (OLTP) with data warehousing, plus an introduction to the different modules that make up a complete database system

  • Overview of the SQL Server database design process: Looks at the process followed in developing database applications

  • Case study introduction: Introduces the case study, which you’ll build throughout the course of the book


Data Warehouse Database Design Fact Table Current Account Balance Disparate Source 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Louis Davidson 2004

Authors and Affiliations

  • Louis Davidson

There are no affiliations available

Personalised recommendations