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
0answers
15 views

NoSQL database for working with MS Office documents [closed]

I'm working on a project which involves ingesting Word, Excel, Powerpoint and PDF files into a database and then performing search on their contents in a fast and dynamic manner. I'm currently hoping ...
2
votes
0answers
8 views

InfluxDB - How can i limit the measures that an user can read by their tags?

I have some data that is collected by several sensors. Some users may own many of this sensors. So, i want to keep all the measures in a single database in InfluxDB. To differentiate the sensors i ...
1
vote
1answer
58 views

Should I look into alternatives to a relational database? [closed]

I am currently in the process of going through some PHP training with procedural code and will be doing a course in OOP with PHP right after that. The course will provide a solid starting point for me ...
4
votes
1answer
31 views

Dynamic form builder database optimization Postgresql

Hi I have a project that create forms dynamically I use a model like the following: forms ----- id (PK) name (other fields) form_fields ------------- id (PK) form_id (FK to forms.id) ...
0
votes
0answers
11 views

Do all types NoSQL databases have a transaction log?

Do all types NoSQL databases have a transaction log? It seems to me that there should be at least one type that doesn't but I don't know which one.
0
votes
2answers
53 views

Document Store & Relational DB Hybrid. Exists? Possible?

Does anyone know of any product or open source project that attempts to strap together Mongo DB and MySQL for instance? I hear a lot about how relational DBs being ACID compliant makes it nearly ...
0
votes
1answer
23 views

Google datastore modeling help

