nosql

Requesting advice on persisting objects from a dynamic language to a document database

Hi, Do you have any insights into the most elegant way of persisting objects from a dynamic language in a document database? I have a solid background in C# and have just started programming in Python. At the same time I am trying to learn the ropes of MongoDB. Now I am wondering: what is the most elegant way to persist my data to t...

Simplest database implementation

I am looking for a really simple database implementation; basically one with no complex parsing SQL engine. What I am looking for is something demonstrating B+ trees and ACID storage (Suitable for educational purposes). What I have found up-till now form my current searches was hamster-db. I am looking for something even simpler with a s...

Is it possible to construct complex queries against noSQL DB

I have been researching noSQL DB and have not been able to satisfactorily answer this for myself: Is it possible to construct complex queries against noSQL DB? The type of query I'm wondering about would be something like this: select * from DB where vara > x AND varb = 2 AND varc < x AND vard in (x,y,z) AND vare like '%texthere%' AND...

Why are key value pair noSQL db's faster than traditional relational DBs

It has been recommended to me that I investigate Key/Value pair data systems to replace a relational database I have been using. What I am not quite understanding is how this improves efficiency of queries. From what I understand you are going to be throwing away a lot information that would help to make queries more efficient, by simpl...

SimpleDB as the main database, examples.

Please, can you give examples of real-life implementations using SimpleDB as the main persistent storage? ...

Non-relational databases (NoSQL) for small to medium sized applications

The benefits of a non-relational database (such as a key-value pair storage) are evident when used in large scale datasets (google, facebook, linkedin). How do you think small to medium sized applications can benefit from using non-relational databases? ...

Are there any good reference (open-source) Rails NoSQL apps?

I'm interested in seeing how using NoSQL would affect the architecture/design/code of a Rails application. Does anyone know of a good example of a open-source Rails app using NoSQL persistence? Thanks ...

Cassandra port usage - how are the ports used?

When experimenting with Cassandra I've observed that Cassandra listens to the following ports: TCP *:8080 TCP *:8888 TCP *:57311 TCP *:57312 TCP 127.0.0.1:7000 TCP 127.0.0.1:9160 UDP 127.0.0.1:700 How does Cassandra use each of the ports listed? ...

Cassandra file structure - how are the files used?

When experimenting with Cassandra I've observed that Cassandra writes to the following files: /.../cassandra/commitlog/CommitLog-<id>.log /.../cassandra/data/Keyspace1/Standard1-1-Data.db /.../cassandra/data/Keyspace1/Standard1-1-Filter.db /.../cassandra/data/Keyspace1/Standard1-1-Index.db /.../cassandra/data/system/LocationInfo-1-Data....

Filter posts by multiple tags to return posts that have all those tags, with good performance

StackOverflow lets you search for posts by tags, and lets you filter by an intersection of tags, e.g. ruby x mysql x tags. But typically it's inefficient to retrieve such lists from MySQL using mulitple joins on the taggings. What's a more performant way to implement filter-by-multiple tag queries? Is there a good NoSQL approach to thi...

Cross-platform embedded database/key-value store for C#

I'm looking for a fast, embeddable key/value store with cursor semantics over key collections (or a simple embeddable DB) that I can use in .NET and mono. Need it to be open-source, would prefer an MIT or Apache style license over a GPL license. Not opposed to a library that needs bindings to be written, as long as binaries are available...

There is any NoSql database simple as SQLite?

There is any NoSql database as simple as SQLite? I'm looking for a lightweight database to persist a small set of data for a simple desktop application. I still can use SQLite but prefer a more OO approach since my app doesn't handle much data. ...

Write-only collections in MongoDB

I'm currently using MongoDB to record application logs, and while I'm quite happy with both the performance and with being able to dump arbitrary structured data into log records, I'm troubled by the mutability of log records once stored. In a traditional database, I would structure the grants for my log tables such that the application...

How to store tree structures in Java?

Hierarchical data structures are often stored in relational databases. This kind of storage is flexible but flat, so the tree structure has to be build with each query. I want to store forum posts as a tree structure, but it should be possible to query efficiently, say for example selecting posts by date or author. I'd like to have an o...

Communication between two Cassandra nodes

Assume two Cassandra nodes running on hosts A and B respectively. Which TCP and/or UDP ports needs to be open between hosts A and B for Cassandra to operate properly? ...

Recommend a good db4o viewer

I'm playing around with db4o, and I have the Object Manager viewer thingy for Visual Studio. It seems okay, but not exactly on par with tools like HeidiSQL/SQL Studio/etc., not to mention that it locks the db4o file--I can't use my db4o app and Object Manager at the same time. Maybe I'm using it wrong, but regardless, I'd like to know ...

Translating a MySQL data/query-set into the equivalent Cassandra representation

Consider a 500 million row MySQL table with the following table structure ... CREATE TABLE foo_objects ( id int NOT NULL AUTO_INCREMENT, foo_string varchar(32), metadata_string varchar(128), lookup_id int, PRIMARY KEY (id), UNIQUE KEY (foo_string), KEY (lookup_id), ); ... which is being queried using only the following t...

Getting an error "bad recv() len: 53888928" from mongodb when trying to bulk insert around 300,000 items

I tried to bulk insert more than 250,000 items I got an error from the server saying: "Wed Mar 10 21:37:34 bad recv() len: 53888928 Wed Mar 10 21:37:34 end connection 127.0.0.1:2795" I did not find any data on that issue on google that is useful to me. These are the results for my machine using single threaded approach with one open co...

Is Cassandra database row size limited by available memory?

I'm working with very long time series -- hundreds of millions of data points in one series -- and am considering Cassandra as a data store. In this question, one of the Cassandra committers (the über helpful jbellis) says that Cassandra rows can be very large, and that column slicing operations are faster than row slices, hence my quest...

How to run MongoDB as windows service?

How to setup MongoDB so it can run as windows service? Thanks ...