Denormalization Guidelines for Base and Transaction Tables Douglas B. Bock Department of Computer Management and Information Systems Southern Illinois University Edwardsville Edwardsville, Illinois 62026 USA John F. Schrage Department of Computer Management and Information Systems Southern Illinois University Edwardsville Edwardsville, Illinois 62026 USA Abstract This article outlines heuristic guidelines for denormalizing transaction tables in relational databases. Denormalization as a process seeks to improve the response time for data retrieval while maintaining good system performance for row insertions, updates, and deletions. These guidelines apply especially for client-server environments where response time for on-line, transaction-processing systems is critical to end-user satisfaction and productivity. 1. Introduction Normalization as part of the conceptual design phase focuses on developing well-structured relations (tables). A wellstructured relation minimizes redundant data storage and supports data manipulation language processing for row insertions, deletions, and updates without introducing errors or data inconsistencies termed anomalies. While a fully normalized database schema reduces the possibility of anomalies, it can introduce other types of problems. These include inadequate system response time for data retrieval and storage, and referential integrity problems due to the decomposition of natural data objects into relational tables. A successful database administrator must trade-off the benefits of normalization
End of preview. The entire article is 5 pages. To view the full-text, please rent this article to continue.
/lp/association-for-computing-machinery/denormalization-guidelines-for-base-and-transaction-tables-jztLWAQ9kk
Welcome to DeepDyve! Rent Premier Research Articles and Save Up to 90%
Denormalization guidelines for base and transaction tables
Bock, Douglas B.; Schrage, John F.
Follow ACM SIGCSE Bulletin
, Volume 34 (4)
Association for Computing Machinery – Dec 1, 2002
More Info
More Like This Article
View All dataSource[]=actageo&dataSource[]=aspet&dataSource[]=aaos&dataSource[]=aacc&dataSource[]=aacr&dataSource[]=aea&dataSource[]=aip&dataSource[]=ajnr&dataSource[]=ams&dataSource[]=aps_physical&dataSource[]=appi_book&dataSource[]=appi_journal&dataSource[]=apha&dataSource[]=asip&dataSource[]=asm&dataSource[]=asn&dataSource[]=aspb&dataSource[]=avs&dataSource[]=annual_reviews&dataSource[]=arxiv&dataSource[]=acm&dataSource[]=berghahn&dataSource[]=cabi&dataSource[]=clinical_trials&dataSource[]=dailymed&dataSource[]=degruyter&dataSource[]=du_press&dataSource[]=esa&dataSource[]=eu_press&dataSource[]=elsevier&dataSource[]=emerald&dataSource[]=ejtr&dataSource[]=emea&dataSource[]=epo&dataSource[]=faseb&dataSource[]=gsa&dataSource[]=health_affairs&dataSource[]=hindawi&dataSource[]=imanager&dataSource[]=imedpub&dataSource[]=informa_healthcare&dataSource[]=informs&dataSource[]=iop&dataSource[]=iucr&dataSource[]=iospress&dataSource[]=jbjs&dataSource[]=leftcoast&dataSource[]=lu_press&dataSource[]=mesharpe&dataSource[]=mary_ann_liebert&dataSource[]=medline&dataSource[]=mit_press&dataSource[]=nature&dataSource[]=oxford&dataSource[]=pier_professional&dataSource[]=pnas&dataSource[]=portlandpress&dataSource[]=psyc_articles&dataSource[]=psyc_books&dataSource[]=psyc_critiques&dataSource[]=plos_journal&dataSource[]=pubmed_central&dataSource[]=rsna&dataSource[]=rockefeller&dataSource[]=rcn&dataSource[]=ria&dataSource[]=rsc&dataSource[]=sage&dataSource[]=spie&dataSource[]=springer_journal&dataSource[]=springer&dataSource[]=taylor_francis&dataSource[]=aps&dataSource[]=the_scientist&dataSource[]=uc_press&dataSource[]=uspto_abstract&dataSource[]=wiley&dataSource[]=pct
© 2012 DeepDyve, Inc. All rights reserved.
Terms of Service | Privacy Policy
