+234 813 0686 500
+234 809 3423 853
info@grossarchive.com

DATA WAREHOUSE SYSTEM FOR A QUICK RETRIEVAL OF DATA

  • Type:Project
  • Chapters:5
  • Pages:90
  • Format:Microsoft Word
(Computer Engineering Project Topics & Materials)
DATA WAREHOUSE SYSTEM FOR A QUICK RETRIEVAL OF DATA
ABSTRACT

This project work intends to provide architecture for the technology in building of a standard, sophisticated and user-friendly data warehouse system which is platform independent and secured. The proposed work surely addressed the limitations identified within the scope of this project work. The limitations are identified by examining and analyzing the present system of reporting and managing data. The new system or proposed work uses a well written software in Java programming language which is OS independent with the aid of a database system; MySQL for collection of and storing of information / data / records. We proposed a new architecture motivated from traditional network from the present system of collecting and saving records. The proposed architecture is also conceptually evaluated for its viability
 CHAPTER ONE
1.0            INTRODUCTION   
1.1       AN OVERVIEW OF A DATA WARE HOUSE SYSTEM
Today, organizations uses large amount of data daily depending on the kind of organization. However, most of these organizations’ collect its useful data majorly through manual paper recording instead of sophisticated and automated systems. Due to the use of paper recording of data, there can be many mishap since paper is a bio gradable material and also slow and prone to natural disaster and damage.
 It is this identification of problems in trends that enabled the decision of building a stronger and more reliable system of collecting, recording and analyzing data, and this is the main aim of this project work.
 The end users are company managers, project managers, and university vice chancellor, Head of Department, stake holders, many team leaders, etc. It should be noted at this point that there is need for adequate training on the use of this proposed system before it can be used properly.
 A data warehouse prerequisite is that database has to exist in the different organizational unit of an organization so that the data warehouse can collect information / records/ data by querying it into its own database.
 Furthermore, it is multidimensional modeled and is used for the storage of histories, cleansed, validated, synthesized, operative, internal and external data. Stakeholders of a data warehouse system are interested in analyzing their business processes in a comprehensive and flexible way. Mostly they already have a comprehensive understanding of their organizational processes which they want to explore and analyze. What they actually need is a view of their organizational processes and its data which allows them have an extensive analysis of their data.
The design of the proposed data warehouse system is to take care of any form of database technology. So it will be built to be able to collect information / data in database such as oracle, SQL server, my SQL, access and from CSV file. I believe that all institutions can’t go outside these systems.
  1.2     BACKGROUND REVIEW OF THE STUDY
Since development come that triggered the necessity to record information in different areas of endeavor, it has always been difficult to manage large amount of data. This is still a serious problem in the developing economy such as Nigeria.
 The present system used manual way of writing on paper and recording. Their process is very slow and the proposed system, data warehouse is been introduced to solve all this problems. This new system will be capable of retrieving data from any kind of database.
 Also, with the use of the present system, heads of various departments finds it difficult to gather all information needed by them. Data coming from various units also varies which bring about inconsistencies. Data warehouse is useful because it is capable of retrieving all these information from different sub-system databases and collecting it into the data warehouse thus, bringing a great deal of speed and confidence in the part of management leaders.
 Considering the limitations of manual systems, data warehouse were developed to meet the growing demand for management of information and analysis that could not be met by the present systems. The present system was unable to meet the need of fast processing which greatly reduced response time.
1.3       STATEMENT OF THE PROBLEM
Before the advent of data warehouse, organizations including Universities used manual means of recording and reporting data. Materials used were pen, ink and paper. These records can be photocopied and reported. There were so many disadvantages associated with this material especially the paper which has a time span. Based on these challenges, I seek to alleviate the problem by implementing a data warehouse that is electronically driven.
 In the present system, data or records that were considered old would be removed from its storage for quick response time. This was done for the purpose of making the response time easier to maintain. This is done to give way to the new records /data coming in. when data warehouse are designed properly and implemented, they can bring a large number of advantages to the organization/universities that use them. They can give an organization a forecast of how the organization is performing as a whole. It can help executives, managers and stakeholders on how to make crucial decisions that can help an organization or institution to succeed.
1.4       OBJECTIVES OF THE STUDY
The main objective of this project work is to design a Data Warehouse for collection of data from separate database sources and store it in a data warehouse for further administrative uses/function, in a conducive format that is readily usable. To achieve this, the following are the objectives to be fulfilled.
1.     Discuss the exiting ways or techniques of managing datas, records and reporting and identifying their limitations based on literature survey.
2.     Propose an architecture addressing identified limitations.
3.     Evaluate the proposed architecture for its viability
4.     And lastly, address the scope for its future work
1.5       SCOPE OF THE STUDY
This study is proposed to Caritas University, Enugu. This proposed system will be able to bring together data from different departments and sections of Caritas University Enugu and put the data into a centralized data warehouse in a format that is conducive to making strategic decisions.
1.6       SIGNIFICANCE OF THE STUDY
Data warehouses when designed and implemented properly, they can bring a large number of advantages to the organization / Universities that use them. The can give an organization a forecast on how the organization is performing as a whole, ensuring a competitive advantage, thus can be applied in other fields such as police stations, production companies, hospital, Banks etc.
 1.7      LIMITATIONS OF THE STUDY
