Back to Search Start Over

Revolutionize Database Performance.

Authors :
Zdonik, Stan
Source :
DM Review; Jan2008, Vol. 18 Issue 1, p20-33, 3p
Publication Year :
2008

Abstract

The article provides an overview of the evolution of relational database management systems (RDBMSs) and how the gap between data warehouse requirements and data warehouse database capabilities has come about. Relational databases emerged in the nineteen seventies as a way to improve business data processing. The idea was that storing data in row-oriented tables that group related information was better than using hierarchical data models. The row-oriented architectures are optimized for write-intensive online transaction processing (OLTP), which enables simple data storage and retrieval. However, RDBMS were not designed to handle read-intensive analytical workloads. Seven database innovations that will revolutionize data warehousing are explained.

Details

Language :
English
ISSN :
15212912
Volume :
18
Issue :
1
Database :
Complementary Index
Journal :
DM Review
Publication Type :
Periodical
Accession number :
28099340