Subscribe: 360 Degree DB Programming
http://db360.blogspot.com/feeds/posts/default
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: 360 Degree DB Programming

360 Degree DB Programming & Analytics



Oracle Database Integration with Java, JavaScript, Hadoop, Spark I - Java in the database, JDBC, UCP, DRCP, Application Continuity, Transaction Guard II - Oracle Datasource for Hadoop (OD4H), In-Database Container for Hadoop, Orale Datasource for S



Updated: 2018-04-18T04:43:04.348-07:00

 



Optimizing the Performance & Scalability of Java Applications that use an RDBMS

2018-04-10T09:05:43.973-07:00

PreambleThere is an abundant literature on Java performance (books, articles, blogs, websites, and so on); a Google search returns more than 5 millions hits. To name a few, the Effective Java programming language guide, Java Performance the definitive guide, Java performance tuning newsletter and associated http://www.javaperformancetuning.com website. This is not the purpose of this post.The goal of this post is to revisit the known best practices for speeding up and scaling database operations for Java applications then discuss database proxy and the upcoming standard Java API for asynchronous database access (ADBA).Even those familiar with Java optimization techniques will learn new tips!Speeding up Java applications that use an RDBMSOptimizing database operations for Java applications includes: speeding up database connectivity, speeding up SQL statements processing, optimizing network traffic, and in-place processing. Speeding up Database ConnectivityConnection establishment is the most expensive database operation; the obvious optimization thatJava developers have been using for ages is connection pooling which avoid creating connections at runtime. Client-side Connection PoolsJava connection pools such as the Apache Commons DBCP, C3P0, as well as the Oracle  Universal Connection Pool (UCP) and many others,  run as part of your stand-alone Java/JDBCapplications  along the JDBC libraries or as part of Java EE containers datasources (e.g.,Tomcat, Weblogic, WebSphere and others). Java EE containers usually furnish their ownconnection pools but they also allow replacing theirs with 3rd party pools (see usingUCP with Tomcat, UCP with Weblogic). Most Java developers use these client-side or mid-tier connection pools for sustaining small and medium workloads however, these connection pools are confined to the JRE/JDK instance(i.e., can't be shared beyond the boundary of the JRE/JDK) and unpractical when deployingthens of thousands of mid-tiers or Web servers. Even with very small pool size each, the RDBMS server  is overwhelmed by thens of thousands of pre-allocated connections that are idle (morethan 90% of the time).Proxy Connection PoolsProxy connection pools such as MySQL Router, Oracle Database Connection Manager in Traffic Director Mode (CMAN-TDM), and others, are part of proxy servers that sit between the database clients (i.e., Java apps) and the RDBMS. These allow thousands of database clients to share a common connection pool. I will discuss this a bit more, near the end of this post.The Oracle database also furnishes database-side connection pools such as  the Shared Servers, and the Database Resident Connection Pool (DRCP). We will not discuss those in this post.Other connection optimization features include: deferring connection health check and the de-prioritization of failed nodes.   Deferring Connection Health CheckThe ability of a connection pool such as Oracle's Universal Connection Pool (UCP) to avoidchecking the health of connections for a defined period of time, improves the latency ofconnection check-out (i.e., getConnection() returns faster).De-prioritization of Failed NodesIn a multi-instances clustered database environment such as Oracle RAC,  this JDBC feature assignsa low priority to a failed instance for a user-defined period of time thereby reducing the connectionestablishment latency (iow, avoid attempting to get connections from the failed instance).Optimizing Statements ProcessingThe default COMMIT mode with JDBC is Auto-COMMIT; unless this corresponds to your desire, you should explicitly disable Auto-COMMIT on the connection object.conn.setAutoCommit(false);Processing a SQL statement requires several steps including: parsing, binding variables, executing,fetching resultSets (if a[...]



Slides of my JavaOne and OOW 2017 sessions

2017-11-06T20:15:16.930-08:00

