Question

In: Computer Science

Chapter #4 Question #12. What is IVR? How is it used to query a database? Question...

Chapter #4

Question #12. What is IVR? How is it used to query a database?

Question #14. What is master data management? What is data steward? What is the role of master data management in an organization’s integration strategy?

Question #16. What are examples of internal sources of data for a data warehouse? What are examples of external sources of data for a data warehouse?

Question #18. What is big data? What are the defining features of big data?

Solutions

Expert Solution

12. The answer is:

IVR: The IVR assists the user through a series of pre-programmed prompts. These prompts are pre-recorded and can also further direct the caller to a live customer service representative.

In some cases, it may be forwarded to a voicemail box or even a message from the customer recorded and emailed to the customer service team.

  • IVRs are used by small and large businesses to reduce their labor costs by using automated systems to answer the routine queries by customers.
  • It can also be designed to recognize human voice and respond accordingly.
  • IVRs can be used for bookings and credit card transactions as well.

14. The answer is:

Master Data Management (MDM) is a comprehensive method of enabling an enterprise to link all of its critical data to one file, called master file which provides a common point of reference.

Data Steward is a person responsible for the management and fitness of data elements ( both the content and metadata).

Role of MDM in an organization's integration strategy:

  • The integration layer is a key component for the different data integration processes, like EAI/ETL and messaging.
  • Integration supports standard messaging formats across multiple protocols as well, like workflow management, cross-referencing, and data sharing.

16. The answer is:

Internal sources of data:

  • Most of the companies collect data from several resources such as past transactions, clicks, shipments and more.
  • The data scientist will transform this data into business intelligence and then into actionable results.

External sources of data:

  • External data records gathered by some external resources like supermarket, medicine store, clothing store etc. based on the requirement.
  • It will also collect the data from random articles and reports that are available in internet.

18. The answer is:

Big Data refers to collections of data that are so enormous in size, varied in content and fast to accumulate that they are difficult to store and analyze using traditional approaches.

Defining features:

  • Volume
  • Velocity
  • Variety

Related Solutions

Question (Chapter 12) Customer analytics can be used for improving retention rates. How?
Question (Chapter 12) Customer analytics can be used for improving retention rates. How?
Describe what a database system is and how it is used. What is a relational database...
Describe what a database system is and how it is used. What is a relational database system and how used in a company to benefit an organization? What does it mean to run a query?
What is a Data Dictionary? What is a Database Engine? What is a Query Processor/Analyzer? What...
What is a Data Dictionary? What is a Database Engine? What is a Query Processor/Analyzer? What is a Forms Generator? What is a Reports writer? What is a DBMS? What is the difference between DB and DBMS?
Describe what each line does in the following SQL query The lyrics database is provided under...
Describe what each line does in the following SQL query The lyrics database is provided under question 3 for context 1. select studioID, studioname, base from salespeople sa inner join studios st on (sa.salesID = st.salesid) where base < 300 2. select concat_ws(' ', firstname, lastname) as "Member Name"         from members; 3. select m.lastname, m.firstname, s.lastname         from members m inner join salespeople s using (salesID)         order by m.lastname asc; The lyrics database is provided below DROP TABLES...
4. Chapter 12: Using the attached dataset “Chapter 12 Data Set 1” to determine whether there...
4. Chapter 12: Using the attached dataset “Chapter 12 Data Set 1” to determine whether there was a change in tons of paper before vs. after a recycling program in these 25 districts. a. Is this a directional or non-directional hypothesis? b. Should you use a one-tailed or two-tailed test? c. Is a dependent samples t-test an appropriate way to analyze these data? d. Conduct the between groups t-test using Excel (either method). Use the .05 confidence level. What is...
Question 6        (Marks: 35) Structured Query Language (SQL) is a language that is widely used in...
Question 6        (Marks: 35) Structured Query Language (SQL) is a language that is widely used in industry to create, update and query data in relational databases. This question must NOT be done practically (i.e. in the computer room). You are required to write the SQL code in your answer book. Q.6.1 The below sample data in third normal form was provided by a database designer. Answer the below questions using this data. Table: Country Primary key: CountryID (auto number) All...
Chapter 12: How was the author of the News Wire (chapter 12 of your text) so...
Chapter 12: How was the author of the News Wire (chapter 12 of your text) so confident that a recession was coming? (Be sure and include what happened to the job market, the stock market, the housing market and anything else you consider to be pertinent) Chapter 13: Does the fact that your bank keeps only a fraction of your account balance in reserve worry you? Why don't people rush off to the bank and retrieve their money? What would...
1. For each of the following, write a single SELECT query against the TSQLV4 database that...
1. For each of the following, write a single SELECT query against the TSQLV4 database that returns the result set described. Each of these queries involves two tables and can be written using a join operation. a. One row for each order shipped to France or Germany, showing the order ID, the last name of the employee for the order, and the customer ID for the order. b. One row for each employee who handled orders to Belgium, showing the...
1.write about your plan for the database performance tuning, query optimization, and distributed database management systems.  Include...
1.write about your plan for the database performance tuning, query optimization, and distributed database management systems.  Include appropriate diagrams.
SQL query exercises: Consider the following database schema:                Product(maker, model, type)              &
SQL query exercises: Consider the following database schema:                Product(maker, model, type)                PC(model, speed, ram, hd, rd, price)                Laptop(model, speed, ram, hd, screen, price)                Printer(model, color, type, price) Consider the Drivers-Cars-Reserves DB for a small rental car company:                Drivers(id, name, rating, age)                Cars(vin, maker, model, year, color)                Reserves(did, vin, date) Give SQL statement each of the following operations: Find the colors of cars reserved by Smith. Find all id’s of drivers who have a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT