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

3
votes
0answers
369 views

How do you think in NoSQL? [closed]

I'm from the pre-nosql era and am rather comfortable with SQL. However, I cringe whenever someone suggests using a NoSQL database for the "upcoming" project. There are some major problems that I'm ...
0
votes
1answer
707 views

Maximum number of fields/columns in MongoDB

I'm considering learning and using MongoDB for a project, but I'm going to need to be able to store at least 1024 columns for the first part, and as many as 1048577 for the second. Does MongoDB have a ...
0
votes
1answer
546 views

How can I Automate MongoDB schema design from existing MySQL Database and Logs?

I am working on the project which will automatically generate sample MongoDB schema analyzing existing MySQL database and logs. I am looking for help regarding the below questions. Please, share your ...
3
votes
2answers
7k 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 ...
1
vote
1answer
340 views

What mongodb database layout would fit better

I'm currently writing an application using the MEAN stack, pretty much only for fun and because MEAN is "cool" at the moment. Therefore I'm thinking about the database layout. The data needed to be ...
52
votes
5answers
17k 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 ...
0
votes
1answer
120 views

On my local computer, where is the data stored for a search on a dynamodb database

I am using RazorSQL to access a dynamodb database in a "SQL"-like way. One of the things RazorSQL lets you do is the sql command select * from table where ... on all columns. This is significant ...
62
votes
5answers
12k 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 ...
3
votes
2answers
8k views

Is there any open source GUI tool to monitor cassandra? [closed]

I would like to monitor cassandra database as well as need to check the values in the database. Could any one suggest me best open source GUI tool ? Regards, Arun Raj.
4
votes
3answers
1k views

Are there any in-memory NoSQL databases?

Given that NoSQL databases are designed to support horizontal scalability by throwing in more servers, are there any that are designed to do entirely without persistent disk storage? I'm looking at ...
0
votes
1answer
279 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 ...
0
votes
1answer
162 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 ...
1
vote
1answer
321 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 ...
1
vote
1answer
1k 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 archived....
1
vote
0answers
81 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
146 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 ...
0
votes
1answer
653 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
0answers
144 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 ...
4
votes
2answers
2k 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
122 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 ...
2
votes
1answer
724 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 records/...
0
votes
1answer
97 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 ...
7
votes
1answer
2k 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
788 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 ?
43
votes
5answers
81k views

What is a Key/Value store database?

I've been looking at the wikipedia page for NoSQL and it lists several variations on the Key/Value store database, but I can't find any details on what it means by Key/Value store in this context. ...
1
vote
0answers
545 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
282 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 ...
3
votes
1answer
4k 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 ...
2
votes
0answers
386 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
1k 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 ...
1
vote
1answer
1k 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
178 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?
2
votes
1answer
439 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. ...
1
vote
1answer
155 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 ...
12
votes
1answer
3k views

Amount of data per node in Neo4j

I need to store substantial amounts of data per node in Neo4j. The data is Unicode chunks of text. Actually not every node will have big chunks, but many of them will. I waded through the ...
2
votes
1answer
337 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 ...
1
vote
2answers
296 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
vote
0answers
149 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 ...
1
vote
1answer
135 views

Is it possible to query “NOT IN” in NO SQL?

I asked the same thing about a specific NoSql engine (Big Table) on SO. It seems that Big Table doesn't support NOT IN queries? Is that possible in any other NoSQL databases? Will it ever be possible ...
0
votes
3answers
370 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, ...
-2
votes
1answer
94 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 ...
2
votes
1answer
235 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
763 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 ...
13
votes
2answers
2k views

Schema-less/flexible + ACID Database?

I am looking at rewriting a VB based on-premise (locally installed) application (invoicing+inventory) as a web based Clojure application for small enterprise customers. I am intending this to be ...
3
votes
2answers
338 views

Database choices for big data

I have many text files, their total size is about 300GB ~ 400GB. They are all in this format key1 value_a key1 value_b key1 value_c key2 value_d key3 value_e .... each line is composed by a key and ...
3
votes
1answer
193 views

Which database?

We have to launch a new service in my company with a big database. And I currently don't have that much knowledge. We did a small preview of the service and our biggest table had more than 2 100 000 ...
2
votes
2answers
1k 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
447 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
127 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 ...
17
votes
3answers
10k views

What does horizontal scaling mean?

In database context, I have come across horizontal scalability as one of the advantages of the NOSQL databases. What does the term mean? http://en.wikipedia.org/wiki/CouchDB http://en.wikipedia.org/...