| dbo:abstract
|
- Unter dem Begriff Slowly Changing Dimensions (deutsch: sich langsam verändernde Dimensionen) werden im Data-Warehousing Methoden zusammengefasst, um Änderungen in Dimensionstabellen zu erfassen und gegebenenfalls historisch zu dokumentieren. Im Wesentlichen unterscheidet man drei Verfahren, die nach Kimball in Typen unterteilt werden. Allen gemein ist, dass vorhandene Datensätze über den Primärschlüssel mit neuen Datensätzen verbunden werden, um Änderungen in der Tabelle zu speichern. Technische Schlüssel sind nicht Gegenstand des Artikels. (de)
- Une dimension à évolution lente (slowly changing dimension ; SCD) est, en informatique décisionnelle (business intelligence), une dimension pouvant subir des changements de description des membres. (fr)
- A slowly changing dimension (SCD) in data management and data warehousing is a dimension which contains relatively static data which can change slowly but unpredictably, rather than according to a regular schedule. Some examples of typical slowly changing dimensions are entities as names of geographical locations, customers, or products. Some scenarios can cause referential integrity problems. For example, a database may contain a fact table that stores sales records. This fact table would be linked to dimensions by means of foreign keys. One of these dimensions may contain data about the company's salespeople: e.g., the regional offices in which they work. However, the salespeople are sometimes transferred from one regional office to another. For historical sales reporting purposes it may be necessary to keep a record of the fact that a particular sales person had been assigned to a particular regional office at an earlier date, whereas that sales person is now assigned to a different regional office. Dealing with these issues involves SCD management methodologies referred to as Type 0 through 6. Type 6 SCDs are also sometimes called Hybrid SCDs. (en)
- Dimensione è un termine usato in data management e in data warehousing per indicare raggruppamenti logici nei dati come la collocazione geografica, informazioni sui clienti o sui prodotti. Le Slowly Changing Dimensions sono dimensioni i cui attributi hanno valori che possono variare lentamente nel tempo. Poniamo il caso di una dimensione, nel vostro database che memorizzi i record delle vendite dei vostri commessi. Creare reports sulle vendite è semplice finché un commesso non viene trasferito da un negozio all'altro. Come viene registrato questo cambiamento nella vostra dimensione? La comparazione fra le performance dei diversi commessi può dare risultati falsati, ad esempio perché il commesso potrebbe passare da un negozio che fa molte vendite ad uno dove queste sono scarse. Nella comparazione con i suoi nuovi colleghi il commesso risulterebbe, incorrettamente, il migliore. Per risolvere problemi di questo tipo si utilizzano metodi per la gestione delle Slowly Changing Dimensions cui si fa riferimento come Tipo 0, 1, 2, 3, 4 e 6. Le SCD di tipo 6 sono anche dette ibride. (it)
- Медленно меняющиеся измерения (от англ. Slowly Changing Dimensions, SCD) — механизм отслеживания изменений в данных измерения в терминах хранилища данных. Применяется в случае, если данные меняются не очень часто и не по расписанию. Примером могут служить географические данные (местонахождение склада, юридический адрес организации), статус заказчика по программе лояльности или отдел компании, в котором работает её сотрудник. Выделяют несколько типов SCD. (ru)
|
| dbo:thumbnail
| |
| dbo:wikiPageExternalLink
| |
| dbo:wikiPageID
| |
| dbo:wikiPageLength
|
- 20850 (xsd:nonNegativeInteger)
|
| dbo:wikiPageRevisionID
| |
| dbo:wikiPageWikiLink
| |
| dbp:date
| |
| dbp:reason
|
- Is this a RI problem caused by SCD, or solved by it? (en)
|
| dbp:wikiPageUsesTemplate
| |
| dct:subject
| |
| rdfs:comment
|
- Unter dem Begriff Slowly Changing Dimensions (deutsch: sich langsam verändernde Dimensionen) werden im Data-Warehousing Methoden zusammengefasst, um Änderungen in Dimensionstabellen zu erfassen und gegebenenfalls historisch zu dokumentieren. Im Wesentlichen unterscheidet man drei Verfahren, die nach Kimball in Typen unterteilt werden. Allen gemein ist, dass vorhandene Datensätze über den Primärschlüssel mit neuen Datensätzen verbunden werden, um Änderungen in der Tabelle zu speichern. Technische Schlüssel sind nicht Gegenstand des Artikels. (de)
- Une dimension à évolution lente (slowly changing dimension ; SCD) est, en informatique décisionnelle (business intelligence), une dimension pouvant subir des changements de description des membres. (fr)
- Медленно меняющиеся измерения (от англ. Slowly Changing Dimensions, SCD) — механизм отслеживания изменений в данных измерения в терминах хранилища данных. Применяется в случае, если данные меняются не очень часто и не по расписанию. Примером могут служить географические данные (местонахождение склада, юридический адрес организации), статус заказчика по программе лояльности или отдел компании, в котором работает её сотрудник. Выделяют несколько типов SCD. (ru)
- A slowly changing dimension (SCD) in data management and data warehousing is a dimension which contains relatively static data which can change slowly but unpredictably, rather than according to a regular schedule. Some examples of typical slowly changing dimensions are entities as names of geographical locations, customers, or products. Some scenarios can cause referential integrity 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. (en)
- Dimensione è un termine usato in data management e in data warehousing per indicare raggruppamenti logici nei dati come la collocazione geografica, informazioni sui clienti o sui prodotti. Le Slowly Changing Dimensions sono dimensioni i cui attributi hanno valori che possono variare lentamente nel tempo. Per risolvere problemi di questo tipo si utilizzano metodi per la gestione delle Slowly Changing Dimensions cui si fa riferimento come Tipo 0, 1, 2, 3, 4 e 6. Le SCD di tipo 6 sono anche dette ibride. (it)
|
| rdfs:label
|
- Slowly Changing Dimensions (de)
- Dimension à évolution lente (fr)
- Slowly changing dimension (it)
- Slowly changing dimension (en)
- Медленно меняющееся измерение (ru)
|
| owl:sameAs
| |
| prov:wasDerivedFrom
| |
| foaf:depiction
| |
| foaf:isPrimaryTopicOf
| |
| is dbo:wikiPageDisambiguates
of | |
| is dbo:wikiPageRedirects
of | |
| is dbo:wikiPageWikiLink
of | |
| is foaf:primaryTopic
of | |