ipl-logo

OLTP Technology: Data Warehousing

2928 Words12 Pages

1. INTRODUCTION

Data Warehousing is a set of decision support technologies, which allows executives, managers, and analysts to make informed decisions, thereby better and faster. It provides basic planning tools for businessman and his workers organize, understand and use their data to make accurate decisions. Data Warehouse is a database used for analysis and to make reports in a business. It is known to be the database that is maintained individually from the company’s operational database. The information stored in the data warehouse is uploaded from the operational systems. Data Warehouses unite variety of application systems. Data warehousing technologies are successfully used in various industries and companies, as follows:
• Manufacturing …show more content…

As a result a data warehouse does not require transactions processing, recovery, or consensus control mechanisms. It requires only two operations in data accessing: primary loading of data and accessing of data.

The data warehouse supports an online analytical processing that is the OLAP technology, the requirements of which are quite different from those of the on-line transaction processing that is the OLTP technology which is inturn application traditionally supported by the operational databases.

Online transaction processing covers almost all daily operations of a company or industry such as purchases, record-keeping, built-ups, banking, registrations and many more. An on-line transaction processing system is customer oriented and is used for transaction and query processing. It makes the current data that usually are too detailed to be easily used for decision making which concentrates mainly on the current data of a company or industry, without referring to data of other companies. The access patterns of on-line transaction processing systems consist mainly of short transactions. These systems require concurrency control and healing …show more content…

MULTIDIMENSIONAL DATA MODEL
Multidimensional data model is the base for data warehouse and OLAP tools. This model views data in the form of a data cube. A data cube allows data to be modeled and viewed in multiple dimensions. A company can keep records with respect dimensions which are perspectives or entities. A table is associated with each dimension, called a dimension table, which tells about the dimension in detail.
It is usually structured around a subject. Fact table represents this subject. The names of the facts, or measures, as well as keys to each of the related dimension tables is contained in this fact table Source: An Overview of Data Warehousing and OLAP Technology, Surajit Chaudhuri (March 1997)

Business analysts use multidimensional data model grew out of the view of business data popularized by programs like spreadsheet. Rotating is one of the popular operations that are supported by the multidimensional spreadsheet. Rotate which is also called pivot, is a visualization procedure that rotates the data axes in view in order to provide an different representation of the data. Other operations are roll-up, drill-down, slice and dice. The roll-up operation performs the aggregation on a data cube, either by climbing up the concept hierarchy for a dimension or by dimension reduction. Drill-down is the reverse of the roll-up. It moves from less detailed data to more detailed data. A selection on one dimension of the cube is operated by slice. A selection

Show More
Related
1118 Words | 5 Pages

In network computing, DCE (Distributed Computing Environment) is a software that is set up to manage data which is going into and out of

Read More
581 Words | 3 Pages

He uses actual line to define shapes such as the side of the mountain. He indicates depth by causing the area that is

Read More
269 Words | 2 Pages

The mapper extracts the support the call identifier (pass to reducer as a key) and the support call description (pass to the reducer as the value). Each map tasks receives a subset of the initial centroids and is responsible for assign each input data point, to the nearest centroid (cluster). Every time the mapper generate the a key / value pair , where the key is the cluster identifier and the value corresponds to the coordinates of the point. The algorithm uses a combiner to reduce the amount of the data to be transferred from the mapper to the reducer. The Hadoop system follow the different task before approaching the map/reduce

Read More
1351 Words | 6 Pages

Two of the definitions are written in this book. Bradley and Howell state, “dimension is the number of coordinates required to specify a point in the object” (p.64). They also mention some main topics of dimension such as: fractal dimension, a twist on dimension, higher dimension, and entering lower dimension which allows the authors to discuss fractal geometry. A pivotal part of this chapter is Herman Grassmann’s research which describes dimension as a bridge that connects science and faith. Additionally, the material of higher dimensions helps us to understand how God transcends the universe through observable principles such as our senses, and experiences.

Read More
660 Words | 3 Pages

Data management includes: Object storage File system storage Archive storage Data transport Integrated storage Amazon Web Services –Pricing The amazon web services is based on what we use we need to pay that much money for the cloud (Storage space). The price ranges are different from region to region.

Read More
1121 Words | 5 Pages

2.3 Client and Server Architecture 2.3.1 Client A client is the receiving end of a service or the requester of the service. The client is mostly located on another system/computer, which is accessed via a network. It can be a simple application or a whole system that accesses the services provided by the server. It can connect to a server via sockets, shared memory, or internet protocols.

Read More
1229 Words | 5 Pages

Describe different types of business documents that may be produced and the format to be followed for each. There are many different types of business documents that are used daily in business environments, for example; Emails- The fastest way to send documents and information and follow the format of recipient and subject. Spreadsheets- These are used to store information electronically.

Read More
521 Words | 3 Pages

The Equal employment opportunity act 1984 was passed through the Western Australian parliament in 1984 with the purpose of eliminating discrimination and promoting recognition and acceptance of men and women in the workplace. Some of the ways people can be discriminated against are due to sex, race, religion and age. During recruitment for example, employment should be awarded to the best candidate for the position and not because of sex, race, religion or age to name a few. When working we need to respect and accept our colleagues individuality's and treat them in a fair and professional way, treating them how we wish to be treated. If during employment an employee feels they have been treated less favourably then this can be grounds for a complaint to be made.

Read More
176 Words | 1 Pages

Not the best form of interdimensional

Read More
117 Words | 1 Pages

Building a business intelligence system is important to the success of LECAL Cruises, Inc. Implementing a business intelligence system is a way to unify data collection, reporting process, and analysis. By integrating your information into powerful, reliable databases, LECAL Cruises, Inc. can have the competitive advantage over other cruise ship organizations. In some cases, the business intelligence system can be expensive for some organization, but it can improve operational and financial spending in the organization which leads to greater profitability.

Read More
817 Words | 4 Pages

In this fast paced competitive world, human health is considered to be priceless. Health once lost is difficult to be recovered. Therefore a sincere attempt is made to effectively incorporate the benefits of information technology for healthcare to make the wellbeing of humans a priority. Healthcare industry consists of humungous amount of data. A methodical procedure for analyzing, storing, processing and validating this data is necessary.

Read More
764 Words | 4 Pages

ADMS 2511. Management Information System Section Q Raqib Ibrahim Prof. M.Zia ul Haq 215251754 Case Assignment 1 Question A i) Data items: Example of Data in Lululemon case is sales over $1 billion. Data item is a set of description which gives information but does not convey a meaning. ii) Information: As stated above the sales resulted in over $1 billion but actually the 10 percent of those sales were from the Internet store.

Read More
1346 Words | 6 Pages

These concept is also known as STP (Segmentation, Targeting

Read More
1110 Words | 5 Pages

Relational Database Management System: This type of database management system that stores the data in the form of related tables. It is a social database administrator which deals with some typical kind of queries and uses SQL for the development of the database. This type of database is a very powerful database as it deals with the relations which makes the data manipulations easier other than any other database. It has the features of data entry, data deletion, and creating of new entry and records etc. the database provides the ease of accessing and maintaining data easily.

Read More
1058 Words | 5 Pages

Alphanumeric data, Numbers, Characters, Image data, Graphic shapes are the different forms of data. It also includes audio and

Read More

More about OLTP Technology: Data Warehousing

Related Topics

Open Document