Architectural Classification

Technology \ Application \ Data Management Systems

Standard Specification

Server functional requirements are different than Online Transaction Processing (OLTP) Database Management Systems (DBMS) in that typically they support larger 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.

Comments

None