Databases that do not use SQL as their query language.
2
votes
1answer
121 views
Designing a universal database driver class
I have a homebrew MVC framework that I have been using for a while, and it has been working great, but I am planning an upgrade to it for its ORM classes. So far, it only supports SQL databases by ...
2
votes
1answer
94 views
Sub-Resource data should be embedded in Resource entity or duplicated in NoSQL document?
I have a scenario similar to as depicted below,
public class Post {
private int id;
private int postType;
private int score;
private User originalPoster;
private String title;
...
1
vote
1answer
188 views
How to model hashtags with nodejs and mongodb
Existing architecture: nodejs server with mongodb backend.
I have strings coming in describing images that can have #hashtags in them.
I wish to extract the hashtags from the strings, store the ...
1
vote
0answers
37 views
What is a good pattern for multi language in MongoDb?
Say I want to build a website that support multiple language and use MongoDB datastore. I wonder what is a good approach to have multiple versions of the body and title of an article, one for each ...
-1
votes
1answer
63 views
Using Rails with a NoSQL database [closed]
I'm planning on creating a Rails site that is backed by a NoSQL database (DynamoDB). Admittedly, I'm no expert in Rails however this immediately seems to go against conventional Rails configurations ...
3
votes
2answers
145 views
Why is MongoDb popular with Node.js? [closed]
I've been looking att different web stacks, mainly rails and node.js. One thing that strikes me is that while rails is often used with a relational database Node.js seem to go hand in hand with ...
1
vote
1answer
232 views
How best to merge/sort/page through tons of JSON arrays?
Here's the scenario: Say you have millions of JSON documents stored as text files. Each JSON document is an array of "activity" objects, each of which contain a "created_datetime" attribute. What is ...
0
votes
0answers
84 views
HDF vs NOSQl solutions
Hi I get a look in some scientific data stored in HDF5 format and I was wondering if there is any NoSQl solution that will reach the same performance in read/write as HDF5 .
The data of my example ...
4
votes
3answers
149 views
Looking for a freeware NoSql key-value database to offload a Java HashMap
I have a Java HashMap with a String key and POJO value in a long-running application, and it's taking up a large chunk of memory (over 500mb, and this number is expected to grow - I'm guesstimating ...
0
votes
2answers
143 views
ACID compliant Database that isn't NoSQL? [closed]
I'm not necessarily asking if a NoSQL database can be ACID compliant, which has been asked here:
Is there any NoSQL that is ACID compliant?
I'm wondering if we have a database either now or in the ...
1
vote
4answers
344 views
Why NoSQL (Key-Value) storage become popular these days?
It seems that NoSQL concept not something very new and innovative, but these days become very popular. Why it become popular recently but not happen in the time when SQL is very popular?
4
votes
4answers
764 views
why are noSQL databases more scalable than SQL? [duplicate]
Recently I read a lot about noSQL DBMSs. I understand CAP theorem, ACID rules, BASE rules and the basic theory. But didn't find any resources on why is noSQL scalable more easily than RDBMS (e.g. in ...
3
votes
4answers
514 views
NoSQL and BIG DATA
I am doing an internship on Big Data technologies so I am new to this area. My question is about the use of NoSQL in the Big Data architecture. Do we need always to use a distributed storage (like ...
0
votes
0answers
59 views
which of the following mongo documents structures are more suited for storing business rules for a loyalty program?
I have been going through MongoDB to evaluate it as an option for storing business rules which are to be applied before we calculate reward for an end-user. The platform in questions is a loyalty ...
5
votes
1answer
112 views
What is the common approach to component template databases?
My Project:
I have employees who are required to go through a checklist when they encounter a duck, a cat, and a human. In our business, we have a set number of ducks, cats, and humans that come in ...
88
votes
12answers
29k views
Why use a database instead of just saving your data to disk?
Instead of a database I just serialize my data to JSON, saving and loading it to disk when necessary. All the data management is made on the program itself, which is faster AND easier than using SQL ...
2
votes
2answers
360 views
Why OTServs have an item cloning problem if the server crashes? [closed]
OTServs are open source MMORPGs with a huge community. Mostly all of them have a serious problem: if the server crashes, people can clone items. This is a dirty trick that can be executed because the ...
1
vote
1answer
220 views
Is map-reduce the basic factor that makes NoSQL more scalable than SQL?
I'm studying the differences between NoSQL and SQL, and what makes the first more scalable. I think I got the point, so I'll try to explain:
Suppose an app has a list of billions of users, each with ...
-1
votes
1answer
108 views
What are techniques used to make scalable, fast databases? [duplicate]
I'm studying the differences between NoSQL and SQL. If I understood correctly, there are two main techniques to optimize a database:
Indexing rows. Say you wanted to make a query such as WHERE x = 1 ...
3
votes
3answers
224 views
NoSQL Document Database as a Message Queue
I am considering using a NoSQL Document database as a messaging queue.
Here is why:
I want a client to post a message (some serialized object) to the server and not have to wait for a synchronous ...
1
vote
1answer
68 views
NoSQL (Azure Table Storage) RowKey design for ordered data
I store large quantities of GPS data in storage tables. Each partition can reach up to 1 million entities. Each GPS entity that is inserted into the table is actually sequential to the previous data ...
1
vote
2answers
128 views
Is NoSQL a good fit for a graphing app, and how can I compare different NoSql Servers?
I am traditionally a MsSQL or MySQL developer - I have been prototyping a new application that involves storing data from many targets.
I have seen that the app appears to get slow after scaling to ...
1
vote
1answer
47 views
Azure Storage Table design with multiple query points
I have the following Azure Storage Table.
PositionData table:
PartitionKey: ClientID + VehicleID
RowKey: GUID
Properties: ClientID, VehicleID, DriverID, Date, GPSPosition
Each vehicle will log ...
7
votes
3answers
268 views
NoSQL use cases [closed]
I am developing an application for my universities student research symposium around the idea of polyglot persistence. I have read Martin Fowlers book and done some other research online about the ...
2
votes
2answers
417 views
Why is NoSQL better for this scenario?
Hypothetical scenario: Let's say we are downloading JSON from Facebook with details of a user's friend's checkins, posts, etc... These come in as one document per friend per activity, so with 8 ...
1
vote
1answer
100 views
Is Neo4j graph database sufficient to itself for all query types?
Neo4j eases relationship traversals => especially useful for a social network for instance.
But are there any scenarios when it's advised to associate an additional relational database (or other ...
0
votes
1answer
164 views
Where to start with NoSQL [closed]
NoSQL look like it is trendy right now, so I am looking to at least learn a bit about it (looking at current job ads, a lot of the ones I am qualified for have some form of NoSQL experience as plus ...
1
vote
1answer
144 views
Static Tables vs Dynamic Entity Attributes Storage Configurations
I am trying to figure out a better way to decide table storage configurations whether it will use static configurations using tables or dynamic configurations using EAV (entity-attribute-value)
When ...
8
votes
5answers
972 views
Writing Web “server less” applications
TL;DR
What are the prospects of writing applications which are completely based on a REST database server (CouchDB) and web applications which directly access the DB instead of having a web server in ...
1
vote
1answer
197 views
NoSQL as file meta database
I am trying to implement a virtual file system structure in front of an object storage (Openstack). For availability reasons we initially chose Cassandra, however while designing file system data ...
2
votes
6answers
528 views
Dynamic Fields/Columns
What is the best way to allow for dynamic fields/database columns? For example, let's say we have a payroll system that allows a user to create unique salary structures for each employee. How ...
2
votes
1answer
203 views
Is file system one of the NoSQL? What's the main difference?
I am confused about it.
I can use lucene to create index and run query against file system.
I can find any particular file very fast, if I can provide a primary key, in this case, directory path and ...
9
votes
5answers
2k views
What will be correct answer to “why is NoSQL faster than SQL” on interview?
It's just nonsense for me personally. I can't see any performance boost by using NoSQL instead of SQL. Maybe SQL over NoSQL, yes but not in that way.
I think that if I answer "I have no idea" or ...
2
votes
5answers
332 views
Should I try to write simple key-value storage by myself?
I need a key-value storage in a simplest form we can think of.
Keys should be some fixed-length strings, values should be some texts.
This key-value storage should have an HTTP-backed API.
That's ...
2
votes
1answer
358 views
What is the recommended MongoDB schema for this quiz-engine scenario?
I'm working on a quiz engine for learning a foreign language. The engine shows users four images simultaneously and then plays an audio file. The user has to match the audio to the correct image. ...
5
votes
2answers
362 views
How do document-oriented databases implement references?
In relational world we have Foreign Keys to reference other entities. But how do document-oriented databases like MongoDb, CouchDb, RavenDb implement references among entities?
Update. StackExchange ...
8
votes
2answers
1k views
best practices for NoSQL database design
I have just started using a NoSQL document based database (MongoDB) and i'm curious about the best practices for designing databases.
I presume the architecture should be different from relational ...
3
votes
1answer
287 views
How would one build a relational database on a key-value store, a-la Berkeley DB's SQL interface?
I've been checking out Berkeley DB and was impressed to find that it supported a SQL interface that is "nearly identical" to SQLite.
...
4
votes
2answers
322 views
Using HBase or Cassandra for a token server
I've been trying to figure out how to use HBase/Cassandra for a token system we're re-implementing. I can probably squeeze quite a lot more from MySQL, but it just seems it has come to clinging on to ...
1
vote
2answers
285 views
Considering JCR as a NoSQL solution?
I'm evaluating some NoSQL solutions for a project of mine and JCR popped up during my searches as a document store. But it seems somehow of an obscure niche which didn't have the impact its designers ...
3
votes
2answers
3k views
How to correctly design NoSql database schema? [closed]
I would like to learn something more about NoSQL databases, so I've chosen to create a new project from scratch to handle football results. In my traditional relational database, I have tournaments, ...
3
votes
2answers
983 views
Rails and Mongoid best way to implement sharing system
I have to model User and Board in rails using mongoid as ODM.
Each board is referenced to an user through a foreign key user_id and now I want to add the ability to share a board with other users.
...
5
votes
3answers
1k views
NoSql databases - Decent tutorial/book that covers the concepts
Am looking for a good resource on learning the concepts behind NoSql databases.
Most things I find are related to a specific technology (MongoDb, CouchDB etc) but I'm after all the concepts behind ...
2
votes
2answers
223 views
Is it sane to use Document based NoSQL for store big data tables
In Document based NoSQL to create tables (AFAIK) I need:
Create such many as many rows in table documents with same ID field (that will be table id) and each time need to set the columns (for each ...
7
votes
5answers
3k views
Is MongoDB the right choice in my case?
I'm going to build my first real project in Rails that consist in a web app made of 3 main parts:
The static part where no database is used
The User registration part which will require a database ...
4
votes
4answers
829 views
Can NoSQL databases be used in e-commerce companies for order management?
Is it possible to use a non relational database be in an Order management system for an e-commerce company with a large number of orders everyday, like Amazon? Can the benefits of Non Relational ...
0
votes
1answer
138 views
Recommendation for a database to query records with attributes that are arrays or hashes?
I'm building site with a very simple data structure: documents that are nodes that reference other nodes that each have arrays of parents, children and siblings, so the structure is:
Node:
uuid
name ...
5
votes
1answer
527 views
Which NoSQL repository is most suitable for a Twitter-type architecture?
In an upcoming project I need to create a Twitter like web application where the basic idea is to read / write short messages and status updates (similar to tweets) and group these messages (just ...
22
votes
8answers
2k views
Are NoSQL databases going to take the place of relational databases? Is SQL going away? [closed]
Does anyone have experience with NoSQL databases (CouchDB, MongoDB, Google's BigTable, Dynamo, Cassandra...)? What was it like? Was it actual production/on the job experience?
What will happen to ...
4
votes
2answers
1k views
Can SQL Server and Mongo be used together?
We have a large news-oriented site that has high web traffic. The architecture is your often seen DB - Repo Layer - Services Layer - Asp.Net MVC. The problem that we've been seeing is around read ...
