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

Sorting field groups we cannot use more than one key field, While sorting f...

While sorting field groups we cannot use more than one key field False.

What is dml, What is DML (Data Manipulation Language)? This language th...

What is DML (Data Manipulation Language)? This language that enable user to access or manipulate data as organised by appropriate data model. Procedural DML or Low level: DM

Explain thomas write rule, Explain Thomas' Write rule.  Show how it is diff...

Explain Thomas' Write rule.  Show how it is different from timestamp ordering protol Ans: In timestamp-based concurrency control the thomas Write rule is a rule. Given a Timest

Create a subroutine, 1. Create a subroutine that does the remote blast on t...

1. Create a subroutine that does the remote blast on the file protein.fa. 2. Pass that returned files from the blast to another subroutine that parses the output and sends it to

Distributed control and data sharing , Distributed Control and Data sharing...

Distributed Control and Data sharing: The geographical distribution of an organization can be showed in the distribution of the data; if a number of different sites are linked to e

How can we classify the operations on classes, How can we Classify the oper...

How can we Classify the operations on classes  This step fundamentally means all three models functional, object and dynamic (studied in last section) must be combined so that

Display how records can be deleted and updated in qbe, With the help of an ...

With the help of an example display how records can be deleted and updated in QBE. (i) Increase Pay_Rate of employees along with the skill of ‘cook' by 10%. (ii) Delete employee

Command line interfaces, Command Line Interfaces: These are interactive int...

Command Line Interfaces: These are interactive interfaces, character-based that let you use the complete power and functionality of the DBMS query language directly. They permit yo

Define dba database administrator, Define DBA database administrator? ...

Define DBA database administrator? DBA : A database administrator (DBA) is a person who is responsible for the environmental aspects of a database. In common, these involves:

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