The slides of my recommended JavaOne 2017 and OOW2017 sessions are available here.



My Sessions Recommendations for JavaOne and Oracle Open World 2017

2017-09-18T10:22:55.646-07:00

Good Day,

JavaOne, and Oracle Open World are 4 exactly weeks away.

Here are some sessions related to Java, JDBC, OJVM (database embedded JVM), JavaScript Nashorn (JavaSCript data access, JavaScript stored procedures), Apache Spark, Apache Hadoop, Apache Flink, Apache Beam that I'd warmly recommend.

JavaOne 2017 Sessions Recommendations


OpenWorld 2017 Sessions Recommendations




Carbonated Java & JavaScript Stored Procedures

2017-08-08T10:12:50.302-07:00

Carbonated Java Stored Procedures

For accessing JSON Collections and documents without any knowledge of SQL, Oracle furnishes the SODA for Java API. It allows a convenient access and navigation using the dot notation.

How to use SODA for Java in Java Stored Procedures? I have posted the steps, the code samples and scripts on GitHub.

Carbonated JavaScript Stored Procedures 

Nashorn allows interoperability between Java and javaScript. By leveraging such interoperability, I've been able to reuse SODA for Java with JavaScript Stored Procedures.

How to use SODA for Java in JavaScript Stored Procedures? I have posted the steps, the code samples and scripts on GitHub.

Enjoy!



What's in Oracle Database 12c Release 2 for Java & JavaScript Developers?

2017-08-08T10:10:53.619-07:00

Here is the summary of New Java & JavaScript Features in Oracle Database 12c Release 2 on Cloud and on-PremiseJava 8: Java 8 in JDBC/UCP and OJVM; JDBC 4.2JavaScript with Nashorn: JDBC/UCP, OJVMPerformance: JIT (OJVM), Network Compression over WAN (JDBC), Configurable connection health check frequency (UCP), PL/SQL Callback interface (JDBC)Scalability: Shared Pool for Multi-Tenant Database (UCP), Shared Pool for Sharded database (UCP), Sharding Key APIs (JDBC, UCP), DRCP Proxy session sharing, DRCP support for  multiple labelsHigh-Availability: Java APIs for FAN events (SimpleFan.jar), Planned Maintenance in the driver (JDBC), Application Continuity for XA Datasources, Transaction Guard for XA DatasourceSecurity: SSL v1.2 / TLS v 1.2 (JDBC)Manageability: XMLconfiguration (UCP), Enable/disable/suspend/resume feature level logging (JDBC), MAX_THINK_TIME for Transactions in progress (DRCP), new statistics view and AWR reports  Ease of Use : Web Services Callout (OJVM), Long Identifiers (OJVM), PL/SQL Boolean (JDBC), Debugger for OJVM (Java Debug Wire Protocol)See our latest white paper for more details.[...]



My Talks/Sessions at UKOUG Tech16

2016-12-02T13:43:55.864-08:00

Hi guys,If you plan to attend UKOUG Tech16, please check out my talks.sessions Sunday 12/04 16:10  New JDBC & UCP Perf, Scalability & HA features in Oracle Database 12cR2 @ http://bit.ly/2f9m0ZAMonday 12/05 17:55 A RESTful MicroService for JSON Processing in Oracle Database 12c R2 @ bit.ly/2gqmfgB   Wednesday 12/07 8:50 12Hadoop, Spark & Flink Explained to Oracle DBAs & why They Should Care @ https://t.co/7CGLchAYAFWednesday 12/07 15:10 Integrate BigData with Master Data: Oracle database table as Hadoop Datasource @ http://bit.ly/2gzwU8w  See you there[...]



REST Enable Java or JavaScript in the Database

2017-04-05T11:53:00.700-07:00

