|
|
|
Check out some of the past Ask the expert columns and industry white papers on active data warehousing.
|
Active data warehousing:
from nice to necessary
Operating an intelligent enterprise enabled by an active data warehouse is no longer an option.
|
Supplying intelligence
Supply chain management software improves operations.
|
The .NET result
One way to simplify data access for software developers is the .NET Data Provider for Teradata.
|
Tech support
Understand how to best provision AMP worker tasks.
|
|
|
|
|
|
Ask the expert: The chronicles of active data warehousing
Build your own reference library.
If you're looking for articles to help you keep track of the advancements in active data warehousing or just wanting to learn more about it, check out the items below.
We've already done the research for you to build this collection that includes Todd Walter's previous Ask the expert columns on the subject as well as other articles from Teradata Magazine and a variety of items from other trusted industry sources.
We've even arranged them for you by category. Select any topic below to find out more. Start browsing and have fun!
White Paper—Current practices in active data warehousing: An update, by Dr. Richard Hackathorn,
Bolder Technology
An update to a 2002 report on the critical management and technical issue patterns regarding the adoption of active data warehousing.
(June 2006)
Getting a handle on data
Travelocity handles a move toward an active data warehouse with aplomb and finds that a collaborative effort between business and IT can lead to success.
(Teradata Magazine, Q1 2006)
Active and right-time data warehousing defined, by Dan Linstedt, Myers-Holum
Find out what active data warehousing and (real-time) right-time data warehousing mean to the enterprise.
(B-EYE Network, Q1 2006)
White
Paper—Right-time business intelligence: Optimizing the business decision
cycle, by Judith Davis, B-EYE Network
This paper provides a wealth of information about designing, implementing and managing a right-time business intelligence (BI)/data warehousing (DW) effort and describes how Teradata's active data warehouse strategy delivers enterprise intelligence.
(January 2006)
White Paper—Active data warehousing: The ultimate fulfillment of the operational data store,
by Claudia Imhoff, Intelligent Solutions
Active data warehousing enables data in
the static snapshots and in live, current
records to co-exist in a single environment.
The active data warehouse: An interview with Stephen Brobst, Teradata CTO
A Q&A about how businesses should respond to the growing volumes of data to support real-time decisions.
(Intelligent Enterprise, October 2005)
Getting active, by Michael Gonzales,
Hands-On BI
Understand the choices for integrating tactical and strategic data into advanced business intelligent (BI) applications that can be invoked on demand.
(DB2 Magazine, Q1 2005)
The data strategy advisor: Is your data warehouse active? by Lou Agosta
What does it take to be an active data warehouse with "closed-loop processing"?
(DM Review Magazine, April 2004)
Ask the expert: Out of hiding: The active data warehouse comes front and center
This article discusses the wide range of users and business processes that can be supported as enterprise data warehouses evolve into active data warehouses.
(Teradata Magazine, Q2 2003)
Ask the expert: ODS Origami
Changing business requirements require an integrated information source to answer operational questions for the enterprise. Teradata has responded by folding the operational data into the enterprise data warehouse.
(Teradata Magazine, Q2 2002)
The five stages of an active data warehouse evolution
Stephen Brobst and Joe Rarey define the five stages for evolving to active data warehousing.
(Teradata Magazine, Spring 2001)
Ask
the expert: Realizing the active warehouse: New support in V2R4 helps
put active warehouse plans into action.
The winning companies in the new millennium will be those that use their data to give customers value. Those that do will reap the benefits of cost savings, waste reduction, customer acquisition and loyalty.
(Teradata Magazine, Q3 2000)
Ask
the expert: Meeting the performance challenge
An active data warehouse requires proper enterprise data management and performance to satisfy the demands of today's business. Teradata Warehouse 8.0 has new functionality and enhanced performance to enable efficiencies in decision-making throughout the enterprise.
(Teradata Magazine, Q3 2004)
Ask the expert: Teradata Warehouse 7.1: Depth, breadth, strength
Although the concept of active data warehousing is now well-established, the requirements on the underlying technologies continue to increase. Take a look at the Teradata Warehouse 7.1 suite of products.
(Teradata Magazine, Q1 2004)
Ask the expert: Strategically tactical
Teradata Warehouse 7.0 adds functionality, scalability,
performance and management specifically for the mixed workload of strategic
and tactical query support. (Teradata Magazine, Q1 2003)
Ask the expert: Teradata Warehouse 7.0—Better at
being the best
With Teradata Warehouse 7.0, Teradata is releasing the
next installment for supporting active data warehousing making every aspect
simpler, faster, more economical and easier to implement. (Teradata
Magazine, 3Q 2002)
Ask
the expert: Teradata Warehouse 6.1—The story continues
Teradata Warehouse 6.1 supports every aspect of active
data warehousing, from keeping the data current to making sure it is always
available to the users, from the biggest data mining problems to short
tactical requests for data. (Teradata Magazine, 3Q 2001)
Ask the expert: The ins and outs of the Teradata active warehouse
A successful data warehouse thrives on the constant inflow of new data.
Teradata's tools for moving data into and out of the data warehouse ensure
that the right data is available at the right time. (Teradata Magazine,
Q1 2001)
Choosing wisely: As your Teradata Warehouse matures, what data acquisition and integration strategy best suits your enterprise?
Teradata provides a wide variety of solutions with the right tools and
partner products to support the shift from simple data acquisition to
complex and near real-time data integration. (Teradata Magazine,
Q1 2005)
Ask the expert: Managing the active data warehouse more easily
Teradata Warehouse 8.1 focuses on making an active data
warehouse easier to manage and easier to build. It brings new capabilities
to workload management, system operations, performance and ease of building
or porting applications. (Teradata Magazine, Q3 2005)
Ask the expert: Extensibility—Add capabilities to the data warehouse dynamically with Teradata's extensibility features
Like the power drill, Teradata's extensibility features allow capabilities
to be added to the data warehouse dynamically, taking advantage of Teradata's
built-in parallelism and scalability, putting the full power of the Teradata
MPP platform to work on the task and opening that power up to anyone with
a new problem to solve. (Teradata Magazine, Q1 2006)
White Paper—User Defined Functions: Extend the power of Teradata database
Scalar and aggregate user defined functions (UDFs) are powerful tools for creating extensions to Teradata Database SQL when built-in functions cannot satisfy all of your needs. UDFs can be written to leverage Teradata Database's ability to store mass quantities of data and allow you to take full advantage of new, nonstandard data-type support. Businesses can write UDFs to maximize the return on their Teradata investment by allowing them to better utilize the data that are already stored in their data warehouse.
White Paper—ANSI Database Triggers
Accommodating a customer within minutes of an event represents an active data warehouse. Database triggers are a key component of an active data warehouse. A trigger is a device used to release or activate a mechanism. A database trigger is a set of synchronous structured query language (SQL) statements that execute automatically when a specific operation, such as changing data in a table, occurs.
White Paper—Event-based applications
With the advent of Teradata Database V2R6, the functionality of the active data warehousing is extended to enable business decision making with event-driven triggers to initiate fully automated decision processes.
Getting support from the active data warehouse: Queries and workload management are the keys to successful active data warehousing
Queries and workload management are the keys to successful active data
warehousing. (Included with this article is a supporting sidebar on Teradata
Active System Management) (Teradata Magazine, Q3 2005)
The wild world of mixed workload: Priorities and resources learn to get along
Essentially, an active data warehouse is an ecosystem full of diverse
activities. DBAs must understand how different expectations can coexist,
and then impose some level of guidance in order to sustain the system.
In the Teradata Warehouse, this guidance takes the form of workload management.
(Included with this article is a supporting sidebar on Teradata Dynamic
Query Manager and Teradata Priority Scheduler) (Teradata Magazine,
2Q 2003)
White Paper—Teradata Active System Management (ASM): High-level architectural overview
This white paper provides a high-level overview of a new architecture
designed for managing workloads in a Teradata Database—Teradata
Active System Management.
White Paper—Introduction to Teradata's Priority Scheduler
Implementers have traditionally separated tactical and strategic work onto different platforms due to the fear that short, tactical queries will be swallowed up by more complex resource-intensive strategic work. Teradata Warehouse users implementing an active data warehouse have successfully overcome this concern by using the Priority Scheduler to manage their mixed workloads.
White Paper—Teradata Database Queue Tables
With queue tables, the Teradata Database provides the capability to run real-time, event-driven active data warehouse activity while still having access to historical data providing the capability to make more effective business decisions in real-time processing environments.
Teradata's
Real-Time Enterprise Reference Architecture: A blueprint for the future
of IT.
An active data warehouse provides a robust yet flexible platform for delivering
decision-making services to the real-time enterprise. Let's walk through
the various elements of Teradata's Real-Time Enterprise Reference Architecture.
(Teradata Magazine, Q1 2005)
The evolution of application development for Teradata: Teradata Application Platform
This article describes the Teradata Application Platform which provides
an easy-to-use, plug-in architecture for developers who create or re-architect
Teradata-based applications as reusable components. (Teradata Magazine,
Q1 2005)
White Paper—Teradata Application Platform: Accelerating application development and deployment
Teradata Application Platform provides organizations with an easy-to-use Teradata-based framework for developers creating or re-architecting existing Teradata-based Web services. Developers create functions (like logging in) once, store them in the Teradata Application Library and reuse them in future applications. This user-friendly platform significantly increases Teradata's business value to an organization, saving approximately 30% of application development time.
White Paper—The Evolution of Application Development for Teradata
Teradata Application Platform provides an easy-to-use, plug-in architecture for developers who create or re-architect Teradata-based applications. It facilitates and accelerates application development by providing common semantics for describing Teradata applications, components and frequently-used base services.
White Paper—Enterprise Application Integration and Active Data Warehousing
Leveraging information assets with an Active Data Warehouse in support of tactical decision making requires that the business intelligence (BI) solution within an enterprise cooperate more closely with OLTP applications to facilitate near real-time data acquisition as well as delivery of decisions. Enterprise Application Integration (EAI) plays a critical role in providing seamless integration of decision-making capability with traditional bookkeeping systems within an enterprise.
Going steady: Look inside the future of business continuity solutions
Teradata's Business Continuity Solutions—including dual-active systems—do
not simply address loss prevention and disaster recovery issues. They
also represent a complete, turnkey solution for corporations that seek
continuous availability for applications and users and an end to all outages,
planned and unforeseen alike. (Teradata Magazine, Q1 2006)
Ask the expert: Data warehouse availability—Survival of the
prepared.
A closer look at the availability features Teradata offers to support
the lifecycle of your data warehouse as it matures into an integral part
of the real-time enterprise. (Teradata Magazine, Q2 2005)
Ask the expert: Teradata: It's there when you need it
A successful active data warehouse provides business-critical access to
the data warehouse. The technology managing the data and supplying the
organization with the answers it needs to do business must deliver a very
high level of reliability and availability. (Teradata Magazine,
2Q 2002)
White Paper—Implementing the Teradata Dual Active Solution
The Teradata approach differs significantly from traditional dual-system solutions. The Teradata Dual Active Solution allows you to use the secondary system in day-to-day production, bringing a positive return on investment (ROI) that is unachievable with a passive system that acts only as an insurance policy.
White Paper—Single system availability features
In the past, a data warehouse was used primarily in back-office business processes. By contrast, an active data warehouse is an operational system used during interactions with customers, suppliers, employees and business partners. As a result, requirements for higher levels of availability are emerging for the active data warehouse. An active data warehouse built with NCR servers and the Teradata Database offers levels of data availability expected in a world-class operational system.
Podcast—Active enterprise intelligence and the real-time enterprise: An interview with Randy Lea, VP of product and services marketing for Teradata, by Claudia Imhoff, Intelligent Solutions
A discussion about Teradata's vision for active enterprise intelligence and the real-time enterprise.
(B-EYE Network)
Podcast—The ROI case for an active enterprise data warehouse
Rob Armstrong gets down to basics in this podcast as he discusses the return on investment (ROI) potential of an active enterprise data warehouse and why it's an important contributor to overall organizational success.
T
© Teradata Magazine-June 2006
back to top
|
Quick Links
Print 
Send to colleague
E-mail us
