Advantages And Disadvantages Of The Evolution Of Database Management Systems

Database is defined as “the collection of information organized in such way that a computer program can quickly select the desired pieces of data.” (Haithcoat, n.d.). In today’s technological world most of the processes is automated where database plays an important role to manage the data across a system. A database can be considered as an electronic filing system. Traditional databases are organized by fields, records, and files. A field is a single element of information; a record is one complete set of elements; and a file is a collection of records. To manage these data across the database system, DBMS came into play and the basic role was to create the management of information across all the data. DBMS plays a critical and integral component of most successful GIS and used to store, manipulate and retrieve data from the database. Although the range of DBMS structures used in GIS includes inverted list, hierarchical, network and relation design.

Access time: One of the primary disadvantages of traditional file systems is the time it takes to access data. It can take minutes if not hours to locate a few files in a large paper filing system. Electronic databases allow for almost instantaneous access to information

1. Reliability: Reliability if the failure of one of the sites that contain the relationship (or database), a copy can be always found in another location without delay of the network traffic. Also available all copies can be updated as soon as possible transactions occurred, and the nodes is not available are updated once they return to

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.

In a distributed database system, all the databases or the storage devices are not connected to a single common processing unit like CPU. The various data may be stored at different physical locations in multiple computers that are located in the same physical location; or they may be inter-connected over a network. In other words, distributed database system consists of various data locations but they do not share any physical components.

A(n) FOREIGN KEY constraint is used to ensure that referential integrity exists between tables. _________________________

Relational data is when you can put data in a computer one time and it grows

I am utilizing the Relational Database in my proposal. According to Murthy, data in a relational database, is mainly represented in tables and is considered to be an assortment of relations. A relational database is similar to a spreadsheet, in that a relational database organizes data in tables. The table is then made up of rows and columns. A row is also known as a record or tuple, and a column is also known as called a field or attribute. Using a relational database allows me to efficiently store huge amount of data, and effectively retrieve selected data. Tables in the relational database are distinguished by a primary key, which confirms that “no

Reducing data redundancy will help improve the database and it assists making data retrieval more simple and easy. Data redundancy makes the storage space needed for the database smaller as it is more efficient compared to older flat based databases which wasted space as it stored the same information in more than one field. Normalisation is what is used to design the RDBMS to split the data up into related tables and then this helps to create relationships between them which enables them to communicate with each other. The main purpose is that it helps reduce the redundancy as it integrates the

The data could also be stored in lots of different tables and the database will be able to store them all.

The application standard to use this kind of database is the structured query language (SQL)

Databases allow us to easily store and retrieve data in a purely digital format. The strength of this is that large amounts of data can be stored and retrieved with minimal effort on the part of the user. Opposed to manually flipping through files, one can quickly pull up the requested data through a computer program. Many systems that were conventionally paper and file based have been converted to a digital format which are now stored in one or more databases.

Redundancy is the duplication of data or the storing of the same data in more than one place. Redundancy wastes space, makes the updating of data more cumbersome and time-consuming, and can lead to inconsistencies.

There are several functions that DBMS performed to make sure the integrity of the data and data consistency in the database such as data storage, retrieval and update, A user-Accessible catalogue, transactional support, concurrency control services, recovery services, Authorization services, support for data communication, integrity services, services to promote data independence and utility services.

A.) Database user names are global across a database. Database users interact with database objects. Every database object has its owner-the user that created it. Every user and role has its creator.