Sybase IQ Business Intelligence Tool

Overview

Business Intelligence (Business INTELLIGENCE,BI) systems enable organizations to improve business performance by leveraging information about customers, vendors, and internal business operations. The ultimate goal of the BI system is to enable users to consume large amounts of relevant data and analyze them to give them an opportunity to increase revenue or save costs.

BI applications have been widely used in various industries, such as call behavior analysis, congestion analysis, service usage analysis, business analysis, etc. for the acquisition and retention of customers in the telecommunications industry; credit risk analysis, currency risk analysis, asset and liability management in the financial industry in risk management; And can be used for all industries of profit and loss p&l analysis, fraud monitoring, technical analysis, value chain analysis, analytical CRM and so on.

The development of business intelligence has gone through three stages, in the initial report analysis stage, the analysis application is only to provide the senior management with the fixed format, the time, the content basic static information; In the second phase of business intelligence development, enterprises gradually set up a data warehouse system to store business data. Solve specific thematic analyses through discrete data marts, and provide OLAP and statistical analysis. The latest business intelligence applications, dedicated to the establishment of customer-centric enterprise-wide analytical applications, integration of various levels of customer communication channels, integration of complex management tools (OLAP, data Mining, business evaluation), and through the analysis of the data affect the business model.

Current business intelligence applications are typically divided into three-tier structures (pictured):

and data storage management is the core of data warehouse system.

Referring to data storage management, we must mention the traditional relational database which is widely used in transaction type (OLTP) data management system, which has the characteristics of data structure, minimum redundancy, high program and data independence, fast transaction processing capability, etc. in processing transaction type (OLTP) Has an advantage when it comes to transactions. In the new business intelligence environment based on OLAP analysis, the demand for data management has changed a lot, such as mass data storage, quick query, complex query, ad hoc query, large number of concurrent users, etc., traditional database is often powerless to deal with new demands. In fact, we don't see a single database that can meet both OLTP and OLAP two types of data storage management requirements.

Sybase IQ Introduction

Sybase's data warehousing approach is fundamentally different from other relational database providers. Sybase believes that the traditional relational approach and the ROLAP method is inefficient, in order to achieve sufficient performance, must be through high cost, the additional hardware, software, resources, money, time to invest heavily, otherwise impossible to achieve. So Sybase has developed a new relational database--a reverse relational database might be the best explanation for this, which uses a traditional relational structure and a very familiar term similar to it, but is based on columns rather than on rows.

It is from this point of view that we are beginning to look at Sybase IQ, and we find that Sybase's discussion of the benefits of using the column method is "quite convincing". Analysis and reporting (not to mention upcoming RFID applications) and customer experience through the growing demand for data warehouses and the rapid growth of data and users from the Web we can now prove that Sybase IQ offers a far superior approach than those of traditional relational suppliers.