Unit 1 – Advanced Database Concepts

DB2 – 400 words
Transaction management and concurrency control are the two most important functions of database management systems (DBMS) to ensure the database remains in a consistent state when many users concurrently access the database, or when any system component (hardware, software, or both) experiences a failure.
First, please study the relevant content in the course materials, and investigate the Library and Internet for the definitions and functions of transaction management and concurrency control. Then, based on the results of your research, answer the following questions. Assume that the nested transaction is used in your database.
• What will be the pros and cons in the following cases?
o The conservative concurrency control method is used
o The optimistic concurrency control method is used
• Please provide examples as necessary.
DB3 – 400 words
Respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.
Please study the relevant content in the Course Materials, and also investigate the Library and Internet for the definitions and functions of query processing and query optimization as needed, then conduct the following tasks:
• Indexes are widely used to implement query optimization; however, you rarely see that an index is applied on every column in every table. Please share your thoughts on this.
• Please provide your thoughts on how to best manage data files in a database management system (DBMS), which has a lot of tables and indexes.
Unit 2 – Distributed DBMS
DB1 – 400 words
Respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
A distributed database management system (DDBMS) manages the database transactions in which both data and processing are distributed among several sites. The DDBMS offers several advantages over the centralized DBMS. Meanwhile the DDBMS are also subject to some problems. Please first study the relevant content in the course material, and also investigate the Library and Internet for information about the centralized DBMS and the DDBMS, and then based on the results of your research, discuss the main difference between the two in the following aspects:
• Suitable Applications
• System Architecture
• System Functions
Please also present 1 specific application example that you either have experienced or researched to explain how some of the differences may impact the decision of choice on what type of DBMS is more suited for that application. Please explain the rationale behind your considerations.
DB2 – 400 words
Respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
Two-Phase Commit (2PC) protocol and Three-Phase Commit (3PC) protocol are two most popular algorithms of managing how to commit or abort distributed transactions in DDBMS. Please first study the relevant content in the course materials, and also investigate the library and Internet for information about 2PC and 3PC, and then based on the results of your research, discuss the main difference between the two in the following aspects:
• Terminate a distributed transaction
• Recover from a system wide power off failure
Please list the main steps that each type of the site involved in the transaction will take when 2PC or 3PC is applied during the terminating process or recovering process.
Unit 3 – Web and DBMS
DB1 – 400 words
Respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
The Web as a platform for database systems has brought both merits and challenges to business and consumers of the products and services produced by the business. Please study the relevant content in the course materials, and also investigate the library and Internet for the definitions and functions of the Web and the requirements for Web-DBMS integration as needed, then conduct the following tasks:
• Please list at list at least 5 items for advantages and disadvantages for Web-DBMS integration. Please point out the main reason for each item.
• Please provide your thoughts on what could be the best approach to integrate Web and DBMS for a given company.
DB2 – 400 words
Respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
So far, 2 approaches have been applied to support the persistency of XML data: (1) the native XML database (NXD), and (2) extend existing DBMS such as Relational DBMS to support XML. Each approach has its own pros and cons. Please study the relevant content in the course materials, and also investigate the library and Internet for these 2 approaches of implementing XML persistency as needed, then conduct the following tasks:
• Please describe the 2 approaches in your own words, and then compare the pros and cons between these 2 approaches.
• Please provide your thoughts on which approach should be used under what situation or type of application. Please use specific examples in your discussion.
Unit 4 – Data Warehouses and Data Mining
DB1 – 400 words
Respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
Business intelligence (BI) is a term that refers to a set of best business practices and software tools to support business decision making under fast changing competitions and growing globalization. The earliest generation of BI system is called the Decision Support System (DDS) which consists of a data warehouse system and often an online analytical processing (OLAP) system. Please first study the relevant content in the course materials, and also investigate the Library and Internet for information about the DDS, data warehouse and OLAP, and then based on the results of your research, discuss the main difference between a data warehouse system and an OLAP system in the following aspects:
• Suitable applications
• System architecture
• System functions
Please also discuss why a DSS needs both a data warehouse system and OLAP system. Also discuss why DSS has evolved further in recent years to include more advanced tools in addition to data warehouse and OLAP.
DB2 – 400 words
Respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
Supervised learning and unsupervised learning are 2 machine learning methods that have both been applied by data mining techniques. Please first study the relevant content in the course materials, and also investigate the library and Internet for information about both machine learning methods, and then based on the results of your research, discuss the following aspects:
• What are 2 or 3 applications suited to each method?
• In your opinion, what is the most important issue related to each method?
• Discuss how to address the issues.
Unit 5: NoSQL Databases and Aggregate Data Models
DB1 – 400 words
Respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
NoSQL is a term with many different definitions. The most popular definition is “NoSQL means Not only SQL,” which refers to many databases, such as Cassandra, Mongo, Neo4J, and Riak, and so forth, which are not following the relational data model. Instead, they are supporting the application-oriented aggregates, embracing schema-less data, running on the cluster platform, and often making the trade-off between the data consistency and other useful properties. Nevertheless, various NoSQL databases have demonstrated some distinct benefits including building applications running with better performance and are much more scalable, so that these databases have become a strong alternative of the relational database in many recently developed applications such as the big data analytics.
Please first study the relevant content in course materials, and also investigate the library and Internet for information about the NoSQL, and then based on the results of your research to discuss the main difference between a relational database system and a NoSQL database system in the following aspects:
• Suitable applications
• System platform
Please also discuss the main reasons why NoSQL databases become emergent.
DB2 – 400 words
Respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
Most of NoSQL databases adopt the Aggregate Data Model, in which an aggregate is the unit of data consisting of a set of related components or objects which are always stored, retrieved, processed, presented, and managed for concurrent access together in a NoSQL database.
Please first study the relevant content in the course materials, and also investigate the library and Internet for information about the Aggregate Data Model, and then based on the results of your research, discuss the following aspects:
• Main concepts of the aggregate data model
• Its application in one of NoSQL databases, such as key-value database, document database and column-family database
• The pros and cons of the aggregate data model
Please use examples to support your point of view.
Unit 6: 400 words
Respond to the following questions with your thoughts, ideas, and comments.
Throughout this class, you have touched many current hot research subjects in databases. You should certainly become familiar with some of problems that are still waiting for a better solution in database area.
Now, assume that you will write a research paper on a database related subject. Please present your paper’s outline, including the title, the motivation, the problem statement, the hypothesis statement, the research questions as well as professional significance statement.
Please be advised that the problem statement needs to contain both the problem syndrome and the root cause of the problem, and that the hypothesis statement needs to propose a solution that can address the root cause of the problem stated in the problem statement, as well as that the professional significance statement needs to specify what will be the new contribution made by your proposed solution to the body of knowledge. Also, each of these 3 statements should be no more than 1 sentence. That is, you need to use 1 sentence to present each statement to ensure that you have made your thoughts on each statement as accurate as possible.
Order Now

Calculate a fair price for your paper

Such a cheap price for your free time and healthy sleep

1650 words
-
-
Place an order within a couple of minutes.
Get guaranteed assistance and 100% confidentiality.
Total price: $78
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?