A catch-all term describing database systems using various non-relational models. Such systems are usually engineered to be high-performance.

learn more… | top users | synonyms

0
votes
1answer
53 views

Terminology No-SQL Database [closed]

I'm looking for a good explanation of terminology for No-SQL. I have some colleagues that won't get the point, and for the sake of advancing i need to have definitions of the names.. Though this seems ...
2
votes
1answer
178 views

Can anyone offer an opinion on handlersocket vs memcached performance in MySQL 5.6

I must say I was a little mis(un)-informed about the MySQL Memcached plugin which offers the same NoSQL like access to InnoDB tables as HandlerSocket, I had only had experience with entirely ...
0
votes
0answers
109 views

show database command doesn't show databases

I've made the following configuration options logpath=D:\mongodb\log\mongo.log logappend=true dbpath=D:\data\db directoryperdb=true port=64623 # [mo]ngodb maxConns=100 objcheck=true cpu=true # ...
0
votes
1answer
33 views

Line Comment in MongoDB config file

How to mark a line comment in mongodb configuration file? cpu=true #temporary for dev env Is this the right way? There is no clue about it in their website page about setting the configuration ...
0
votes
0answers
44 views

Riaks Bitcask- Why high throughput?

In the Riak docs I have read: High throughput, especially when writing an incoming stream of random items Because the data being written doesn't need to be ordered on disk and because the log ...
0
votes
0answers
96 views

Mongoose: Using limit operator with subdocs match a condition