REST Enable Java or JavaScript in the DatabaseThe Oracle REST Data Service (ORDS) allows you to turn Java stored procedures or JavaScript stored procedures into REST Web Services that you may publish these in the Oracle REST Data Service.See more details @ http://www.oracle.com/technetwork/developer-tools/rest-data-services/overview/index.htmlPrerequisiteThis article assumes you've already loaded your Java or JavaScript code in the Oracle database 12c Release 2 (for JavaScript); for Java, any supported database release will do (Oracle has been supporting Java in the database since version 8i.)This blog post describes how to load and run JavaScript in Oracle database 12c Release 12.2.Download and Configure ORDS1) First step: download the latest ORDS  @ http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html2) Extract the zip file in a directory say ../ords.3.0.83) Configure and Install$ ls docs logs params examples ords.war readme.htmlNavigate into params directory and edit the ords_params.properties file. Modify the standalone.http.port value to a desired port # (e.g., 8090) and save the file.$vi params/ords_params.properties#Tue Jul 26 05:23:16 UTC 2016db.hostname=db.port=db.servicename=db.sid=db.username=APEX_PUBLIC_USERmigrate.apex.rest=falserest.services.apex.add=rest.services.ords.add=trueschema.tablespace.default=SYSAUXschema.tablespace.temp=TEMPstandalone.http.port=8090standalone.static.images=user.tablespace.default=USERSuser.tablespace.temp=TEMP~ ~ ~ ~ ~ "params/ords_params.properties" 17L, 467C 1,1 AllNote: Do not modify any other property$ java -jar ords.warThis Oracle REST Data Services instance has not yet been configured.Please complete the following promptsEnter the location to store configuration data:/u01/oracle/ords.3.0.6/ordsiEnter the name of the database server [localhost]:Enter the database listen port [1521]:Enter 1 to specify the database service name, or 2 to specify the database SID [1]:Enter the database service name:pdb1Enter the database password for ORDS_PUBLIC_USER:Confirm password:Please login with SYSDBA privileges to verify Oracle REST Data Services schema.Enter the username with SYSDBA privileges to verify the installation [SYS]:Enter the database password for SYS:Welcome1Confirm password:Welcome1Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:2Sep 07, 2016 3:53:19 AM oracle.dbtools.common.config.file.ConfigurationFilesBase updateINFO: Updated configurations: defaults, apex_puInstalling Oracle REST Data Services version 3.0.6.176.08.46... Log file written to /u01/oracle/ords.3.0.6/logs/ords_install_core_2016-09-07_035319_00534.log... Verified database prerequisites... Created Oracle REST Data Services schema... Created Oracle REST Data Services proxy user... Granted privileges to Oracle REST Data Services... Created Oracle REST Data Services database objects... Log file written to /u01/oracle/ords.3.0.6/logs/ords_install_datamodel_2016-09-07_035342_00050.logCompleted installation for Oracle REST Data Services version 3.0.6.176.08.46. Elapsed time: 00:00:23.840 Enter 1 if you wish to start in standalone mode or 2 to exit [1]:1Enter 1 if using HTTP or 2 if using HTTPS [1]:12016-09-07 03:54:28.867:INFO::main: Loggin[...]



1 Comments

2017-05-26T15:28:51.836-07:00

