Using Constraint Programming in Selection Operators for Constraint Databases

Constraint Databases represent complex data by means of formulas described by constraints (equations, inequations or Boolean combinations of both). Commercial database management systems allow the storage and efficient retrieval of classic data, but for complex data a made-to-measure solution combin...

ver descrição completa

Detalhes bibliográficos
Autores: Gómez López, María Teresa, Martínez Gasca, Rafael
Tipo de documento: artigo
Estado:Versión enviada para evaluación y publicación
Data de publicação:2014
País:España
Recursos:Universidad de Sevilla (US)
Repositório:idUS. Depósito de Investigación de la Universidad de Sevilla
OAI Identifier:oai:idus.us.es:11441/138515
Acesso em linha:https://hdl.handle.net/11441/138515
https://doi.org/10.1016/j.eswa.2014.04.047
Access Level:Acceso aberto
Palavra-chave:Complex data
Optimal query evaluation
Selection Operator
Constraint Databases
Constraint programming
Descrição
Resumo:Constraint Databases represent complex data by means of formulas described by constraints (equations, inequations or Boolean combinations of both). Commercial database management systems allow the storage and efficient retrieval of classic data, but for complex data a made-to-measure solution combined with expert systems for each type of problem are necessary. Therefore, in the same way as commercial solutions of relational databases permit storing and querying classic data, we propose an extension of the Selection Operator for complex data stored, and an extension of SQL language for the case where both classic and constraint data need to be managed. This extension shields the user from unnecessary details on how the information is stored and how the queries are evaluated, thereby enlarging the capacity of expressiveness for any commercial database management system. In order to minimize the selection time, a set of strategies have been proposed, which combine the advantages of relational algebra and con-straint data representation.