StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Business information system - Essay Example

Cite this document
Summary
Data Warehouse is large collection of an organizations past and present Business data. The basic aim of Data warehouses is to provide the facility of business reporting and analysis. A data ware…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER95.7% of users find it useful
Business information system
Read Text Preview

Extract of sample "Business information system"

Assignment Data Warehouse Bill Inmon is the first person who introduced the term Data Warehouse in 1991. Data Warehouse is large collection of an organizations past and present Business data. The basic aim of Data warehouses is to provide the facility of business reporting and analysis. A data ware house can have million of rows of data and its size can be in terabits. It is a relational database so it stores data in from of rows and tables. It uses standard query language. It becomes available 7*24.

It has data size varying from business to business. Like in telecom sector you have lot of data you can not retain it for years, but in insurance business you have keep data of many years (Inmon 1995). In this paper we will discuss different aspects of data warehouse.This section will explain four main characteristics of data warehouse. These characteristics give a more clear view of data warehouse. First characteristic of data warehouse is “Subject Oriented” (Kimball & Ralph 2002), It means data warehouse should be built for a specific subject or domain.

It also means that Data that provides information about the concerning topic/ subject instead of organizations ongoing processes. Second characteristic is “integrated” nature of data warehouse. It Means data that is gathered from different sources are integrated into a single structure. Third characteristic is “Time-variant”: It means all data that is stored in the data warehouse is recognized with a specific time period. Forth and last characteristic is “Non-volatile” nature of data warehouse.

Data is never deleted from data warehouse. But when it exceeds from a certain level, it is archived and stored at differ places (Kimball & Ralph 2002).There is a question about data warehouse: When data warehouse has data in terabits, then how it can handle such amount of data? The answer is: data warehouse uses parallelism approach to handle such amount of data. By this approach data is divided into small parts and parallel unit of data warehouse store retrieve and process them individually (Inmon 1995).

Architecture of data warehouse consists of different logical layers (Inmon 1995). First layer is input or source layer, then processing layer, out put layer, decision support layer, etc. At source layer we have our data sources; these can be data bases, legacy system or data from web. After extracting this data from the source a process of transformation is applied on it to bring it into coherent format. Because data can be extracted from any type of sources, it contains dirty data that must be purified.

After this step data is loaded into data warehouse. These are three steps in which data from sources to data warehouse transformed. These steps are called ETL (extraction, Transformation, Loading) (Inmon 1995). After data loading the data is stored in from rows and columns. Here data can be arranged in two sub parts those called “Data marts”. These can be referred as sub-section (parts) of data warehouse. Like if you have data warehouse of an organization, here you can divide your data warehouse in Accounts, Production, and Sales Data Marts.

This provides ease in data handling, querying, recovery and maintenance. After maintaining your data in data warehouse you apply decision support and decision making techniques on data warehouse, which include data mining, OLAP, querying tools and visualizing techniques. These techniques help in decision making and future perditions about business trends (Kimball & Ralph 2002).We have talked about the design of data warehouse; it has star schema approach for its design methodology. In this schema we have a large single fact table and lots of other tables are connected with it with a single link.

Here we renormalize data to increase the number of table. Increasing the number of tables improves retrieval time. So that data warehouse able to answer the quires with even large amount of data. Data warehouse life cycle is completely opposite to other software development life cycle (Inmon 1991).References 1. Inmon, (1995). Tech Topic: What is a Data Warehouse? Prism Solutions. Volume 1.2. Kimball, Ralph and Ross. (2002). Margy. The Data Warehouse Toolkit Second Edition John Wiley and Sons, Inc.

ISBN 0-471-20024-7

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Business information system Essay Example | Topics and Well Written Essays - 500 words”, n.d.)
Retrieved from https://studentshare.org/miscellaneous/1548275-business-information-system
(Business Information System Essay Example | Topics and Well Written Essays - 500 Words)
https://studentshare.org/miscellaneous/1548275-business-information-system.
“Business Information System Essay Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/miscellaneous/1548275-business-information-system.
  • Cited: 0 times

CHECK THESE SAMPLES OF Business information system

E-bay in the domain of business information system

In addition, today the functions of management information system (MIS) in a business are similar to the functions of heart in the body.... Moreover, the system is anticipated to accomplish the information requirements of a person, a group of individuals, the management processes, the managers and the top management.... This report will assess EBay's business and possible impact of information technology based system on the business.... This report will assess EBay's business and possible impact of information technology based system on the business....
15 Pages (3750 words) Assignment

Theoretical Concept of Business Information System

This paper "Theoretical Concept of Business information system" will give a critical analysis and review of CPS, regarding its use of technology.... Literature review (Theoretical concept of Business information system) Technology is a key to success in today's world (Blaze 2010).... Collaboration with the outside world is impossible due to a lack of a modern system of IT.... They do not have a virtual learning system, and hence open learning and distance learning cannot take place in CPS....
6 Pages (1500 words) Case Study

Developing Business Information System Solutions

Developing Business information system Solutions Contents Contents 2 Answer 1 3 Answer 2 4 Answer 3 5 Answer 4 6 Answer 5 7 References 8 Answer 1 A firm operating in a perfectly competitive market would break even at the point where the Marginal Cost cuts the Average Total Cost curve from below as in the above diagram....
4 Pages (1000 words) Essay

Business Information System Essay

When system analysts and programmers set about the task of designing and developing a new system, they will use a number of tools and techniques to help them some techniques are use full with creating a broad outline or work of a program. ... data processing system is used to take input data, process it and produce output.... hellip; A starting point for system design work is to establish what data processing is needed.... The term data modeling is some times used to describe the technique of looking the system from data handling purposes....
7 Pages (1750 words) Essay

Technology in Jurassic Park

It is a fact that information technology is not only dictating terms in the field of science and business but also information technology is shaping our personal lives.... informationinformation Technology Association of America (ITAA) has defined information technology as the study, design, development, implementation information technology has been instrumental for the improved performance of various companies and business houses across the globe....
6 Pages (1500 words) Essay

The Protection of Business Information System

The paper "The Protection of Business information system " states that the integration of information systems with business operations facilitates the development of a design that improves and maintains business processes.... hellip; Moreover, this has led to a significant dependence between businesses and the information system; thus, when a problem in the information system, the business is affected significantly.... usinesses employ different categories of information system to present data that are gathered from transactions, and for making decisions on certain areas of the business....
6 Pages (1500 words) Assignment

Business Information System - Competitive Advantage over Competitors

This paper "Business information system - Competitive Advantage over Competitors" focuses on the Business information system (BIS) which is only as good as the people who designed it in the first place.... nbsp;… This means a good BIS software should take into account not only a firm's present needs for the system but future uses as well.... This means a good accounting system must be able to provide timely and accurate data to guide management in making its important decisions that will determine whether the firm will be profitable or not or if it will survive for another year despite all the competitive odds against it....
8 Pages (2000 words) Assignment

Developing Business Information System Solutions

The paper "Developing Business information system Solutions" gives a description of the business whose information system we are developing.... The second part highlights the key information required to successfully operate the business, followed by general Business information system requirements.... It is important to note that data for one level of an information system may be information for another.... For example, data input to the management level is information output of a lower level of the system such as operations level....
9 Pages (2250 words) Term Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us