Data Warehouse & Business Intelligence Glossary (B)

B

Backup and Recovery Strategy

A storage and recovery strategy that protects against business information loss resulting from hardware, software, or network faults.

Baseline

1. A starting point or condition against which future changes/enhancements are measured.

2. A named set of object versions which fixes a configuration at a particular point in time. A baseline normally represents a milestone or key deliverable of a project.

Budget

A plan for determining in advance the expenditure of time, money, etc for a particular task/activity or for the whole project/engagement.

Business

An enterprise, commercial entity, or firm in either the private or public sector, concerned with providing products or services to satisfy customer requirements.

Business Constraint

Any external, management, or other factor that restricts a business or system development in terms of resource availability, dependencies, timescales, or some other factors which can also include Regulatory requirements or any compliance.

Business Function

Something an enterprise does, or needs to do, in order to achieve its objectives.

Business Metadata

The information which users can understand and access the data warehouse. It focuses on what data is in the warehouse, how it was transformed, the source, and the timeliness of the data.

Business Priority

A statement of the level or urgency of important business needs and expected deliveries.

Business Organization Type

A classification of a business organization into one of several functional categories. Each business organization type has a distinct set of business requirements. All the business organizations of a certain type will typically require similar applications and system capabilities.

A given business location may house one or more business organization types. Since business organizations may be related in a hierarchy, a high level business organization may be composed of several business organizations of different types.

For the purposes of application architecture analysis and design, it is generally useful to decompose the hierarchy of business organizations until it is composed of atomic organization types.

Business Object

A physical or logical object of significance to a business; for example, a sales order, department, assembly, item, balance, or invoice. A business object is analogous to a class in object oriented terminology.

One of the reporting tool’s name is Business Objects (From SAP). That is different and this term is specific to business and the processes of the business.

Business Process

The complete response that a business makes to an event. A business process entails the execution of a sequence of one or more process steps. It has a clearly defined deliverable or outcome. A Business Process is defined by the business event that triggers the process, the inputs and outputs, all the operational steps required to produce the output, the sequential relationship between the process steps, the business decisions that are part of the event response, and the flow of material and/or information between process steps.

Business Process Re engineering (BPR)

The activity by which an enterprise reexamines its goals and how it achieves them, followed by a disciplined approach of business process redesign. BPR is the method that supports this activity.

Business Rule

A rule under which an organization operates. A policy or decision that influences the process step. This can be done at the enterprise level or at the application level.

Business System

A combination of people and automated applications organized to meet a particular set of business objectives.

Business Unit

Part of an organization treated for any purpose as a separate entity within the parent organization. Examples include a department or distribution center.

Buy-In

The process whereby stakeholders, e.g. end-users as well as executives, come to see the goals of an organizational or change effort as their own; a key component in achieving change successfully.

Bit mapped Index

A sophisticated and fast indexing technique using the binary values of individual bits to indicate values of attributes in relational database tables. This technique is very effective in a Data Warehouse for low-selectivity data, that is, for attribute that have only a few distinct values.

B Tree Indexing

A hierarchical indexing technique based on a inverted tree of nodes containing ranges of indexed values. Going down the hierarchical levels, the nodes progressively contain smaller number of Index values, so that any value may be searched for in a few trails by starting at the top.

Buffer

A region of computer memory that holds data being transferred from one area to another. Data from database tables are fetched into memory buffers. Memory buffer management is crucial for system performance.

Business Intelligence

Business intelligence, is a set of software tools that enable an organization to analyze measurable aspects of their business such as sales performance, profitability, operational efficiency, effectiveness of marketing campaigns, market penetration among certain customer groups, cost trends, anomalies and exceptions, etc. Typically, the term business intelligence is used to encompass OLAP, data visualization, data mining and query/reporting tools.

Some of the examples of the BI tools are Business Objects, Tableau, Cognos, QlikView etc.

Base Fact

A fact that is physically stored in the Data Warehouse, in a fact table.

Business Dimensional Model – BDM

 

A data model that provides a business abstraction of the data needed to support reporting and analysis. The model shows diagrams of dimensions and facts so that the details can be reviewed and discussed in business terms. This also helps separate business perspective from technical implementation details.

Business Dimension

The data elements or attributes used to describe the major categories of reference data, such as customer or product.

Business Fact or Business Measure

The facts, base and derived, that are defined and made available for reporting and analysis.