Data Warehouse
     
       In an enterprise a data warehouse (DWH) is an organized 
     information collection which stores current and historical data 
     used for creating reports for management.
     
        Reports are generally produced from already structured 
     information or continual data mining carried out by experts.
     
       Data mining is realized by using advanced statistical methods, 
     correlating “primary information ” from different production 
     departments.
     
       The delivery of reports is carried out using “secondary 
     information” stored in specialized Data Marts.
     
       The discovery of useful information aids business strategies which 
     should increase efficiency in the production process.
                     S-DWH overview architecture
       Staging Area    Data Integration Data Warehouse      Data Mart
       PRODUCTION                           DATA MINING
                               E
                               T
       RESOURCES               L                            secondary 
                                                            information
      DISTRIBUTION                                          secondary 
                            operational     primary         information
          SALES             information   information
                                              primary 
                                            information      REPORTS
        EXTERNAL          OPERATIONAL
                                                                DECISION
                                              feedback
            Statistical Data Warehouse
     
       In an Enterprise the information collected in a DWH derives 
      from different production departments. For producing Primary 
      Information, specific Extraction Transformation and Loading 
      (ETL) procedures are needed.
     
       In a S-DWH (Statistical-DWA) the sources are direct data 
      capturing or administrative archives and the ETL procedures 
      must manage the effective statistical elaboration.
     
       A S-DWH is a coherent information collection of current and 
      historical data of different statistical topics and domains.
     A high level of coordination is necessary both within different 
     topics and within different operational phase activities, and 
     between the topics and activities.
                S-DWH Architectural domains
       
          To define and enable the evolution of a S-DWH requires a 
         definition of a framework where key principles and models 
         can be created, communicated and improved.
       
          A S-DWH framework comprises:
          business domain to align strategic objectives and 
            tactical demands through a common understanding of 
            the organization. 
          Information architecture domain, to describe data 
            base organization and management of data and 
            metadata information. 
          technology domain, i.e. the combined set of software, 
            hardware and networks to develop and support IT 
            services. 
                                                      5
                 S-DWH business domain
        
           In the business domain, key business processes that 
          should be considered are:
           Adapting or Redesigning of statistical regulation (timing 
           and output); 
           Managing changes from stove-pipe approaches to a 
           coherent S-DWH; 
           Redesigning operational management ( methodology and 
           processes);
           Data management (security, custodianship and ownership, 
           data and metadata); 
           Quality management (assessment and control);
           Software and IT infrastructure management.
                                                   6