Explanation on data sharing, Database Management System

Assignment Help:

Explanation on Data Sharing?


Related Discussions:- Explanation on data sharing

Management information system, Explain the challenges before an E-business ...

Explain the challenges before an E-business management.

Datamodels, explain thee diffrent types of data models

explain thee diffrent types of data models

What is multilevel index, Multilevel Index The Multilevel Index is a m...

Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve

OLD HOME POLICIES, Write an sql statement to find what is the percentage of...

Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.

Join relation of two tuples, Consider the join of a relation R with relatio...

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is: If R has m tuples and S has n tuples then maximum siz

Illustrate the state model for the atm class, Illustrate the State model fo...

Illustrate the State model for the ATM class let us take state model for the ATM class given below in Figure showing state model of the ATM class and the pseudo code derived fr

Dependency preservation, Dependency Preservation It is obvious that the...

Dependency Preservation It is obvious that the decomposition must be lossless so that we do not lose any information from the relation that is decomposed. Dependency preservati

Need ssd information database completion for wp website, We are looking to ...

We are looking to find someone to prepare a database which improves upon the one we are using at present. The present database will be found here: Click on filter options and yo

Union - basic set operation, UNION If R1 and R2 are two union compatibl...

UNION If R1 and R2 are two union compatible relations then R3 = R1 ∪ R2 is the relation having tuples that are either in R1 or in R2 or in both. In case, R3 will have tuples

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