Normalizing records data for relational databases
When relational database management systems (RDBMS) replace traditionally programmed computer systems, managers and users are often confronted with a barrage of strange terminology and concepts. It is the intent of this paper (and workshop) to demystify some of the ideals surrounding RDBMS technology. After all, these systems were marketed to the computer community as tools for end-user'' development of computer applications. This paper describes how to manipulate RDBMS structures to create concise, linkable tables of unique facts, events, or concepts via a process called normalization. The three primary rules of normalization are covered in considerable detail. Additional rules of normalization are also briefly presented because they are sometimes necessary for certain groupings of information. Some of the more technical details of the process of normalization have been simplified or excluded in order to provide the essential concepts to a wide audience. 7 refs., 1 figs.
- Research Organization:
- Pacific Northwest Lab., Richland, WA (United States)
- Sponsoring Organization:
- USDOE; USDOE, Washington, DC (United States)
- DOE Contract Number:
- AC06-76RL01830
- OSTI ID:
- 6148897
- Report Number(s):
- PNL-SA-18895; CONF-9109307-1; ON: DE92003104
- Resource Relation:
- Conference: Association of Records Managers and Administrators (ARMA) international conference, Orlando, FL (United States), 23-26 Sep 1991
- Country of Publication:
- United States
- Language:
- English
Similar Records
The lightness of being: mass, ether, and unification of the forces
Energy Intensity Baselining and Tracking Guidance