All Questions
710
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 & ...
- 2,710
1
vote
2
answers
2k
views
The best choice for database for large datasets [closed]
I'm about to start a new project which should have a rather large database.
the records have roughly up to 10 fields , these datas will have following specifications :
Only insert and read records ...
- 1,429
0
votes
1
answer
73
views
what is the best way to store alerts where many users may subscribe to an alert?
I have a system which responds to different types of events:
Type1 events
Type2 events
Type3 events
...
The purpose of the system is to give users alerts for the types they subscribe to.
I also have ...
- 139
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"...
- 901
0
votes
0
answers
27
views
If ObjectId is stored in _id field, is there any reason to still have a timestamp field?
THe ObjectId captures the date and time the document is created. So what reason is there to still have the timestamp field?
0
votes
1
answer
86
views
Should I use NoSQL for a project management app like Citrix Podio?
I'm thinking about developing an app similar to Podio, where you can create different "Apps" with personalized fields. I understand that this couldn't work on a SQL database because the ...
- 59
0
votes
1
answer
578
views
Use of secondary indexes in a redis database in comparison with SQL statements
I'm working with a redis database. I have already implemented Python code to access the redis server. The problem is that the code implemented is complex and not easy maintainable.
Secondary indexes ...
- 2,076
0
votes
1
answer
361
views
Designing relations in Microservices architecture
I am new in microservices architecture and I am a bit confused about designing relations between data of each Microservice. So I think about design as its on picture bellow:
So my question is:
Is it ...
- 53
0
votes
1
answer
121
views
2 different not shared databases for the same microservice good approach?
Context:
Microservices architecture, DDD, CQRS, Event driven.
SQL database.
I have an use case, where I have to store a record when a entity state is updated. I'm afraid that the quantity of records ...
- 39
1
vote
1
answer
69
views
Architecture for a large number of entries with many columns searchable by range
The database consists of one main table with one million entries each with approximately 100 fields.
Most fields are numeric and searching will be by ranges, not exact values.
It will be possible to ...
- 351
0
votes
0
answers
238
views
How to retrieve jsonb data from db using spring jpa?
When interacting directly with a sql db (that contain a jsonb column), the query required is:
SELECT stuff FROM alerts WHERE id = '12345'
AND (stuff->'action'->>'actionId' = '123')
ORDER BY (...
- 217
1
vote
0
answers
148
views
DynamoDB Modelling: Find all entities that match search term against various entity attributes
I am new to DynamoDB and the world of NoSQL in general, and although I have purchased and read Alex DeBrie's DynamoDB book, I still couldn't figure this out.
Scenario:
I want to build an app with one ...
- 15k
0
votes
1
answer
343
views
dynamodb composite primary key design with multiple attributes
I am trying to design a dynamodb table to store data, in which multiple attributes constitutes as unique key. In this case how do I design a DynamoDBHashKey/primary key?
Currently I am thinking of ...
- 437
0
votes
1
answer
72
views
Database for substring search
This is not full text search!
I have approximately 1 billion of rows, the core column is a string with medium length of 13 chars and I want to search with a substring as filter in any positions (left,...
- 1
-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 ...
