timesten

How do I show a table's foreign key's in TimesTen?

How do I show a table's foreign key's in TimesTen? ...

Alternative to the TimesTen in memory database

I just found "Has anyone published a detailed comparison between different in-memory RDBMSs?" that is related to my question. TimesTen (see also) is a In-Memory Database from oracle. It has a lot going for it including. Fast, consistent response time High transaction throughput Standard SQL, no application rewrite Persi...

TimesTen - correct way to reinstall schema

Hey, I have TimesTen local store which open cache connect to an Oracle data store. Sometimes I need to drop the whole Oracle schema (Entities changes etc..), so I simply drop every table, and recreate it. The problem I'm facing at this stage is by getting inifite XLA messages (in the TimesTen side) for every entity in every table (I get...

Sorting DB tables from least dependent to most dependent

Hi community, I'm performing a data migration and the database I'm using only allows to export and import each table separately. In such a setup importing becomes a problem since the order in which tables are imported is important (you have to import referenced tables before referencing ones). Is there any external tool that allows me ...

SQL query performance optimization (TimesTen)

Hi community, I need some help with TimesTen DB query optimization. I made some measures with Java profiler and found the code section that takes most of the time (this code section executes the SQL query). What is strange that this query becomes expensive only for some specific input data. Here’s the example. We have two tables that ...

Oracle times ten embedded in a java application

Can someone point to me some documentation on how to run the Oracle times ten database in an embedded mode within a java application? I would like to run times-ten as a replacement for HSQLDB. ...