DATABASE DESIGN

Oracle Workspace Manager Now Available in Autonomous Database Oracle Workspace Manager is a feature of Oracle Database that provides the infrastructure for developers to create workspaces to maintain multiple versions of a set of tables. Read: https://blogs.oracle.com/undefined/post/oracle-workspace-manager-now-available-in-autonomous-database

Introducing Exadata X10M: Extreme Scalability and Dramatically Improved Price Performance Introducing Exadata X10M: Extreme Scalability and Dramatically Improved Price Performance Read: https://blogs.oracle.com/exadata/post/exadata-x10m

Introducing Exadata Cloud@Customer X10M We are excited to announce Exadata Cloud@Customer X10M, the latest generation of the world’s best on-premises cloud database platform. Exadata Cloud@Customer X10M now has 3 times as many cores than in the previous generation. With 190 usable 4th Generation AMD EPYCTM processors per database server, you can consolidate more work into fewer servers, reducing the number of servers in your subscription and simplifying your deployment. Read: https://blogs.oracle.com/database/post/introducing-exadata-cloudcustomer-x10m

Develop MongoDB Applications with Oracle Autonomous Database on Dedicated Exadata Infrastructure The blog post showcases the Oracle Database API for MongoDB, enabling integration between MongoDB and Autonomous Database. It highlights the benefits of leveraging ADB's converged capabilities, provides configuration instructions, and demonstrates MongoDB collection migration. The post emphasizes using familiar MongoDB tools while harnessing the power of a converged database, enabling SQL on JSON collections. Read: https://blogs.oracle.com/database/post/adb-d-mongodb-api

Using JSON documents and don’t know what you’re looking for? 23c Search Indexes to the rescue Oracle has powerful capabilities for handling JSON. It also has flexible capabilities for full-text searching, like keyword search, phrase search, or proximity search. We're going to see how these capabilities meet in the JSON search index to provide the powerful functionality of full text search in an optimized manner for all your JSON documents Read: https://blogs.oracle.com/database/post/23c-search-index

Lock-free reservation in 23c: how to start with This blog posting illustrates the basice of lock-free reservations in 23c Read: https://blogs.oracle.com/coretec/post/lock-free-reservation-in-23c

ADB Newsletter for May 2023 We are continually adding new features to Autonomous Database. This latest update includes features to make management simpler, development more agile and analytics so much richer. Read: https://blogs.oracle.com/datawarehousing/post/adb-newsletter-for-may-2023

Autonomous Database Security Central This blog serves as a central information dissemination page for Security features related to the Oracle Autonomous Database on Dedicated Exadata Infrastructure on all deployment platforms Read: https://blogs.oracle.com/database/post/autonomous-database-security-central

Second Quarterly Update on Oracle Graph (2023) Oracle Graph Server and Client 23.2 is available for download for use with databases in the Cloud (OCI Marketplace image is available) and for databases on-premises. This release includes a number of changes, including changes to the graph visualization app, updates to PGQL, and integrations of Oracle Graph with other services. Read: https://blogs.oracle.com/undefined/post/second-quarterly-update-on-oracle-graph-2023

Property Graphs in SQL Developer release 23.1 You can use your favorite SQL tool (SQL Developer) to run SQL queries and PGQL queries on property graphs. Read: https://blogs.oracle.com/undefined/post/property-graphs-in-sql-developer-release-231

Autonomous Database Observability (Part 2) Autonomous Database provides detailed Observability via Oracle Cloud Infrastructure (OCI) services for database monitoring. In Part 1 of this blog series we covered the tools and services available from Oracle to observe and monitor Autonomous Databases (ADB). In this second and final part of the blog series we're covering relevant and popular open source third party tools and services used by developers for observability (now including the database): Prometheus and Grafana. Read: https://blogs.oracle.com/database/post/autonomous-database-observability-2

ADDM Spotlight provides strategic advice to optimize Oracle Database performance Oracle Database ADDM (Automatic Database Diagnostic Monitor) has new Spotlight capability in Oracle Enterprise Manager and Oracle Cloud Infrastructure Operations Insights service. The feature enables administrators to get ADDM analysis across databases deployed in diverse environments over long periods from a single pane of glass. Read this blog to learn how you can get better database performance analysis with this capability. Read: https://blogs.oracle.com/observability/post/addm-spotlight-strategic-advice-optimize-oracle-dbms

Autonomous Database Observability (Part 1) This is Part 1 of an Autonomous Database (ADB) Observability blog series where we'll cover the basics of database observability and then introduce the most relevant Oracle tools and services that you can leverage to observe your Autonomous Databases. In Part 2 we'll be covering relevant and popular third party tools and services used by developers for observability (including the database): Prometheus and Grafana. Read: https://blogs.oracle.com/database/post/autonomous-database-observability-1

Introduction to JavaScript in Oracle Database 23c Free - Developer Release Oracle Database 23c Free - Developer Release is the first release of the next-generation Oracle Database, allowing developers a head-start on building applications with innovative 23c features that simplify development of modern data-driven apps. The entire feature set of Oracle Database 23c is planned to be generally available within the next 12 months. Read: https://blogs.oracle.com/developers/post/introduction-javascript-oracle-database-23c-free-developer-release

Get started with property graphs in Oracle Database 23c Free – Developer Release Oracle Database 23c Free – Developer Release is a new, free offering of the industry-leading Oracle Database that enterprises worldwide rely on every day. Among its new features is support for creating and querying property graphs in SQL using constructs, such as GRAPH_TABLE and MATCH, defined in SQL:2023. These enable you to write simple SQL queries to follow connections in data. Read: https://blogs.oracle.com/undefined/post/get-started-with-property-graphs-in-oracle-database-23c-free-developer-release

Database links in Autonomous Database Serverless are the past - Cloud links are the future Database links have been around for decades but always require measurable administration effort. You must exchange connection and authentication information about databases to connect one database at a time. With Oracle Autonomous Database Serverless, the ability to connect individual databases, or even many databases, is simplified significantly. Cloud links enable you to easily make data remotely accessible for one or many other autonomous databases within your defined security realms. Read: https://blogs.oracle.com/datawarehousing/post/database-links-in-autonomous-database-shared-are-the-past---cloud-links-are-the-future

Writing Applications for JSON Documents in a Sharded Environment (Part 2) Using Oracle SODA for simplified JSON data queries and retrieval Read: https://blogs.oracle.com/database/post/writing-applications-for-json-documents-in-a-sharded-environment-part-2

Now available: Geocoding API in Oracle Autonomous Database Serverless The Autonomous Database Serverless now supports converting addresses into geocoded addresses directly in the database by invoking the functions in the PL/SQL package SDO_GCDR. Read: https://blogs.oracle.com/undefined/post/new-in-database-geocoder-for-autonomous-database-shared

Autonomous Container Database Version Control Blog that describes Version control for Autonomous Container Database Read: https://blogs.oracle.com/database/post/autonomous-container-database-version-control

Autonomous VM Cluster Node Subsetting on Autonomous Database on Exadata Cloud@Customer and Dedicated Infrastructure Blog on Autonomous VM Cluster Node Subsetting on Autonomous Database on Exadata Cloud@Customer and Dedicated Infrastructure. With the support for node subsetting, customers can select the subset of database server hosts on their Exadata Infrastructure to run each workload Read: https://blogs.oracle.com/database/post/autonomous-vm-cluster-node-subsetting-on-autonomous-database-on-exadata-cloudcustomer