The Proceedings of the Information Systems Education Conference 2005: §3153 Home Papers/Indices prev (§3152) Next (§3154)

Sat, Oct 8, 9:00 - 9:25, Senate B Paper (refereed)

Recommended Citation: Ugboma, E. How Valuable is Planned Data Redundancy in Maintaining the Integrity of an Information System through its Database. In The Proceedings of the Information Systems Education Conference 2005, v 22 (Columbus OH): §3153. ISSN: 1542-7382. (A later version appears in Information Systems Education Journal 4(112). ISSN: 1545-679X.)

How Valuable is Planned Data Redundancy in Maintaining the Integrity of an Information System through its Database

Refereed

8 pages

Eghosa Ugboma    [a1] [a2]
Department of Computer Science and Mathematics
Florida Memorial University    [u1] [u2]
Miami Gardens, Florida, USA    [c1] [c2]

Although planned (controlled) data redundancy increases the distribution of redundant data to a very meager degree, this type of redundancy most often involves few columns of database data files that supports an information system and helps to enforce the integrity of the information system. The effectiveness of an information system depends largely on the database that supports the information system. This paper discusses the importance of planned data redundancy and how it is implemented in assisting an information system to be deemed effective in generating the required data and information to its intended users. Due to their unique functions and for easy understanding, this paper uses the primary keys and foreign keys columns to demonstrate how planned data redundancy is implemented to help maintain the validity of the data pool that an information system needs to produce the desired information. First normal form (1NF), third normal form (3NF), fourth normal form (4NF), and the Redundant Data technique of denormalization process are the yardsticks used to illustrate how controlled data redundancy is generated, in which keys’ columns it occurs, and its benefits to information systems. Planned data redundancy is classified into two groups, namely, internal controlled data redundancy and external controlled data redundancy. To understand their formation and how they are used to maintain the integrity of a database and uphold the reliability of the information system that uses the database, normalization and normal forms as well as denormalization are discussed at the elementary level.

Keywords: planned data redundancy, redundancy, normalization, normal Forms, denormalization, database, data pool, data files

Read this refereed paper in Adobe Portable Document (PDF) format. (8 pages, 372 K bytes)
Preview this refereed paper in Plain Text (TXT) format. (27 K bytes)

CDpic
Comments and corrections to
webmaster@isedj.org