Terms pertaining to data warehousing and e-business

Atomic Data

Data elements that represent the lowest level of detail. For example, in a daily sales report, the individual items sold would be atomic data.

Braking Mechanism

A software device that prevents users from querying the operational database once transaction loads reach a certain level.

Cooperative Processing

A style of computer application processing in which the presentation, business logic, and data management are split among two or more software services operating on one or more computers. In cooperative processing, individual software programs (services) perform specific functions that are invoked by means of parameterized messages exchanged between them.

Enterprise Resource Planning (ERP)

ERP systems are comprised of software programs, which tie together all of an enterprise’s various functions – such as finance, manufacturing, sales and human resources. This software also provides for the analysis of the data from these areas to plan production, forecast sales and analyze quality.

Intelligent Agent

A software routine that waits in the background and performs an action when a specified event occurs. For example, agents could transmit a summary file on the first day of the month or monitor incoming data and alert the user when certain transactions have arrived.

Normalization

The process of reducing a complex data structure into its sim plest, most stable structure. In general, the process entails the removal of redundant attributes, keys, and relationships from a conceptual data model.

Subject Oriented Databases

Rather than build one massive, centralized data warehouse, many companies are building numerous subject-oriented warehouses to serve the needs of different divisions.

Source: DM Review.com

Would you recommend this article?

Share

Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.


Jim Love, Chief Content Officer, IT World Canada

Featured Download

Featured Articles

Cybersecurity in 2024: Priorities and challenges for Canadian organizations 

By Derek Manky As predictions for 2024 point to the continued expansion...

Survey shows generative AI is a top priority for Canadian corporate leaders.

Leaders are devoting significant budget to generative AI for 2024 Canadian corporate...

Related Tech News

Tech Jobs

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

Tech Companies Hiring Right Now