Normalization on the fly

Research output: Contribution to journalArticle

1 Citation (Scopus)

Abstract

This paper describes a universal technique for data retrieval from a database file afflicted with repeating groups. The procedure relies on a generic "repeater" table which is joined to the unnormalized table. Though the physical data model may violate first normal form, the proposed technique produces a data view that overcomes that violation. The importance of this technique to the design and use of databases is demonstrated through an actual case study.

Original languageEnglish (US)
Pages (from-to)85-88
Number of pages4
JournalJournal of Systems and Software
Volume40
Issue number1
DOIs
StatePublished - Jan 1 1998

Fingerprint

Telecommunication repeaters
Data structures

All Science Journal Classification (ASJC) codes

  • Software
  • Information Systems
  • Hardware and Architecture

Cite this

Millet, Ido. / Normalization on the fly. In: Journal of Systems and Software. 1998 ; Vol. 40, No. 1. pp. 85-88.
@article{700760494cdd43e6a5c002ff643cd518,
title = "Normalization on the fly",
abstract = "This paper describes a universal technique for data retrieval from a database file afflicted with repeating groups. The procedure relies on a generic {"}repeater{"} table which is joined to the unnormalized table. Though the physical data model may violate first normal form, the proposed technique produces a data view that overcomes that violation. The importance of this technique to the design and use of databases is demonstrated through an actual case study.",
author = "Ido Millet",
year = "1998",
month = "1",
day = "1",
doi = "10.1016/S0164-1212(97)00015-0",
language = "English (US)",
volume = "40",
pages = "85--88",
journal = "Journal of Systems and Software",
issn = "0164-1212",
publisher = "Elsevier Inc.",
number = "1",

}

Normalization on the fly. / Millet, Ido.

In: Journal of Systems and Software, Vol. 40, No. 1, 01.01.1998, p. 85-88.

Research output: Contribution to journalArticle

TY - JOUR

T1 - Normalization on the fly

AU - Millet, Ido

PY - 1998/1/1

Y1 - 1998/1/1

N2 - This paper describes a universal technique for data retrieval from a database file afflicted with repeating groups. The procedure relies on a generic "repeater" table which is joined to the unnormalized table. Though the physical data model may violate first normal form, the proposed technique produces a data view that overcomes that violation. The importance of this technique to the design and use of databases is demonstrated through an actual case study.

AB - This paper describes a universal technique for data retrieval from a database file afflicted with repeating groups. The procedure relies on a generic "repeater" table which is joined to the unnormalized table. Though the physical data model may violate first normal form, the proposed technique produces a data view that overcomes that violation. The importance of this technique to the design and use of databases is demonstrated through an actual case study.

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

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

U2 - 10.1016/S0164-1212(97)00015-0

DO - 10.1016/S0164-1212(97)00015-0

M3 - Article

AN - SCOPUS:0031649467

VL - 40

SP - 85

EP - 88

JO - Journal of Systems and Software

JF - Journal of Systems and Software

SN - 0164-1212

IS - 1

ER -