{'fraction_non_alphanumeric': 0.016152716593245228, 'fraction_numerical': 0.0, 'mean_word_length': 5.314814814814815, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Design and realization of the National Petroleum Resource Database ETL System based on SOA

Considering the current situation of the data on oil and gas resources in China, which is relatively multi-sourced, heterogeneous and decentralized, as well as the actual demand of OLAP, MVC model is employed as the system constructing model. Besides, ODBC and XML technology are combined to achieve dynamic mapping on database connection. Thus the National Petroleum Resource Database ETL System which is based on SOA comes into being. Meanwhile, the technical difficulties encountered in the integrated developing process as well as the corresponding solutions adopted are also provided.