Contenting Logo

News

Entertainment

Science & Technology

Sport

Business & Money

Life

Culture & Art

Hobbies

Sites
Lists
#tags
  1. home
    2. ›
  2. Julian Dontcheff's Database Blog

Julian Dontcheff's Database Blog

8 | Follower

Software

See All

Julian Dontcheff's Database Blog

02.09.2024

Performance tuning of queries over JSON data in Oracle Database 23ai | Julian Dontcheff's Database Blog

Oracle Database 23ai offers 4 main ways of tuning SQL queries over JSON data: (1) indexes, (2) materialized views, (3) in-memory column storage, and (4) Exadata storage-cell pushdown. This blog post looks into how to index JSON. It is not a surprise to anyone that the Oracle Autonomous Database makes it extremely easy to index JSON…

Julian Dontcheff's Database Blog

05.11.2024

Indexing and partitioning of JSON Collection Tables in Oracle Database 23ai | Julian Dontcheff's Database Blog

In the Oracle Database, a JSON Collection Table is a special table that provides JSON documents in a single JSON-type object column named DATA. JSON Collection Tables stores JSON documents. You can create such a collection by using the CREATE JSON COLLECTION TABLE command.  Each document in a JSON Collection Table must have a document-identifier field, _id, at the top level, whose value…

Julian Dontcheff's Database Blog

14.11.2024

Using the PL/SQL Profiler in the Oracle Autonomous Database | Julian Dontcheff's Database Blog

The PL/SQL (Hierarchical) Profiler has been part of the Oracle database for quite some time but there is very little, close to none, information on how to use it in the Oracle Autonomous Database. This blog post is about how to bypass few hurdles in the Autonomous database for we lack OS access in ADB-S.…

Julian Dontcheff's Database Blog

19.12.2024

Outliers, high-entropy and flex columns in JSON-to-Duality | Julian Dontcheff's Database Blog

Fun fact: by coffee consumption by country in 2024, Finland is #1 in the world. If you are familiar with JSON and still wondering about the meaning of the words in the title, then that's fine - these are relatively new concepts related to arguably the most important feature of Oracle Database 23ai: JSON Relational…

Contenting Logo
About UsPrivacy PolicyTerms Of UseContact