Explanation on data sharing, Database Management System

Assignment Help:

Explanation on Data Sharing?


Related Discussions:- Explanation on data sharing

How is oracle used in pl/sql, How is Oracle used in PL/SQL? Define the feat...

How is Oracle used in PL/SQL? Define the features of process and how they are defined? PL/SQL - PL/SQL is Oracle's procedural language (PL) superset of the Structured

Create database for car application, The Database MySQL scripts cars_f...

The Database MySQL scripts cars_for_sale.sql and car_details.sql containing the data to use for this task have been supplied. To complete this task, you need to first create

Consider relational schema and construct algebra query, Consider the follow...

Consider the following relational schema: PERSON (SS#, NAME, ADDRESS) CAR (REGISTRATION_NUMBER, YEAR, MODEL) ACCIDENT (DATE, DRIVER, CAR_REG_NO) OWNS (SS#, LICENSE) Constru

Consistency, what do you mean by consistency in rdbms?

what do you mean by consistency in rdbms?

Describe participation constraints, Describe Participation Constraints? ...

Describe Participation Constraints? Participation Constraints - The participation constraint exacts whether the existence of an entity depends on its being related to another

Wound-wait scheme-deadlock prevention, " Wound-wait" scheme : It is based o...

" Wound-wait" scheme : It is based on a preemptive method. It is based on a simple rule:                   If Ti requests a database resource that is held by Tj

Which operator is used to compare a value to a list literals, Which operato...

Which operator is used to compare a value to a list of literals values that have been specified? BETWEEN operator is used to compare a value to a list of literals values that h

Conflicting operations in schedule, Conflicting Operations in Schedule: ...

Conflicting Operations in Schedule: The three simple ways of interleaved instruction implement of transactions T1 and T2. Please note that in the following tables the first col

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