Seven popular business intelligence products (non-open source)

Currently, bi products on the market mainly include: data mining software, end customer query, report and analysis tools, data mart/warehouse products, three-dimensional data analysis software, technical data analysis software, data warehouse database and information integration tools, etc. The business intelligence products provided by manufacturers of different backgrounds are not nearly the same. A wide range of products can be described in a hundred flowers.

I. IBM

In April this year, IBM just released its next-generation business intelligence strategy dynamicwarehousing. Dynamicwarehousing will meet the needs of growing enterprises for business intelligence and help enterprises of all sizes obtain real-time value from business data and information (including structured and unstructured.

IBM's new dynamic repository strategy allows users to use analytical capabilities as part of real-time business processes, it also mines data hidden in unstructured information (including text, email, audio files, webpages, and so on ). In addition, this method can also achieve immediate access to reliable information in the execution status, whether it is customer support, complaint handling or transaction.

Unlike traditional data warehouses that only focus on queries and reports to understand information, the new generation of dynamic warehouses try to use OLAP) and the data mining technology used for historical analysis to understand the cause, and propose suggestions for future work, including strategic and tactical plans. Dynamic warehouses can also provide and analyze information as needed to help users optimize each transaction.

To support the new business intelligence strategy, IBM has also developed a series of products that help enterprises of all sizes apply dynamic warehouse technologies, including ibmdb29, ibmbalancedwarehouse, and ibmomnifindanalyticsedition.

The functions and features of IBM Business Intelligence products are as follows:

1. data storage and management: DB2 solutions for Business Intelligence provide integrated and easy-to-use data warehousing, data analysis, and data management software, quickly build and manage data warehouses with easy-to-use tools.

2. Data Processing: once the data warehouse is ready, db2warehousemanager can provide flexible and easy-to-use tools to make the data warehouse accessible and manage and track usage.

3. Online analysis: The db2olapserver does not require any query language knowledge, but only requires the most basic programming experience. The db2olap server allows users to quickly design and manage applications.Program.

4. Data Mining: db2intelligentminer will help users discover previously unknown information from the data warehouse that can be used to guide decision-making. When a user's data has accumulated to a certain amount, some potential links, classifications, derivation results, and potential values of the data are hidden, you can use data mining tools to discover valuable data.

2. Bo

Businessobjectsenterprise is a product of Bo's business intelligence platform. It organically integrates the deep insight of end users and the flexible system management of a single bi standard, enabling users to deploy bi products with confidence, and implement standardization.

Businessobjectsenterprise provides the following help:

1. scalable, adaptive, and service-based architecture

The Bi platform is a key component of the enterprise's overall IT infrastructure. It provides a key support system for enterprise information access and decision-making, users can rely on this platform to track, understand, and manage business information. In this way, an effective structure with High Availability needs to be deployed to process and manage key information and its analysis work, and provide it to a wide range of user groups. The businessobjectsenterprise solution is flexible and can be expanded as demand changes.

2. End User insights

Businessobjectsenterprise can provide reliable information for employees and can be directly integrated into the portal network, external network, desktop application or performance management application system. It can also raise questions anytime and anywhere in the way you like, this allows end users to make accurate and timely judgments based on facts to make decisions. However, the innovative tools such as Encyclopedia and processtracker enable end users to make decisions throughout the entire process, tracking, management, and collaboration are implemented on an intuitive, web-based interface.

3. easy deployment and management solutions

Businessobjectsenterprisexi can be deployed quickly, and provides guidance and installation, comprehensive import and upgrade support, and flexible deployment.

Iii. SAS

SAS introduces the concept of an enterprise-level intelligent platform (EIP, enterpriseintelligenceplatform) that is higher than traditional business intelligence, including data integration (extraction, conversion, and loading) smart storage, traditional business intelligence, and analytical intelligence. SAS also developed other commercial solutions based on this platform, such as products that support enterprise-level intelligence, customer intelligence, financial intelligence, and supply chain intelligence, there are also solutions required to support various vertical markets.

Whether an enterprise needs an interactive inquiry environment that reports content via network ports or wireless Internet access devices, or publishes and subscribes to channel content via email, anytime, anywhere, SAS Business Intelligence provides valuable information and answers.

With a customizable development environment, SAS provides a flexible and scalable interface and Support Service, and provides software packages, SAS Business Intelligence provides the following components for the end-to-end intelligent generation and delivery process:
1. easy to access and stable enterprise data;

2. Use Online Analytical Processing (OLAP) for business users to quickly and effectively access highly summarized data around the world;

3. Powerful analytic and interactive data exploration;

4. Network-based reporting and analysis;

5. Publish subscription channels and wireless devices to transmit content through network ports;

6. Open Development Environment for programmersProgramming LanguageAnd program access to sasbi.

Iv. Sybase

