All Questions
710
questions
0
votes
1
answer
54
views
How to create the following data structure in an SQL environment
I have a FireStore database and I need to convert it to SQL. My SeminarsAndTraining document looks like this:
{
"st_name": "SOL Level 1",
"attendance": [
{"...
0
votes
1
answer
123
views
What sql engine is best in terms of low db size?
I have a script that gathers some data every 5 mins and stores it directly into a sqlite table using pandas to_sql function. So far it gathered around 300k rows and the table size already exceeds 30 ...
0
votes
1
answer
34
views
How to extract customer and products ordered statistics in web site with python
To get the statistical behavior of buyers and visitors to a store site and process the numbers obtained from the number of visits, number of purchases and other similar items regardless of what ...
0
votes
1
answer
27
views
How to optimize this query in mongodb?
I have a query like below in MongoDB.
a = xml_db.find(
{
'crawl_id': crawl_id,
'low_performer': { '$nin': [source] }
}
).hint('crawl_id_low_performer_index')
print(a.count())
...
0
votes
1
answer
33
views
Which database should I use to store in real time my exact location from an Android application and then display it in my website (tracking system)?
I'm kind of new at backend development, and I should to create a website (tracking) display the location of my phone, this location I have to retrieve from an android application.
My question is which ...
2
votes
1
answer
174
views
In MongoDB, what is the purpose of embedded documents if the same thing can be achieved without using them?
For example
Instead of a field named, COLUMN_1, that holds an embedded document with fields A, B, and C.
Why not 3 separate fields with names COLUMN_1_A, COLUMN_1_B, COLUMN_1_C.
0
votes
1
answer
84
views
Query free booking based on time window and duration from MONGODB
I have the following problem for which I am looking for a solution.
I have a table in my database with the following structure:
id
Date
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
1
2022-02-01
0
...
-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 ...
3
votes
1
answer
134
views
How to sort vertices according to edge types OrientDb?
I'm quite new to OrientDb and I'm trying to figure out how to sort vertices according to a more complex schema than I am accustomed to...
In my (simplified for StackOverflow) database, I have a bunch ...
2
votes
1
answer
2k
views
What is the industry standard way to store country / state / city in a database of web APP?
For country and state, there are ISO numbers. With City, there is not.
Method 1:
Store in one column:
[Country ISO]-[State ISO]-[City Name]
Method 2:
Store in 3 separate columns.
Also, how to handle ...
0
votes
1
answer
46
views
How to optimize large database query accessed with an item ID?
I'm making a site that stores a large amount of data (8 data points for 313 item_ids every 10 seconds over 24 hr) and I serve that data to users on demand. The request is supplied with an item ID with ...
0
votes
1
answer
441
views
what are the options to store small amount of data that needs to be queried frequently in an asp.net core app
I'm currently working on a project that needs to store data of about 5 to 10 entities and at most 5000 records for each of them.
I was thinking about using mysql or postgres or even mongodb but all of ...
-1
votes
1
answer
22
views
How does MongoDB keep a numeric column, which is indexed, always sorted if the column is constantly updated?
What happens after an update to this column is made? What does MongoDB do? What is the time-complexity to keep this column sorted after each update?
0
votes
0
answers
125
views
In MongoDB, What is the time complexity of this query?
There is a table of M rows, with a column which records the date and time the row was updated and a numeric column to record the SCORE of this row.
QUERY:
Find the X most recently updated rows and ...
0
votes
1
answer
807
views
Is the time complexity of querying an indexed column O(1)?
Let's suppose that table A has a column named X which is numeric and indexed.
If the query is something like:
find all rows where X is greater than some value
Is the time complexity of retrieving the ...