0
Can data redundancy be completely eliminated when database approach is used?
Wiki User
∙ 9y ago
Database is collection of some inter related records . And yes, data redundancy be completely eliminated when database approach is used.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
DO you have redundancy of records in distributed DBMS?
Redundancy means duplicacy of data or repetitive data. In distributed database case the data is stored in different systems . So the answers is yes there can be redundancy of records / data.In distributed database , data is stored in different systems. Since the data is distributed there is redundancy of records.
What is Controlled redundancy in a database?
In non-database systems each application has its own private files. This can often lead to redundancy in stored data, with resultant waste in storage space. In a database the data is integrated. The database may be thought of as a unification of several otherwise distinct data files, with any redundancy among those files partially or wholly eliminated. Data integration is generally regarded as an important characteristic of a database. The avoidance of redundancy should be an aim, however, the vigour with which this aim should be pursued is open to question. Redundancy is * direct if a value is a copy of another * indirect if the value can be derived from other values: ** simplifies retrieval but complicates update ** conversely integration makes retrieval slow and updates easier * Data redundancy can lead to inconsistency in the database unless controlled. * the system should be aware of any data duplication - the system is responsible for ensuring updates are carried out correctly. * a DB with uncontrolled redundancy can be in an inconsistent state - it can supply incorrect or conflicting information * a given fact represented by a single entry cannot result in inconsistency - few systems are capable of propagating updates i.e. most systems do not support controlled redundancy.
What is important to consider when creating a database?
Memory should be taken into account when building a database and maintain integrity and avoid redundancy through normalization.
Database approach VS traditional approach?
Database Approach vs. Traditional File ProcessingSelf contained nature of database systems (database contains both data and meta-data).Data Independence: application programs and queries are independent of how data is actually stored.Data sharing.Controlling redundancies and inconsistencies.Secure access to database; Restricting unauthorized access.Enforcing Integrity Constraints.Backup and Recovery from system crashes.Support for multiple-users and concurrent access.
What is redundancy and is it good or bad ina database?
Redundancy is when you have the same data in multiple locations. Some redundancy is good, while too much is bad. If two departments are using the exact same data, then this redundancy is bad. It is utilizing excess resources. Redundancy, can be used as a failsafe. Having a backup helps incase of data corruption. The key is too find the right balance of redundancy within a database.
What are five strengths of the database approach?
Reduced data redundancy, Improved data integrity, Shared data, Easier access, Reduced development time
What is replication in database?
it is the process of finding the redundancy.
When working with a database it is important to?
Avoid redundancy, for instance.
DO you have redundancy of records in distributed DBMS?
Redundancy means duplicacy of data or repetitive data. In distributed database case the data is stored in different systems . So the answers is yes there can be redundancy of records / data.In distributed database , data is stored in different systems. Since the data is distributed there is redundancy of records.
What is Controlled redundancy in a database?
In non-database systems each application has its own private files. This can often lead to redundancy in stored data, with resultant waste in storage space. In a database the data is integrated. The database may be thought of as a unification of several otherwise distinct data files, with any redundancy among those files partially or wholly eliminated. Data integration is generally regarded as an important characteristic of a database. The avoidance of redundancy should be an aim, however, the vigour with which this aim should be pursued is open to question. Redundancy is * direct if a value is a copy of another * indirect if the value can be derived from other values: ** simplifies retrieval but complicates update ** conversely integration makes retrieval slow and updates easier * Data redundancy can lead to inconsistency in the database unless controlled. * the system should be aware of any data duplication - the system is responsible for ensuring updates are carried out correctly. * a DB with uncontrolled redundancy can be in an inconsistent state - it can supply incorrect or conflicting information * a given fact represented by a single entry cannot result in inconsistency - few systems are capable of propagating updates i.e. most systems do not support controlled redundancy.
Describe database normalization?
Database Normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency
Does redundancy make updating a database less difficult?
this is true!
What is the repetition of data in a database called?
its called data redundancy.
What were the shortcomings of early file-oriented database structures?
data redundancy
What are to advantages of a database?
A database is a collection of interrelated data and the advantages of a database are ensured efficiency, standardized data, maintainable data, integrated data, reduced redundancy of data.
What is Data redundancy in DBMS?
Data redundancy in DBMS refers to the duplication of data within a database system. This can result in inconsistencies and inefficiencies, as well as consuming more storage space. It is important to minimize data redundancy in order to maintain data integrity and improve performance.
What is important to consider when creating a database?
Memory should be taken into account when building a database and maintain integrity and avoid redundancy through normalization.
