A Research Study On Relational Database Technology

A Relational Database Management System (RDBMS) is a type of database management system that stores data in the form of related tables. The system does not require many assumptions about how data is related t or how it is to be extracted from the database. The database can be viewed in several forms.

Databases have been around long before the computer first utilized them, but they became a necessity as the industry has been using them now for over 40 years. Everything is a database now, your inventory, your class schedule, your closet, it is all a possible database. Arora and Gupta state, “Stand alone applications have been replaced with web-based applications, dedicated servers with multiple servers dedicated storage with network storage” (Arora and Gupta 2012). There have been several movements to try and change the database environment, however attempts to replace the relational database with the object-oriented database never came to popularity and relational databases popularity remains high today. However, a new movement called

Relational database contains data records that do not have a preset of relationships, permitting the user to define his or her relationship when accessing the data. Since users have much control over the data being accessed, relational databases can perform a variety of tasks. Such as defining the database; querying the database; adding, editing, and deleting data from the database; modifying the structure of the database; securing data from public access; communicating within the network; and exporting and importing data (Murthy, 2008).

In order to overcome these limitations, a new database model known as Not Only SQL (NoSQL) database emerged with a set of new features. The main objective of NoSQL is not to discard SQL, but to be used as an alternative database data model for new features [1] [2] [3]. NoSQL database increases the performance of relational databases by a set of new characteristics and advantages. In contrast to relational databases, NoSQL databases introduced an additional feature that provides flexible and horizontal scalability and taking advantage of new clusters. The rise of NoSQL provides cost-effective management of data in modern web applications. With its new features, NoSQL can be used with applications that have a large transaction, and require low-latency access to huge datasets, service availability while

The wider insight about relational and non-relational database performance, particularly MySQL and Hadoop was gathered through the literature survey. By read textbooks, reviewing academic journals and research papers, I founded a gap in the performance of relational database compare to the non-relational.

The knowledge base consists of information regarding the user behavior and ADL that include self-care tasks, household duties, and personal management actions. It specifies the task to be carried out and the actions to be performed. The relational database presents a natural association between the two elements of the decision support system, and the use of the database to additionally represent a novel approach to knowledge engineering (KE) for planning.

The idea of relational database was first introduced by E.F.Codd at IBM in 1970. It is a kind of computer database in which data is stored in Relations and is represented in the form of tables with rows and columns. Databases can vary in sizes, ranging from very small and simple to very large and complex ones. Database users can access the data practically in an unlimited number of ways. Relational databases help in finding the information in a quick and efficient manner that one is looking for.Today many popular databases use the model of relational database.

Introduction: A company called Ian’s & Co currently employs a team of IT technicians to manage their IT infrastructure and also support the IT users. Also quite recently the company has taken over a similar but a smaller company which is also employs technical support staff in the same way.

A relational database is a collection of data which organized into a set of tables that can be accessed in multiple ways without having to reorganize the tables’ oftenly.Relational Database was proposed by Edgar Codd around the time 1969.It has become prevalent for commercial applications. In the 20th century there were countless Relational Database System (RDBMS) take for instance: IBM.DB2 and Oracle.

At the U.S. Census Bureau, hundreds, perhaps more than a thousand heterogeneous databases are currently operating. Some divisions have standardized the database technology on Oracle, while others are using a combination of Sybase, MySQL, SQL Server, etc. These Relational Database Management Systems (RDBMSs), supporting many databases and applications and each hosted on dedicated servers, are often under-utilizing the server resources available to them. Such a database infrastructure, therefore, is not cost-, or resource-effective from a maintenance or administrative standpoint. Consequently, the best solution to mitigate these issues involves the implementation of database consolidation technology. Database consolidation is the process of centralizing database resources, so that they are shareable among several databases and instances. In other words, it is the process of consolidating databases from multiple servers onto one or fewer servers. For example, Multitenant Architecture of Oracle 12c moves the database management principle to a completely new level with database consolidation. Consequently, for the U.S. Census Bureau, consolidation initiatives such as the following are beneficial:

A relational database management system is a type of database management system that stores the data in the form of related tables. The tables might be related to each other by common fields. It consists of a set of tables or files containing data that is fitted into predefined categories. These tables have data in the forms of rows and columns. Relational databases enable users to perform deletion, updating, reading and creating the data entries in the database tables. This is accomplished though structured query language, or SQL. SQL also provides users the facility to manipulate and query data in a relational database. It also provides the facility of multi user accessibility that can be controlled

The successful applications of No SQL databases in the USA involve the development of the Facebook wall. The Metlife in the Insurance industry applied the techniques of the No SQL databases to develop the social interface of the Facebook wall. The social media platform supports all application of the insurance industry including the information management center and the call center. The insurance applications and functions like filling the claim form acquire effective and efficient operations on the social wall of the company account. The integration of the insurance agencies and the Facebook application allows the insurance agents to solve customer claims and the questions arising from the insurance matters. The selling of the insurance claims takes place on the Facebook platform. The analysis report indicated that data that more than 70 different databases have subscription to the platform. The No SQL application supports more than 45 million insurance agreements integrated within the official Facebook platform. The USA insurance had tried applying the integration of insurance and Facebook with the relational database management system however the attempts failed. The full successful integration was accomplished using the No SQL databases. The No SQL integrated Facebook application runs in four dedicated servers. The current No SQL application servers support 24 terabytes of data. b

A relational database’s use is organizing large amounts of data. Relationships database define the relationship between two points of tables and these database systems are linked by defining that relationship.

What is database management system? Database Management System is a database program. The DBMS manage incoming data, organize it, and provided ways for the data to be modified or extract by users or other programs. This cause, most database software comes with an Open Database Connectivity (ODBC) driver that allows the database to integrate with other databases. For example, common SQL statements such as SELECT and INSERT are translated from a program's proprietary syntax into a syntax other databases can understand. Some DBMS examples include PostgreSQL, MySQL, SQL Server, Microsoft Access, Oracle, FileMaker, RDBMS, dBASE, Clipper, and FoxPro. It is a software system that uses a standard method of retrieving, and running queries on data.

Roger K. Doost, (2002) "The need for change in the way we teach accounting information systems", Managerial Auditing Journal, Vol. 17 Iss: 5, pp.277 – 282