What’s new in Oracle Database 23c

Show video

hi I'm Jenny Tsai Smith vice president of Oracle database product management in this session I'll be sharing with you what's coming in Oracle database 23c this is a release that will accelerate our mission to simplify the development of data-driven apps a quick reminder of our Safe Harbor statement we're still developing many of the features I'll be talking about and as a result their functionality may change before General availability of the release modern data-driven apps operate on a diverse set of data including spatial documents sensor transactional and these data is pulled from multiple different sources often in real time and they create value from that data in very different ways from traditional applications for example they may use machine learning to make real-time recommendations to customers or detect fraudulent transactions they may also use graph analytics to identify influencers in a community or use spatial data to to track deliveries oracle's database development vision is to create the very best database in the industry by making it simple to develop and run modern operational and analytic applications everything we build is designed to make this happen we're delivering on this Vision by building a converged database that delivers the industry-leading support for Json XML graph spatial text and relational in doing this for any type of workload plus allowing developers to use the development style that suits them however we understand that managing databases can be challenging especially in Mission critical environments to make this simpler we're bringing autonomous operations to every aspect of the Oracle database processes that were once complex to configure and manage now use machine learning and automation to make them simple a fully managed service Oracle autonomous database is the easiest way to take advantage of oracle's converged database engine it's complete and simple data management with a standard programming interface for all data types and models via SQL or rest it's really easy for developers to adopt and new technologies without incurring a steep learning curve with our converged database approach building a data-driven app can be as simple as adding a SQL statement or a rest call this way developers data scientists analysts get what they want a database that lets them easily build a specific project they're working on and chief technology officer officers get what they want easier repurposing of data across the Enterprise and simpler operations to sustain this using data in more ways means that a single data set can serve more points of use thereby bring more value better yet Oracle database can run on your laptop on high performance engineer systems in oracle's Cloud on other clouds and even in containers it's the same database engine that requires the same skill set to run anywhere while simple to operate Oracle the autonomous database is a fully managed cloud service running on Oracle exadata a powerful engineered system specifically optimized for Oracle database with all of the performance availability and security features that's pre-configured and enabled Oracle autonomous database has built-in integration with the full range of Oracle cloud services that are needed for cloud native app development and the same autonomous database service is available in public cloud and customer data centers via Cloud customer and in multi-cloud configurations the Innovative capabilities of autonomous database is recognized by industry analyst firms such as Gartner in every annual Gartner Cloud dbms critical capabilities assessment for the past three years autonomous database ranked highest for all of the operational use cases and in the top two for all of the analytical use cases now let's talk about Oracle database 23c the next long-term release of Oracle database this new release follows our previous long-term support release to uh Oracle database 19c while Oracle has always offered the most complete set of features in the industry to ensure the most secure performant and highly available database there's always more that we can do as new data management requirements arise in Oracle database 23c we focused on making it easier for developers to build the next generation of data-driven applications regardless of development approach or style while maintaining the same levels of performance and availability that the Oracle database is known for to help ensure that Oracle database 23c is our most stable release of the Oracle database and to give our customers earlier access to this release we launch the beta program for Oracle database 23c in October 2022 the beta program allows you to test your application against this new release ensuring it works as expected this is also the opportunity for you to try out new database functionality to see how your company could benefit from it Oracle database 23c beta is available on oracle-based database service in the cloud as well as via download for on-premises testing Oracle Linux and Red Hat Linux are the two operating systems that are supported you can join the beta program by scanning the QR code below and while looking at the functionality in Oracle database 23c it's important to remember that this isn't just about the features that we'll be discussing shortly but also the features announced in Oracle database 21c and Innovation release so when looking at Oracle database 23c please remember it's the sum of the functionality in 21c plus 300 new features in 23c Oracle is commonly regarded as the best database for storing relational data it's trusted by the world's leading organizations to manage the most critical data but the Oracle database is more than that it's the world's only converged database not only supporting relational but also semi-structured and structure and unstructured data all in the same database Engine with all of the data models benefiting from oracle's industry leading performance security and availability better yet data stored in all of these models can be used without any costly Integrations in 23c Json capabilities go beyond what our competition provides over the last few years we've listened to our customers and the issues they face in managing Json data in a complex Enterprise environment the improvements that we've made in Oracle database 20 19c 21c and now 23c will enable customers to not only benefit from the flexibility that building applications with Json offers but also the benefits that the relational model can provide for data management and analytics and more importantly allowing users to continue to benefit from all of oracle's Enterprise level availability scalability and security features graph databases offer a new approach to modeling complex applications and relationships that exist in the real world however until recently languages used by developers to navigate these relationships for proprietary and bolted onto each of the databases that store the data this held back the adoption of this very important technology the good news is that the industry has come together and worked to ratify these standards this means that developers can benefit from the freedom of choice that SQL brings to the relational table and bottle and we're confident that these changes will Propel graph databases Into the Heart of the Enterprise and as with Json Oracle database 23c is offering unique capabilities for supporting graph models while previous Oracle versions of the database have offered graph model support in Analytical workloads in Oracle database 23c we're introducing support for the emerging anti-standard C equal pgq directly in the database this combined with oracle's leading support for managing highly concurrent and scalable workloads means that customers can begin to look at using graph models as their single source of truths for operational applications does change potentially reduces the complexity of applications that have looked to exploit the benefits that graph databases offer whether it's for fraud detection and banking applications or making recommendations in retail applications it's impossible to understate the impact that SQL has had on the software industry it created a standard that freed developers from building code that could only ever be run against a single database it's a standard simple to read language that has become universally accepted across the industry and across every type of database be it key value document graph or relational Oracle is designed on the principle of SQL first and because of that we strive to do SQL better than anyone else over the last 40 plus years we've constantly pushed that what could be achieved using this simple and Powerful language from the early days of Oracle where our SQL leverages Oracle databases is row level locking and reconsistancy capabilities to more recently where we use SQL to exploit the power of document and graph data models we've been the first commercial database to implement numerous SQL standards that make it easier to query large and complex data sets and return results quickly we optimize SQL execution regardless of whether it's for analytical or operational systems Technologies like parallel query real-time materialized views in-memory column their store and many others ensure fast and scalable execution and SQL is one of the most important programming languages decades after it was first conceived today the Oracle database still runs SQL better than anyone else in addition to Jason Graf and SQL we also focus on adding developer productivity enhancements when using Oracle database 23c for microservices JavaScript and mid-share caching along with Jason Graf just Jason and graph Juan Luisa cover these areas at length in his keynote app simple the future of data Centric app Dev however he didn't cover SQL enhancements so let's spend a few minutes on some of them so it's complex to write apps that need to update or delete data Based on data stored in another table in 23c this is simple since update or delete statements can include joins with other tables it's complex to write apps that need the old and new values of data that's being updated in 23c this is simple since update statements can return the old and new values for a column it's complex to write SQL statements that group by and return complicated Expressions now this is simple by using column aliases or column position numbers inside the group by clause it's unnecessarily complex to write a complete SQL statement to retrieve the value of an expression from the database now this is simpler using a select without a from clause it's complex to run multiple SQL statements to operate on multiple rows and in 23c this is simple because the values expression can construct multiple rows in a single insert or merge statement it's also complex to determine when there are genuine errors in scripts that create and drop tables because actual errors are masked by faults errors that are returned if tables already exist now this is simple using the if not exist syntax which will support alter create and drop statements and there's more it's complex to Grant all the Privileges developers need to create debug and tune apps it's now simpler to use the new developer role it's a complex and manual process to map language and Json Boolean data types to text for number columns in SQL and now it's simple using the new Boolean data type it's complex to manage privileges on all the tables views and procedures used by an application now this is simpler by granting privileges to a schema and it's much more secure than granting the any privileges to users it's complex to write applications that must use more than a thousand columns in a table especially for machine learning and analytic applications in 23c this is simple since tables can contain up to 4096 rolls now let's take a look at some Focus areas to help make dbas more productive first I will highlight some enhancements and new features that automate and improve user and operational experience then we'll walk through a few of the new security capabilities we're adding machine learning to improve the accuracy of real-time statistics this change allows us to better predict how data will change over time thus providing better information on which to plan query executions this reduces the need for those expensive statistics collection jobs and reduces the impact on operational systems Oracle database 23c can automatically detect regressions in SQL plans and provide the optimal plan it'll also automatically intercept errors that may previously have thrown Aura 600 messages and come up with alternative solutions that will return the expected results without any Interruption to the application this feature proactively handles SQL plan issues that that can cause application errors or slow down the response time in Oracle database 23c we're enhancing the way that we create materialized views we're using machine learning to allow us to make better recommendations with materialized views that we automatically generate on your behalf the underlying machine learning framework better understands the benefits that materialized views might make for your anal analytical workloads but also it understands the burden it might place on the database to maintain those materialized views as with all of our autonomous features we allow you to automatically or manually accept the changes that it recommends Oracle SQL firewall is an easy to use firewall solution with minimal performance and operational overhead it's built into the database ensuring that it cannot be bypassed and it offers real-time protection against common database attacks by monitoring and blocking unauthorized SQL and SQL injection attacks SQL firewall can also use session context data such as IP addresses for its enforcement transport layer security TLS is used to secure data in transit from the database server TLS 1.3 enables faster handshake and connection to the database in addition it implements encryption authentication and integrity for data in transit Oracle database 23c offers Azure active directory oauth 2 integration which will enable customers to more easily connect their Azure applications to Oracle databases and simplify multi-cloud database access in addition to Automation and security we also focus on some other areas that dbas spend a fair amount of time on manageability performance and security for example kubernetes is a key component of many organizations Enterprise architectures Oracle offers support for customers wishing to run this container-focused architecture we have an operator that makes it easy to deploy create and manage instances and we're improving that experience by adding real application cluster support for kubernetes and podman now let's take a look at a few more of the key enhancements in these Focus areas Resource Management in Oracle database has allowed dbas to Define policies that ensure the fair the fair utilization of database resources however prior to Oracle database 23c it's complex to ensure that fair utilization of resources such as CPU at the operating system level in Oracle database 23c we've introduced the support for inter-database resource management making it simpler than ever to consolidate databases onto a single server one of the problems that dbas often face is when a transaction blocks access to a row this can lead to lengthy application outages and typically requires the Hands-On involvement of the DPA in Oracle database 23c users can now enable functionality that automatically aborts lower priority transactions that are blocking higher priority transactions to maintain data Integrity locking data either explicitly or implicitly is one of the most important characteristics of databases however it's possible that it can become obstructive to business operations if the data is highly contended or blocked by long-trent running transactions in Oracle database 23c we support Lock Free column value reservations also referred to as escrow locking this allows developers to create rules as to when data rows need to be locked for example when stock levels are running low data is locked only at commit time and potentially improves the end user experience and indeed the throughput of the transactions one of Oracle database 21c's High availability feature was was the ability to use Oracle Data Guard to protect individual plugable databases rather than the full container this allows an individual plugable database to be failed over to a standby rather than having to fail over the entire container database which can take a longer time in Oracle database 23c we now allows a standby plugable database to be open read only greatly increasing the flexibility and architecture such as an elastic use case such as the offloading of reporting Global scales distributed workloads demand very extreme scalability and availability we introduce sharding in Oracle database 12C release 2. the advantage is that it provides is that the concept of shorting is baked directly into the database it makes it really easy to manage Solutions either for scalability or for global distribution in Oracle database 23c we've added new functionality to make the creation and management of replicas much simpler and just as important the new functionality makes the failover to the replica much faster we also add a directory based sharding which is a new type of user-defined sharding method that helps you to short data where there are fewer numbers of distinct short value keys to be used now let's take a really quick look at the upgrade path to Oracle database 23c to upgrade directly to 23c you'll need to be either on 19c or 21c of Oracle database if you're on an earlier release of the database you'll need to upgrade first to one of these releases the good news is that it's never been easier to upgrade the Oracle database we have optimized many of the time-consuming steps needed to upgrade the database such as time zone updates there's also the popular Auto upgrade utility that will walk you through all of the steps necessary to upgrade your database it Flags any issues before upgrades performs the upgrades and then it'll run any postgrad post upgrade actions finally it'll verify that the upgrade was successful it can also be run against multiple databases at the same time and it's worth pointing out that you can use the same tool to upgrade Oracle database 12C release 2 and 18c to Oracle database 19c and then on to 23c now we understand planning the upgrades of hundreds or even thousands of databases can be very challenging it's likely to touch many critical systems within an organization to help ensure that you have plenty of time to plan and Implement your upgrade we're pleased to waive the first year of extended support fee uplift for Oracle database 19c this will allow customers to more a lot more time to test and perform their upgrade to 23c without incurring the higher cost of extended support so that's a very quick rundown of just some of the features in Oracle database 23c I hope you learned some useful information about the this next long-term support release of the Oracle database we truly believe that Oracle database 23c delivers on our vision of creating the very best converged database in the industry by making it simpler to develop and run modern operational and analytical apps at any scale or criticality the Oracle database is built for the developer whether you're looking to build applications for operational systems with millions of connected users or whether you're building you're looking to build data warehouses data lakes or data lake houses designed to process billions of rows the Oracle database makes it simple for developers to build secure and highly available applications regardless of the model or design approach being used by the way we offer many free resources for you to try Oracle database both in the cloud and on premises please check them out and thank you for your time

2023-04-17

Show video