Skip to main content

Questions tagged [data]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
37 views

How can I transfer specific filtered data from one database(server1) to another database(server 2) in postgresql?

For Example, I have a PostgreSQL database with multiple schemas and each table under the schemas has one common column like city. I want to transfer the database entry for city like Pune from one ...
akshaycredmango's user avatar
0 votes
0 answers
14 views

Synthetic or derived fact tables

I have a doubt on how to model a situation where the granularity of what we show in the reports does not derive directly from measurements (i.e. classic "facts"), but rather, is ...
user2412218's user avatar
0 votes
1 answer
26 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 ...
user23600793's user avatar
0 votes
0 answers
18 views

SQL: Perform join on multiple tables on Google BigQuery

Please, I am running a professional course in data analytics. Right now, I am on my Capstone project. But I am having challenge combining tables in BigQuery using SQL. The data is about bicycle trips ...
Nduka Charles Jala-Igwe's user avatar
0 votes
0 answers
44 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 ...
Kadir Çolak's user avatar
-2 votes
2 answers
76 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 ...
charu gupta's user avatar
1 vote
0 answers
12 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 ...
Maissa Oueslati's user avatar
0 votes
0 answers
27 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 ...
cricket900's user avatar
1 vote
2 answers
88 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 ...
Cydennn's user avatar
  • 13
0 votes
1 answer
13 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 ...
Ambidex's user avatar
  • 111
0 votes
2 answers
357 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 ...
QueryQuirk's user avatar
1 vote
1 answer
57 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, ...
epm.007's user avatar
  • 29
0 votes
0 answers
26 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 ...
N. Kendrick's user avatar
-1 votes
1 answer
507 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 ...
zddshp's user avatar
  • 1
0 votes
1 answer
31 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 ...
chandra's user avatar
0 votes
1 answer
50 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 ...
miguel ramires's user avatar
3 votes
2 answers
735 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.
Cassandra Thrift's user avatar
0 votes
0 answers
63 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 ...
gioman's user avatar
  • 101
0 votes
0 answers
135 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 ...
Azr.em's user avatar
  • 1
0 votes
1 answer
112 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, ...
kylie's user avatar
  • 39
0 votes
0 answers
187 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 ...
Adeoye Adegboyega p's user avatar
0 votes
0 answers
201 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 ...
Sahil Ummer's user avatar
0 votes
0 answers
24 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, ...
Madhura's user avatar
0 votes
1 answer
573 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 ....
Eli's user avatar
  • 101
0 votes
1 answer
19 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,...
mihiran vikram's user avatar
0 votes
1 answer
3k 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 ...
Kum's user avatar
  • 47
1 vote
1 answer
2k 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 ...
TheRealChx101's user avatar
0 votes
1 answer
49 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 ...
Raf's user avatar
  • 11
5 votes
3 answers
2k 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 ...
Chris McQueen's user avatar
0 votes
0 answers
40 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?
LeoG's user avatar
  • 1
1 vote
1 answer
4k 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 ...
azamat's user avatar
  • 11
2 votes
2 answers
533 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 ...
Sameer Bille's user avatar
1 vote
1 answer
123 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},...
Stench's user avatar
  • 21
1 vote
1 answer
780 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 ...
DFX Nguyễn's user avatar
0 votes
1 answer
451 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 ...
Kravennagen's user avatar
-1 votes
1 answer
729 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 ...
SakZepelin's user avatar
0 votes
2 answers
3k 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 ...
Tessaract's user avatar
  • 167
0 votes
0 answers
257 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 ...
Apricot's user avatar
  • 101
3 votes
1 answer
368 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 ...
Namu N's user avatar
  • 31
0 votes
1 answer
465 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 ...
E.Aigle's user avatar
  • 105
-2 votes
1 answer
438 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 ...
Chase Sarhan's user avatar
1 vote
1 answer
102 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 ...
SQL_NoExpert's user avatar
  • 1,061
1 vote
1 answer
73 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 ...
AlexLaforge's user avatar
0 votes
1 answer
382 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 | | ...
CPSuperstore's user avatar
1 vote
1 answer
5k 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 ...
JConstantine's user avatar
0 votes
1 answer
622 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 ...
Sai Chandra Avushetty's user avatar
0 votes
1 answer
180 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 ...
Marlon's user avatar
  • 1
3 votes
1 answer
672 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?
user1828605's user avatar
0 votes
2 answers
1k 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 ...
user2787096's user avatar
0 votes
1 answer
9k 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 "...
Dave's user avatar
  • 723