Stack Overflow
Stack Overflow

Questions tagged [nosql]

NoSQL (sometimes expanded to "not only SQL") is a broad class of database management systems that differ from the classic model of the relational database management system (RDBMS) in some significant ways.

NoSQL (sometimes expanded to "not only ") is a broad class of database management systems that differ from the classic model of the relational database management system () in some significant ways.

NoSQL systems:

  • Specifically designed for high load
  • Natively support horizontal scalability
  • Fault-tolerant
  • Store data in a denormalized manner
  • Do not usually enforce strict database schema
  • Do not usually store data in a table
  • Sometimes provide eventual consistency instead of ACID transactions

In contrast to RDBMS, NoSQL systems:

  • Do not guarantee data consistency
  • Usually support a limited query language (a subset of SQL or another custom query language)
  • May not provide support for transactions/distributed transactions
  • Do not usually use some advanced concepts of RDBMS, such as triggers, views, stored procedures

NoSQL implementations can be categorized by their manner of implementation:

Free NoSQL Books

Related tags

13110 questions
4
votes
1 answer

Is it necessary to use all the columns defined as the primary key to query a Cassandra database?

I am using Cassandra database and need to define the Primary Key which is a combination of partition key and clustering keys. The cassandra database needs to be queried based on the combination of two fields i.e. a customer number and createdAt…
Avinash Singh
  • 63
  • 5
4
votes
2 answers

Raven DB to SQL server (NoSQL DB to Relational DB)

Is there a way to convert/migrate NoSQL database data(Raven,Mongo,Couch ) into SQL server data? Since some NoSQL databases lack reporting tools, would be easier if I could move the data to SQL and work off that directly (just for data analysis,…
ZVenue
  • 4,967
  • 16
  • 61
  • 92
4
votes
1 answer

how to query for greater than sort key in dynamodb with boto3

I have a dynamodb table with string primary key called name and number sort key age. I want to get the items in the dynamodb table with age younger than 30. I understand that since my filter is on a Key, I can use query instead of scan. So I tried: …
tom q
  • 97
  • 2
  • 6
4
votes
1 answer

Aerospike Python Documentation - Incorrect Syntax?

I'm trying to follow Aerospike's Python Documentation here, but it seems that it has a syntax error? def print_result((key, metadata, record)): print(key, metadata, record) Anyone who has a better idea on how to query data using Python with…
Benj Cabalona Jr.
  • 428
  • 5
  • 17
4
votes
1 answer

DynamoDB | How to Query all records in sorted order without specifying a Partition Key

I'm using AWS DynamoDB to store user session records for a web application. Each record is of the following format: uuid timestamp type where uuid is a users id and partition key timestamp is a unix timestamp and sort key type is "connected"…
Vingtoft
  • 13,368
  • 23
  • 86
  • 135
4
votes
1 answer

Multi-tentant model and nosql?

When doing multi-tenant applications using a RDMBS I use tenantId columns in each table to indicate which tenant a row belongs to. How would I do that in a DocumentDatabase? Let's take mongodb for instance. Is DBRef the way to go? Or am I stuck in…
jgauffin
  • 99,844
  • 45
  • 235
  • 372
4
votes
3 answers

How to create like query in Cassandra?

In my keyspace posts = [ #key 'post1': { # columns and value 'url': 'foobar.com/post1', 'body': 'Currently has client support FOOBAR for the following programming languages..', }, 'post2': { 'url':…
Bruce
  • 1,145
  • 1
  • 10
  • 16
4
votes
1 answer

MongoDB embed vs reference on users home address?

I have read some forums and blog posts but did not find a good answer about MongoDB schema structure when referencing another collection. For example, if I have a user collection, where the user belongs to only one address (his residence). But a…
bsantoss
  • 427
  • 6
  • 17
4
votes
1 answer

How to PutItem in dynamodb only if the item does not exist

I've got a table in dynamodb that only has a partition key, and I want to put an item in the db only if there isn't another item with the same partition key in the db. I've tried using ConditionExpression attribute_not_exists to no avail. The…
Darkstar
  • 725
  • 2
  • 8
  • 27
4
votes
3 answers

Ripping out Hibernate/Mysql for MongoDB or Couch for a Java/Spring/Tomcat web application

I have an application that is undergoing massive rework, and I've been exploring different options - chug along 'as is', redo the project in a different framework or platform, etc. When I really think about it, here are 3 major things I really…
egervari
  • 22,372
  • 32
  • 121
  • 175
4
votes
3 answers

Architecture and pattern for large scale, time series based, aggregation operation

I will try to describe my challenge and operation: I need to calculate stocks price indices over historical period. For example, I will take 100 stocks and calc their aggregated avg price each second (or even less) for the last year. I need to…
AltControl
  • 101
  • 4
4
votes
1 answer

How to find documents which contains non empty arrays inside array of items in MongoDB

I have a mongo document collection like the following, I'm trying to find the documents which has images for all the colors in that document also the document template should not be empty. [ { "template" : "one", "colors" : [ …
Unnikrishnan
  • 2,683
  • 5
  • 22
  • 39
4
votes
1 answer

(Pyrebase) error : orderBy must be a valid JSON encoded path

I use firebase and my JSON(Firebase) is as below. I want to retrieve the key values(288xxx) by using busStopName values. My code is as below. I'll make an example with '윤정사앞' # Retriving id by using value def getIdByName(db, name) : bus =…
Jung Jaehoon
  • 101
  • 1
  • 12
4
votes
1 answer

Is a primary key query in a SQL database similar to a key query in a NoSQL one in terms of speed?

From my understanding, we can compare SQL vs NoSQL to array vs hashmap/dict. (Let's consider PostgreSQL vs MongoDB just for a context) SQL is arranged in tables and searches through the rows for what you're looking for. NoSQL is arranged in a…
Mojimi
  • 2,561
  • 9
  • 52
  • 116
4
votes
3 answers

Looking for a local .Net NoSQL DB system

I'm currently trying to write a backup/sync system for myself (Dropbox etc don't cut it for my purposes), and I think I've identified the best way to do it. The issue is, using a relational DB (like the local DB I just added into my .Net 4 project)…
Liam Dawson
  • 1,189
  • 13
  • 27
1 2 3
…
99
100