UNIT 1 Introduction
What is Data?
Data is a collection of a distinct small unit of information. It can be used in a
variety of forms like text, numbers, media, bytes, etc. it can be stored in pieces
of paper or electronic memory, etc.
Data Information
Data is the raw fact. It is a processed form of data.
It is not significant to a business. It is significant to a business.
Data is an atomic level piece of information. It is a collection of data.
Example: Name of student, Marks Example: Report card sheet
It is a phenomenal fact. It is organized data.
This is the primary level of intelligence. It is a secondary level of
intelligence.
May or may not be meaningful. Always meaningful.
Understanding is difficult. Understanding is easy.
What is Database?
A database is an organized collection of data, so that it can be easily accessed
and managed.
You can organize data into tables, rows, columns, and index it to make it easier
to find relevant information.
Database handlers create a database in such a way that only one set of
software program provides access of data to all the users.
,The main purpose of the database is to operate a large amount of information
by storing, retrieving, and managing data.
There are many dynamic websites on the World Wide Web nowadays which
are handled through databases. For example, a model that checks the
availability of rooms in a hotel. It is an example of a dynamic website that uses
a database.
There are many databases available like MySQL,Oracle, MongoDB, Informix,
PostgreSQL, SQL Server, etc.
Modern databases are managed by the database management system (DBMS).
SQL or Structured Query Language is used to operate on the data stored in a
database. SQL depends on relational algebra and tuple relational calculus.
Definition DBMS -
A database is an organized collection of structured information, or data,
typically stored electronically in a computer system. A database is usually
controlled by a database management system (DBMS).
Advantages of Database Management System
Some of the great advantages of DBMS are listed below:
1. Better use of data or information - We can easily and efficiently access
well-managed and synchronized forms of data with the help of DBMS. It
makes data handling simple, provides an integrated perspective of how a
certain business is operating and also aids in keeping track of how one
element of the business affects another portion.
2. Secured Data - The likelihood of security problems increases as a
database becomes more functional and accessible. The danger to data
security rises as a result of the rate at which data is shared or transferred
growing along with the user base. It is frequently utilized in the business
world where organizations spend a lot of time, money, and effort making
sure data is protected and handled effectively. Data management systems
(DBMS) offer a stronger framework for data privacy and security policies,
assisting businesses in enhancing data security.
3. Reduces Data Inconsistency and Redundancy - The major issues faced
during the process of storing data are inconsistency and redundancy.
Inconsistent data may lead to a big loss to an individual or a business
model and the storage capacity is not utilized properly because of the data
redundancy. When multiple copies with different versions or values of
, the same data exist in various locations, then it causes inconsistency.
Data Redundancy and inconsistency can both be significantly decreased
by properly designing a database with the help of a database management
system.
4. Better Recovery and Backups - Backup and recovery are handled
automatically by the DBMS. Users don't need to regularly back up their
data because the DBMS handles this for them. Additionally, it returns the
database to its prior state following a crash or system failure.
5. Fast Data Sharing - Database administration makes it possible for
consumers to access more and better-managed data. DBMS enables end
users to quickly scan their environment and react to any alterations made
there.
6. Helps in decision-making - Because of the well-managed data and
improved data access provided by DBMS, we are able to produce
better-quality information and, as a result, make better judgments.
Accuracy, validity, and the time it takes to read data are all improved by
better data quality. Although DBMS does not ensure data quality, it does
offer a framework that makes it simple to enhance data quality.
7. Increases Privacy - The privacy rule in a database specifies the privacy
restrictions that can only be accessed by authorized users. A user can
only view the data he is permitted to view since there are different degrees
of database access. For instance, on social networking sites, different
accounts that a user wishes to access have varying access restrictions and
a user can only see his/her account details, not others.
8. User Friendly - Data are presented in a straightforward and logical
manner by database management systems (DBMS). It is simple to carry
out many activities, such as the addition, deletion, or creation of files or
data. ( we modify the content)
9. Data Abstraction - In order to give users an abstract overview of the
data, database systems are primarily used. Since numerous intricate
algorithms are employed by developers to boost the effectiveness of
databases that are concealed from users by several degrees of data
abstraction, consumers can easily engage with the system.
Database Applications
Nowadays, any business that has small or large amounts of data needs a
database to store and manage the information. The database is an easy, reliable,
secure, and efficient way to maintain business information.
What is Data?
Data is a collection of a distinct small unit of information. It can be used in a
variety of forms like text, numbers, media, bytes, etc. it can be stored in pieces
of paper or electronic memory, etc.
Data Information
Data is the raw fact. It is a processed form of data.
It is not significant to a business. It is significant to a business.
Data is an atomic level piece of information. It is a collection of data.
Example: Name of student, Marks Example: Report card sheet
It is a phenomenal fact. It is organized data.
This is the primary level of intelligence. It is a secondary level of
intelligence.
May or may not be meaningful. Always meaningful.
Understanding is difficult. Understanding is easy.
What is Database?
A database is an organized collection of data, so that it can be easily accessed
and managed.
You can organize data into tables, rows, columns, and index it to make it easier
to find relevant information.
Database handlers create a database in such a way that only one set of
software program provides access of data to all the users.
,The main purpose of the database is to operate a large amount of information
by storing, retrieving, and managing data.
There are many dynamic websites on the World Wide Web nowadays which
are handled through databases. For example, a model that checks the
availability of rooms in a hotel. It is an example of a dynamic website that uses
a database.
There are many databases available like MySQL,Oracle, MongoDB, Informix,
PostgreSQL, SQL Server, etc.
Modern databases are managed by the database management system (DBMS).
SQL or Structured Query Language is used to operate on the data stored in a
database. SQL depends on relational algebra and tuple relational calculus.
Definition DBMS -
A database is an organized collection of structured information, or data,
typically stored electronically in a computer system. A database is usually
controlled by a database management system (DBMS).
Advantages of Database Management System
Some of the great advantages of DBMS are listed below:
1. Better use of data or information - We can easily and efficiently access
well-managed and synchronized forms of data with the help of DBMS. It
makes data handling simple, provides an integrated perspective of how a
certain business is operating and also aids in keeping track of how one
element of the business affects another portion.
2. Secured Data - The likelihood of security problems increases as a
database becomes more functional and accessible. The danger to data
security rises as a result of the rate at which data is shared or transferred
growing along with the user base. It is frequently utilized in the business
world where organizations spend a lot of time, money, and effort making
sure data is protected and handled effectively. Data management systems
(DBMS) offer a stronger framework for data privacy and security policies,
assisting businesses in enhancing data security.
3. Reduces Data Inconsistency and Redundancy - The major issues faced
during the process of storing data are inconsistency and redundancy.
Inconsistent data may lead to a big loss to an individual or a business
model and the storage capacity is not utilized properly because of the data
redundancy. When multiple copies with different versions or values of
, the same data exist in various locations, then it causes inconsistency.
Data Redundancy and inconsistency can both be significantly decreased
by properly designing a database with the help of a database management
system.
4. Better Recovery and Backups - Backup and recovery are handled
automatically by the DBMS. Users don't need to regularly back up their
data because the DBMS handles this for them. Additionally, it returns the
database to its prior state following a crash or system failure.
5. Fast Data Sharing - Database administration makes it possible for
consumers to access more and better-managed data. DBMS enables end
users to quickly scan their environment and react to any alterations made
there.
6. Helps in decision-making - Because of the well-managed data and
improved data access provided by DBMS, we are able to produce
better-quality information and, as a result, make better judgments.
Accuracy, validity, and the time it takes to read data are all improved by
better data quality. Although DBMS does not ensure data quality, it does
offer a framework that makes it simple to enhance data quality.
7. Increases Privacy - The privacy rule in a database specifies the privacy
restrictions that can only be accessed by authorized users. A user can
only view the data he is permitted to view since there are different degrees
of database access. For instance, on social networking sites, different
accounts that a user wishes to access have varying access restrictions and
a user can only see his/her account details, not others.
8. User Friendly - Data are presented in a straightforward and logical
manner by database management systems (DBMS). It is simple to carry
out many activities, such as the addition, deletion, or creation of files or
data. ( we modify the content)
9. Data Abstraction - In order to give users an abstract overview of the
data, database systems are primarily used. Since numerous intricate
algorithms are employed by developers to boost the effectiveness of
databases that are concealed from users by several degrees of data
abstraction, consumers can easily engage with the system.
Database Applications
Nowadays, any business that has small or large amounts of data needs a
database to store and manage the information. The database is an easy, reliable,
secure, and efficient way to maintain business information.
