This website uses cookies to ensure you have the best experience. Learn more

Data Warehousing In Universities Essay

2843 words - 12 pages

Design and Implementation of a Data Warehouse Prototype for the University of Nairobi within the Context of Relational Online Analytical Processing (Data Analysis)


1.  JORAM KIPLIMO D61/68960/2013 0724431978


PRESENTED TO: Dr. Muranga Njihia

Word count: 2752


Data ware housing is a booming industry with many interesting research problem. The data warehouse is concentrated on only few aspects. The discussion here is about the data warehouse design and usage in the case of the University of ...view middle of the document...

Meta data is contained in database catalogs and data dictionaries.


In the 1970’s virtually all business system development was done on the IBM mainframe computers using tools such as COBOL, CICS, IMS, and DB2. The 1980’s brought in the new mini-computer platforms such as AS/400 and VAX/VMS. The late eighties and early nineties made UNIX a popular server platform with the introduction of client/server architecture.

Despite all the changes in the platforms, architectures, tools, and technologies, a remarkably large number of business applications continue to run in the mainframe environment of the 1970’s. By some estimates, more than 70 percent of business data for large corporations still resides in the mainframe environment. There are many reasons for this. The most important reason, and one that is particularly relevant to our topic, is that over the years these systems have grown to capture the business knowledge and rules that are incredibly difficult to carry to a new platform or application.

This is a strategy for satisfying business needs for complex queries and insightful information with a managed database. In 1990, William Inmon (Inmon, W. H. 1997) coined the phrase “Data warehouse”.

The ultimate goal of data warehousing is the creation of a single, logical view of data, which may reside in many physically disparate databases (Butler Group. 1996). “…traditional database systems are good at recording and reporting what happened. A data warehouse shows why” (Fisher, Lawrence. 1996).

Data warehouses represent the latest great paradigm of database management. The earliest data management systems were hierarchical, run on massive mainframes, and were used primarily for archival purposes. The first big change came in the early 1980’s, with the adoption of relational database systems, which have primarily operational applications. These systems, typically run on minicomputers, are used for online transaction processing (O.L.T.P.). Now come Data warehouses, commonly run on client/server networks of personal computers and more powerful server machines. These latest systems are used for online analytical processing (O.L.A.P.), an essentially strategic application.

Data warehouse organize and store data, from the operational environment, over a long historical time perspective. Consequently, they provide data found in the operational environment. Data warehouse allows user to recognize data they want and, using simple query tools, create their own queries, based on solid repository of integrated, historical data.

The concept of data warehouse is that: It’s a place where data extracted from production systems in the enterprise is stored (Warner, Tim. 1995). The University of Nairobi as a big organization, there are operational systems like: Admission systems, Accommodation system, Examination record system, Master timetable, incorporated on the SMIS (Student Management Information System) etc. all of...

Other Papers Like Data Warehousing in Universities

It560 Week 2 Essay

1830 words - 8 pages played a major role in the successful deployment of data warehousing and BI at Continental. This team’s responsibilities included “managing the warehouse, developing and maintaining ETL processes, and working with the business units.” (Brown, 320) This team also has frequent meetings with the committee to discuss warehouse related issues. I think the team did a good job at identifying the areas of opportunities and incorporating those areas as a

Data Management Essay

632 words - 3 pages . Data Warehousing & Business Intelligence Management 8. Document & Content Management 9. Meta Data Management 10. Data Quality Management Data Management: A Unified Approach Effective , unified Data Management Strategies depends on IT and Business users working together. When teams of IT and business users are formed to guide data management, the results are often positive. “The strategy around data management has to deal with the

Data Mining

1405 words - 6 pages making (Coronel, Morris, & Rob, 2013). Data Warehouse A data warehouse enables an organization to obtain the information about future trends and track customer demands. The key terms that define data warehouse are subject-oriented, integrated, time-variant, and nonupdateable. Each one has its meaning and importance in data warehousing. Subject-oriented – A data warehouse is organized around the key subjects that may include but not


3118 words - 13 pages Data Warehousing Concepts Venkat Jandhyala 2010 1 1.1 INTRODUCTION Data Warehousing Concepts Based on the way the data is used, databases can be classified in two ways: the one that is used for transactions i.e. Online Transaction Processing (OLTP) and the one that is used for analysis Online Analytical Processing (OLAP). As the businesses these days contain huge amounts of data and the users are connected to these databases

