Questions tagged [data]
The data tag has no usage guidance.
48
questions
0
votes
1
answer
10
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 ...
- 137
0
votes
0
answers
9
views
Data documentation and planning
I’m trying to find information about data attribute documentation but not by entity. We have 5 or 6 separate products we are simultaneously building that all serve a part of related customer need.
...
2
votes
2
answers
268
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.
- 151
0
votes
0
answers
27
views
Designing a scaleable social photo gallery in Postgres
I’m trying to design a scaleable approach to modeling a social photo gallery and user profiles.
Every profile will have 1 gallery.
My current idea is the following:
Photo table (id, photourl, fKey ...
- 101
0
votes
0
answers
25
views
After moving my PostgreSQL data folder to a new disk, the cluster ownser shows as "unknown"
I moved my PostreSQL cluster data folder to a new disk and after restarting the server I noticed that pg_lsclusters returns "unknown" as the cluster owner rather than "postgres" as ...
- 101
0
votes
0
answers
82
views
Find the I/O cost of the following question?
Estimate the I/O cost of retrieving records from Parts table that contains price less than or equal 1000 rupees. Assume that 15% of tuples satisfy the selection criteria. There are 3300 pages in the ...
- 1
0
votes
0
answers
6
views
Can BigQuery queries get assigned to a different root nodes?
I have been trying to understand the limitations of BigQuery based on how it works under the hood, but it's hard for me to find an answer to the question in the title: Can BigQuery queries get ...
- 101
0
votes
0
answers
6
views
Help with Data input project
I am relatively very new to R so apologies for the redundancy.
I have a file with trade data from Can to USA for a few years. The data shows exact amounts from two points example ( Ontario-Alabama, ...
0
votes
1
answer
34
views
create table based on another table
I have a table called " Product " it has: ID_P, Name, expiration date
Now I want to create another table called "Stock" this table has ID, Quantity_of_the_product, ...
- 41
0
votes
0
answers
54
views
Relationship in ER diagram
I have this ER diagram assignment for a sport club. I have shown different entities. But I have an entity for staff and then I have entities like instructors, admin, managers, coach. I have be to find ...
0
votes
0
answers
83
views
Wide partitions and large number of partitions in Cassandra
0
We are currently facing wide Partitions for certain customers. We have data in Gbs for those partitions. We tried data modelling and partitions always seems to be skewed. We were trying to use ...
- 121
0
votes
0
answers
23
views
Mysql Query need to optimize
I have below query having proper indexes (all columns in where clause), But still query is very slow.
Can anyone help me to optimize this mysql query?
SELECT
centerID,
compID,
...
- 1
0
votes
1
answer
186
views
Exporting FoxPro DBF Files
I am attempting to export data stored by a client's Visual FoxPro database to be used in a MySQL context. The data given is a folder of .dbf, .cdx, and .tbk files, as well as a few .dct, .dcx, and ....
- 101
0
votes
1
answer
14
views
Is it better to add a mostly n/a valued column to a fact table or should a new fact table be created to store the values for this column?
I am creating a data model for Dropbox data warehouse
Business process: a user interacting with the application
Grain:every page event by a user on the application.
Dimensions: files,date,user,page,...
0
votes
1
answer
774
views
Approximately how many reads/writes per secons can MySql/MariaDb tolerate?
I'm running a python script that reads some historical data and inserts it into MariaDb. There's a lot of data and I consider splitting it into parts and running mulitple instances of a script.
But ...
- 47
1
vote
1
answer
662
views
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 ...
- 111
0
votes
1
answer
44
views
Combine output from 3 queries into a single query
I have the following three queries:
SELECT NAME,
ABS(sum(UNITS)) as WK1
FROM products
inner join stockdiary on stockdiary.PRODUCT = products.ID
where SUB_CATEGORY='LB40'
and DATENEW ...
- 11
5
votes
3
answers
1k
views
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 ...
0
votes
0
answers
26
views
Are there a logs to harvest on Oracle Active Data Guard instance?
We are trying to see if there is a way for cloud/SaaS-based( like AirByte or Fivetran) CDC/replicate provider to harvest logs on Oracle active data guard instance.
Any ideas?
- 1
0
votes
1
answer
1k
views
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 ...
- 1
2
votes
2
answers
256
views
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 ...
- 21
1
vote
1
answer
111
views
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},...
- 21
1
vote
1
answer
513
views
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 ...
- 111
0
votes
1
answer
180
views
UPDATE table IF data in another
I would like to retrieve some data from another table and put it in my first table.
I used this query:
UPDATE table_1 SET table_1.firstname =
(
SELECT
firstname
FROM table_2
WHERE ...
0
votes
1
answer
324
views
How to reduce big size database files (Data File ) SQL Server without SHRINK?
I found a couple of 'question' regarding shrinking big datafiles but I think that is not very accurate to my situation. So here is my question
I have a big database with almost 8TB of Data File Size ...
- 13
0
votes
2
answers
2k
views
insert on table being unnaturally slow
I have an "Basic" pricing tier Azure SQL database with a table of 7 columns, an ID column of int that is the clustered index and primary key, one datetime2(0) column, 3 varchar(100) columns ...
- 167
0
votes
0
answers
157
views
Copy postgres data files from a broken server to a new server
I was running a postgres13 on a ec2 instance. This instance got corrupt and I lost the sudo access hence I could not login into postgres any more nor read data in tables.
I created another instance ...
- 101
3
votes
1
answer
264
views
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 ...
- 31
0
votes
1
answer
289
views
What exactly is the datatype input into a DATETIME value in MySQL
I am trying to get data from a PLC directly into a MySQL 8.0 database (using MySQL Workbench). I need to know what data type the input value is for a column set to DATETIME so I can send in the right ...
- 105
-2
votes
1
answer
214
views
Would like to see what Credit Card Numbers have changed [duplicate]
Using the following SELECT Statement, I see all active drivers with a Credit Card Number :
SELECT top 1000 *
FROM cashcard
WHERE crd_status = 'A'
Based on that query, I get a table with a bunch of ...
1
vote
1
answer
76
views
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 ...
- 1,019
1
vote
1
answer
43
views
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 ...
- 121
0
votes
1
answer
214
views
How do I select the total count of records over the past week, including days which have no records in MySQL
Essentially, I need a query which can output something like:
+------------+-------+
| date | count |
+------------+-------+
| 2020-09-30 | 10 |
| 2020-09-29 | 3 |
| 2020-09-28 | 0 |
| ...
- 113
1
vote
1
answer
3k
views
How can I get LOAD DATA LOCAL INFILE to work for MySQL 8.0.21 on a Windows machine? [closed]
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 ...
- 141
0
votes
1
answer
412
views
Data sync between two local Mysql databases in different system in same netwrok
I am using mysql as database for my application and for the purpose of fail over and I need to sync the data from one local mysql database in system one to other local database in system 2 connected ...
0
votes
1
answer
128
views
How to restore MySQL database files without having a MySQL instance?
After a crash of my PC I'm left with several databases (27Gb in total) that are left on my data drive, while my OS drive (Windows 7) is gone.
I've reinstalled the machine by now (Windows 10) and set ...
- 1
3
votes
1
answer
588
views
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?
- 157
0
votes
2
answers
505
views
how to view data as history of field value change
Example
i have data like
id employeeId Salary Year
1 1 12000 2001
1 2 10000 2001
1 1 16000 2002
1 3 12000 2004
1 ...
0
votes
1
answer
6k
views
How do I locate my Postgres data directory while the server is down?
I'm on Mac 10.13.6. I restarted my machine and Postgres, which normally starts upon restart, wasn't running. Sadly, I cannot remember how or where I installed it. I'm able to locate instances of "...
- 605
-1
votes
1
answer
861
views
SUM first consecutive rows only SQL Server
I have the following data:
ROW SEGMENT ORDEN LONG
1 39 11 49.00
2 39 10 102.00
5 39 7 104.00
6 39 6 139.00
7 39 5 97.00
11 39 1 ...
0
votes
1
answer
328
views
What is the safe way to update production data if data found inconsistent
I am in a small company and require to fix a bunch of data in production which are inconsistent. I have written the script to handle the fix.
I understand that writing sql to fix data is way more ...
- 101
-1
votes
2
answers
316
views
Where to find Dummy Data For Oracle Database [closed]
I don't know if the question is relevant, but if someone can give me some info, I'll be very grateful. I have found this website
- here for generating dummy data. I have found some .dump files full of ...
0
votes
1
answer
2k
views
How to fill/insert fake data into a MS Sql Server
I'm trying to test out some configuration settings for an MS Sql Server FILEGROUP and to do this I wish to fill my FILEGROUPdisk up so it will start populating the 2nd FILEGROUP.
I've just created a ...
- 235
0
votes
1
answer
2k
views
'PRIMARY' filegroup is full [closed]
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.
Source: "Microsoft SQL Server Native Client 11.0"
Hresult: 0x80004005 ...
0
votes
1
answer
2k
views
MySQL date range if data not available display 0
I've a table here here is the structure : id,id_berita,ip_user,tanggal
I try to use this query :
select count(id) as jumlah,tanggal from tb_trafik_berita WHERE (tanggal BETWEEN '2020-01-02 00:00:00'...
- 1
-1
votes
1
answer
65
views
What is the correct way to join this tables? [closed]
what is the correc way to join this tables?
Party, person and organization:
Tables
Party: id, party_type (person/organization)
Person: party_id, name, etc
Organization: party_id, name, etc
Other ...
0
votes
1
answer
30
views
Using WHERE / AND in Joins
Can someone elaborate on how the following two queries would provide different results?
That is, how the query is processed differently using WHERE or AND.
select
orders.*,
accounts.*
from
...
- 1
0
votes
1
answer
1k
views
Unpivot in MYSQL?
Please I need help on how I can transform the data that appears in the attached photo. Maybe Unpivot SQL?
