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.
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
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!