Comparison of the characteristics of nine data warehouse program
China Electronic Equipment System Research Institute Wang Jianxin Liu Dongbo
IBM, Oracle, Sybase, CA, NCR, Informix, Microsoft, and SAS, have strong companies that have launched their own data warehouse solutions, Bo and Brio, etc. professional software companies in the front-end online through acquisition or research and development. The analysis processing tool market has a place. The performance and comparison of these data warehouse solutions are made.
1. IBM IBM provides a business intelligence (BI) solution based on visual data warehouse, including: Visual Warehouse (VW), EssBase / DB2 OLAP Server 5.0, IBM DB2 UDB, and front-end data from third parties Show tools (such as BO) and data mining tools (such as SAS). Among them, VW is a strong integrated environment that can be used in data warehouse modeling and metadata management, and can be used for data extraction, conversion, loading, and scheduling. EssBase / DB2 OLAP Server supports "dimension" definitions and data loading. EssBase / DB2 OLAP Server is not a ROLAP (ROLAP) server, but a HOLAP server that is mixed (ROLAP and MOLAP), after EssBase completes the data load, data is stored in the DB2 UDB database specified by the system. Strictly speaking, IBM did not provide a complete data warehouse solution that taking a partner strategy. For example, its front-end data show tools can be BUSINESS Objects's Bo, Lotus Approach, Cognos's IMPROMPTU or IBM Query Management Facility; Multi-Word Analysis Tool supports the DB2 OLAP server of Arbor Software EssBase and IBM (United Development); The statistical analysis tool adopts SAS system.
2. Oracle Oracle Data Warehouse Solutions mainly include two parts: Oracle Express and Oracle Discoverer. Oracle Express consists of four tools: Oracle Express Server is a MOLAP (multidimensional OLAP) server that utilizes multidimensional models, stores and manages multi-dimensional databases or multi-dimensional caches, and also access a variety of relational databases; Oracle Express Web Agent passes CGI Or web plug-in supports web-based dynamic multi-dimensional data; Oracle Express Objects Front-end Data Analysis Tool (currently only supporting Windows Platform) provides graphical modeling and assumption analysis, support visual development and event-driven programming technology, providing compatible Visual The language of the Basic syntax, supports OCX and OLE; Oracle Express Analyzer is a general, an end-oriented report and analysis tool (currently only supporting Windows platforms). Oracle Discoverer is designed to end users and administrator versions specifically for end users. During the Oracle Data Warehouse Solution implementation, the summary data is usually stored in the Express Cube, and the detailed data is stored in the Oracle relational database. When detailed data is needed, the Express Server accesss the relational database by constructing the SQL statement. But the current Express is not flexible enough, a change in data warehouse design often leads to the reconstruction of the database. In addition, the integration of the current Oracle 8i and Express is not high enough, and the metadata needs to be replicated between Oracle 8i and Express. If Oracle Discoverer (or BO) needs to access the summary data, you need to save the summary data in Oracle and Express. In the middle, system maintenance is difficult. It is worth noting that Oracle 9i just came out as an important feature of OLAP and data mining. 3. The data warehouse solution provided by Sybasephology, called Warehouse Studio, including data warehouses, data extraction and conversion, data storage and management, metadata management, and visual data analysis. Among them, Warehouse Architect is a design module in PowerDesigner, which supports star models, snowflake models and ER models; data extraction and conversion tools include PowerStage, Replication Server, Carleton Passport, PowerStage is the visual data migration tool provided by Sybase.
Adaptive Server Enterprise is the Sybase Enterprise-Level Relational Database, Adaptive Server IQ is the relational database designed for data warehouse, which optimizes the establishment of high performance decision support systems and data warehouses, Sybase IQ supports a variety of popular front ends. Exhibit tools (such as Cognos Impromptu, Business Objects, Brio Query, etc.); Data Analysis and Display Tools include PowerDimensions, Englishwizard, Infomaker, PowerDynamo, etc., PowerDimensions are graphically OLAP analysis tools that support SMP and multi-dimensional cache technology, which can be integrated Architectural data warehouse and distributed data market, thereby form a single, new multidimensional mode; data warehouse maintenance and management tools include Warehouse Control Center, Sybase Central, Distribution Director, where Warehouse Control Center is developed for data warehouse Metadata management tool provided by personnel. Sybase provides a complete data warehouse solution Quick Start Datamart, which has good performance and supports third-party data show tools. It is not difficult to see from the name of Quick Start Datamart, especially suitable for data market applications. In addition, Sybase can provide customer relationship management (CRM) products for telecommunications, finance, insurance, health care, in which 80% of the functions are common, and 20% of the features require Sybase. Developed with partners for different needs.
4. Informix [In 1998 "and 1999 acquired the internationally renowned data warehouse vendor Ard Brick System and Data Management Software Supplier Ard Brick System, and provided a complete, integrated data warehouse solution. The solution also includes a "quick start" consulting service that helps users quickly complete the development of data warehouses or data markets. Informix products can integrate Microsoft IIS or NetScape Enterprise / FastTrack servers to support web-based data warehouse applications. Informix did not provide its own report and data mining tools, but they have established a strategic alliance with Brio and SAS, and launched the "Informix Business Intelligence Alliance Program". The plan is based on Informix, combined with Brio's front-end data analysis and reporting function, and SAS data mining function, forming a "BI Center" package scheme. (In April this year Informix Software has been acquired by IBM, this move will give IBM's database and data warehouse products, from technology and market share.)
5. After acquiring Platinum Technology in 1999, CA α acquired a complete data warehouse solution, including: erwin data warehouse design tool, Infopump data conversion and extraction tool, InfobeAn ROLAP server, Forest & Trees front-end data show tool, provision System monitoring and job scheduling tools and DecisionBase metadata management tools, etc. Similar to the Informix solution, the CA solution also provides data warehouse modeling, metadata management, data extraction and conversion, online analysis server, system monitoring and job scheduling, front-end data display, etc., and supports Web application. The difference is that informix provides a high-performance target database specifically designed for data warehouse, while the CA solution provides an ODBC interface and stores data in a third-party relational database (such as Oracle, Sybase, SQL Server, Informix. In IBM DB2, etc., its performance is to play some discounts, but openness is better. In addition, the OLAP server of the CA is currently integrated with Microsoft IIS web server. 6.NCR Teradata ncr Teradata is the most powerful competitor of high-end data warehouse market, mainly running on UNIX operating system platforms in NCR WorldMark SMP hardware. In 1998, the company also provided Windows NT TERADATA, tried to develop data market (Data Mart) market. In general, NCR's product performance is very good, and the TPCD indicator test in TERADATA data warehouse is in the TPCD indicator test in TPCD, and 3TB. However, the price of NCR products is relatively high, and small and medium-sized enterprises are unacceptable.
7. Microsoft Microsoft integrates OLAP functions into Microsoft SQL Server 7.0, providing expandable COM-based OLAP interfaces. It supports data warehouse applications through a series of service programs. Data Transfer Service DTS (Data Transformation Services) provides data input / output and automatic scheduling function, which can complete data verification, cleaning, and conversion operations during data transmission, by integrating with Microsoft Repository, sharing related metadata; Microsoft Repository Store all intermediate data including metadata; SQL Server OLAP Services supports online analysis processing; PivotTable Services provides client OLAP data access, through this service, developers can develop user front-end data display programs with VB or other languages, Pivottable Services also allows data to be stored on local clients; Microsoft Management Console provides a core management service of schedule, storage management, performance monitoring, alarms, and notifications; Access and Excel in Microsoft Office 2000 kits can be used as data display tools. In addition, SQL Server also supports third-party data show tools.
8.SAS 公司 有 公 公司 in the 1970s, "Statistical Analysis" and "Linear Mathematical Model", after the 1990s, SAS also joined the competition in the data warehouse market, and provided a distinctive data warehouse solution Solution, including more than 30 special modules. Among them, SAS / WA (Warehouse Administrator is an integrated management tool for establishing a data warehouse, including defining topics, data conversion, summary, updating summary data, metadata management, data martial arts implementation; SAS / MDDB is SAS for online Analytical multi-dimensional database server; SAS / AF provides screen design functions and SCLs for development; SAS / ITSV (IT Service Vision) is software for performance evaluation and management of IT services, including computers System, network system, web server, and telephone system, etc. The advantage of the SAS system is that the function is strong, high performance, highlights, and disadvantage is that the system is complicated. 9.Business ObjectsBusiness Objects (bo) is a intelligent decision support system that sets queries, reports, and OLAP technology. It uses a unique "semantic layer" technology and "dynamic micelle" technology to represent multi-dimensional data in the database, with better query and reporting function, providing multi-dimensional analysis technologies such as drill (DRILL), supporting multiple databases, while It also supports web browser-based queries, reports, and analysis decisions. Although BO is increasing new features, in strict sense, BO can only be a front-end tool. Perhaps because of this, almost all data warehouse solutions use BO as an optional data display tool. Although there are many universities and research institutions engaged in data warehouse technology, so far, there is basically no mature data warehouse solutions in China.
