Relational versus non-relational database systems for data warehousing

  • Authors:
  • Carlos Ordonez;Il-Yeol Song;Carlos Garcia-Alvarado

  • Affiliations:
  • University of Houston, Houston, TX, USA;Drexel University, Philadelphia, PA, USA;University of Houston, Houston, TX, USA

  • Venue:
  • DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

Relational database systems have been the dominating technology to manage and analyze large data warehouses. Moreover, the ER model, the standard in database design has a close relationship with the relational model. Recently, there has been a surge of alternative technologies for large scale analytic processing, most of which are not based on the relational model. Out of these proposals, distributed file systems together with MapReduce have become strong competitors to relational database systems to analyze large data sets, exploiting parallel processing. Moreover, there is progress on using MapReduce to evaluate relational queries. With that motivation in mind, this panel will compare pros and cons of each technology for data warehousing and will identify research issues, considering practical aspects like ease of use, programming flexibility and cost; as well as technical aspects like data modeling, storage, hardware, scalability, query processing, fault tolerance and data mining.