All Questions
22
questions
0
votes
0
answers
102
views
Best solution for storing 10,000,000+ lines of json objects which needs to be checked (new data inserted) daily
I have a big zip file which contains around 10,000,000+ lines of json objects. Every day I receive a new zip file which contains mostly exactly the same data but some of it (maybe around 2%) is ...
-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
vote
1
answer
195
views
Couchbase n1q1 query to fetch map's specific key
Below is the couchbase doc
`
{
"docId": "1111212",
"user": {
"id": "5050017",
"name": "string",
"type"...
1
vote
1
answer
135
views
How to get a table name inside a pg query with json?
I'm trying to get a json with a table name inside with a row, I've trying:
Create a table:
create table if not exists customer (
_id serial,
first_name varchar(50),
constraint pk_customer ...
1
vote
2
answers
2k
views
Filtering a Snowflake SQL SELECT statement
I'm trying to find a good maybe subquery strategy to select a value within a document by matching another value, with multiple documents. I can execute a query, but not in a scalable methodology for ...
1
vote
1
answer
565
views
How to achieve generic Audit.NET json data processing?
I am using Audit.Net library to log EntityFramework actions into a database (currently everything into one AuditEventLogs table, where the JsonData column stores the data in the following Json format:
...
-1
votes
1
answer
71
views
How do I translate MongoDb query from SQL to NoSQL
How do I write this SQL command in NoSQL
SELECT regionname from Worldbank;
0
votes
0
answers
54
views
SQL JSON NULL VALUES
I need to convert the result of the query to a JSON. My query is:
**select TABLE2.Id [TABLE2.Id],
TABLE4.Id [TABLE4_Record.Id],
TABLE4.Name as [TABLE4_Record.Name]
from TABLE2
left join ...
2
votes
1
answer
277
views
Doesn't NoSQL databases work the same as an SQL Table with serialized objects in it?
If I just store serialized JSON strings of objects in an SQL database table... does that turn it into a NoSQL database?
1
vote
2
answers
74
views
Extract value from one table if their values match the 2nd table
Background:
I have two tables within a CosmosDB database that hold key:value documents within their containers.
T1 and T2
T1
Id: 111
ems_featurecategory: 1234
ems_name: "win"
T2
...
1
vote
2
answers
300
views
These days SQL databases can store JSON. Then why do we need NoSQL?
One of the advantages of NoSQL databases is to handle unstructured data. Since that issue is now resolved in SQL databases, is there any need left for NoSQL? Only advantage that I can think of is ...
1
vote
1
answer
131
views
DataModel in NoSQL from multiple SQL tables
I have a database which look like this uploaded on a SQL Server :
And this specific scenario :
The airport web page allows viewers to see details of an airport
together with the city that it ...
2
votes
0
answers
766
views
Store and query extremely large amount of JSON data
Context:
300000 lines of JSON data are generated approximately every five seconds by a game's remote public API. This data disappears immediately after the next update and is never accessible again. ...
2
votes
1
answer
3k
views
Query JSON Attributes from JSON-formatted Column in Database
here is the problem I am facing
I have a table called GAMELOG (well, could be SQL Table or NoSQL column family), that looks like this :
ID INT,
REQUESTDATE DATE,
REQUESTMESSAGE VARCHAR,
RESPONSEDATE ...
0
votes
1
answer
185
views
PostgreSQL Query n Manipulate JSON data
I have problem with update jsonb type in postgree,
this is my example json
{
"total": 2,
"products":[
{"name": "guitar", "price": 100000, "brand": "yamaha"},
{"name": "guitar", "...