Quarry : digging up the gems of your data treasury
Visualitza/Obre
Cita com:
hdl:2117/27125
Tipus de documentComunicació de congrés
Data publicació2015
Condicions d'accésAccés obert
Tots els drets reservats. Aquesta obra està protegida pels drets de propietat intel·lectual i
industrial corresponents. Sense perjudici de les exempcions legals existents, queda prohibida la seva
reproducció, distribució, comunicació pública o transformació sense l'autorització del titular dels drets
Abstract
The design lifecycle of a data warehousing (DW) system is primarily led by requirements of its end-users and the complexity of underlying data sources. The process of designing a multidimensional (MD) schema and back-end extracttransform-load (ETL) processes, is a long-term and mostly manual task. As enterprises shift to more real-time and ’on-the-fly’ decision making, business intelligence (BI) systems require automated means for efficiently adapting a physical DW design to frequent changes of business needs. To address this problem, we present Quarry, an end-to-end system for assisting users of various technical skills in managing the incremental design and deployment of MD schemata and ETL processes. Quarry automates the physical design of a DW system from high-level information requirements. Moreover, Quarry provides tools for efficiently accommodating MD schema and ETL process designs to new or changed information needs of its end-users. Finally, Quarry facilitates the deployment of the generated DW design over an extensible list of execution engines. On-site, we will use a variety of examples to show how Quarry facilitates the complexity of the DW design lifecycle.
CitacióJovanovic, P. [et al.]. Quarry : digging up the gems of your data treasury. A: International Conference on Extending Database Technology. "Proceedings of the 18th International Conference on Extending Database Technology". Brussels: 2015, p. 549-552.
ISBN978-3-89318-067-7
Fitxers | Descripció | Mida | Format | Visualitza |
---|---|---|---|---|
paper-351.pdf | 1,603Mb | Visualitza/Obre |