JavaScript in Oracle Database 12c Release 2JSR 223 introduced the idea of Scripting for the Java platform. Java 8 furnishes the Nashorn JavaScript engine as a more performant replacement for Rhino Per the Redmonk ranking (http://redmonk.com/sogrady/2016/07/20/language-rankings-6-16/) and the TIOBE index (http://www.tiobe.com/tiobe-index), JavaScript is one the most popular programming languages, disputing the top seat with Java.This blog post is an update to a previous post which discussed the rationales and a proof of concept of Nashorn (JavaScript on the JVM) and Avatar (Node APIs on the JVM. This update discusses the real production implementation of Nashorn on the JVM in rhe database.Rationales for JavaScript in the DatabaseThe embedded JVM in Oracle Database 12c Release 2 (a.k.a. OJVM) supports Java 8 and the Nashorn JavaScript engine.Running JavaScript in the database stemmed from the same motivations for running Java in the database namely: reuse of skills, libraries and code for implementing data-bound modules or applications and performance.However, JavaScript in the database makes sense only when it is processing data stored in the database thereby - and this is another major motivation -- yielding better performance by the virtue of running close to the data. The beauty of the Nashorn JavaScript engine on the JVM is the ability to call Java APIs from JavaScript e.g., calling JDBC APIs from JavaScript, for database access.Let's create an EMPLOEES table storing employees data as JSON documentsCREATE TABLE employees ( id RAW(16) NOT NULL, data CLOB, CONSTRAINT employees_pk PRIMARY KEY (id), CONSTRAINT employees_json_chk CHECK (data IS JSON));INSERT INTO employees (id, data)VALUES (SYS_GUID(), '{ "EmpId" : "100", "FirstName" : "Kuassi", "LastName" : "Mensah", "Job" : "Manager", "Email" : "kuassi@oracle.com", "Address" : { "City" : "Redwood", "Country" : "US" } }');......INSERT INTO employees (id, data)VALUES (SYS_GUID(), '{ "EmpId" : "300", "FirstName" : "Suresh", "LastName" : "Mohan", "Job" : "Developer", "Email" : "Suresh@oracle.com", "Address" : { "City" : "Bangalore", "Country" : "India" } }');COMMIT;Here is a JavaScript code which uses JDBC for querying JSON documents stored in the EMPLOYEE table.var selectQuery = function(id){ var Driver = Packages.oracle.jdbc.OracleDriver; var oracleDriver = new Driver(); var url = "jdbc:default:connection:"; var output = ""; var connection = oracleDriver.defaultConnection(); var prepStmt; // Prepare statement if(id == 'all') { prepStmt = connection.prepareStatement("SELECT a.data FROM employees a"); } else { prepStmt = connection.prepareStatement("SELECT a.data FROM employees a WHERE a.data.EmpId = ?"); prepStmt.setInt(1, id); } // execute Query var resultSet = prepStmt.executeQuery(); // display results while(resultSet.next()) { output = output + resultSet.getString(1) + ""; } // cleanup resultSet.close(); prepStmt.close(); connection.close(); return output;}Fluent JavaScript API using SODA for Java with NashornFor accessing JSON Collections and documents, Oracle furnishes SODA for Java; this API allows No SQL and dot notation access to JSON.Check out the code samples and scripts for running testSODA.java and testSODA in OJVM  How to Run JavaScript in Oracle Database Your  schema (or database user) must be granted the DBJAVASCRIPT role (check with your DBA).Your JavaScript source code (select) may originate from strings, files or Java resources.funct[...]



0 Comments

2016-08-24T10:35:55.193-07:00

JavaOne and OOW 2016: Sessions RecommendationsIf you are attending JavaOne and/or Oracle OpenWorld, here are my sessions  recommendations.1) JavaOne  How Multidimensional Search Trees Speed Up a Java Connection Pool [CON2843]Tuesday, Sep 20, 5:30 p.m. - 6:30 p.m. | Parc 55 - Cyril Magnin II/IIIJDBC Next: A New Nonblocking API for Connecting to a Database [CON1578]Monday, Sep 19, 12:30 p.m. - 1:30 p.m. | Hilton - Continental Ballroom 1/2/3 Scalability and HA with Java EE Containers, JDBC, and Java Connection Pool [BOF1566]Tuesday, Sep 20, 8:00 p.m. - 8:45 p.m. | Parc 55 - Cyril Magnin II/III2) Oracle OpenWorld Oracle Database 12c Release 2 JDBC and UCP Features and Best Practices [CON6454]Tuesday, Sep 20, 12:15 p.m. - 1:00 p.m. | Park Central - OlympicA RESTful Microservice for JSON in Oracle Database 12c Release 2 [CON6358]Thursday, Sep 22, 9:30 a.m. - 10:15 a.m. | Park Central - Olympic Querying Oracle Table from Hadoop/Hive and Querying Hadoop/HDFS from PL/SQL [CON6359]Monday, Sep 19, 4:15 p.m. - 5:00 p.m. | Park Central - Metropolitan IIMeet the Developers and get Your Questions Answered [MTE7183]Tuesday, Sep 20, 7:15 p.m. - 8:00 p.m. | Moscone South - 3103) Must-See Guide for Data Warehousing and Big Data  PDF version can be downloaded by clicking hereApple iBooks version can be downloaded by clicking here[...]



