Cómo construimos Oracle TimesTen

1. Cómo construimos Oracle TimesTen Ricardo González #SGOracle

2. Cómo Construimos Oracle TimesTen Ricardo GonzalezSenior Product Manager

3. Agenda Oracle Oracle MDC TimesTen In-Memory Database Q & A <Insert Picture Here>

5. Oracle in a Nutshell • RDBMS • TimesTen • MySQL • SUN • 35 años • R $35.6 billones • NI $8.5 billones • +100k colaboradores

7. Why Guadalajara, Mexico ?

8. Oracle México Development Center

9. How is Oracle different Product vs. Project Development

10. Projects @ Oracle MDC • Gateways • Golden Gate • OLAP • Porting • Semantics • Spatial • TimesTen • Virtual Operating System • XAP • Enterprise Manager • Oracle Applications Lab • Real Application Clustering • Documentation • Curriculum Development • Automatic Storage Management • Clusterware* • Oracle Cloud File System • Quality of Service • Database Sustaining

11. TimesTen In-Memory Database

12. The Quest for Response Time • Failure to meet service level agreements (SLA) • Due to long response time • Customer churns • Competitive products offer better response time • Decreased user productivity and decreased customer satisfaction • Unhappy customers • Loss of revenue and decreased profitability • Effect of lost business and opportunities • Why is Response Time Important?

13. Improving Application Response Time • Define business requirements for latency • Evaluate solutions • Understanding Latency Requirements Result-set Cache (Client/Server) Disk Cache Array Magnetic Disks In-Memory Database Flash Storage, SSD Network round trips Buffer Cache L A T E N C Y Slower Faster

14. TimesTen In-Memory Database Over a Decade of Innovation

15. Enabling The Real-Time World Market Data, Market Events, Order Matching, Trading Real-Time Analytics - Interactive Dashboard Data Mart, Scorecard Authorization, Online Charging, Location-Based Services Real-Time Applications Instantly Responsive / Highly Scalable / Always-On Mainstream 64-bit Processors Large Capacity RAM Fast Networks Key Enabling Technology eCommerce, Personalization, Real-Time Ad Serving

16. What is Oracle TimesTen In-Memory Database Extremely fast Entire database in memory Microsecond response time Compatible with Oracle Database Standard SQL and PL/SQL, Datatypes JDBC, ODBC, ODP.NET, OCI, Pro*C Persistent and Recoverable Transactional logging and checkpointing Easy to use and deploy Client-Server Application TimesTen Client Lib Client/Server Direct-Linked Application JDBC / ODBC / ADO.NET / OCI / PLSQL TimesTen Libraries Fast data access Checkpoint Files Transaction Log Files Memory-Resident Database Memory Optimized Relational Database

17. 7 Millionths of a second 1.78 Millionths of a second Lightning Fast Response Time One Exalogic Compute Node Oracle TimesTen In-Memory Database 11.2.2.0 - Intel Xeon 5670 2.93Ghz, 2 CPUs, 6 cores/CPU - Oracle Linux 5.6

18. Client-Server Application TimesTen Client Lib Client/Server Direct-Linked Application JDBC / ODBC / ADO.NET / OCI / PLSQL TimesTen Libraries Fast data access Checkpoint Files Transaction Log Files Memory-Resident Database Why is TimesTen In-Memory Database so fast? • In-Memory Optimizations • Database in shared memory • Memory optimized access methods • Faster than fully-cached disk-based databases • Direct-link for best performance • Shared memory mapped into application process • Eliminates networking overhead

19. What If .. you have an existing Oracle Database?How to enable your application to use in-memory technology? Use TimesTen as an In-Memory Database Cache Oracle In-Memory Database Cache A product option for Oracle Database Enterprise Edition

