An SQL extension supporting user viewpoints
In order to accomplish independence on the logical data organization, a relational DBMS must be capable of interpreting query language sentences which reference attributes belonging to different relations even if the necessary joins are not explicitly formulated (query inference problem). In this work we propose an SQL extension which supports concise formulation of queries through the dynamic definition of user viewpoints. User viewpoints are perspectives for accessing data; each user viewpoint defines a virtual derived relation (user viewpoint relation) which includes all those in the database scheme, each accessed by means of exactly one chain of system-activated equi-joins. Our approach to the definition of user viewpoint relations aims at reducing the global cost of query formulation, that is, the number of joins which must be explicitly written.
Unable to display preview. Download preview PDF.
- G. Bellavia, D. Maio and S. Rizzi. Resolving the query inference problem by optimizing the query-formulation cost. Technical Report CIOC-C.N.R. n. 85 (1992).Google Scholar
- G. Bellavia, D. Maio and S. Rizzi. Minimizing the cost of query formulation through User Viewpoint Relations. Atti del Secondo Convegno Nazionale su Sistemi Evoluti Per Basi Di Dati, Rimini, Italy, 141–159 (1994).Google Scholar
- A. Motro. Constructing queries from tokens. Proc. ACM SIGMOD Int. Conf. Management of Data. Washington D.C., 120–131 (1986).Google Scholar