Analyze Gaps Between Theory And Practice In Data Management
Pathak, N. (2008). Database management system. [electronic resource]. Mumbai [India]: Himalaya Pub. House..http://proxy1.ncu.edu/
Research existing theories for databases and data management. Identify common theories, and explain if these theories have evolved over time. Then, research how these technologies are used in practice. You will likely have to include business journals and practical application of the concepts. Choose at least one major theory for further gap analysis. Write an assessment outlining the following:
- Explain the theory that was chosen.
- Provide your analysis of the gap between theory and practice (industry literature can help show the state of practice and help you determine the gaps compared with the scholarly literature).
- Outline the root cause of this gap and include the effect of the gap. Whom or what does it impact? Is it a positive or negative impact? Provide examples to support your findings.
NOTE: Do not select database normalization for your theory.
Support your assessment with a minimum of five scholarly resources. In addition to these specified resources, other appropriate scholarly resources, including seminal articles, may be included.
Length: 5-7 pages, not including title and reference pages
Your assignment should demonstrate thoughtful consideration of the ideas and concepts presented in the course by providing new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards.
Solution Preview
For this assignment, Relational Database Theory was chosen for discussion. The relational model is based on a digital model of data proposed in 1970 by E. F, Codd. The model introduced a software system that was used for maintaining relational databases commonly referred to as a relational database management system (RDBMS) (Darwen, 2009). Notably, the theory focuses on SQL (Structured Query Language), an important facet when designing computer languages such as PHP to store and process data. When handling simple data sets such as personal web database, understanding this processes is simply enough. However, when building scalable databases that can handle huge amounts of data sets, issues such as referral integrity, redundancy elimination, efficiency, and security become vital to the success of the database application (Darwen, 2009). As such, these issues can be tackled by delving into the theory behind the relational model as it applies to the database design principles.
(1,535 words)