Quarry is a platform for managing the complex tasks of the design of DW systems. It comprises 4 main processing components and a communication and metadata component: 1. Requirements Elicitor (MineDigger [1]), 2. Requirements Interpreter (GEM [2], [3], [4], [5]), 3. Design Integrator (CoAl [6] and ORE [7]), 4. Design Deployer (Forge), 5. Communication & Metadata layer (Minecart). For supporting non-expert users in providing their information requirements at input, Quarry provides a graphical component, namely Requirements Elicitor (i.e., MineDigger). Requirements Elicitor connects to Requirements Interpreter (GEM), which for each information requirement at input semi-automatically generates validated MD schema and ETL process designs (i.e., partial designs). Quarry further offers a component (i.e., Design Integrator) comprising two modules (ORE and CoAl) for integrating partial MD schema and ETL process designs, respectively, and generating unified design solutions satisfying a complete set of requirements. At each step, after integrating partial designs of a new requirement, Quarry guarantees the soundness of the unified design solutions and the satisfiability of all requirements processed so far. Produced DW design solutions are further sent to the Design Deployer component for deciding the initial deployment (e.g., level of materialization) of a DW schema and an ETL process that populates it (i.e., Forge). The deployed design solutions are then available for further user-preferred tunings and use. To support intra and cross-platform communication, Quarry uses the communication & metadata layer (i.e., Minecart).

Peer Reviewed