Relational versus non-relational database systems for data warehousing

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....

• Type: Journal
• Year: 2010
• Where: DOLAP
• Authors: Carlos Ordonez, Il-Yeol Song, Carlos Garcia-Alvarado
• Keywords: Database, DOLAP 2010, Information Technology, Large Data, Relational Model