X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 data warehouse concepts olap

Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Warehouse Management Systems (WMS)

A warehouse management system (WMS) should provide database and user-level tools in order for a company to optimize its storage facilities while at the same time providing user level task direction and activity support. The WMS should enable warehouse operators to optimize pick, put-away, and replenishment functions by employing powerful system logic to select the best locations and sequences. 

Evaluate Now

Documents related to » data warehouse concepts olap

Best Practices for a Data Warehouse on Oracle Database 11g


Companies are recognizing the value of an enterprise data warehouse (EDW) that provides a single 360-degree view of the business. But to ensure that your EDW performs and scales well, you need to get three things right: the hardware configuration, the data model, and the data loading process. Learn how designing these three things correctly can help you scale your EDW without constantly tuning or tweaking the system.

data warehouse concepts olap  Practices for a Data Warehouse on Oracle Database 11g Best Practices for a Data Warehouse on Oracle Database 11g If you receive errors when attempting to view this white paper, please install the latest version of Adobe Reader. Oracle has been helping customers like you manage your business systems and information with reliable, secure, and integrated technologies. Source : Oracle Resources Related to Data Warehouse : Data Warehouse (Wikipedia) Best Practices for a Data Warehouse on Oracle Read More

The Evolution of a Real-time Data Warehouse


Real-time data warehouses are common in some organizations. This article reviews the basic concepts of a real-time data warehouse and it will help you determine if your organization needs this type of IT solution.

data warehouse concepts olap  Evolution of a Real-time Data Warehouse The Evolution of a Real-time Data Warehouse Jorge Garcia - December 23, 2009 Understanding Real-time Systems Today, real time computing is everywhere, from customer information control systems (CICSs) to real-time data warehouse systems. Real-time systems have the ability to respond to user actions in a very short period of time. This computing behavior gives real-time systems special features such as instant interaction: users request information from the system Read More

The Truth about Data Mining


It is now imperative that businesses be prudent. With rising volumes of data, traditional analytical techniques may not be able to discover valuable data. Consequently, data mining technology becomes important. Here is a framework to help understand the data mining process.

data warehouse concepts olap  the presence of a data warehouse or data store containing organizational data. Although data mining can be applied to a wide range of data sources, it is beneficial to start with a data warehouse in which facts and dimensions have been identified and a data cleansing framework is in place in order to ensure good data quality. 1. The Knowledge Base The crust of a data mining system is an organization''s knowledge base. This is the domain knowledge that describes an organization''s data. It includes Read More

The Data Warehouse Institute (TDWI) Conference in San Diego: The Agile Approach to Business Intelligence (BI)


Next month a TDWI World Conference will be taking place in San Diego, California. What’s so special about this conference anyway? The answer is simple:  the general topic is going to be “Creating an Agile BI Environment”. Progressively in the last four or five years, the agile software development methodology has been jumping from the software development area to the data warehouse

data warehouse concepts olap  Data Warehouse Institute (TDWI) Conference in San Diego: The Agile Approach to Business Intelligence (BI) Next month a TDWI World Conference will be taking place in San Diego, California. What’s so special about this conference anyway? The answer is simple:  the general topic is going to be “Creating an Agile BI Environment”. Progressively in the last four or five years, the agile software development methodology has been jumping from the software development area to the data warehouse space, as Read More

SAS/Warehouse 2.0 Goes Live


SAS Institute has announced the production availability of SAS/Warehouse Administrator software, Version 2.0. This new version provides IT the ability to proactively publish data warehouse information and track its usage, plus aggressively manage the process of change in the data warehouse.

data warehouse concepts olap  ability to proactively publish data warehouse information and track its usage, plus aggressively manage the process of change in the data warehouse. Data warehouses and data marts have become a vital component of all successful data mining, knowledge management, business portal, e-intelligence, customer relationship management (CRM) and supplier relationship management (SRM) applications today, said Frank Nauta, product manager for SAS/Warehouse Administrator at SAS Institute. Nauta added, Successful Read More

Data Storage in the Cloud--Can You Afford Not To?


In Data Storage in the Cloud Can You Afford Not To?

data warehouse concepts olap  Afford Not To? Spiraling data storage requirements are straining many companies'' abilities to keep pace. One obvious solution is storage in the cloud—but concerns regarding security, speed, and accessibility remain. Or do they? In Data Storage in the Cloud—Can You Afford Not To? , you''ll discover a cloud storage solution that offers you high-security dual-level encryption (SSLv3 and 256-bit AES) data accessibility from anywhere lower costs due to the economies of scale of cloud storage providers high Read More

How Companies Use Data for Competitive Advantage


Find out in Leveling the Playing Field: How Companies Use Data for Competitive Advantage.

data warehouse concepts olap  Companies Use Data for Competitive Advantage How Companies Use Data for Competitive Advantage Today, many businesses find they are under siege dealing with an explosion of data. Yet the best performing companies are mastering their data—and using it for competitive advantage. How are they able to accomplish this? What best practices, approaches, and technologies are they employing? Find out in Leveling the Playing Field: How Companies Use Data for Competitive Advantage . In this Economist Business Read More

The Value of Big Data


As the use of big data grows, the need for data management will also grow. Many organizations already struggle to manage existing data. Big data adds complexity, which will only increase the challenge. This white paper looks at what big data is, the value of big data, and new data management capabilities and processes, required to capture the promised long-term value.

