EA-STD-021 Database Server – Data Warehouse

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.

 

Baseline (Today) Emerging (To track)
  • None

 
  • Evolving Free and Open Source Products
  • Cloud based DBaaS / SaaS solutions
  • Other

 
Tactical (0-3 years) Strategic (3-6 years)
  • Microsoft SQL Server 2014
  • DBaaS / SaaS Solution
  • Microsoft SQL Server 2014
  • Microsoft SQL Server Future Versions
  • Other Open Source Database Offering
  • DBaaS / SaaS Solutions
Retirement (to be removed) Containment (No new development)

 

Comments

None

Database Data Warehouse Server Roadmap

db data warehouse

Status:

Draft

Approval Date:

Next Review: