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 language | English |
|---|---|
| Title of host publication | ACM International Conference Proceeding Series |
| Publisher | Association for Computing Machinery |
| Pages | 208-209 |
| Number of pages | 2 |
| Edition | CONFCODENUMBER |
| DOIs | |
| Publication status | Published - 2015 Jul 13 |
| Event | 19th International Database Engineering and Applications Symposium, IDEAS 2015 - Yokohama, Japan Duration: 2015 Jul 13 → 2015 Jul 15 |
Other
| Other | 19th International Database Engineering and Applications Symposium, IDEAS 2015 |
|---|---|
| Country | Japan |
| City | Yokohama |
| Period | 15/7/13 → 15/7/15 |
Fingerprint
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
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 proceeding › Conference contribution
}
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
AN - SCOPUS:85007495427
SP - 208
EP - 209
BT - ACM International Conference Proceeding Series
PB - Association for Computing Machinery
ER -