Slowly Changing Dimension
Dimension is a term in data management and data warehousing. It's the logical groupings of data such as geographical location, customer or product information. With Slowly Changing Dimensions (SCDs) data changes slowly, rather than changing on a time-based, regular schedule.
For example, you may have a dimension in your database that tracks the sales records of your company's salespeople. Creating sales reports seems simple enough, until a salesperson is transferred from one regional office to another. How do you record such a change in your sales dimension?
You could calculate the sum or average of each salespersons sales, but if you use that to compare the performance of salesmen, that might give misleading information. If the salesperson was transferred and used to work in a hot market where sales were easy, and now works in a market where sales are infrequent, his/her totals will look much stronger than the other salespeople in their new region. Or you could create a second salesperson record and treat the transferred person as a new sales person, but that creates problems.
Dealing with these issues involves SCD management methodologies referred to as Type 0 through 6. Type 6 SCDs are also sometimes called Hybrid SCDs.
Read more about Slowly Changing Dimension: Type 0, Type I, Type II, Type III, Type IV, Type 6 / Hybrid, Combining Types, See Also
Famous quotes containing the words slowly, changing and/or dimension:
“If you believe that a nation is really better off which achieves for a comparative few, those who are capable of attaining it, high culture, ease, opportunity, and that these few from their enlightenment should give what they consider best to those less favored, then you naturally belong to the Republican Party. But if you believe that people must struggle slowly to the light for themselves, then it seems to me that you are a Democrat.”
—Eleanor Roosevelt (1884–1962)
“The human condition is such that pain and effort are not just symptoms which can be removed without changing life itself; they are the modes in which life itself, together with the necessity to which it is bound, makes itself felt. For mortals, the “easy life of the gods” would be a lifeless life.”
—Hannah Arendt (1906–1975)
“God cannot be seen: he is too bright for sight; nor grasped: he is too pure for touch; nor measured: for he is beyond all sense, infinite, measureless, his dimension known to himself alone.”
—Marcus Minucius Felix (2nd or 3rd cen. A.D.)