Having mentioned the usefulness of the data warehouse, a quiet number of factors may also affect this study. The factors are:
1.     The acceptance of implementing this project work into the school system.
2.     The present knowledge base on database management.
3.     The cost of carrying out the project.
1.8       DEFINITION OF TERMS / VARIABLES
DATA CLEANSING- the process of ensuring that all values in a dataset are consistent and accurate
DATA MINING- the extraction of hidden predictive information from large database
DATA NAVIGATION- the process of viewing different dimensions, slices, and levels of details of multidimensional databases.
DATA VISUALISATION- The visual interpretation of complex relationships in multidimensional data.
DATA WAREHOUSE- a system for storing and delivering massive quantities of data.
METADATA- the information of the data stored in database
OLAP- Online Analytic Processing
OLTP- Online Transaction Processing
DATABASE- A collection of logically related data to meet the information need of the organization
DBMS- Database management software that enables the user to define, maintain control the database
MANAGEMENT INFORMATION SYSTEM- Collection of people, database and devices produced to use in providing routine information to manager and decision makers of the organization
DATABASE DESIGN- The process of creating a design that will support task to the mission statement and mission required database system.

DATA WAREHOUSE SYSTEM FOR A QUICK RETRIEVAL OF DATA

Share This

Details

Type Project
Department Computer Engineering
Project ID CPE0005
Price ₦3,000 ($9)
Chapters 5 Chapters
No of Pages 90 Pages
Format Microsoft Word

500
Leave a comment...

    Details

    Type Project
    Department Computer Engineering
    Project ID CPE0005
    Price ₦3,000 ($9)
    Chapters 5 Chapters
    No of Pages 90 Pages
    Format Microsoft Word

    Related Works

      ABSTRACT Tourism as being a great source of revenue in so many countries like Britain, Australia, Malaysia and many other countries. Seeing the viability of the sector in these countries where tourism as served as one of the life wire of the country economy, has stirred other country government to invest vastly in the sector. The tourism sector... Continue Reading
      ABSTRACT Tourism as being a great source of revenue in so many countries like Britain, Australia, Malaysia and many other countries. Seeing the viability of the sector in these countries where tourism as served as one of the life wire of the country economy, has stirred other country government to invest vastly in the sector. The tourism sector... Continue Reading
    INTRODUCTION The dictionary defines accident as “an unexpected and undesirable event, a mishap, unforeseen and without apparent cause. The mounting toll of Road Traffic Accident (RTA) deaths in Nigeria has public health problem, which requires urgent attention since these deaths are preventable. The pattern of scold sustained in these fatalities... Continue Reading
    DESIGN AND IMPLEMENTATION OF COMPUTERIZED INFORMATION MANAGEMENT SYSTEM IN SEISMIC DATA PROCESSING (A CASE STUDY OF INTEGRATED DATA SERVICES LIMITED, IDSL BENIN-CITY) ABSTRACT Oil industry is a prominent aspect of modern economy and as it were exploration activities are very important for continuity of oil production. The exploration activities... Continue Reading
    ABSTRACT Oil industry is a prominent aspect of modern economy and as it were exploration activities are very important for continuity of oil production. The exploration activities involve the acquisition of data and processing. As exploration activities increases in the modern world, the computer manufacturers are also working hard to produce... Continue Reading
    CHAPTER ONE INTRODUCTION 1.0 Introduction Data Mining (DM) really gained a lot of prominence in the society as it helped make prediction methodologies easier in various fields. Data mining may be viewed as the extraction of patterns and models from observed data. Data mining tools aid the discovery of patterns in data. Gartner, the global leader... Continue Reading
    CHAPTER ONE 1.0        INTRODUCTION In the past, security was simply a matter of locking the door or storing files in a locked filing cabinet or safe. Today, paper is no longer the only medium of choice for housing information. Files are stored in computer databases as well as file... Continue Reading
    A CASE STUDY OF LEECON FINANCE AND INVESTMENT LTD ABSTRACT Having discovered the importance of computers in al ranks and aspects of life, computer system is applicable to almost all human activities and has been employed to automats most activities especially in areas were management... Continue Reading
    ABSTRACT Having discovered the importance of computers in al ranks and aspects of life, computer system is applicable to almost all human activities and has been employed to automats most activities especially in areas were management data is of outmost importance. Due to unauthorized access to data in database, repose disclosure or modification... Continue Reading
    ABSTRACT Streaming media is multimedia that is constantly received by and presented to an end-user while being delivered by a streaming provider. The name refers to the delivery method of the medium rather than to the medium itself. The distinction is usually applied to media that are distributed over telecommunications networks, as most other... Continue Reading