The Utility of the Abstract Relational Model and Attribute Paths in SQL View Full Text


Ontology type: schema:Chapter     


Chapter Info

DATE

2018-10-31

AUTHORS

Weicong Ma , C. Maria Keet , Wayne Oldford , David Toman , Grant Weddell

ABSTRACT

It is well-known that querying information is difficult for domain experts, for they are not familiar with querying actual relational schemata due to the notions of primary and foreign keys and the various ways of representing and storing information in a relational database. To overcome these problems, the Abstract Relational Model and the query language, SQLP, have been proposed. They are the theoretical foundations and ensure that explicit primary and foreign keys are hidden from the user’s view and that queries can be expressed more compactly. In this paper we evaluate these theoretical advantages with user studies that compare SQLP to plain SQL as the baseline. The experiments show significant statistical evidence that SQLP indeed requires less time for understanding and authoring queries, with no loss in accuracy. Considering the positive results, we develop a method to reverse engineer legacy relational schemata into abstract relational ones. More... »

PAGES

195-211

Identifiers

URI

http://scigraph.springernature.com/pub.10.1007/978-3-030-03667-6_13

DOI

http://dx.doi.org/10.1007/978-3-030-03667-6_13

DIMENSIONS

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


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": "Cheriton School of Computer Science, University of Waterloo, Waterloo, Canada", 
          "id": "http://www.grid.ac/institutes/grid.46078.3d", 
          "name": [
            "Cheriton School of Computer Science, University of Waterloo, Waterloo, Canada"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Ma", 
        "givenName": "Weicong", 
        "type": "Person"
      }, 
      {
        "affiliation": {
          "alternateName": "Department of Computer Science, University of Cape Town, Cape Town, South Africa", 
          "id": "http://www.grid.ac/institutes/grid.7836.a", 
          "name": [
            "Department of Computer Science, University of Cape Town, Cape Town, South Africa"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Keet", 
        "givenName": "C. Maria", 
        "id": "sg:person.014507001556.98", 
        "sameAs": [
          "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.014507001556.98"
        ], 
        "type": "Person"
      }, 
      {
        "affiliation": {
          "alternateName": "Cheriton School of Computer Science, University of Waterloo, Waterloo, Canada", 
          "id": "http://www.grid.ac/institutes/grid.46078.3d", 
          "name": [
            "Cheriton School of Computer Science, University of Waterloo, Waterloo, Canada"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Oldford", 
        "givenName": "Wayne", 
        "id": "sg:person.01322616636.49", 
        "sameAs": [
          "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.01322616636.49"
        ], 
        "type": "Person"
      }, 
      {
        "affiliation": {
          "alternateName": "Cheriton School of Computer Science, University of Waterloo, Waterloo, Canada", 
          "id": "http://www.grid.ac/institutes/grid.46078.3d", 
          "name": [
            "Cheriton School of Computer Science, University of Waterloo, Waterloo, Canada"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Toman", 
        "givenName": "David", 
        "id": "sg:person.011644611743.11", 
        "sameAs": [
          "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.011644611743.11"
        ], 
        "type": "Person"
      }, 
      {
        "affiliation": {
          "alternateName": "Cheriton School of Computer Science, University of Waterloo, Waterloo, Canada", 
          "id": "http://www.grid.ac/institutes/grid.46078.3d", 
          "name": [
            "Cheriton School of Computer Science, University of Waterloo, Waterloo, Canada"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Weddell", 
        "givenName": "Grant", 
        "id": "sg:person.01111756132.29", 
        "sameAs": [
          "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.01111756132.29"
        ], 
        "type": "Person"
      }
    ], 
    "datePublished": "2018-10-31", 
    "datePublishedReg": "2018-10-31", 
    "description": "It is well-known that querying information is difficult for domain experts, for they are not familiar with querying actual relational schemata due to the notions of primary and foreign keys and the various ways of representing and storing information in a relational database. To overcome these problems, the Abstract Relational Model and the query language, SQLP, have been proposed. They are the theoretical foundations and ensure that explicit primary and foreign keys are hidden from the user\u2019s view and that queries can be expressed more compactly. In this paper we evaluate these theoretical advantages with user studies that compare SQLP to plain SQL as the baseline. The experiments show significant statistical evidence that SQLP indeed requires less time for understanding and authoring queries, with no loss in accuracy. Considering the positive results, we develop a method to reverse engineer legacy relational schemata into abstract relational ones.", 
    "editor": [
      {
        "familyName": "Faron Zucker", 
        "givenName": "Catherine", 
        "type": "Person"
      }, 
      {
        "familyName": "Ghidini", 
        "givenName": "Chiara", 
        "type": "Person"
      }, 
      {
        "familyName": "Napoli", 
        "givenName": "Amedeo", 
        "type": "Person"
      }, 
      {
        "familyName": "Toussaint", 
        "givenName": "Yannick", 
        "type": "Person"
      }
    ], 
    "genre": "chapter", 
    "id": "sg:pub.10.1007/978-3-030-03667-6_13", 
    "inLanguage": "en", 
    "isAccessibleForFree": false, 
    "isPartOf": {
      "isbn": [
        "978-3-030-03666-9", 
        "978-3-030-03667-6"
      ], 
      "name": "Knowledge Engineering and Knowledge Management", 
      "type": "Book"
    }, 
    "keywords": [
      "Abstract Relational Model", 
      "foreign keys", 
      "relational schema", 
      "relational model", 
      "query language", 
      "relational database", 
      "domain experts", 
      "user study", 
      "user views", 
      "relational ones", 
      "SQL", 
      "queries", 
      "schema", 
      "theoretical foundation", 
      "SQLP", 
      "significant statistical evidence", 
      "less time", 
      "key", 
      "information", 
      "language", 
      "database", 
      "experts", 
      "accuracy", 
      "path", 
      "model", 
      "view", 
      "advantages", 
      "way", 
      "foundation", 
      "method", 
      "experiments", 
      "notion", 
      "one", 
      "utility", 
      "theoretical advantages", 
      "time", 
      "results", 
      "statistical evidence", 
      "positive results", 
      "understanding", 
      "loss", 
      "study", 
      "baseline", 
      "evidence", 
      "paper", 
      "problem", 
      "actual relational schemata", 
      "engineer legacy relational schemata", 
      "legacy relational schemata", 
      "abstract relational ones", 
      "Attribute Paths"
    ], 
    "name": "The Utility of the Abstract Relational Model and Attribute Paths in SQL", 
    "pagination": "195-211", 
    "productId": [
      {
        "name": "dimensions_id", 
        "type": "PropertyValue", 
        "value": [
          "pub.1107922943"
        ]
      }, 
      {
        "name": "doi", 
        "type": "PropertyValue", 
        "value": [
          "10.1007/978-3-030-03667-6_13"
        ]
      }
    ], 
    "publisher": {
      "name": "Springer Nature", 
      "type": "Organisation"
    }, 
    "sameAs": [
      "https://doi.org/10.1007/978-3-030-03667-6_13", 
      "https://app.dimensions.ai/details/publication/pub.1107922943"
    ], 
    "sdDataset": "chapters", 
    "sdDatePublished": "2021-12-01T20:03", 
    "sdLicense": "https://scigraph.springernature.com/explorer/license/", 
    "sdPublisher": {
      "name": "Springer Nature - SN SciGraph project", 
      "type": "Organization"
    }, 
    "sdSource": "s3://com-springernature-scigraph/baseset/20211201/entities/gbq_results/chapter/chapter_290.jsonl", 
    "type": "Chapter", 
    "url": "https://doi.org/10.1007/978-3-030-03667-6_13"
  }
]
 

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/978-3-030-03667-6_13'

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/978-3-030-03667-6_13'

Turtle is a human-readable linked data format.

curl -H 'Accept: text/turtle' 'https://scigraph.springernature.com/pub.10.1007/978-3-030-03667-6_13'

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

curl -H 'Accept: application/rdf+xml' 'https://scigraph.springernature.com/pub.10.1007/978-3-030-03667-6_13'


 

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

156 TRIPLES      23 PREDICATES      76 URIs      69 LITERALS      7 BLANK NODES

Subject Predicate Object
1 sg:pub.10.1007/978-3-030-03667-6_13 schema:about anzsrc-for:08
2 anzsrc-for:0806
3 schema:author Na366793012904732a45876751202a505
4 schema:datePublished 2018-10-31
5 schema:datePublishedReg 2018-10-31
6 schema:description It is well-known that querying information is difficult for domain experts, for they are not familiar with querying actual relational schemata due to the notions of primary and foreign keys and the various ways of representing and storing information in a relational database. To overcome these problems, the Abstract Relational Model and the query language, SQLP, have been proposed. They are the theoretical foundations and ensure that explicit primary and foreign keys are hidden from the user’s view and that queries can be expressed more compactly. In this paper we evaluate these theoretical advantages with user studies that compare SQLP to plain SQL as the baseline. The experiments show significant statistical evidence that SQLP indeed requires less time for understanding and authoring queries, with no loss in accuracy. Considering the positive results, we develop a method to reverse engineer legacy relational schemata into abstract relational ones.
7 schema:editor Nb5d45cedb25745209ee48ee1db972e31
8 schema:genre chapter
9 schema:inLanguage en
10 schema:isAccessibleForFree false
11 schema:isPartOf N06cb6ff6e3034918aeec7c7eec653831
12 schema:keywords Abstract Relational Model
13 Attribute Paths
14 SQL
15 SQLP
16 abstract relational ones
17 accuracy
18 actual relational schemata
19 advantages
20 baseline
21 database
22 domain experts
23 engineer legacy relational schemata
24 evidence
25 experiments
26 experts
27 foreign keys
28 foundation
29 information
30 key
31 language
32 legacy relational schemata
33 less time
34 loss
35 method
36 model
37 notion
38 one
39 paper
40 path
41 positive results
42 problem
43 queries
44 query language
45 relational database
46 relational model
47 relational ones
48 relational schema
49 results
50 schema
51 significant statistical evidence
52 statistical evidence
53 study
54 theoretical advantages
55 theoretical foundation
56 time
57 understanding
58 user study
59 user views
60 utility
61 view
62 way
63 schema:name The Utility of the Abstract Relational Model and Attribute Paths in SQL
64 schema:pagination 195-211
65 schema:productId Ne24bbf683d5d4d418cbe56421c2ce962
66 Ne481b93a8036459382cd006ed957a5e5
67 schema:publisher N83dbebf9572f4b1ea73e61b2a3005826
68 schema:sameAs https://app.dimensions.ai/details/publication/pub.1107922943
69 https://doi.org/10.1007/978-3-030-03667-6_13
70 schema:sdDatePublished 2021-12-01T20:03
71 schema:sdLicense https://scigraph.springernature.com/explorer/license/
72 schema:sdPublisher Nc5551de308a64b268c09a14955123319
73 schema:url https://doi.org/10.1007/978-3-030-03667-6_13
74 sgo:license sg:explorer/license/
75 sgo:sdDataset chapters
76 rdf:type schema:Chapter
77 N06cb6ff6e3034918aeec7c7eec653831 schema:isbn 978-3-030-03666-9
78 978-3-030-03667-6
79 schema:name Knowledge Engineering and Knowledge Management
80 rdf:type schema:Book
81 N093d465618f847b4ba6a085fdce37f31 rdf:first sg:person.01111756132.29
82 rdf:rest rdf:nil
83 N0a08ebeeb81d438cb24ab804f5af9d38 rdf:first Ne19f3ad8d49847efb7e3a81ce01fd463
84 rdf:rest Nf6a8013eac154d67af95b25295ec7c43
85 N19f12a3c235f4578ac6c248f7525ec15 rdf:first sg:person.01322616636.49
86 rdf:rest Nc30b572b3834461497a51113618377fd
87 N476ee6e08de54a6b8d1dbe543e47486f schema:familyName Faron Zucker
88 schema:givenName Catherine
89 rdf:type schema:Person
90 N72618cd580ee4d3b9d185cc5c2e3c52a rdf:first Ncb7d6ab9a0324c74a6cc658a59a74eed
91 rdf:rest rdf:nil
92 N83dbebf9572f4b1ea73e61b2a3005826 schema:name Springer Nature
93 rdf:type schema:Organisation
94 Na366793012904732a45876751202a505 rdf:first Nb71caa70ec4347e99dd55cb9265d9e0f
95 rdf:rest Nc243e59ac8d946e8b609ad645b8b286f
96 Nb5d45cedb25745209ee48ee1db972e31 rdf:first N476ee6e08de54a6b8d1dbe543e47486f
97 rdf:rest N0a08ebeeb81d438cb24ab804f5af9d38
98 Nb71caa70ec4347e99dd55cb9265d9e0f schema:affiliation grid-institutes:grid.46078.3d
99 schema:familyName Ma
100 schema:givenName Weicong
101 rdf:type schema:Person
102 Nc243e59ac8d946e8b609ad645b8b286f rdf:first sg:person.014507001556.98
103 rdf:rest N19f12a3c235f4578ac6c248f7525ec15
104 Nc30b572b3834461497a51113618377fd rdf:first sg:person.011644611743.11
105 rdf:rest N093d465618f847b4ba6a085fdce37f31
106 Nc5551de308a64b268c09a14955123319 schema:name Springer Nature - SN SciGraph project
107 rdf:type schema:Organization
108 Ncb7d6ab9a0324c74a6cc658a59a74eed schema:familyName Toussaint
109 schema:givenName Yannick
110 rdf:type schema:Person
111 Ne19f3ad8d49847efb7e3a81ce01fd463 schema:familyName Ghidini
112 schema:givenName Chiara
113 rdf:type schema:Person
114 Ne2371c2e6e8b4564b00a0f321d7367ac schema:familyName Napoli
115 schema:givenName Amedeo
116 rdf:type schema:Person
117 Ne24bbf683d5d4d418cbe56421c2ce962 schema:name dimensions_id
118 schema:value pub.1107922943
119 rdf:type schema:PropertyValue
120 Ne481b93a8036459382cd006ed957a5e5 schema:name doi
121 schema:value 10.1007/978-3-030-03667-6_13
122 rdf:type schema:PropertyValue
123 Nf6a8013eac154d67af95b25295ec7c43 rdf:first Ne2371c2e6e8b4564b00a0f321d7367ac
124 rdf:rest N72618cd580ee4d3b9d185cc5c2e3c52a
125 anzsrc-for:08 schema:inDefinedTermSet anzsrc-for:
126 schema:name Information and Computing Sciences
127 rdf:type schema:DefinedTerm
128 anzsrc-for:0806 schema:inDefinedTermSet anzsrc-for:
129 schema:name Information Systems
130 rdf:type schema:DefinedTerm
131 sg:person.01111756132.29 schema:affiliation grid-institutes:grid.46078.3d
132 schema:familyName Weddell
133 schema:givenName Grant
134 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.01111756132.29
135 rdf:type schema:Person
136 sg:person.011644611743.11 schema:affiliation grid-institutes:grid.46078.3d
137 schema:familyName Toman
138 schema:givenName David
139 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.011644611743.11
140 rdf:type schema:Person
141 sg:person.01322616636.49 schema:affiliation grid-institutes:grid.46078.3d
142 schema:familyName Oldford
143 schema:givenName Wayne
144 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.01322616636.49
145 rdf:type schema:Person
146 sg:person.014507001556.98 schema:affiliation grid-institutes:grid.7836.a
147 schema:familyName Keet
148 schema:givenName C. Maria
149 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.014507001556.98
150 rdf:type schema:Person
151 grid-institutes:grid.46078.3d schema:alternateName Cheriton School of Computer Science, University of Waterloo, Waterloo, Canada
152 schema:name Cheriton School of Computer Science, University of Waterloo, Waterloo, Canada
153 rdf:type schema:Organization
154 grid-institutes:grid.7836.a schema:alternateName Department of Computer Science, University of Cape Town, Cape Town, South Africa
155 schema:name Department of Computer Science, University of Cape Town, Cape Town, South Africa
156 rdf:type schema:Organization
 




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


...