Why are relational database management systems (RDBMS) and data warehouses needed?
The flat file processing approaches that preceded RDBMS and DW created data redundancy and inconsistency, difficulty in accessing data, data isolation, data integrity problems and security problems. Often the same information was duplicated in several files and all copies may not be updated. Because of the many files it was often necessary to write a new application program to satisfy an ad hoc data request. Because data was in many files often with many file formats, it was difficult to write new application programs. In general it was difficult to enforce or to change integrity constraints with the file-processing approach. Finally, security is difficult to manage with many files and many isolated application programs. The major purpose of a database system is to provide users with an understandable view of the data. The system hides most details of how data is stored and created and maintained from users. The relational data model describes the organization of the database. It is of
Related Questions
- How does an in-memory data grid improve the performance, scalability and reliability of a relational database (RDBMS)?
- Are there any commercial database management systems (DBMS) supporting Temporal Database Applications?
- Which web businesses pioneered the use of relational database management systems for e-commerce?