The paper presents a formal model to specify a data base, a query and the access which must be followed to obtain the answer. The model is based on the problem reduction hypergraph, for which an admissible and optimal search algorithm is known. An effective method is given to map the data base and the query into a problem reduction hypergraph, which the known search algorithm can be applied to. The optimal solution to the problem reduction hypergraph provides an optimal (and possibly parallel) program to obtain the answer to the given query. Since the model allows to determine the correct answer, if any, without modification of the data base nor requiring further information, it is an improvement over the models presented in the literature.

On finding the optimal access path to resolve a relational data base query

1980

Abstract

The paper presents a formal model to specify a data base, a query and the access which must be followed to obtain the answer. The model is based on the problem reduction hypergraph, for which an admissible and optimal search algorithm is known. An effective method is given to map the data base and the query into a problem reduction hypergraph, which the known search algorithm can be applied to. The optimal solution to the problem reduction hypergraph provides an optimal (and possibly parallel) program to obtain the answer to the given query. Since the model allows to determine the correct answer, if any, without modification of the data base nor requiring further information, it is an improvement over the models presented in the literature.
1980
Istituto di Scienza e Tecnologie dell'Informazione "Alessandro Faedo" - ISTI
relational data base query
File in questo prodotto:
File Dimensione Formato  
prod_421797-doc_149847.pdf

solo utenti autorizzati

Descrizione: On finding the optimal access path to resolve a relational data base query
Tipologia: Versione Editoriale (PDF)
Dimensione 1.25 MB
Formato Adobe PDF
1.25 MB Adobe PDF   Visualizza/Apri   Richiedi una copia

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/20.500.14243/408753
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 1
  • ???jsp.display-item.citation.isi??? ND
social impact