Stack Overflow
Stack Overflow

Questions tagged [timesten]

TimesTen is a high performance event-processing software component that enables applications to capture, store, use, and distribute information in real-time, while preserving transactional integrity and continuous availability.

TimesTen is designed to operate most efficiently in an application’s address space. Using standard interfaces, TimesTen can be integrated into an application to serve as either a stand-alone relational database management system (RDBMS) or an application-tier cache that works in conjunction with a traditional disk-based RDBMS, such as the Oracle database. TimesTen can be configured to operate entirely in memory, or it can be configured for disk-based environments to log and checkpoint data to disk.

TimesTen is available in a specially-licensed edition, TimesTen for Exalytics, to support Oracle's Exalytics BI Machine. This version of TimesTen makes available various analytic functions, as well as columnar compression. These features are not available in standard TimesTen.

75 questions
11
votes
8 answers

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…
Ian Ringrose
  • 51,220
  • 55
  • 213
  • 317
4
votes
2 answers

how to cache XMLTYPE table in a TimesTen DB?

I have an XMLType table in an oracle database which I want to cache in a timesten cache group. But because the constraint that the table definition in the cache group must be the same as in the oracle DB and the fact that the timesten database does…
Nafaa Boutefer
  • 2,169
  • 19
  • 26
3
votes
2 answers

SQL support cache with fallback to a database

Is there any product which can be queries using JDBC (normal SQL), it sees whether all the tables in the query are in CACHED tables, and use the cache, otherwise fallback to the back-end database. I am aware of two products: Oracle In Memory…
Amir Pashazadeh
  • 7,170
  • 3
  • 39
  • 69
3
votes
4 answers

In-memory database optimized for read (low/no writes) when operations involve sorting, aggregating, and filtering on any column

I am looking to load ~10GB of data into memory and perform SQL on it in the form of: Sort on a single column (any column) Aggregate on a single column (any column) Filter on a single column (any column) What might be a good choice for performance?…
David542
  • 104,438
  • 178
  • 489
  • 842
3
votes
2 answers

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.
JavaRocky
  • 19,203
  • 31
  • 89
  • 110
3
votes
3 answers

SQL query performance optimization (TimesTen)

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 …
Sergey Mikhanov
  • 8,880
  • 9
  • 44
  • 54
2
votes
5 answers

python access to TimesTen

I googled a lot to find any python module to access TimesTen (in memory database). I am writing a automated testing framework (more like for System Test and not Unit Test). Is anyone aware of such module? The last resort is write the wrapper myself…
Sudeep
  • 107
  • 1
  • 11
2
votes
2 answers

How to connect to TimesTen database using golang?

I am trying to connect TimesTen database using golang, but no TimesTen driver for golang is available I can find. Does anybody have such experience using golang to access TimesTen? Since TimesTen supports OCI api. So I am trying to use a go package…
Lei Yang
  • 61
  • 3
2
votes
1 answer

How to reference .so files in spark-submit command

I am using TimesTen Database with Spark 2.3.0 I need to refer to .so files in spark-submit command in order to connect to Timesten db. Is there any option for same in spark-submit? I tried adding so file in --conf spark.executor.extraLibraryPath…
Curious Techie
  • 185
  • 2
  • 15
2
votes
0 answers

Count for all combinations of two other columns on a large scale

SETUP - I have a large but simple query that usually takes a second or two to run SELECT DISTINCT t1.Col_1, t1.Col_2, t1.Col_3, Col_4, ... t2.Col_3, t3.Col_2, ... (14 columns total) FROM Table_1 t1 INNER JOIN Table_2 t2 ON (t1.COL_3 = t2.COL_1)…
Jeutnarg
  • 1,138
  • 1
  • 16
  • 28
2
votes
1 answer

TimesTen - correct way to reinstall schema

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…
Udi
  • 1,080
  • 1
  • 12
  • 25
2
votes
2 answers

Problems with loading native library/missing methods: no ttJdbcCS in java.library.path

Iam facing one problem while connecting the timesten client to the server The SQL Exception which Iam getting is pasted below:- Problems with loading native library/missing methods: no ttJdbcCS in java.library.path I am working with MAC OS X 10.7.2…
Aditya
  • 78
  • 2
  • 8
1
vote
1 answer

ruby access to timesten

I googled a lot to find any one has accessed timesten from ruby. I need to access timesten from Ruby (v1.9.3). Can anyone please help me out? Thanks
zahidal
  • 111
  • 1
  • 8
1
vote
1 answer

TimesTen JDBC URL format without DSN

I would like to ask what should be the format of JDBC URL when I know the server OP, port, user and password. I cannot use ODBC (DSN). I have tried: jdbc:timesten:client://:/, but it is not working.
Jakub Znamenáček
  • 766
  • 1
  • 4
  • 18
1
vote
1 answer

java.sql.SQLException: Problems with loading native library/missing methods: no ttJdbc181 in java.library.path

I am running TimesTen facing application in local (in eclipse IDE). URL and username and password seems to be fine. But I am getting below exception. java.sql.SQLException: Problems with loading native library/missing methods: no ttJdbc181 in…
VENKATRAMAN HIREGANGE
  • 11
  • 2
1
2 3 4 5