Timesten内存数据库新特性.ppt

TimesTen 11gR2 New Features  Pro*C/C++ -- Motivation Benefit What’s Oracle Pro*C/C++? Oracle Pro*C/C++ pre-compiler enables programs to embed SQL PL/SQL statements in the C or C++ source programs Pro*C/C++ support in TimesTen database Uses the same Oracle Pro*C/C++ precomiler Enables applications to embed SQL and PL/SQL statements in the C or C++ source programs Supports embedded SQL 92 syntax Provides same level of SQL functionality as supported in the TimesTen ODBC interface TimesTen 11.2.1 installer provides all required software for Proc/C++ (precomplier runtime library ) PL/SQL Stored Procedure TimesTen Stored Procedures Compatible Oracle PL/SQL syntax and semantics Create and Execute procedures in the TimesTen database Execute PL/SQL code from ODBC, JDBC, ttClasses, OCI, Pro*C, ttIsql programs Support main-stream PL/SQL packages targeted for OLTP real-time database applications Benefits: Improve application response time and reduce client/server round trips Improve application code reuse with modular code abstractions Leverage Oracle TimesTen in-memory database technology for response-time critical applications Retain and reuse existing PL/SQL application development skill sets TimesTen PL/SQLDDL Commit Behavior DDL commit behavior in previous TimesTen releases is different from that in Oracle database Oracle DDL operations are automatically committed before and after the command TimesTen DDL operations are explicitly committed by the application DDLCommitBehavior attribute (new in TimesTen 11gR2) First Connect attribute; created for backward compatibility with previous TimesTen releases = 1 means keep the old TimesTen behavior = 0 means follow the Oracle DDL commit behavior If PL/SQL is enabled, DDL operations are committed automatically Must set DDLCommitBehavior = 0 ttSrcScan Utility A standalone utility to scan program source file to identify potential compatibility issues in OCI, Pro*C/C++, and PL/SQL functional areas Intended to help custo