2015 · 56 citations · 16 references
ComputingComputer ScienceData ManagementDatabasesStorage SystemsData Storage SystemsData WarehousingDatabase ManagementNosql DatabasesQuery ProcessingStructured Query LanguageAggregationData Warehousing ArchitectureDocument DatabasesLoading TimeOlap BenchmarkingOnline Analytical Processing (Olap) ArchitectureOnline Analytical Processing (Olap) SchemaStar Schema
Not only SQL (NoSQL) databases are becoming increasingly popular and have some interesting strengths such as scalability and flexibility. In this paper, we investigate on the use of NoSQL systems for implementing OLAP (On-Line Analytical Processing) systems. More precisely, we are interested in instantiating OLAP systems (from the conceptual level to the logical level) and instantiating an aggregation lattice (optimization). We define a set of rules to map star schemas into two NoSQL models: column-oriented and document-oriented. The experimental part is carried out using the reference benchmark TPC. Our experiments show that our rules can effectively instantiate such systems (star schema and lattice). We also analyze differences between the two NoSQL systems considered. In our experiments, HBase (column-oriented) happens to be faster than MongoDB (document-oriented) in terms of loading time.
16
Adam Jacobs · Communications of the ACM · 2009 · 646 citations · Full text
Optimizing ETL Processes in Data Warehouses
Alkis Simitsis, Panos Vassiliadis, Timos Sellis · 2005 · 207 citations · Full text