Teradata

This document describes how to create and render reports using a ROLAP data source built with Analysis Services and Teradata. In addition, KPIs can be built using an ODBC data source that accesses data residing in the Teradata data source utilizing a SQL statement.

This white paper, by Rajeev Rawat of BI Results, describes how an enterprise data warehouse can provide a sustained state of compliance and competitive advantage.

This white paper describes how an enterprise data warehouse can help policy makers and even recipients of government funds have a clear picture of whether or not TARP funds are having the intended effects in the U.S. economy and whether or not the money is being used for the intended purposes.

This paper focuses on a lesser known but increasingly important component of the CIF, the ODS, its role in business management, and the ability of the Teradata technology - Active Data Warehousing - to handle not only the historical, analytical requirements of the data warehouse but also this new need for actionable information found in the ODS.

This paper discusses key features of Teradata Database that extend the parallel, scalable foundation for building ETL solutions in addressing Active Data Warehousing issues.

Financial institutions can benefit from Active Event Management technology, an integrated data environment, and near real-time rules-based risk monitoring and alerting.

Itron and Teradata introduce Active Smart Grid Analytics™ — a powerful platform where business value is derived from analytics driven by smart grid information.

This white paper recommends a structured, enterprise-oriented approach to establish a direct link between the available data resources and the strategic goals of the company.

This paper offers a brief overview of the supply chain management problems that drive out-of-stocks, as well as a discussion of how Teradata has been able to solve these problems at leading retailers.

By utilizing technology, government regulators could create new capabilities to measure, monitor, and regulate risk across the financial system to avoid crisis.

This white paper introduces database triggers and explains all the attributes associated with them. It also discusses the importance of database triggers in commercial applications and how they form the backbone of active data warehousing.

There is an ongoing debate about the scope and influence of relationship marketing and what is meant by customer loyalty. This paper synthesises opinion by arguing that loyalty can only be earned by having a superior customer value proposition in the first place. It describes a four-zone “customer value impact” framework for the measurement, planning and implementation of strategies designed to grow firm customer-centricity.

Traditional media business models are increasingly challenged as consumer eyeballs and advertising dollars move to online, interactive channels. As this shift takes place, the ability to drive intelligent real-time insights from consumer data across multiple channels (and from across the enterprise) becomes increasingly critical as media companies look to improve the monetization of new business models.

 Teradata Database was designed as a parallel database engine which means most wasted energy and unnatural efforts can be eliminated.

This report describes techniques used by business and technical managers to close the cultural divide and get the two groups working together effectively to deliver optimal results for their organizations

This white paper by Barry Devlin proposes Business Integrated Insight or "BI2" as a new architectural model for decision making throughout the enterprise.

This report will help you understand the inherent challenges and available solutions for BI. It discusses common-use cases where SAP and non-SAP products are applied to successful BI solutions.

Selecting a database management system is critical for the success of a data warehouse. The Teradata Database is ideal in this role, delivering unmatched performance even as data volume and users increase.

This white paper by James Markarian, Informatica Chief Technology Officer; Stephen Brobst, Teradata Chief Technology Officer; and Jeff Bedell, MicroStrategy Chief Technology Officer makes recommendations about moving to pervasive BI.

In this white paper you will learn how through a series of interviews conducted with people who have pioneered implementations of active data warehousing, the author concluded companies are implementing active data warehousing successfully and are reaping benefits from these implementations.

This white paper by Dr. Richard Hackathorn focuses on three key customers: e-Bay, Unum Provident, and SUPERVALU, and it assesses whether active data warehousing has become an integral part of their enterprise architecture. It also discusses how they see ADWpractices evolving in the coming years. This paper is an update to Dr. Hackathorn’s 2002 white paper that interviewed customers who were in the early stages of implementing active data warehousing. This current study shows how ADW is becoming mainstream in large organizations.

This white paper, co-authored by META Group and Teradata, explores ten imperatives critical for obtaining Customer Experience Optimization (CEO).

Understanding who your profitable customers are is more important today than ever before. Knowing how long they will remain customers is key. Teradata can help.

Teradata EOM for the mobile channel enables Teradata users to go beyond traditional offer management and personalize offers and communications to customers.