I have a Schema like this in Mongoose: var Schema = require('mongoose').Schema; var ActivitySchema = new Schema({ is_hidden : { type: Boolean, required: true, default: false }, post : ...
1
vote
1answer
530 views

~2 Billion row fact table in star schema on Oracle. Advisable? [closed]

Let me start with: I am not a DBA; I am a backend developer. It has been suggested that, for a report schema, I implement a star schema where-in the fact table can have ~2B rows before being ...
1
vote
0answers
61 views

Why NOSql should be more performant than RDBMS under structured data loads?

The main reason NoSQL dbms have become so common is the need of storing unstructured data where a Relational database instead would require carefully designing a database schema and fitting data into ...
1
vote
0answers
55 views

Dealing with null values in non-nullable columns in a NoSQL database

If I have an existing table in a NoSQL database cluster and I want to add a new column that should never return null, how do I handle it in my application code? I can update all exist records and ...
1
vote
0answers
81 views

Can XML columns in Oracle/MS SQL Server replace document oriented databases to some extent?

Just a strategic question: I am currently working with frequently changing data schemas and it takes a lot to keep track of versions and specific content. I do, however, have a classic OLTP ...
1
vote
1answer
256 views

Design DB for users with different information fields?

Let's say I want to register all faculty of a university and they are in different fields and have different resume information. Here we have some common fields and some field specific fields. for ...
0
votes
1answer
333 views

Accumulo table design methodology

I am just getting started with Accumulo and NoSQL databases and I am looking for some discussion on table design. I get the key value structure that is seen in the manual. However, if I am trying to ...
1
vote
1answer
87 views

Use Database to Store Data Extracted From Internet

I'm mining 500 million users, and their "followers" from a social network using their API. The extraction of data itself is not a problem, since I can do it with my scripts. However having 500 million ...
0
votes
1answer
77 views

Two types of data, so two type of databases?

For a social network site, I need to propose a DB. The application is written in Java & will be hosted on VPS(s) initially. Broadly classified there is two type of data to be stored at backend: ...
2
votes
1answer
391 views

What database and setup can handle several million inserts per minute? [closed]

We have come to a point where for a few of our customers' systems, at peak times, events are generated at that crazy rate. That is, millions of new events per minute (between 1M and 2M). The ...
0
votes
1answer
80 views

Is PostgreSQL appropriate for processing this large but simple dataset? [closed]

I have a dataset I'm not sure how to store. The structure is simple: 30 numeric attributes identified by about 15 billion x, y, and t values. We're expecting ~17k t values and maybe 90k x/y ...
5
votes
1answer
679 views

Full text search through many tables in MySQL

We have high traffic NEWS websites, I want to add a feature that every user can search through over all content of site, such as news, polls, comments, galleries,etc . Each of contents type has its ...
0
votes
1answer
371 views

difference between MySQL and noSQL databases [duplicate]

All these days I've been using MySQL, recently I saw a kind of similar named Database NoSQL. What is NoSQL and what is the difference between them ?
1
vote
0answers
311 views

Data replication between SQL server 2008 R2 and other NOSQL DB (ML, MongoDB)

I'm a newbie in RDBMs and I have the question regarding replication between SQL Server (Oracle in future) and NOSQL MarkLogic server (ML). There are two servers: Machine with SQL server 2008 R2 ...
3
votes
2answers
189 views

Scalability: Desiging a message table

This question might be deadly simple but I wanted to make sure I am going through the correct path and not making any simple and irrevertible mistakes. My project will be based on messaging and it ...
1
vote
1answer
176 views

MongoDB service not starting on RedHat - missing 'service_uri'

I'm on a Red Hat Enterprise Linux Client release 5.4 (Tikanga) machine I created my /etc/yum.repos.d/10gen.repo like this: [10gen] name=10gen Repository ...
2
votes
1answer
2k views

If foreign keys/cascade deletes are bad, why use a database-server with that feature?

I noticed wordpress/rails etc do not use foreign keys constraint or cascade deletes features from database. Instead they handle this in PHP/Ruby/scripting level! I have read this and this. Most ...
1
vote
0answers
194 views

Store large hierarchy in NoSQL each day and compare

I'm in the process of creating a utility that stores a fairly large hierarchy into a NoSQL document. The data of this is similar to an Active Directory / LDAP structure which contains sub groupings, ...
4
votes
4answers
517 views

In Memory Database for high transaction and volume spikes on a website [closed]

I am looking at the IA for a hypothetical application scenario, for example: A high demand application such as an online ticketing website where there can be demand for 100,000 tickets to be ...
0
votes
2answers
640 views

Storing dynamic data in NoSQL

I have scenario where I need to store unstructured data but the rest of my data is structured and relational. An example of the type of unstructured data is as explained below: User Type 1: How do ...
-2
votes
1answer
110 views

Why Hypertable is not supporting joins and Transaction? [closed]

I have read the following topic about hpertable http://hypertable.com/documentation/. Why Hypertable is not supporting joins and Transaction?
0
votes
1answer
424 views

UTF8 vs ASCII or custom binary format: high-performance optimization on very big tables

The summary of my question is whether there are advantages, even if minimal, to use ASCII, or even a smaller format designed yet created specifically for the situation, instead of UTF-8 for strings. ...
1
vote
1answer
112 views

How would I change this relational model to fit a nosql database?

Because of things beyond my control, I have to switch from a relational database to MongoDB for the advertising platform I'm helping to build. I've got a relational schema sketched out, but I'm unsure ...
11
votes
3answers
3k views

Choosing a database for storing large amount of data and allowing for thousands of writes [closed]

I am working on a project that has some serious requirements regarding its database and having hard time choosing the best solution. The details are: Database will easily reach tens of terabytes of ...
4
votes
2answers
872 views

Sharded key-value store using MongoDB

Would like to set up a key-value store that is sharded across multiple machines. We are currently using MongoDB, is there a reason why we shouldn't use MongoDB for this purpose? We also use Redis, ...
1
vote
1answer
244 views

Switching to NoSQL for native JSON use?

I am rather comfortable writing concrete schemas with explicit primary keys, foreign keys, indexes, views and stored procedures. For queuing I use a NoSQL solution called: Redis. Recently I heard a ...
3
votes
3answers
947 views

Relational vs Non-Relational Database for Events Database

I'm trying to find out whether an SQL or no-SQL solution would be better for creating an events database. I'm creating a ticketing system, similar to ticket master. I know that for either ...
1
vote
2answers
5k views

To find a version for your pc check with the software publisher install mongodb

I want to install MongoDb on windows 8 but when i try to run C:\mongodb\bin\mongod.exeiget this error: To find a version for your pc check with the software publisher.
0
votes
0answers
230 views

Use cases for NoSQL databases: Time series

I need to set up a database that will record temporal series data (sensors). A friend of mine has recommended me to use a NoSQL database instead of using Oracle (for instance). There're also some ...
1
vote
0answers
121 views

Real Time data collection - Help select Database

My Scenario: I want to collect data from various sensors[for now I have 600 sensors sending data, but this may have to scale up to 3000 more data sensors, all sensors send real time data] Now I have ...
36
votes
5answers
7k views

Which database could handle storage of billions/trillions of records?

We are looking at developing a tool to capture and analyze netflow data, of which we gather tremendous amounts of. Each day we capture about ~1.4 billion flow records which would look like this in ...
1
vote
1answer
262 views

MongoDB: Aggregation workaround by helper collection

Since I regularly run against mongodb's document size limit and also aggregation framework's group limitations >16M, depending on the amount of data I need to process, I look for a simple workaround. ...
2
votes
0answers
55 views

Create Scheme that allows for fluidity between entities [closed]

We are a small rapidly evolving company and recently investigated switching databases from SQL Server to a graph database. We like the graph approach because of the fluidity and openness that it ...
5
votes
1answer
491 views

What fillfactor for caching table?

I have heavily updated / accessed table where I store serialized java objects. They are in the table for 2-3 hours (also are being updated during that period) and then removed. Size of table is around ...
0
votes
3answers
250 views

Would a NoSQL solution be relevant for a real-time mobile game?

Developing an iOS/Android/WP real time game. Server side stuff will be done in Javascript using Node.js. It will be a trivia with 8-players rooms + an admin site made in Python with Flask (for stats, ...
44
votes
5answers
7k views

Why can't RDBM's cluster the way NoSQL does?

One of the big plusses for nosql DBMS is that they can cluster more easily. Supposedly with NoSQL you can create hundreds of cheap machines that store different pieces of data and query it all at ...
2
votes
2answers
4k views

NoSQL, CouchDB vs. CouchBase, What should i do?

I started to encounter some issues on my production site, when having a web page that needs to load a very big ResultSet (currently coming from relational database, MySQL) it takes forever, and ...
-2
votes
1answer
76 views

NOSQL Database for [closed]

can anybody say me if I use NOSQL database and then kind of database should I use for development of a salary benchmarking website like glassdoor? Should that be MongoDB or Neo4j database, which is ...
1
vote
1answer
184 views

is it reasonable to use NoSQL for my project

Imagine you want to write a webapp for selling your car online. A car has a lot of attributes. Like how many doors, color, aircondition, etc. Some of them are simple boolean values, others might need ...
2
votes
2answers
533 views

How well, if at all, does Oracle NoSQL database integrate with Oracle RDBMS?

I currently have an application which runs on Oracle RDBMS and an area of new functionality which would be better supported by a NoSQL store. I am wondering if Oracle NoSQL Database may be a good ...
2
votes
2answers
419 views

Should I use SQL or NoSQL for this specific design (surveys)?

Building a small web application to create satisfaction surveys with a default list of questions and responses. The application is for a small audience of people (5,000 max) with surveys sent out when ...
1
vote
1answer
273 views

Books to start with big data [closed]

I would like to start learning about the big data technologies. I work in this area in the future. Does anyone know good books to start learning about it? Hadoop, HBase. Beginner - intermediate - ...
0
votes
0answers
112 views

Database (open source) for complex queries (for analytics) like these:

In an app, I'll be storing information about events, specifically, session_id url time type data: foo: bar bar: foo The data will basically be a hashmap (need to support arbitrary types / names ...
1
vote
2answers
218 views

Can graph databases be easily distributed?

I have never worked with graph databases such as neo4j, I would like to know if they support easily replication and clustered distribution as well as key-values databases, or if there inherent ...
-1
votes
1answer
290 views

Database for an application similar to Chatroulette

I am making an app that is similar to Chatroulette. When a user starts the app it finds someone that is not currently talking to anyone and have them talk to each other. At any point a user could ...