Oracle Database 23ai โ ๐๐จ๐ง๐ฏ๐๐ซ๐ ๐๐ ๐๐๐ญ๐๐๐๐ฌ๐
๐๐จ๐ง๐ฏ๐๐ซ๐ ๐๐ ๐๐๐ญ๐๐๐๐ฌ๐๐ฌ offer a unified platform for storing, managing, and analyzing a wide range of data types and workloads, including relational, JSON, spatial, graph, vector and more (๐ฆ๐ฎ๐ฅ๐ญ๐ข-๐ฆ๐จ๐๐๐ฅ ๐๐๐ญ๐๐๐๐ฌ๐).
๐ And now, Oracle has introduced its groundbreaking new database solution, #23๐๐ข, which takes converged databases to the next level!๐
The following are some of the supported data types for storing your valuable data:
1. ๐๐๐ฅ๐๐ญ๐ข๐จ๐ง๐๐ฅ: Our traditional data type, organizes information into tables with rows and columns. It enforces data integrity through constraints such as primary keys, foreign keys, and unique constraints.
โ
2. ๐๐๐๐: JSON is a text format for storing and transporting data. In 23ai, JSON-relational duality view seamlessly integrates relational database tables and JSON documents, offering the benefits of both models without compromising on flexibility or storage efficiency.
๐๐๐๐๐๐ ๐๐ ๐๐๐๐๐๐๐ ๐๐๐๐ ๐๐๐๐๐๐๐๐๐๐ ๐๐๐๐๐๐๐ ๐๐๐๐ ๐๐๐๐๐๐_๐๐ ๐๐
๐๐๐๐๐๐ ๐๐๐๐ { โ๐๐ณ๐ฅ๐ฆ๐ณ๐๐ฅโ : ๐ฐ๐ณ๐ฅ.๐ฐ๐ณ๐ฅ๐ฆ๐ณ_๐ช๐ฅ, โฆ..
3. ๐๐ฉ๐๐ญ๐ข๐๐ฅ: It refers to geographic or location-based information that is stored and managed within the database. It includes data types and functions specifically designed to handle spatial data, such as points, lines, polygons, and other geometric shapes.
4. ๐๐ซ๐๐ฉ๐ก: It represented as a graph structure, consisting of nodes (entities) and edges (relationships) between them. In 23c Free, the GRAPH_TABLE function and MATCH clause, enable you to write simple SQL queries to traverse data connections.
Get Baig Mohammedโs stories inย yourย inbox
Join Medium for free to get updates fromย thisย writer.
5. ๐๐๐๐ญ๐จ๐ซ: It provides the foundation to store vector embeddings alongside business data in the database.
Oracle AI Vector Search, part of Oracle Database 23ai, introduces a range of features including a new vector data type, indexes, and search operators. It enables storing the meaning of unstructured data like documents and images as vectors for quick similarity searches. It also supports Retrieval Augmented Generation. Check my old post on how hashtag#RAG works ๐https://lnkd.in/gDvwMMqZ
GPT 3.5 and 4.0 from OpenAI, as well as Cohere, Llama2, Mistral, Gemini, Palm2, and Vertex AI, underwent testing.
๐๐ซ๐๐๐ฅ๐ ๐๐๐ญ๐๐๐๐ฌ๐ 23๐๐ข ๐๐จ๐๐ฎ๐ฆ๐๐ง๐ญ๐๐ญ๐ข๐จ๐ง to get started: https://lnkd.in/gap8nyRv
The following are the steps to create the 23ai autonomous database in Oracle Cloud Infrastructure (OCI):
For further details on creating 23AI instance on OCI and sample code, stay tuned for my upcoming post.
#Oracle23ai #OracleCloud #OCI #ConvergedDatabase #OracleACE #23ai
I hope you liked the article, please leave your thoughts in comments.