20. Application Application Application Oracle In-Memory Database Cache Real-Time Analytics – Dashboard, Scorecard Data Mart Telco ServicesFinancial Services eCommerce, Personalization • Application-tier In-memory RDBMS • Accelerates applications • Uses standard SQL and PL/SQL • Caches Oracle Database tables • Read-write caching • Dynamic and static • Automatic synchronization • Scales up and scales out • Built-in high availability IMDB Cache Grid

21. In-Memory Database Cache Application Transactions • Cache Group describes the data in the Oracle database to cache • Collection of related tables • All or subset of rows and columns • Defined via SQL clauseCREATE CACHE GROUP name • FROM owner.tab1 (col1, col2), • owner.tab2 (col1, col4) • … • WHERE <predicate> • Cache tables are regular database tables in TimesTen • Joins/search, insert/update/delete • Flexible Cache Group Configurations Cache Groups Automatic Data Synchronization

22. Application Application Application In-Memory Database Caching • Read-Write caching • Transactions committed in TimesTen cache • Parallel write-through of committed transactions to Oracle Database • Read-only caching • Transactions committed in Oracle Database • Multi-stream refresh of committed transactions to TimesTen Reads/Write transactions Data Synchronization Reads/Write transactions Reads/Write transactions Automatic Data Synchronization

23. Application Application Application Application In-Memory Database Cache Grid • Location transparency • Usage-driven, adaptive redistribution of cached data • Online addition/removal of cache nodes • Scale out with growth • Parallel searches • Transactional consistency Incremental Scalability

24. Read-Write and Read-only Pre-loading of cache Data set pre-determined On-demand loading of cache Data set not pre-determined or too large Performance driven Locality optimized for consistent response time Globally shared across all nodes for application transparency Scale-out horizontally with processing capacity Flexible Caching Options

25. What does TimesTen offer for high availability? TimesTen Replication provides real-time replication of transaction data between TimesTen databases

26. Application Transactions Application Reads on Hot Standby Active Real-Time Transactional Replication High Availability and Disaster Recovery • High performance • Synchronous / Asynchronous • Memory-to-memory replication • Parallel send of log streams • Parallel apply of changes on Standby and Subscribers • HA and DR support • Online upgrades – no downtime Standby Subscriber Subscriber Subscriber Read-Only Subscribers - Reader Farm - Disaster Recovery

27. Application Programming Interfaces And Tools

28. ADO.NET ODBC OCI, Pro*C ttClasses Application Development SQL PL/SQL C/C++/C# OR Mapping J2EE App Servers Languages Java/JDBC

29. Minimal Application Changes • PL/SQL support • PL/SQL engine implemented inside TimesTen database • Same Oracle PL/SQL language; subset of packages • C/C++ support • Standard ODBC interface • Java support • Standard JDBC interface • Oracle APIs: ODP.NET, OCI, Pro*C/C++ • Support identical API signatures as used for the Oracle Database; subset of functions • Minimal application changes

30. TimesTen team @ oracle mdc

31. TT Team • Quality Assurance • 3 Software Developers • 3 System & Release Testing Engineers • Database Engine • 2 Software Developers • Documentation • 1 Technical Writer • Replication, Cache, EM Plugin • 4 Software Developers • Product Management • 1 Product Manager • Management • 1 Senior Development Manager

32. BuildingProducts Theoracleway

33. Lo que resaltan nuestros ingenieros del MDC • Ambiente • No hay Micromanagement • Equipo multidisciplinario, internacional y talentoso • Libertad para pensar y ser creativo • Proyectos Long Term • El trabajo de cada uno afecta empresas y personas a nivel global • Más allá de horarios, lo importante son los objetivos • Retador • Motivación constante • Jefe y Equipo tanto local como internacional • Great Place to Work Mexico • Facilities / Location

39. For More Information http://www.oracle.com/technetwork/database/timesten • Technology white papers • Quick Start Guide and tutorials • Discussion Forum • And more.. Ricardo Gonzalez Senior Product Manager ricardo.a.gonzalez@oracle.com

40. Q&A