Oracle Magazine, July/August 2017
Database Developer and DBA ETL For example to meet the stringent data integrity needs of financial transaction processing applications Oracle Database is a natural technology fit but for simpler key value pair requirements a business may opt for Oracle NoSQL Database The fundamental unit of storage in many NoSQL databases is a document and rather than using multiple relational structures a NoSQL database stores data in much larger chunks typically in documents of a proprietary format or an open standard such as JavaScript Object Notation JSON It is already possible to query data from for example a Hadoop Distributed File System HDFS datastore by creating and using an external table definition in Oracle Database SQL create table CUSTOMER_ RAWDATA 2 customer_ number number 3 customer_ name varchar2 50 4 postal_ code char 5 5 6 organization external 7 type oracle_ hdfs 8 default directory TEMP 9 access parameters 10 11 com oracle bigdata cluster hadoop_ clust 12 com oracle bigdata rowformat delimited fields terminated by 13 14 location hdfs p1a dat 15 hdfs p1b dat ORACLE MAGAZINE JULY AUGUST 2017 89
You must have JavaScript enabled to view digital editions.