Critique of relational database technology

Proceedings of the First …

IEEE Distributed Systems Online, 2006

Since they first became commercially available, database systems have played a well-defined role in enterprises: managing business-critical information and making it accessible to clients. During the past 40 years, the database research community has worked to significantly improve data storage, organization, management, and access, as reflected in many of today's most popular database management systems. Enterprises have been moving their critical data to (mainly relational) databases, and the number of databases, applications, and domains within each enterprise has multiplied. Moreover, by enabling cross-enterprise communication, the Internet has helped convert closely controlled environments into highly distributed, dynamic, large-scale information spaces. In today's global marketplace, most enterprises must actively share information with their partners, suppliers, and customers to achieve their business goals.

I have authored this paper to illustrate the History, Types, and Structure of Database Management Systems and their dependencies. Aiming to give a solid overview of the terms database and DBMS. Also, to help the reader create a global, comprehensive picture of the database and DBMS.We start the paper by listing the history of databases and storing data techniques. Then the terms data and types of data. After that, we start defining database and DBMS and their types. We have an extensive illustration of database objects. We give an overview of SQL, DML, TCL, DQL, and DDL as Structured Query Language. Finally, we ended the paper by talking about database normalization and its levels.

International Journal of Leading Research Publication (IJLRP), Vol. 1 Issue 4, 2020

The business performance in many organizations is enhanced through the effectiveness and efficiency of their database management system. Management decision-making is best achieved when the available data is at the right hand of decision-makers to analyze a given scenario. Customer best service is rendered when data redundancy is eliminated. The entity's overall bottom-line profit result is yielded when all the easily accessible data mixed together gives a higher net profit above the total operational cost. However, the traditional way of managing data establishes a major problem that affects their daily business operation. The technological advancement in every sector is driving change in all organizations; as there is a need for them to catch up with the need of the moment by creating a DBMS that will help their day-to-day operations. The challenges of accurately recording data, storing, updating and tracking are the major problems faced by Uniongate Diagnostic Center because of the manual means of operations. They can overcome the problems of working manually with data by perusing the benefits of database management systems. The use of a database will increase the efficiency of business operations and reduce overall costs. The database management system is used to store, organize and manage a large amount of information within a single software application. The data is entered into the system and it is accessed on a routine basis by assigned users. The users have an assigned password to gain access to the system. The project is developed for Uniongate Diagnostic centre Akure Ondo State, Nigeria. The development of a relational database for the diagnostic centre was implemented successfully using the Apache Server with MySQL running as the back end and PHP used as the server-side language. The results obtained show that the use of relational databases has reduced data storage costs, eliminate data redundancy, remove data inconsistencies and avoid duplicate processing. The overall business efficiency has improved significantly and work processes simplified with the least time of data query.

International journal of engineering research and technology, 2012

We report the comparison between the two leading type of Database storage components prevailing in the industry. The Database is largely concerned with managing massive amount of data in a consistent, stable, repeatable and quick manner. The prominent features of both relational as well as non relational databases have been specified which form the basis of the comparison between the two types of database. The relational model is based on mathematical theory(set theory, relational theory) whereas the nonrelational databases may or may not have a single groundwork mathematical theory. Relational model is beneficial when it comes to reliability, flexibility, robustness, scalability requirements but in order to cater to the needs of modern applications where the data is huge and generally unstructured; Non-relational databases show true signs of usability here. Based on the characteristics, commonly used tools of relational and non relational databases are mentioned along with brief in...

Database management systems (DBMS) technology is advancing in two directions. The evolutionary or parochial direction raises questions such as: How can DBMS technology meet current new application requirements? What features might it offer users? The revolutionary direction raises questions such as: What requirements will the next generation of computing, applications, and users place on DBMS technology? How can DBMS technology contribute to the next generation of computing? Current requirements pose known but difficult technical challenges as opposed to unknown future requirements which potentially pose greater challenges and will have a larger effect on DBMS technology. This paper considers both directions in speculating on advances in DBMS technology and relates them to current DBMS research, development, and product directions. The paper expresses the opinions of panelists on the above topic as discussed at the First International Conference On Distributed and Object-Oriented Databases, Kyoto, Japan, December 1989.

Database Management, 2024

This note provides a comprehensive examination of database management, covering fundamental concepts, principles, and contemporary practices in the field. The document begins by elucidating the foundational elements of databases, including data models, schemas, and normalization techniques. It delves into the role of database management systems (DBMS) as the central orchestrators of data organization, storage, retrieval, and manipulation. The note explores various types of databases, such as relational, NoSQL, and object-oriented databases, offering insights into their respective strengths, weaknesses, and use cases. Additionally, it discusses the significance of data integrity, security, and concurrency control within database systems, addressing the challenges and solutions associated with these critical aspects. A significant portion of the note is dedicated to query languages, with an emphasis on SQL (Structured Query Language) and its pivotal role in interacting with relational databases. The document also highlights emerging trends in database management, such as cloud-based databases, big data technologies, and the integration of artificial intelligence for enhanced data analytics. Furthermore, the note touches upon database administration, covering tasks such as backup and recovery, performance tuning, and user management. It concludes by examining the evolving landscape of database management, considering factors like the rise of distributed databases and the growing importance of scalability and flexibility in modern data ecosystems.

ACM SIGMOD Record, 1993

This paper very briefly summarizes the features and technologies implemented in the IBM relational DBMS products. The topics covered include record and index management, concurrency control and recovery methods, commit protocols, query optimization and execution techniques, high availability and support for parallelism and distributed data. Some indications of likely future product directions are also given.