Data: Data is a collection of row facts such as telephone
numbers, a birth data (or) names. Data
have little meaning unless they have been organized in same logical manner.
Field: A character
(or) group of characters that has a specific meaning is used to define and
store data.
Eg: S.No
S.name s.add
Record: A logically
connected set of one or more fields that describes a person, places (or) thing
File: File is a
collection of related records
Information: The data
that have been processed in such a way as to increase the knowledge of the
person who uses the data processed data is called information.
Data Name: It is name(identifier)
that is given to data
Eg: Marks is a data name
given to 72, which are marks of a student.
Mata data:
Data that describes
the properties were are characteristics of other data is called meta data.
Data vs Information:
Data:
1. Raw facts; building blocks of information
2. Unprocessed information
Information:
1. Data processed to reveal meaning
2. Accurate, relevant, and timely information is key to good
decision making.
3. Good decision making is key to survival in global
environment
Data base:
Data base is a
structured collection of records (or) data that is stored in a computer system.
Usually contains
software so that a person or program can use it to answer Queries (or) extract
desired information.
Data Base refers to
the collection of related record and software should be referred to as the database
management.
Data Base Management System:
A DBMS is a software system that is used to
create, maintain and controlled access to user database. A DBMS provides a systematic method of
creating, Updating, Storing and Retrieving data in a database.
The primary goal of
a DBMS is to provide an environment that is both convenient and efficient to
use in retrieving and storing database information. Data base systems are designed to manage
large bodies of information.
The management of
data involves both the definition of structure for the storage of information
and the profession of mechanisms for the manipulation of information.
A for Examples of Data Base Applications are
1. Automatic teller machines (ATM)
2. Flight reservation systems
3. Computerized inventory systems
4. Computerized library systems
Why data base is important:
Database design refers to the activities that focus on the design of the data base structure that will be used store and managed the user data.
Suppose to store the data of a student, the data base designer should have the complete details of a student.
A Data base that meets all user requirements should be designed carefully. Data base design is an important aspect of working with data bases.
Proper data base design requies the designer to identify the data base to the user a well designed data base provides accurate and valuable information.
File Processing System:
A file processing system contains various files and a number of application program to operate on these files.
The file processing system as a no. of disadvantage as follows:
1. Data Redundancy:
Redundancy refers to the duplication of data. When file processing system was used same piece of information may be duplicated in several files and leads to Redundancy which leads to higher storage cost.
2. Data Inconsistency:
Inconsistency means irregularity or un reliability In a file processing any changes one file, does not effect the other file that was linked with the previous file.
3. Difficulty in accessing data:
In the processing system for each operation to be made a separate program or function is to be implemented for example let a program displays the customer details of SB account holders. If a user holders whose balance is less than 1000 rupees then separate function is to written for this purpose. Thus the convectional file processing system does not allow required data to be required inconvenient and efficient manner.
4. Data Isolation:
As the data was spread over the function file processing system it is difficult to write new application program to retrieve appropriate data.
5. Concurrent Access Anomalies:
While accessing data simultaneously in a file process system some anomalies may occur. For example tries to update an account at very much same time then instead of accessing both updates only either of one transaction can be done.
6. Atomicity problem:
Let a sum of thousand rupees is to be deducted from account A and to be added into account B after deducting the amount from account A if the system failure (or) program failure was occurred. Then the transaction will be left in inconsistent state. In file processing system this operation cannot be roll back
7. Integrity Problems:
While handling data some constraints may be present such as maintaining minimum balance, providing not null etc. When these constraints are to be added (or) modified then the application program is to be modified which is very much difficult in file processing system.
8. Security Problems:
In file processing system any software developer (or) users are able to invoke function regarding transactions, and hence the operation are not restricted and hence less security.
Database system:
A database system aims to achieve a highly organized collection of data along with appropriate tools and applications that facilitate processing and access to that data.
Most people confuse a database system with a database management system, but the two are different. A DBMS is a suite of software tools used to store and manipulate data. Database management systems come in different types, such as document store, file store and relational database management systems.
The most advanced and highly popular type of DBMS is the relational database management system. Oracle, Microsoft SQL Server, MySQL, and PostgreSQL are all examples of popular RDBMSs.
Why data base is important:
Database design refers to the activities that focus on the design of the data base structure that will be used store and managed the user data.
Suppose to store the data of a student, the data base designer should have the complete details of a student.
A Data base that meets all user requirements should be designed carefully. Data base design is an important aspect of working with data bases.
Proper data base design requies the designer to identify the data base to the user a well designed data base provides accurate and valuable information.
A file processing system contains various files and a number of application program to operate on these files.
The file processing system as a no. of disadvantage as follows:
1. Data Redundancy:
Redundancy refers to the duplication of data. When file processing system was used same piece of information may be duplicated in several files and leads to Redundancy which leads to higher storage cost.
2. Data Inconsistency:
Inconsistency means irregularity or un reliability In a file processing any changes one file, does not effect the other file that was linked with the previous file.
3. Difficulty in accessing data:
In the processing system for each operation to be made a separate program or function is to be implemented for example let a program displays the customer details of SB account holders. If a user holders whose balance is less than 1000 rupees then separate function is to written for this purpose. Thus the convectional file processing system does not allow required data to be required inconvenient and efficient manner.
4. Data Isolation:
As the data was spread over the function file processing system it is difficult to write new application program to retrieve appropriate data.
5. Concurrent Access Anomalies:
While accessing data simultaneously in a file process system some anomalies may occur. For example tries to update an account at very much same time then instead of accessing both updates only either of one transaction can be done.
6. Atomicity problem:
Let a sum of thousand rupees is to be deducted from account A and to be added into account B after deducting the amount from account A if the system failure (or) program failure was occurred. Then the transaction will be left in inconsistent state. In file processing system this operation cannot be roll back
7. Integrity Problems:
While handling data some constraints may be present such as maintaining minimum balance, providing not null etc. When these constraints are to be added (or) modified then the application program is to be modified which is very much difficult in file processing system.
8. Security Problems:
In file processing system any software developer (or) users are able to invoke function regarding transactions, and hence the operation are not restricted and hence less security.
Database system:
A database system aims to achieve a highly organized collection of data along with appropriate tools and applications that facilitate processing and access to that data.
Most people confuse a database system with a database management system, but the two are different. A DBMS is a suite of software tools used to store and manipulate data. Database management systems come in different types, such as document store, file store and relational database management systems.
The most advanced and highly popular type of DBMS is the relational database management system. Oracle, Microsoft SQL Server, MySQL, and PostgreSQL are all examples of popular RDBMSs.

No comments:
Post a Comment