The most-effective way to gain greater business value (delivering consistent, integrated data) is the consolidation of data marts, operational data stores, and other information sources. Doing so not only provides cross-functional data to your users, but also creates a 360-degree view of customers, products and services.

Teradata Warehouse Miner can be used for several common data quality assurance processes, with particular emphasis on data quality assessment. Users of Teradata Warehouse Miner perform data quality functions without additional hardware, software, and associated data management processes.

This white paper outlines the general principles and best practices as a starting point for a complete data quality management program. The overarching benefit of this approach will be that all organizational decisions are rooted in the most complete and up-to-date information available.

Sid Adelman, an independent consultant, provides a fair, balanced view of how to properly conduct a benchmark and what a prospective customer should expect from their benchmarking efforts.  This paper shows how one customer successfully conducted a benchmark.

Positions, compares and contrasts enterprise event management and decisioning functions within banks' Enterprise Business Services architecture.

The Teradata data warehouse maturity assessment is used to define and measure the characteristics of the overall maturity of your data warehousing environment. Learn more about how you can harvest maximum value from your data warehouse.

This paper emphasizes the importance of high-quality data, contrasts competing approaches for managing data quality, clarifies who must lead the data quality program, and helps business managers understand how to improve data quality.

This paper examines how data warehousing tools and techniques can be applied to the prepaid products and services segment of the telecommunications industry.

This White Paper describes both the PCI requirements and a simple, cost effective solution that delivers broad-based compliance with these requirements.

Learn how Teradata Meta Data Services makes it possible to provide both technical and business context for the data in the warehouse, identify impact analysis, manage change, foster reuse and provide extensibility to help meet additional metadata management needs.

In this white paper, Lisa Loftis from Intelligent Solutions discusses how the best contact optimization strategies enable timely, relevant and significant customer communications. Communications are prioritized, not based on campaign profitability, but rather on the ability to identify and act on the best things to talk to the customer about today.

By recognizing the variation in performance requirements for data managed by the data warehouse, we can implement technologies that will reduce the effective price of data warehouses that contain a large proportion of less frequently accessed historical data.

Teradata can help the healthcare industry eliminate siloes and data marts and make the move to EDW and an Active Data Warehousing tm environment.

This white paper describes business intelligence and its evolution from strategic to operational.

This paper, written by Michael Gonzales of The Focus Group, defines the architecture necessary for an enterprise-wide data quality strategy: architecture based on Teradata Warehouse Miner for providing a predictable and timely source of quality data.

To learn how the Teradata EDW Roadmap for the Travel Industry provides value by ensuring a business-driven perspective to data warehouse design and usage, download the pdf.

This white paper describes a method of visual modeling to support understanding and planning of the Enterprise Data Warehouse.

This white paper discusses the use of Event-Based Marketing (EBM) in the financial services industry and identifies the specific benefits of implementing EBM programs to stimulate the main organic growth enablers.

Enterprise data warehouses combined with advanced reporting and business intelligence tools will allow the leaders within the Financial Services community to develop robust, flexible, and automated measurement systems and further exploit the opportunities presented by Event-Based Marketing.

This white paper describes Oracle's Exadata architecture -- its strengths and shortcomings -- when compared to Teradata architecture. A close examination of the architect reveals how little Oracle has really changed, how few of Oracle's data warehousing performance issues are addressed by Exadata, how very few business intelligence queries benefit from it, and how complex and costly Exadata really is.

Read the "Financial Performance Management for the 21st Century" white paper now, to see Ventana's recommendations for CFO organizations, and the crucial role that the enterprise data warehouse plays in providing critical financial performance management capabilities.

This white paper is a good introduction to master data management (MDM). It describes the challenges and drivers of master data management and presents case examples of MDM implementations in organizations.

This report provides an enlightening look at the chaos within an organization's data.  With worldwide spending on packaged software growing to $230 billion in 2006 and business analytics software growing at better than 10% worldwide, there's never been a more appropriate time for the insightful information in this report. We encourage you to put the vital findings in this report to work immediately in your teaching of organizational BI.

