Concepedia

Denormalization

Denormalization is a schema modification strategy in database design that involves intentionally introducing redundancy into a relational schema to enhance query performance by reducing the number of joins required, thereby deviating from the principles of normalization while balancing consistency and efficiency trade-offs.

28

Publications

751

Citations

87

Authors

43

Institutions

Publications per year

2017–2026

10

Parents

Publications

28

Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation

Ģirts Karnītis, Guntis Arnicāns · 2015 · 65 citations

, , +17

The denormalized 3×3 lemma

Dominique Bourn · Journal of Pure and Applied Algebra · 2002 · 59 citations

, , +4

Denormalization effects on performance of RDBMS

G. Lawrence Sanders, Seungkyoon Shin · 2005 · 56 citations

, , +17

Denormalization strategies for data retrieval from data warehouses

Seung Kyoon Shin, G. Lawrence Sanders · Decision Support Systems · 2005 · 54 citations · Full text

, , +16

Automatic Generation of Normalized Relational Schemas from Nested Key-Value Data

Michael DiScala, Daniel J. Abadi · 2016 · 54 citations

, , +16

1–5 of 28

Authors

87

  1. DB
    Dominique Bourn

    Laboratoire de Mathématiques Blaise Pascal, France

    2 publications · 80 citations

    2

    h-index

  2. GL
    G. Lawrence Sanders

    University at Buffalo, State University of New York, United States

    2 publications · 110 citations

    2

    h-index

  3. HS
    Haşim Sak

    Google (United States), United States

    1 publications · 10 citations

    1

    h-index

  4. MS
    Marco Sorrentino

    University of Salerno, Italy

    1 publications · 22 citations

    1

    h-index

  5. GA
    Guntis Arnicāns

    University of Latvia, Latvia

    1 publications · 65 citations

    1

    h-index

1–5 of 87

Institutions

43

  1. University at Buffalo, State University of New York

    Buffalo, United States

    2 h-index

    3 publications

    166 citations

  2. Institut national de recherche en sciences et technologies du numérique

    Le Chesnay-Rocquencourt, France

    2 h-index

    6 publications

    120 citations

  3. Harvard University

    Cambridge, United States

    2 h-index

    2 publications

    73 citations

  4. Carnegie Mellon University

    Pittsburgh, United States

    2 h-index

    2 publications

    24 citations

  5. Instituto de Telecomunicações

    Lisbon, Portugal

    1 h-index

    1 publications

    11 citations

  6. Roswell Park Comprehensive Cancer Center

    Buffalo, United States

    1 h-index

    2 publications

    48 citations

  7. Renmin University of China

    Beijing, China

    1 h-index

    5 publications

    85 citations

  8. College of Business Administration

    Riga, Latvia

    1 h-index

    1 publications

    54 citations

1–8 of 43

Venues

  1. Journal of Pure and Applied Algebra

    2 publications · 80 citations

    2

    h-index

  2. arXiv (Cornell University)

    Repository · 2 publications · 42 citations

    2

    h-index

  3. IEEE Transactions on Computers

    1 publications · 15 citations

    1

    h-index

  4. IEEE Transactions on Knowledge and Data Engineering

    TKDE · 1 publications · 17 citations

    1

    h-index

  5. Substance Abuse

    1 publications · 24 citations

    1

    h-index

1–5