170 likes | 178 Views
Embeddable Database Products. Mike Olson Vice President, Embedded Technologies. Oracle’s Embeddable Databases. Oracle’s Embeddable Databases span the full range of customers’ needs. Mobile Devices Telematics Field Force Automation Distributed Asset Management. Gateways / Routers
E N D
Embeddable Database Products Mike Olson Vice President, Embedded Technologies
Oracle’s Embeddable Databases Oracle’s Embeddable Databases span the full range of customers’ needs Mobile Devices Telematics Field Force Automation Distributed Asset Management Gateways / Routers Storage & Systems Mgmt Security / Authentication Mobile Services Software Appliances Telecom OSS/BSS Core Networking Systems Securities Trading Call Centers / CRM Reservations Healthcare Equipment Industrial Systems Manufacturing Systems Telco Softswitches MobileApplications Edge Applications Data CenterApplications
Example Deployed Applications Enterprise ISV OEM
<Insert Picture Here> Oracle TimesTen
Applications Applications Oracle TimesTen In-Memory DatabaseApplication-tier data management for performance-critical systems: When milliseconds matter. A new database for the application tier, optimized for blazing-fast responseand real-time caching of Oracle data
User Apps JDBC – ODBC – SQL92 Oracle TimesTen In-Memory Database • Key Takeaways… • Everything runs in-memory on the same platform - very efficiently • The data is safe! Local disks are used for persistence and recovery • This is a full read/write, transactional RDBMS for shared, multi-user access • Offers for replication for load balancing, fault tolerance and high availability • All APIs are based on well-known industry standards
User Apps JDBC – ODBC – SQL92 Cache Connect to OracleUsing Oracle TimesTen to Cache Oracle Data • Key Takeaways… • Pre-load or load-on-demand the most active data from Oracle • Synchronizes updates in both directions • Transparent SQL pass-through for non-cached data requests • Works with replication to protect application-tier data • Keeps working even if the connection to Oracle is down
<Insert Picture Here> Oracle Berkeley DB
Berkeley DB Product Family Berkeley DB extension providing XQuery-based access to XML documents The original transactional storage engine for applications developed with C, C++, Java, PHP, Perl, etc. Transactional storage engine written in Java and optimized for Java environments
All Berkeley DB Products… • …are libraries • Run in the same address space as the application • Small footprint – on the order of half a megabyte • No client/server abstraction • …require Oracle’s partner to write code • Designed for embedded use in applications an devices • End users generally don’t know there’s a database • …support transactions, concurrency, recovery • …provide record-based put/get APIs for storage and retrieval • No SQL support anywhere
Key Features Berkeley DB Feature Partner Benefit Data stored in application-native format Performance, no translation required Programmatic API, no SQL Performance, flexibility/control In process, not client-server Performance, no IPC required Zero administration Low cost of ownership Locking High concurrency ACID transactions and recovery Reliability, data integrity Source code availability Ease of integration
<Insert Picture Here> Oracle Lite
Database Lite - ‘More Than a Database’ Mission: To extend the enterprise environment with infrastructure and application services that enable the delivery and operation of secure, personalized applications on mobile and embedded devices. Mobile Server Repository Mobile Server Embedded or Mobile Client Data and Applications Sync Layer Oracle Lite Database Security Application Provisioning Data Synchronization Device Management Life Cycle management
Complete Life Cycle Management Device Management Software management Remote diagnostics and command execution System Management Synchronization monitoring and scheduling Inspection and corrective action Application Management (Provisioning and Deployment) User (OID), Application and Data Management Mobile Server
Synchronization: High performance Scalable ‘Automatic’ continuous sync in the background Designed for One-to-Many Synchronization Transport independent Conflict detection and customizable resolution Synchronizes everything Tables, Index, Sequences, DDL, Constraints Robust Checkpoint (Resume after transport failure) Network resilience with Broadbeam for roaming sessions over multiple protocols and networks Mobile Server
Oracle’s Embeddable Databases Oracle’s Embeddable Databases span the full range of customers’ needs Mobile Devices Telematics Field Force Automation Distributed Asset Management Gateways / Routers Storage & Systems Mgmt Security / Authentication Mobile Services Software Appliances Telecom OSS/BSS Core Networking Systems Securities Trading Call Centers / CRM Reservations Healthcare Equipment Industrial Systems Manufacturing Systems Telco Softswitches MobileApplications Edge Applications Data CenterApplications