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

Explain b-tree, What is B-Tree? A B-tree eliminates the redundant stora...

What is B-Tree? A B-tree eliminates the redundant storage of search-key values .It permits search key values to appear only once.

Explain the integrity constraints, Explain the integrity constraints: Not N...

Explain the integrity constraints: Not Null,  Unique, Primary Key with an example each. Is the combination 'Not Null, Primary Key' a valid combination. Justify. Not Null - Shou

MYSQL, write an SQL statement to create the database in MYSQL server

write an SQL statement to create the database in MYSQL server

Data models, After going by the database architecture, let us now dwell on ...

After going by the database architecture, let us now dwell on an important query: how is the data organised in a database? There are a lot of basic structures that exist in a datab

What are the uses of odbc, What are the uses of ODBC? Under what circumstan...

What are the uses of ODBC? Under what circumstances we use this technology? ODBC expose database capabilities within a standardized way to the application programmer by an ap

Draw an entity-relationship model, Draw an Entity-Relationship model for ...

Draw an Entity-Relationship model for the relational schema given in the Appendix. Show all the entities, relationships, relationship names, and attributes and also underline the

Assigning responsibility for operation, Assigning Responsibility for Operat...

Assigning Responsibility for Operation Many operations might have obvious target objects, but some of these operations could be used at numerous places in an algorithm, by one

Describe the grant function and explain security, Describe the GRANT functi...

Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce

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