V+H: Hybrid architecture for DSS and OLTP

María del Pilar Angeles and Victor González Castro

International Journal of Information Management, 2013, vol. 33, issue 6, 940-947

Abstract: Previous research has been done to identify the best pragmatic approach that DBMSs must follow to manage different workloads. Some approaches have followed the “One size fits all” approach, 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. This paper proposes 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 for storage.

Keywords: Vertical DBMS; Columnar DBMS; OLTP; DSS; Hybrid architecture (search for similar items in EconPapers)
Date: 2013
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
http://www.sciencedirect.com/science/article/pii/S0268401213000972
Full text for ScienceDirect subscribers only

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:eee:ininma:v:33:y:2013:i:6:p:940-947

DOI: 10.1016/j.ijinfomgt.2013.08.006

Access Statistics for this article

International Journal of Information Management is currently edited by Yogesh K. Dwivedi

More articles in International Journal of Information Management from Elsevier
Bibliographic data for series maintained by Catherine Liu ().