1 / 23

External Trade Statistical System

External Trade Statistical System. UNECA – Addis Ababa, October 2011. Eurotrace has been substantially revised and improved. Three separate applications that work together. Data Processing Software for External Trade Statistics. Comext Standalone Data Browser. Eurotrace DBMS.

cybele
Download Presentation

External Trade Statistical System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. External Trade Statistical System UNECA – Addis Ababa, October 2011

  2. Eurotrace has been substantially revised and improved. Three separate applications that work together. Data Processing Software for External Trade Statistics Comext Standalone Data Browser Eurotrace DBMS Eurotrace Data Editor

  3. Computing Technology • Built with Microsoft Visual Basic and C++ Programming Languages • Supports Data Access Objects (DAO) and Open database connectivity Standards (OBDC) • Pentium II 450Mhz • 256MB RAM • Windows 95, 98, NT, 2000, Me or XP Operating system • A 3 part system of Interacting programs, offering an extensive and complete range of data processing tools to meet all External Trade Statistics data processing needs. • The software is free and can be downloaded from: http://circa.europa.eu/irc/dsis/eurotracegroup/info/data/website/index_en.htm

  4. External Trade Statistics: Implementing system with Comext/Eurotrace Package Data Sources Mostly CUSTOMS DECLARATION External Trade Database RAW DATA COMEXT Stand-Alone Browser External Trade Database Definition Estimation Indices Enterprise Data Requests UN IMF Country Table and Publication EUROSTAT MedComext Data Integration Procedure

  5. Eurotrace Actors How to design a Domain ? 4. Target of Data dissemination Statistical Office Statistics Users 2. Provider of Data Trade Statistics data Supplier, Customs, Statistical Office Data Editor 1. Define External Trade Statistical Database Expert of Nomenclatures and/or Trade Information System 3. Validity Check and Quality Control Data Coders, Data Controller Derived Data Source Dataset Classification Plan

  6. Definition Classification Plan Dictionary Dictionary Dictionary Eurotrace DOMAIN

  7. GeoNom. CTY Activity BEC SITC HS Enterprise Managing Nomenclatures and Relations Classification Plan

  8. Source Data Dataset Source Classification Plan Dictionary Dictionary Dictionary Eurotrace DOMAIN Definition

  9. Define Data Structure • Define the data set structure using Dictionaries Format: Asycuda, Eurotrace Dos, SAD … 2. Source Data Structure Define the file structure to be integrated within Eurotrace Validation 3. Define Data Integration Algorithm Importing data by using the Wizard Data Entry/Correction Direct Validation Source Dataset

  10. 1. Database Extraction a. Single File b. Record Locking Security c. Extraction Criteria 2. Data Editor a. Appending New Records b. Modify Records c. “Undo” function d. Header – Detail - Footer e. Validation “On The Fly” 3. Detecting Errors a. Highlighted in red b. Type of Error occurred 7. Database Update a. File sent to administrator in order to update the DB b. Errors could be corrected one by one (No lock in process) c. Database Records Unlocked 4. Form Designer a. Customize the Customs Declaration Form b.Hide/Mask fields c. Move Boxes ( from/to body to/from header/footer part) 5. Code List Selector a. Hierarchy selection b. Code Validation 6. Record Navigator a. Select a specific record directly b. View data in Grid format Data Entry/Data Correction

  11. Data Monitoring • Historical back-up • Error Correction Wizard • Checking of Error Type • List of valid codes (dictionary) Dataset Management

  12. Upgrade Upgrade Classification Plan Dictionary Dictionary Dictionary Derived Dataset Derived Dataset Source Data Eurotrace DOMAIN Dataset Source Definition

  13. 2. Simple Interface to Upgrade Derived DS a. Selecting of Period to be updated b. Global control on Data Maintenance 1. Define Algorithm for Derived Dataset a. Parameters based on Data Source b. Codes Filter & Correlation Tables Derived Dataset Upgrade

  14. Classification Plan Dictionary Dictionary Dictionary Dissemination/Analysis Source Data Eurotrace DOMAIN Dataset Source Upgrade Upgrade Definition Derived Dataset Derived Dataset

  15. COMEXT Stand-Alone A common Interface for Data Dissemination

  16. Criteria Selection and Data Browsing COMEXT Stand-Alone Comext Plan

  17. COMEXT Stand-Alone Formula definitions

  18. COMEXT Stand-Alone Format of extraction TYPE .txt .dmp .dta .xls .csv Spreadsheet format Excel format

  19. Classification Plan Dictionary Dictionary Dictionary Source Data Eurotrace DOMAIN Dataset Source Upgrade Upgrade Definition Eurotrace Local Administrator Black Box or Installation mission Parameters Derived Dataset Derived Dataset Dissemination/Analysis

  20. Implementation, Efficiency & Robustness

  21. Advantages of Eurotrace • Flexibility • Full control of statistical data • Fully definable control parameters • Save Time • Reduce data validation time • Track down and easily correct errors • Helps Cooperation between partner countries • Make data compatible with EU standards • Ensure compatibility with partner countries • Enables easy transmission of data

  22. Multi-lingual • EUROTRACE is able to store codes and labels in different languages that are accessible throughout the application. Data can be displayed in English, French, German, Italian, Spanish, Portuguese, Greek, Dutch, Swedish, Danish, Finnish and Luxembourgish. • The language of the interface is set by the user to either French or English.

  23. Thank You

More Related