ipl-logo

Relational Database Management System Advantages And Disadvantages

1500 Words6 Pages

Relational Database Management System:
A relational database management system is a database management system that stores the data as tables which can related to each other. The tables might be related to each other by common attributes. It consists of a set of tables or files containing data that is fitted into some particular groups. These tables have data in the forms of rows and columns. Relational databases allows the user to update delete add and access a data entry from the tables. This is done by the help of 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 multiple users can access the data that can be controlled by individual …show more content…

It provides a middle group between relational database management system and object oriented database management system. It combines the advantages of relational database management system and object oriented database management system.
(Figure-3: Combination of RDBMS and OODBMS)
Advantages of ORDBMS:
ORDBMS provides advantages of object oriented programming as well as relational database management system. Following are the advantages of ORDBMS:
• One of the main advantage of ORDBMS is the flexibility in data reusability which will help in reducing the time and cost of the database designing
• It can work with the complex datatypes and based on the real world modeling
• The union of relational database management system and object oriented database management system increases the flexibility and functionality of the database
• As ODBMS provides better maintenance of database the ORDBMS also has the same feature therefore the data is easily manageable
Disadvantages of …show more content…

The other databases give the users a major access of their data or storage therefore there is a possibility of bugs entrance or making the data corrupt. The RDBMS however consumes a lot of physical memory and the problem on the other hand is not present in the object oriented programming database management systems. This system uses the objects of classes to manipulate data and therefore the data with similar data types consumes the same classes making it possible for the database consume less storage. But in order to take the advantages of both the databases there is a combination of the two databases i.e. object relational database management system. It has the data security and less data physical storage but because of the use of both databases the object relational database becomes complex. But it gives many features and user friendly usage to its users and therefore it is more preferable. However it becomes complex for the database developers. Other than these three databases there is XML database which is written in the most easiest and flexible language which is self-describing so the developers prefer using it. However this type of database provides least amount of data

