In the last few years research has been done in order to define the best approach that DBMSs must follow to manage different workloads. Some approaches have followed the “One size fits all” trying to incorporate all features in a row-oriented DBMS (also called horizontal) to manage both OLTP and DSS workloads. Additionally, there have been specialized DBMS following a columnar approach (also called vertical) that focuses on the growing demand to efficiently manage DSS workloads. The present paper is aimed to propose a combination of both vertical and horizontal DBMS to best manage OLTP and DSS workloads. We have used mature, commercially available products from a single vendor and developed a custom middleware Decision Query Module that identifies the best option for most efficient execution of a query. This V+H architecture also offers the functionality of a mirrored DB without paying twice of the storage.
Angeles, Maria Del Pilar and Gonzalez-Castro, Victor, "V+H: Architecture to Manage DSS and OLTP Workloads" (2012). MWAIS 2012 Proceedings. 13.