Tag Archives: 12c

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

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

http://zenodo.org/record/7566/files/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?

http://www.trivadis.com/uploads/tx_cabagdownloadarea/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

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!