Purchase Solution

Transaction Processing and Query Optimization

Not what you're looking for?

Ask Custom Question

1. Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. And each time the product ABC is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in Table P1 in the attachment.

Given this information, answer questions a-e.

a. How many database requests can you identify for an inventory update for both PRODUCT and PART?
b. Using SQL, write each database request you have identified in Step a.
c. Write the complete transaction(s).
d. Write the transaction log, using Table 10.1 as your template.
e. Using the transaction log you created in Step d, trace its use in database recovery.

2. This problem is based on the DDBMS scenario in figure P10.1 in the attachment. Specify the minimum type(s) of operation(s) the database must support (remote request, remote transaction, distributed transaction, or distributed request) in order to perform the following operations at sites C, A and B. Please refer to the attachment for complete question.

3. What are the different types of query optimization algorithms?

4. Describe three data fragmentation strategies. Give some examples of each.

5. What is data replication, and what are the three replication strategies?

Attachments
Purchase this Solution
Solution Summary

This solution deals with transaction processing and query optimization. It also answers several questions related to query optimization, data replication and data fragmentation with well explained examples.

Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

View More Free Quizzes
Related BrainMass Solutions

  • Query processing strategy

    Otherwise we stay and complete processing the query using St0. Obviously, the procedure can be repeated on St1, to call St2 if necessary, etc.

  • Data Warehousing

    Application databases are OLTP (On-Line Transaction Processing) systems where every transaction has to be recorded, and super-fast at that.

  • Distributed Database Architecture

    Thus it is a more complex operation than query optimization in centralized databases. Query optimization overview Query optimization is essential if a DBMS is to achieve acceptable performance and efficiency.

  • Data Resouce Management

    Compare and contrast online transaction processing with online analytical processing. Online transaction processing is a type of systems that enable and manage software that is transaction oriented.

  • Subquery vs. Join.

    predict what data should be loaded to be processed and save time, unlike the sub-query where it will run all the queries and load all their data to do the processing.

  • features and uses of SQL

    When SQL was not developed File-processing System was very popular for processing and storing the data.

  • Five Software Components of a Database Management System

    Data administration subsystem: This component helps to manage the overall database environment through facilities for data backup and recovery, data security, change control, query optimization and concurrency control. Hope this will help.

  • Optimization for Genetic Algorithms

    some test data is needed to see the benefit of this optimization algorithm ( see the the result pdf file i sent) or something like it. Hello Please find the solution attached.. please do let me know if you have any query or doubt..

  • Differences between OLTP and OLAP Databases

    OLTP is designed for transaction oriented where OLAP is for processing data. OLTP has can handle update/delete/inserts more effectively whereas OLAP cubes needs to be re-created to have any Updates/deletes/inserts.

View More Related Solutions