USPS offers innovative example of consolidated, integrated enterprise data warehouse for large operations, managing multiple terabytes of dynamic data for 40,000 users
WASHINGTON — Teradata Corporation (NYSE: TDC), the world’s largest company solely focused on data warehousing and enterprise analytics today announced that the United States Postal Service (USPS) has added a new high-availability capability to its Teradata Enterprise Data Warehouse (EDW) infrastructure. The ‘Dual Active’ system provides USPS analysts with the ability to access detailed operational information, without disruption, for monitoring, analysis, reporting and decision-making purposes. USPS’ new Dual Active infrastructure serves as an award-winning example of an integrated, centralized enterprise data warehouse with significant, tangible economic benefits.
The latest upgrade of the USPS Teradata environment involved deployment of a Dual Active/High Availability infrastructure. This refers to the installation of a second system where data load activity is duplicated resulting in full data synchronization between the primary and secondary sites for disaster recovery and high service availability. With the additional facility, USPS can provide consistent and assured delivery of queries and reporting services required by the users of USPS data warehouse services, as well as enabling a load balancing of user demand between the two sites.
The EDW system now supports the execution of over 1.6 million reports a month for over 40,000 users. USPS has described its data warehouse-based information ecosystem as a mission critical environment which supports 37,000 finance units. For example, having the financial data in the EDW allows USPS to close its books in days, when previously it had taken weeks. This kind of accelerated and highly available platform benefits the USPS in many ways.
“The Teradata data warehouse at USPS is of particular importance, since it validates our successful and long-advocated approach of a consolidated, integrated database platform – and is certainly one of the largest data warehouses in the world,” said Jerry Myers, president of Teradata Government Solutions group. “As more government agencies look for ways to consolidate multiple data sources and integrate data for economic efficiencies and better decision support, we believe they will increasingly turn to Teradata, where our track record of consolidating data marts and centralizing huge volumes of data is impeccable.”
This recent USPS initiative was the basis of a recent award in the Computerworld Enterprise Intelligence program for innovative use of information technology.
The USPS first engaged Teradata in 2000 to develop its Retail Data Mart, which included the consolidation of all point-of-service data into a single data repository. Since then, USPS has grown its Teradata system into a corporate EDW including a number of other business areas, such as financial management, operational decision support and marketing. USPS has also grown its usage of Teradata to support complex analyses as well as reporting to support their decision making processes.
In addition to being the acknowledged leader in data warehousing for commercial purposes, Teradata data warehouses are used at a growing number of government agencies including the Centers for Medicaid and Medicare. In the midst of a historic fiscal crisis for state governments, several states, led by the State of Texas, have used Teradata databases to collectively recover more than one billion dollars in under-reported and unreported tax revenue.
More government organizations are turning to Teradata’s powerful data warehousing computer systems, which integrate data, deliver dramatic efficiencies and drive economic benefits using the most advanced database platforms and software.
Relevant news links
* Look! Teradata information feed to MicroStrategy dashboard at USPS
source: Teradata Press Release