Tag Archives: TimesTen

No to Oracle TimesTen? It seems Redis is the next logical choice in a C++ HFT as compared to SQLite or BerkeleyDB

No to Oracle TimesTen? It seems Redis is the next logical choice in a C++ HFT as compared to SQLite or BerkeleyDB

It is always that debate of which is the best real time trading engine for C++ platform with R analytics through RCpp/Rinside.

First I mentioned Oracle TimesTen which look solid over the last weekend. It seems someone who is highly experienced has convinced me the product is entirely slow. Who knew? I am not in a position to argue so I will take their word for it. Without doubt, that lead me to three choices:

1. Berkeley DB

2. Redis

3. SQLLite

After reading the usual BerkeleyDB vs SQLite debate, it seems BDB wins without doubt as any trading platform needs concurrency which BDB offers over SQLite.

http://doc.gnu-darwin.org/intro/dbisnot.html

http://www.oracle.com/technetwork/database/berkeleydb/learnmore/bdbvssqlite-wp-186779.pdf

http://stackoverflow.com/questions/2824135/how-fast-is-berkeley-db-sql-compared-to-sqlite

As indicated above, BDB is not a network database or database server.

So I guess that brings me back to Redis. I can only use the hiredis C client which is recommended by their site. The C++ client is very outdated.

Some further decent comparisons with other NOSQL as well:

http://perfectmarket.com/blog/not_only_nosql_review_solution_evaluation_guide_chart

I would have gone with MongoDB but when you read this for C++,

http://www.mongodb.org/pages/viewpage.action?pageId=133415

My experience is the same with MongoDB:

I am dumping NOSQL including MongoDB clustering, trying MYSQL Cluster

http://news.ycombinator.com/item?id=2052852

http://stackoverflow.com/questions/2376846/which-key-value-store-is-the-most-promising-stable

http://vschart.com/compare/berkeley-db/vs/redis-database

Learn more what I do with these by being a Premium Member. Join here for instant access!

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Is Oracle TimesTen the key to building an ultra high frequency trading platform HFT with real time R model analytics?

Hi there

Today is another one of those game changing days for trading development:

1. Is this Oracle TimesTen the best in memory database for real time analysis of R scripts in a HFT environment?

https://quantlabs.net/blog/2012/10/financial-industry-use-cases-for-oracle-timesten-in-memory-database-for-rapid-automated-trading-systems-with-low-latency/

2. Fast way to develop a trading application with TimesTen with this Free virtual machine appliance:

quantlabs.net/blog/2012/10/oracle-makes-it-real-easy-to-get-into-developing-with-timesten-in-memory-database-with-this-free-virtual-box-appliance/

Youtube video demo:

https://quantlabs.net/blog/2012/10/it-is-easier-to-debug-an-abandoned-open-c-linux-high-frequency-trading-platform-or-roll-your-own/

3. With all the above, here are my pieces ready to go to roll my own ultra low latency high frequency trading platform?

https://quantlabs.net/blog/2012/10/it-is-easier-to-debug-an-abandoned-open-c-linux-high-frequency-trading-platform-or-roll-your-own/
So what does this mean?  I can now get everything running faster than debugging another open source HFT platform with Interactive Brokers. After my complete R code walkthrough videos, you will be learning right now with how I integrate all this is into an ultra low frequency trading platform. There is no different than how Bank of America or major stock exchanges are doing it! Join the membership here to get instant access here:

–> GET YOUR ACESSS NOW <–

As a result, this could my first claim in potentially building an ultra high frequency trading platform with ultra low latency. Learn more on how I do it!!
I really hope you are able to join me on this exciting development,

Bryan

P.S. Don’t be afraid to rach out if got any questions on this.

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Youtube video demo of Oracle TimesTen in memory database with FREE Developer Day tools with a Virtual Box VM appliance

Youtube video demo of Oracle TimesTen in memory database with Free Developer Day tools with a Virtual Box VM appliance

Interested in this technology? Join the Premium Membership to learn what I do with this. Get instant access now!

 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Oracle makes it real easy to get into developing with TimesTen in memory database with this free Virtual Box appliance!

Oracle makes it real easy to get into developing with TimesTen in memory database with this free Virtual Box appliance!

Yikes. I don’t need to go crazy downloading and installing stuff individually. It is all in one source here:

