INTRODUCING THE DATABASE
Introducing the Database
Efficient data management typically requires the use of a computer database. A database is a shared,
integrated computer structure that stores a collection of:
The end user stands in contrast to users who support or maintain the product, such as system operators,system administrators, database administrators, information technology experts, software professionals and computer technicians.
End User
An end user is the person that a software program or hardware device is designed for. The term is based on the idea that the "end goal" of a software or hardware product is to be useful to the consumer. The end user can be contrasted with the developers or programmers of the product. End users are also in a separate group from the installers or administrators of the product
Introducing the Database
Efficient data management typically requires the use of a computer database. A database is a shared,
integrated computer structure that stores a collection of:
End-user data-that is, raw facts of interest to the end user.
Metadata, or data about data-through which the end-user data are integrated and managed.
Metadata of a Document
Metadata summarizes basic information about data, which can make finding and working with particular instances of data easier. For example, author, date created and date modified and file size are examples of very basic document metadata.
Metadata in Our Case
The metadata provide a description of the data characteristics and the set of relationships that links the data found within the database. For example,
A database management system (DBMS)
DBMS is a collection of programs that manages the database structure and controls access to the data
stored in the database. In a sense, a database resembles a very well-organized electronic filing cabinet in which powerful software, known as a database management system, helps manage the
cabinet’s contents.
Role and Advantages of the DBMS
The DBMS serves as the intermediary between the user and the database. The database structure itself is stored as a collection of files, and the only way to access the data in those files is through the DBMS
Role and Advantages of the DBMS
DBMS presents the end user (or application program) with a single, integrated view of the data in the database. The DBMS receives all application requests and translates them into the complex operations required to fulfill those requests. The DBMS hides much of the database’s internal complexity from the application programs and users.The application program might be written by a programmer using a programming language such as Visual Basic. NET,Java, or C#, or it might be created through a DBMS utility program.
Having a DBMS between the end user’s applications and the database offers some important advantages.DBMS enables the data in the database to be shared among multiple
applications or users.Second, the DBMS integrates the many different users’ views of the
data into a single all-encompassing data repository.
 |
| cpoyright-https://www.kohezion.com/ |
Efficient data management typically requires the use of a computer database. A database is a shared,
integrated computer structure that stores a collection of:
- End-user data
- Metadata
The end user stands in contrast to users who support or maintain the product, such as system operators,system administrators, database administrators, information technology experts, software professionals and computer technicians.
End User
An end user is the person that a software program or hardware device is designed for. The term is based on the idea that the "end goal" of a software or hardware product is to be useful to the consumer. The end user can be contrasted with the developers or programmers of the product. End users are also in a separate group from the installers or administrators of the product
Introducing the Database
Efficient data management typically requires the use of a computer database. A database is a shared,
integrated computer structure that stores a collection of:
End-user data-that is, raw facts of interest to the end user.
Metadata, or data about data-through which the end-user data are integrated and managed.
Metadata of a Document
Metadata summarizes basic information about data, which can make finding and working with particular instances of data easier. For example, author, date created and date modified and file size are examples of very basic document metadata.
Metadata in Our Case
The metadata provide a description of the data characteristics and the set of relationships that links the data found within the database. For example,
- The metadata component stores information such as the name of each data element
- The type of values (numeric, dates, or text) stored on each data element
- Whether or not the data element can be left empty,
- The metadata provide information that complements and expands the value and use of the data.
- In short, metadata present a more complete picture of the data in the database. Given the characteristics of metadata, you might hear a database described as a “collection of self-describing data.”
A database management system (DBMS)
DBMS is a collection of programs that manages the database structure and controls access to the data
stored in the database. In a sense, a database resembles a very well-organized electronic filing cabinet in which powerful software, known as a database management system, helps manage the
cabinet’s contents.
Role and Advantages of the DBMS
The DBMS serves as the intermediary between the user and the database. The database structure itself is stored as a collection of files, and the only way to access the data in those files is through the DBMS
Role and Advantages of the DBMS
DBMS presents the end user (or application program) with a single, integrated view of the data in the database. The DBMS receives all application requests and translates them into the complex operations required to fulfill those requests. The DBMS hides much of the database’s internal complexity from the application programs and users.The application program might be written by a programmer using a programming language such as Visual Basic. NET,Java, or C#, or it might be created through a DBMS utility program.
Having a DBMS between the end user’s applications and the database offers some important advantages.DBMS enables the data in the database to be shared among multiple
applications or users.Second, the DBMS integrates the many different users’ views of the
data into a single all-encompassing data repository.
Improved data sharing
Improved data security
Better data integration
Minimized data inconsistency
Improved data access
Improved decision making
Increased end-user productivity
..............................................................................................
END
More details:-https://www.youtube.com/watch?v=d11viALaCvA
Comments
Post a Comment