data warehouse concepts olap  Value of Big Data As the use of big data grows, the need for data management will also grow. Many organizations already struggle to manage existing data. Big data adds complexity, which will only increase the challenge. This white paper looks at what big data is, the value of big data, and new data management capabilities and processes, required to capture the promised long-term value. Read More

Warehouse Management Systems by the Numbers


When it comes to warehouse management systems (WMS), the stats are both shocking and thought-provoking. And although you don't see these stats in the marketing brochures of WMS vendors, you need to think about them before you purchase a WMS.

data warehouse concepts olap  will continue to gather data and take it back to your manager, vice president, president, and so on, only to have them again shoot down the idea of investing in a WMS system. Tell them a WMS system will also lower the total cost per unit shipped; reduce the number of inventory out-of-stocks; improve delivery accuracy and timeliness; increase profitability per order and per customer; reduce customer service cost; reduce phone communication costs; and increase sales. Now is the time to take a serious look Read More

1010data Big Data Warehouse


Designed originally to solve Big Data analytics problems for companies like the New York Stock Exchange, the 1010data platform is a unique approach to data exploration. Built from scratch to deliver instant access to all the raw data in gigantic datasets, 1010data analytics offers a revolutionary a cloud-based platform that unifies data and analytics and provides a single repository for critical information assets.  

data warehouse concepts olap  Big Data Warehouse Designed originally to solve Big Data analytics problems for companies like the New York Stock Exchange, the 1010data platform is a unique approach to data exploration. Built from scratch to deliver instant access to all the raw data in gigantic datasets, 1010data analytics offers a revolutionary a cloud-based platform that unifies data and analytics and provides a single repository for critical information assets. Read More

Agile Data Masking: Critical to Data Loss Prevention and Threat Reduction


Over the past several years data loss and data leaks have been a regular part of headline news. This surge in data leak activity has prompted many organizations to reevaluate their exposure to data leaks and institute automated, agile approaches to data masking. Well-implemented data masking secures data delivery and enhances compliance and security while accelerating data management processes.

data warehouse concepts olap  Data Masking: Critical to Data Loss Prevention and Threat Reduction Over the past several years data loss and data leaks have been a regular part of headline news. This surge in data leak activity has prompted many organizations to reevaluate their exposure to data leaks and institute automated, agile approaches to data masking. Well-implemented data masking secures data delivery and enhances compliance and security while accelerating data management processes. Read More

Increasing Sales and Reducing Costs across the Supply Chain-Focusing on Data Quality and Master Data Management


Nearly half of all US companies have serious data quality issues. The problem is that most are not thinking about their business data as being valuable. But in reality data has become—in some cases—just as valuable as inventory. The solution to most organizational data challenges today is to combine a strong data quality program with a master data management (MDM) program, helping businesses leverage data as an asset.

data warehouse concepts olap  the Supply Chain-Focusing on Data Quality and Master Data Management Nearly half of all US companies have serious data quality issues. The problem is that most are not thinking about their business data as being valuable. But in reality data has become—in some cases—just as valuable as inventory. The solution to most organizational data challenges today is to combine a strong data quality program with a master data management (MDM) program, helping businesses leverage data as an asset. Read More

Developing a Universal Approach to Cleansing Customer and Product Data


Data quality has always been an important issue for companies, and today it’s even more so. But are you up-to-date on current industry problems concerning data quality? Do you know how to address quality problems with customer, product, and other types of corporate data? Discover how data cleansing tools help improve data constancy and accuracy, and find out why you need an enterprise-wide approach to data management.

data warehouse concepts olap  Cleansing Customer and Product Data Developing a Universal Approach to Cleansing Customer and Product Data If you receive errors when attempting to view this white paper, please install the latest version of Adobe Reader. Founded in 1972, SAP has a rich history of innovation and growth as a true industry leader. SAP currently has sales and development locations in more than 50 countries worldwide and is listed on several exchanges, including the Frankfurt Stock Exchange and NYSE under the symbol SAP. Read More

The New Virtual Data Centre


Old-style, one application per physical server data centers are not only nearing the end of their useful lives, but are also becoming barriers to a business’ future success. Virtualization has come to the foreground, yet it also creates headaches for data center and facilities managers. Read about aspects of creating a strategy for a flexible and effective data center aimed to carry your business forward.

data warehouse concepts olap  New Virtual Data Centre Old-style, one application per physical server data centers are not only nearing the end of their useful lives, but are also becoming barriers to a business’ future success. Virtualization has come to the foreground, yet it also creates headaches for data center and facilities managers. Read about aspects of creating a strategy for a flexible and effective data center aimed to carry your business forward. Read More

Achieving a Successful Data Migration


The data migration phase can consume up to 40 percent of the budget for an application implementation or upgrade. Without separate metrics for migration, data migration problems can lead an organization to judge the entire project a failure, with the conclusion that the new package or upgrade is faulty--when in fact, the problem lies in the data migration process.

data warehouse concepts olap  a Successful Data Migration Achieving a Successful Data Migration If you receive errors when attempting to view this white paper, please install the latest version of Adobe Reader. Informatica''s data migration solution decreases the risk and minimizes the errors inherent in data migration projects. At the same time, our solution reduces the costs of data migration projects by automating processes, improving business-IT collaboration, and incorporating proven best practices. Source : Read More