Addressing efficiency issues during the process of integrity maintenance (extended version)

An important problem that arises when updating a deductive database is that of integrity maintenance. That is, given a consistent database and an update request, to obtain all possible updates of base facts such that the request is satisfied and no integrity constraint is violated. This problem beco...

ver descrição completa

Detalhes bibliográficos
Autores: Mayol Sarroca, Enric|||0000-0003-3777-5857, Teniente López, Ernest|||0000-0001-8890-9638
Tipo de documento: relatório científico
Data de publicação:1999
País:España
Recursos:Universitat Politècnica de Catalunya (UPC)
Repositório:UPCommons. Portal del coneixement obert de la UPC
Idioma:inglês
OAI Identifier:oai:upcommons.upc.edu:2117/93070
Acesso em linha:https://hdl.handle.net/2117/93070
Access Level:Acceso aberto
Palavra-chave:Deductive database
Updating
Integrity maintenance
EDB
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
Descrição
Resumo:An important problem that arises when updating a deductive database is that of integrity maintenance. That is, given a consistent database and an update request, to obtain all possible updates of base facts such that the request is satisfied and no integrity constraint is violated. This problem becomes more complex when views may be present in the integrity constraints definition since a repair of a constraint could be a view update, which requires a translation into base fact updates. In this paper we address efficiency issues during the process of integrity maintenance. In this sense, we propose a technique, which improves efficiency of existing methods by defining the order in which maintenance of integrity constraints should be performed. Moreover, we integrate view updating into integrity maintenance and we propose a technique for translating view updates efficiently, aimed at reducing the number of alternatives considered during the process of view updating and the EDB accesses required to perform this translation.