Embedded functional dependencies and data-completeness tailored database design

Autor: Sebastian Link, Ziheng Wei

Publikováno v: Proceedings of the VLDB Endowment. 12:1458-1470

We establish a principled schema design framework for data with missing values. The framework is based on the new notion of an embedded functional dependency, which is independent of the interpretation of missing values, able to express completeness

Externí odkaz: https://explore.openaire.eu/search/publication?articleId=doi_dedup___::569169f0f07efb3b17d622ed4cd5da7f
https://doi.org/10.14778/3342263.3342626

SQL schema design: foundations, normal forms, and normalization

Autor: Sebastian Link, Henning Köhler

Publikováno v: SIGMOD Conference

Normalization helps us find a database schema at design time that can process the most frequent updates efficiently at run time. Unfortunately, relational normalization only works for idealized database instances in which duplicates and null markers

Externí odkaz: https://explore.openaire.eu/search/publication?articleId=doi_dedup___::e65bc5897545196a9dbce59d16c6b252
https://doi.org/10.1016/j.is.2018.04.001

Relational database schema design for uncertain data

Autor: Sebastian Link, Henri Prade

Publikováno v: CIKM
Information Systems
Information Systems, Elsevier, 2019, 84, pp.88-110. ⟨10.1016/j.is.2019.04.003⟩
CIKM '16: Proceedings of the 25th ACM International on Conference on Information and Knowledge Management ; ISBN : 978-1-4503-4073-1
25th ACM International Conference on Information and Knowledge Management (CIKM 2016)
25th ACM International Conference on Information and Knowledge Management (CIKM 2016), SIGWEB; SIGIR, Oct 2016, Indianapolis, United States. pp.1211--1220, ⟨10.1145/2983323.2983801⟩

International audience; Driven by the dominance of the relational model, we investigate how the requirements of applications on the certainty of functional dependencies can improve the outcomes of relational database schema design. For that purpose,

Externí odkaz: https://explore.openaire.eu/search/publication?articleId=doi_dedup___::7a7bca9e04bbf741cd649dad001750b5
https://oatao.univ-toulouse.fr/24944/

Normalization

Autor: Jan L. Harrington

This chapter covers the process of transforming an ER diagram into a well-designed relational database. For each normal norm, the chapter presents the rules that relations must meet to reach that normal form, and the design problems that may remain.

Externí odkaz: https://explore.openaire.eu/search/publication?articleId=doi_________::d4d7cb3bbaca26e62e6778b012708dd9
https://doi.org/10.1016/b978-0-12-804399-8.00007-7

Using Fuzzy Logic to Evaluate Normalization Completeness for an Improved Database Design

Autor: Nayyar Iqbal, Mahaboob Sharief Shaik, M. Rizwan Jameel Qureshi

Publikováno v: International Journal of Information Technology and Computer Science. 4:48-55

A new approach, to measure normalization completeness for conceptual model, is introduced using quantitative fuzzy functionality in this paper. We measure the normalization completeness of the conceptual model in two steps. In the first step, differe

Externí odkaz: https://explore.openaire.eu/search/publication?articleId=doi_dedup___::b9051a466f7dda2fc1df6faf31ced7d9
https://doi.org/10.5815/ijitcs.2012.02.07