Challenges In Database Theory And Practice
This paper focused on challenges in database theory and practice. Database management has undergone more than four decades of evolution producing vast range of research and extensive array of technology solutions. The database research community and software industry has responded to numerous challenges resulting from changes in user requirements. Most recent database challenges arise because there are now hundreds of millions of users and cloud databases need to use novel techniques for managing massive amounts of data, securing data, prevent data duplication while supporting migration to other databases. Challenges highlighted in database theory and practice in this paper are use of primary key and social security numbers, deadlock detection and management, dealing with missing data, data privacy and data auditability challenges. Also presented are ways of overcoming the challenges in database theory and practice.
Keywords: Databases, Database Management System (DBMS), Primary Key, Online Transaction Processing (OLTP), Distributed Database Management System (DDBMS)
Databases, in particular relational databases, are a ubiquitous part of today’s computing environment. Database management systems support a wide variety of applications, from business to scientific and more recently various types of internet and electronic commerce applications. Database management systems (DBMS) are a core technology in most organizations today and run mission-critical applications that banks, hospitals, airlines, and most other types of organizations rely on for their day to day operation. Over the last three decades relational DBMS technology has proven to be highly adaptable and has evolved to accommodate new application requirements and the ever-increasing size and complexity of data (Pokorn, Snasel, and Richta, 2010).
But, there are challenges presented by this development. There are indications that some of the recently emerging data-intensive applications (e.g. internet searches) cannot be satisfactorily addressed using existing DBMS technology, and some experts argue that significant innovation is needed (a new database paradigm) to overcome the limitations of the current generation of database technology.