An SQL extension supporting user viewpoints View Full Text


Ontology type: schema:Chapter      Open Access: True


Chapter Info

DATE

1995

AUTHORS

Giuseppe Bellavia , Dario Maio , Stefano Rizzi

ABSTRACT

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. More... »

PAGES

334-343

Book

TITLE

Database and Expert Systems Applications

ISBN

978-3-540-60303-0
978-3-540-44790-0

Identifiers

URI

http://scigraph.springernature.com/pub.10.1007/bfb0049131

DOI

http://dx.doi.org/10.1007/bfb0049131

DIMENSIONS

https://app.dimensions.ai/details/publication/pub.1045525810


Indexing Status Check whether this publication has been indexed by Scopus and Web Of Science using the SN Indexing Status Tool
Incoming Citations Browse incoming citations for this publication using opencitations.net

JSON-LD is the canonical representation for SciGraph data.

TIP: You can open this SciGraph record using an external JSON-LD service: JSON-LD Playground Google SDTT

[
  {
    "@context": "https://springernature.github.io/scigraph/jsonld/sgcontext.json", 
    "about": [
      {
        "id": "http://purl.org/au-research/vocabulary/anzsrc-for/2008/08", 
        "inDefinedTermSet": "http://purl.org/au-research/vocabulary/anzsrc-for/2008/", 
        "name": "Information and Computing Sciences", 
        "type": "DefinedTerm"
      }, 
      {
        "id": "http://purl.org/au-research/vocabulary/anzsrc-for/2008/0806", 
        "inDefinedTermSet": "http://purl.org/au-research/vocabulary/anzsrc-for/2008/", 
        "name": "Information Systems", 
        "type": "DefinedTerm"
      }
    ], 
    "author": [
      {
        "affiliation": {
          "alternateName": "DEIS-Facolta' di Ingegneria, Universita' di Bologna, Italia", 
          "id": "http://www.grid.ac/institutes/grid.6292.f", 
          "name": [
            "DEIS-Facolta' di Ingegneria, Universita' di Bologna, Italia"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Bellavia", 
        "givenName": "Giuseppe", 
        "type": "Person"
      }, 
      {
        "affiliation": {
          "alternateName": "DEIS-Facolta' di Ingegneria, Universita' di Bologna, Italia", 
          "id": "http://www.grid.ac/institutes/grid.6292.f", 
          "name": [
            "DEIS-Facolta' di Ingegneria, Universita' di Bologna, Italia"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Maio", 
        "givenName": "Dario", 
        "id": "sg:person.013075040365.65", 
        "sameAs": [
          "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.013075040365.65"
        ], 
        "type": "Person"
      }, 
      {
        "affiliation": {
          "alternateName": "DEIS-Facolta' di Ingegneria, Universita' di Bologna, Italia", 
          "id": "http://www.grid.ac/institutes/grid.6292.f", 
          "name": [
            "DEIS-Facolta' di Ingegneria, Universita' di Bologna, Italia"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Rizzi", 
        "givenName": "Stefano", 
        "id": "sg:person.012370122532.25", 
        "sameAs": [
          "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.012370122532.25"
        ], 
        "type": "Person"
      }
    ], 
    "datePublished": "1995", 
    "datePublishedReg": "1995-01-01", 
    "description": "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.", 
    "editor": [
      {
        "familyName": "Revell", 
        "givenName": "Norman", 
        "type": "Person"
      }, 
      {
        "familyName": "Tjoa", 
        "givenName": "A Min", 
        "type": "Person"
      }
    ], 
    "genre": "chapter", 
    "id": "sg:pub.10.1007/bfb0049131", 
    "isAccessibleForFree": true, 
    "isPartOf": {
      "isbn": [
        "978-3-540-60303-0", 
        "978-3-540-44790-0"
      ], 
      "name": "Database and Expert Systems Applications", 
      "type": "Book"
    }, 
    "keywords": [
      "user's viewpoint", 
      "SQL extension", 
      "logical data organization", 
      "number of joins", 
      "query formulation", 
      "relational DBMS", 
      "data organization", 
      "database scheme", 
      "language sentences", 
      "dynamic definition", 
      "join", 
      "Derived Relations", 
      "queries", 
      "global cost", 
      "different relations", 
      "concise formulation", 
      "viewpoint", 
      "scheme", 
      "extension", 
      "definition", 
      "sentences", 
      "cost", 
      "dBm", 
      "work", 
      "organization", 
      "data", 
      "order", 
      "number", 
      "formulation", 
      "perspective", 
      "means", 
      "reference", 
      "independence", 
      "relation", 
      "chain", 
      "approach"
    ], 
    "name": "An SQL extension supporting user viewpoints", 
    "pagination": "334-343", 
    "productId": [
      {
        "name": "dimensions_id", 
        "type": "PropertyValue", 
        "value": [
          "pub.1045525810"
        ]
      }, 
      {
        "name": "doi", 
        "type": "PropertyValue", 
        "value": [
          "10.1007/bfb0049131"
        ]
      }
    ], 
    "publisher": {
      "name": "Springer Nature", 
      "type": "Organisation"
    }, 
    "sameAs": [
      "https://doi.org/10.1007/bfb0049131", 
      "https://app.dimensions.ai/details/publication/pub.1045525810"
    ], 
    "sdDataset": "chapters", 
    "sdDatePublished": "2022-11-24T21:17", 
    "sdLicense": "https://scigraph.springernature.com/explorer/license/", 
    "sdPublisher": {
      "name": "Springer Nature - SN SciGraph project", 
      "type": "Organization"
    }, 
    "sdSource": "s3://com-springernature-scigraph/baseset/20221124/entities/gbq_results/chapter/chapter_372.jsonl", 
    "type": "Chapter", 
    "url": "https://doi.org/10.1007/bfb0049131"
  }
]
 

Download the RDF metadata as:  json-ld nt turtle xml License info

HOW TO GET THIS DATA PROGRAMMATICALLY:

JSON-LD is a popular format for linked data which is fully compatible with JSON.

curl -H 'Accept: application/ld+json' 'https://scigraph.springernature.com/pub.10.1007/bfb0049131'

N-Triples is a line-based linked data format ideal for batch operations.

curl -H 'Accept: application/n-triples' 'https://scigraph.springernature.com/pub.10.1007/bfb0049131'

Turtle is a human-readable linked data format.

curl -H 'Accept: text/turtle' 'https://scigraph.springernature.com/pub.10.1007/bfb0049131'

RDF/XML is a standard XML format for linked data.

curl -H 'Accept: application/rdf+xml' 'https://scigraph.springernature.com/pub.10.1007/bfb0049131'


 

This table displays all metadata directly associated to this object as RDF triples.

113 TRIPLES      22 PREDICATES      61 URIs      54 LITERALS      7 BLANK NODES

Subject Predicate Object
1 sg:pub.10.1007/bfb0049131 schema:about anzsrc-for:08
2 anzsrc-for:0806
3 schema:author N812cd31e82b84f10b8cbcb5062e33c32
4 schema:datePublished 1995
5 schema:datePublishedReg 1995-01-01
6 schema:description 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.
7 schema:editor N9097c6f260004a568c3df209502ef3a3
8 schema:genre chapter
9 schema:isAccessibleForFree true
10 schema:isPartOf Nf22b29c6b04e430eb3c025f375f2c290
11 schema:keywords Derived Relations
12 SQL extension
13 approach
14 chain
15 concise formulation
16 cost
17 dBm
18 data
19 data organization
20 database scheme
21 definition
22 different relations
23 dynamic definition
24 extension
25 formulation
26 global cost
27 independence
28 join
29 language sentences
30 logical data organization
31 means
32 number
33 number of joins
34 order
35 organization
36 perspective
37 queries
38 query formulation
39 reference
40 relation
41 relational DBMS
42 scheme
43 sentences
44 user's viewpoint
45 viewpoint
46 work
47 schema:name An SQL extension supporting user viewpoints
48 schema:pagination 334-343
49 schema:productId N029e8900b49145e7b561ec90a442eda5
50 Nbea184c92d224fcd98fbc0d12ae441b4
51 schema:publisher N4f3c8a77196447df9813aaee18b70245
52 schema:sameAs https://app.dimensions.ai/details/publication/pub.1045525810
53 https://doi.org/10.1007/bfb0049131
54 schema:sdDatePublished 2022-11-24T21:17
55 schema:sdLicense https://scigraph.springernature.com/explorer/license/
56 schema:sdPublisher N246f79c896314903bf4cc2ee0c9a2355
57 schema:url https://doi.org/10.1007/bfb0049131
58 sgo:license sg:explorer/license/
59 sgo:sdDataset chapters
60 rdf:type schema:Chapter
61 N029e8900b49145e7b561ec90a442eda5 schema:name dimensions_id
62 schema:value pub.1045525810
63 rdf:type schema:PropertyValue
64 N246f79c896314903bf4cc2ee0c9a2355 schema:name Springer Nature - SN SciGraph project
65 rdf:type schema:Organization
66 N2f8c85e273b14117aebcd17e361eea26 rdf:first Na9e8f25909304273bca1e92a58c754fa
67 rdf:rest rdf:nil
68 N4f3c8a77196447df9813aaee18b70245 schema:name Springer Nature
69 rdf:type schema:Organisation
70 N812cd31e82b84f10b8cbcb5062e33c32 rdf:first Nac86d4ccafc74e1fab2ddcd451996d49
71 rdf:rest Ncc11674b4b1448f7b636dffdd83ae4ba
72 N9097c6f260004a568c3df209502ef3a3 rdf:first Ne00d51970f1f44658296584d2606864c
73 rdf:rest N2f8c85e273b14117aebcd17e361eea26
74 Na9e8f25909304273bca1e92a58c754fa schema:familyName Tjoa
75 schema:givenName A Min
76 rdf:type schema:Person
77 Nac86d4ccafc74e1fab2ddcd451996d49 schema:affiliation grid-institutes:grid.6292.f
78 schema:familyName Bellavia
79 schema:givenName Giuseppe
80 rdf:type schema:Person
81 Nbea184c92d224fcd98fbc0d12ae441b4 schema:name doi
82 schema:value 10.1007/bfb0049131
83 rdf:type schema:PropertyValue
84 Nc0b95d8048d54322bf07b0ac58be55d9 rdf:first sg:person.012370122532.25
85 rdf:rest rdf:nil
86 Ncc11674b4b1448f7b636dffdd83ae4ba rdf:first sg:person.013075040365.65
87 rdf:rest Nc0b95d8048d54322bf07b0ac58be55d9
88 Ne00d51970f1f44658296584d2606864c schema:familyName Revell
89 schema:givenName Norman
90 rdf:type schema:Person
91 Nf22b29c6b04e430eb3c025f375f2c290 schema:isbn 978-3-540-44790-0
92 978-3-540-60303-0
93 schema:name Database and Expert Systems Applications
94 rdf:type schema:Book
95 anzsrc-for:08 schema:inDefinedTermSet anzsrc-for:
96 schema:name Information and Computing Sciences
97 rdf:type schema:DefinedTerm
98 anzsrc-for:0806 schema:inDefinedTermSet anzsrc-for:
99 schema:name Information Systems
100 rdf:type schema:DefinedTerm
101 sg:person.012370122532.25 schema:affiliation grid-institutes:grid.6292.f
102 schema:familyName Rizzi
103 schema:givenName Stefano
104 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.012370122532.25
105 rdf:type schema:Person
106 sg:person.013075040365.65 schema:affiliation grid-institutes:grid.6292.f
107 schema:familyName Maio
108 schema:givenName Dario
109 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.013075040365.65
110 rdf:type schema:Person
111 grid-institutes:grid.6292.f schema:alternateName DEIS-Facolta' di Ingegneria, Universita' di Bologna, Italia
112 schema:name DEIS-Facolta' di Ingegneria, Universita' di Bologna, Italia
113 rdf:type schema:Organization
 




Preview window. Press ESC to close (or click here)


...