Show simple item record

dc.contributor.authorJovanovic, Petar
dc.contributor.authorRomero Moral, Óscar
dc.contributor.authorSimitsis, Alkis
dc.contributor.authorAbelló Gamazo, Alberto
dc.contributor.authorCandón Arenas, Héctor
dc.contributor.authorNadal Francesch, Sergi
dc.contributor.otherUniversitat Politècnica de Catalunya. Departament d'Enginyeria de Serveis i Sistemes d'Informació
dc.identifier.citationJovanovic, 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.
dc.description.abstractThe 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.
dc.format.extent4 p.
dc.subjectÀrees temàtiques de la UPC::Informàtica::Sistemes d'informació
dc.subject.otherdata warehousing
dc.titleQuarry : digging up the gems of your data treasury
dc.typeConference lecture
dc.contributor.groupUniversitat Politècnica de Catalunya. MPI - Modelització i Processament de la Informació
dc.description.peerreviewedPeer Reviewed
dc.rights.accessOpen Access
dc.description.versionPostprint (published version)
local.citation.authorJovanovic, P.; Romero, O.; Simitsis, A.; Abello, A.; Candón, H.; Nadal, S.
local.citation.contributorInternational Conference on Extending Database Technology
local.citation.publicationNameProceedings of the 18th International Conference on Extending Database Technology

Files in this item


This item appears in the following Collection(s)

Show simple item record

All rights reserved. This work is protected by the corresponding intellectual and industrial property rights. Without prejudice to any existing legal exemptions, reproduction, distribution, public communication or transformation of this work are prohibited without permission of the copyright holder