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)

_________________________

 

CS2029/CS606 Advanced Database Technology Anna University question paper - May/June 2011

CS2029 Advanced Database Technology question paper - May/June 2011 / Anna University Previous Year 2011 Exam Questions for Advanced Database Technology / Anna University Previous Year 2011 Computer Science and Information Technology Question Papers / CS 606 Advanced Database Technology Question Paper

Question Paper Code : 11247

B.E./B.Tech. DEGREE EXAMINATION, MAY/JUNE-2011

Sixth Semester

Computer Science and Engineering

CS 2029 — ADVANCED DATABASE TECHNOLOGY

(Regulations 2008)

Time : Three Hours                                                          Maximum : 100 marks

Answer ALL Questions

PART A – (10 X 2 = 20 marks)

1. What are Armstrong axioms?

2. What is cascade less schedule?

3. What is location transparency and fragmentation transparency?

4. When are elections and voting used in distributed database?

5. Mention the approaches used for making objects persistent.

6. Mention the use of create_iterator() method used in ODMG C++ language.

7. What is the difference between XML schema and XML DTD?

8. Define Snowflake schema and fact constellation schema.

9. Mention the type of spatial queries.

10. What is a Horn clause?

PART B – (5 X 16 = 80 marks)

11. (a) (i) Discuss first normal form, second normal form and third normal forms.(10)

(ii) Normalize the given relations as required. (6)

·         Customer(Customer_ID, customer_name, telephone_numbers, credit_cards) to first normal form [note : telephone_numbers and credit_cards are multivalued Attributes]

·         Student(Rollno, name, courseno, course max ,marks, yearofstudy, Address) to third normal form

·         Vendor_order(vendorno, orderno, vendorname, qty_supplied, price_per_unit) to second normal form

Or

(b) Discuss: (16)

(i) Conflict serializability

(ii) View serializability

(iii) Two phase commit protocol

(iv) Validation based concurrency control protocol.

12. (a) Discuss in detail how parallelism could be used in query processing and relational operation executions.(16)

Or

(b) (i) Consider the relations:(10)

Employee(Name, address, salary, plant_number)

Machine(Machine_number, type, plant_number)

Assume that the Employee relation is fragmented horizontally by plant_number and that each fragment is stored locally at the corresponding plant site. Assume that the Machine relation is stored its entirety at the ‘Armonk’ site. Describe a good strategy for processing each of the following queries.

* Find all employees at the plant that contains machine number 1130.

* Find all employees at plant that contain machine whose type is "milling machine".

* Find all machines at the ‘almaden’ plant.

* Compute join of find employee and machine relations.

(ii) Explain how 3PC responds to various types of failure. (6)

13. (a) (i) Discuss the basic built in interfaces of the ODMG model. (12)

(ii) Differentiate:(4)

* Multiple inheritance and selective inheritance

* Structured and unstructured complex object

Or

(b) (i) Describe the steps of the algorithm for object database design for EER to OO mapping. (8)

(ii) Discuss in detail the OQL concepts. (8)

14. (a) Discuss the issues and steps involved in building a data warehouse. How the concept of relational view is related to data warehouse and data marts? (16)

Or

(b) Discuss Apriori and frequent pattern tree algorithm. (16)

15. (a) Discuss the database management issues involved in designing mobile, genomic and multimedia databases.(16)

Or

(b) (i) Discuss the design and implementation issues for active databases. (8)

(ii) Discuss the programming aspects of Datalog with example. (8)

________________________

CS2029 Advanced Database Technology Anna University question paper - May/June 2011

CS2029 Advanced Database Technology question paper - May/June 2011 / Anna University Previous Year 2011 Exam Questions for Advanced Database Technology / Anna University Previous Year 2011 Computer Science and Information Technology Question Papers / CS 606 Advanced Database Technology Question Paper

M260

B.E./B.Tech. DEGREE EXAMINATION, MAY/JUNE-2011

Regulations 2008

Sixth Semester

CS 606 — ADVANCED DATABASE TECHNOLOGY

Computer Science and Engineering

Time : Three Hours                                                          Maximum : 100 marks

Answer ALL Questions

PART A – (10 X 2 = 20 marks)

1. Define primary key, candidate key.

