A new database architecture called sharding was introduced in Oracle 12cR2 database for linear scalability and complete fault isolation for OLTP workloads. This Oracle sharding architecture partition horizontally partitions data across discrete Oracle Databases (shards). All shards collectively form a single logical database. Come to this session to learn this new architecture and the related new features in Oracle 18c. We will share our experience with Oracle sharding through our POC project: what type of application best fit to this sharding architecture, how to deploy sharded database and how to implement replications for massive scalability and complete fault isolation on commodity hardware with local storage. Some of lessons learned will be shared and discussed in the session

In this session, Blaine Carter will demonstrate how to REST enable your database using Oracle Rest Data Services (ORDS). He will demonstrate how to use SQL Developer to create and deploy REST services in ORDS. First Blaine will "Auto Rest" enable a table and a PL/SQL package.  Then he will secure the API and create…

In just a few years, mainstream VR headsets like the Oculus are transforming the way businesses interact with computing. Virtual and Augmented Reality are key leading the way.  With new API's announced from Facebook (Oculus) and other headset vendors, the platform is opening up to business applications.  In this session, we show you how to…

Data security is critical for a business. Data is not just providing the business processes, workflows and intelligence but are the assets for the company. Protection of the data in databases and in-transit is important if on-premise or in the cloud. They might even been traveling between the two. The skill is mitigating the risk…

Get hands-on and learn the features of the Python cx_Oracle interface for Oracle Database. In this session learn efficient techniques for connection management, statement handling, and more. If you want to use Python and Oracle Database, this session is for you. Basic programming skills in any language are required

What does “autonomous” really mean, and what makes the database autonomous? If you’re looking for an answer to this question, this session is for you. In this session, we’ll cover the many benefits of autonomous capabilities and invite you to take a peek under the hood for a deep dive into the machine learning algorithms…

The most interesting new feature Oracle 18c introduces to Developers are Polymorphic Table Functions and Qualified Expressions. Polymorphic Table Functions finally allow the Developer to define the structure of the returned records at runtime. Qualified Expressions allows defining array- or record constructors that assign all values in a single statement. What looks at first sight…

One of the most critical aspects of building effective systems is the successful management of unstructured/semi-structured information. The database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of JSON has become one of the most critical elements of contemporary database infrastructure.

Even though you can store JSON documents in VARCHAR2 columns, in reality you will quickly outgrow VARCHAR2 size limitations and will have to switch to CLOBs for storage. However, few people in the development community really understand the underlying mechanics of Oracle LOB datatypes and consider it yet another DBA issue! This presentation attempt to fill that knowledge gap:

Core conceptual elements of how Oracle works with LOBs (multi-segment storage, IO mechanism, copy semantics/pointer semantics, etc.)
SecureFiles/BasicFiles implementation issues
Best practices of LOB manipulation (both generic and JSON-related)

Overall, this presentation gives database developers sufficient knowledge to be able to build efficient modern applications. Real-life examples will be included to pinpoint key ideas and solutions.

Setting up an Oracle Analytics Cloud (OAC) instance can be a little tricky. Learn the ins and outs of this fairly new Oracle offering in this session. Topics covered will be OAC parts and pieces, how to navigate in the Cloud environment, creating the database and OAC instance, building out an application and analysis and…

Learn from Oracle GoldenGate Product Management on the new GoldenGate 18c features, including a deeper dive into the new Microservices Architecture for automing Oracle GoldenGate.  And discuss enhancements related to Active-Active replication including the new Automatic Conflict Detection and Resolution features.