fbpx

Oracle 12c successfully install for my requirements for high speeding trading with message queuing in memory and more features

(Last Updated On: December 16, 2014)

Oracle 12c successfully install for my requirements for high speeding trading with message queuing in memory and more features

Sepcial NOTE: on installation: The Server install seems to be work ok but the Workstation some wierd permissioning problems for the database when installed.

Successfully and easily installed on my Windows 2012 Server. It is a strange world we live in now that it sort of works. After digging through, Oracle 12c could meet all my requirements.

Why Oracle?

When you read about Liquidnet being used, it got me wanting to try it out.

My REAL reasons why Matlab is important to me thanks to Mr FPGA real time charting and ease of use for FAST quant trading idea generation

 

http://wedostreams.blogspot.ca/2009/01/oracle-aq-buffered-queues-101.html?m=1

Well, boy was I surprised but here is what I found:

Performance:

Oracle local is faster than TimesTen

Click to access CERN_openlab_report_Endre_Andras_Simon.pdf

http://en.m.wikipedia.org/wiki/TimesTen

In Memory TimesTime database functionality

http://www.peakindicators.com/index.php/knowledge-base/1136-performance-benchmarks-timesten-vs-oracle-database

NOTE THIS:

One terabyte may not sound like a lot, but because TimesTen also provides columnar compression, it’s equivalent to about five terabytes of addressable storage. Because it’s in main memory, the entire data store can be scanned within five seconds, according to Oracle. Additional Exalytics boxes can be added to increase total system capacity.

http://www.informationweek.com/software/information-management/oracle-strikes-at-sap-hana-with-timesten-database/d/d-id/1102231?

Click to access TimesTen_DOAG_2011_1_.pdf

BTW, I once wrote a time series database which outperformed both TimesTen and Kdb. It supported a SQL-92 syntax. The key to the performance was binding the schema to C++ template based classes, and using memory mapped files. Allowing for on-the-run schema changes is quite expensive, and defining the schema at compile time, data lookups could be retrieved in just a few assembly instructions.http://stackoverflow.com/questions/1593987/alternative-to-the-timesten-in-memory-database

Oracle Advanced Queuing

http://en.wikipedia.org/wiki/Oracle_Advanced_Queuing

http://wedostreams.blogspot.ca/2009/01/oracle-aq-buffered-queues-101.html?m=1

http://www.oracle.com/us/products/middleware/cloud-app-foundation/tuxedo/message-queue/overview/index.html

https://docs.oracle.com/cd/B10501_01/appdev.920/a96587/qintro.htm

http://docs.oracle.com/cd/E11882_01/server.112/e11013/aq_intro.htm#ADQUE0100

NOTE that this is all experimental but so far, I can report it seems pretty decent. As compared to SQL Server 2014 default, it seems not much of a memory hog as compared to SQL Server.

 

Join y FREE newsletter to learn more about this interesting breakthrough

Just in case when things go bad

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!

Subscribe For Latest Updates

Sign up to best of business news, informed analysis and opinions on what matters to you.
Invalid email address
We promise not to spam you. You can unsubscribe at any time.
Scroll to Top