Tag Archives: high speeding trading

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!

The stats are here for MongoDB vs Redis NOSQL database performance comparison for high speeding trading from other experienced user!

The stats are in for MongoDB vs Redis NOSQL database performance comparison for high speeding trading from other experienced user!

This awesome news from someone else who test the performance betwen both. He also posted some comments I never considered so big thanks to him for posting! This is excellent as we move forward to make this really cool! Read the comments below in this posting.

https://quantlabs.net/blog/2014/12/the-stats-are-in-for-mongodb-vs-redis-performance-comparison-for-high-speeding-trading-from-other-experienced-user/

From the Dell guy on the NEXT BIG THING internet of things? WTF is fog computing

He said: 2 exabyte per day is generated man thats INSANE

Interesting  future

https://quantlabs.net/blog/2014/12/from-the-dell-guy-on-the-next-big-thing-internet-of-things-wtf-is-fog-computing/

Don’t forget about our upcomingNOSQL vs SQL database smackdown”

LIVE Event: NOSQL vs SQL database smackdown, which one for what?

Online Meetup LIVE Event: NOSQL vs SQL database smackdown, which one for what?

There are so many databases usedbut what for what reason. I really want to investigate this with others online.

http://www.meetup.com/quant-finance/events/218915269/

http://www.meetup.com/R-Matlab-Users/events/218915394/

And now for a word from our sponsor::

If you are interested in any of these topics above, my entire Quant Elite membership revolves around these.

http://quantlabs.net/academy/introduction-quant-elite-membership/

Bryan

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!