2. What are the goals of data mining?

3. What is data parallelism?

4. Write short notes on horizontal fragmentation.

5. Why do database systems support concurrent execution of transactions?

6. Differentiate persistent objects and transient objects.

7. List out the types of Constructor? Give definition of each.

8. Briefly explain about applications of data warehousing.

9. Write short notes on multimedia query languages.

10. What is knowledge? What are its types?

PART B – (5 X 16 = 80 marks)

11. (a) Explain in detail about serial schedule and serializable schedule in transaction processing. (16)

Or

(b) Explain any two principal methods for dealing with the deadlock problem. (16)

12. (a) Briefly explain about Intra-operation parallelism and Inter-operation parallelism. (16)

Or

(b) Explain about commit protocols. (16)

13. (a) (i) Explain how the concept of the object identity in the object-oriented model differs from the concept of tuple equality in a relational model? (6)

(ii) Briefly explain about ODMG model. (10)

Or

(b) Discuss in detail about transaction and concurrency of Object oriented databases. (16)

14. (a) Explain about data mining and association rules of data mining in detail. (16)

Or

(b) (i)           What do you mean by a tier? For a Web, why a three tier client-server architecture is more suitable? Give a general structure of a client-server system. (8)

(ii) Briefly explain about mobile databases. (8)

15. (a) Explain about spatial and multimedia database. (16)

Or

(b) Explain in detail about Active Databases. (16)

________________________

 

CS2029 Advanced Database Technology Anna University question paper - May/June 2013

CS2029 Advanced Database Technology question paper - May/June 2013 / Anna University Previous Year 2013 Exam Questions for Advanced Database Technology / Anna University Previous Year 2013 Computer Science and Information Technology Question Papers / CS 606 Advanced Database Technology Question Paper

Question Paper Code : 21283

B.E./B.Tech. DEGREE EXAMINATION, MAY/JUNE 2013

Sixth Semester

Computer Science and Engineering

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

(Common to Seventh Semester – Information Technology)

(Regulation 2008/2010)

Time : Three Hours                                                          Maximum : 100 marks

Answer ALL Questions

PART A – (10 X 2 = 20 marks)

1. Write an SQL query to retrieve employee name and Id from a table employee.

2. What is Concurrency Control?

3. Differentiate intra query parallelism from inter query parallelism.

4. Differentiate distributed database and normal database.

5. How transaction is performed in Object oriented database?

6. What is versioning in terms of object oriented database?

7. List the advantages of XML over HTML.

8. Specify the advantages of Data warehousing.

9. How spatial databases are more helpful than active database?

10. What is deductive database?

PART B – (5 X 16 = 80 marks)

11. (a) (i) Illustrate and discuss the steps involved in processing a query with neat diagram.                                                                                                         (12)

(ii) Discuss briefly on database tuning.                                                          (4)

Or

(b) Explain the following with an example in relational model

(i) Transaction Processing

(ii) Query Optimization                                                                                 (16)

12. (a) (i) Explain with a neat diagram the architecture of distributed databases also mention its uses.                                                                                        (8)

(ii) Discuss the ACID properties of a transaction with relevant example.                   (8)

Or

(b) (i) Explain the Distributed transaction Processing with suitable example.   (10)

(ii) Explain the role of recovery subsystem in a distributed environment.                  (6)

13. (a) (i) Explain the object oriented database and its approaches.               (8)

(ii) Explain the component of the ODMG model with example.                        (8)

Or

(b) (i) Discuss the transaction states in object oriented databases.                          (8)

(ii) What is POSTGRES? Explain it in detail.                                                     (8)

14. (a) (i) How XML are processed and stored in web database? Explain with an example.                                                                                                   (8)

(ii) Explain the process of mobile database and its advantages over other database.                                                                                                                    (8)

Or

(b) (i) Explain the steps involved in constructing a data warehouse.                (8)

(ii) Explain about the decision trees in the process of data mining.                          (8)

15. (a) (i) Describe the active and deductive database and compare with each other.                                                                                                                            (8)

(ii) Explain the role and use of multimedia database for current technologies.          (8)

Or

(b) Elaborate the following with an example.                                                 (16)

(i) Spatial databases

(ii) Multimedia query with complex types.

________________________