I have a site written in PHP. It currently uses MySQL for all of its database needs (I'm open to additional DB technologies). The system's content is interrelated. These relationships can be represented as a graph where vertices are pieces of content and edges are the relationships. I need to be able to traverse that graph. In particu...
I currently have a data solution in RDBMS. The load on the server will grow by 10x, and I do not believe it will scale. I believe what I need is a data store that can provide fault tolerant, scalable and that can retrieve data extremely fast. The Stats Records: 200 million Total Data Size (not including indexes): 381 GB ...
I'm trying to implement blog post storage using mongo db. I've got two domain entities: "Blog post" and "Author" Currently I've added AuthorId property to blog post entity. Is that the right approach to store relation between objects? ...
I'm looking for a common data access framework that will provide portability across various nosql databases like SimpleDB, Azure Tables, Cassandra, CouchDB, MongoDb, etc. I'm building an app and would like my customers to be able to use which ever nosql store they want. In a more relational scenario, I'd use Linq over nHibernate or E...
I am developing a service that needs to perform bulk insert of tens of thousands of rows/items/objects at a time, about 20 times per second. (The NoSQL storage can be sharded, so inserts can work in parallel. The sharding strategy, and sharding in general, do not matter for this discussion.) The question is: which NoSQL products in yo...
Hi, I'm a MongoDB newbie and wanted to ask how to write an update command involving upsert and list. Basically I want to accomplish something like this: {"_id" : ObjectId("4c28f62cbf8544c60506f11d"), "some_other_data":"goes here", "trips": [ {"name": "2010-05-10", "loc": [{"lat":21.321231, "lng": 16.8783234, "updated_at": ...
i need to do something like this on apache cassandra, SELECT * FROM mytable where address = "%indonesia%" any idea how to do it on cassandra? ...
First, I apologize if this is not an appropriate venue to ask this question, but I wasn't really sure where else to get input from. I have created an early version of a .NET object persistence library. Its features are: A very simple interface for persistence of POCOs. The main thing: support for just about every conceivable storage m...
Two days ago i started learning Cassandra in my internship, they gave me a learning about Cassandra and i found some codes from the net.There is no errors on the code syntatically but when i run the code i get errors like : InvalidRequestException(why:Keyspace Blog does not exist in this schema.) at org.apache.cassandra.thrift...
hi all I am trying to work out the best way to store my daat using mongodb and mongomapper. I have category and each category can be described by many attributes so length in mm, weight in kg etc. I want each user to be able to create their own attributes to descibe a category of products. So forexample: user A wants to store his c...
I am trying to implement a transaction system for Cassandra with the help of ZooKeeper. Since I don't think I have enough experience in database implementation, I would like to know if my idea would work in principle, or is there any major flaw. Here is the high level description of the steps: identify all the rows(keys) and columns t...
NoSQL are an alternative to RDBMS, that work well with simple data models holding vast volumes of data. MongoDB, Google's BigTable, Dojo's Persevere, Amazon's Dynamo, Facebook's Cassandra are some examples. Could you state your favorite application/IDE that can manage (i.e. insert or query data) such databases? ...
What is going one when parts of the cluster don't see each other? For example: when 3/7 of cluster can't communicate with 4/7 cluster for coupe of hours. Each part of cluster use "hinted handof" for other one part? The data is rebalanced and replicated in each part of cluster? If I balance clients to each part of cluster for writes, aft...
I'm trying migrating an existing web application to use RavenDB. I currently have pages in my web application which allow you to view Categories, SubCategories and Resources based on an id in the querystring. However I notice that RavenDB generates ids for aggregate roots, but not for child entities. I don't think subcategory is an ...
Hi, I consider to use some NoSQL database in one of my project. Do you know some good starting points for a newbie in this topic? ...
I'm working on a small web application using the Python Flask framework. For a few happy weeks SQLAlchemy was a perfect fit for my needs. In the meantime I found out more about MongoDB, played with it locally and started thinking of using it instead of MySql along with SQLAlchemy. Is this a good idea in terms of: Suitability. The pro...
dear how i can get data from Cassandra using value posts = { '1': { //this post id 'user_id': '4', 'body': 'This is awesome!', }, } i cen get the post using post id can i get posts related to certain user i mean get post related to user_id=4 like an example (query using user_id attribute) regrads ...
Hi. I need some help deciding which database we should choose for our project. We are developing a web application that collects data about user's behavior and analyses that (bad explanation, but I can't provide much more detail; web analytics data is one of our core datasets). We have estimated that we will insert approx 200 million ro...
I've been looking at MongoDB and I'm fascinated. It appears (although I have to be suspicious) that in exchange for organizing my database in a slightly different way, I get as much performance as I have CPUs and RAM for free? It seems elegant, and flexible, but I'm not trading that for fast like I am with Rails. So what's the catch? Wha...
Hi everyone, After searching about Cassandra a little bit, i wanted to learn about Membase NoSql. I downloaded it but i couldn't find a way to configure it. Is there anyone who can help me ?? ...