Independientemente de los proveedores de software o hardware, el mercado de Data Warehousing es un área de crecimiento, que se espera que aumente aproximadamente 10.1% en CAGR (tasa de crecimiento anual compuesta) en 2015 según el último estudio realizado por IDC. SAP, gracias a la adquisición de Sybase, Gartner & Forrester lo considera un líder en el Data Warehouse. Este artículo se centra en las soluciones proporcionadas por SAP para organizaciones que buscan almacenes de datos orientados a la empresa o bases de datos de alto rendimiento más ágiles y para echar un vistazo a su hoja de ruta futura.
Almacén de datos empresariales
- SAP NetWeaver Business Warehouse (BW): is nowadays a very stable product, with a large installed base and in constant growth (more than 12000 customers, more than 15000 productive systems), and what more it has not been affected by the economic downturn in 2009. If we look at its future evolution, it is intended to be running on HANA in 2012 which will be used as the underlying In-Memory database Platform (BW 7.3x SP5), this means to be based on an already built-in Business Warehouse Accelerator.
Base de datos analíticos de alto rendimiento
- SAP HANA: is a flexible, data source agnostic, in-memory appliance that analyzes high volumes of transactional data in real-time. It includes tools for data modeling, data and lifecycle management, security and operations. It combines SAP software components which are optimized with the hardware provided by partners. The benefits are the following: make smarter business decisions supported by an increased visibility of very large volumes of business information, react to business events more quickly through real-time analysis and reporting of operational data, a new application foundation for a new category of applications, streamline IT landscapes and finally reducetotal cost of ownership (TCO). If we look further ahead in time, there will be a transition going from having SAP Business Objects BI 4.0 running on SAP HANA 1.0 to having the whole SAP Business Suite running on SAP HANA 2.0 in 2013.
- Sybase IQ: is a market leading, high-performance, columnar analytics server and data warehouse specifically designed for high speed data analytics, enabling high speed performance of complex queries against large datasets, with the advantage of being a low cost maintenance when compared to row-based systems (by reducing the need for aggregates and indexes). It is a mature and proven solution with about 1900 customers and more than 3300 unique deployments. SAP will continue to support and invest on this acceleration technology, especially for non-SAP applications and data (including the possibility of placing SAP BusinessObjects BI on top).
- SAP BusinessObjects RapidMarts are preconfigured jumpstart data marts that are designed to accelerate BI. And they all come pre-packaged by subject areas and sub-areas specific to SAP modules (Finance, Manufacturing, Operations, HR, etc.) as well as for non-SAP applications (JD Edwards, PeopleSoft, Lawson, Oracle EBS, etc.). The key elements included are the following:
- Asignaciones de ETL: asignaciones de origen a destino y transformación de datos para tablas de origen relevantes (movimientos de datos iniciales e incrementales).
- Data Marts: conjunto de objetos y esquemas RDBMS de destino basados en las mejores prácticas para el modelado de datos dimensionales (Oracle, DB2, SQL Server, Teradata).
- Contenido de BI: universos preconfigurados basados en las mejores prácticas y muestras de informes que muestran la gran cantidad de datos disponibles.
Si necesita más información sobre las soluciones presentadas aquí, no dude en publicar una respuesta o ponerse en contacto con Clariba.