Questions tagged [data]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-2 votes
0 answers
8 views

Data Validation in databricks

I have created a table(1st) and loaded data from another table(2nd) in databricks using merge statement. But after loading, some rows are missing in the 1st table which are there in 2nd table. So can ...
Dibyarup Dhar's user avatar
0 votes
0 answers
41 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
64 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
8 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
20 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
72 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
12 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
184 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
54 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
25 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
0 votes
0 answers
8 views

Using Stitch to import data to Postgres database, not all selected fields are being replicated

Has anyone has trouble with replicating tables/fields from the service Stitch? I've used this for various data sources in the past and I'm currently having issues with the platform Kustomer. The ...
N. Marchetti's user avatar
-1 votes
1 answer
297 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
29 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
35 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
0 votes
0 answers
12 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. ...
Jason Hegarty's user avatar
3 votes
2 answers
568 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
48 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 ...
Giovanni Manghi's user avatar
0 votes
0 answers
118 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
94 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
  • 41
0 votes
0 answers
138 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
186 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
476 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
17 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
2k 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
1k 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
46 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
36 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
3k 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
451 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
121 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
699 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
406 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
0 votes
1 answer
610 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
234 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
335 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
410 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
368 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
97 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,049
1 vote
1 answer
67 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
372 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
4k 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
548 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
153 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
636 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
829 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
8k 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
  • 663
-1 votes
1 answer
1k 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 ...
FacundoInsua's user avatar