Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: dimensional-modeling

Is my understanding of Fact table granularity correct?

By adminPosted on December 8, 2022

Question : Myself and another DBA at our company are tasked with reviewing a database design that a vendor has […]

Designing a dimensional DB off a normalized source that already implements SCD’s

By adminPosted on December 7, 2022

Question : I have built an SSIS ETL to integrate various data sources (one from MySQL, two from SQL Server) […]

what is the difference between ‘order’ and ‘order line’?

By adminPosted on November 5, 2022

Question : I was trying to understand degenerate dimensions. But I quite often encounters the term “order line” as grain […]

To normalize or not to normalize for few distinct values

By adminPosted on October 1, 2022

Question : Assuming in a Postgres database, you have a table called party, which can have less than 5 well-defined […]

Should I create a Factless Fact Table or Denormalise my table

By adminPosted on September 22, 2022

Question : I am creating a data warehouse from a store database and I have a question regarding the design […]

How to optimally structure a table with sparse data

By adminPosted on August 29, 2022

Question : I am working on a project to create a series of tables that are easier to use and […]

Connecting dimension tables in a multi-fact star schema database warehouse?

By adminPosted on June 12, 2022

Question : I am new to data warehouse modelling so please bear with me. In database warehouse modelling, the star […]

Transactional versus Dimensional model for file upload web application — preferred approach?

By adminPosted on May 11, 2022

Question : For a web application whose sole purpose is to allow users to upload raw file data at any […]

Database model / design best practice

By adminPosted on January 11, 2022

Question : I’m looking for a some guidance/advice on how to best model my data. Some background: I have location […]

What is the meaning of “dimension key”?

By adminPosted on December 3, 2021

Question : I am a beginner trying to understand the basic concepts of database’s. I know several types of keys […]

  • 1
  • 2
  • 3

Recent Posts

  • Help me define the tables in this scenario
  • Convert seconds into HH:MM:SS format in MySQL
  • Guaranteeing a FK relationship through multiple tables
  • Is it Possible to Recover Data from a BLACKHOLE table? [closed]
  • MySQL: sysbench test – InnoDB vs Memory tables
  • Why are virtual log files not always allocated in order?
  • Need help to understand how information_schema.TABLES get updated
  • unique constraint on a set
  • PostgreSQL, integer arrays, index for equality
  • What is the most performant way to group by and join high cardinality columns in column based table?
  • LOAD DATA (400k rows) INFILE takes about 7 minutes, cannot kill the “logging slow query” process?
  • Is a process created in Oracle for every SQL statement?
  • How to select a row based on the maximum value of a column, when ties are expected
  • I am unable to join tables in correct manner
  • How often to backup database and what are the favoroble practices to do so [closed]
  • In Postgresql, after pg_dump the access privileges on the database itself are not restored
  • InnoDB Buffer pool not showing as much I configured in MariaDB 10.5
  • Which version of SQL Server 2016 supports R
  • Design DB for users with different information fields?
  • WSREP: Writeset deserialization failed: Unsupported RecordSet version: 2: 71 (Protocol error)

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding