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
3answers
281 views

Working NoSQL scheme for a betting app

I'm building an app where a user can bet on the result of a sports game. Basically, we feed the database with competitions and games, and the users can place their bet in the form of a score ...
0
votes
1answer
3k 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 ...
1
vote
1answer
34 views

NoSQL : Getting latest item from DynamoDB table

I'm implementing chat server currently, with dynamoDB. Here is keys from ChatData table Primary partition key : roomNo Primary sort key : seq Chat server, can created many instant rooms, ...
62
votes
6answers
29k 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 ...
5
votes
2answers
134 views

MongoDB vs RDBMS DBA duties

What are the differences between the daily tasks/duties of a Mongo DBA compared to a RDBMS DBA? For example, some sites claim that a MongoDB DBA would not require to do data modelling or designing ...
1
vote
3answers
47 views

What is considered as a document in mongoDB?

I have been learning MongoDB for the past two days and I've been confused with documents and their limits, and how to overcome the limits. What is a difference between documents and collection?
0
votes
0answers
52 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
28 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
12 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 ...
1
vote
1answer
16 views

couchbase - multiple buckets or documents with different types

Background Information This is day one for me with couchbase. I've been reviewing the sample databases using the database console that comes with couchbase. Specifically, I've been playing with the ...
0
votes
0answers
23 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 ...
1
vote
0answers
23 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. ...
3
votes
3answers
2k views

Relational vs Non-Relational Database for Events Database

I'm trying to find out whether an SQL or no-SQL solution would be better for creating an events database. I'm creating a ticketing system, similar to ticket master. I know that for either ...
2
votes
1answer
872 views

UTF8 vs ASCII or custom binary format: high-performance optimization on very big tables

The summary of my question is whether there are advantages, even if minimal, to use ASCII, or even a smaller format designed yet created specifically for the situation, instead of UTF-8 for strings. ...
1
vote
0answers
31 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
1answer
90 views

How to efficiently design MongoDB database for Uber-like application?

I'm designing a MongoDB database for an Uber-like application, but since I'm new to NoSQL concept, I have several doubts. I have three main collections - users, requests and messages. User can post a ...
0
votes
0answers
77 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
6 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
1answer
14 views
3
votes
0answers
39 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 ...
0
votes
2answers
164 views

Strategies to import big data into Oracle

What strategies are available to import about 500 million small transactions every day from an external system? Oracle becomes very slow with very frequent commits. The transfer process which is ...
0
votes
1answer
95 views

ReplicaSet MongoDB

I'am trying to create replcaSet in MongoDB and I'am facing a problem. This is what I did step by step: 1- I entered this command to create these repertories: mkdir \data\rs1 \data\rs2 \data\rs3 ...
0
votes
0answers
34 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
1answer
140 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 ...
0
votes
0answers
19 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
2answers
286 views

SQL Server vs SOLR (Or any document db)

I have my "customer" data in a normalized sql server database. Getting out the customer data in my app is taking too long. This is because I have to go to 10+ tables to get all the data I need. My ...
3
votes
1answer
61 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 ...
2
votes
0answers
26 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
78 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
57 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
15 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
67 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
37 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
40 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 ...
2
votes
1answer
196 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 ...
1
vote
1answer
30 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 ...
1
vote
1answer
559 views

Use cases for NoSQL databases: Time series

I need to set up a database that will record temporal series data (sensors). A friend of mine has recommended me to use a NoSQL database instead of using Oracle (for instance). There're also some ...
1
vote
2answers
382 views

MongoDB service not starting on RedHat - missing 'service_uri'

I'm on a Red Hat Enterprise Linux Client release 5.4 (Tikanga) machine I created my /etc/yum.repos.d/10gen.repo like this: [10gen] name=10gen Repository ...
0
votes
0answers
30 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
86 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
36 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" : ...
2
votes
2answers
10k 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.
0
votes
1answer
106 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
1answer
51 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
55 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
3answers
335 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 ...
1
vote
2answers
86 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 ...
4
votes
2answers
2k views

DynamoDB: searching with primary key or range key, which way is faster?

To those familiar with DynamoDB, I'm trying to make a table where items only have 2 entries. For example, . Most of the time I'll be searching the user_id with a facebook_id on hand. Amazon's ...
0
votes
0answers
170 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. ...
8
votes
2answers
1k views

What fillfactor for caching table?

I have heavily updated / accessed table where I store serialized java objects. They are in the table for 2-3 hours (also are being updated during that period) and then removed. Size of table is around ...