Explain why large firms use data warehouses.
What will be an ideal response?
Large firms maintain many databases, which might or might not be linked together into an overall structure. To provide rapid access to this information, companies use software packages that organize and store data in special configurations called data warehouses. A data warehouse is an integrated collection of data that can include seemingly unrelated information, no matter where it is stored in the company. Because it can link various information systems and databases, a data warehouse provides an enterprise-wide view to support management analysis and decision making. A data warehouse allows users to specify certain dimensions, or characteristics. By selecting values for each characteristic, a user can obtain multidimensional information from the stored data.
You might also like to view...
Prove that K i=1 x?Ci (x ? mi)(m ? mi) = 0. This fact was used in the proof that TSS = SSE + SSB on page 557.
A(n) ___________ join represents the Cartesian product of two tables in a SQL database.
a. full b. outer c. double d. inner
You may have to add the Gantt Chart ____ to the Ribbon before using it.
A. Master B. Wizard C. Template D. dialog box
As a SAN administrator, you are implementing a storage solution for a customer. A server will remotely mount physical disks on the shared SAN and then write a large number of small files to disk before they are processed by a Java program. Which consideration is most important to ensure that the files can be processed successfully by the Java program?
A. Ensure that the server can write the files to the disk as fast as the Java program can process them. B. Ensure that the Java program has the latest updates. C. Ensure that the server has multiple NICs. D. Ensure that the server utilizes processor affinity.