Category Archives: System Managers

What Is Datawarehousing And System Managers?

What Is Datawarehousing And System Managers?

Program management is mandatory for the effective performance of a information factory. The most significant system supervisors are:

Program settings manager

Program arranging manager

Program event manager

Program database manager

Program back-up recovery manager

System Configuration Manager

It settings administrator is mainly accountable for the management over the installation and settings of information factory.

The dwelling of settings administrator is different from one os to another.

In Unix framework of settings, the administrator is different from source to source.

Configuration supervisors have single customer interface.

The consumer interface of settings administrator allows us to management all aspects of the system.

Note: The most significant settings tool is the I/O administrator.
9-important-topics-to-note-in data-mining

System Scheduling Manager

System Scheduling Manager is mainly accountable for the effective performance of the information factory. Its purpose is to schedule ad hoc concerns. Every os has its own scheduler with some form of group management mechanism. The record of features a process arranging administrator must have is as follows:

Work across group or MPP boundaries

Cope with international time differences

Manage job failure

Manage multiple queries

Assistance job priorities

Reboot or re-queue the failed jobs

Inform the customer or a process when job is completed

Maintain the job plans across system outages

Re-queue tasks to other queues

Include the stopping and starting of queues

Log Queued jobs

Cope with inter-queue processing

Note: The above record can be used as assessment factors for the assessment of a good scheduler.

Some essential tasks that a scheduler must be capable of handling are as follows:

Daily and ad hoc query scheduling

Execution of regular report requirements

Data load

Data processing

Index creation


Gathering or amassing creation

Data transformation

Note: If the information factory is operating on a group or MPP framework, then the system arranging administrator must be capable of operating across the framework.

Program Occasion Manager

The event administrator is a kind of a software. The case administrator controls the activities that are described on the information factory system. We cannot manage the information factory personally because the structure of information factory is very complicated. Therefore we need a tool that instantly controls all the activities without any involvement of the consumer.

Note: The Occasion administrator watches the activities situations and deals with them. The case administrator also paths the variety of things that can go wrong on this complicated information factory system.


Events are the activities that are produced by the consumer or it itself. It may be observed that the event is a considerable, visible, incident of a detailed action.

Given below is a list of common activities that are required to be monitored.

Components failure

Running out of area on certain key disks

A procedure dying

A procedure coming back an error

CPU utilization going above an 805 threshold

Internal argument on data source serialization points

Shield storage cache hit percentages going above or unable below threshold

A desk attaining to maximum of its size

Extreme storage swapping

A desk unable to increase due to lack of space

Hard drive presenting I/O bottlenecks

Use of short-term or sort area attaining a certain thresholds

Any other data source distributed storage usage

Our oracle dba training is always there for you to provide a wonderful career for you in this field.

Don't be shellfish...Digg thisBuffer this pageEmail this to someoneShare on FacebookShare on Google+Pin on PinterestShare on StumbleUponShare on LinkedInTweet about this on TwitterPrint this pageShare on RedditShare on Tumblr