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

1
vote
1answer
120 views

Database Design for NoSQL Fantasy Baseball League

I am trying to create a proper schema to place scraped data into, using a MongoDB database. Currently it looks like Team { id : id, name : String, teamLink : String, username : ...
1
vote
1answer
20 views

What are some databases that are schema-full but not relational

What are some databases/datastores that are schema-full, but not relational? In other word I'm after some NoSql databases that are not schema-less. By schema-full I mean that, like in a traditional ...
0
votes
1answer
46 views

Is using a relational DB for storing votes and (accessed resources) overkill?

I am writing a forum component for a site and would like to keep track of what topics/questions a user accesses so that other topics/questions can be recommended based on said users previous choices. ...
0
votes
2answers
265 views

Redis takes up all the Memory and Crashes

A redis server v2.8.4 is running on a Ubuntu 14.04 VPS with 8 GB RAM and 16 GB swap space (on SSDs). However htop shows that redis alone is taking up 22.4 G of memory! redis-server eventually crashed ...
-1
votes
0answers
39 views

Benchmark New NoSQL DB? Hyperdex, Aerospike, MonetDB [closed]

I would like to find the fastest database (preferably free) for some OLTP and a lot of OLAP. I reduced my canidates to two groups: a) MonetDB vs RocksDB vs Couchbase OR Redis -> for an in memory ...
5
votes
3answers
257 views

Replace relational database with “poor” design in software product with non-relational DB? [closed]

Think of a software system you look at, based on classic, relational databases (SQL Server, Oracle), NHibernate as object-relational mapper (ORM), a business logic model layer on top and a huge number ...
0
votes
1answer
20 views

Best practices for relating NoSQL data to RDMBS

I am looking to use both a NoSQL solution (Redis, Mongo, etc) with a mySQL/Laravel application. My reasons for this is that I need a schemaless key value storage to go with my relational data. I could ...
1
vote
1answer
24 views

Keeping rows ordered by counter value

I'm storing linked words in a Cassandra v2 cluster and I'm having a hard time doing efficient reads. I'm trying to fetch the top X rows with the highest counter value. Cassandra doesn't store the ...
0
votes
0answers
11 views

Architecture for huge catalog of products

I need to upgrade my current system of product catalog. For currently I have a 12 000 items in catalog, it's not a lot, but I need to improve them for feature. I have a task to reorganize my database ...
0
votes
1answer
395 views

Storing multidimensional array in MongoDB

I am attempting to convert a large MySQL database of product information (dimensions, specifications, etc) to MongoDB for flexibility and to move away from the restriction of a column based table. I ...
0
votes
0answers
13 views

Cassandra cluster on Windows Machine

I am new to Cassandra, and have been trying to create a cluster using DevOps. When I add a node , I get the following error: Error provisioning cluster: Unable to SSH to some of the hosts ...
1
vote
1answer
22 views

MongoDB: how to create a new database

After installation, test,admin and local are the default database. As per the MongoDB tutorial, when we insert data in collection a database will be listed in show dbs command. For a specific purpose, ...
1
vote
1answer
37 views

Checking records consistency after mongorestore --noobjcheck

I had an HDD malfunction on a Mongo node. After running fsck and mongod --repair I was able to dump the needed collection with mongodump and move it to another server. However, some records appear ...
1
vote
0answers
49 views

Relational or non-relational database for a system to pass objects on?

hopefully this is the right place to ask this kind of question. I am working on a system that focuses on helping people give away things that they don't use anymore. So, an object typically has the ...
0
votes
1answer
21 views

How should I implement logs into a document store db?

I am somewhat unsure if I want to use document store(noSQL) for the sake of using it or because it could really help in my situation. Here is my problem, I have users, I can think about them as ...
2
votes
0answers
83 views

Should I use SQL Azure to store product descriptions and links to images in Azure Blob

For an html/Css/JQuery public Azure website to be coded using Zurb Foundation html5 responsive framework, I'd like to use SQL Azure (web edition) to store product descriptions and links to images that ...
-1
votes
1answer
35 views

Disable MongoDB journaling?

Are there any benefits in disabling mongodb journaling besides performance gain? I know journaling provides write durability and crash resiliency. But I can tune syncdelay parameter to make data files ...
3
votes
2answers
1k views