Data Mining

1657 words - 7 pages , categorize it, and summarize the relationships identified. Technically, data mining is the process of finding correlations or patterns among dozens of fields in large relational databases. Continuous Innovation Although data mining is a relatively new term, the technology is not. Companies have used powerful computers to sift through volumes of supermarket scanner data and analyze market research reports for years. However, continuous

Audit Design Program Iii

1202 words - 5 pages , and analytical procedures designed for use in the auditing of Apollo Shoes, Inc.’s inventory and warehousing cycle and cash cycle will allow the auditor to obtain data or evidence to substantiate the opinion that will be issued regarding the company’s financial statements and internal controls. These tests and procedures will each meet one or more audit objective by collection of substantial evidence supporting the auditor’s opinion


965 words - 4 pages |PROFESSIONAL SUMMARY: | • Over all 3 Plus years of experience in data warehousing project using of datastage, quality stage and oracle. |KEY SKILLS: | • Experience working with Data Stage

Computer Security In Education

330 words - 2 pages university at risk for lawsuits if the information is exposed. Student’s internet use on campus daily comes in contact with social network targeting, malicious software, infrastructure attacks, phishing, and peer-to-peer file transfers (Rasmussen, 2011). These dangers put not only the students’ computers at risk for security breaches, but the universities’ network as well. The damages resulting from data breaches in college networks are numerous. Not only

Should Universities Be Free?

786 words - 4 pages 04: There are many arguments that suggest that universities should be financed through charging fees to their students. Extract C states that ‘fee income provides the best way of financing the growth of higher education’. One of the most compelling arguments for Universities charging fee’s is the fact that going to university can be considered an investment. The data shown in extract C shows that the average graduate earns £160,000 more than an

Tertiary Packaging Market - Global Industry Analysis, Size, Share, Growth, Trends and Forecast 2016 – 2023

836 words - 4 pages . Additionally, export companies are one of the major users of tertiary packaging. Some of the tertiary packaging is disposable while some can be reused. Corrugated brown carton is one of the most widely used tertiary packaging. Tertiary Packaging Market: Drivers The market for tertiary packaging was driven by various factors such as growing demand from logistics and warehousing activities, rise in export from China and other Asia countries and

Module 4 Review

647 words - 3 pages . Database management systems simplify finding and utilizing safely stored data, enabling the organization to operate quickly and fluently. Furthermore, it acts as an interpreter and medium where data are stored safely and retrieved per the need of the organization. It also aids in applying information system technologies like database management, data warehousing, and other data management tools to the task of managing an organization’s data resources

Related Essays

Data Warehousing Essay

1219 words - 5 pages data warehousing use this broader context. Thus, an expanded definition for data warehousing includes business intelligence tools, tools to extract, transform, and load data into the repository, and tools to manage and retrieve metadata. In contrast to data warehouses are operational databases that support day-to-day transaction processing. In the past, it was very difficult for managers or executives to get {draw:frame} information about

Business Intelligence Essay

739 words - 3 pages transaction processing system (OLTP) database. The topics in this paper address approaches and choices to be considered when designing and implementing a data warehouse. The paper begins by contrasting data warehouse databases with OLTP databases and introducing OLAP and data mining, and then adds information about design issues to be considered when developing a data warehouse with Microsoft® SQL Server™ 2000. A data warehouse supports an OLTP system by

Data Warehousing Essay

1198 words - 5 pages relevant data to prove or disprove this theory is data mining. Data warehousing describes the process of designing how the data is stored in order to improve reporting and analysis. Data warehouse experts consider that the various stores of data are connected and related to each other conceptually as well as physically. A business's data is usually stored across a number of databases. However, to be able to analyze the broadest range of data, each of

Uuuuuuuuuuuuuuuuuu Essay

937 words - 4 pages Universities of Bangladesh. * To identify the Strengths, weaknesses, opportunities and threats and acceptability of this sector to the society. * To observe and analyze the performance of some institutions and make a comparisons between Private and Public Universities Education Systems in the Country. Using Data: In order to make the report more meaningful and presentable, two sources of data and information will been used widely