A data retrieval model based on independence rules for SuperSQL

Arnaud Wolf, Ria Mae Borromeo, Motomichi Toyama

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

SuperSQL is an extension of SQL that automatically formats data retrieved from the database into various kinds of application data (HTML, PDF...). Current developments lead us to identify improvement points and remodel the design of the SuperSQL architecture. Among them, in the current SuperSQL version, the emptiness of one single relation leads to the emptiness of the entire table forming the output data. This is because the process handling the retrieval of desired data does not consider the schema representation of the data and thus does not identify independence between data lists. In this paper, we propose a new process of data retrieval based on a three layers model: the definition layer, the equivalence layer and the optimisation layer. As a result, our proposed architecture is able to manage empty sets and allows easier integration to support future developments.

Original languageEnglish
Title of host publicationACM International Conference Proceeding Series
PublisherAssociation for Computing Machinery
Pages208-209
Number of pages2
EditionCONFCODENUMBER
DOIs
Publication statusPublished - 2015 Jul 13
Event19th International Database Engineering and Applications Symposium, IDEAS 2015 - Yokohama, Japan
Duration: 2015 Jul 132015 Jul 15

Other

Other19th International Database Engineering and Applications Symposium, IDEAS 2015
CountryJapan
CityYokohama
Period15/7/1315/7/15

Fingerprint

HTML

Keywords

  • Algorithm
  • Data retrieval & query optimization
  • SuperSQL

ASJC Scopus subject areas

  • Human-Computer Interaction
  • Computer Networks and Communications
  • Computer Vision and Pattern Recognition
  • Software

Cite this

Wolf, A., Borromeo, R. M., & Toyama, M. (2015). A data retrieval model based on independence rules for SuperSQL. In ACM International Conference Proceeding Series (CONFCODENUMBER ed., pp. 208-209). [2790782] Association for Computing Machinery. https://doi.org/10.1145/2790755.2790782

A data retrieval model based on independence rules for SuperSQL. / Wolf, Arnaud; Borromeo, Ria Mae; Toyama, Motomichi.

ACM International Conference Proceeding Series. CONFCODENUMBER. ed. Association for Computing Machinery, 2015. p. 208-209 2790782.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Wolf, A, Borromeo, RM & Toyama, M 2015, A data retrieval model based on independence rules for SuperSQL. in ACM International Conference Proceeding Series. CONFCODENUMBER edn, 2790782, Association for Computing Machinery, pp. 208-209, 19th International Database Engineering and Applications Symposium, IDEAS 2015, Yokohama, Japan, 15/7/13. https://doi.org/10.1145/2790755.2790782
Wolf A, Borromeo RM, Toyama M. A data retrieval model based on independence rules for SuperSQL. In ACM International Conference Proceeding Series. CONFCODENUMBER ed. Association for Computing Machinery. 2015. p. 208-209. 2790782 https://doi.org/10.1145/2790755.2790782
Wolf, Arnaud ; Borromeo, Ria Mae ; Toyama, Motomichi. / A data retrieval model based on independence rules for SuperSQL. ACM International Conference Proceeding Series. CONFCODENUMBER. ed. Association for Computing Machinery, 2015. pp. 208-209
@inproceedings{e21847eafee247d2bf0092eec52568c5,
title = "A data retrieval model based on independence rules for SuperSQL",
abstract = "SuperSQL is an extension of SQL that automatically formats data retrieved from the database into various kinds of application data (HTML, PDF...). Current developments lead us to identify improvement points and remodel the design of the SuperSQL architecture. Among them, in the current SuperSQL version, the emptiness of one single relation leads to the emptiness of the entire table forming the output data. This is because the process handling the retrieval of desired data does not consider the schema representation of the data and thus does not identify independence between data lists. In this paper, we propose a new process of data retrieval based on a three layers model: the definition layer, the equivalence layer and the optimisation layer. As a result, our proposed architecture is able to manage empty sets and allows easier integration to support future developments.",
keywords = "Algorithm, Data retrieval & query optimization, SuperSQL",
author = "Arnaud Wolf and Borromeo, {Ria Mae} and Motomichi Toyama",
year = "2015",
month = "7",
day = "13",
doi = "10.1145/2790755.2790782",
language = "English",
pages = "208--209",
booktitle = "ACM International Conference Proceeding Series",
publisher = "Association for Computing Machinery",
edition = "CONFCODENUMBER",

}

TY - GEN

T1 - A data retrieval model based on independence rules for SuperSQL

AU - Wolf, Arnaud

AU - Borromeo, Ria Mae

AU - Toyama, Motomichi

PY - 2015/7/13

Y1 - 2015/7/13

N2 - SuperSQL is an extension of SQL that automatically formats data retrieved from the database into various kinds of application data (HTML, PDF...). Current developments lead us to identify improvement points and remodel the design of the SuperSQL architecture. Among them, in the current SuperSQL version, the emptiness of one single relation leads to the emptiness of the entire table forming the output data. This is because the process handling the retrieval of desired data does not consider the schema representation of the data and thus does not identify independence between data lists. In this paper, we propose a new process of data retrieval based on a three layers model: the definition layer, the equivalence layer and the optimisation layer. As a result, our proposed architecture is able to manage empty sets and allows easier integration to support future developments.

AB - SuperSQL is an extension of SQL that automatically formats data retrieved from the database into various kinds of application data (HTML, PDF...). Current developments lead us to identify improvement points and remodel the design of the SuperSQL architecture. Among them, in the current SuperSQL version, the emptiness of one single relation leads to the emptiness of the entire table forming the output data. This is because the process handling the retrieval of desired data does not consider the schema representation of the data and thus does not identify independence between data lists. In this paper, we propose a new process of data retrieval based on a three layers model: the definition layer, the equivalence layer and the optimisation layer. As a result, our proposed architecture is able to manage empty sets and allows easier integration to support future developments.

KW - Algorithm

KW - Data retrieval & query optimization

KW - SuperSQL

UR - http://www.scopus.com/inward/record.url?scp=85007495427&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85007495427&partnerID=8YFLogxK

U2 - 10.1145/2790755.2790782

DO - 10.1145/2790755.2790782

M3 - Conference contribution

SP - 208

EP - 209

BT - ACM International Conference Proceeding Series

PB - Association for Computing Machinery

ER -