WEEK 13 (DATA MANAGEMENT)

Data Management Definition

•  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

SUMMARY :

In this topic, I learned that the powerful of DBMS that will help us to manage a huge data. This is give us opportunity to manage the data easily and in a systematic ways.