Matches in SemOpenAlex for { <https://semopenalex.org/work/W2045221612> ?p ?o ?g. }
- W2045221612 endingPage "42" @default.
- W2045221612 startingPage "12" @default.
- W2045221612 abstract "Several approaches have been proposed to model different aspects of a Data Warehouse (DW) during recent years, such as the modeling of a DW at the conceptual and logical level, the design of the ETL (Extraction, Transformation, Loading) processes, the derivation of the DW models from the enterprise data models, and customization of a DW schema. At the end of the design, a DW has to be deployed in a database environment, requiring many decisions of a physical nature. However, few efforts have been dedicated to the modeling of the physical design of a DW from the early stages of a DW project. In this article, we argue that some physical decisions can be taken from gathering main user requirements. In this article, we present physical modeling techniques for DWs using the component diagrams and deployment diagrams of the Unified Modeling Language (UML). Our approach allows the designer to anticipate important physical design decisions that may reduce the overall development time of a DW, such as replicating dimension tables, vertical and horizontal partitioning of a fact table, and the use of particular servers for certain ETL processes. Moreover, our approach allows the designer to cover all main design phases of DWs from the conceptual modeling phase to the final implementation. To illustrate our techniques, we show a case study that is implemented on top of a commercial DW management server." @default.
- W2045221612 created "2016-06-24" @default.
- W2045221612 creator A5042498552 @default.
- W2045221612 creator A5087667090 @default.
- W2045221612 date "2006-04-01" @default.
- W2045221612 modified "2023-09-25" @default.
- W2045221612 title "Physical Modeling of Data Warehouses Using UML Component and Deployment Diagrams" @default.
- W2045221612 cites W110700143 @default.
- W2045221612 cites W125528362 @default.
- W2045221612 cites W1482268585 @default.
- W2045221612 cites W1495788210 @default.
- W2045221612 cites W1510022615 @default.
- W2045221612 cites W1518695183 @default.
- W2045221612 cites W1544891722 @default.
- W2045221612 cites W1550553545 @default.
- W2045221612 cites W1570240737 @default.
- W2045221612 cites W158175084 @default.
- W2045221612 cites W178071803 @default.
- W2045221612 cites W1879180136 @default.
- W2045221612 cites W1936689714 @default.
- W2045221612 cites W1968189045 @default.
- W2045221612 cites W1984639778 @default.
- W2045221612 cites W2008120802 @default.
- W2045221612 cites W2016925060 @default.
- W2045221612 cites W2032766917 @default.
- W2045221612 cites W203981271 @default.
- W2045221612 cites W2093154290 @default.
- W2045221612 cites W2101915266 @default.
- W2045221612 cites W2128731098 @default.
- W2045221612 cites W2139088695 @default.
- W2045221612 cites W2153696856 @default.
- W2045221612 cites W26368440 @default.
- W2045221612 cites W3000135916 @default.
- W2045221612 cites W5925479 @default.
- W2045221612 cites W2584377124 @default.
- W2045221612 doi "https://doi.org/10.4018/jdm.2006040102" @default.
- W2045221612 hasPublicationYear "2006" @default.
- W2045221612 type Work @default.
- W2045221612 sameAs 2045221612 @default.
- W2045221612 citedByCount "16" @default.
- W2045221612 countsByYear W20452216122012 @default.
- W2045221612 countsByYear W20452216122013 @default.
- W2045221612 countsByYear W20452216122014 @default.
- W2045221612 countsByYear W20452216122015 @default.
- W2045221612 countsByYear W20452216122016 @default.
- W2045221612 crossrefType "journal-article" @default.
- W2045221612 hasAuthorship W2045221612A5042498552 @default.
- W2045221612 hasAuthorship W2045221612A5087667090 @default.
- W2045221612 hasBestOaLocation W20452216122 @default.
- W2045221612 hasConcept C105339364 @default.
- W2045221612 hasConcept C115903868 @default.
- W2045221612 hasConcept C121332964 @default.
- W2045221612 hasConcept C135572916 @default.
- W2045221612 hasConcept C143008350 @default.
- W2045221612 hasConcept C145644426 @default.
- W2045221612 hasConcept C168167062 @default.
- W2045221612 hasConcept C199360897 @default.
- W2045221612 hasConcept C201932085 @default.
- W2045221612 hasConcept C203702819 @default.
- W2045221612 hasConcept C21285288 @default.
- W2045221612 hasConcept C2777904410 @default.
- W2045221612 hasConcept C41008148 @default.
- W2045221612 hasConcept C41298492 @default.
- W2045221612 hasConcept C45235069 @default.
- W2045221612 hasConcept C67186912 @default.
- W2045221612 hasConcept C77088390 @default.
- W2045221612 hasConcept C86610423 @default.
- W2045221612 hasConcept C97355855 @default.
- W2045221612 hasConceptScore W2045221612C105339364 @default.
- W2045221612 hasConceptScore W2045221612C115903868 @default.
- W2045221612 hasConceptScore W2045221612C121332964 @default.
- W2045221612 hasConceptScore W2045221612C135572916 @default.
- W2045221612 hasConceptScore W2045221612C143008350 @default.
- W2045221612 hasConceptScore W2045221612C145644426 @default.
- W2045221612 hasConceptScore W2045221612C168167062 @default.
- W2045221612 hasConceptScore W2045221612C199360897 @default.
- W2045221612 hasConceptScore W2045221612C201932085 @default.
- W2045221612 hasConceptScore W2045221612C203702819 @default.
- W2045221612 hasConceptScore W2045221612C21285288 @default.
- W2045221612 hasConceptScore W2045221612C2777904410 @default.
- W2045221612 hasConceptScore W2045221612C41008148 @default.
- W2045221612 hasConceptScore W2045221612C41298492 @default.
- W2045221612 hasConceptScore W2045221612C45235069 @default.
- W2045221612 hasConceptScore W2045221612C67186912 @default.
- W2045221612 hasConceptScore W2045221612C77088390 @default.
- W2045221612 hasConceptScore W2045221612C86610423 @default.
- W2045221612 hasConceptScore W2045221612C97355855 @default.
- W2045221612 hasIssue "2" @default.
- W2045221612 hasLocation W20452216121 @default.
- W2045221612 hasLocation W20452216122 @default.
- W2045221612 hasOpenAccess W2045221612 @default.
- W2045221612 hasPrimaryLocation W20452216121 @default.
- W2045221612 hasRelatedWork W1978766952 @default.
- W2045221612 hasRelatedWork W1988156201 @default.
- W2045221612 hasRelatedWork W2034216129 @default.
- W2045221612 hasRelatedWork W2045221612 @default.
- W2045221612 hasRelatedWork W2369215403 @default.
- W2045221612 hasRelatedWork W2478694530 @default.