Explanation on data sharing, Database Management System

Assignment Help:

Explanation on Data Sharing?


Related Discussions:- Explanation on data sharing

Define the boyce-codd normal form, Define the Boyce-Codd Normal Form with i...

Define the Boyce-Codd Normal Form with instance and also Compare BCNF and 3NF.  Ans: BCNF: For each functional dependency X->Y in a set F of functional dependencies over relati

What is a database graph, What is a database graph? The partial orderin...

What is a database graph? The partial ordering implies that the set D may now be viewed as a directed acyclic graph, known as a database graph.

Explain the object-oriented decomposition, Explain the Object-oriented deco...

Explain the Object-oriented decomposition Object-oriented decomposition targets at identifying individual sovereign objects that encapsulate both a state and certain behavio

How many types of data independence have, Types of data independence D...

Types of data independence Data independence can be classified into the following two types: Physical Data Independence: This means that for any change made in the physi

Explain about sql server 2000, What is the difference between SQL Server 2...

What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the whole database. A differential backup creates a copy of

Why object-oriented system use the relational dbms, Why, generally does an ...

Why, generally does an object-oriented system use the relational DBMS? The reasons for using relational DBMS for OO systems could be any combination of following: a. Many or

Process-oriented decompositions, Process-oriented decompositions Pr...

Process-oriented decompositions Process-oriented decompositions divide complex process, task or function into simpler sub processes until they get simple enough to be deal

Mention the various user privileges, Mention the various user privileges ...

Mention the various user privileges All privileges directly granted to the user or role. All privileges granted to roles that have been granted to the user or role.

What is meant by heuristic optimisation, What is meant by heuristic optimis...

What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.

12/5/2013 4:35:24 AM

A. Data without sharing:
The mainly significant difference between a file-based system and a database system is that data are shared.

There are three kinds of data sharing:

(i)Sharing between Functional Units: The data sharing proposes that people in various functional areas use common pool of data, each of their own requests. Without data sharing marketing group might have their data files, purchasing group theirs, accounting group theirs and so on. Each group benefits only from its own data. The combined data are more important than sum of the data in separate files. Not only does each group carry on to have way in to its own data but, within reasonable restrictions of control, they have entrance to other data as well. The concept of merge data for common use is known as data integration.

(ii)sharing data between Different Levels of Users: Different levels of users need to share data.
Three different points of users are normally distinguished: operations, middle management and executive. These levels correspond to three different types of automated business systems that have evolved during past three decades:


a.) Electronic Data Processing (EDP): EDP was first applied to the lower operational levels of the organization to automate paperwork. Its basic characteristics include:
1. ) A focus on data, storage, processing and flows at operational level.
2. ) Efficient t transaction processing.
3. ) Summary reports for management.

b. Management Information System (MIS): The MIS approach elevated the focus on information systems activities with additional emphasis on integration and planning of information systems function. This includes following points:

1. ) An information focus aimed at middle managers.
2. ) An integration of EDP jobs by business function such as production MIS, marketing MIS, Personnel MIS.
3. ) Inquiry and report generation usually with database.
c. Decision Support System: DSS is focused still senior in the organization with emphasis on the following characteristics:


1. ) Decision focused, aimed at top managers and executive decision creators.

iii)sharing data between Different Locations: A company with several locations has important data dist rebutted over a wide geographical area. Sharing these data is an important problem.

A middle database is actually confined to a single location, controlled by a single computer. Most functions for databases are formed are accomplished more simply if database is centralized. That is, it is easier to revise, back up, query and control access to a database if we know accurately where it is and what software controls it.

A distributed database system is made up of some database systems running at local sites linked by communication lines. A query is then no longer a single process controlled by one software module, but a set of cooperating methods running at some sites controlled by independent software modules. For a distributed database system to function efficiently adequate communication technology have to be available and the DBMS in system must be able to communicate while interacting with communications facilities.

 

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd