0
What else can I help you with?
What are the differences between a data administrator and a database administrator?
Depending on the company, they could be the same. But, if they are different, here is the difference:A data administrator is one who oversees the data integrity of the database. They do not create objects and they may not have privileges to do anything other than "view" the data and report any data discrepencies to the database administrator(one who administers the entire database). The data administrator can check data in the tables to make sure there are no errors, can check to see if tables that need an index have one, are all programs valid--stuff like that. The database administrator is usually busy with fixing problems, creating tablespaces, tables, looking at error messages.
Discuss briefly about DBMS?
A database management system (DBMS) is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
What is DBMS and is its function?
A database management system (DBMS) is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
What are the advantages DBMS?
-data redundancy:which reduce the redundancy-repetition of data -security-it provides security for various levels -data sharing-it allows multiple users to access and share the data becomes easier in dbms -data concurrency:it allow multiple users to acess the same data simultaniously
What is data isolation in dbms explain with example?
Data isolation in DBMS refers to the concept of keeping data from interfering with each other in concurrent transactions. This means that changes made by one transaction are not visible to other transactions until they are committed. For example, if two users are updating the same database record simultaneously, data isolation ensures that one user's changes are not visible to the other user until they have both finished their transactions and committed the changes.
What are the differences between a data administrator and a database administrator?
Depending on the company, they could be the same. But, if they are different, here is the difference:A data administrator is one who oversees the data integrity of the database. They do not create objects and they may not have privileges to do anything other than "view" the data and report any data discrepencies to the database administrator(one who administers the entire database). The data administrator can check data in the tables to make sure there are no errors, can check to see if tables that need an index have one, are all programs valid--stuff like that. The database administrator is usually busy with fixing problems, creating tablespaces, tables, looking at error messages.
Discuss briefly about DBMS?
A database management system (DBMS) is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
What is DBMS and is its function?
A database management system (DBMS) is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
What are the advantages of DBMS Approach in managing data?
Advantages of the Database Approach· Data IndependenceThe data is held in such a way that changes to the structure of the database do not effect any of the programs used to access the data.· Consistency of DataEach item of data is held only once therefore no danger of item being updated on one system and not on another.· Control Over RedundancyIn a non-database system, the same information may be held on several files. This wastes space and makes updating more time-consuming. A database system minimizes these effects.Integrity of DataThe DBMS provides users with the ability to specify constraints on data such as making a field entry essential or using a validation routine.Greater Security of DataThe DBMS can ensure only authorized users are allowed access to the data.Centralized Control of DataThe Database Administrator will control who has access to what and will structure the database with the needs of theMore Information Available to UsersUsers have access to a wider range of data that was previously held in separate departments andsometimes on incompatible systems.Increased ProductivityThe DBMS provides an easy to use query language that allows users to get immediate response from their queries rather than having to use a specialist "programmer" to write queries for them. whole department in mind
What is Data redundancy in DBMS?
In database we store data however the can be redundant. Redundancy means repetitive data that is taking extra storage space . So to reduce or prevent the storage space we should eliminate redundancy or just reduce it.
What is data based management system?
A Database Management System (DBMS) is a set of computer programs that controls the creation, maintenance, and the use of a database. It allows organizations to place control of database development in the hands of database administrators (DBAs) and other specialists. A DBMS is a system software package that helps the use of integrated collection of data records and files known as databases. It allows different user application programs to easily access the same database. DBMSs may use any of a variety of database models, such as the network model or relational model. In large systems, a DBMS allows users and other software to store and retrieve data in a structured way. Instead of having to write computer programs to extract information, user can ask simple questions in a query language. Thus, many DBMS packages provide Fourth-generation programming language (4GLs) and other application development features. It helps to specify the logical organization for a database and access and use the information within a database. It provides facilities for controlling data access, enforcing data integrity, managing concurrency, and restoring the database from backups. A DBMS also provides the ability to logically present database information to users.
Discuss the capabilities and features of a database management system dbms what set of functions does a dbms provide give some examples of dbms software?
Features of DBMS A typical DBMS has the following features: • Provides a way to structure data as records, tables, or objects • Accepts data input from operators and stores that data for later retrieval • Provides query languages for searching, sorting, reporting, and other "decision support" activities that help users correlate and make sense of collected data • Provides multiuser access to data, along with security features that prevent some users from viewing and/or changing certain types of information • Provides data integrity features that prevent more than one user from accessing and changing the same information simultaneously • Provides a data dictionary (metadata) that describes the structure of the database, related files, and record information
What are the advantages DBMS?
-data redundancy:which reduce the redundancy-repetition of data -security-it provides security for various levels -data sharing-it allows multiple users to access and share the data becomes easier in dbms -data concurrency:it allow multiple users to acess the same data simultaniously
What is database management sysstem?
A database management system (DBMS) is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. Adatabase is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model orobject model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
What are the diffeneces between a files processing system and a Data base management system?
A database coordinates the physical and logical access to the data; a file-processing system only coordinates physical access to the dataA DBMS reduces the amount of data duplicationA DBMS is designed to allow flexibility in what queries give access to the data, where a file-processing system only allows pre-determined access to data (by specific compiled programs)A DBMS is designed to coordinate and permit multiple users to access data at the same time. A file processing system is much more restrictive in simultaneous data access: http://www.answers.com/in%20dbms%20difference%20between%20file%20processing%20and%20database%20system
What in normal forms in DBMS?
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.
Is a database and a database management system the same why why not?
A database is a collection of data. A database management system controls how those data are collected, stored and retrieved.
