Title :
Query maintenance with hierarchical updates
Author :
Gosain, Anjana ; Madaan, Heena
Author_Institution :
USICT, Guru Gobind Singh Indraprastha Univ., New Delhi, India
Abstract :
Data warehouse must evolve with changes in the schema, software components, user requirements or organization´s business rules. Various authors have proposed different schema evolution operators for various level updates but none of them handled the syntactic and semantic adaptation of queries automatically. Few authors discussed this problem considering few changes in data sources schema and data warehouse structure schema. But they did not deal with the problem due to changes in the hierarchy and its levels in a dimension of the schema. In this paper, we perform what-if analysis for change in the hierarchy and its levels in the data warehouse schema. Queries, views and relations are modeled in a graph annotated with policies to manage the change event. Framework detects the affected part of graph due to change in hierarchical levels and readjusts according to the specified action without making the queries invalid.
Keywords :
data warehouses; graph theory; query processing; automatic syntactic-semantic query adaptation; change event management; data source schema; data warehouse structure schema; graph annotation; graph modeling approach; hierarchical level update; organization business rules; query maintenance; query modelling; relation modelling; schema evolution operators; structure software components; user requirements; view modelling; what-if analysis; Manuals; data warehouse evolution; graph modeling; hierarchical update; policies;
Conference_Titel :
Recent Advances and Innovations in Engineering (ICRAIE), 2014
Conference_Location :
Jaipur
Print_ISBN :
978-1-4799-4041-7
DOI :
10.1109/ICRAIE.2014.6909169