Questions and Answers of Database Processing Fundamentals

As illustrated in Figure 12-33, what is column family database storage, and how are column family database storage systems organized? How do structured storage systems compare to RDBMS systems?
Based on Figure 12-1, what is the relationship between 1 MB of storage and 1EB of storage?
Explain how the OLAP report in Figure 12-23 differs from that in Figure 12-22.
Explain the characteristics of customers that have the following RFM scores: {1 1 5}, {1 5 1}, {5 5 5}, {2 5 5}, {5 1 2}, {1 1 3}.
What is the enterprise data warehouse (EDW) architecture?
Why do the authors describe the data in Figure 12-6 as "frightening?"
Describe three reasons why direct reading of operational data is not feasible for BI applications.
What are the three sources of data for BI systems?
Do the uses of the term tier in the three-tier architecture and its use in ODBC have anything to do with each other?
Explain how you would change the stored procedure in Figure 10C-66 to connect the customer to all artists who either (a) Were born before 1900 or(b) Had a null value for DateOfBirth.
Explain how you would change the stored procedure in Figure 10A-58 to connect the customer to all artists who either (a)Were born before 1900 or (b) Had a null value for Birthdate.
If you are using Microsoft SQL Server, Oracle Database, or MySQL, create a folder in your Documents folder to save and store the *.sql scripts containing the SQL statements that you are asked to
Explain how the notations shown in Figure 5-9 differ.
Explain how the notations shown in Figure 5-7 differ.
Explain the problems in your example in question 4.23.
Explain what is wrong with the table in Figure 3-2.
Describe why the data environment is complicated.
Why are conformance levels important?
Explain the flexibility inherent in the use of the InsertCommand, UpdateCommand, and DeleteCommand properties.
Explain how JSPs are portable.
How is PHP code designated in a Web page?
How are HTML, SGML, and XML related?
How do BI systems differ from transaction processing systems?
Name and describe the two main categories of BI systems.
Explain the difference in processing between reporting and data mining applications.
Summarize the problems with operational databases that limit their usefulness for BI applications.
What are dirty data? How do dirty data arise?
What are dirty data? How do dirty data arise?
What is click-stream data? How is it used in BI applications?
Why are data warehouses necessary?
Give examples of data warehouse metadata.
Explain the difference between a data warehouse and a data mart. Use the analogy of a supply chain.
Describe the differences between operational databases and dimensional databases.
What is a star schema?
What is a fact table? What type of data is stored in fact tables?
What is a measure?
What is a dimension table? What type of data is stored in dimension tables?
What is a slowly changing dimension?
Why is the time dimension important in a dimensional model?
What is a conformed dimension?
State the purpose of a reporting system.
What do the letters RFM stand for in RFM analysis?
Describe, in general terms, how to perform an RFM Analysis.
What does OLAP stand for?
What is the distinguishing characteristic of OLAP reports?
Define measure, dimension, and cube.
Give an example, other than one in this text, of a measure, two dimensions related to your measure, and a cube.
What is drill down?
What is the purpose of an OLAP server?
Define distributed database.
Explain one way to partition a database that has three tables: T1, T2, and T3.
Explain one way to replicate a database that has three tables: T1, T2, and T3.
Explain what must be done when fully replicating a database but allowing only one computer to process updates.
If more than one computer can update a replicated database, what three problems can occur?
What solution is used to prevent the problems in Review Question 12.39?
Explain what problems can occur in a distributed database that is partitioned but not replicated.
What organizations should consider using a distributed database?
Explain the meaning of the term object persistence.
In general terms, explain why relational databases are difficult to use for object persistence.
What does OODBMS stand for, and what is its purpose?
According to this chapter, why were OODBMSs not successful?
What is an object-relational database?
What is the NoSQL movement? What are the four categories of NoSQL databases used in this book?
What were the first two nonrelational data stores to be developed, and who developed them?
What is Cassandra, and what is the history of the development of Cassandra to its current state?
Explain MapReduce processing. INPUT: DOCUMENT MAP Computer 01: List individual words and count how many times each word appears Document Section 01 REDUCE Computer: Combine lists of individual words
What is Hadoop, and what is the history of the development of Hadoop to its current state? What are HBase and Pig?
Show the SQL statement necessary to create a table named T1 with columns C1, C2, and C3. Assume that C1 is a surrogate key. Assume that C2 has character data of maximum length 50 and that C3 contains
Write an SQL CREATE TABLE statement to create a table named PICTURE using the column characteristics as shown in Figure 10B-95. Run the SQL statement to create the PICTURE table in the MEDIA database.
Write an SQL CREATE TABLE statement to create the table SLIDE_SHOW using the column characteristics, as shown in Figure 10B-96. Run the SQL statement to create the SLIDE_SHOW table in the MEDIA
Write an SQL CREATE TABLE statement to create the table SLIDE_SHOW_PICTURE_INT using the column characteristics, as shown in Figure 10B-97. SLIDE_SHOW_PICTURE_INT is an intersection table between
Write SQL INSERT statements to populate the PICTURE table using the data shown in Figure 10B-98. Run the SQL statements to populate the PICTURE table.
Explain the meaning of each of the cursor concurrency settings listed in Figure 10A-72.
Write SQL INSERT statements to populate the SLIDE_SHOW table using the data shown in Figure 10B-99. Run the SQL statements to populate the SLIDE_SHOW table.
Write SQL INSERT statements to populate the SLIDE_SHOW table using the data shown in Figure 10B-99. Run the SQL statements to populate the SLIDE_SHOW table.
Write SQL INSERT statements to populate the SLIDE_SHOW_PICTURE_INT table using the data shown in Figure 10B-100. Run the SQL statements to populate the SLIDE_SHOW_PICTURE_INT table.
Why do database processing and document processing need each other?
Explain how ODBC, OLE DB, and ADO are related.
Explain the author’s justification for describing Microsoft standards. Do you agree?
Name the components of the ODBC standard.
What role does the driver manager serve? Who supplies it?
What role does the DBMS driver serve? Who supplies it?
What is a single-tier driver?
What is a multiple-tier driver?
Summarize the three ODBC API conformance levels.
Summarize the three SQL grammar conformance levels.
Explain how the three types of data sources differ.
Which data source type is recommended for Web servers?
What are the two tasks to be accomplished when setting up an ODBC data source name?
What is the Microsoft.NET Framework? What basic elements does it include?
What is the current version of the .NET Framework, and what new features does it include?
Why is OLE DB important?
What disadvantage of ODBC does OLE DB overcome?
Define abstraction and explain how it relates to OLE DB.
Give an example of abstraction involving rowset.
Define object properties and methods.
What is the difference between an object class and an object?
Explain the role of data consumers and data providers.
What is an interface?
What is the difference between an interface and an implementation?

Showing 1 - 100 of 777