Government agencies and medical institutions are facing rising expectations for care along with budgets that cannot possibly keep up. Learn how data warehousing, properly implemented, can help address this crisis in health care by helping to lower the costs of and increase the quality of health care.

This detailed report tells the results of a survey taken among members of OAUG, conducted by Unishphere Media in cooperation with Teradata, to measure the scope and adoption of financial reporting technologies. Read more to learn about the information stemming from this study.

This paper shows how inferior information quality adversely affects risk management. It then discusses ways to assess the quality of risk information in financial institutions as well as showing how to address this problem in a cost-efficient manner.

This white paper describes some of the high-level Teradata business solutions that help to drive customer value and return on investment (ROI) for foodservice companies.

To be ready for Solvency II requires a strategy that saves time, minimizes costs, and accelerates time-to-competitive advantage.

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 ROI that is unachievable with a passive system that acts only as an insurance policy.

Microsoft and Teradata recognize that customers may want to combine both companies' products when building analytic applications. Learn how to build a relational ROLAP solution on a Teradata implementation, one that can provide deeper and wider analytics without being overly penalized in performance.

This paper describes how you can use Oracle and Teradata technologies to improve your analytical OLAP application environment, specifically moving from
MOLAP to Hybrid (HOLAP) solution. This paper is targeted to BI administrators, system integrators and database administrators.

The availability of operational reporting in retailing environments can mean the different between a retailer knowing what to do and doing it.

For Teradata users transitioning to active data warehousing, Priority Scheduler is key to managing diverse work in a single database. It offers a built-in, flexible solution to sharing database resources - a key component for any data warehousing effort.

Knowing about your business sooner, rather than later, provides a competitive edge and enables you to better manage through unexpected situations. Learn why the accepted industry wisdom about low-latency data is rapidly shifting.

An EDM is needed by almost every corporate-wide initiative, and an industry model can facilitate the task of creating an EDM for your organization. If you want to learn how to leverage LDMs in your Enterprise Data Model, download this white paper.

This white paper defines master data management and explores the various scenarios where this issue is gaining attention both from IT and business managers. The challenge for organizations is to align business roles with responsibilities for management of specific master data domains, with IT providing the technical support for the underlying data resources and data models.

This TDWI Best Practices Report written by Phillip Russom, provides insightful answers and draws upon results of an Internet-based survey co-sponsored by TDWI and Teradata. The report shares fascinating results as well as recommendations and a brief review of Teradata MDM.

This white paper, by David Loshin of Knowledge Integrity, explores the challenges associated with inconsistent and unsynchronized data within an enterprise data warehouse environment.

This whitepaper, authored by Greg Sloyer discusses the supply chain planning processes and metrics.

This white paper provides an overview of a Continuous Value Management Process for maximizing the business value of Enterprise Data Warehouse solutions.

Management wants to know the business value of the data warehouse, measured in quantitative terms, with the metrics in the form of Return on Investment (ROI). ROI refers to a few differnet ways of calculating the value of an investment which can be calculated by payback period (break-even analysis), net present value, or rate of return (yield).

Today, data warehouses must absorb new data in near-real time and provide extraordinary performance, squeezing most of the latency out of the process. Being able to provide fresher data enables the data warehouse, in turn, to participate in ongoing operational processes.

This whitepaper is an overview to Oracle Essbase, XOLAP, and Oracle Essbase Studio and how they integrate with Teradata.

This white paper helps answer the key questions about migrating from Oracle to a Teradata solution by profiling three of the more than 150 Oracle customers who have already done so.

An exciting, but challenging environment faces the electronics manufacturing services (EMS) of today. Fueled by the outsourcing trends of high-tech original equipment manufacturers (OEMs) and consumer electronics manufacturers, forecasters predict long-term growth rates of 20–30%.

What should you be doing to maximize the return from your investment in customer profitability measurement?

This paper was developed to help companies critically evaluate and be aware of common tactics to tilt the scales in favor of the vendor. It is important to be able to see through the claims.

Synchronize information for increased agility, productivity, active leadership, and competitive advantage. 

There is no doubt that the mobile channel is emerging as a dramatic, holistic, and powerful method of interacting with your customers. Learn why many companies are dedicating portions of their marketing budgets to mobile communications and are training their marketing executives to the possibilities inherent in the channel.

