Contents

Oracle Enterprise Data Quality Address Verification Server Release Notes

- 1 Release 15.1 February 2015

- 1.1 New Features and Improvements in 15.1

- 1.1.1 Faster Verification for Germany and China

- 1.1.2 Improved Title Casting for All Countries

- 1.1.3 Premium India Data

- 1.2 Need Help?

- 1.3 Installation

- 2 Release 14.4 December 2014

- 2.1 New Features and Improvements in 14.4

- 2.1.1 Faster Verification for US

- 2.1.2 Address Powersearch for Japan

- 2.1.3 Native Address Powersearch Formatting for China, Japan, and Korea

- 2.1.4 Improved Title Casing for the US, Australia, and Canada

- 2.1.5 Improved Parsing with Phonetic Lexicon

- 2.1.6 New Server Options

- 2.1.7 New Process Options

- 2.2 General Suggestions and Tips

- 3 Release 14.3 September 2014

- 3.1 New Features and Improvements in 14.3

- 3.1.1 Address Powersearch™ Improvements

- 3.1.2 Improved Handling of Incorrectly Formatted Input Queries During Search

- 3.1.3 Improved Alias Handling During Search

- 3.2 General Suggestions and Tips

- 4 Release 14.2 May 2014

- 4.1 New Features and Improvements in 14.2

- 4.2 Known Issues

- 5 Release 14.1 March 2014

- 5.1 New Features and Improvements in 14.1

- 5.2 Known Issues and Workarounds

- 6 Related Documents

- 7 Documentation Accessibility

Oracle® Enterprise Data Quality

Oracle Enterprise Data Quality Address Verification Server Release Notes

Release 14.x and 15.x

E52586-06

February 2015

This document contains cumulative release information for Oracle Enterprise Data Quality (EDQ) Address Verification Server Release 14.x and 15.x and includes the following:

- Section 1, "Release 15.1 February 2015"

- Section 2, "Release 14.4 December 2014"

- Section 3, "Release 14.3 September 2014"

- Section 4, "Release 14.2 May 2014"

- Section 5, "Release 14.1 March 2014"

- Section 6, "Related Documents"

- Section 7, "Documentation Accessibility"

Oracle recommends you review its contents before installing or working with the product.

1 Release 15.1 February 2015

The following are the release notes for Oracle Enterprise Data Quality Address Verification Server Release 15.1.

- Section 1.1, "New Features and Improvements in 15.1"

- Section 1.2, "Need Help?"

- Section 1.3, "Installation"

1.1 New Features and Improvements in 15.1

This release includes the following new features and improvements:

1.1.1 Faster Verification for Germany and China

In Release 14.4, we introduced a new hash index for the US. In Release 15.1, the hash index was extended to Germany and China. The hash index is built to support faster verification for addresses that match the reference data exactly. Other countries may be supported in future releases.

The hash index helps improve verification performance significantly on input that matches reference data.

1.1.2 Improved Title Casting for All Countries

In Release 14.4, intelligent title casing was introduced for the US and Australia. This feature resulted in output having proper casing for all verified fields. This feature has been extended to all countries in Release 15.1. This includes upper-cased Roman numerals and upper-cased directional words.

1.1.3 Premium India Data

In this release, we introduced premium data for India. Premium India data provides better verification and geocoding than regular India data.

1.2 Need Help?

For more information on the new features and improvements in this release, and to access complete documentation of the address verification APIs, please make sure to register at:

http://www.loqate.com/oracle/

This website gives you full access to all technical information.

1.3 Installation

Please note that this version (15.1.0.0.0) of EDQ AV may require you to update your version of EDQ for compatibility purposes. Please consult the following table for a guide to compatibility:

Table 1 EDQ Compatibility

EDQ Address Verification Server Version

Required EDQ Version

12.x, 13.x, 14.1.0.0.0

EDQ 9.0.7 or later, EDQ 11.1.1.7.3 or later, or EDQ 12.1.3 or later

14.2.0.0.0, 14.3.0.0.0, 14.4.0.0.0, 15.1.0.0.0

EDQ 9.0.10 or later, EDQ 11.1.1.7.4 or later, or EDQ 12.1.3 or later

You can find installation instructions in the Oracle Enterprise Data Quality Address Verification Server Installation and Upgrade Guide at

http://docs.oracle.com/middleware/1213/edq/index.html

2 Release 14.4 December 2014

The following are the release notes for Oracle Enterprise Data Quality Address Verification Server Release 14.4.

- Section 2.1, "New Features and Improvements in 14.4"

- Section 2.2, "General Suggestions and Tips"

2.1 New Features and Improvements in 14.4

This release includes the following new features and improvements:

2.1.1 Faster Verification for US

In this release, we introduced a new Hash Index for US. The hash index is built to support faster verification for addresses that match the reference data exactly. Other countries will be supported in future releases.