My sessions recommendations for JavaOne '15 and OOW '15

2015-10-19T10:49:21.571-07:00

JavaOne SF 2015  Session recommendationsHigh Availability with Java EE Containers, JDBC, and Java Connection Pools [BOF7732]Monday, Oct 26, 8:00 p.m. | Parc 55—MissionImplement Cloud Data Services with Java 8 Nashorn [CON4405]Tuesday, Oct 27, 4:00 p.m. | Hilton—Continental Ballroom 1/2/3Java Connection Pool Performance and Scalability with Wait-Free Programming [CON2158]Wednesday, Oct 28, 4:30 p.m. | Hilton—Continental Ballroom 1/2/3OOW SF 2015 - Session recommendationsJava Virtual Machine Cookbook [UGF2720]Sunday, Oct 25, 9:00 a.m. | Moscone West—3011Next-Generation Database: Implement Cloud Data Services with Java 8 Nashorn [CON8461]Monday, Oct 26, 5:15 p.m. | Moscone South—308Next-Generation Database: Java Connection Pool for Multitenant and Sharded Databases [CON8460]Monday, Oct 26, 2:45 p.m. | Moscone South—308Integrate Master Data with Big Data on Hadoop and Spark [CON8459]Wednesday, Oct 28, 3:00 p.m. | Moscone South—308Market Basket Analysis Using Oracle In-Database Container for Hadoop [CON8462]Thursday, Oct 29, 12:00 p.m. | Moscone South—307Next-Gen Database Enhancements for Java Application Performance and Scalability [CON10310]Thursday, Oct 29, 2:30 p.m. | Moscone South—307Dialog with the Oracle Database Java Developers and Architects [MTE9501]Tuesday, Oct 27, 7:15 p.m. | Moscone South—305[...]



JavaScript stored procedures as Cloud data services.

2015-09-08T15:37:05.218-07:00

Find out how to implement JavaScript Stored Procedures with Oracle Database 12c and how to invoke these through RESTful Web Services.

https://blogs.oracle.com/java/entry/nashorn_and_stored_procedures



JavaScript Stored Procedures and Node Applications with Oracle Database 12c

2017-04-05T16:10:28.589-07:00

