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

15.08.2024

The Oracle Database API for MongoDB in Oracle Database 23ai | Julian Dontcheff's Database Blog

The Oracle Database API for MongoDB (Mongo API for short) lets applications interact with collections of JSON documents in the Oracle Database using MongoDB commands. Oracle Database understands Mongo-speak. That is the purpose of Oracle Database API for MongoDB. Here is why and where you might use the MongoDB API: You have one or more applications…

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

Contenting Logo
About UsPrivacy PolicyTerms Of UseContact