Relational Data Model Versus No SQL Data Model
Rutu Patel
CSIT 555 Database Systems
Midterm Research Paper
[1] INTRODUCTION:
The term database can be defined as the collection of systematic, well-ordered and structured data that can be easily and efficiently handled, retrieved and upgraded on a periodic basis depending on its requirements. The structure and organization of any database is based upon its respective database model.
A unique database model is implemented by each database depending upon the logical structure of the data that is being handled by that database. There are numerous distinct database models out in the market at present that allow the application developers to effectively manage the data. The most widely welcomed
…show more content…
The fundamental theory of logical relations among the grouped data is incorporated in the relational database model. This method offers numerous advantages such as keeping the structured data in an organized and logically related manner, ease of data handling in case of related data or information, simplicity of data management and many more. In general, it can be stated that those database systems that assimilate the technique of relational SQL data model can execute in a productive and precise method.
[3] THE NO SQL DATABASE SYSTEM AND KEY-VALUE STORE DATA MODEL:
The term “No SQL” is considered in a much wider vision which means “Not Only SQL”. This can be elaborated in the sense that the concept of No SQL does not consider the complete elimination of SQL language, rather it focuses on supporting other SQL like queries. The No SQL Database basically follows a model-free approach. The leading advantage of implementing the No SQL database is eliminating all the restrictions of the rigorously followed structured model in the relational database system. In No SQL approach, there are many flexibilities of choosing eligible data structure according to the information or data that has to be handled. Some of the widely followed data models of the No SQL database are key value stores, column family stores, document database, graph database, etc. The fundamental concept behind the development of the key-value store data model is to create a data model that
Data objects can model relational data or advanced data types such as graphics, movies, and audio. Smalltalk, C++, Java, and others are objects used in object-oriented data. The object-relational is a combination of relational and object-oriented databases. Traditional and advanced data types can be used to construct database management systems. These systems can connect to a company’s website and update records as needed. Database Approach The main purpose of a database is data storage that can be stored and retrieved when needed. A popular common language called structured query language (SQL) is used to store and retrieve data in relational database. This language enables the systems to run a report or modify data or remove the data from the database. A database management system (DBMS) controls all aspects of a database, this is not limited to the creation, maintenance, and use of database. The DBMS ensures proper applications are able to access the database. An important purpose of a DBMS is to maintain the data definitions (data dictionary) for all the data elements in the database. It also enforces data integrity and security measures. Data Models Data models provide a contextual framework and graphical representation that aid in the definition of data elements. In a relational database, the data model lays the foundation for the database and identifies important entities,
A database is a structural set of related data that is organized in such a way that the information can be easily managed, accessed, and updated. The purpose of a database is to replace paper documents, files, and filing cabinets. The data collected in databases is an efficient way to store, retrieve, and analyze the information.
It is a process of constructing a data model for each view of the real world problem which is independent of physical considerations. This stage involves assessing the informational needs of an organization so that a database can be designed to meet those needs.
Databases today are essential to every business. Whenever you visit a major Web site – Google, Yahoo!, Amazon.com, or thousands of smaller sites that provide information – there is a database behind the scenes serving up the information you request (Hector, Ullman, & Widom 2008). Database systems are becoming as common in the workplace as the essential one that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user.
A relational database is a database that consists of a collection of tables with columns showing entities, and rows showing data. This type of database uses a primary key and foreign key. The foreign key in another table will point to the primary key of a table, and this is how tables can relate to each other. This permits for one-to-one, one-to-many, and many-to-many relationship between the data. An advantage of relational databases includes the ease of adding or modifying new tables and entities without needing to change the structure of the database already in place. Relational database have many features, including indexing, setting data type, and setting validation tests, all these help to ensure data integrity.
Database model defines the logical structure of the database by determining manner in which the data will be stored. Relational model is one of the most popular database models, which defines tables and relationships between the tables.
This model demonstrates the data attributes logical entities and relationships between these entities within a business function. It also helps to create the physical data model. Moreover, it shows more details while integrate business logic and business rules. This model is used to describe the domain concept and their relationship of the domain problem.
Database plays a major role in any organization. As a Database administrator(DBA) he/she is responsible in developing, implementing and maintaining the databases and DBA 's are also responsible in updating, backup 's and security of the databases. The first Database Management System was developed in the late 1960 's by two firms based on their network data model but in the early 1970’s a scientist of IBM introduced Relational database theory after six years IBM completed prototype on RDBMS (relational database management system). Oracle created the first versatile Relational Database Management Systems In 1983, which allowed organizations to use their DBMS on different machines including mainframes, workstations, and Pc 's. In 1993 Microsoft first created a database application called Access for Macintosh machines. Microsoft SQL server is a RDBMS which is used to store and retrieve the data by other software applications. There are 12 types of servers concentrated on various types of user 's from single computer to large networks (Microsoft SQL DBA).
A database is an ordered collection of associated information. Database has data that is connected to each other. For example, a database that comprises information about company stock prices must not also contain information about student.
There are several important steps to consider when designing a database, as a well-designed database should be deployed and not only support the accuracy and integrity of business information but also avoid redundant data and assist with has enterprise level reporting tasked. If we analyze the
Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This
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).
An enterprise data model presents an abstraction of a more complicated real-world event or object. Generally, a data is graphical simple representation, of an interconnected real organization’s data structures. The main function of the data model is to help in understanding the complexities of a particular organization. A data model within a database environment brings out the data structures, their transformations, constraints, relations, and characteristics, thus providing a blueprint of
Today, Database management systems play a main role in management, data transportation, administrative and control systems. A database management system (DBMS) is system software for creating, managing databases. A database management system creates a systematic way for programs, apps and users to create, retrieve, delete, update and manage data. DBMS ensure that data is consistently organized and remains easily accessible. As a normal person we access to database management systems every day within our personal computers, mobile phones and various digital devises for various purposes like play online games, find something, find a place. Today every business, organization use a DBMS for store,
In recent years, the distributed database system has been emerging as an important area of information processing, and its popularity is increasing rapidly. A distributed database is a database that is under the control of a central DBMS in which not all storage devices are attached to a common CPU. It may be stored on multiple computers located in the same physical location, or may be dispersed over a network of interconnected computers. Collections of data (e.g., in a database) can be distributed across multiple physical locations. In short, a distributed database is a logically interrelated collection of shared data, and a description of this data is physically distributed over a computer network. A