Designing Semistructured Databases: A Conceptual Approach View Full Text


Ontology type: schema:Chapter     


Chapter Info

DATE

2001-08-28

AUTHORS

Mong Li Lee , Sin Yeung Lee , Tok Wang Ling , Gillian Dobbie , Leonid A. Kalinichenko

ABSTRACT

Semistructured data has become prevalent with the growth of the Internet. The data is usually stored in a database system or in a specialized repository. Many information providers have presented their databases on the web as semistructured data, while others are developing repositories for new applications. Designing a “good” semistructured database is important to prevent data redundancy and updating anomalies. In this paper, we propose a conceptual approach to design semistructured databases. A conceptual layer based on the Entity-Relationship model is used to remove redundancies at the semantic level. An algorithm to map an ER diagram involving composite attributes weak entity types, recursive, n-ary and ISA relationship sets, and aggregations to a semistructured schema graph (S3-Graph) is also given. More... »

PAGES

12-21

Identifiers

URI

http://scigraph.springernature.com/pub.10.1007/3-540-44759-8_3

DOI

http://dx.doi.org/10.1007/3-540-44759-8_3

DIMENSIONS

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


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": "School of Computing, National University of Singapore, Singapore", 
          "id": "http://www.grid.ac/institutes/grid.4280.e", 
          "name": [
            "School of Computing, National University of Singapore, Singapore"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Li Lee", 
        "givenName": "Mong", 
        "type": "Person"
      }, 
      {
        "affiliation": {
          "alternateName": "School of Computing, National University of Singapore, Singapore", 
          "id": "http://www.grid.ac/institutes/grid.4280.e", 
          "name": [
            "School of Computing, National University of Singapore, Singapore"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Yeung Lee", 
        "givenName": "Sin", 
        "type": "Person"
      }, 
      {
        "affiliation": {
          "alternateName": "School of Computing, National University of Singapore, Singapore", 
          "id": "http://www.grid.ac/institutes/grid.4280.e", 
          "name": [
            "School of Computing, National University of Singapore, Singapore"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Wang Ling", 
        "givenName": "Tok", 
        "type": "Person"
      }, 
      {
        "affiliation": {
          "alternateName": "Dept of Computer Science, University of Auckland, New Zealand", 
          "id": "http://www.grid.ac/institutes/grid.9654.e", 
          "name": [
            "Dept of Computer Science, University of Auckland, New Zealand"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Dobbie", 
        "givenName": "Gillian", 
        "id": "sg:person.011441415101.99", 
        "sameAs": [
          "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.011441415101.99"
        ], 
        "type": "Person"
      }, 
      {
        "affiliation": {
          "alternateName": "Russian Academy of Sciences, Institute for Problems of Informatics, Russia", 
          "id": "http://www.grid.ac/institutes/grid.4886.2", 
          "name": [
            "Russian Academy of Sciences, Institute for Problems of Informatics, Russia"
          ], 
          "type": "Organization"
        }, 
        "familyName": "Kalinichenko", 
        "givenName": "Leonid A.", 
        "id": "sg:person.016144507043.63", 
        "sameAs": [
          "https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.016144507043.63"
        ], 
        "type": "Person"
      }
    ], 
    "datePublished": "2001-08-28", 
    "datePublishedReg": "2001-08-28", 
    "description": "Semistructured data has become prevalent with the growth of the Internet. The data is usually stored in a database system or in a specialized repository. Many information providers have presented their databases on the web as semistructured data, while others are developing repositories for new applications. Designing a \u201cgood\u201d semistructured database is important to prevent data redundancy and updating anomalies. In this paper, we propose a conceptual approach to design semistructured databases. A conceptual layer based on the Entity-Relationship model is used to remove redundancies at the semantic level. An algorithm to map an ER diagram involving composite attributes weak entity types, recursive, n-ary and ISA relationship sets, and aggregations to a semistructured schema graph (S3-Graph) is also given.", 
    "editor": [
      {
        "familyName": "Mayr", 
        "givenName": "Heinrich C.", 
        "type": "Person"
      }, 
      {
        "familyName": "Lazansky", 
        "givenName": "Jiri", 
        "type": "Person"
      }, 
      {
        "familyName": "Quirchmayr", 
        "givenName": "Gerald", 
        "type": "Person"
      }, 
      {
        "familyName": "Vogel", 
        "givenName": "Pavel", 
        "type": "Person"
      }
    ], 
    "genre": "chapter", 
    "id": "sg:pub.10.1007/3-540-44759-8_3", 
    "inLanguage": "en", 
    "isAccessibleForFree": false, 
    "isPartOf": {
      "isbn": [
        "978-3-540-42527-4", 
        "978-3-540-44759-7"
      ], 
      "name": "Database and Expert Systems Applications", 
      "type": "Book"
    }, 
    "keywords": [
      "entity-relationship model", 
      "Semistructured Databases", 
      "schema graph", 
      "database systems", 
      "data redundancy", 
      "conceptual layer", 
      "ER diagrams", 
      "entity types", 
      "ISA relationships", 
      "semantic level", 
      "information providers", 
      "specialized repositories", 
      "repository", 
      "new applications", 
      "redundancy", 
      "database", 
      "conceptual approach", 
      "Internet", 
      "algorithm", 
      "Web", 
      "graph", 
      "providers", 
      "data", 
      "applications", 
      "system", 
      "ary", 
      "model", 
      "diagram", 
      "aggregation", 
      "layer", 
      "types", 
      "anomalies", 
      "relationship", 
      "levels", 
      "growth", 
      "approach", 
      "paper"
    ], 
    "name": "Designing Semistructured Databases: A Conceptual Approach", 
    "pagination": "12-21", 
    "productId": [
      {
        "name": "dimensions_id", 
        "type": "PropertyValue", 
        "value": [
          "pub.1010046668"
        ]
      }, 
      {
        "name": "doi", 
        "type": "PropertyValue", 
        "value": [
          "10.1007/3-540-44759-8_3"
        ]
      }
    ], 
    "publisher": {
      "name": "Springer Nature", 
      "type": "Organisation"
    }, 
    "sameAs": [
      "https://doi.org/10.1007/3-540-44759-8_3", 
      "https://app.dimensions.ai/details/publication/pub.1010046668"
    ], 
    "sdDataset": "chapters", 
    "sdDatePublished": "2022-05-20T07:45", 
    "sdLicense": "https://scigraph.springernature.com/explorer/license/", 
    "sdPublisher": {
      "name": "Springer Nature - SN SciGraph project", 
      "type": "Organization"
    }, 
    "sdSource": "s3://com-springernature-scigraph/baseset/20220519/entities/gbq_results/chapter/chapter_287.jsonl", 
    "type": "Chapter", 
    "url": "https://doi.org/10.1007/3-540-44759-8_3"
  }
]
 

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/3-540-44759-8_3'

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/3-540-44759-8_3'

Turtle is a human-readable linked data format.

curl -H 'Accept: text/turtle' 'https://scigraph.springernature.com/pub.10.1007/3-540-44759-8_3'

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

curl -H 'Accept: application/rdf+xml' 'https://scigraph.springernature.com/pub.10.1007/3-540-44759-8_3'


 

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

143 TRIPLES      23 PREDICATES      62 URIs      55 LITERALS      7 BLANK NODES

Subject Predicate Object
1 sg:pub.10.1007/3-540-44759-8_3 schema:about anzsrc-for:08
2 anzsrc-for:0806
3 schema:author Nc424e4e5d5bd4531a01d87e23a6fd4d0
4 schema:datePublished 2001-08-28
5 schema:datePublishedReg 2001-08-28
6 schema:description Semistructured data has become prevalent with the growth of the Internet. The data is usually stored in a database system or in a specialized repository. Many information providers have presented their databases on the web as semistructured data, while others are developing repositories for new applications. Designing a “good” semistructured database is important to prevent data redundancy and updating anomalies. In this paper, we propose a conceptual approach to design semistructured databases. A conceptual layer based on the Entity-Relationship model is used to remove redundancies at the semantic level. An algorithm to map an ER diagram involving composite attributes weak entity types, recursive, n-ary and ISA relationship sets, and aggregations to a semistructured schema graph (S3-Graph) is also given.
7 schema:editor Na839bf16d9a94f9783ece4d84f3a637e
8 schema:genre chapter
9 schema:inLanguage en
10 schema:isAccessibleForFree false
11 schema:isPartOf Na3bc4e279cf14f80a0c78fc6c8cee4f3
12 schema:keywords ER diagrams
13 ISA relationships
14 Internet
15 Semistructured Databases
16 Web
17 aggregation
18 algorithm
19 anomalies
20 applications
21 approach
22 ary
23 conceptual approach
24 conceptual layer
25 data
26 data redundancy
27 database
28 database systems
29 diagram
30 entity types
31 entity-relationship model
32 graph
33 growth
34 information providers
35 layer
36 levels
37 model
38 new applications
39 paper
40 providers
41 redundancy
42 relationship
43 repository
44 schema graph
45 semantic level
46 specialized repositories
47 system
48 types
49 schema:name Designing Semistructured Databases: A Conceptual Approach
50 schema:pagination 12-21
51 schema:productId N31618cfa1a8b44d199c0b595ba5874c4
52 Ne9c3be7975b3438c8b1520c13a8224df
53 schema:publisher N2560b93adadb480080a1378c3a1ba28d
54 schema:sameAs https://app.dimensions.ai/details/publication/pub.1010046668
55 https://doi.org/10.1007/3-540-44759-8_3
56 schema:sdDatePublished 2022-05-20T07:45
57 schema:sdLicense https://scigraph.springernature.com/explorer/license/
58 schema:sdPublisher N0178b9dbdf244f4ea51039ee18e2b2ff
59 schema:url https://doi.org/10.1007/3-540-44759-8_3
60 sgo:license sg:explorer/license/
61 sgo:sdDataset chapters
62 rdf:type schema:Chapter
63 N0178b9dbdf244f4ea51039ee18e2b2ff schema:name Springer Nature - SN SciGraph project
64 rdf:type schema:Organization
65 N23b653dfd6d64200bf3df8002e2d6bc7 schema:familyName Vogel
66 schema:givenName Pavel
67 rdf:type schema:Person
68 N2560b93adadb480080a1378c3a1ba28d schema:name Springer Nature
69 rdf:type schema:Organisation
70 N31618cfa1a8b44d199c0b595ba5874c4 schema:name doi
71 schema:value 10.1007/3-540-44759-8_3
72 rdf:type schema:PropertyValue
73 N39c8a412b4a04917ac4abb0c13abaf95 schema:familyName Mayr
74 schema:givenName Heinrich C.
75 rdf:type schema:Person
76 N3a28b15676894f7aa58e5c6697b55674 rdf:first N70648a46d2884f039fa2345231d57d52
77 rdf:rest Nf8c8ba4b573647d2a101370a471d9e6b
78 N590edf0b7e164b489da9b6f8c0c7e3ea schema:familyName Lazansky
79 schema:givenName Jiri
80 rdf:type schema:Person
81 N70648a46d2884f039fa2345231d57d52 schema:affiliation grid-institutes:grid.4280.e
82 schema:familyName Yeung Lee
83 schema:givenName Sin
84 rdf:type schema:Person
85 N7bbd92f9c0544048ad56d133dd254095 rdf:first sg:person.011441415101.99
86 rdf:rest Ne82516ce10514d92812bbe3c1c3701d8
87 Na3bc4e279cf14f80a0c78fc6c8cee4f3 schema:isbn 978-3-540-42527-4
88 978-3-540-44759-7
89 schema:name Database and Expert Systems Applications
90 rdf:type schema:Book
91 Na55b14b94280456ea15d4dbfd4c16210 rdf:first N590edf0b7e164b489da9b6f8c0c7e3ea
92 rdf:rest Ncc0773c5710a45a08ec421b396148bef
93 Na839bf16d9a94f9783ece4d84f3a637e rdf:first N39c8a412b4a04917ac4abb0c13abaf95
94 rdf:rest Na55b14b94280456ea15d4dbfd4c16210
95 Nb4763b17947b461e938c5c354e1cfa81 schema:affiliation grid-institutes:grid.4280.e
96 schema:familyName Wang Ling
97 schema:givenName Tok
98 rdf:type schema:Person
99 Nc424e4e5d5bd4531a01d87e23a6fd4d0 rdf:first Ne9968d801dc44352b47ab50b0596ec7e
100 rdf:rest N3a28b15676894f7aa58e5c6697b55674
101 Nc6dea9fa714b4c7ea315c8798eaa5ce5 schema:familyName Quirchmayr
102 schema:givenName Gerald
103 rdf:type schema:Person
104 Ncc0773c5710a45a08ec421b396148bef rdf:first Nc6dea9fa714b4c7ea315c8798eaa5ce5
105 rdf:rest Ne97c5ed704bc4d6b94572adc0da5dfae
106 Ne82516ce10514d92812bbe3c1c3701d8 rdf:first sg:person.016144507043.63
107 rdf:rest rdf:nil
108 Ne97c5ed704bc4d6b94572adc0da5dfae rdf:first N23b653dfd6d64200bf3df8002e2d6bc7
109 rdf:rest rdf:nil
110 Ne9968d801dc44352b47ab50b0596ec7e schema:affiliation grid-institutes:grid.4280.e
111 schema:familyName Li Lee
112 schema:givenName Mong
113 rdf:type schema:Person
114 Ne9c3be7975b3438c8b1520c13a8224df schema:name dimensions_id
115 schema:value pub.1010046668
116 rdf:type schema:PropertyValue
117 Nf8c8ba4b573647d2a101370a471d9e6b rdf:first Nb4763b17947b461e938c5c354e1cfa81
118 rdf:rest N7bbd92f9c0544048ad56d133dd254095
119 anzsrc-for:08 schema:inDefinedTermSet anzsrc-for:
120 schema:name Information and Computing Sciences
121 rdf:type schema:DefinedTerm
122 anzsrc-for:0806 schema:inDefinedTermSet anzsrc-for:
123 schema:name Information Systems
124 rdf:type schema:DefinedTerm
125 sg:person.011441415101.99 schema:affiliation grid-institutes:grid.9654.e
126 schema:familyName Dobbie
127 schema:givenName Gillian
128 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.011441415101.99
129 rdf:type schema:Person
130 sg:person.016144507043.63 schema:affiliation grid-institutes:grid.4886.2
131 schema:familyName Kalinichenko
132 schema:givenName Leonid A.
133 schema:sameAs https://app.dimensions.ai/discover/publication?and_facet_researcher=ur.016144507043.63
134 rdf:type schema:Person
135 grid-institutes:grid.4280.e schema:alternateName School of Computing, National University of Singapore, Singapore
136 schema:name School of Computing, National University of Singapore, Singapore
137 rdf:type schema:Organization
138 grid-institutes:grid.4886.2 schema:alternateName Russian Academy of Sciences, Institute for Problems of Informatics, Russia
139 schema:name Russian Academy of Sciences, Institute for Problems of Informatics, Russia
140 rdf:type schema:Organization
141 grid-institutes:grid.9654.e schema:alternateName Dept of Computer Science, University of Auckland, New Zealand
142 schema:name Dept of Computer Science, University of Auckland, New Zealand
143 rdf:type schema:Organization
 




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


...