I have a very simple requirement. I have an application where users log in, add/remove/view friends, and can send/receive (also view the message you sent and received) a message (message is more like ...
1
vote
0answers
25 views

Design options for time series scientific data

I've been scratching my head over the last few days trying to find a solution that best suit my needs. I tried to think that what I want is probably not very different from what many others wanted ...
1
vote
1answer
22 views

Google Datastore model User and Messages efficently

I have two kinds: USER and MESSAGES. A user can send/receive many messages to/from another user. Thinking in a relational way the relationship would suggest a user can have many messages, and a ...
0
votes
0answers
23 views

Data Model for a popular/basic type of social app

I am trying to learn about Google Datastore and creating a basic application to have some practical experience with it opposed to just reading the docs. I would like to create a basic social ...
0
votes
1answer
53 views

Can SQL Server Change Data capture (CDC) log rows to an external DB?

I have not used SQL Server CDC before, but to my understanding it works like this: business data changes in source DB, e.g. SQL Server CDC has been configured to track certain table/column changes, ...
1
vote
0answers
26 views

How to use DBRefs to fetch records from multiple collections in MongoDB

I am working on a database for library system. I have a collection called 'books' and another collection called 'publishers'. This is my documents structure in collection 'book'. { "_id" : ...
0
votes
1answer
43 views

What database supports over a thousand fields and tables

I have a requirement to store several csv files with several fields in an database. This data does not need to be searchable but i need to query the data by Id. I will also need SQL to query the data ...
1
vote
1answer
49 views

From RDBMSs to MongoDB

I've worked exclusively with RDBMSs for the past 10 years and am trying to explore something new to me like MongoDB. I’m trying to learn about data model design in this environment and because ...
1
vote
2answers
78 views

Is my db too big for my server? Should I go nosql or stick with relational db management? [closed]

I have a mysql database that is about 22GB in size and has multiple tables with hundreds of thousands of records, my biggest table has 1.8 million records. The Database was not professionally designed ...
0
votes
0answers
72 views

Merging time series in influxdb 0.9.x

I have a system which demands monitoring its metrics. In order to do that I use grafana + influxdb. The version of influxdb I currently use is 0.9.x. I want to be able to calculate some statistics. ...
-2
votes
1answer
76 views

Why are writes failing in MongoDB?

Here is the information about my development environment: Microsoft Visual Studio Community 2015 .NET Framework 4.6 ASP.NET MVC assembly System.Web.Mvc Version=5.2.3.0 MongoDB.Driver 2.0.1.27 ...
0
votes
1answer
71 views

Why does MongoDB give me the cannot use 'w' > 1 when a host is not replicated Error message?

Here is the information about my development environment: •Microsoft Visual Studio Community 2015 •.NET Framework 4.6 •ASP.NET MVC assembly System.Web.Mvc Version=5.2.3.0 •MongoDB.Driver 2.0.1.27 ...
1
vote
0answers
34 views

Which hosting technology is suitable for large data with limited index

I have a scenario where I have to host very large amount of data in database type solution. The amount of data is very very large. When I try to host it in mysql database the size increases as mysql ...
1
vote
0answers
28 views

does solution of Normalilization causes duplicacy in NoSQL?

i am currently using mysql as a database but now i have decided to switch rdbms to nosql probably on mongoDB. i have an doubt that nosql removed the concept of normalization from database so in such ...
1
vote
1answer
138 views

A good use case for Postgres JSONB?

I am looking to create an Asset Management System to track assets (laptops/desktops, monitors, keyboards, mice, bags, software keys, etc), basically anything that can be assigned to an employee. My ...
4
votes
1answer
55 views

What exactly are secondary members acknowledging in replicasets with MongoDB?

I try to understand the mechanics and behavior of MongoDB's replica-features better. I hope to get some insightful information from someone who is familiar with mongo's internals and behaviour. My aim ...
1
vote
1answer
63 views

What kind of database should I use?

I'm designing a new system and I'm wondering what kind of DB should I use for my needs. I have a tree structure of nodes, where each node has historic values. For each historic value it should hold 2 ...
8
votes
2answers
294 views

NoSQL : What is unstructured data?

we are currently running at the edge of resources with our mssql server based solution. We have now many traditional options regarding the next move to tackle the load: buy faster CPUs and IO ...
0
votes
0answers
42 views

How to merge numerous collections within one colection in MongoDB?

Here is the scenario: In one collection name is "Parent" I have the following document {"_id" : ObjectId("4f7ee46e08403d063ab0b4f9"), "name" : "MongoDB", "range" : "spec", "notes" : { { ...
0
votes
1answer
73 views

Based from experience, is dreamfactory better paired with a RDBMS like MySQL or NoSQL like MongoDB

This is our first time to create a data logging web application and we have chosen to use Dreamfactory as the backend framework. We have been used to with MySQL from the past with small amount of data ...
0
votes
0answers
49 views

mysql - suggestions for table design with huge number of columns [duplicate]

We have a table that consists of a huge number of columns (usually between 500 to 1000, depends on our clients websites). We are suffering from speed issues due to this, and we're looking for the best ...
0
votes
0answers
35 views

MongoDB: Multiple timezone support

In Mongodb how to support multiple timezones? Say every client has his own timezone. I want to group by dates. Records are in different timezones before aggregation. The report should be aggregated ...
0
votes
2answers
247 views

MongoDB document delete and fragmentation

I've a MongoDB collection that works like a queue: new documents are insert and old documents (after 60days) are removed. I can see a rapid grown of the datafile size, too rapid. I can be reasonable ...
0
votes
0answers
58 views

Can we swap out SQL Server with HBase on our .Net application?

In a current application we use SQL Server. The data flow consists of using TVPs for better-than-bulk-insert performance by passing in DataTables. As part of the data addition process, old records ...
0
votes
0answers
18 views

Would a nosql db handle sorting by latitude and longitude queries as well as a mysql db?

I have a table with a couple hundred advertisers including the latitude and longitude of the centroid of their zip code. I will also know the centroid of the zip code of website visitors. What I want ...
0
votes
0answers
127 views

Running out of disk space when removing documents error

I'm trying to remove unused document from a production instance of MongoDB but, when I try to execute this query: db.collection.remove( { date: {$lt: new Date((new Date())-1000*60*60*24*90)} } ) ...
1
vote
1answer
81 views

How to Query Properties of an Entity in Apache Cassandra

I am new to Apache Cassandra, and I would like to know how to create a table in which I can filter rows by non-key columns. In relational databases, I would simply create a table with an ID as a ...
2
votes
1answer
154 views

Google Datastore (NoSQL) backend for PHP CMS

I am working on a personal project where I am creating a small CMS using PHP as the developing language, but I want to be able to deploy it to the Google App Engine and I want to use its Google ...
1
vote
0answers
37 views

Dealing with joins in persistent key-value stores

One promising emerging category of NoSQL databases is key-value stores. These include Redis (disk-backed), Riak, Aerospike and others. The problem I struggle with the most is the lack of joins. ...
1
vote
1answer
47 views

cassandra in memory tables

I am planning to use Cassandra in memory tables for my particular work load. THe problem is I am worried if the node fails then what will happen to the data in memory that was not flushed to disk ? ...
1
vote
0answers
39 views

mongoDB - how to link one embedded object to another embedded object

Background Information I'm trying my hand at my first mongoDB database. So far, I've decided that I will need to use both references and embedded data models. One of the features of this application ...
1
vote
3answers
201 views

Sparse matrix - key-value db?

I have a huge sparse matrix ( 10^9 rows, 10^6 cols, density < 0.03% ), where each row has at least one nonzero column, but some column may contain only zeros. The cells are decimal numbers > 0. I ...
0
votes
1answer
137 views

A good dataset to experiment NoSQL databases [closed]

I need to do some experiments in HBase and Cassandra and to do that I need an adequate dataset. The dataset I'm looking for has to be large enough (i.e. more than 2GB) and the data in it has to be ...
1
vote
1answer
99 views

how to make secondary slave as readable in MongoDB?

How do I make a secondary slave as readable in MongoDB? We can do this via shell command rs.slaveOk() But how we can do it permanently for all session via config file?
1
vote
0answers
94 views

What kind of database is Cassandra DB?

I was taking some courses to understand better the way Cassandra works (at academy.datastax.com) and by what I gathered it came to me that it is a Key Value Database because of the way it stores data ...
0
votes
0answers
41 views

AWS DynamoDB structure and operations for product filtering

I'm having trouble with finding the right pattern to use in a "product" table. The site should be able to sort the products on date and price (asc and desc order). Besides that a user can apply a ...
0
votes
1answer
68 views

updating single row in MYSQL

We have a situation where we need to update on a single row several thousands time a second and this requirement lasts continuously for 5 hours every day due to the nature of the business. Design ...
1
vote
1answer
68 views

MongoLab: Does hardware effect performance of a find() query [closed]

I asked a pervious question on StackOverflow about if document size affected the performance of fetching that document (the document is 3MB in size) ...
0
votes
0answers
51 views

In face of a network partition (P), does Neo4J HA allow read stale data?

In Neo4j docs it says that it is partition tolerant, but in further descriptions their docs does not make clear what happens if a network partition occurs. It enables a fault-tolerant database ...
0
votes
0answers
38 views

Challenged with modeling a big DB

I'm tasked to develop a gaming web application system with relatively large database - it should hold the data about 300 million players, the orders/payment of each player - ~3B records - , and other ...
1
vote
0answers
59 views

Couchbase data modeling

I come from the Relational DB world (SQL), and I'm getting started with NoSQL. So please consider that when answering. I have two Buckets: Apps and Users. A user may be subscribed to N ...
2
votes
1answer
85 views

Is there any database with versioning (column based) built in?

I'm wondering if there is a database (SQL or NOSQL) which provides versioning for for the records ( if the column/field/property is enabled for versioning). I'm developing an authentication software ...
1
vote
0answers
394 views

Creating Pandas DataFrame on Python From a MongoDB Document containing Embedded documents

I am working on a machine learning algorithm on python's scikit.learn, but this time the data are in Mongodb documents format. I would like to pull my data into a dataframe. Here is an exemple of the ...
1
vote
0answers
19 views

Does the consistency part of the CAP theorem apply to updates and not first-time writes?

Using this definition of the CAP theorem: Consistency All database clients see the same data, even with concurrent updates. Availability All database clients are able to access some version ...