Questions tagged [data]
The data tag has no summary.
57 questions
-1
votes
1
answer
66
views
How to identify the type of database file from a data dump?
I have a file that I suspect is a database, but I don't know what kind of database it is (SQLite, Postgres, etc.). How can I infer test if it's a database, and if so, what kind of database it is?
If ...
- 2,093
0
votes
1
answer
50
views
How to implement historical data with this EERD?
I am looking for a way to implement historical data with the following EERD (what I have tried, below the image):
What have I tried?
Temporal tables
Didn't work because I use MySQL and it has no ...
0
votes
0
answers
49
views
copying data from database with the same skeleton
I have a database design with the same tables, procedures and all other details on two different servers. Since one of them ran out of traffic, I forwarded the web software project to the other one.
I ...
-2
votes
2
answers
125
views
Insert data from one table to another
I have a table in which new entries come in every second. The table is just like this:
value1
data1
Value2
data2
1
Er
2
Er
3
Er
4
Er
Now insert these value in other table as
Value
data
1
Er
2
Er
3
Er
...
1
vote
0
answers
36
views
Power Pivot/Data model issue
Good day,
I am facing two blocking points where I would need your insights please.
I have downloaded all my sheets in power query and made the necessary transformations, including creating a common ...
0
votes
0
answers
55
views
Seeking Clarity on Calculating Tuples in Slotted Page Array with Unspanned Organization
I'm currently grappling with a database administration question and would greatly appreciate some guidance. Here's the scenario: I'm working with a slotted page array organized under the unspanned ...
- 129
1
vote
2
answers
321
views
Should a frequently-growing log file be stored as a table or a blob in the database?
I'm an undergrad and haven't worked with any actually database yet so my apologies if I misunderstand/misuse any terms. My question comes from an assignment of mine, but this is my attempt at learning ...
- 13
0
votes
1
answer
21
views
Correct way of storing the "reach profile" of an object
We've got to store information about a diversity of mechanical "arms" that have a certain reach profile. We need to store the information about what kind of reach profile the arm has. Since ...
- 111
0
votes
2
answers
576
views
Compare two tables for discrepencies
I am trying to compare two tables in two separate databases (same instance)
for a new data extract
The tables have around 4 millions rows and due to how they've been extracted are not in the same ...
1
vote
1
answer
99
views
MySql count using and still show all data even using where clause
Good Afternoon,
How i can show all data when using count and where clause in MySql.
In my case, I have master data like pict at below.
and i using this query to show count the data.
SELECT body,
...
- 29
0
votes
0
answers
45
views
Two Database Instances, need to share table data
Background
Two sites, both WordPress; one is public-facing, and the second is private with restrictive access.
The public-facing site has a form on it, but I need to be able to access the information ...
-1
votes
1
answer
846
views
Aborted mysql connection no one can solve - need a true expert
I have had several high level db admins look at my issue here and not a single one knows what the issue is.
I am constantly getting mysql error log spammed with
[Warning] Aborted connection 1650610 to ...
- 1
0
votes
1
answer
38
views
Query on table A to find the number of overlapping jobs for each job
Table A:
job
start_time
end_time
A
1:30
2:30
B
1:45
2:15
C
2:45
3:45
D
0:50
2:50
Table B:
job
start_time
end_time
A
1:30
2:30
B
1:45
2:15
C
2:45
3:45
D
0:50
2:50
Sample output:
job
start_time
end_time
...
- 9
0
votes
1
answer
117
views
Does the order in which vms are shutdown impact the postgresql replication environment?
I have the following environment:
A postgres server (rhel8, postgresql v14) as master and another as standby.
I need to do a maintenance task on the infrastructure and for this reason both vms need to ...
- 169
3
votes
2
answers
1k
views
Data retention in Mariadb
I want to retain data for 90 days only for all 15 tables in my Mariadb database.
Current db size is 60 GB.
What are the options available for performing the same.
- 307