nosql

NoSQL/Document Store Searching

Hi All, I have researching NoSQL for a while, but I am still struggling to wrap my head around searching and filtering results/documents. In a NoSQL world, how would I find all data within two timestamps for example? If everything is stored on a key/value basis? Or find all documents within a radius of a latitude and longitude point? ...

Spring and Mixing SQL and NoSQL db

The answers to my previous post encouraged me mixing SQL and NoSQL db. What is the best practice implementation of two databases in terms of application context configuration and DAO creation? Let's choose Derby as the SQL db and Cassandra as the other one. What I am searching for is e.g. an example appcontext.xml, two DAOs, one imple...

How do you stop a MongoDB search from being applied recursively to the key-value tree?

Imagine I have this object (written with Ruby literals) stored in a MongoDB: {"tags" => ["foo", "bar"], "jobs" => [{"title" => "Chief Donkey Wrangler", "tags" => ["donkeys"]}] } Now, I want to search for objects based on the tags on the first level of data, not the second. I can write a query like this (using the Ruby MongoDB librar...

How to: SQL or NOSQL?

I haven't been confronted with this yet, but this is what i think (very superficial and simplistic imho) If you have a key value kind of storage and all you accesses are key lookups use the NOSQL solutions. If you want lookups based on values (and subvalues) or have something more complicated like joins you would go for a relational sol...

Asp.net MVC + NoSQL Database(Cassandra)

Is there any good/simple asp.net mvc application that uses NoSQL database(cassandra)... Any suggestion... ...

Tree structures in a nosql database

I'm developing an application for Google App Engine which uses BigTable for its datastore. It's an application about writing a story collaboratively. It's a very simple hobby project that I'm working on just for fun. It's open source and you can see it here: http://story.multifarce.com/ The idea is that anyone can write a paragraph, wh...

With the recent prevelance of NoSQL databases why would I use a SQL database?

After developing software for about 5 years now, I have spent probably atleast 20% and perhaps up to 40% of that time simply making a RDBMS able to save and retrieve complex object graphs. Many times this resulted in less than optimal coding solutions in order to make something easier to do from the database side. This eventually ended a...

NoSQL and REST web-services

I understand that if you use SUN's Jersey REST implementation framework, you get the ability to use XML and JSON doc's interchangably. I've tried this in a simple REST service and it works just fine, marshalling XML or JSON to Java objects and back again without any problems. My Question is this..... Whats the simplest 'NoSQL' way to p...

Cassandra - Impact of configuring ColumnFamilies

I'm in the process of researching into various NoSQL technologies and currently looking into Cassandra (so I'm at a beginner level with regard to this!). My understanding is you have to define ColumnFamilies in a config file - if you want to change a column family or add a new one, you have to restart Cassandra. What I'd like to know is...

CouchDB sorting and filtering in the same view

Hi, I'm trying to use CouchDB for a new app, and I need to create a view that sorts by multiple fields and also filters by multiple fields. Here is an example document, I've left out the _id and _rev to save myself some typing. { "title": "My Document", "date": 1279816057, "ranking": 5, "category": "fun", "tags": [ ...

Cassandra/BigTable data model - what's the best approach for building indexes?

I'm in the process of spiking a conversion from MySQL to Cassandra for PenWag.com. In Cassandra, I'm storing Users keyed off of a GUID, but users sign in with their email, not the GUID (obviously). GUID as a key for Users makes sense to me more than email for two reasons. From a practical perspective it seems that it's too cumbersome ...

How to start developing rails/django application using NoSql Database like cassandra?

Hello i want to use NoSql database in my rails/django application for learning point of view. What the various things i should kept in mind. Any tutorials? things to be kept in mind? Any Tips like do and don't? EDIT I am fully flexible. I want to learn. I know php,rails,django.I want to create some application using Nosql database a...

Various queries - MongoDB

Hi folks, This is my table: unicorns = {'name':'George', 'actions':[{'action':'jump', 'time':123123}, {'action':'run', 'time':345345}, ...]} How can I perform the following queries? Grab the time of all actions of all unicorns where action=='jump' ? Grab all actions of...

Spring Configuration Settings For Neo4j

Hi I would like to integrate the "neo4j_config.props" file from http://wiki.neo4j.org/content/Configuration_Settings#Optimizing_for_traversals_example into the : a neo4j spring app, the graphDbService which is configured the in app-config.xml: <bean id="graphDbService" class="org.neo4j.kernel.EmbeddedGraphDatabase" init-method="en...

Other platform to socialize information like FLUIDDB?

In its official website, http://fluidinfo.com/, it is described as the following: "FluidDB is a platform for the web of things, each represented by an openly writable "social" object". In http://eu.techcrunch.com/2009/08/31/fluidinfo-a-database-aiming-to-socialize-information/, it is described as "Fluidinfo – a database aiming to social...

Is there a safe subset of JSON that can be used with all JSON parsers & databases

JSON is still becoming more and more important for exchange of data but the JSON specification is rather lax in some aspects: The names within an object SHOULD be unique. An implementation may set limits on the size of texts that it accepts. An implementation may set limits on the maximum depth of nesting. An implementatio...

MongoDB NoRM: query nested objects using Expando

I saw this Q&A http://stackoverflow.com/questions/2900763/mongodb-norm-query-nested-objects, but it seems to apply to strongly-typed objects only. Is there a way to do a find or update a nested field on an Expando object (http://wiki.github.com/atheken/NoRM/expando)? Basically, I have a simple JSON CMS tool that lets developers store do...

Why are document stores like Lucene / Solr not included in NoSQL conversations?

All of us have come across the recent hype of no-SQL solutions lately. MongoDB, CouchDB, BigTable, Cassandra, and others have been listed as no-SQL options. Here's an example: http://architects.dzone.com/articles/what-nosql-store-should-i-use However, three years ago a co-worker and I were using Lucene.NET as what seem to fit the descr...

Explanation of BASE terminology

The BASE acronym is used to describe the properties of certain databases, usually NoSQL databases. It's often referred to as the opposite of ACID. There are only few articles that touch upon the details of BASE, whereas ACID has plenty of articles that elaborate on each of the atomicity, consistency, isolation and durability properties....

What NoSQL solution is best to store Apache error_log and access_log? Cassandra or MongoDB?

We have developed PaaS solution for PHP. As part of that we offer developers to see Apache error_log and access_log files through our API. Currently we write the logs into files on disk seperated per deployment (vhost). Since this doesn't scale too well with a higher number of nodes and deployments, even though files are on distributed...