I am trying to figure out how you design data storage in a document storage system like CouchDB or MongoDB. I don't use JOIN's anymore in my queries and just stick to searches for rows with certain indexes that meet my criterion. For example, I might look for recent comments (ORDER BY date) or all active users (WHERE status = 1). In ot...
I'm in the process of converting a system from sql server to mongodb. I believe the project is a good candidate for mongodb, but that's not my question. In the sql database, i have a stored procedure that I use to return a set of records that need processing. So, I have Processed BIT and LastProcessingRequestDate DATETIME fields in th...
I've tried working with OrientDB but it seems inserting to the database is not supported by the REST interface. Looking at Cassandra and MongoDB, they seem to be alright but I haven't seen any references to VB in their site. ...
I'm curious if anyone has implemented or even knows of any bitemporal databases built on NoSQL platforms (e.g., riak). ...
I've got a problem with performance of my reporting database (tables have millions of records, 50+), when I want to calculate distinct on column that indicates a visitor uniqueness, let's say some hashkey. For example: I have these columns: hashkey, name, surname, visit_datetime, site, gender, etc... I need to get distinct in time spa...
Does Microsoft have any NoSQL strategy at all? Any ongoing MS Research projects? ...
In our web project we decided to use NoSQL, but are unsure of which NoSQL solution to use, and which languages have full support for NoSQL. Our priorities are: availability of tutorials and support, and ease of implementation and maintenance. And we want to save the data which is from client side into both relational database (in MySql...
Hi, I’am starting a personal web project. Which I hope it grows fast. It will do a lot of text inserts and searches in this project. So it seems MongoDB a good option. But of course there is not a hosting of asp.net and mongoDB. Also I do not want to expend a lot of money, at the beginning. So I have the idea of contract https://mo...
When to choose NoSQL and when to choose XML ? Update: I want to know when one can use NoSQL exclusively, XML exclusively or both. I want real examples not generalities. ...
a) I have 1000000 domain names b) Every domain has about 100000 sites c) each site has about 10000 visits daily / (5000 unique visits daily) d) As the owner of all those websites, I want to see, how many visitors on selected sites I had in a selected periods of time, for example: How many unique visitor were from 4th December 1987...
Is there a NoSQL (or other type of) database suitable for storing a large number (i.e. >1 billion) of "medium-sized" blobs (i.e. 20 KB to 2 MB). All I need is a mapping from A (an identifier) to B (a blob), the ability to retrieve "B" given A, a consistent external API for access, and the ability to "just add another computer" to scale t...
Hello, I need to build an indexed database of whole domains in the world. . Example: domain1.com ips: 1.1.1.1,2.2.2.2,3.3.3.3 domain2.com ips: 1.1.1.1,4.4.4.4 requirements: fast insertions fast "selects" index on ip's - need fast "select" for all domains on IP: 1.1.1.1 . . I built it in Berkley-DB , and it seems fine: ( ple...
Hi, I have some documents which have 2 sets of attributes: tag and lieu. Here is an example of what they look like: { title: "doc1", tag: ["mountain", "sunny", "forest"], lieu: ["france", "luxembourg"] }, { title: "doc2", tag: ["sunny", "lake"], lieu: ["france", "germany"] }, { title: "doc3", tag: ["sunny"], lieu: ["b...
I'm using Map Reduce with MongoDB. Simplified scenario: There are users, items and things. Items include any number of things. Each user can rate things. Map reduce is used to calculate the aggregate rating for each user on each item. It's a complex formula using the ratings for each thing in the item and the time of day - it's not ...
Back-Story On a current project, I am using MySQL and SQLite in combination with each other. I'm currently giving each user their own SQLite database to get around my provider's 1GB MySQL DB limit. It's worked out alright and the performance is good, but I know for a fact that continual maintenance of these flat-file databases will be a...
I don't really care if it's NoSQL or SQL based - as long as it uses int indexes (and stores them in RAM for fast searching) so I can find my data with simple queries based on criteria like user_id, lat, status, or other common int fields. The actual records can be stored on disk. My first guess would be SQLite - but it moves slowly when...
We have an app that creates text log files of requests to it. Pretty typical stuff in the log file and it is space delimited (date, time, url, http code, ip, user agent, etc). Currently, we are generating around 500k entries in the text log files per day. We're currently doing a lot of analysis via sed/awk/grep of the text files. Ho...
Instead, it displays this: ^[[A^[[A ...
con = pymongo.Connection('localhost',27017) db = con.MouseDB post = { ...some stuff } datasets = db.datasets datasets.insert(post) So far, there are only 3 records, and it's supposed to have about 100... ...
db.mycollection.find(HAS IMAGE URL) ...