Tag Archives: Cassandra

MongoDB NOSQL outperforms Cassandra and Couchbase?

 

MongoDB NOSQL outperforms Cassandra and Couchbase?

Is this true

A new independent study shows that MongoDB outperforms key value stores. The results demonstrate that MongoDB provides greater scalability than NoSQL vendors Cassandra and Couchbase in all tests, by as much as 13x.
Download the report to access detailed performance results.

https://www.mongodb.com/collateral/scalability-benchmarking-mongodb-and-nosql-systems-report

I always heard about MongoDB is the better choice but no one ever compares Redis. Or is that even a fair comparison

Join my FREE newsletter to see which one is better 

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!

Why not Python nor NOSQL Cassandra? Did Friend make your 5% in 1 day from our first trading alert?

Why not Pythonn nor NOSQL Cassandra? You make your 5% in 1 day from our first trading alert? Don’t hold US dollars!

SO we got two streams in this email: Technical vs general trading

These are sorted by popularity!

Why not Python or Pandas like AQR capital management does?  Why not Cassandra NOSQL database like BlueMountain Capital does?

Questions about yesterday from a newsletter subscriber:

Why not Python/Pandas like AQR does? See quote by Roni Israelov here: http://pandas.pydata.org/

Or Cassandra like BlueMountain Capital does?

These firms spend millions trying to solve the same problems as you do. There is probably value in the approaches they recommend.

Find the answers here:
https://quantlabs.net/blog/2014/12/why-not-pythonpandas-like-aqr-capital-management-does-why-not-cassandra-nosql-database-like-bluemountain-capital-does/

Next:

Watch these videos: Aftermath of a crisis and The Day of the Dollar a 2005 bubble before 2008 financial meltdown burst

All I can say it is interesting on this 2005 meltdown financial mess

https://quantlabs.net/blog/2014/12/watch-these-videos-aftermath-of-a-crisis-and-the-day-of-the-dollar-a-2005-bubble-before-2008-bursts/

You should like the Netherland one which means don’t hold US dollars.  Watch to find out why!!

*** Did you make your 5% for the day on our trade alert from Sunday  today??? More reason to follow us suckah

More fun times:

Interesting. The stengthening US dollar could be the next financial trigger meltdown

Many debtors including countries have their debt in US dollars. If they do not have US dollar inome, the stregenthing could wipe them out. Makes sense. We proudly accept US Dollars at this point regardless of what you may have watched recently on Youtube. Don’t forget about that growing student debt too which is as bad as the housing mortgage debt

Don’t say we ain’t looking out for you.

https://quantlabs.net/blog/2014/12/interesting-the-stengthening-us-dollar-could-be-the-next-financial-trigger-meltdown/

We got the bestest community even from the newbies. Check this out:

Slide deck presentation on NOSQL trading database options from a NEW Twitter follower

He just provided me some cool resources so check out his own

Slide deck presentation on NOSQL trading database options from a NEW Twitter follower

He just provided me some cool resources so check out his own

https://quantlabs.net/blog/2014/12/slide-deck-presentation-on-nosql-trading-database-options-from-a-new-twitter-follower/

Bryan
P.S. Don’t forget about our first Analytics online now!!

Future alerts will be posted via my Facebook or Twitter. Join either or both so you no longer need to miss out! <– why do you think I list this at the bottom. This is where the good stuff is always |->

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!

Why not Python/Pandas like AQR capital management does? Why not Cassandra NOSQL database like BlueMountain Capital does?

Why not Python or Pandas like AQR capital management does?  Why not Cassandra NOSQL database like BlueMountain Capital does?

Questions about yesterday from a newsletter subscriber:

Why not Python/Pandas like AQR does? See quote by Roni Israelov here: http://pandas.pydata.org/

Or Cassandra like BlueMountain Capital does?
These firms spend millions trying to solve the same problems as you do. There is probably value in the approaches they recommend.
This was from earlier today on:
Oh me oh my so programming languages for automated trading or quant login details for Dec 8 at 7 PM EST
First. Blue Mountatin also focuses on F#:
http://techblog.bluemountaincapital.com/2012/08/01/announcing-the-f-r-type-provider/
As for Cassandra, this is a toss up betweeen MongoDB and Reddit. The powers to be easily swing towards MongoDB but still prefer a home grown in memory database solution.
As for Pandas Python and Pypy, I want to use it but will be around in 5 years? Will my scripts stil;l be compatible? Pypy does not give me any confidence but this does not mean a quick death to Python. Believe me, its popular and it has my attention. The question is: How do I deploy it with all these other options?

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!

Has anyone ever used Cassandra NOSQL database memory mapped files?

Has anyone ever  used Cassandra NOSQL database memory mapped files?

I am looking for feedback or comments on the use of this NOSQL database. How is the performance vs Redis opr MongoDB

https://wiki.apache.org/cassandra/FAQ

http://www.safaribooksonline.com/library/view/cassandra-high-performance/9781849515122/ch04s11.html

http://planetcassandra.org/blog/cassandra-11-reading-and-writing-from-sstable-perspecitve/

http://blog.comsysto.com/2013/04/12/cassanrda-1-1-tuning-for-frequent-column-updates/

Join my FREE newsletter to see how this work

 

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!

How to use SQL Database for Algo Trading with HFT Potential with SQL Server MYSQL NOSQL MongoDB Redis Cassandra R Java

How to use SQL Database for Algo Trading with HFT Potential with SQL Server MYSQL NOSQL MongoDB Redis Cassandra R Java

This has been posted for my QuantLabs.net Premium Members

