Question

In: Accounting

What are the two main approaches (from a systems management/control perspective), to data management? Your answer...

What are the two main approaches (from a systems management/control perspective), to data management? Your answer should include a brief definition of each and the main differences in the approaches and the major advantages of the data base approach to data management over the file-oriented approach to data processing.)

Solutions

Expert Solution

The two main approaches (from a systems management/control perspective), to data management are:

1. Data Base approach and

2. File Oriented approach.

What is Database Approach (DBMS) : A Database Management System (DBMS) is a system software that allows users to efficiently define, create, maintain and share databases. Defining a database involves specifying the data types, structures and constraints of the data to be stored in the database. Creating a database involves storing the data on some storage medium that is controlled by DBMS. Maintaining a database involves updating the database whenever required to evolve and reflect changes in the miniworld and also generating reports for each change. Sharing a database involves allowing multiple users to access the database

What is File Oriented Approach: A File Management system is a DBMS that allows acces to single files or tables at a time. In a File System, data is directly stored in set of files. It contains flat files that have no relation to other files (when only one table is stored in single file, then this file is known as flat file).

Advantage of DBMS over file system:There are several advantages of Database management system over file system:

No redundant data: Redundancy removed by data normalization. No data duplication saves storage and improves access time.

Data Consistency and Integrity: As we discussed earlier the root cause of data inconsistency is data redundancy, since data normalization takes care of the data redundancy, data inconsistency also been taken care of as part of it

Data Security: It is easier to apply access constraints in database systems so that only authorized user is able to access the data. Each user has a different set of access thus data is secured from the issues such as identity theft, data leaks and misuse of data.

Privacy: Limited access means privacy of data.

Easy access to data: Database systems manages data in such a way so that the data is easily accessible with fast response times.

Easy recovery: Since database systems keeps the backup of data, it is easier to do a full recovery of data in case of a failure.

Flexible: Database systems are more flexible than file processing systems.


Related Solutions

There are two control approaches: PLCs, Distributed Control Systems (DCS). Explain them and then answer the...
There are two control approaches: PLCs, Distributed Control Systems (DCS). Explain them and then answer the following question: What are the reasons to choose one over the other? Attention: 1)your answer at least one scientific paper source (i.e. it is NOT websites) 2)Only one page is required.
Trust-based relationships Instructions: answer the questions below based on your perspective from Part Two. 1. What...
Trust-based relationships Instructions: answer the questions below based on your perspective from Part Two. 1. What is the status of my relationships with key project team members and customers? List one key project team member and one customer (internal or external customer) and discuss the nature and state of the relationships. 2. Which relationships cause me the most pain (friction, confrontation, dishonesty, etc.)? List the relationships and pain points. 3. Which specific actions can I take to turn the troubled...
Topic: parasite diseases, prevention approaches, control and future perspective ( Please write a review for this...
Topic: parasite diseases, prevention approaches, control and future perspective ( Please write a review for this topic )
Managers are often required to create a budget, from the perspective of management, answer the following...
Managers are often required to create a budget, from the perspective of management, answer the following questions: 1. How can the process of creating a budget benefit a manager? 2. For each activity a manager includes in a budget, should the activity be evaluated as a change from last budget period or with a blank slate? a) Pros and Cons of zero-base budget (blank slate)? b) Pros and Cons of updating last period’s budget? 3. The budget communicates objectives across...
There are two main organising approaches to industrial economics. Identify these two approaches and explain how...
There are two main organising approaches to industrial economics. Identify these two approaches and explain how they differ.
What is the difference between statistical process control and randomized control trial?  How are the two approaches...
What is the difference between statistical process control and randomized control trial?  How are the two approaches similar?
1. Describe two key difference between digital control systems and their analog counterparts. Your answer should...
1. Describe two key difference between digital control systems and their analog counterparts. Your answer should include both a block diagram and a discussion on key design choices in each topology.
6D2. From an economic perspective, are unions efficient or otherwise? Give reasons for your answer. What...
6D2. From an economic perspective, are unions efficient or otherwise? Give reasons for your answer. What objectives do unions serve? Are there other, more economically efficient, methods to achieve these objectives? What might those methods be?
What distinguishes enterprise risk management from more traditional approaches to risk management?
What distinguishes enterprise risk management from more traditional approaches to risk management?
Philosopher Thomas Nagel approaches the issue of what is sexually natural from a different perspective than...
Philosopher Thomas Nagel approaches the issue of what is sexually natural from a different perspective than that of our other authors. Nagel defines what is sexually natural in terms of the double reciprocal incarnation or the Romeo and Juliet Model. In your post, explain how Nagel's theory of what is sexually natural differs from two of the other theories of what is sexually natural. You do NOT need to list the steps in the Romeo and Juliet Model in your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT