CS2029 Advanced Database Technology Anna University question paper - November/December 2014

CS2029 Advanced Database Technology question paper - November/December 2014 / Anna University Previous Year 2014 Exam Questions for Advanced Database Technology with Answers / Anna University Previous Year 2014 Computer Science and Information Technology Question Papers / CS 606 Advanced Database Technology Question Paper / CS2029 Sixth Semester Advanced Database Technology question / CS2029 CS606 Question paper with answers

Question Paper Code : 91325

B.E./B.Tech. DEGREE EXAMINATION, NOVEMBER/DECEMBER 2014

Sixth Semester

Computer Science and Engineering

CS 2029/CS 606/10144CSE 23 — ADVANCED DATABASE TECHNOLOGY

(Common to Seventh Semester Information Technology)

(Regulation 2008/2010)

(Common to PTCS 2029/10144 CSE 23 – Advanced Database Technology for B.E.

(Part-Time) Fifth/Sixth Semester – CSE – Regulation 2009/2010)

Time : Three Hours                                                          Maximum : 100 marks

Answer ALL Questions

PART A – (10 X 2 = 20 marks)

1. Define query processing.

2. Mention the use of database tuning.

3. State any two features of distributed database.

4. Define concurrency control.

5. What is the use of JASMINE model?

6. Write any two features of POSTGRES model.

7. Define data mining.

8. Mention main difference between mobile and web database.

9. What is multimedia database?

10. Give any features of spatial database.

PART B – (5 X 16 = 80 marks)

11. (a) (i) Explain about third normal form and BCNF with an example. (8)

(ii) Discuss query optimization briefly. (8)

Or

(b) (i) Write short note on transaction processing. (8)

(ii) Discuss two phase locking protocol technique for concurrency in detail. (8)

12. (a) Discuss aboutinterquery and intraquery parallelism with example. (16)

Or

(b) (i) Explain the architecture of Distributed database with a neat diagram. (10)

(ii) Write about commit protocols briefly. (6)

13. (a) Discuss the modeling and design of object oriented database in detail. (16)

Or

(b) Explain the overview of GEMSTONE and ODMG models. (16)

14. (a) (i) Distinguish between OLTP and OLAP. (8)

(ii) What are the different schemas in data warehouse? Explain them. (8)

Or

(b) Write about mobile, XML, and web databases with their structures. (16)

15. (a) (i) Explain about knowledge bases, active and deductive databases. (16)

Or

(b) Discuss the concepts of multimedia data structures and query languages briefly. (16)

_________________________

 

List of DBMS that support Distributed Database

List of few Database Management System software that support the concepts of Distributed Database.

The following are the list of DBMS software that support the concept of Distributed Database.

·      Cassandra

·      Clusterpoint

·      Druid (open source data store)

·      Foundation DB

·      Riak

Riak - Overview

Riak - an Open Source, Distributed Database - Overview

Riak:- Riak was announced on August 17, 2009 by Basho Technologies. It is written in Earlang and supports Linux,BSD,Mac OS X, Solaris operating system. Its recent stable version is 2.0.0 which has been released on September 2 andcurrently it is under devlopment.Riak is used by thousands of companies worldwide, including 25% of the Fortune 50.In addition to the open-source version, it comes in a supported enterprise version and a cloud storage version that is ideal for cloud computing environments.

Features

• Queries

Riak provides a straightforward REST-full API through HTTP and Protocol Buffers for basic, PUT, GET, POST, and DELETE functions.

• Predictable latency

Riak can provide excellent latency profile and evenly distributes data across nodes with consistent hashing.

• Fault-tolerant availability

Riak replicates key/value stores across a cluster of nodes so that in the case of node outages due to network partition or hardware failures, data can still be written to a neighboring node beyond the initial three, and read-back due to its "masterless" peer-to-peer architecture.

• Multi-datacenter replication

In this one cluster acts as a "primary cluster." The primary cluster handles replication requests from one or more "secondary clusters". It helps to maximize performance and network utilization.

• Tunable Consistency

Each bucket can be set to be either eventually consistent (to provide high availability) or strongly consistent.

Advantages

Ø  It offers extremely high availability.

Ø  Fault tolerance

Ø  Operational simplicity

Ø Scalability.