For example, if the input address is ”999 Baker way, Ste 320, San Mateo, CA, 94404,” then the hash index will be used to verify the address before using the match tool.

Hash Index helps improve verification performance significantly on input that matches reference data.

2.1.2 Address Powersearch for Japan

Japan was one of the few countries not to receive a Powersearch data pack in our previous release. This data pack has now been compiled and will be added to our product list.

2.1.3 Native Address Powersearch Formatting for China, Japan, and Korea

Addresses in Japan start with the postal code instead of the premise number, as is common in most other countries. Our Powersearch indexes previously required all input to Powersearch to start with a premise number in order to be auto-completed accurately.

Now Powersearch will be able to auto-complete addresses that are in native format when the input is in the respective native script. This is an ongoing effort and should extend to other countries in future releases.

2.1.4 Improved Title Casing for the US, Australia, and Canada

Casing and capitalization can be an issue with many addresses. Users often capitalize the wrong word, or forget to capitalize the necessary ones which can make the address harder to read or process. Our GKR will now be able to assign the correct casing to addresses in the US, Australia, and Canada even in cases where the user completely neglected to do so.

2.1.5 Improved Parsing with Phonetic Lexicon

In this release, we added phonetic lexicons to help improve the parsing and therefore improve the verification quality.

Phonetic lexicons are able to handle homonyms and spelling errors with better accuracy than our previous methods. For example, a phonetic lexicon will be able to recognize Baltamor as Baltimore by itself, rather than having to depend on hardcoded rules. This should enable the engine to correct misspellings that were not explicitly included in our GKR rules.

2.1.6 New Server Options

This release includes the following new server options:

- SearchAutocompleteIndexCheck: this option allows the user to control if the search process should use the Powersearch auto-complete index files. The default is ON. The option should be set to 0 or OFF to have the search process not use Powersearch auto-complete index files. The option should be set to 1 or ON for the search process to use the Powersearch auto-complete index files. This can also be used as a process option.

- AutocompleteIndexOnly: this option allows the user to specify whether the search process should use Powersearch auto-complete index ONLY. The default is OFF. The option should be set to 0 or OFF to allow search tool to also use the parser and match tool when the auto-complete index cannot find any results. The option should be set to 1 or ON to allow the search tool to use the Powersearch auto-complete index files. This can also be used as a process option.

- FlexiconCountryList: this option allows the user to specify a comma separated list of ISO 3166-1 alpha-3 country codes for which phonetic lexicons (described above) is enabled for parsing. Default value is empty which means that the phonetic lexicons are not enabled for any country by default.

2.1.7 New Process Options

This release includes the following new process options:

- HashCheck: this option controls whether the Verify process will use the hash index or not. The default is ON. If the option is set to 0 or OFF, then the Verify Process will not use the Hash Index during verification.

2.2 General Suggestions and Tips

For the best results, install this release as soon as your application development cycle allows it. This release makes improvements in both the throughput of the verification process and the quality of the results.

Remember to update both the program files and the reference data. The improvements in the Loqate Engine are tied to the data in the Global Knowledge Repository and the combination works better. If you cannot update both in your application, contact support prior to upgrading so we can help you.

3 Release 14.3 September 2014

The following are the release notes for Oracle Enterprise Data Quality Address Verification Server Release 14.3.

- Section 3.1, "New Features and Improvements in 14.3"

- Section 3.2, "General Suggestions and Tips"

3.1 New Features and Improvements in 14.3

This release includes the following new features and improvements:

3.1.1 Address Powersearch™ Improvements

The new Address Powersearch™ functionality has been expanded to cover most countries worldwide. It provides faster, more accurate address capture and verification to improve customer service and reduce the costs associated with inaccurate address data. Note that the Powersearch feature requires the purchase of additional data files from Loqate.

Here is an overview of how Address Powersearch works. When you call Address Verification using the Search option from EDQ, the Address Verification Engine will first look for the corresponding auto-complete index in the Powersearch data files. If present, the method will attempt to return a list of candidate addresses instantly. If the index is not present, or if the index does not return any results, the older search process will be triggered.

Auto-complete indexes use only the first 10 characters to search within the US data set. The other supported countries use up to 15 characters to search. Address Powersearch will return the best information currently available. Some countries¿ data packs might not have addresses more precise than the street or locality levels. In those countries, Address Powersearch will accept the street or city name as input, and return the complete name with any additional information available.

Address Powersearch now covers all countries in the world except for India, Japan, Botswana, Ethiopia, San Marino, Saint Kitts and Nevis, Malaysia, Mongolia, and Kazakhstan.

Auto-complex index files can be downloaded via the Loqate Install Manager. Note that you will likely need to upgrade your license in order to be granted access to the Powersearch data for the countries you require.