This white paper discusses risk solution architecture with significant benefits - it not only ensures Basel compliance from the perspective of all three pillars, but also ensures that the investment in Basel can be leveraged to improve business profitability.

This white paper explains the value scalability and performance, availability and reliability, and manageability deliver in an effective enterprise data warehouse platform.

This white paper describes two architectural alternatives for the national IT infrastructure, namely distributed database and enterprise data warehousing.

This white paper provides an overview of the security features and describes scenarios for their usage. The paper will also discuss the independent evaluation of the Teradata Database to the international Common Criteria for Information Technology Security Evaluation (ISO 15408) Standard.

An Active Data Warehouse built with Teradata Servers and the Teradata Database offers levels of data availability expected in a world-class operational system. An ADW with Fallback achieves levels of single system availability unmatched by other RDBMS vendors.

This white paper describes how single-level partitioned primary indexes, introduced in Teradata Database V2R5 and extended to multiple levels in Teradata Database 12.0, provide an opportunity to improve performance of certain queries and to improve the performance of high-volume insert, update, and delete operations.

Neil Raden gives guidance in the best way to propose data warehouse/BI expenditures to CEOs/senior management.

This paper describes the results from functionality and basic performance testing of SQL Server 2005 Analysis Services leveraging Teradata v12. This paper is targeted at Business Intelligence (BI) administrators, system integrators and database administrators.

William McKnight describes Teradata appliances for mid-size companies' use in data warehousing and business intelligence.

Discusses Data Management recommendations for U.S. systemic risk authority.

Arm knowledge workers with data visualization tools using Tableau and Teradata Database.

This white paper details the results of a global survey performed by IDC at the request of Teradata to come up with a “state-of-the-art” picture of organizational use of business analytics to support decision making.

This white paper details the results of a global survey performed by IDC at the request of Teradata to come up with a “state-of-the-art” picture of organizational use of business analytics to support decision making.

A key to eliminating complexity in the area of corporate finance and performance management is to drive toward the use of one simplified, enterprise-wide chart of accounts.

Who are your customers? Which products and services are they buying across your enteprise? Where do they conduct business besides your firm? This white paper describes the benefits of CDI solutions.

This white paper, by James Taylor and Neil Raden, discusses the need for companies to become decision centric by adopting enterprise decision management techniques and technology. It also outlines the benefits of adopting EDM, as well as the risks and issues with adopting EDM and applying technology to automating and improving operational decision making .

The key concept introduced in this white paper is that by using Teradata Active System Management users can analyze both query level information collected over time as well as an existing workload set, convert database settings, regulate workloads, and monitor and report on workload performance.

The Teradata Analyst Pack to enables you to analyze and tune your database queries for better performance. Learn more about its benefits, features and specifications.

The Teradata Analyst Pack to enables you to analyze and tune your database queries for better performance. Learn more about its benefits, features and specifications.

Teradata Plug-in for Eclipse allows developers to leverage the Eclipse IDE to quickly generate Teradata Database objects and Java code. Within a single tool, developers can browse their databases, create objects and Java code, test applications, and run stored procedures

This program establishes an industry standard measure of technical competence for IT professionals using Teradata technology.

This paper presents a solution for increasing the performance of mixed workloads by using the cylinder read feature.

The real cost of the data warehouse is not in the cost of acquiring the software (operating system and DBMS), but in application development and overall management effort. This paper shows you the savings that accrue when constructing your data warehouse using a Teradata Database.

This white paper defines enterprise analytic data sets and how using them conserves resources, including people and systems. To learn more about the advantages, costs, and benefits of this methodology, download the white paper.

To learn how the Teradata EDWR for Financial Services provides value by ensuring a business-driven perspective to data warehouse design and usage, download the pdf.

The Teradata Enterprise Data Warehouse (EDW) Roadmap is a visual planning model showing the alignment of enterprise strategic goals and objectives linked to the supporting data in the EDW. The roadmap will help a company stay on the path supporting its strategic business values based on a foundation of enterprise data.

To learn how the Teradata EDWR for Insurance provides value by ensuring a business-driven perspective to data warehouse design and usage, download the pdf.