Show More
Related

  • Nt1330 Unit 1 Study Guide

    317 Words  | 2 Pages

    What are the exact features of a distributed database? a) Is always connected to the internet b) Always requires more than three machines c) Users see the data in one global schema. d) Have to require the physical location of the data when an update is done

    Read More

  • Pt2520 Unit 1 Assignment

    442 Words  | 2 Pages

    In developing a database, one of the first things one must know is how the database(DB) will be used within the organization. Seconda,y what type of data will be required to develop the database and how it will enhance productivity and reliability to the organization. All the information is gathered in the first phase of the database life cycle, which is planning. In the planning phase, you are gathering information on the need, cost and feasibility of the database within the organization. Also within this phase you would look to see if there are databases within the organization that can meet the requirements.

    Read More

  • Nt1310 Unit 4 Systems Analysis

    49 Words  | 1 Pages

    • The four major systems each have its own database and interfaces had to be built for them to all communicate with each other. This is caused information to show in multiple formats and is difficult to reconcile. Providing accurate reports for banking and government regulators is very challenging.

    Read More

  • Unit 20 M1

    876 Words  | 4 Pages

    The Use of Database in Effective Sales Management 1. Uses of Database in Zacoom Holdings With the technology available today, all businesses regardless of size, can have an interactive database without too much effort. When considering using a database to increase sales Zacoom Holdings even believes that they already have one in their systems to get started. Sales databases provide many opportunities to optimize their sales relationships and success. Database helps sales management in many different ways, and below are some useful help Zacoom Holdings g ain from their database.

    Read More

  • M1 Unit 3 Written Assignment

    1098 Words  | 5 Pages

    Unit 3 Written Assignment Terry J. King University of the People Abstract Databases are an effective tool for a retail business, to help meet its needs and objectives, as outlined in its business strategy and the values that are contained within a company mission statement. Efficiency is an important driver for a database, and this can be achieved by carefully considering the database relationships that are defined through the primary and foreign keys. Keywords: Business, Information Technology, Database Unit 3 Written Assignment

    Read More

  • Nt1310 Unit 18 System Analysis

    510 Words  | 3 Pages

    Access is a database management system that allows users to create a database, add, change and delete data. Outlook is an app were users can communicate with others and organize

    Read More

  • Pt1420 Unit 2 Assignment 2

    102 Words  | 1 Pages

    ASSIGNMENT 02 Key: A key is an attribute or set of attribute in a relation that identifies a tuple in a relation. Followings are the keys used in Data Base Management System. 1) Super Key: A set of attributes of relations for which it holds in all relation there are no two rows that have same values for attributes.

    Read More

  • Nt1330 Unit 2.7 Observation Paper

    500 Words  | 2 Pages

    Therefore, the database can be any type such as SQL, Not Only SQL (NOSQL), or other. Observation_4: The CSP needs to apply a virtualization technology on storage resources to serve CSUs’ demands efficiently. Therefore, a

    Read More

  • Essay Explain The Need For Safe Storage And Efficient Retrieval Of Information

    1229 Words  | 5 Pages

    The information or data that needs to be stored could relate to personal employee information that would need to be password protected so only the relevant people can gain access. Only if date if stored in a procedural manner can it be easily retrieved. This can also help if an external body needs to gain access to records for example auditors. Describe the features of different types of systems used for storage and retrieval of information. There are many different ways in which you can store and retrieve information; the main purpose of storing any information is for easy retrieval in the future when it is

    Read More

  • Big Data In Human Resource Management

    975 Words  | 4 Pages

    Even though organizations hold huge amount of data, they cannot use them effectively as they are unstructured. However new technologies are now available which enable analysis of large, complex, unstructured data. The accessibility of technology has become easy; as a result, there is massive increase in data amounts available with the entrepreneurs. The data usage depends on the ability the way it is stored, managed and then analyzing it adequately. Big data is an upcoming and emerging trend in the field of Information technology.

    Read More

  • Strengths And Weaknesses Of Operations Management

    968 Words  | 4 Pages

    The purpose of Operations management within an organization is to control the production process and business operations as efficient as possible to achieving overall organizational goal (investopedia.com, 2017). Therefore operation management creates policies, processes and procedures and also use various methods and techniques to maximize profits thus achieving organizational goal. Approaches or Techniques of operation management To improve the operational performance, operation management use various techniques to improve the operational performance. Some of these approaches are: Six Sigma Lean production Queuing theory TQM In this section below some of these techniques or theory has been explained: Six Sigma: Six sigma an effective and significant process improvement theory

    Read More

  • Advantages And Disadvantages Of LINQ

    859 Words  | 4 Pages

    Introduction of LINQ (Language Integrated Query) Based on the research conducted, the term LINQ is an acronyms that stand for Language Integrated Query. LINQ is tool that mainly used for querying data in the ASP.NET by defining a common programming syntax to query different type of data through using a common language. LINQ syntax is divided into 2 type of syntax which is Lambda (Method) Syntax and Query (Comprehension) Syntax. However, both syntax also involve the use of extension method. Moreover, LINQ can be used to extract data from various data sources such as LINQ to Objects, XML, SQL and etc.

    Read More

  • Advantages And Disadvantages Of Relational Database Management System

    1110 Words  | 5 Pages

    In a relational database management system the data access is privileged which means that the database administrator has the authority of giving access of data to some particular users which makes the data secure. 3. Easy to use: This type of database uses tables which is better and easy to create and use. Disadvantages of RDBMS: 1. Slow:

    Read More

  • Tracking System Advantages And Disadvantages

    1693 Words  | 7 Pages

    Reduce operational costs and increase productivity Track and control vehicles to provide better communication, deliver timely services, etc. Transmit information quickly via satellites and prepare vehicle reports All these features of the tracking system ultimately reduces operational costs and increase productivity. Guide drivers and increase fuel efficiency By careful analysing driver behavior such as speeding, acceleration, braking etc. , you will be able to avoid unnecessary wear and tear of the vehicle, operating, and fuel costs With the help of sensors, you can minimize maintenance costs, machine failures, and thereby prevent vehicle theft Improve cargo security and driver's safety You can identify theft instantly

    Read More

  • Essay On Importance Of Operation Management

    1486 Words  | 6 Pages

    Operation management is a crucial tool which help organization to achieve its objectives. This is required for limited period of time and finances to fulfill the objectives. Benefits of safe, timely, cost effective, high quality and law abiding production Safe production is important for sustaining the skilled workforce. This gives them the peace of mind and make the most of their abilities to contribute towards the prosperity of the company.

    Read More

More about Relational Database Management System Advantages And Disadvantages

Open Document