Notes and Video Demos of SQL Database for Algo Trading with HFT Potential with SQL Server MYSQL NOSQL MongoDB Redis Cassandra R Java

This happens tonight and will be the LAST EVER I do this LIVE

Get access here

Want to learn more about how to use databases for Automated Algo Trading System, join my FREE newsletter

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!

Which RDMS or NOSQL database do you use for R? MySQL, Cassandra, HBase, MongoDB, Oracle, PostgreSQL, CouchDB, SQLite?

Which RDMS or NOSQL database do you use for R? MySQL, Cassandra,  HBase, MongoDB, Oracle, PostgreSQL, CouchDB, SQLite?

Join my FREE newsletter to say what gets posted about R !

This R survey is kind of important. It will show a few things:

  1. Which R most users use regardless if they are commercial vs open source vs NOSQL .
  2. This will help us figure out which database is best for R using the scalability and speed depending on the requirements. This includes multiple writes for market tick data from C++ or a Java application and access by various R algorithms for analytics purposes.

Go here for the poll.

Here are some reasonable options with reasons:

MYSQL

I would assume this to be the number one choice since it is open source (or at least they say). It also contains sharding and other scalability needs with clustering. Is this something that people are using for their trading platform requirements? This includes using MYSQL as a tick data repository.

PostgreSQL

Is anyone actually using this open source database for their R needs?

Oracle

This is easily the most popular commercial RDMS for both Linux/Unix and Windows. As Oracle has open R into with a connector into their ecosystem, I wondered if people are actually using this.

SQL Server/DB2/Sybase

I am unsure if there are any R package connectors to any of these databases. I was just curious as I am really not interested in these as a real option.

Cassandra

There seems to be no R package support for this. I once posted something on R-Bloggers.com and it lit up the site, it made me wonder if this is actually more popular than people think. It seems to meet the needs of both quick write and read access.

Redis

Now the doRedis R package looked really hot. It even showcased how to use with a potential financial analytics system. I even saw Java sharding examples which left me excited on the capabilities of this database.

MongoDB

This seems to be strangely the most popular of all. I also found various R packages which seems to support it as well.

HBase which is part of Hadoop

Eh. No support even according to Revolutionary Analytics which their lacking install R package guides. I gave up pretty quickly on these R packages.

All others database options seem fine but the ones listed above seem the most viable for any R user as repository for scaling and clustering.

Go here for the poll.

http://quantlabs.net/surveys/2012/06/19/what-rdms-or-nosql-database-should-a-r-user-focus-on/

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!

No to NOSQL like MondoDB or Cassandra for institutional firms like hedge funds or banks for in memory database, hello kdb is fastest processing

No to NOSQL like MondoDB or Cassandra for institutional firms like hedge funds or banks  for in memory database, hello kdb is fastest

 

Join my FREE newsletter to learn more about this

This was sent from Youtube visitor (TimeStored) as a comment for the video:

They commented:

Hi Bryan,

I would say the core strengths of kdb are:
– q language is very powerful
– kdb is based on ordered lists, SQL is based sets, this difference makes a lot of time series queries much easier.
– it’s fast

 

Also:

i Bryan,

The core strengths of kdb are:
– q language is very powerful
– kdb is based on ordered lists, SQL is based sets, this difference makes a lot of time series queries much easier.
– it’s fast.

I can easily recommend a career in it if you want an interesting, challenging programming job.

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 vidYoutube video: cool million dollars to store tick database with kdb no need for nosql like Hadoop, Cassandra, MongoDB, Redis

 

Youtube vidYoutube video: cool million dollars to store tick database with kdb no need for nosql like Hadoop, Cassandra, MongoDB, Redis

Learn to see what my open source database will be through my FREE newsletter

 

 

 

 

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!

Best explanation of Cassandra vs MondoDB: Why I may switch to MongoDB for better R support? Redis is less popular

 

Best explanation of Cassandra vs MondoDB: Why I may switch to MongoDB for  better R support? Redis is less popular

http://stackoverflow.com/questions/3391586/mongodb-on-ec2-server-or-aws-simpledb

Benefits of Cassandra with Sharding:

https://www.cloudkick.com/blog/2010/mar/02/4_months_with_cassandra/

http://comments.gmane.org/gmane.comp.db.cassandra.user/4122

Clients to Mongo including R (better R client support for MondoDB as compared to Cassandra)

http://www.mongodb.org/display/DOCS/Drivers

2 potential R package client repositories for MongoDB

https://github.com/tc/RMongo

https://github.com/gerald-lindsly/rmongodb

MongoDB does still do sharding:

http://www.mongodb.org/display/DOCS/Sharding+Introduction

This is a primary reasons why I would switch from Redis. An example of usage of R with MongoDB using high frequency market data:

http://www.r-bloggers.com/i-see-high-frequency-data/

https://github.com/kafka399/Rproject/blob/master/HFD/showHFD.R

There are many other examples found on R-Bloggers.com

 

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!

No to MYSQL: How to use Cassandra with R and RCasandra versus Hadoop and HBase

No to MYSQL: How to use Cassandra with R and RCasandra versus Hadoop and HBase

MYSQL looked good but can get pricey. Cassandra is true free open source and Twitter uses it!

http://blog.milford.io/2010/06/installing-apache-cassandra-on-centos/

HBase vs Cassandra: why we moved

Learn more on how I proceed with this with R as part of my high frequency trading:

http://quantlabs.net/membership.htm

Lucky me, I get a strange issue with RCassandra, Hmmm…probably a stupid thing but please comment if anyone has any ideas. Thanks

This could be a potential workaround but let me try for another day:

Big Analytics with R, Cassandra, and Hive

 

 

 

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!