Questions tagged [data]
57 questions
5
votes
3 answers
SQL Database vs Multiple Microsoft Access Databases
The company I work for produces a lot of test data in raw text files from lots of different devices. Each device belongs to a 'process' of which there are only a few dozen. Currently we have a program which takes this data and produces/adds to an…
Chris McQueen
- 67
- 3
3
votes
2 answers
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.
Cassandra Thrift
- 307
- 1
- 7
3
votes
1 answer
MySQL importing csv file by Data import wizard
I tried importing a CSV file in MySQL via the data import wizard.
My CSV file has 70,000 records but only 61 are imported.
I tried checking the CSV file, recreating the file from source, and changing the location of the CSV file, but nothing…
Namu N
- 31
- 1
3
votes
1 answer
How is data lake and polyglot persistence different?
I just came across a new technology called polyglot persistence. However, it sounds very much like a data lake. So, how are these two things different?
user1828605
- 157
- 3
2
votes
2 answers
Post migration MySQL database validation
We are migrating from 5.5 enterprise mysql to 8.0 mysql enterprise edition. And we are migrating version by version like from 5.5 to 5.6 then 5.6 to 5.7 and lastly from 5.7 to 8.0 also os migration is there from the rhel5. 4 to 8.4 it's all okay…
Sameer Bille
- 21
- 2
1
vote
0 answers
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 Column ID on each sheet based on a project number…
Maissa Oueslati
- 11
- 1
1
vote
2 answers
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 and not having my homework done for me.
The…
Cydennn
- 13
- 2
1
vote
1 answer
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,
count(body)
from tb_list_data
WHERE type…
epm.007
- 29
- 5
1
vote
1 answer
How to recover Postgresq data from $PGDATA/base files after system crash
I was working on my Ubuntu machine and left it on to grab food. Upon returning, I found it had shut itself down. It was not power failture because I have a home backup system and lights never go off in my house.
When I turned it on, it went straight…
TheRealChx101
- 121
- 6
1
vote
1 answer
How to grant read-write access to a user within the whole database cluster?
I got a database cluster with 1300 databases. I created a role and a user and granted access using the command GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO myuser, so myuser is able to run queries in one particular…
azamat
- 11
- 1
- 3
1
vote
1 answer
normalisation in DBMS
For the relation schema R(A, B, C, D, E) with the following FDs
FD1: {A,B,C} → {D,E}
FD2: {B,C,D} → {A,E}
FD3: {C} → {D}
I Decomposed R into a set of BCNF relations.
I got candidate keys as {A,B,C}, {B,C,D} respectively.. how do I find the subset…
Stench
- 21
- 3
1
vote
1 answer
How can I arrange database structure for ranking card in a list in a Kanban Board?
thank you for helping me.
I got a problem when I design my database structure for kanban board application.
How can I design kanban board to rank card in a list for sorting,drag and drop,..
Currently this is my design
1. cards table
-id…
DFX Nguyễn
- 111
- 1
1
vote
1 answer
Pointing the database secondary data file towards a network drive
I have a 2 TB database and the Data Drive has filled up. My network team cannot expand the drive nor provide another drive so that the secondary data file can be pointed towards that. My question is can the secondary drive be pointed towards a…
SQL_NoExpert
- 1,107
- 1
- 21
- 37
1
vote
1 answer
How to search for multiple synonyms?
I have a database with 2 tables : products, and synonyms.
When a user type one or several words to search in the products.description field, I would like to search for all the synonyms/substitutions as well.
The synonyms table is basic, and have to…
AlexLaforge
- 151
- 6
1
vote
1 answer
How can I get LOAD DATA LOCAL INFILE to work for MySQL 8.0.21 on a Windows machine?
I've created a file: 'C:\fff.txt' which contains data for my database table.
Then I'm trying to load data from that file like this:
LOAD DATA LOCAL INFILE 'C:\\fff.txt' INTO TABLE fff
LINES TERMINATED BY '\r\n';
but I get the following error all…
JConstantine
- 141
- 1
- 8