Bret Taylor discussed the SchemaLess Design in this blog post: http://bret.appspot.com/entry/how-friendfeed-uses-mysql It looks like they stored different class's Objects into only one table.Then build more index tables. my question is that how to build index on one class. for example, a user's blog is {id,userid,title,body}. A user's...
Is there an .NET-enabled embedded database (like SQLite.NET) with support for XML? It doesn't matter for me if it is SQL or NoSQL, XPath, document-oriented or not. I just know of BerkeleyDB XML, but this project is still alha and seem to be dead for a year. ...
I need to store many XML documents identified by a unique name, and keep track of their versions. I need to have an access to every document (read, update, delete) through some RESTful API. I need to maintain access control (read/write permissions) for every document (or groups of them). Is there any solution on the market for these nee...
What book would you recommend on distributed computing concepts/database internals such as the ones used for Cassandra, the concepts are listed here: Cassandra glossary? Thanks! ...
I'm trying MongoDB with NoRM in C# and can't figure out why my LINQ queries don't work. Something as simple as this: How can this return all documents with all the fields/properties populated: return Collection.FindAll().Documents.ToList(); but this one only returns the correct number of documents with only the ID field popul...
Hey Everyone, Let me explain my problem, and hopefully someone can offer some good advice. I am currently working on a web-app that stores information and meta-data for a large amount of applications. For each application there could be anywhere from 10 to 100's of comments that are tied to the application and an application version i...
I am a complete noob when it comes to the NoSQL movement. I have heard lots about MongoDB and CouchDB. I know there are differences between the two. Which do you recommend learning as a first step into the NoSQL world? ...
I have been hearing a lot about document oriented data stores like CouchDB. I understand the uses of BigTable like stores such as Cassandra. After reading this question, I was wondering what the conditions would be to merit using a document store? ...
Hi, I am highly interested in new NoSQL solutions to implement a search engine for a dating site. However because of having a lot of possibilities, I am little bid confused. My requirements, 1) 10 million people 2) More than 8 index (gender, online, city, name etc...) 3) Scalability Thanks ...
Here is a document in the store: { "Name": "Hibernating Rhinos", "Employees": [ { "Name": "Ayende" }, { "Name": "John" }, { "Name": "Bob" }, { "Name": "Tom" }, { "Name": "Lane" }, { "Name": "Bill" }, { "Name": "Tad" } ] } It is easy to load this document with or wit...
As Qt is used for small, medium and large sized application/service development, it is very likely that NoSQL trend will not skip Qt developers. Although most NoSQL projects have background of web app development and dynamic languages, some of the current NoSQL libraries have been written in C or C++, so integration would be possible. E...
Is there a database out there that gives you the benefit of referential integrity and being able to use a SQL type language for querying, but also lets entities be loosely defined with respect to their data attributes and also the relationships between them? E.g. take a RBAC type model where you have Permissions, Users, User Groups & Ro...
I have a collection of items in mongodb that look like this (I'm using pymongo): {'type':'_sometype', 'name':'_somename', 'date':datetime, 'incoming':bool} type and name are not unique across items, so it is possible to have items with the same type and name but differing dates. The issue: sometimes I'll need to determine if an it...
I am starting to study map-reduce databases. How can one implement a reference in a map-reduce database, such as CouchDB or MongoDB? For example, suppose that I have drivers and cars, and I want to mark that some driver drives a car. In SQL it's something like: SELECT person_id, car_id FROM driver, car WHERE driver.car = car.car_id (T...
A little background: I currently make use of Memcached Providers for managing session state in my ASP.NET application. It provides facilities for using SQL Server as a fallback storage mechanism (when sessions need to be purged from the memcached cache). I'd like to look at creating a provider for RavenDB as it would be much more perform...
I would like to find a nosql solution as handy as sqlite. That means: one or two files does not need a daemon to manage it usable in a directory/virtualenv ideally python API, but not that important preferably document based over key-value, but i'll take what i can get What, if any are my options. ...
I've read some article say that RDBMS such as MySQL is not good at scalable,but NoSQL such as MongoDB can shard well. I want to know which feature that RDBMS provided make itself can not shard well. ...
I'm developing a database that holds large scientific datasets. Typical usage scenario is that on the order of 5GB of new data will be written to the database every day; 5GB will also be deleted each day. The total database size will be around 50GB. The server I'm running on will not be able to store the entire dataset in memory. I've s...
Does anyone know how to populate mongodb with initial data? For example, with a traditional SQL database, you can put all your SQL statements in a textfile, then load that using a SQL command. This is extremely useful for unit testing. Is it possible to do this with the mongo shell? For example, write down a list of shell statements int...
As with most new technologies after a while a standard emerges. Is there anything cooking for NoSQL? ...