JavaScript Stored Procedures and Node Applications with Oracle Database 12c                                       Kuassi Mensah                                    db360.blogspot.com | @kmensah | https://www.linkedin.com/in/kmensah Keywords: JavaScript, Node, Java, JVM, Nashorn, AvatarIntroduction                                                            Node and server-side JavaScript are hot and trendy; per the latest “RedMonk Programming Languages Rankings”[1], JavaScript and Java are the top two programming languages. For most developers building modern Web, mobile, and cloud based applications, the ability to use the same language across all tiers (client, middle, and database) feels like Nirvana but the IT landscape is not a green field; enterprises have invested a lot in Java (or other platforms for that matter) therefore, the integration of JavaScript with it becomes imperative. WebSockets and RESTful services enable loose integration however, the advent of JavaScript engines on the JVM (Rhino, Nashorn, DynJS), and Node APIs on the JVM (Avatar, Nodyn, Trireme), make possible and very tempting to co-locate Java and Node applications on the same JVM. This paper describes the steps for running JavaScript stored procedures[2]directly on the embedded JVM in Oracle database 12c and the steps for running Node applications on the JVM against Orace database 12c, using Avatar, JDBC and UCP.           JavaScript and the Evolution of Web Applications Architecture                                   At the beginning, once upon a time, long time ago, JavaScript was a browser-only thing while business logic, back-end services and even presentations where handled/produced in middle-tiers using Java or other platforms and frameworks. Then JavaScript engines (Google’s V8, Rhino) leave the browsers and gave birth to server-side JavaScript frameworks and Node.Node Programming ModelNode and similar frameworks bring ease of development rapid prototyping, event-driven, and non-blocking programming model[3]to JavaScript. This model is praised for its scalability and good enough performance however, unlike Java, Node lacks standardization in many areas such as database access i.e., JDBC equivalent, and may lead, without discipline, to the so called “callback hell[4]”.Nonetheless, Node is popular and has a vibrant community and a large set of frameworks[5].Node Impact on Web Applications ArchitectureWith the advent of Node, REST and Web Sockets, the architecture of Web applications has evolved into (i) plain JavaScript on browsers (mobiles, tablets, and desktops); (ii) server-side JavaScript modules (i.e., Node, ORM frameworks) interacting with Java business logic and databases.The new proposal for Web applications architecture is the integration of Node and Java on the JVM.  Let’s discuss the enabling technologies: JavaScript engine on the JVM and Node API on the JVM and describe typical use cases with Oracle database 12c.  JavaScript on the JVMWhy implement a JavaScript engine and run JavaScript on the JVM? For starters, i highly recommend Mark Swartz ‘s http://moduscreate.com/javascript-and-the-jvm/and Steve Yegge[...]



My DOAG session re:Server-side JavaScript

2014-11-18T02:31:04.380-08:00

#DOAG Wed 19/11 17:00 rm HongKong Server-side #JavaScript (#NodeJS) progrm#OracleDB using #nashorn & Avatar --#db12c @OracleDBDev #javaWill post shortly ablog re: JavaScript Stored Procedures. [...]






Preview [video]: Apps HA Solutions for Planned & Unplanned DB Downtime w UCP

2014-06-21T21:56:08.479-07:00

http://bit.ly/V0Dycf 



My sessions at JavaOne and OOW 2014

2014-06-18T19:45:20.756-07:00

My sessions at JavaOne 2014  San FranciscoCON1815 - JavaScript Across Tiers with Nashorn and Avatar BOF1826 - MapReduce over an RDBMS: JDBC Storage Handler or In-Database Container for Hadoop? CON1851 - Java Applications: At-Most-Once COMMIT Protocol and Capture/Replay Database Calls Other JavaOne sessions from my teamsCON2152 - DistributableStream: A Java 8 Stream Computational Model for Big Data Processing My sessions at Oracle OpenWorld 2014CON8300 - Analyze Oracle Database Data from Hadoop Compute Engines (HiveQL, Spark, Impala, and others) CON7757 -  Design Applications for Planned and Unplanned Database Downtime CON8373 - In-Database MapReduce: Near Real-Time Analytics with Hadoop and SQLCON7787 - JavaScript and Node Apps with Oracle Database 12c, Using Nashorn, Avatar, and JDBCOther OOW sessions from my teamsCON7785 - Performance/Scalability with JDBC, Oracle Universal Connection Pool, and Oracle Database 12c [...]



Run Scala directly in Oracle database

2014-02-27T04:15:00.785-08:00

A nice proof of concept for #Scala, #java, #Oracle, and #db12c, afficionados http://bit.ly/1o8gejG




En route for OTN Yathra

2014-02-17T09:27:47.684-08:00

