Explain in details about data sharing, Database Management System

Assignment Help:

Explain in details about Data Sharing


Related Discussions:- Explain in details about data sharing

Need for distributed database systems, Need For Distributed Database System...

Need For Distributed Database Systems A distributed database is a set of database kept on multiple computers that appears to applications as a one database. As a result, an app

What is the difference between primary key and a unique key, What's the dif...

What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim

Illustrate about the advanced object design, Illustrate about the advanced ...

Illustrate about the advanced object design Advanced object design is a complex task. The objects discovered through analysis serve as a skeleton of design. The operations reco

Define boyce codd normal form, Define Boyce codd normal form A relation...

Define Boyce codd normal form A relation schema R is in BCNF with respect to a set F of functional dependencies if, for all functional dependencies in F + of the form.α ->β.

What is index, What is Index? An index is a physical structure having p...

What is Index? An index is a physical structure having pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possibl

What is a state chart diagram, What is a state chart diagram? State dia...

What is a state chart diagram? State diagrams (State Chart Diagram) explain all possible states that a particular object can get into, and how object's state changes as result

12/5/2013 4:31:59 AM

(A).Data without sharing:
The most significant variation between file-based system and a database system is that data are shared.

There are three types of data sharing as follows:
(i.). sharing between functional Units: The data sharing suggests that people in different functional areas use general pool of data, each of their own applications. Lacking data sharing, the marketing group should have their data files, purchasing group theirs, accounting group theirs and so on. Each set benefits only from its own data. The combined data are additional valuable than the sum of data in separate files. Not only each group continue to have access to its own data but, within practical restrictions of control, they have way in to other data. The concept of combining data for common use is known as data integration.

(ii.). sharing data between different Levels of Users: Dissimilar levels of users need to share data.
Three different levels of users are usually distinguished: operations, middle management and executive. These levels correspond to the three unlike types of automated business systems that have evolved all through the 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 these following points:
(1.). a focus on data, storage, processing and flows at operational level.
(2.). efficient 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 addition and planning of the information systems function. This includes:

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

(1.). decision focused, aimed at top managers and executive decision creators.
(2.). emphasis on flexibility, adaptability and fast response.
(3.). support for personnel decision-making styles of individual mangers.

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

A centralized database is actually confined to a single location, controlled by a single computer. Mainly functions for databases are formed are accomplished added easily if database is centralized. That is, it is easier to inform, back up, query and control access to database if we know exactly where it is and what software controls it.

A distributed database system is made up of some database systems running at local sites connected by communication lines. A query is then no longer a single course controlled by one software module, but the set of cooperating processes running at several sites controlled by independent software modules. For a dispersed database system to function efficiently, adequate communication technology has to be available and the DBMS in the system has to 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