According to (Shio Kumar Singh, ), “Databases and database management systems have become essential for managing our business, governments, banks, universities and every other kind of human endeavour”.
The major advantages of Data Base Management System (DBMS) are described below.
CONTROL DATA REDUNDANCY:
This feature allow to store all data in a single database avoiding traditional computer file processing that means each application has its own files and the same files are created in many different places. With DBMS all data are saved in one place in database and it’s not duplicated. In DMBS the data redundancy can be controlled or reduced but is not removed completed. Sometime is necessary duplicating some data to communicate with tables each other by managing redundancy data it is possible to save space and increase performance when queries are needed to retrieve data.
DATA CONSISTENCY:
Data consistency is quite dependent of control data redundancy because if the data control redundancy is controlled, data consistency is achieved. “If a data item appears only once, any update to its value has to be performed only once and the updated value (new value of item) is immediately available to all users.”(BlogSpot, 2014)
If the Database management System has reduced to a smallest level possible, the database system put into effect consistency.
That means when the data item displays more than once in the database and is updated, the Database management System automatically
with information it requires to join the information in the tables together as needed, helps support
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.
Database is a set of data. It has a regular structure and that is organized in such a way that a computer can easily find the desired information.
* Describe the role of databases and database management systems in managing organizational data and information.
Data Redundancy: Data redundancy is where a duplicate of information is sorted into different tables/databases. Sometimes data redundancy is done on purpose as a backup of data as a precaution just in case something happens and the data gets deleted. Data redundancy creates a new piece of data so that any modifications, addition of new data or deletion of data will be done on a new piece so that you will always have the
This research paper is to survey on database environment and development process. Database is an organized collection of logically related data. It consists of tables, queries, views and other objects. Database management system is a software system used for creating and managing databases. It is a collection of programs used to store, modify and extract information from database. It helps users and programmers for creating updating and managing the data in a systematic way. There are many types of database management system ranging from small systems to huge systems that run on personal computers and mainframes.
It is a set of technologies using which we can copy and then distribute data and the database objects from one database to another and then carry out synchronization between the databases to maintain the consistency of the data.
Data redundancy helps with the sorting of data because it has reduced the chances of errors by using data integrity rules such as validation rules and applying the right
More than likely the data is spread across several physical files. However, the database sees the data as being located in a single data repository. By organizing information in a single logical repository, it allows for easy handling and querying of the data. Traditional file systems required the programmer to specify when and how the data was to be retrieved (McCaldin, 2015, p. 1).
(Shelly, Cashman, Waggoner 1992). However, the arrival on the scene of the relational database along with the rapidly changing technology has modified the database administrator's role. This has required organizations to vary the way of handling database management.
Connolly and Carolyn (2004) define a database as a structureordesign that consists of theclient’s data as well as metadata. It is also a persistent, logicallycoherentrepository of inherentlymeaningful data that is relevant to someaspects of therealworld. The database consists of data organized in a systematicway, anditallowseasy retrieval of information, analysis, updating andoutput of data. Thatdata can be in theform of graphics, scripts, reports, text, tables, andsoon. Most of thecomputerapplications are databases at their core. Manycompaniesusuallyhave a lot of data, andsotheyhavebig databases that can handlethatlargeamount of data. It is wherenothe database administratorcomes into playtopensurepropermanagement of the database sothatthe organizational data is safe from anyintrudersor data corruption (Jones, 2014). The database is whatcontrolsthedata of theentireorganization, andany tampering of the databases can culminate to the stoppage of businessoperations.
Metadata present a more complete picture of the data in the database than the data itself.
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.
A database is a system that is specialized to manage data in a computer application system. Data has many forms, such as text, digital, symbols, graphics, images and sound. The database systems are integral components of current and future command, communication, control and intelligence information systems. (Lunt, 1992, p. 253)
RDBMS provide limited replication techniques. In fact, these databases are based on consistency instead of availability [14].