Showing posts with label characteristics. Show all posts
Showing posts with label characteristics. Show all posts

Wednesday, October 21, 2009

characteristsics of groupwork page 436

  • performs a task
  • may be located in different locations
  • may work at different times
  • work for the same of different orgs
  • groups is remporary or permanent
  • can span several managerial levels
  • may be synergy or conflict
  • creates gains/or losses in productivity
  • may have t be done quickly
  • may be impossible or too expensive for all team members to meet in one location face to face
  • needed data may come from many different sources, including external ones
  • expertise of non team members maybe required
  • should concerntrate on decision making

Friday, September 18, 2009

On-Line Analytical Processing






















Four Main Characteristics of OLAP
  • Use multidimensional data analysis techniques
  • Provide advanced database support
  • Provide easy-to-use end user interfaces
  • Support client/server architecture
OLAP Architecture
  • OLAP Graphical User Interface (GUI)
  • OLAP Analytical Processing Logic
  • OLAP Data Processing Logic
OLAP systems are designed to use both operational and Data Warehouse data.

Characteristics of the Data Warehouse


The Data Warehouse is a database that provides support for decision making.

In simple terms, a data warehouse (DW) is a pool of data produced to support decision making; it is also a repository of current and historical data of potential interest to managers throughout the org.

Integrated
  • Integration is closely related to subject orientation. Data warehouses must place data from from different sources into a consistent format. To do so they must deal with naming conflicts and discrepancies among units of measure. A data warehouse is assumed to be totally integrated.

Subject-Oriented
  • Data are organised by detailed subject such as sales, products or customers, containing only information relevant for decision support. Enables users to determin not only how the business is performing but why. differs from an operation database in that most operationAL databases have a product orientation and are tuned to handle transactions that update the database. Comprehensive view of the organisation.

Time Variant (time series) (built-in time aspects)
  • Maintains historical data. Does not necessarily provide current status (except in real time systems). They detect trends, deviations long-term relationships for forecating and comparrisons, leading to decision making. There is a temporal quality to every data warehouse. Time is the one important dimension that all data warehouses must support. Data for analysis from multiple sources contain multiple time points (daily, weekly, monthly).

Non-Volatile (can't be changed)
  • After data are enetered into a data warehouse, users cannot change or update the data. Obsolete data are discarded, and changes are recorded as new data. Enables the data warehouse to be tuned almost exclusively for data access.
Summarized
Not normalized
Sources
Metadata
(Data about data)

Thursday, September 17, 2009

Why do Management Roles need Decision Support?

Decision support = helping managers make better decisions.

  • A wrong decision can have far-reaching consequences.
  • No one person can remember (and recall) everything
  • Frequently some form of calculating will be necessary
  • A decision may be needed urgently
What form of support is needed?

Information that…
  • is accurate
  • is up-to-date
  • is easy to assimilate
  • is relevant
  • has quick and easy access to specific records