The DWE components provide an integrated platform for warehouse administration and for developing warehouse-based analytics, including Web-based applications with embedded data mining and multidimensional online analytical processing (OLAP). 数据挖掘实验室
The DWE components are: 数据挖掘实验室
- DWE Design Studio
- The DWE Design Studio provides a common design environment for modeling physical data, OLAP cubes, data mining, and SQL data flows and control flows. The Design Studio is built on the Eclipse workbench, which is a powerful development environment that you can customize.
The Design Studio includes the following tools and features:
- Integrated physical data modeling, based on Rational® Data Architect
- SQL Warehousing Tool for data flow and control flow design
- Data mining, exploration, and visualization tools
- Tools for designing OLAP metadata, MQTs, and cube models
- Integration points with WebSphere® DataStage® ETL systems
- DWE SQL Warehousing Tool
- The SQL Warehousing Tool (SQW) is a graphical tool that generates SQL for warehouse maintenance and administration, replacing hand coded SQL. The SQW tool automatically generates DB2-specific SQL based on visual operator flows that you model in the DWE Design Studio. The library of SQL operators covers the in-database data operations that are typically needed to move data between DB2® tables and to populate analytical structures, such as data mining models and multidimensional cubes. SQW compliments and works well with ETL products from IBM® and third parties. The integration of SQW with IBM WebSphere Data Stage Suite expands your abilities to build a DB2-based analytical system.
- DWE Administration Console
- The DWE Administration Console is a WebSphere application that provides a single tool for administrating BI applications that are created with the DWE Design Studio. After enabling DB2 databases for DWE with the Administration Console, you can use the DWE Administration Console to manage SQL warehousing, Cube Views™, and Intelligent Miner™ operations.
Administration console operations include: 数据挖掘交友
- SQL warehousing
- You can deploy, run, and monitor data warehouse applications. You can also use the console to study deployment histories, execution statistics, and log files.
- Cube Views
- You can import and export cube models, explore cube models and cubes, and run the Cube Views Optimization Advisor.
- Intelligent mining
- You can load, import, and export mining models.
DB2 UDB, DB2 Alphablox, and WebSphere Application Server provide their own administration tools. You can launch the DB2 Alphablox administration tool from the DWE Administration Console. 数据挖掘实验室
- DB2 UDB Enterprise Server Edition
- DB2 UDB Enterprise Server Edition, Version 8.2 (DB2 UDB ESE) with the Database Partitioning Feature is a highly scalable, multi-user relational database management system that can manage data warehousing, OLAP, online transaction processing (OLTP), and data mining. You can also create and manage partitioned database environments.
DB2 UDB ESE has DB2 Connect™ functionality for accessing data that is stored on midrange and mainframe database systems such as DB2 UDB for iSeries™ or DB2 UDB for z/OS®. DB2 UDB ESE provides support for both local and remote DB2 UDB clients. DB2 UDB ESE can also remotely administer DB2 UDB database servers that are configured as satellites. 数据挖掘研究院
- DB2 Query Patroller
- DB2 Query Patroller uses the predictive query costing of the DB2 optimizer to help manage the warehouse workload. DB2 Query Patroller matches projected resource costs to predefined user profiles, system thresholds, and queue criteria, and dynamically routes queries accordingly. You can use DB2 Query Patroller to dynamically control the flow of queries to your DB2 UDB database.
With DB2 Query Patroller, you can regulate the query workload of your database so that small queries and high-priority queries can run promptly, and you can ensure that your system resources are used efficiently. In addition, you can collect and analyze information about completed queries to determine trends across queries, heavy users, and frequently used tables and indexes.
- DWE Cube Views
- DB2 Cube Views works together with Alphablox, or with partner BI tools, to accelerate OLAP queries in DB2. DB2 Cube Views uses multidimensional models to design runtime DB2 objects that contain critical dimensions and levels (slices) of the cube. These pre-joined and pre-aggregated Materialized Query Tables (MQT) are exploited by the DB2 optimizer, which rewrites incoming queries and routs eligible queries to the appropriate MQT for significantly faster query performance. These MQTs can accelerate all queries in the warehouse, not just the queries that use a particular tool or interface.
Besides performance benefits, DB2 Cube Views metadata and tooling allow cube models to be defined once in DB2 and used by Alphablox and other partner BI tools. Cube models can also be imported into DB2 from partner tools. Because the shared common metadata includes aggregation formulas and calculations, you benefit from greater consistency of analytical results across the enterprise.
- DWE Intelligent Miner
- DWE uses Intelligent Miner algorithms to analyze warehouse data and provide insights into customer or business behaviors. In DWE Design Studio, a new data discovery function allows you to profile your data, sample and view table contents, and visualize correlated statistics to understand what parts of the warehouse hold the best potential for mining. You can use the Design Studio to visually design data mining flows with modeling, scoring, and visualization operators.
You can generate SQL and paste it into an Alphablox page, a third party tool, or any application to invoke the mining flow for embedded analytics. 数据挖掘实验室
The IBM DB2 Data Warehouse Edition includes the following data mining features:
- Data mining functions in DB2 Data Warehouse Edition Design Studio
- Data mining functions in DB2 Data Warehouse Edition Administration console
- Intelligent Miner Easy Mining
- Intelligent Miner Modeling
- Intelligent Miner Scoring
- Intelligent Miner Visualization
In addition to the set of Intelligent Miner™ features within DB2 Data Warehouse Edition, the Intelligent Miner Add-In for Microsoft® Excel is available for free on alphaWorks® at the following Web site: http://www.alphaworks.ibm.com/
- DB2 Alphablox
- DB2 Alphablox provides the ability to rapidly create custom, Web-based analytic applications. These applications fit into your corporate infrastructure and have the ability to reach users both inside and outside a corporate firewall. Applications that you build with DB2 Alphablox run in standard Web browsers, so that you can perform real-time, highly customizable multidimensional analysis in a Web browser. DB2 Alphablox integrates into a variety of enterprise infrastructure components, including application servers such as IBM WebSphere Application Server.
With DB2 Alphablox, you can:
- Access and interact with data from DB2 Universal Database™ and DWE Cube Views.
- Create structured reports that are sourced from relational databases.
- Allow users to interactively display the exact view of their relational data that they want, by using functions such as filters and drill-down.
- Enable a single application to access multiple data sources.
|
