What is Data Warehouse?

In recent years, organizations have made investments in IT systems in order to arrange business processes and to take advantage of competitiveness. Relational data base located on these IT systems generates and stores substantial amount of information and also distributes the information on PC, main frame and server network system. However, it is not adequate just to gather and collect large amount of information without using it. In many organizations, this information does not support critical business decisions. Besides, it is not possible to manage and handle such huge amount of information. Therefore, new methods are sought to convert collected data into information that is the most valuable asset.

The Data Warehouse serving as a basis for these methods is information depository to store operational information, which is kept on data base in an integrated chronological format and to make fast and accurate analysis on this data base after completing procedures for the operational information, Unlike operational data base, the structure of Data Warehouses is based on fast analysis and information access. The data is updated at regular intervals. The Data Warehouses are accessed through specially developed tools.

Customs Data Warehouse System

The fundamental aim of IT studies carried out Undersecretariat of Customs is to modernize the Customs Administration so as to make it more effective and efficient. 100% of foreign trade transactions have been carried out by BILGE on real-time basis.

The goal of establishment of the Data Warehouse is to found a “Decision-Support System” in order for customs administration to take sound decisions and to access to accurate information for various types of complicated customs procedures over a wide geographic range.

Customs Data Warehouse (called as GÜVAS) which has been implemented by central units of Undersecretariat of Customs as of May 2002, enables all Customs organization to manage, to analyse and to access promptly to raw information obtained from operational units of Undersecretariat of Customs regarding the following topics:

• Foreign Trade Statistics
• Performance Statistics of Customs Directorates, customs officers and traders
• Monitoring activities of company/institution/administration
• Establishment and analysis of valuation information
• Risk analysis
• Performance analysis
• Monitoring smuggling cases
• Monitoring judicial records
• Monitoring procedures for Vehicle, Container, TIR