For a new project I'm working I have the need to store some data into a database. The type of data and access model fits well with the NoSQL model and document databases. We are considering things like MongoDB but are still yet undecided. One of the requirements is to be able to allows Business Intelligence tools to consume some of our ...
I'm a little confused about the level of integration between Lucene.NET and RavenDB. Lucene supports grammatical and phonetical analysis of texts (like word stemming, Metaphone) to allow searches that match the document based on similarity. Now Lucene is used for querying indices, and from what I take from the documentation, also for bu...
HBase is wonderful, but... What will happen to the data when a node (explodes/burns down/gets stolen/Torn into pieces by mad IT on the loose)? Is the data lost? Can the cluster auto recover? Can I add new nodes without downtime? Thanks guys, Maxim. ...
I'm interesting in modeling relations between documents in CouchDB. Let say that i have three documents A,B and C. These documents may refer to each other, but there is an application constraint that cyclic dependency must not occur. Lets take a example (-> is a marker for dependency): A -> B C Two clients (C1, C2) try concurrent mo...
Hi, In our web application we need to trace what users click, what they write into search box, etc. Lots of data will be sent by AJAX. Generally functionality is a bit similar to google analytics, but we need to customize it in different ways. Data will be collected and once per day aggregated and exported to PostgreSQL, so backend sh...
Is there any way to access Redis data from relational databases, such as Oracle or SQL Server? One use case I have in mind is ETL to a data warehouse. ...
Hi everyone i was working with memcache, and when i compiled this code i got following errors. 2010-07-09 10:35:53.499 INFO net.spy.memcached.MemcachedConnection: Added {QA sa=localhost/127.0.0.1:11211, #Rops=0, #Wops=0, #iq=0, topRop=null, topWop=null, toWrite=0, interested=0} to connect queue 2010-07-09 10:35:53.520 INFO net.spy.memc...
Hi folks, I am in the process of building/architecting a business social network web application that has a component that I think will lead to major scalability issues and I'd like to get some feedback/thoughts on the best way forward. The application has a User object. The idea is, that every time a new user joins the system he ranks...
With the NoSQL movement growing based on document-based databases, I've looked at MongoDB lately. I have noticed a striking similarity with how to treat items as "Documents", just like Lucene does (and users of Solr). So, the question: Why would you want to use NoSQL (MongoDB, Cassandra, CouchDB, etc) over Lucene (or Solr) as your "dat...
I've been trying to figure out how to create a CouchDB view that will let me query all the documents that have a start date greater than A and an end date less than B. Is this possible in CouchDB or another noSQL document store? Should I scrap it and go back to SQL? I'm simply trying to do the SQL equivalent of: SELECT * WHERE [start ...
It seems like implementing web-app like twitter/facebook-wall needs 1 huge "feeds" relational table (+ a user table) and an awesome caching mechanism.. ( can you recommend one? ) my main question is, how would you implement such a "feature" using a non-relational DB, e.g. a key/value kind of DB? Obviously, I had like to support the amo...
I've seen two contradictory pieces of advice when it comes to designing row IDs in HBase, (specifically, but I think it applies to Cassandra as well.) Group keys that you'll be aggregating together often to take advantage of data locality. (White, Hadoop: The Definitive Guide and I recall seeing it on the HBase site, but can't find it....
Hi! I have very interested in using MongoDB it seems awesome. But I'm from a totally different school : relational databases. So now I'm wondering how would this case works with MongoDB: Say, I have a table filled with brands and I have another table filled with products. Each products will have a brand. This is very simple to unders...
What is the largest known Neo4j cluster (in db size, graph stats, or # of machines)? ...
I'm investigating the different types of NoSQL database types and I'm trying to wrap my head around the data model of column-family stores, such as Bigtable, HBase and Cassandra. First model Some people describe a column family as a collection of rows, where each row contains columns [1], [2]. An example of this model (column families ...
Memcached + relational db looks like a good solutions if you don't have to scale in magnitude of twitter or facebook... are there reasons when NoSQL would be preferred even if high scalability is not a requirement.. ...
i think i've done enough research to know that i want to go with a NOsql key/value route. i've read up as much as i can and have the following questions still: should i go with something like amazon simpledb, google big table or microsoft azure's solution? (note i'm a .NET site) why not just simply create an in memory hashtable of ke...
I just wonder if there are any JDBC implementations (in some extent, as much as possible) for any NoSql DB (opensource or proprietary)? How do you think, is it possible that this implementation will show as good performance as raw API of correspondent NoSql DB? Which parts cannot be implemented (transactions? CallableStatements? etc)? ...
It's obvious that I'm not an expert on Cassandra. So the question may sound silly. Given an existing SQL-based project does it give any benefit or is it even possible to apply a no-SQL database(e.g. Cassandra) as an additional layer between business logic and SQL database to speed up our queries or inserts. It's relatively new technol...
may i know in 'nosql' there is limitation just like bigtable where we should 'denormalized' our table/entity ? any api wrapper that allow we to write code once and can be used for google app engine bigtable and nosql ? (something like hiberanate) ...