Overview of SQL

A database consists of elements. Each element stores a portion of your data. You manipulate and query the data in the database through SQL operations from any element. For example, you can use the CREATE USER statement to create a user in your database from any element. After TimesTen Scaleout creates the user, this user is available in all elements of the database. You can issue DDL and DML statements from any element which TimesTen Scaleout then applies to all elements in your database. You can issue a SELECT statement to run a query that is prepared from one element and ran on other elements in the query with the result returned to the originating element.

Note:

• The syntax and semantics for SQL statements, functions, and the like are detailed in Oracle TimesTen In-Memory Database SQL Reference.

• See Summary of SQL Statements Supported in TimesTen in Oracle TimesTen In-Memory Database SQL Reference for information on the SQL statements supported in TimesTen Scaleout.