Find out more: http://www.ibm.com/software/data/infosphere/warehouse/
Virtual Conference: https://events.unisfair.com/index.jsp?seid=33250&eid=556
IBM InfoSphere Warehouse is a complete real-time data warehousing platform that delivers superior scalability and availability, design, build, and management tooling, and business analytics. It provides a complete, multipurpose environment that allows organizations to access, analyze and act on operational and historical information, whether structured or unstructured.
With InfoSphere Warehouse, organizations can gain the insight and agility they need to generate new opportunities, contain costs and satisfy customers. Unlike traditional data warehouse and BI solutions, which may be complex and inflexible, InfoSphere Warehouse simplifies the processes of selecting, deploying and maintaining an information management infrastructure while offering the flexibility for dynamically integrating and transforming data into actionable business insights. It enables organizations to centrally, accurately and securely analyze and deliver information as part of their operational and strategic business applications.
New and enhanced features of version 10:
One of the driving motivations behind this new version 10 is the desire to accelerate time-to-insight so that decision makers throughout an organization can make faster (and better) business decisions. Accelerating time-to-insight focuses on two key areas: 1) the latency of data ingest, and 2) the analytics latency – time to perform analytics and provide insights to decision makers.
In more traditional warehouse environments, additional data is loaded once a day, once a week or perhaps even once a month. InfoSphere Warehouse continuously ingests data from multiple sources throughout the organization while optimizing resource utilization across all the data sources.
Continuous ingest of data optimizes loading of data – not once per day, not once per hour, but continuously. This ensures that the most up-to-date data is used all the time – no more waiting for a nightly ETL process and scheduled reports to be run the next morning. This is a significant feature for companies where being first is critical – ha, I can’t think of any company that wouldn’t want to analyze fresh data and take action before their competitors!
Multi-temperature data management
As warehouses grow in size, storage costs escalate. At the same time, service-level agreements (SLAs) for warehouse access are becoming tighter for certain mission-critical warehouse information. Multi-temperature data management enables warehouse data to be spread across multiple tiers of storage, defined by performance or cost. The optimizer and workload management features use information about data priority to enhance query performance for hot data while reducing resources for lower-priority queries that access archival or cold data.
Faster performance delivers insights faster. Pretty simple concept. Multi-storage data management puts high priority, frequently accessed data in the fastest (hot) storage available to the warehouse, and of course, less frequently accessed data in warm and cold storage. This accomplishes two things – 1) for end users, queries run faster, and 2) for IT, it optimizes performance, storage and costs.
Storage savings and enhanced performance through adaptive compression
Adaptive compression improves on the leading compression technology found in prior versions of InfoSphere Warehouse by adaptively determining the optimal compression between row- and page-based compression. Using InfoSphere Warehouse 10.1, organizations can improve the compression ratio by nearly 30 percent compared with prior versions. By combining InfoSphere Warehouse and the terabyte charge metric (in which organizations pay for only the post-compression data volume), organizations now can store more raw warehouse data with less storage while enjoying improved performance to query that data. Adaptive compression eliminates the need to completely rebuild compression dictionaries as data grows and reduces the requirement to periodically perform table reorganizations.
Time travel queries through Temporal Table support
The relevance of data within a warehouse often degrades significantly over time. For example, knowing the specific updates to a customer’s record throughout the day may provide valuable insight into a customer’s activity patterns. Two days later, however, it may no longer be necessary to store same-day activities data within the warehouse. Temporal Table support enables organizations to enhance table definitions to define the relevance of transitional changes within the rows stored in the table. After changes reach a predefined threshold, historical (temporal) changes are removed from the table. Organizations can use temporal analytics to gain new insights into the patterns and transitory activities of their business—insights that were previously too expensive to manage or store within the warehouse.
Improved efficiency and performance for BI queries
To improve the speed of BI queries, InfoSphere Warehouse provides industry-leading efficiency in collating multiple data formats, including unstructured data. The result is a 3x or better performance improvement for standard, star-schema types of complex BI queries. Intelligent analytic query optimization helps reduce I/O to minimize resource requirements for heavy workloads.
Advanced security through row and column access control
Advanced access control allows organizations to restrict data access to certain users or groups. Administrators can decide to present only the data that users are allowed to see, or they can mask certain data, such as all but the last four digits of credit card numbers. Quick setup and standardization of security features simplifies security, enabling organizations to control, monitor and help ensure enforcement of security by the database. These security policies help reduce complexity for organizations trying to manage these policies and procedures within applications and business groups. Fine-grain access control capabilities also enable organizations to host multitenant warehouses while limiting access to a single tenant’s information, thereby leveraging resources across multiple warehouse clients.
Real-time operational warehousing
Using the features and enhancements of InfoSphere Warehouse 10, organizations can realize the benefits of real-time data warehousing and deliver greater business value through faster access to time-critical data. Historical trend analysis using temporal tables allows finer insight into business and market trends. By maximizing the utilization and prioritization of resources, organizations can achieve those benefits at a lower total cost of ownership.