Explanation on data sharing, Database Management System

Assignment Help:

Explanation on Data Sharing?


Related Discussions:- Explanation on data sharing

Define weak and strong entity sets, Define weak and strong entity sets?  ...

Define weak and strong entity sets?  Weak entity  set:  entity  set  that  do not  have  key  attribute  of  their  own are  known as weak entity sets.  Strong entity set

Difference among a primary index and a secondary index, What is the differe...

What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.

Illustrate the class diagram for class room scheduling, Illustrate the clas...

Illustrate the class diagram for class room scheduling system If in any college, the number of classrooms are limited which have to be allocated to various classes and instruct

What is the disadvantage of a call by reference, What is the disadvantage o...

What is the disadvantage of a call by reference? During a call by reference damage or loss of data is not restricted to the subroutine, but will instantly lead to alters to th

Basic set operation, These are the binary operations; i.e., each is applied...

These are the binary operations; i.e., each is applied to two relations or sets. These two relations can be union compatible excluding in case of Cartesian product. Two relations R

Determine advantages of merging an association into a class, What are the a...

What are the advantages and disadvantages of merging an association into a class?  Advantages: i)  Less number of tables ii) Faster performance due to the fewer tables

Define normalization, Normalization :It is a process of examine the given ...

Normalization :It is a process of examine the given relation schemas based on their primary key and Functional Dependencies (FDs) to achieve the properties Minimizing redun

Explain the terms primary key, Explain the terms primary key, candidate key...

Explain the terms primary key, candidate key, alternate key and secondary key. In the given table identify every key? STUDENT(SID,Regno, Name, City) Primary Key: The prim

Give short note on the following terms- dirty pages and etl, Give short not...

Give short note on the following terms:Dirty pages and ETL a.) Dirty pages. These are buffer pages which comprise modifications which haven't been written to disk. b.

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