Distributed Database



INTRODUCTION:

◦ Database technology has taken us from a paradigm of data processing in which each application defined and maintained its own data, i.e. one in which data is defined and administered centrally.

◦ In recent times, we have seen the rapid development of network and data communication technology, supported by the internet, mobile and wireless computing, intelligent devices and cloud computing. ◦ Networks and data communication technology is changing the mode of working from centralized to decentralize. The two technologies are causing major developments in the database systems area.

DBMS vrs. DDBMS ◦ DBMS engine supports standalone and centralized database whereas DDBMS engine supports decentralized or distributed database platforms. ◦ Distributed databases bring the advantages of distributed computing to the database management domain. ◦ Distributed databases help us to do distributed computing such as Cloud Computing, Social Media Computing, and Mobile Computing.



DEFINITIONS: ◦ Distributed Databases – A logically interrelated collection of shared data and its metadata physically distributed over a computer network.

◦ Distributed DBMS – The software system that permits the management of the distributed database and makes the distribution transparent to users. ◦ Distributed Computing – Is a field of computer science that studies distributed systems. The software components are shared among multiple computers to improve efficiency and performance. Distributed computing is achieved through support of distributed database concepts and technology.

ADVANTAGE • Low online security threat.

DISADVANTAGES

• Do not allow collaboration and job sharing. • No data replication, unless backup.

ADVANTAGE



Low online security threat.

DISADVANTAGE •

Faulty switch affects network

ADVANTAGES •

Allows collaboration and sharing



One system administrator.

DISADVANTAGES •

Online security threat.



Network failure.



Complete server shutdown prevents access of resources by users.

Nb: Each site has its own database, but can be accessed by others. Also, each site can have more than one computer available.  ADVANTAGES ◦ Allows collaboration and sharing. ◦ Replication of data. ◦ Difficult for complete shutdown.  DISDVANTAGES ◦ High online security threat. ◦ Network failure. ◦ More hardware resources.





     

Each site is capable of independently processing user requests that requires access to local data (e.g. Tamale office). This is called local autonomy. It also has the capability of processing data stored on other computers in the network (such as Kumasi office). Data is split into a number of fragments. Fragments may be replicated. Fragments / replicas of the data are allocated to sites. The data at each site is controlled by the DBMS software. Data across network link is controlled by the DDBMS software. Each DBMS participate (handover) request to DDBMS (global application).



Homogeneous and Heterogeneous Distributed Databases ◦ Homogeneous Distributed Platform: If all the clients, server and local DBMS in all the sited used the same or identical software (oracle products only). ◦ Heterogeneous distributed platform: If different DBMS (oracle, IBM DB2, Sybase) and different client application programs (VB, Java) are connected together. It is said to be heterogeneous (cloud, social media computing are largely heterogeneous).

Next week 11 Cloud computing Database system

Thanks

Database Week 8 - godsonug

database whereas DDBMS engine supports decentralized or distributed database platforms. ◦ Distributed databases bring the advantages of distributed computing to the database management domain. ◦ Distributed databases help us to do distributed computing such as Cloud Computing, Social Media Computing, and.

736KB Sizes 1 Downloads 325 Views

Recommend Documents

Database Week 8 - godsonug
managed compute infrastructure capable of hosting end customer applications and billed by consumption” ... Hybrid Clouds combine both public and private cloud models. With a Hybrid Cloud, service providers can utilize. 3rd party Cloud Providers in

Database Week 8 - godsonug
managed compute infrastructure capable of hosting end customer applications and billed by ... XaaS is quickly emerging as a term that is being readily recognized as services that were previously separated on either private or public ... Definition of

Week 8 - index.xml
Javascript. • Programming Language used in web design. • Unlike PHP, executed client-side! • Javascript code is included in HTML passed to browser.

Week 8 - CS50 CDN
PHP: PHP Hypertext Preprocessor. • When accessed, dynamically generates a webpage which it then outputs to browser. • PHP code enclosed in tag.

Week 8 - index.xml
Big O – Upper bound on runtime. – 'Worst Case' ... First in, last out data structure. • Can 'pop' or ... Database software which allows us to store a collection of data ...

