About
Subscribe

Teradata announces Logical Data Model for travel

By Alison Bull Communications
Johannesburg, 04 Dec 2001

Teradata, a division of NCR Corporation represented exclusively in SA by National Data Systems (NDS), has introduced the TeradataTravel Logical Data Model (LDM) 1.0. This will assist airline, travel agency, bus, rail, cruise line, lodging and car rental companies to create an architectural blueprint of the information requirements for a Teradata warehouse prior to implementation.

An integrated, subject-oriented base of strategic business information, the Teradata Travel LDM offers a single view of the customer experience to employees across an enterprise. An airline, for example, can track customer activity throughout the travel cycle, including Web-based travel planning, purchasing tickets at an airport or agency, travelling to the destination and interacting with the company after travel has been completed. The airline can then utilise this information to form better customer relationships and create more targeted marketing campaigns.

The Teradata Travel LDM offers insights that drive improved company performance. Customer value can be measured based on revenue generated, rather than on the traditional mileage benchmarks. Distressed inventory on specific dates or flights can be matched to customer interests that have been traced through the Teradata Travel LDM, and targeted communications can be developed to encourage purchases. The impact of operational performance (lost luggage, delayed flights) on future customer choices can be captured and analysed, allowing the travel company to take steps that will inevitably improve its competitive position.

The Teradata Travel LDM is modelled to support everyday questions, such as "who are my most valuable customers" or "which marketing campaigns and promotional programs have been the most successful". Companies can also handle complex queries, such as analysing the effects of operational impacts to revenue and customer behaviour, by addressing questions that require data integration across and between departmental silos. Built around a common customer core, the Travel LDM organises a company`s essential data around 17 subject areas that support privacy, click stream/Web analytics and customer relationship management (CRM).

Teradata has created the Travel LDM based on extensive knowledge in designing and implementing hundreds of logical data models for companies in multiple industries. By graphically depicting the information requirements and their relationship to one another, the Teradata Travel LDM 1.0 helps users visualise how information is organised within the data warehouse environment. This creates stability in the data warehouse, reduces overall development time, increases speed to market and eliminates the risk of costly redesigns down the road.

"This complex logical data model was designed by LDM and industry experts specifically for airlines and other travel companies who require collecting information about the customer experience across the enterprise. Since the Travel LDM maps the business processes before the Teradata warehouse is ever built, it will shave months of development time off an enterprise data warehouse implementation, thus delivering greater return-on-investment benefits faster," said Simon O` Hagan, general manager of the Teradata Solutions Division at NDS.

Modular in nature, the Teradata Travel LDM is designed in "third normal form" for flexibility and a changing environment. As a company adds new business or types of customers, changes products or distribution channels or varies its customer campaigns, the LDM is easily extended by adding modules, entities or sets of attributes. The Teradata Travel LDM provides the foundation for building an enterprise data warehouse and will continue to be enhanced to support new additions to the Teradata Travel Solution Portfolio.

Teradata solutions for the travel and transportation industry offer airlines, travel suppliers and distributors, and transportation companies, such as rail, courier and trucking companies, industry-specific tools, processes and services. Teradata`s proven methodology has been successfully implemented at leading international travel and transport companies, including seven of the nine most profitable international airlines - eight of the 13 with the highest operating revenue. The largest data warehouse in the travel and transportation industry is a Teradata warehouse, supporting over 4 000 users.

About Teradata Division Teradata, a division of NCR Corporation, offers powerful analytical solutions that help businesses drive growth. Teradata solutions include the Teradata database, and analytical applications for customer relationship management, operations and financial management, business performance management and e-business.

Share

NCR Corporation

 

NCR Corporation (NYSE: NCR) is a leader in providing Relationship Technology solutions to customers worldwide. NCR`s Relationship Technology solutions include the Teradata database and analytical applications such as customer relationship management (CRM) and demand chain management, store automation systems and automated teller machines (ATMs). The company`s business solutions are built on the foundation of its long-established industry knowledge and consulting expertise, value-adding software, global customer support services, a complete line of consumable and media products, and leading edge hardware technology. NCR employs 33 300 in more than 100 countries, and is a component stock of the Standard & Poor`s 500 Index.

Editorial contacts

Alison Bull
Alison Bull Communications
(011) 783 0594
abcomms@iafrica.com
Simon O`Hagan
National Data Systems
(011) 373 4148
simono@nds.co.za