Computers: Data Warehouse Database and OLTP Database

Data Warehouse Database and OLTP Database

Written by Exforsys.com

In this tutorial we will learn about repparttar

differences between Data Warehouse database and OLTP database and repparttar 107220

objectives of a Data warehouse and Data flow. The data warehouse and repparttar 107221

OLTP data base are both relational databases. However, repparttar 107222

objectives of both these databases are different.

The OLTP database records transactions in real time and aims to automate clerical data entry processes of a business entity. Addition, modification and deletion of data in repparttar 107223 OLTP database is essential and repparttar 107224 semantics of repparttar 107225 application used in repparttar 107226 front end impact on repparttar 107227 organization of repparttar 107228 data in repparttar 107229 database.

The data warehouse on repparttar 107230 other hand does not cater to real time operational requirements of repparttar 107231 enterprise. It is more a storehouse of current and historical data and may also contain data extracted from external data sources.

The differences between these two relational databases, is tabulated below for information.

Differences Data warehouse database OLTP database :

Data warehouse database: Designed for analysis of business measures by categories and attributes Optimized for bulk loads and large, complex, unpredictable queries that access many rows per table.

Loaded with consistent, valid data; requires no real time validation

Supports few concurrent users relative to OLTP Supports thousands of concurrent users.

OLTP database : Designed for real time business operations.

Optimized for a common set of transactions, usually adding or retrieving a single row at a time per table.

Optimized for validation of incoming data during transactions; uses validation data tables. Supports thousands of concurrent users.

Objectives of a Data warehouse and Data flow

The primary objective of data warehousing is to provide a consolidated, flexible meaningful data repository to repparttar 107232 end user for reporting and analysis. All other objectives of Data warehousing are derived from this primary objective. The data flow in repparttar 107233 warehouse also is determined by repparttar 107234 objectives of data warehousing.

The data in a data warehouse is extracted from a variety of sources. OLTP databases, historical repositories and external data sources offload their data into repparttar 107235 data warehouse. Achieving a constant and efficient connection to repparttar 107236 data source is one of repparttar 107237 objectives of data warehousing. This process is known as Data Source Interaction.

Beware of Wireless Routers

Written by Brian Renner

Before you freak out and throw your router out repparttar

window, make sure you get all repparttar 107219

facts straight about wireless routers.

Wireless routers are great, they reduce clutter, allow you to easily use laptops or PDAs around repparttar 107220 house, and save money on wiring and wiring installation.

However, when repparttar 107221 big router companies had repparttar 107222 decision of whether to make Wireless Routers easy to install or secure, repparttar 107223 chose easy to install.

What does this mean?

This means that rather than having you go through a lengthy process of encrypting your signal and preventing outside users from taking your internet connection, repparttar 107224 big wireless companies (Microsoft, Intel, Linksys, D-Link, and Netgear) wanted to make installation a snap! Did you ever notice how easy it was to get up and running with a wireless router right out of repparttar 107225 box? Once you power up repparttar 107226 router and connect your DSL line or Cable Modem, that signal is being broadcasted in every direction up to an average of 300 feet. That means your next door neighbor can easily pick up on your signal and surf repparttar 107227 web for free!

Even worse, this means that if someone using your connection is doing something illegal, whoever traces that activity ends up knocking on your door since repparttar 107228 internet connection is in your house!

Protect yourself by doing 2 things:

1. Encrypt Your Connection

This will vary between router manufacturers and models, but if you refer to your manual then it will explain it in detail. You'll basically go into repparttar 107229 settings through repparttar 107230 computer that's hard wired to repparttar 107231 router and enter a password that will be further scrambled into what's called a Network Key. This network key is a series of letters and numbers that are then entered into each computer you wish to have access to repparttar 107232 internet through your router.

Cont'd on page 2 ==>