DATABASE DESIGN – Telegram
DATABASE DESIGN
1.41K subscribers
2.08K photos
3 videos
5.35K links
Лучшие материалы по работе с хранилищами данных на русском и английском языке

Разместить рекламу: @tproger_sales_bot

Правила общения: https://tprg.ru/rules

Другие каналы: @tproger_channels

Другие наши проекты: https://tprg.ru/media
Download Telegram
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
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
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
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
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
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
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
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
Oracle Announces Oracle Database for Arm Architectures in the Cloud & On-Premises

Oracle today announced that Oracle Database 19c Enterprise Edition, the current long-term support release of Oracle Database, is now certified and available on the popular Arm architecture for both cloud and on-premises deployments.

Read: https://blogs.oracle.com/database/post/announcing-oracle-database-19c-support-for-arm
Introducing the Oracle Database Error Help Portal

The Oracle Database Error Help Portal documents all Oracle Database errors, their Causes and the recommended Action for users. It is available under https://docs.oracle.com/error-help/db/

Read: https://blogs.oracle.com/database/post/error-help-portal
August edition of newsletter for Autonomous Database Serverless

We are continually adding new features to Autonomous Database Serverless. Over the LAST 12 MONTHS, over 200 NEW FEATURES have been added, and the latest updates include the following...

Read: https://blogs.oracle.com/datawarehousing/post/august-edition-of-newsletter-for-autonomous-database-serverless
Oracle Graph Server REST API

The Oracle Graph offering includes the Graph Server REST API, a gateway to utilize the capabilities of Oracle Graph from any application with a simple REST call. This API allows developers to interact with their graphs, enabling them to create graphs, run queries, and derive actionable information from their data

Read: https://blogs.oracle.com/database/post/oracle-graph-server-rest-api
Sagas Are Great. What’s the Problem?

Sagas are promoted as a solution to ensuring data consistency across microservices. The solution sounds simple and conceptually it is. It's in the details where things get difficult. This post looks at sagas in a bit more detail and shows some of the problems that can be encountered.

Read: https://blogs.oracle.com/database/post/sagas-are-great-whats-the-problem
Oracle and Microsoft expand partnership to deliver Oracle database services in Azure

Oracle is committed to provide the easiest path for customers to migrate their mission critical workloads, many of which have long been powered by Oracle databases. Read more about how Oracle Database@Azure provides customers more flexibility and choice with Oracle database services running on OCI, colocated in Microsoft Azure data centers for the highest levels of Oracle Database performance, scale, security, and availability, on par with what we offer in OCI.

Read: https://blogs.oracle.com/cloud-infrastructure/post/oracle-microsoft-deliver-oracle-database-at-azure
Introducing Oracle True Cache : In-memory, consistent, and automatically managed SQL and key-value (object) cache

Oracle True Cache is an in-memory, consistent, and automatically managed cache for Oracle Database. It is a cutting-edge caching solution designed to tackle the challenges faced by modern business applications. This blog discusses the features and capabilities of Oracle True Cache and how it empowers organizations to optimize performance, mitigate data staleness, and efficiently manage cached data

Read: https://blogs.oracle.com/database/post/introducing-oracle-true-cache