what's the name for this type of table used in the following way?

Question

what's the name for this type of table used in the following way?

sqlguy-736318

Hall of Fame

Points: 3859
More actions
December 13, 2013 at 5:09 am

#301375

Hello, what's the name for this type of table used in the following way? Instead of creating a database view, create a table with the structure of the view and populate the table with data via a trigger or an ETL job.
I suppose this could be described as a denormalized table or a reporting table. I was wondering if DBA's have a common way of describing this type of table used in this context?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398911 More actions · Answer 1

Hmmmm... Well, it's almost a materialized view, but that's a view with a clustered index which makes it effectively a table. This is different. I guess I'd go with denormalized table, but that doesn't feel satisfying. I can't say that I've heard an explicit term for this before.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 2

If it's an ETL job then you'd probably call it a data load; incremental, if you're not truncating the target table beforehand.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Jeff Moden SSC Guru Points: 1004433 More actions · Answer 3

Staging table.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)