Description
Data Warehouse (DW) database functional requirements are different than Online Transaction Processing (OLTP) Database Management Sytems (DBMS) in that they support large databases, complex multi-table join processing and schema support, and have specialized index technology, workload management, and data partitioning capabilities. Most importantly, they support parallel capabilities (e.g., I/O, query and operations), and parallel utilities (e.g., backup/recovery and reorganization). DW databases are generally not updated real time, but are frequently updated via over night, batch oriented processes.
Brick Information
Tactical
(0-2 years)
|
Strategic
(2-5 years)
|
- IBM DB2 Universal Database
- Microsoft SQL Server
- MySQL
- Oracle
|
- IBM DB2 Universal Database
- Microsoft SQL Server
- Oracle
|
Retirement
(To be eliminated)
|
Containment
(No new development)
|
|
|
Baseline
(Today)
|
Emerging
(To track)
|
- IBM DB2 Universal Database
- Microsoft Access
- Microsoft SQL Server
- MySQL
- Oracle
|
- Evolving open source productsComments
|
Comments
Time Table
This architecture definition approved on:
May 25, 2005
The next review is scheduled in:
TBD