What is a good way to copy data from one Cassandra ColumnFamily to another on the same Keyspace (like SQL's INSERT INTO)?

Trying to find a way to easily transfer all the rows from a Cassandra ColumnFamily/Table to another. The COPY command, as I understand, is a good option. However, as it dumps all the data to .csv on ...
0
votes
1answer
12 views

MongoDB Booleans

In MongoDB, I could store a boolean like so: active: True But that doesn't really take advantage of NoSQL, since there's no reason to have the active property at all if it's false. Is there a way ...
1
vote
2answers
27 views

What's the best design for a logical structure that contains different properties of various types for different entity categories? (MySQL or NoSQL)

I'm designing a MySQL database that needs to contain a list of products. Those products, based on their category, will need to have a list of various properties. Let's say all products in category ...
1
vote
3answers
216 views

Heterogeneous ordered list of value

I have the following object model: class A { List<Thing> orderedListOfThings; } interface Thing { } class X implements Thing { int attr; } class Y implements Thing { String ...
0
votes
0answers
30 views

noSQL for log/stats database

I'm trying to determine whether pursuing (learning,testing and implementing) a noSQL (CouchDB) to store and process log information. The log depending on the type of event has varying number of ...
0
votes
1answer
17 views

Collate view with old record on couchdb

I need to create a collate view with couch db but I dont want to use the current records, I want to use records of a specific revision. For example, lets imagine that I have an invoice with an array ...
0
votes
1answer
56 views

SQL or NoSQL for structured clinical data [closed]

I'm designing a database for a primary health center, the idea We basically have a Patient with many Encounters, also the Encounters have to be entered from different Users (Health Professionals). ...
1
vote
1answer
69 views

Data modeling with many attributes where few apply to each record [closed]

I'm pretty new to data modeling, so please excuse me if I've missed something obvious. I'm trying to decide on a schema (or possibly a DBMS) to work with some data where there are quite a few possible ...
0
votes
1answer
18 views

View collation are incomplete joins in couchdb

I was trying to create view collations following this tutorial: http://elegantcode.com/2012/02/14/view-collation-in-couchdb/ but I realize that the result was an array with 5 elements with 2 objects ...
0
votes
4answers
81 views

Use SQL or NoSQL? [closed]

I'm designing a system that checks a given website for any security vulnerabilities. The system includes a client (firefox plugin) and a server. The server does all the scanning while the client just ...
1
vote
0answers
45 views

Advice to choose the best tool [closed]

We have some kind of a high-load system. Currently, we're using Postgres on RAM disk (you know all the pros and cons). There are around 10 millions of rows. There's only 1 external key, and these 2 ...
1
vote
0answers
110 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 ...
15
votes
2answers
8k views

Timeseries: SQL or NoSQL?

I don't care about the general differences between SQL and NoSQL (or their traditional differences). I am currently looking at altering the storage of our internal time series. They all contain ...
1
vote
1answer
142 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 ...
1
vote
2answers
4k 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.
11
votes
3answers
2k 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 ...
0
votes
1answer
58 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
256 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 ...
0
votes
0answers
46 views

Collection VS lots of Fields

As of the moment we are having this collections RptCustomer RptCustomerMonthly RptCustomerDaily RptStoreCustomer RptStoreCustomerMonthly RptStroreCustomerDaily RptFranchise ...
49
votes
6answers
15k views

What are the differences between NoSQL and a traditional RDBMS?

What are the differences between NoSQL and a traditional RDBMS? Over the last few months, NoSQL has been frequently mentioned in the technical news. What are its most significant features relative to ...
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 ...
0
votes
1answer
89 views

Deleting aerospike bins

I have an Aerospike instance and I messed up one of my namespaces. I didn't know there was a ~32k limit on bins, so i wrote unique bin names into my namespace. I hit that 32k limit, and now my whole ...
1
vote
1answer
115 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 ...
1
vote
0answers
92 views

Best database for fast read all in one table

I currently have a large database in SQLite that I was using for rapid-prototyping for a software I am working on. Now that I am planning to move it to another database that should give better ...
35
votes
5answers
6k 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
0answers
10 views

Are rfiles in Accumulo and hfiles in Hbase similar in structure and purpose?

I cannot seem to find much info on rfiles other than the Accumulo site and from what I can gather from the information I cannot deduce whether like hfiles they are based on Mapfiles and meant to store ...
0
votes
1answer
22 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 ...
42
votes
5answers
6k 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 ...
1
vote
2answers
644 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.
0
votes
0answers
93 views

Elasticsearch: Versioning a document on revisions

I currently have a document which gets revised regularly, I want to keep track of the document by keeping each old version of the document. So if document A has a summary and update date I want to, ...
4
votes
3answers
961 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
51 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
30 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 ...