explain characteristic of database approach
Main Characteristics of the database approach0diggsdigg- Self-describing nature of a database system.
a fundamental characteristic of the database approach is that the database system contains not only the database structure and constrains. this definition is stored in the system catalog.
A DBMS catalog stores the description of a particular database (e.g. data structures, types, and constraints)
the description is called meta-data
this allows the DBMS software to work with different database application.
- insulation between programs and data.
in traditional file processing, the structures of data files is embedded in the access programs, so many change to the structure of a file may require changing all programs that access this file.
by constraint, DBMS access programs do not require such changes in most cases. the structure of data files is stored in the DBMS catalog separately from the access programs.
we call this property program-data independence
program-data independence: allows changing data structures and storage organization without having to change the DBMS access programs.
- data abstraction.
the characteristic that allows program-data independence and program-operation independence is called data abstraction.
a data model is a type of data abstraction that is used to hide storage details and present the users with a conceptual view of the database.
- support of multiple views of the data.
each user may see a different view of the database, which describes only the data of interest to that user.
a view may be a subset of the database or it may contain virtual data that is derived from the database files but is not explicitly stored.
- sharing of data and multi-user transaction processing.
allowing a set of concurrent users to retrieve from and to update the database.
concurrency control within the DBMS guarantees that each transaction is correctly executed or aborted.
recovery subsystem ensures each completed transaction has its effect permanently recorded in the database.
OLTP (online Transaction Processing) is a major part of database applications. this allows hundreds of concurrent transactions to execute per second.
Data integrity: Ensuring that data stored in the database is accurate and consistent by enforcing constraints, such as unique keys and foreign keys, to prevent invalid data. Scalability: Allowing the database to efficiently handle growing amounts of data and user load by optimizing data storage, indexing, and query performance. Maintainability: Simplifying the process of database maintenance, updates, and modifications by using normalization, clear data modeling, and documenting database structures.
Disposition refers to a person's inherent qualities, characteristics, or tendencies that influence their behavior or attitude towards something. It can also refer to the way in which something is arranged or placed.
A database is considered self-describing because it contains metadata that describes its structure and organization. This metadata includes information about the tables, columns, data types, relationships, and other properties of the database. This allows users and applications to understand and interact with the database without needing external documentation.
Metaphysical naturalism asserts that only natural phenomena exist, while methodological naturalism is a scientific approach that seeks to explain the world through natural causes and methods.
"Point, quote, and explain" is a method of providing evidence or support for a statement or argument. It involves making a point, providing a relevant quote or piece of evidence, and then explaining how the quote supports the point being made. This approach helps to strengthen arguments by backing them up with specific examples or references.
chandranana explain the characteristic of database?
The Database Approach has four common characteristics. These are: Self-describing nature, support multiple user view of data, share the data and multiple user transaction processing and insulation between data and data abstraction.
a) Identify and describe FIVE characteristics of an efficient database
1 Explain architecture of Distributed Database systems? Also, explain the reasons for building distributed database systems?
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.
laleo
•Database approach: approach whereby a pool of related data is shared by multiple application programs; offers significant advantages over traditional file-based approach
what are the advantages of database management approach to the file processing approach Give examples to illustrate your answer
Database is collection of some inter related records . And yes, data redundancy be completely eliminated when database approach is used.
list and explain some important characteristics of a computer?
what are the disadvantages of centralized database system
database