En route for OTN Yathra (http://t.co/E0KUudWOLn) first stop Mumbai customers visits #java #db12c #mapreduce #hadoop #oracletechnet



Rocky Mountain OUG: what's up Feb 6th @ 8:30am in Room 504?

2014-02-05T18:17:55.475-08:00

 Why get up early and show up in Room 504? http://bit.ly/1cgzgy1 #Java #db12c #OracleRac



Speaking at OTN Yathra (India)

2014-01-29T10:01:17.371-08:00

Speaking @ http://t.co/E0KUudWOLn Mumbai/Pune/Chennai In-Database#MapReduce for DBAs and Database Developers using SQL or #Hadoop



Rocky Mountain Oracle Users group event

2014-01-24T15:16:36.985-08:00

 
Join me at #RMOUG Feb 6th 8:30 Rm 504:; i'll be presenting #JavaPerf., Scalability, Availability & Security w Oracle #db12c --#OracleRac -- http://bit.ly/1cgzgy1



OTN Virtual Developers Days

2014-01-24T22:17:29.135-08:00

Join me on Feb 4th @ http://t.co/nheuk9MBZd

at 10:15am: "In-Database MapReduce w SQL & Hadoop"  then 12:15pm "Best Practices 4 App Performance, Scalability and High-Availability with Oracle Database 12c"



My Sessions at Oracle OpenWorld and JavaOne 2013

2013-09-10T14:52:19.786-07:00

Have you ever needed to deploy Java applications with tens of thousands of concurrent users?Have you ever experienced paying twice the same flight ticket, the same article or your taxes? Have you ever wanted the system to just deal with database failure and not ask you to restart your transaction from start?Looking to exploit the new Oracle Multitenant Container Database with Java?Looking to analyze structured data using Mapreduce patterns?Looking to implement MapReduce patterns using SQL and Hadoop?If you are a Java architect, Java designer or wannabe looking to exploit new Oracle database 12c enhancements in the areas of performance, scalability, availability, security and manageability/ease-of-use, here are sessions for you. Register and book your seats ASAP!My SessionsMeet the Developers of Oracle Database 12c JDBC, Oracle UCP, and JVM in the Database - BOF110539/23/13 (Monday) 6:15 PM - Marriott Marquis - Foothill FWhat’s New for Java Performance, Scalability, and Security with Oracle Database 12c - CON85979/25/13 (Wednesday) 11:45 AM - Marriott Marquis - Salon 7Oracle Database 12c Application Continuity and Transaction Guard - CON86009/24/13 (Tuesday) 5:15 PM - Marriott Marquis - Salon 8In-Database MapReduce for DBAs and Database Developers Using SQL or Hadoop - CON86019/25/13 (Wednesday) 10:15 AM - Marriott Marquis - Salon 7A JDBC Datasource for Failing Over and Replaying In-Flight Transactions - CON92349/24/13 (Tuesday) 3:00 PM - Hilton - Continental Ballroom 5In-Database Container for Hadoop: When MapReduce Meets RDBMS - CON92409/25/13 (Wednesday) 8:30 AM - Hilton - Continental Ballroom 4Oracle Database 12c In-Database MapReduce with SQL and Hadoop - HOL100159/23/13 (Monday) 10:45 AM - Marriott Marquis - Salon 3/4Java Performance, Scalability, Availability, and Security in Oracle Database 12c - HOL100169/23/13 (Monday) 1:45 PM - Marriott Marquis - Salon 3/4[...]



What's in Oracle Database 12c for Java?

2013-06-25T22:05:29.564-07:00

Looking to exploit the new Oracle Multitenant Container Database with Java?
Have you ever needed to deploy Java applications with tens of thousands of concurrent users? If you are a Java architect, Java designer or wannabe looking to exploit new Oracle database 12c enhancements in the areas of performance, scalability, availability, security and manageability/ease-of-use, this is the paper for you.

 Have you ever experienced paying twice the same flight ticket, the same article or your taxes? Have you ever wanted the system to just deal with database failure and not ask you to restart your transaction from start? Upon database outages (hardware, software, network, or storage failure), four problems confront applications: hangs, errors handling, determining the outcome of in-flight work (i.e., last COMMIT), and the resubmission in-flight work.
If you are application developer, database and system administrator, integrator or ISV looking to better exploit Oracle RAC and Active Data Guard to achieve maximum application availability, this is the paper for you (although with a Java focus).




My Guide for Oracle OpenWorld 2012

2012-09-23T19:05:18.542-07:00

Are you a Java developer, C/C++ developer, or PHP|Ruby|Perl|Python developer  looking to exploit the latest Oracle database technology?Are you a MapReduce/Hadoop developer or administrator?Are you MySQL developer looking to migrate or reuse your applications against Oracle?Are you a developer or Oracle DBA looking for Net Services Enhancements with the Latest Oracle Database Technology? Here is my list of sessions for you!Note: I will be either presenting, coordinating or attending these sessions, so if you want to see/meet me, you know where to go!1/ MapReduce and Hadoop developer and administrator: what is new in the latest Oracle database technology?In-Database Hadoop: When MapReduce Meets the RDBMSWhere: Parc 55 - EmbarcaderoWhen: 10/3/12, 15:00 - 16:00In-Database MapReduce and Scalable Data Manipulation Where: Marriott Marquis - Salon 10/11When: 10/2/12, 17:00 - 18:00 Hadoop part of "In-Database Java VM: New Enhancements and Killer Application" Where: Marriott Marquis - Golden Gate C1When: 10/2/12, 13:15 - 14:15In-Database MapReduce part of "Oracle’s Big Data Platform: Settling the Debate"Where: Moscone South - 302When: 10/2/12, 10:15 - 11:15 Visit us in the:(i) Oracle Red Lounge in Moscone North upper lobby  (ii) Java/JDBC demo booth (Database demo campground, Moscone South)Overall Big data Focus on2/ Java developers: what is new in the latest Oracle database technology?In-Database Java VM: New Enhancements and Killer ApplicationWhere: Marriott Marquis - Golden Gate C1When: 10/2/12, 13:15 - 14:15 New JDBC and Oracle Universal Connection Pool Enhancements with the Latest Database Technology Where: Marriott Marquis - Club RoomWhen: 10/3/12, 17:00 - 18:00Extreme Scalability/Availability: JDBC, Oracle Universal Connection Pool, Java in the DatabaseWhere: Marriott Marquis - Salon 10/11When: 10/1/12, 12:15 - 13:15 Meet the Developers: Oracle JDBC Drivers, Oracle Universal Connection Pool, JVM in the Database Where: Marriott Marquis - Foothill FWhen: 10/1/12, 18:15 - 19:00 Maximize Availability by Minimizing Disruption to End Users and ApplicationsWhere: Moscone South - 301When: Wednesday, Oct 3, 10:15 AM - 11:15 AMIn-Database Hadoop: When MapReduce Meets the RDBMSWhere: Parc 55 - Embarcadero (JavaOne)When: 10/3/12, 15:00 - 16:00 And Hadoop part of hands-on lab "In-Database MapReduce and Scalable Data Manipulation" Where: Marriott Marquis - Salon 10/11When: 10/2/12, 17:00 - 18:00Visit us in the Java/JDBC demo booth (Database demo campground, Moscone South)Check-out JavaOne 3/ C/C++ developer: what is new in the latest Oracle database technology?Best Practices for Application Performance, Scalability, and AvailabilityWhere: Marriott Marquis - Club RoomWhen: 10/1/12, 10:45 - 11:45Meet the Developers of Database Access Services (OCI, ODBC, DRCP, PHP, Python)Where: Marriott Marquis - Foothill FWhen: 10/1/12, 19:15 - 20:00Run MySQL Applications Against the Latest Oracle Database Technology Where: Marriott Marquis - Salon 10/11When: 10/1/12, 16:45 - 17:45Syndication and Consolidation: Oracle Database Driver for MySQL ApplicationsWhere: Marriott Marquis - Club RoomWhen: 10/1/12, 13:45 - 14:45  Visit us in the Data Access and Net Services demo booth (Database demo campground, Moscone South)4/ PHP|Python|Ruby|Perl developer5/ MySQL developer: what is new in the latest Oracle database techno[...]