Ten ways the AI Database, Db2 11.5, will help your business pull ahead
Today’s launch of Db2 11.5, the world’s premier AI database, is great news for any company seeking to build an architecture that supports their AI implementation. Governance, integration, and business intelligence are all important rungs on the ladder for a business to reach AI. But the first step is a solid hybrid data management practice.
That’s why the new Db2 11.5 is built for – and powered by – AI. It helps run queries significantly faster, supports popular data science languages and frameworks, and makes it easier to implement natural-language querying. These factors and more make up the top 10 ways Db2 11.5 can help your business pull ahead of the competition:
- Natural language querying for more intuitive insights. Db2 11.5 provides a more search-engine-like experience to explore datasets. Writing queries is improved through auto-completion, natural language querying and faceted search thanks to the inclusion of IBM Db2 Augmented Data Explorer. Try the beta of Augmented Data Explorer to learn more.
- System performance is optimized. Using Workload Management, Db2 11.5 automatically manages the resources and schedules the execution for its workloads. This enables fine-grain resource allocation, monitoring and management of workloads based on service classes, workload characteristics, elapsed time, time of day and more. In turn, users can focus on more important tasks than monitoring system performance.
- Data is more accessible no matter where it resides. The common SQL engine (CSE) found within Db2 11.5 provides better access to data within both IBM and non-IBM offerings so users can provide more complete insights. The CSE’s built-in data federation allows users to access data from Db2 family offerings like IBM Db2 Warehouse, IBM Db2 Big SQL, IBM Integrated Analytics System and existing IBM PureData for Analytics (Netezza). Due to these federation capabilities, we’ve improved data access to Oracle, Teradata, Microsoft SQL Server, cloud sources like Amazon Redshift, and open-source solutions like Hive.
- Db2 works the way data scientists do. Db2 11.5 supports popular data science languages and frameworks including: Go, Ruby, Python, PHP, Java, Node.js, Sequelize, IBM Watson Studio and Jupyter notebooks. This enables developers and data scientists to build or integrate their AI applications with Db2. And data scientists will soon be able to do complex modeling and visualization using Db2 Graph, a capability that will be released later in 2019.
- Queries run significantly faster. Queries run faster than before with Db2 11.5 because it monitors SQL performance information over time and correlates it with queries using machine learning algorithms. This allows models to be created and optimized for specific SQL statements.
- Confidence-based querying makes results are more accurate. Db2 11.5 also uses machine learning to monitor SQL query results and score them based on their accuracy. It can then use those scores to prioritize and reorder results, providing users with higher degrees of confidence in the insights they will use to drive their business.
- Db2 can be deployed nearly anywhere. There have never been more deployment options for Db2 than there are now. Db2 provides the same experience and features across on-premises, hosted, and cloud options so users can leverage existing skills and streamline transitions between ground and cloud. Moreover, Db2 can be deployed on a variety of public cloud platforms including IBM Cloud or Amazon Web Services so that you can continue – or begin – your multicloud strategy.
- Db2 editions are more streamlined and easier to upgrade –With the 11.5 release Db2 is consolidating from 11 distinct editions to three. Organizations can start with the free edition, migrate to Db2 Standard Edition, and move to Db2 Advanced Edition should their business grow to need that level of scalability. And all three versions use the same code base, so it’s never been easier to move up or down.
- Growing your hybrid data management architecture and AI capabilities is simpler. Db2 is part of a family of hybrid data management products including database, data warehouse, data lake, and fast-data offerings, including both on-premises and cloud options. With IBM Cloud Pak for Data, businesses can add these as needed within a containerized platform by purchasing additional VPCs. Additional capabilities from each rung of the AI ladder like Watson Studio Open Scale can be selected in the same way to help grow AI smoothly within a business.
- Getting started with Db2 for free has never been easier. Anyone wanting to experience Db2 11.5, the AI database, can download and use it at no cost. Then you can easily upgrade to Standard and Advanced editions if you need more cores or RAM.
The announcement of Db2 11.5 at IDUG North America was just the beginning. We have plans to release additional AI capabilities within Db2 and the entire Db2 family of offerings throughout the year. Sign up and be the first to know about these new Db2 updates.
For a deeper look at the impact an AI database can have on an organization join Matt Aslett, research vice president for 451 Research, and Sam Lightstone, IBM Fellow, for their AI database webinar, “Modernizing your information architecture with AI.“