A COMPARATIVE STUDY ON BITEMPORAL SEMISTRUCTURED DATA WAREHOUSES AND RELATIONAL DATABASES
Abstract
Data warehouses and relational databases are two different areas for data storage. A special structured data warehouse is prepared in this study that is bitemporal and its structure is formed as nested. Same data is stored in data warehouse and the relational database. These two data storage area is competed with each other. Same resulting queries are queried by using relational database objects and data warehouse components. The results are compared and evaluated in terms of query sets, processing time and disk space usage.
Keywords
Data warehouse,Big data,Bitemporal databases,Attribute time stamping
References
- ABELLÓ A., MARTÍN C. The Data Warehouse: An Object-Oriented Temporal Database. JISBD, 675-684, 2003.
- ATAY C. E., TANSEL A. U. Bitemporal databases: Modeling and implementation, VDM Publishing, Germany, 2009.
- BEN-ZVI J. The time relational model, Doktora Tezi, University of California, Los Angeles, 1982.
- CECI M., CUZZOCREA A., MALERBA D. Effectively and efficiently supporting roll-up and drill-down OLAP operations over continuous dimensions via hierarchical clustering. Journal of Intelligent Information Systems, 1–25, 2013.
- COMBI C., OLIBONI B., POZZI G. Modeling and querying temporal semistructured data warehouses. New Trends in Data Warehousing and Data Analysis Annals of Information Systems, 1-25, 2009.
- EDER J., KONCILIA C., MORZY T. A. model for a temporal data warehouse. OES-SEO Workshop,48-54, 2001.
- GOLFARELLI M., RIZZI S. Temporal data warehousing: Approaches and techniques, PA: Information Science Reference, 1-18, 2011.
- INMON W., KRISHNAN K. Building the Unstructured Data Warehouse, Technics Publications, New Jersey, 2011.
- JANET E., RAM´IREZ R., GUERRERO E. B. A model and language for bitemporal schema versioning in data warehouses, IEEE, CIC '06. 15th International Conference, 309–314, 2006.
- KAUFMANN M., FISCHER P. M., MAY N., TONDER A., KOSSMANN D. Tpc-bih: A Benchmark for Bitemporal Databases. Springer International Publishing, 8391, 16-31, 2014.