Chapter 03: databases and data warehouses: building business intelligence.

Collective information- about customers , competitors, business partners - that gives you the ability to make effective , important and often strategic business decision.

The science of fact-based decision making. It's a growing field of study , research and career opportunities that focuses on integrated use of it and statistical techniques to creat real-time , high-quality, fact-based business intelligence in support of decision making.

We need : first to gather and organize data and information. / Then to have the right IT tools to define and analyze relationships within the collected information. / people ( knowledge workers) use IT tools to creat BI from information.

This is what analytics is all about. They help you build and use BI

1. Online transaction processing ( OLTP ) 2. Online analytical processing ( OLAP )

Is the : 1. Gathering of input information;2.

Processing that information; and 3. Updating existing information to reflect the gathered and processed information.

Databases that support OLTP.

The manipulation of information to support decision making.

That contains information gathered from many operational databases for the support of decision-making tasks.

A collection of information that you organize and access according to the logical structure of that information.

Uses a series of logically related two-dimensional tables or files to store information in the form of a database

Describes each two-dimensional table or file in the relational model.

1) information- stored in a series of 2D tables, files , or relations. 2) logical structure of information.

We first create Data dictionary

Contains the logical structure for the information

A field ( or group of fields in some cases ) that uniquely describes each record.

A primary key of one file that appears in other file.

Rules that help ensure the quality of the information

Helps you specify the logical organization for a database and access and use the information within a database.

-DBMS engine. - Data definition subsystem - Data manipulation subsystem - Application generation subsystem -Data administration subsystem

Accepts logical requests from the various other DBMS subsystem, converts them into their physical equivalent and actually accesses the database and data dictionary as they exist on a storage device.

Deals with how information is physically arranged, stored and accessed on some type of storage device such as a hard disk.

Focuses on how you ( as a knowledge worker ) arrange and and access information to meet your particular business needs.

Helps you create and maintain the data dictionary and define the structure of the files in a database

Helps you add, change , and delete information in a database and query it for valuable information. ( tools here include views , report generator, QBE and SQL ).

A window from it you can see the contents of a database file , make changes, delete, sort information, or query for information.

Helps you quickly define formats of reports and what information you want to see in a report.

Helps you graphically design the answer to a question.

A standardized fourth-generation language found in most DBMSs

Select ...

From ....Where ..

..

Contains facilities to help you develop transaction-intensive application.

A DBMS helps you manage the overall database environment by providing ((facilities)) to do : •Backup and recovery; ~ periodically backup information contained in a database. ~ restart or recover a database and its information in case of failure. • Security management;Controls who has access to what information and what type of access those people have.

• Query optimization; take queries from users and restructure them to minimize response times. • reorganization; continually maintain statistics concerning how the DBMS engine physically accesses information. • concurrency control; ensure the validity of database updates when multiple users attempt to access and change the same information. • change management; allows you to assess the impact of proposed structural changes to a database.

A logical collection of information- gathered from many different operational databases- used to create business intelligence that supports business analysis activities and decision-making tasks

Support OLAP

Software tools you use to query information in a data warehouse.

These tools include:• Query-and-reporting tools ; similar to QBE tools , SQL , and report generators in the typical database environment. • Intelligent agents ; use various artificial intelligence tools to form the basis of information discovery and building business intelligence in OLAP. • Multidimensional analysis ( MDA ) ; slice-and-dice techniques that allow you to view multidimensional information from different perspectives. • Statistical tools ; help you apply various mathematical models to the information stored in a data warehouse to discover new information.

Smaller data warehouses

A subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

Responsible for overseeing an organization's information resource.

Plans for , oversees the development of, and monitors the information resource.

Responsible for the more technical and operational aspects of managing the information contained in organizational databases.