{'fraction_non_alphanumeric': 0.01676076217360621, 'fraction_numerical': 0.005822159491884263, 'mean_word_length': 5.222832052689353, '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': 1, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Designing a new Applications of Data Warehousing Using 3-tier Architecture for Petroleum Industry

In this paper we present three tier architecture of a middleware that addresses challenges facing accessibility, availability, and consistency of data in mobile environments. The architecture supports the automatic hoarding of data from multiple, heterogeneous sources into possibly a variety of different mobile devices. Organizations be it industry or business or even educational institutes, need to improve their information inventory system so as to survive in the competitive environment. The Organizations have to increase their efficiency and effectiveness in maintaining the cycle of activities, in their planning, decision-making processes, and analytical needs. There are several ways to acquire this goal; one of it is with data mining which is able to make a prediction using existing data in their database in order to forecast future demand. In addition, with data mining they would be able to determine which activity is more important and what trend is prevailing. An information system, which is based on both World Wide Web technology and a 3-tiered architecture, is proposed herein to meet the above requirements. This paper is an attempt to provide the initial concept about data mining model that most likely will be used in various department including libraries of the teaching institutes. The initial concepts covered by the paper are the appropriate data warehouse schema; data mining tasks and techniques that are best suited, and applications. And also In this paper we investigated the various data capturing systems which they currently in use at the Ghana National Petroleum Cooperation (GNPC) – a state agency responsible for the overall management and supervision of the hydrocarbon endowment of the sub region and recommending a tree tier level petroleum data warehouse architecture for cuttingedge decision making on petroleum resources. Keywords-Data warehouse architecture, Petroleum data warehousing, Ghanaian petroleum industry. INTRODUCTION Ghana came into the spotlight in 2007 for its first ever discovery of hydrocarbon in commercial quantities. According to reports, the country is set to produce 1.4million gallons of crude oil per year, shooting the country’s wealth up by a warping 4 billion dollars a year. Economic growth is also estimated to increase more than 13% per annum [1]. All these economic developments in the country raised the issue of how all these plans have been made without using a reliable data. As a matter of fact that for any country to achieve international reputation should depends greatly on the pro-activeness of its government and its citizens, especially the research reports to be able to anticipate the ramifications of their decisions and to put in place appropriate contingency plans to mitigate them. However this cannot be done without using the right information carefully formatted, faultlessly triangulated, craftily and rightly positioned at the right place relative to each other for cutting edge decision making. Quality data and vibrant is the key to success of this fast growing industry. The importance of data is once again captured by the fact that the organization makes approximately about US$2 million from data licensing per annum and presently provisions are being made to embark on a US$10 million project that would see to the establishment of an online four levels architectures data store (the so termed data farm) supported by a meta data for faster and easier access to information. In this paper we looked at how data warehousing can be integrated into this data farm for efficient and effective extraction of necessary data for tactical decision making. This paper presents a new data warehouse framework for the Ghanaian petroleum industry, Ghana is a relatively small but powerful country in sub-Saharan Africa – the republic of Ghana which recently idiomatically struck gold fortunes on its sea beds in the form of hydrocarbon deposits. In this context, some of the key questions that can be asked; what are the government’s plan for continual discovery, exploration and preservation of this resource for the citizens of Ghana, and if there are any, are these plans made based on readily available, factual and highly summarized data or they are the decisions of the precomputer age. Data warehouses are said to provide artificial support for management decision making but can this be of any use to the Ghanaian petroleum exploration industry. This paper seeks to provide answers to these questions by investigating the various data capturing systems currently in use at the Ghana National Petroleum Cooperation – a state agency responsible for the overall management and supervision of the hydrocarbon endowment of the subregion and recommending petroleum data warehouse for cuttingedge decision making on petroleum by government. Interviews supported by some level of participant observation methods are adopted for gathering information in this paper. Transcription was the main analysis tool utilized in identifying themes, trends and building interpretations around them. The term data warehouse just like any other term in the professional domain has received many scholarly attentions over the years with criticisms and counter criticisms by many database technologists. However, Inman in 1993 has it that “a data warehouse is a subject oriented, integrated, time variant and non-volatile collection of data in support D.V.S.S.Subrahmanyam / (IJCSIT) International Journal of Computer Science and Information Technologies, Vol. 5 (3) , 2014, 4505-4510