Tag Info

New answers tagged

0

Would I loose that data, or not ? Good question! As outlined in the DataStax documentation section on The Write Path To Compaction, you would not lose data. As you can see, when Cassandra processes a write operation, data is written to both the commit log (on-disk) and to the memtable (which you referred to). In case of a "plug out of the wall" ...


0

I would make a change in your tables. You have a Games pointer in your Bets table, but you should have a Bets pointer in your Games table. Here's my reasoning. You have a table for Competitions. From which then the admin creates Games. For each Game, you should store a list of bets the users have placed. Not a list of games for the bets (which is what you ...


1

In Cassandra, as far as I know, for SELECT filtered by non-key attributes, you only have three options: (1) Application side filtering. That is, if you get your results from a CQL SELECT, use your application to filter the results. For all but the smallest data sets, this is ill-advised. (2) Bite the bullet, and create those secondary indices. (3) ...


1

Try this link https://cloud.google.com/appengine/docs/php/storage . This should get you started on the use and main concepts. FYI joins are not applicable to the datastore but if you model out your data correctly you should have no problem.


0

I'm puzzled as to why you think SciDB would be too complex? (Full disclosure ... I work for Paradigm4, so what's familiar to me might not be so obvious to others). Your basic data structure (your array) would look something like this: CREATE ARRAY MyData < data : double > [ I=0:999999999,60000,0, J=0:999999,60000,0 ]; That's 10^9 rows by ...


0

Interesting use case... What makes your problem complex for a DB is your access pattern. Looks like you want to access both by row as well as column. General purpose DBs are generally either row-oriented storage (mostly) or column-oriented storage which will be their most efficient mode of access. They will support the access other way round also (for e.g ...



Top 50 recent answers are included