All Questions
20
questions
-1
votes
1
answer
83
views
Querying JSON key with values as JSON in SQL Server
I have these JSON:
Application 1:
{
"business_industry": "Agriculture",
"docs": [
{
"internal": false,
"type": "Asset & ...
-1
votes
1
answer
138
views
Draw ERD for a project using SQL + NoSQL databases [closed]
For my graduation project, I need to draw a ERD to combine 2 databases,
SQL for authentication and NoSQL for other data like articles and posts and tasks.
How can I specifically display relationships ...
0
votes
3
answers
111
views
Adequate database structure for mixed data
I have to create a database for sensor measurements. I have scalar data like date, serial number, firmware version, etc., but I also have array data, basically sensor data in the form of a 1000-...
-2
votes
1
answer
67
views
Store this data model as non-relational?
I am currently in a situation where I think of redesigning one of my classic relational database tables into a non-relational design and I am not sure if I should do it or not. Reason is that ...
10
votes
1
answer
2k
views
Is SQL Server support for JSON a replacement for NoSql solutions like MongoDB?
After many years working with SQL databases, it feels unconformable working with a database that doesn't rely on a schema to model the data.
I understand that SQL and NoSQL solutions have their ...
0
votes
2
answers
382
views
SQL a table for each metadata of other tables
Hi I have various time series each having a unique timeseries ID. Given an ID, the series look something like this (obviously with different dates and data respetively)
datetime data
1/1/1980 ...
-2
votes
2
answers
602
views
Are NOSQL database usefull for million rows [closed]
I have a table with more than 500 million rows and around 30 columns.
I need to do select by different columns.
I am just using SQL Server but the performance is not so good, can any NOSQL database ...
0
votes
1
answer
859
views
Storing dynamically generated grids in a database
I am having some issues trying to come up with the best way to store dynamically generated grids in a database. My current scenario is that I have 2 user roles, to simplify we'll just call them an ...
1
vote
1
answer
2k
views
Sync NoSQL with SQL
Is there a way to sync NoSQL and SQL databases?
My problem is: We have a software that uses MSSQL. We also have a mobile application that uses MongoDB. We want to sync data (on create/update) between ...
0
votes
1
answer
32
views
MongoDB - Load a subset of documents for querying
I have a collection containing multiple clients, months, etc.
Each month I need to run a series of queries against the collection to retrieve metrics - basically a bunch of counts.
Most of those ...
0
votes
1
answer
98
views
Clarification on multiple join syntax SQL/NoSQL
I am studying NoSQL databases, and came across a situation which shows the complexity of storing connected data in relational databases. Here's the table structure:
The two queries are:
Who are Bob'...
4
votes
3
answers
1k
views
Should I move to NoSQL? (big data)
I'm currently researching a very large table (~100 million rows, 35 columns), it's currently stored in SQL db, but the queries I'm running (and they're various) run very, very slow..
so I get it I ...
0
votes
1
answer
55
views
Blob database, extremely dynamic database
I am helping one of my professors out by doing a special course where I am to create a piece of software for him. But due to the nature of being a student, can my professor not count on me being there ...
6
votes
2
answers
3k
views
Database design for items with variable attributes? [closed]
I'm creating an application that will need to store items and categories. The information added to the database will be user submitted and the user can add items and in the future categories for items....
11
votes
2
answers
4k
views
SQL and NoSQL Analogy for the Non-Technical [closed]
I am working with a third client that will be using both a SQL and NoSQL solution (often SQL Server and Mongo). The last two clients I worked with understood a great deal of technical information, so ...