Data Warehouse Product Introduction

Data Warehouse Product Introduction

At present, there are a wide variety of data warehouse products and solutions on the market, with different product positioning and characteristics. Which product can be selected to better suit your enterprise's characteristics and future development?

In addition to Microsoft, the following eight mainstream Data Warehouse products are available:Businessobjects, Oracle, IBM, Sybase, Informix, NCR, SAS, CA.

1.4.1businessobjects

1. Product Features

Businessobjects is an intelligent decision support system integrating query, report, and OLAP technologies. It uses the unique "semantic layer" technology and "Dynamic Micro-Cube"Technology to represent multi-dimensional data in the database, with good query and report functions, provides drilling (drill) and other multi-dimensional analysis technology, supports a variety of platforms (all Windows platforms and UNIX platforms) and a variety of databases (such as Oracle, Informix, Sybase, microsoftsqlserver, DB2, ca-Ingres, teradata, Redbrick, foxfro, dBase, access, etc.), and it also supports Intemet/Intranet, you can make query, report, and analysis decisions through www.

2. Main tools

Businessobjects is a tool that integrates query, report, and analysis functions.

Webintelligence is the world's first decision support tool for querying, reporting, and analysis through the Web.

Businessquery is the first tool to integrate data from the enterprise public data source in Microsoft Excel.

Businessminer is a data mining tool for mainstream commercial users. It can be used for in-depth analysis to discover the relationships between deep data.

3. Application

Strictly speaking, businessobjects is only a front-end tool. It is the most common data presentation tool in Data Warehouse solutions. Businessobjects is based on the industry by providing decision-making support for mainstream commercial users to access information in databases and data warehouses. The product has been upgraded from the basic working group to the enterprise level.