Microsoft SQL Server 2000 | Provides several components that you can use to transform OLTP data into OLAP data and make the OLAP information available to decision makers, including:
Analysis Services. Analysis Services is an easy-to-use, integrated, and scalable set of components that enables you to build multidimensional cubes and provide the application programs with access to them. Analysis Services is very flexible in the types of storage mechanisms it supports for the cubes. The cubes can be stored in relational databases (ROLAP); as separate, high-performance multidimensional data structures (MOLAP); or as hybrid combinations (HOLAP) of both. Analysis Services also supports wizards that ease tasks such as defining dimensions and cubes.
Relational Database Engine. The SQL Server 2000 database engine is used primarily in the OLTP systems. It is also used to store the intermediate data stores used when transforming OLTP data for storage in the data warehouse or data mart and to store and manage the data in a data warehouse or data mart.
Data Transformation Services. Data Transformation Services (DTS) is a component built to take data from one OLE DB data source, perform operations such as aggregating the data (SUM, MIN, MAX, AVG), and store it in a destination OLE DB data source. DTS consists of packages, which define a particular set of work that forms a logical work item. Packages contain multiple connections to data sources, tasks to be performed, and workflows connecting connections and tasks. |