To learn how the Teradata EDWR and LDM combination provides value by ensuring a business-driven perspective to data warehouse design and usage, download the pdf.

Learn more about how Teradata logical data models help enterprises cope with abundant data, compressed business cycle times, and constant economic pressures in this white paper.

The ability to create User Defined Functions is an important enhancement to Teradata Database. This white paper provides a high-level overview of the feature in V2R6 and why it is beneficial.

This paper analyzes the root causes for data mart proliferation. It presents a method for developing a data mart consolidation plan and illustrates the potential cost savings and revenue enhancement opportunities resulting from consolidating disparate data marts onto a single, integrated data warehouse.

This white paper presents a high-level description of Teradata's Real-Time Enterprise Reference Architecture.

To learn how Teradata and IBM Information Server, together, can energize your enterprise, empower your employees, and produce a cost-effective return on your investment, download this white.

This paper describes a way to simplify the complex customer demands and transform the blur of technologies into a clear window that delivers true network control.

This white paper focuses on the growing trend of customer communities and how customers are using these communities to discuss products, react to services offered and voice opinions on a company in general.

Examines information management architectures in the finance function in banks, and approaches and barriers to migration to a more efficient Finance Information Factory.

In this paper, Larissa Moss explores the origin and significance of data modeling, as well as the concepts and principles behind the technique. Steve Hoberman then focuses on physical data modeling by describing the various mature and proven database design options available for BI/DW databases.

The purpose of this paper is to explore the changes in marketing information that must accompany the progression of a company from being product- or sales-focused to being customer- or, more particularly, relationship-focused.

The business value question becomes important during the planning and budgeting season. While you may have a handle on what you are spending, you may not understand the benefits you're receiving from the expenditure. An assessment will show you the linkage between technology and revenue generation.

The Teradata CLDM provides a detailed and well-proven data model as a foundation for your organization's enterprise data model that can save you substantial amounts of time and money.

Scalability is a widely used and often misunderstood term. This paper explains scalability as experienced within a data warehouse. It will point to several unique characteristics of the Teradata Database that allows scalability to be achieved.

The goal of this paper is to increase your awareness of how Teradata Healthcare Logical Data Model helps organizations obtain their big picture quicker and more accurately than building an EDM from scratch, thus permitting your organization to answer complex strategic and tactical business questions faster and more accurately.

Teradata MLDM provides the blueprint of the structure and standardization you need to address your most crucial business questions.

This white paper increases your awareness of how the Teradata T&H LDM helps organizations like yours obtain the big picture more quickly and accurately than building an EDM from scratch, thus permitting you to answer complex strategic and tactical business questions faster and more accurately.

Teradata is best positioned to provide a cost efficient, flexible, comprehensive end-to-end TREAD Act solution. This data-driven solution is best positioned to help manufacturers avoid the potential cost of fines and product recalls.

Learn more about how airlines using a Passenger Name Record (PNR) data warehouse can analyze complete, current, and historic data, providing them with information that supports a broad range of capabilities including revenue management and customer management.

This paper focuses upon the value proposition behind the Active Data Warehouse as another phase in the evolution of Business Intelligence in the enterprise.

This TDWI Best Practices report will help you identify the opportunities that BI offers to finance and accounting executives, managers, and analysts; the obstacles in delivering BI to the finance department; and best practices for ensuring a solution’s success.

This white paper, by Jim Sterne of the Web Analytics Assoc.,and Paul Barrett of Teradata, discusses the competitive advantage of getting, integrating and using customer data.

The ability to create User Defined Functions is an important enhancement to Teradata Database. This white paper provides a high-level overview of the feature in V2R6 and why it is beneficial.

It has been a difficult for a database administrator to design and implement database applications that emulate real-world objects or processes using the common structures and data types available in a relational database. Teradata Database now facilitates this object-oriented approach by supporting User-defined Types.

An embedded BI analytics business model, when implemented successfully, has the potential to optimize business performance, dramatically increase an organization’s flexibility and agility, improve customer satisfaction and loyalty, and enhance competitiveness.

This article describes five data warehouse architectures -- independent data marts, data mart bus architecture, hub and spoke, centralized, and federated -- and provides survey data about how successful they are.