14,501 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
There are many. Without knowing more details it is hard to guess.
"Data Vault" is one I have used in the past. I would not really recommend it for most implementations.
cannot recall the term used for a very detailed, highly disciplined data warehousing approach that includes processes
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 70%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
db042190
1,521
Reputation points
Hi, this is embarrassing but there is a discipline out there that in addition to data, captures something about processes and perhaps workflows in the warehouse as well.
I looked at it years ago, thought it had some merit, would be expensive and in some installations might possibly be overkill.
Does anybody remember what it is called? I want to do a re read.
SQL Server | Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,586 Reputation points2022-06-27T01:35:26.983+00:00 Hi @db042190 ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Sign in to comment
Accepted answer
2 additional answers
Sort by: Most helpful
-
Seeya Xi-MSFT 16,586 Reputation points
2022-06-24T03:17:43.47+00:00 Hi @db042190 ,
Welcome to Microsoft Q&A!
Since what you said is not very clear, I found some articles for your reference. You can read them and check if what you want to ask is in these articles.
Management Data Warehouse
SQL Server Data Warehouse: the Easy and Practical Guide
Choosing Snowflake vs SQL Server for a Data Warehouse
I hope these articles can point you in the right direction.Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. -
db042190 1,521 Reputation points
2022-06-24T12:58:58.38+00:00 thx anyway seeyaxi, i'll pass on reading the articles. i think as soon as someone who has seen and worked on that approach to building warehouses sees the question, they will post the answer. I'll try to find the name myself also when time permits. even the design diagrams for such design have special figures as i recall for processes and work flows. Its a very disciplined and detailed approach to designing warehouses, at least as i recall.