It is important to note that the results returned can only be as comprehensive as the underlying reference data available for a country. Please consult the Data Coverage documentation to see the level of coverage in any countries of interest:

http://www.loqate.com/datacoveragesummary/

3.1.2 Improved Handling of Incorrectly Formatted Input Queries During Search

In the 2014Q2.0 release, we introduced improved parsing and spelling correction to the Verify option. This functionality has now been added to the Search option, providing better results where input is not recognizable as a standard address structure. For example, in the string `san francisco 300 berry usa', the order of the address elements is incorrect. The additional capability here will now provide more accurate results.

The parsing recognition has also been improved to handle compressed data, common in database systems with limited field lengths (for example, `SANFRANCISCO' instead of `SAN FRANCISCO').

3.1.3 Improved Alias Handling During Search

In this release, Search is better able to handle partial input with non-postal standard aliases. For instance, `1303 Nerine Circle' or `2100 W Point Avenue' in the US – the postal standards are Cir and Ave respectively, but now Search is able to provide better results in these situations with partial input.

The improved handling of incorrectly formatted input queries and improved alias handling during Search are controlled by the CombinedSearchMethods option. This option is set to YES (or ON or TRUE or 1) by default and will improve the quality of results.

There are also a wide range of Reference Data improvements in the compatible 2014Q3.0 data files from Loqate.

3.2 General Suggestions and Tips

Please remember to update both the program files (available in this zip file) and the global knowledge repository data files, available from Loqate. This release requires data files at version 2014Q2.0 or later. The improvements in the engine are tied to the data in the Global Knowledge Repository and the combination works better. If a reason exists in your application that both cannot be updated, please contact Oracle Support prior to upgrading so we can help you.

4 Release 14.2 May 2014

The following are the release notes for Oracle Enterprise Data Quality Address Verification Server Release 14.2.

- Section 4.1, "New Features and Improvements in 14.2"

- Section 4.2, "Known Issues"

4.1 New Features and Improvements in 14.2

This release includes the following new features and improvements:

- New Address Powersearch™ : Instant single line search results for 29 countries. Note: This feature requires the purchase of additional data files from Loqate.

- Flexible spelling correction during verification.

- Improved geocoding for Brazil.

- Performance improvements for better throughput in batch processing.

There are also a wide range of Reference Data improvements in the compatible 2014Q2.0 data files from Loqate.

4.2 Known Issues

This release will not work correctly with versions of EDQ prior to 9.0.10 or 11.1.1.7.4. If EDQ AV 14.2.0.0.0 is installed on a server running EDQ 11.1.1.7.3 or 9.0.9 (for example), the Address Verification processor will fail to load, and there will be an error in the log file stating that the version is incompatible. This is due to bug 18139586 in EDQ that has been fixed in EDQ 11.1.1.7.4 and 9.0.10.

5 Release 14.1 March 2014

The following is release information for Oracle Enterprise Data Quality Address Verification Server Release 14.1.

- Section 5.1, "New Features and Improvements in 14.1"

- Section 5.2, "Known Issues and Workarounds"

5.1 New Features and Improvements in 14.1

This release includes the following new features and improvements:

- Point-level geocoding for USA, Brazil, and Bosnia and Herzegovina

- Geocoding improvements; new MaximumGeoDistance and MinimumGeoAccuracy options

- New ReturnDataType and SuppressMatchFields options that provide more flexibility on Search and Verify modes respectively

- Improved Reference Data for New Zealand, Australia, Canada, and US

- Parsing improvements for Brazil, Canada, and US

- Transliteration improvements

5.2 Known Issues and Workarounds

The following are known issues and any workarounds in this release:

On 32-bit environments with more than 1024 MB of memory allocated to the EDQ Application Server's Java heap, a process with more than one instance of the Address Verification processor may attempt to use more memory than is available causing the application server to crash.

Extensive testing has not revealed this issue on any 64-bit environments, nor with any processes featuring a single instance of the Address Verification processor.

To be certain that you avoid this issue, Oracle recommends that you always run EDQ in 64-bit environments with sufficient memory to support both it and the additional Address Verification Server. For detailed requirements, contact Oracle support.

6 Related Documents

For more information, see the following documents in the Oracle Enterprise Data Quality documentation set:

- Oracle Enterprise Data Quality Address Verification Server Installation and Upgrade Guide

See the latest version of this and all documents in the Oracle Enterprise Data Quality Documentation website at

http://download.oracle.com/docs/cd/E48549_01/index.htm

7 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Oracle Enterprise Data Quality Product Title/BookTitle as a Variable,Release 14.x and 15.x

E52586-06

Copyright © 2006, 2015, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2015, Oracle and/or its affiliates. All rights reserved.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Alpha and Beta Draft Documentation Notice

If this document is in preproduction status:

This documentation is in preproduction status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.