JSON Data and Relational Data Integration in Oracle

Abstract

Data is of major importance in the IT industry nowadays. The need to work with a wide variety of existing data is becoming more and more pressing. IT professionals need to transfer data structures from any language into formats that are recognized by other languages and platforms. JSON (JavaScript Object Notation) is the format that is more and more often used for data exchange. This format has been widely accepted by IT developers because its text is easy to read and understand, it is faster and easier to process, and requires less coding. In this article, we shall show how the Oracle database works with JSON data and how it can be integrated with relational data.

Keywords

• json data
• relational data
• integration
• sql
• soda