Sybase's data warehouse method is fundamentally different from other relational databases. Sybase has developed a new relational database-reverse relational database, it uses a traditional relational structure and similar familiar terms, but is based on columns rather than rows.

Sybase's business intelligence product sybaseiq has the following three features:

1. Architecture

Unlike traditional relational databases, sybaseiq stores and accesses data in tables through columns instead of by row. Although this method is obviously not suitable for the transaction environment, in the transaction environment, a transaction effectively corresponds to a row of data; in the query process environment, queries are selected based on specific columns.

2. Index

The key to sybaseiq is its index. As Sybase users discover new analysis requirements, Sybase can easily create new indexes to meet these requirements. This method can add new indexes to the data warehouse without affecting the architecture of the data warehouse or using the Analytic Applications of the warehouse. In Real-Time Enterprise and closed-loop applications, Sybase regards indexes as the key to achieving higher query performance in data warehouses of terabytes or even petabytes.

3. multiplex

The multiplex component of sybaseiq supports multiple SMP machine nodes in a single sybaseiq environment. On each node, sybaseiq uses a lightweight operating system thread located under each process. multithreading significantly reduces the burden on processes and memory.

5. Cognos

Cognos's business intelligence product mainly provides functions such as reports, analysis, scorecard, dashboard, enterprise event management, and data integration. It features easy to integrate, deploy, and use. Cognosbi provides a simplified Bi environment that increases user acceptance and decision-making, and serves as the basis for enterprise-level performance management.

1. Reports are an important feature of Cognos business intelligence. Cognos business intelligence is a product that provides complete Bi functions in the architecture. It allows users to access a variety of self-help report types suitable for any data source and perform operations from a single metadata layer, for example, multi-language reports.

2. Analysis is another important feature of Cognos business intelligence. Analysis allows you to visually inspect and analyze information related to all business dimensions without considering data storage locations, including Online Analytical Processing (OLAP) reports and multidimensional relational data sources.

3. the scorecard is also an important feature. The scorecard helps you coordinate teams, tactics, and strategies, communicate with each other in a consistent manner, and monitor the performance of your target.

4. business dashboards can deliver complex information by express delivery. They can convert data and information from various enterprise IT systems into rich graphs for presentation, such as scales, maps, charts, and other graphs, multiple results are displayed together.

5. cognosbi business event management can track important events that require attention. It can monitor these events, the decision-making process and business process can also be used to automate the reduction of the time for action and decision-making.

6. Data integration is also an important feature. Cognos data integration is an enterprise-level ETL solution for high-performance business intelligence. It optimizes data merging, extraction, conversion, and dimension management, and provides a data warehouse suitable for enterprise reports and analysis.

Vi. NCR

NCR has announced the separation of teradata from its data warehouse business department, showing its determination to the business intelligence market. The dynamic data warehouse of teradata is divided into four layers:

The first layer is the infrastructure of the entire business intelligence solution. It integrates data of various business systems through a unified data model and establishes a unified information view;

The second layer is the basic application of multi-dimensional analysis, dynamic analysis, and pre-defined reports on the basis of infrastructure, customizes/dynamically reports, multidimensional correlation analysis, basic customer segmentation, and assists in the formulation of marketing strategies for marketing business departments;

The third layer is an advanced application that focuses on data mining, such as the customer churn model, customer value model, and customer credit model. It provides prediction and warning functions for enterprises;

The fourth layer is to further implement closed-loop Customer Relationship Management, fraud management, performance management, revenue assurance, and other value-added applications dominated by application products, so as to thoroughly explore and expand Bi business value.

VII. Oracle

The third edition of Oracle Business Intelligence kit Enterprise Edition was launched in December February this year. The new version of the software has added a large number of new features. In order to further implement business intelligence across the enterprise to achieve full Bi, to this end, it enhances availability and is more closely integrated with Oracle application products, ORACLE Integrated middleware, and Oracle databases. It also supports a wider range of non-Oracle Data sources through hot swapping.

Oracle Business Intelligence kit can help enterprises that need to optimize business processes, make better decisions, and take more appropriate actions, and use business intelligence software to extract useful information from existing applications and data sources, this information is widely distributed to every corner of the enterprise to achieve the goal of optimizing the process, making better decisions, and taking appropriate actions. In addition to providing comprehensive business intelligence functions, the Oracle Business Intelligence kit Enterprise Edition platform also provides many next-generation business intelligence functions based on the Web service architecture.

The functions and features of Oracle Business Intelligence are as follows:

1. Integrated Business Intelligence tool, which is the next generation of business intelligence infrastructure.

2. Integrated Business Intelligence Database, that is, integrating business intelligence functions into the database.

3. Integrated analysis application software, that is, business intelligence and Enterprise Performance application software that are cross-department and industry-specific.