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
55 views

AS/400 + DB2 to MongoDB?

I'm not seeing a whole lot of info on the subject, so I figured I'd ask people who might know more about it than I do: Is it possible to replicate data from an AS/400 + IBM DB2 instance to MongoDB? If ...
3
votes
0answers
383 views

Are there any known benchmarks/statistics on UnQLite?

I came across UnQLite the other day in Stack Overflow and it has me intrigued for some software I'm working on. However, very few tests have been published on how well it performs. There are plenty of ...
2
votes
0answers
38 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 ...
2
votes
0answers
130 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 ...
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, ...
2
votes
0answers
287 views

Strugling with updating a cassandra row in FluentCassandra

I have this problem with using Fluent Cassandra in a test application. All I want to do is set the IsOnline field to true inside the SignIn method, but I keep getting the exception supercolumn ...
1
vote
0answers
20 views

What are the implications of using quite large partitions (rows) in Cassandra?

I am looking to store data in Cassandra, due to the fact that I have many writes that need to perform well, and all my reads can be done based on primary key. While doing the data modeling, however, I ...
1
vote
0answers
31 views

Solr with SQL Server or NoSQL

I am working on a POC of using Solr with SQL Server. I have a very complex data model with SQL server which required a bunch of joining and scalar functions to strip some mark up and other stuff. ...
1
vote
0answers
43 views

Would it be good practice to represent MongoDB ObjectId as a String or a Blob type in SQL Lite (RDMS world)?

All: We have a software application with 1) Web-based component 2) Mobile-based component Our 1) Web-based component uses a) MongoDB as the Database b) ASP.NET C# Our 2) Mobile-based component ...
1
vote
0answers
47 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
0answers
39 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" : 1....
1
vote
0answers
36 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
32 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 a ...
1
vote
0answers
38 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
0answers
40 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
0answers
137 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 ...
1
vote
0answers
74 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 applications,...
1
vote
0answers
667 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
20 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 ...
1
vote
0answers
177 views

Can we query Accumulo data from Apache Drill

Accumulo uses HDFS where as HBase also works on top of HDFS. We can query HBase data through Drill. So can we query Accumulo data also from Apache Drill ?
1
vote
0answers
56 views

Mongodb schema design validation

I am building an app which allows users to do some "tasks" to earn points. The "tasks" are part of a "campaign" which themselves are a part of "brands". I am confused about the schema for storing the ...
1
vote
0answers
126 views

Good way to store daily train data in MongoDB

I am preparing to collect large amounts of information about trains in my country. Each train in my country has a number. I've already collected all of these numbers. There are about 4000 of them. ...
1
vote
0answers
84 views

Nosql multiple database design to handle sharing scenarios

This question is regarding design of a database in mongodb. The scenario: A user has a drive which he can share with others. Drive has two categories: docs and others. The user has three choices in ...
1
vote
0answers
331 views

How Do I Get DB2 NoSQL User-Defined Functions to Work

I am using NoSQL in DB2 10.5 FP4. I am creating and connecting to the database with the 'db2admin' administrator user ID on my Windows machine. I also used the 'db2 attach to DB2_01 as db2admin' ...
1
vote
0answers
86 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 ...
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 ...
1
vote
0answers
143 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 ...
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 (...
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 ...
0
votes
0answers
13 views

Design: Available domain database

I'm building website and service that will allow user to check if given domain is available. Right now I'm thinking about good way to store result from whois, but i dont want to store whole response ...
0
votes
0answers
18 views

How to store non-numeric data for a numeric field

I am looking for an SQL or NOSQL solution for the following problem: In a MySQL database (which I have no control over), I have some numeric fields in which numeric data is stored. But for some ...
0
votes
0answers
39 views

Postgres hstore or jsonb to store many to many relations

There is a table 'Products' with columns (id, tile, price, description, shop_id, timestamps) Column price and shop_id are dynamic. The rest of column are static. Also there is a table 'Shops' with ...
0
votes
0answers
30 views

Using both NoSQL and SQL in a Project

I am working on a project and would like some advice on my data structure for my backend. Currently I am writing a SaaS Multi-Tenant application hosted in Azure for customers who use the same legacy ...
0
votes
0answers
75 views

Which NoSQL Database is best suited?

I have been reading a lot of blogs trying to determine which NoSQL database would be best. I am looking at moving from file based (xml) storage to using a database. The application will be storing ...
0
votes
0answers
32 views

Mongodb database design

I'm planning to implement this schema in Mongodb, I have been doing some readings about schema design, and the notion was whenever you structure your data like a relational database you must be doing ...
0
votes
0answers
20 views

Product Features table for No Sql Databse

I want to design database to save products features. Actually i want to store all features of mobile given on this link http://www.gsmarena.com/samsung_galaxy_j7-7185.php After search on google i ...
0
votes
0answers
26 views

Cassandra filtering multiple items

I am attempting to learn Cassandra by taking my RDBMS database and create a nosql version of it. Forgive any mistakes I am just making a quick example so I can ask my question. Here is my example(...
0
votes
0answers
162 views

mongod.exe has stopped working

I have installed mongoDB 3.2.4 and I am on windows 7 64-bit system. After installation of mongoDB , i have specified dbpath as c:\data and also set the environment variable. Now whenever I am trying ...
0
votes
0answers
7 views

pattern matching on row attributes

I have the following: there are dozens of millions of records on the following format a1 a2 a3 ..... a10 where ai are float values of some attributes. I would like to store these records in a db ...
0
votes
0answers
54 views

How to add an index to attributes sorted on in mongodb

Before you find another reason for changing the category of this question, it was on Stack Overflow and it was described as a DB Admin question, so here goes: I am running a reporting app with ...
0
votes
0answers
23 views

Is it viable to connect RethinkDB to mssql server

I'm adapting a nodejs project for a client. This project uses RethinkDB as it's database server, obviously NoSQL, it serializes data from Android systems, such as state, battery life, software ...
0
votes
0answers
16 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
0answers
36 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
0answers
226 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. ...
0
votes
0answers
90 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
0answers
49 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
0answers
85 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
25 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
263 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)} } ) ...