Understanding the Semantic SQL Transducer

1. Abgrall, T.: Formalization of data integration transformations. In: Chiusano, S., et al. (eds.) ADBIS 2022. CCIS, vol. 1652, pp. 615–622. Springer, Cham (2022). https://doi.org/10.1007/978-3-031-15743-1_56

   Chapter  Google Scholar 

2. Abgrall, T.: Schema decomposition via transformation patterns (2024, submitted)

   Google Scholar 

3. Abgrall, T., Franconi, E., Pedot, N.: Enhancing data management and value creation through a knowledge-centric data stack (2024, submitted)

   Google Scholar 

4. Andersson, M.: Extracting an entity relationship schema from a relational database through reverse engineering. In: Loucopoulos, P. (ed.) ER 1994. LNCS, vol. 881, pp. 403–419. Springer, Heidelberg (1994). https://doi.org/10.1007/3-540-58786-1_93

   Chapter  Google Scholar 

5. Astrova, I.: Reverse engineering of relational databases to ontologies. In: Bussler, C.J., Davies, J., Fensel, D., Studer, R. (eds.) ESWS 2004. LNCS, vol. 3053, pp. 327–341. Springer, Heidelberg (2004). https://doi.org/10.1007/978-3-540-25956-5_23

   Chapter  Google Scholar 

6. Borgida, A., Toman, D., Weddell, G.: On referring expressions in information systems derived from conceptual modelling. In: Comyn-Wattiau, I., Tanaka, K., Song, I.-Y., Yamamoto, S., Saeki, M. (eds.) ER 2016. LNCS, vol. 9974, pp. 183–197. Springer, Cham (2016). https://doi.org/10.1007/978-3-319-46397-1_14

   Chapter  Google Scholar 

7. Calvanese, D., Franconi, E.: First-order ontology mediated database querying via query reformulation. In: Flesca, S., Greco, S., Masciari, E., Saccà, D. (eds.) A Comprehensive Guide Through the Italian Database Research Over the Last 25 Years. SBD, vol. 31, pp. 169–185. Springer, Cham (2018). https://doi.org/10.1007/978-3-319-61893-7_10

   Chapter  Google Scholar 

8. Chiang, R.H., Barron, T.M., Storey, V.C.: Reverse engineering of relational databases: extraction of an EER model from a relational database. Data Knowl. Eng. 12(2), 107–142 (1994)

   Article  Google Scholar 

9. Franconi, E., Sattler, U.: A data warehouse conceptual data model for multidimensional aggregation. In: International Workshop on Design and Management of Data Warehouses, DMDW 1999 (1999)

   Google Scholar 

10. Franconi, E., Tessaris, S.: On the logic of SQL nulls. In: 6th Alberto Mendelzon International Workshop on Foundations of Data Management, pp. 114–128. CEUR Workshop Proceedings (2012)

    Google Scholar 

11. Franconi, E., Tessaris, S.: Relational algebra and calculus with SQL null values. CoRR abs/2202.10898 (2022)

    Google Scholar 

12. Hainaut, J.L., Chandelon, M., Tonneau, C., Joris, M.: Contribution to a theory of database reverse engineering. In: 1993 Proceedings Working Conference on Reverse Engineering, pp. 161–170. IEEE (1993)

    Google Scholar 

13. Hainaut, J.L.: Introduction to Database Reverse Engineering. LIBD Lecture Notes (2002)

    Google Scholar 

14. Hainaut, J.-L., Tonneau, C., Joris, M., Chandelon, M.: Schema transformation techniques for database reverse engineering. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds.) 12th International Conference on the Entity-Relationship Approach. ER 1993. LNCS, vol. 823, pp. 364–375. Springer, Heidelberg (1993). https://doi.org/10.1007/BFb0024380

15. Hull, R.: Relative information capacity of simple relational database schemata. SIAM J. Comput. 15(3), 856–886 (1986)

    Article  MathSciNet  Google Scholar 

16. Kobayashi, I.: Losslessness and semantic correctness of database schema transformation: another look of schema equivalence. Inf. Syst. 11(1), 41–59 (1986)

    Article  Google Scholar 

17. Lammari, N., Comyn-Wattiau, I., Akoka, J.: Extracting generalization hierarchies from relational databases: a reverse engineering approach. Data Knowl. Eng. 63(2), 568–589 (2007)

    Article  Google Scholar 

18. Lubyte, L., Tessaris, S.: Automatic extraction of ontologies wrapping relational data sources. In: Bhowmick, S.S., Küng, J., Wagner, R. (eds.) DEXA 2009. LNCS, vol. 5690, pp. 128–142. Springer, Heidelberg (2009). https://doi.org/10.1007/978-3-642-03573-9_10

    Chapter  Google Scholar 

19. Ma, W., Keet, C.M., Oldford, W., Toman, D., Weddell, G.: The utility of the abstract relational model and attribute paths in SQL. In: Faron Zucker, C., Ghidini, C., Napoli, A., Toussaint, Y. (eds.) EKAW 2018. LNCS (LNAI), vol. 11313, pp. 195–211. Springer, Cham (2018). https://doi.org/10.1007/978-3-030-03667-6_13

    Chapter  Google Scholar 

20. McBrien, P., Poulovassilis, A.: Data integration by bi-directional schema transformation rules. In: Proceedings 19th International Conference on Data Engineering (ICDE-03), pp. 227–238 (2003)

    Google Scholar 

21. Mian, N.A., Khan, S.A., Zafar, N.A.: Database reverse engineering methods: what is missing? Res. J. Recent Sci. 2(5), 49–58 (2013)

    Google Scholar 

22. Miller, R.J., Ioannidis, Y.E., Ramakrishnan, R.: The use of information capacity in schema integration and translation. In: 19th International Conference on Very Large Data Bases (VLDB-1993), pp. 120–133 (1993)

    Google Scholar 

23. Ndefo, N., Franconi, E.: On preserving information in schema transformations: a constructive perspective. In: 2nd IEEE International Conference on Artificial Intelligence and Knowledge Engineering, AIKE 2019, pp. 57–64 (2019)

    Google Scholar 

24. Ndefo, N., Franconi, E.: A study on information-preserving schema transformations. Int. J. Semant. Comput. 14(1), 27–53 (2020)

    Article  Google Scholar 

25. Poulovassilis, A., McBrien, P.: A general formal framework for schema transformation. Data Knowl. Eng. 28(1), 47–71 (1998)

    Article  Google Scholar 

26. Qian, X.: Correct schema transformations. In: Apers, P., Bouzeghoub, M., Gardarin, G. (eds.) EDBT 1996. LNCS, vol. 1057, pp. 114–128. Springer, Heidelberg (1996). https://doi.org/10.1007/BFb0014146

    Chapter  Google Scholar 

27. Soutou, C.: Relational database reverse engineering: algorithms to extract cardinality constraints. Data Knowl. Eng. 28(2), 161–207 (1998)

    Article  Google Scholar 

Download references