Week 8 - index.xml
Fast Lookup, High Memory Use struct trie_node ... SQL – Structured Query Language. • Database software which ... Server-side execution Client-side execution ...

Challenges Week 8 -
Read In Defense of Food: An Eater's Manifesto by Michael Pollan. Spirituality ... Art Tour. Create and publish a guide for people to tour your favorite art in the city.

TED week 4 -- Database technology.pdf
Sign in. Loading… Whoops! There was a problem loading more pages. Retrying... Whoops! There was a problem previewing this document. Retrying.

MCQ solution week 8.pdf
a) Root mean squared error (RMSE). b) Sum of squared error (SSE). c) Both A and B. d) None of the above. Answer. A. Which is the true assumptions that are made when building decision trees. a) The data can be described by features, such as the featur

Term 4 Week 8.pdf
Phone: 9533 3341 Fax: 9584 2672. [email protected]. www.stjriverwood.catholic.edu.au. Mary MacKillop. St Mary of the Cross. Australia's first ...

8 database design.pdf
obvious. Transformation. Any process that changes data into. information. Page 4 of 69. 8 database design.pdf. 8 database design.pdf. Open. Extract. Open with.

week 8 term 2 .pdf
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. week 8 term 2 .

Term 2 Week 8.pdf
Page 1 of 13. Newsletter : Term 2, Week 7, 22 June 2017. Welcome to New Students. Annika Zhao. Rajesh Freya. Term Dates 2017. Term 2. 1 May - Friday 7 July. Term 3. 24 July - Friday 29 Sep. Term 4. 16 Oct – Friday 15Dec. REMINDER: Any monies due th

week 8 term 3.pdf
stall or activity e.g donation that pays for the whitebait so all is profit,. donation for the equipment for the hair and beauty salon , please let. Chrissy in the school office know- [email protected] or ph. 4488339. • If you or your fami

Term 1 Week 8.pdf
St Joseph's Catholic Primary School. “Work and Pray”. Page 3 of 32. Term 1 Week 8.pdf. Term 1 Week 8.pdf. Open. Extract. Open with. Sign In. Main menu.

Term 2 Week 8.pdf
Have a good fortnight. Lynda Busuttil. Congratulations to Jordan Aquilina who received a Gold Medal in. his recent Karate Tournament. St Joseph's Catholic Primary School. “Work and Pray”. “Blessed are the merciful, for they obtain mercy.” Mat

Term 4 Week 8 Newsletter.pdf
will be deposited into your school banking account. with a Christmas theme. Prizes will be displayed at. School Banking in the Library on Wednesdays 8.15am.

Term 3 Week 8.pdf
mobile phones and instant access to the internet are part and parcel of. daily life for all ages, both at home and at school. Computers are a vital. and absolutely ...

Term 1 Week 8.pdf
Term 1 Week 8 Tuesday 21 March 2017 ... the New Zealand Order of Merit in the Queen's Birthday Honours, for services to education. .... Term 1 Week 8.pdf.

Term 2 Week 8.pdf
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. Term 2 Week 8.

Newsletter week 8.pdf
school donation? Absence TXT Line: 022 351 2655 Text child's first & last name, area, absence reason, sender's name. Hurricanes Visit Last Friday. Hurricanes.

Term 4 Week 8.pdf
Page 1 of 15. St Joseph's. Catholic Primary School. RIVERWOOD. Dear Parents and Caregivers. The end of the school year is fast approaching, yet the beginning of the. Church's liturgical year begins this Sunday with the first Sunday of. Advent. In the

NEWSLETTER - WEEK 2, TERM 2 Tuesday May 8
May 16, 2018 - Tennis—Program for K to Yr 3 : Primrose Park Tennis –David Chapman. 9908 2366. Double Dutch Skipping—Mark Saunders: Available for ...

Week 21 Rev 8 and 9.pdf
8:7)– a supernatural event, with hail and fire and blood that burns up. the green vegetation. i. 1/3 is significant. This is the antichrists-controlled domain.