Large data processing expert SAP Hana,sap HANA ten mistaken ideas

In today's big data age, if you don't know SAP HANA, it just means you're out. SAP Hana is a hardware and software combination, providing High-performance data query function, users can directly to a large number of real-time business data query and analysis, without the need for business data modeling, aggregation and so on. For some of the SAP Hana heard but not very understanding of customers, there will be a literal understanding of the misunderstanding, the following we will come together to analyze SAP Hana ten misunderstandings:

1, the role of the database platform
wrong view: Memory database can do only a few things, such as MOLAP, running reports, querying and analyzing, planning and budgeting, and discovering unstructured information.

The correct view: SAP Hana in-memory database platform is a common memory database platform-it can bring new data, capture transactions and comprehensive acid compatibility, analyze them when they occur, do database processing, decentralize the logic of business, forecasting and planning, Its clients include analysts, cloud computing, and mobile applications. Its mainstream application goes far beyond the small audience's understanding of the database, you don't need to add a variety of technologies and or copy the engine in one box for different purposes.

2, Storage mode – row, column, text
Error view: SAP Hana does not support unstructured data and does not provide row and column compression.

The correct view: SAP Hana can store rows, columns, and text in a single database, which natively supports the storage of unstructured data. Because these are all integrated together, it simplifies the transactions and parsing operations in different storage. In fact, SAP Hana is built on a unstructured basis. It can handle standard search, text mining, and search of class text on structural data. SAP Hana will also include inxight technologies in language functions such as tagging, feature extraction, entity extraction, and affective analysis. Inxight is the best text analysis software in the market. SAP Hana supports a large number of compressed column stores. Row storage does not require a lot of compression because it is used only as a buffer for compressed columns and unrelated tables.

3, Business Intelligence client
Error point: SAP Hana only limited support for some BI clients.

The correct view: SAP Hanasap has optimized the operation of Business objects. In addition _ Today many third party clients have become possible (such as Tableau,tibco Spotfire) and we will continue to be fully open to Third-party BI clients on SAP HANA.

4, planning applications and profiling features
Error point: SAP Hana provides limited support for planning and budgeting procedures.

The correct view: SAP HANA provides complete support for planning programs, and there are a significant number of SAP enterprise performance management programs that can be run on SAP Hana. SAP Hana in

The

has a local planning support and planning engine in the database. Similar to decomposition aggregation, replication, and other operators are part of relational algebra in SAP Hana. In addition, we support the SAP database with its own programming language Fox.

5, operational reports, and data sources
Error point: SAP Hana Limited Operational reporting capabilities for using replication and ETL technology due to "limited data sources".

The correct view: SAP has a very good real-time running report solution for different data sources, such as SAP CO-PA Accelerator, many of which are non-SAP program data sources. SAP Data Services and SAP Sybase replication servers are market-leading ETL and replication technologies that can load data from non-SAP and SAP data sources. Hana has a very high insertion rate, because it supports all data sources due to large-scale parallel batch mechanism, and tests show that the data incoming SAP HANA speed is 2TB per hour.

6, SAP HANA on disk
Incorrect view: SAP HANA does not support data storage to disk.

The correct view: SAP Hana supports data storage disks by using priority technologies, such as the least recently Used (LRU). SAP Hana can place related data in memory, while data from disk is loaded as needed.

7, query speed
Error point: SAP Han executes queries faster than other databases.

The correct view: SAP Hana stores all data in integer format and leverages the latest Intel innovation technologies, such as CPU development optimizations for vector operations. SAP Hana next-generation architecture and chip-level innovation to make it faster than any competitor database on the market. For example, after 4 customers have used SAP HANA, the business process has increased 100,000 times times. Leading the MKI, its retail and logistics data analysis increased 408,000 times times.

8, installation and implementation experience
Erroneous view: SAP Hana takes days to install, and implementation takes months or even years.

The correct view: SAP Hana can be installed in a data center in just minutes to an hour. In fact, you'll soon be able to install it from our partner or cloud. Provimi's profit analysis took only 3 weeks to get online.

9, data caching, and query optimization
Error point: Both SAP Hana and TimesTen can do data caching.

The correct view: the previous generation of databases uses caching to improve performance. Hana is based on a new architectural paradigm on a pure memory database. Since the entire database is in Hana, youNo more caching of data. SAP Ha has a world-class query optimizer that itself allows large-scale parallel query execution, including parallel operations within and outside operations.

10, aggregation, and materialized views
Erroneous view: You need to aggregate the materialized views of the data to achieve high performance.

The correct point of view: again! Like an electric car without a spark plug, the instantaneous aggregation performance of detailed data in memory is much higher. Aggregation is an obsolete technology because it takes a lot of effort to create, store redundancy, and manage changes. SAP Hana does not need performance metrics like a traditional database, because all of its parts are in memory and, in the face of all sizes of data, it can set its behavior as an index.

For other related SAP HANA information, click: http://www.avatech.com.cn/pro/product90.html