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:
Oracle recommends you review its contents before installing or working with the product.
The following are the release notes for Oracle Enterprise Data Quality Address Verification Server Release 15.1.
This release includes the following new features and improvements:
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.
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.
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:
This website gives you full access to all technical information.
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:
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
The following are the release notes for Oracle Enterprise Data Quality Address Verification Server Release 14.4.
This release includes the following new features and improvements:
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.
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.
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.
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.
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.
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.
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.
The following are the release notes for Oracle Enterprise Data Quality Address Verification Server Release 14.3.
This release includes the following new features and 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:
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').
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.
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.
The following are the release notes for Oracle Enterprise Data Quality Address Verification Server Release 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.
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.
The following is release information for Oracle Enterprise Data Quality Address Verification Server Release 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
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.
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
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
.
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.