Assalamualaikum and Salam Sejahtera,
This week En. Abd Razak teach us about data management. Data is very important to be stored and cared properly. Losing data may cause we lose our source of information. Too large data must be managed well. Using DBMS can help us simplify data management and reduce the cost of data storage.
Data Management Definition:
Problem With Traditional Files:
The traditional file system had suffered a number disadvantage as firms tended to grow day by day. The problems with traditional file environment include :
Data redundancy:
Data redundancy is the presence of duplicate data in multiple data files
Program data dependence:
Program data dependence is the tight relationship between data stored in files and the specific programs required to update and maintain those files.
Lack of flexibility:
lack of flexibility is a traditional file system can deliver routine scheduled reports after extensive programming efforts but it can not deliver ad hoc reports or respond to unanticipated information requirement in a timely fashion.
Poor security:
Because there is little control or management of data, access to information may be out of control.
Lack data sharing and availability:
Lack of control in accessing data and not easy to retrieve the information
DBMS
Advantages of DBMS
The advantages of DBMS are as follows:
Disadvantages of DMS
The disadvantages are as follows:
- Data Management is a broad field of study, but essentially is the process of managing data as a resource that is valuable to an organization or business.
- Administrative process by which the required data is acquired, validated, stored, protected, and processed, and by which its accessibility, reliability, and timeliness is ensured to satisfy the needs of the data users.
Problem With Traditional Files:
The traditional file system had suffered a number disadvantage as firms tended to grow day by day. The problems with traditional file environment include :
Data redundancy:
Data redundancy is the presence of duplicate data in multiple data files
Program data dependence:
Program data dependence is the tight relationship between data stored in files and the specific programs required to update and maintain those files.
Lack of flexibility:
lack of flexibility is a traditional file system can deliver routine scheduled reports after extensive programming efforts but it can not deliver ad hoc reports or respond to unanticipated information requirement in a timely fashion.
Poor security:
Because there is little control or management of data, access to information may be out of control.
Lack data sharing and availability:
Lack of control in accessing data and not easy to retrieve the information
DBMS
- A software system that facilitates the creation and maintenance and use of an electronic database.
- A database management system (DBMS) is a software package with computer programs that control the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications by database administrators (DBAs) and other specialists.
- (DBMS) is computer software designed for the purpose of managing databases. Typical examples of DBMSs include Oracle, DB2, Microsoft Access, Microsoft SQL Server, Firebird, PostgreSQL, MySQL, SQLite, FileMaker and Sybase Adaptive Server Enterprise. DBMSs are typically used by Database administrators in the creation of Database systems. (Wikipedia, 2008)
 |
Advantages of DBMS
The advantages of DBMS are as follows:
- Controlling redundancy
- Providing storage structure for efficient query processing.
- Restricting unauthorized users.
- Providing concurrency.
- Providing backup and recovery.
- Enforcing integrity constraints.
Disadvantages of DMS
The disadvantages are as follows:
- Centralization:That is use of the same program at a time by many user sometimes lead to loss of some data.
- High cost of software.
- Technical experties are required
No comments:
Post a Comment