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