Making Try-Confirm/Cancel Easy with MicroTx

This post describes how microservices can adopt the Try-Confirm/Cancel transaction protocol to ensure data consistency across their microservices.

Read: https://blogs.oracle.com/database/post/making-try-confirmcancel-easy-with-microtx

Spatial Studio 22.3 Available Now

We’re pleased to announce the release of Oracle Spatial Studio 22.3. Oracle Spatial Studio is a no-code web tool for working with the Spatial features of Oracle Database. This blog post will explore some of the new functionality available in this release.

Read: https://blogs.oracle.com/undefined/post/spatial-studio-223-available-now

Key Considerations Before Migrating Oracle Databases to the Cloud

Moving your on-premises workloads to the cloud can offer many benefits, such as downsizing data centers, eliminating infrastructure management, accelerating application deployments, simplifying administration with automated and autonomous services, and lowering cost. If you’re ready to start moving existing Oracle databases to the cloud, it’s important to carefully evaluate your requirements to determine which cloud provider can best meet your application and operational needs.

Read: https://blogs.oracle.com/database/post/key-considerations-before-migrating-oracle-databases-to-the-cloud

New in 2022 from Oracle Database Development

Blog post highlighting some updates from the Oracle Database Development Team during 2022.

Read: https://blogs.oracle.com/undefined/post/new-from-oracle-database-development-in-2022

What is a Converged Database?

A converged database is a database that has native support for all modern data types and the latest development paradigms built into one product. A converged database does not mean data must be in one monolithic database. A converged database enables you to choose your data architecture for each application. You decide when to consolidate data into fewer databases and when a fully distributed design is best.

Read: https://blogs.oracle.com/database/post/what-is-a-converged-database

2022 - The Year In Review For The Exadata Family

2022 - The year in review for the Oracle Exadata Family

Read: https://blogs.oracle.com/exadata/post/2022-exadata-family-year-in-review

Writing Applications for JSON Documents in a Sharded Environment

Oracle’s JSON capabilities allow native JSON support with the JSON data type which also supports relational database features, including transactions, indexing, declarative querying, and views.

Read: https://blogs.oracle.com/database/post/writing-applications-for-json-documents-in-a-sharded-environment

First Quarterly Update on Oracle Graph (2023)

Graph databases are a part of Oracle’s converged database offering that store and navigate relationships between entities. the marquis feature of this release is the release of a graph visualization JavaScript library for Property Graphs. This library allows developers to leverage the many of the benefits of graph visualization available in Graph Studio and the graph visualization tool, but in their own applications.

Read: https://blogs.oracle.com/undefined/post/first-quarterly-update-on-oracle-graph-2023

Announcing third-party Python packages for use for Graph Studio on Autonomous Database

We are pleased to announce the ability to use custom third-party packages on Graph Studio. Users of Oracle Graph Studio can now use custom-installed third-party packages through Conda environments. Oracle Graph Studio now has a Conda interpreter that allow to easily create and distribute Conda environments. As a part of this interpreter, you can now install python libraries that are available through Conda.

Read: https://blogs.oracle.com/undefined/post/announcing-third-party-python-packages-for-use-for-graph-studio-on-autonomous-database

Oracle Backup & Recovery Technologies - Year in Review

This blog highlights product updates over the last year for the Oracle Backup & Recovery Technologies portfolio.

Read: https://blogs.oracle.com/maa/post/oracle-br-year-in-review

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

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

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

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

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

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

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-javanoscript-oracle-database-23c-free-developer-release

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

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 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

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