Archived data management systems (ADMSs) are data warehouses created to support analyses that are based on data collected by transportation operations systems. Whereas many believe that an ADMS can be created by simply exporting data from an operations system, experience in developing the Virginia ADMS illustrates that the creation of an effective ADMS requires careful attention to the extraction, transformation, and loading (ETL) process. This process refers to the activities conducted when a data warehouse is created from an operational data store. Four critical elements of an ADMS ETL process are addressed: data aggregation, data quality assessment, data imputation, and data characterization. For each element the purpose and need are documented, a review of available alternative implementation methods is presented, and, finally, a description of the approach used in the Virginia ADMS is detailed.


    Zugriff

    Download

    Verfügbarkeit in meiner Bibliothek prüfen

    Bestellung bei Subito €


    Exportieren, teilen und zitieren



    Titel :

    Investigation of Extraction, Transformation, and Loading Techniques for Traffic Data Warehouses


    Weitere Titelangaben:

    Transportation Research Record


    Beteiligte:


    Erscheinungsdatum :

    2004-01-01




    Medientyp :

    Aufsatz (Zeitschrift)


    Format :

    Elektronische Ressource


    Sprache :

    Englisch





    The environmental and traffic impacts of warehouses in southern California

    deSouza, Priyanka N. / Ballare, Sudheer / Niemeier, Deb A. | Elsevier | 2022


    STACKER CRANE FOR WAREHOUSES

    CAMELLI MARCO | Europäisches Patentamt | 2018

    Freier Zugriff

    Height adjustable rack for warehouses

    KIM DEOK SU | Europäisches Patentamt | 2016

    Freier Zugriff