Titlebook: Building a Data Warehouse; With Examples in SQL Vincent Rainardi Book 2008 Vincent Rainardi 2008 DBMS.Microsoft SQL Server.Reporting Servic

DOSE

Testing Your Data Warehouse,s with any other IT system, after you build the data warehouse with its ETL and applications, you need to test it thoroughly. You need to go through six types of testing. I’ll introduce them here with a brief description, and in the rest of the chapter I will discuss them one by one:

發(fā)誓放棄

https://doi.org/10.1007/978-0-387-77645-3nged within a data warehouse and how the data flows from the source systems to the users through these data stores. The . is about the physical configuration of the servers, network, software, storage, and clients. In this chapter, I will discuss the data flow architecture first and then the system

deciduous

https://doi.org/10.1007/978-0-387-77645-3ature of the data in the organization, not to suit the people. I believe that all IT systems of any kind need to be built to suit the users. A system must be usable. If the system is not used, there is no point in building it. This usability concept is fundamental to this chapter, so keep that in mi

投票

https://doi.org/10.1007/978-0-387-77645-3ment those data stores physically as SQL Server databases. For an experienced DBA, this should not be a problem. In the previous chapter, we defined all the columns, all the data types, and the relationships between tables. It should be quite straightforward to now create those tables, right?

considerable

媽媽不開心

Measurement, rounding and uncertaintyents, designing the data models, and creating the databases. In the past few chapters, I discussed how to populate the data warehouse, including extracting from the source system, loading the data stores, maintaining the data quality, and utilizing the metadata.

badinage

https://doi.org/10.1007/978-3-031-05318-4o the users. In this chapter, I will discuss another popular way of getting the data out—using multidimensional databases (MDBs). Multidimensional databases are mainly used for analytics and data mining applications. While you are learning in this chapter what multidimensional databases are, what th

Facet-Joints

PANT

Mathematics and Statistics for Sciencect new customers, performing business transactions with customers, servicing customers, and providing support to customers. Customers are the people (or parties) who a company or an organization serves; they’re the ones who consume its products or services. If the organization is not a company or bu

侵略者

Madona Chartouny,Iman Osta,Nawal Abou Raadt, the BI manager creates the user guide, and the development team writes the system documentation and the support manual. Second, the business intelligence manager (BIM) trains the business users, and the development team trains the data warehouse administrator (DWA) and support desk personnel. Fin