© 2006 AT&T. All rights Reserved.

AT&T SouthwestAT&T SouthwestVDB and ERDB SystemsVDB and ERDB Systems

Page 2

Today’s Environment

Today’s ALI database systems perform three main functions:

1. Validation of a subscriber’s street address against an MSAG.

2. Assignment of an ESN for call routing and Selective Transfer.

3. Management and delivery of the record associated with a Telephone Number.

Page 3

Here comes Tomorrow

In i2, i3 and going forward, those functions will be broken out into separate but related systems.

1. Address validation performed by a Validation Database (VDB).

2. Routing determination by an ESZ Routing Database (ERDB).

3. Management and provision of the subscriber record will be managed by a Location Information System (LIS).

Page 4

Why the Change?

This redesign is necessary because of changes in the telecommunications market and infrastructure. The old, centralized model is no longer viable in the “Internet Age”.

Address validation and call routing information must now be accessed by a host of new service providers using the Internet.

This open access creates a host of security issues, requires some new functionality and new data management techniques.

Page 5

What will the 9-1-1 call flow look like?

VDBVDB

Subscriber

Page 6

VPC, VDB, ERDB1. VPC (Voice Positioning Center)Voice Positioning Center)= Uses location information to

request routing information from the ERDB that is associated with the caller’s location.

2. VDB (Validation Database)= Address Validation matches addresses from civic to MSAG-valid

3. ERDB (Emergency Service Zone Routing Database)= Sends call routing data back to VPC

VDVDBB

Subscriber

1

3

2

Page 7

What is a VDB? - Validation Data Base

Contains Postal address guide for a designated area.

Contains MSAG information for the same area.

Uses various software to match the MSAG to postal addresses.

VDBVDB

Subscriber

Page 8

Validation Database – VDB

1. Receives Validation Request with a location Postal Civic Landmark/Placename Alias or AKA MSAG

2. Returns Response Code Valid or Invalid ID

• If invalid will return up to 10 alternatives Geo location (optional)

VDBVDB

Page 9

Subscriber enters current address

http (5)

Wonage App Server AT&T VDB

V7 Request (3)

V7 Response (4)

Wonage Subscriber

entersaddress (1)

9-1-1 Registration9-1-1 Registration

700 LavacaAustin, TX 78701

V7 Simulator

http (2)

9-1-1 Registration9-1-1 Registration

700 LavacaAustin, TX 78701

Good Address!

App Server

Subscriber

Page 10

What’s in a VDB?

1. Postal Link Builder creates Street and Community Links that match Postal to MSAG.

2. V7 Web Service accepts a Postal address and looks in Street Link for a match.

3. If a match isn’t found, it uses “sound-alike” processes like: Soundex and Oracle Text to find possible alternate addresses.

VDBVDB

Page 11

Building the VDB

USPS MSAGMSAGMSAG

VDB

VDB DMI

Page 12

Invalid Address – Alternates proposed

Up to 10 alternates proposed Additional screening

Zip Code Further limits alternates proposed

Page 13

VDB Maintenance

USPS MSAG

VDB

AT&T DOC

Page 14

ERDB V8 Query - 9-1-1 Call Flow

VDBVDB

Subscriber

Page 15

What is an ERDB?

Emergency Service Zone Routing Data Base

Contains the same Master and Link data as the VDB.

Contains and returns to the VPC Routing Instructions similar to Selective Routing Tables in 9-1-1 selective routing tandems and ALI systems.

ERDBERDB

Page 16

ERDB Return Data

When queried by the VPC, the ERDB returns:

1.1. The Emergency Services Routing NumberThe Emergency Services Routing Number (ESRN) which identifies at least the SR and/or a specific trunk group into the SR.

2.2. The Emergency Services NumberThe Emergency Services Number (ESN) for the ESZ in which the caller is located.

3.3. The Contingency Routing NumberThe Contingency Routing Number (CRN). This is an optional 10-digit telephone number to which the 9-1-1 call would be routed if the VPC was unable to connect the call to the SR (i.e. PSAP 24/7 number).

4. The MSAG valid address

Page 17

VDB/ERDB Architecture

The VDBVDB is analogous to the MSAG verification process in a Service Order Processor (SOP) or Database Management System (DBMS).

The ERDB ERDB is analogous to an Selective Routing Database or ALI node supporting selective routing.

All data maintenance is replicated to dual ERDBs for redundancy and Fault Tolerance.

Reliable and proven software tools and subsystems, like Oracle and Web Logic, are used to build the system.

Page 18

ERDB Returns

Civic Included

Geo Included

MSAGMatch

Geo Code Found

Routing Method MSAG

Returned

Y N Y n/a MSAG Y

Y N N Y Geo N

Y N N N Default Route N

Y Y Y n/a MSAG Y

Y Y N n/a Geo N

N Y n/a n/a Geo N

N N n/a n/a Error Returned N

Page 19

Building the ERDB

GIS

VDB

GIS GIS DMI(e.g. ARC GIS)

Voice Positioning

Centers (VPC)

V8ERDB

Page 20

The MSAG of the Future

The VDB and ERDB systems are deployed as an integrated system, since their functions and data requirements are so closely related.

Over time, management of the MSAG will migrate into the combined VDB/ERDB system. This will be where the master copy of the MSAG is managed.

All other systems using MSAG data will get their updates from the VDB/ERDB system.

Tools are available that use GIS to maintain the MSAG. This represents a significant advancement over manual management of tabular MSAG files and will combine the process of MSAG and map management.

Page 21

It’s worth the effortThis all is just a new way of managing Address, MSAG and Routing data. Integrates Postal and GIS with MSAG data for the first time.

Distributes intelligence that was centralized.

Positions 9-1-1 for Next Generation.

VDVDBB

Subscriber

Page 22

E9-1-1 must evolve to support new call origination E9-1-1 must evolve to support new call origination typestypes Long-term E9-1-1 will not operate as it does today.

E9-1-1 must continue to provide equal or better service to Public Safety for the Public’s safety.

Likely Scenario: 9-1-1 will make use of a hybrid migratory path to support VoIP (NENA i1, pre-i2, i2, i3).

It’s worth the effort!

Contact your AT&T Account Manager for more Contact your AT&T Account Manager for more information and/or a demonstration of the information and/or a demonstration of the

VDB/ERDB!VDB/ERDB!