Monday, April 28, 2014

KScope14's Sunday Database Symposium

    This is the 3rd year Chet aka oraclenerd  and I have organized the Sunday Symposium.  This year has a bunch of great speakers with great content.  So, if you are debating at all getting to KScope a day early to make the symposium, here's the agenda for the DB Symposium and debate no more get there early !



Starting off the APEX and DB tracks will be combined.  


Oracle Database Tools  -  Mike Hichwa 


Mike Hichwa, Vice President of Database Tools, will provide an insight into the latest development of database tools and the Oracle Database Cloud Service. Everybody who is currently utilizing Oracle database tools should attend this session. 

Restful Access to Your Data  -  Kris Rice 


Representational State Transfer (REST) enables data to be shared over HTTP(s) allowing data access from virtually any platform or language. Oracle REST Data Services ( ORDS ) make this easier than ever to RESTfully enable your database. This session will start with an overview of what REST is and why it is growing in popularity as well as cover all the upcoming features in ORDS that includes: Auto enablement of relational data, Oracle Database 12 JSON support, and Oracle NoSQL support.  

Split to separate DB track


Best PL/SQL Features You Never Heard Of (or certainly don’t use)  - Steven Feuerstein


Hop out of the deep ruts of your programming habit and learn how to take advantage of some under-utilized but very powerful features of the finest database programming language in Planet Earth.

Storing and Querying JSON Data in Oracle Database 12c  -  Mark Drake 


JSON has been widely adopted as a mechanism for persisting structured and semi-structured data in recent years. Application developers are particularly attracted to the schema later / schema never nature of JSON, which allows them to evolve their application data model at will. The rising popularity of JSON has been accompanied by wider adoption of 'document stores' such as MongoDB and CouchDB.
    This session will show how new features of Oracle Database 12c allow the database to be used as a JSON document store. It will show how the database can deliver JSON storage, indexing and queryability, combined with performance, and full life-cycle support for JSON data, while still providing developers with all the flexibility that attracted them to JSON in the first place. The session will also touch on new API’s that make it very easy to use the Oracle Database as a JSON Document store. These new APIs are designed to support the programming paradigms and frameworks used by today’s cutting-edge developer They enable the use of popular document centric approaches, such as REST,  to be used to perform Create, Retrieve, Update and Delete operations on JSON documents managed by an Oracle database, without having to make use of traditional relational technology such as SQL, OCI, or JDBC.

Oracle SQL Developer and Oracle Database 12c  - Jeff Smith


Discover and exploit new Oracle Database 12c features such as multitenant container databases and data redaction with Oracle SQL Developer. This session also covers other Oracle Database 12c SQL and PL/SQL language enhancements that are available to all Oracle SQL Developer users. 

Applications HA Solutions for Planned and Unplanned Database Outages - Kuassi Mensah 



Upon database instance outage, applications are confronted with four issues: (1) hang and control loss, (2) error handling, (3) reliable determination of the outcome of in-flight work, and (4) resubmission of uncommitted transactions. This session introduces Oracle Database 12cApplication Continuity, which addresses all four issues. Fast Application Notification addresses the hang, Recoverable Error classification enables applications to interpret SQL exceptions without maintaining a list of error codes, Transaction Guard enables reliable determination of the outcome of in-flight work, and Application Continuity solves the resubmission of the uncommitted transaction. The session also discusses configuration and design considerations.