http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html

This is realy smart as it includes everything I need and already preconfigured:

  • Oracle Linux 5
  • Oracle Database 11g Release 2 Enterprise Edition
  • Oracle TimesTen In-Memory Database Cache
  • Oracle XML DB
  • Oracle SQL Developer
  • Oracle SQL Developer Data Modeler
  • Oracle Application Express
  • Oracle JDeveloper
  • Hands-On-Labs (accessed via the Toolbar Menu in Firefox)

 

Let’s see what happens when I play with it.

 

 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Financial industry use cases for Oracle TimesTen in memory database for rapid automated trading systems with low latency

Financial industry use cases for Oracle TimesTen in memory database for rapid automated trading systems with low latency

 

In summary:

perform real-time analyses need

With Oracle TimesTen, a transaction that reads a database record can be completed in 2.5 microseconds

(measured on Intel Xeon 2.93 GHz processor running Oracle Solaris),

Extreme low latency and predictable microsecond response times enable Oracle TimesTen to provide

real-time access to data for highly time-sensitive operations such as processing transactions, messages and

data streams, whether for trading systems, risk management, fraud detection or other applications

http://www.oracle.com/technetwork/products/timesten/overview/wp-timesten-financial-334271.pdf

 

Notes: It is used by financial applications such as securities trading, stock exchanges, fraud detection, compliance, online banking, and bond pricing.

When used as a cache to the Oracle Database, it synchronizes data automatically with the Oracle Database. Distributed caches present a single image to applications with location transparency and distributed concurrency control.

Definite low latency metric claims:

requests in microseconds — 1.78 microseconds (0.00178 ms) for a SQL SELECT statement and 7 microseconds (0.007 ms) for a SQL UPDATE statement.

… the Oracle TimesTen In-Memory Database (TimesTen) is used by many customers today as a standalone database at the application tier. TimesTen provides full transactional support for SQL operations and the transaction logs are persisted to disk for recovery (the database is always in memory).

http://www.oracle.com/technetwork/products/timesten/faq-091526.html#GENERAL6

Use by some major stock exchanges including Philadelphia.

 

Also: http://www.oracle.com/technetwork/products/timesten/overview/china-finance-online-db-snapshot-1367347.pdf

the Oracle TimesTen In-Memory Database (TimesTen) is used by many customers today as a standalone database at the application tier. TimesTen provides full transactional support for SQL operations and the transaction logs are persisted to disk for recovery (the database is always in memory).

Holy moly in terms of speed:

 

 NYFIX Cuts Transaction Response Times to Less Than Three Milliseconds with In-Memory Database Solution

http://www.oracle.com/technetwork/products/timesten/overview/nyfix-customer-snapshot-1367382.pdf

 

DeutscheBorse Stock exchange:

http://www.oracle.com/technetwork/products/timesten/overview/deutsche-borse-db-snapshot-130682.pdf

 

 

Reduced the order processing time in Xentric Order by approximately 70% for 95% of all orders

 

 

 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Is Oracle TimesTen in memory database the ultimate for your c++ high frequency trading aka HFT platform?

Is Oracle TimesTen in memory database the ultimate for your c++ high frequency trading aka HFT platform?

So I found this a few days ago. I have been going on about how great Redis is but it got me thinking that this option is a definite top contender as a choice for your trading platform. If you using a decently supported client programming language like C# or Java, this might be a really good option. The parallelization with R on the backend of Redis is stunningly powerful but still primitive. Although I am committed to C++, I am find the client support for Redis is not as wider as Java.

I started investigating TimesTen and was left with a really good impression of it especially for the support of C++ as well as just general documentation, wikis, etc. Also, can you really say No from Oracle. I am trying to find if it is free or not. It seems it is as a standalone with the ability to persist into log files. You can also use clustering capabilities with another Oracle product. I will report back as I get to these answers but it is looking really good so far! It also supports multi operating systems as well which is kind of nice.

I would definitely go with option versus the other Oracle Berkeley DB as well. There appears to be some arguments against MYSQL Server which just adds to the confusion.

As for TimesTen, you can use PL/SQL on topi of it which is obviously a popular SQL so the practice of using it helps for those wanting to go down the path of Oracle solutions as a career choice.

http://www.oracle.com/technetwork/products/timesten/overview/index.html

 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!