6533b85dfe1ef96bd12bdc94

RESEARCH PRODUCT

Query-Driven Method for Improvement of Data Warehouse Conceptual Model

Darja SolodovnikovaLaila NiedriteAivars Niedritis

subject

DatabaseSource systemComputer scienceSchema (psychology)InformationSystems_DATABASEMANAGEMENTSchema versioningData structurecomputer.software_genrecomputerData warehouse

description

We propose a query-driven method that elicits the information requirements from existing queries on data sources and their usage statistics. Our method presumes that the queries against the source database reflect the analysis needs of users. We use this method to recommend changes to the existing data warehouse schemata. In our method, we take advantage of the schema versioning approach to reflect all changes that occur in the analysed process, and we analyse the activity of users in the source system, rather than changes in physical data structure, to infer the necessary improvements to the data warehouse schema.

yearjournalcountryeditionlanguage
2013-01-01
https://doi.org/10.1007/978-1-4614-7540-8_41