Recently in Global Data Quality Category

Melissa provides numerous APIs to handle the standardization, cleansing and verification of various data elements such as addresses, names, phones and emails. Often times we get asked by our customers as to what are some ways to improve the speed when processing records using our APIs. Below are some performance tips to consider when implementing our APIs:

 

Storage

The type of medium where the data files are stored may have an impact on processing speed. We recommend the use of solid state drives to store our data files as they have faster seek & read times compared to spinning disk drives.


We have also sometimes seen clients store the data files on a network share which we definitely don't recommend. Typically, trying to access the files over a network introduces latency which impacts the processing speed when blocks of data need to be fetched quickly. Data files, therefore, should often be stored locally on the machine.

 

Memory

The amount of memory available and speed can also affect processing. While using the APIs, once data is read from the hard drive, the data is cached and stored temporarily into memory in case the data needs to be accessed again shortly.

 

A simple example below, we have a list of phone numbers that were verified using our Phone Object API along with the times in milliseconds indicating the amount of time to verify the phone number.

 

When the Phone Object API encounters a phone number in a new area code, there are spikes in the verify times as the Phone Object now has to go back and fetch a new block from the data files stored on a hard disk and cache it into memory. The more memory available on the system, the more that can be cached into memory as the API reads more blocks from the data files on the disk. And, as discussed in the previous section, having a faster hard drive will help keep those disk read times low when those data file reads occur.


tips-phone.png

Multi-threading

Processors with more than a single core are now common these days. If multiple cores are available on the system, we highly recommend that developers take advantage of that. When multithreading with our APIs, we suggest having each thread contain its own object instantiation for our APIs. 


For example, if you have 8 cores, you may want to create 8 threads with our API instantiated 8 times: once per each thread. Ideally, you would want to create a pool of threads that have our API instantiated already, and therefore ready for processing. If you keep reinitializing/instantiating our API, that will introduce some overhead in the processing.

 

The graph and table below shows some multithreaded testing of our own with our Global Address Object® API with UK addresses and, as shown, there as substantial speed increases that can be obtained through multithreading:


tips-phone2.png


Get in the Contact Zone

| No Comments | No TrackBacks

If you're looking for that perfect all-in-one solution that combines the power of easy integration and Melissa's full spectrum of data quality solutions, then you need to get in the Zone - The Contact Zone®.

Contact Zone employs all the customer data management tools you'll need to help provide consistent, trusted, accurate data across the enterprise - all in one single platform for effortless integration. 

Plus, it's powered by Pentaho® Data Integration (PDI), which gives Contact Zone a simple, graphical user interface, dynamic templates, administrative features, and so much more. Collect data from any source, cleanse and transform it, and gain immediate insight for meaningful use.



Contact Data Requests Increase up to 1400 Percent; Global Server Strategy Ensures Responsive, Compliant In-Country Processing



Rancho Santa Margarita, CALIF - July 12, 2016 - Melissa Data, a leading provider of global contact data quality solutions, today announced global server locations designed to ensure a robust growth infrastructure for expanding cloud-based data quality services.  Consistently outpacing its 2015 cloud-based business activity, Melissa Data anticipates a 165% increase in verification requests for Australia, 200% for China, and as high as 1400% for Germany. Melissa Data's domestic cloud-based services are also anticipated to grow by 100% in contrast to 2015. 


"Global reach with local support is the foundation of Melissa Data's growth strategy and enterprise business operations - we're working to meet the needs of each in-country user. Our customers not only capitalize on processing speeds inherent with local server calls, but also meet stringent compliance requirements for in-country data processing," said Bud Walker, vice president enterprise sales and strategy, Melissa Data. "As the global marketplace continues its shift to data quality as a service, we have protocols in place to support a significant upswell in data requests worldwide."


Melissa Data's dedicated resources protect effective, real-time data quality processing with efficiency, uptime, and failover protection. Local servers also meet the broadest range of in-country compliance requirements, which bind international data quality users and their vendors to maintain customer data handling without crossing borders. 


In-country processing requirements are growing rapidly in European markets and are well supported by Melissa Data's facilities in Canada, France, Germany, and Ireland; Asia Pacific clients are supported with local data facilities in Australia. The firm's U.S. server farm is shared between Richmond, Virginia, and now both Irvine and Rancho Santa Margarita, California, ensuring ideal uptime and load balancing for domestic enterprise users.


Demonstrating its focus on in-country processing and compliance, Melissa Data is one of only a handful of vendors licensed by Canada Post® to provide Canadian NCOA (National Change-of-Address) processing, matching data against 10+ million change-of-address records filed by Canadian households and businesses within the last 72 months. The company is also certified in Service Organization Controls (SOC 2), further assuring international enterprise users that data is handled with security, privacy, and integrity at every point along the spectrum of data quality operations. Click here for more insight on Melissa Data's global operations and technical capabilities, or call 1-800-MELISSA.


Melissa Data is set to attend Dreamforce #DF15 in San Francisco and will showcase its Listware for Salesforce all-in-one data cleansing app. Users are invited to download the app, submit a review to receive a free $15 Starbucks card, and be entered into a drawing for an Apple Watch. Come see us at North Hall Kiosk 1112!

Click here for more info!

Consolidating duplicate international customer records is now easier than ever with our enhanced MatchUp tool. MatchUp - Melissa Data's deduplication solution - can now parse addresses worldwide, a process that recognizes vast differences in international customer data fields and how they are merged into a data warehouse. Its initial global functionality will handle data for Australia, Germany, and the U.K. with additional countries to follow.

 

To learn more, please visit our website!


 

After 30 years in the industry, we've seen firsthand what bad data does to good companies. You'll be surprised to learn some of the issues companies have with their data. We've collected the top 30 most pervasive data quality issues - and what you need to know to solve them. Download our free Melissa Data Magazine to learn more. Also featured: our 2015 Data Quality Catalog, packed with info on our smart, sharp tools that include free trials, source codes, and unlimited tech support.

 

Download now!


Data Quality Plugin Increases Efficiency with Auto-Completion of Worldwide Customer Addresses; Optimizes Development with Flexible Mapping of Address Fields


Rancho Santa Margarita, CALIF. - April 15, 2015 - Melissa Data, a leading provider of contact data quality and integration solutions, today announced batch processing of worldwide address verification in Listware® for Salesforce®, its powerful data quality plugin that integrates data cleansing, validation, and enrichment directly into Salesforce.com's CRM software. Available on the Salesforce AppExchange, Listware for Salesforce now allows users to quickly and easily verify, check, and update customer addresses in more than 240 countries and territories at two points: point-of-entry; and upon scheduling bulk cleanup within an organization's database.

At point of entry, Listware for Salesforce provides real-time address autocompletion and verification, helping save up to 50% on keystrokes while only permitting valid data to enter the system. The user simply begins typing a customer or prospect's address into any Salesforce contact field; chooses the correct address from a list of suggestions, and the completed query returns a verified U.S. or international address, standardized into the official postal format for each geographic locale. In batch, an administrator can run address verification jobs based on unique criteria such as sales representative, city, state, or inquiry date. Bulk cleansing also provides many data appends to enrich Salesforce CRM data including: latitude/longitude coordinates and other postal elements; move- updates for U.S. and Canadian addresses; adding missing phone numbers, email addresses, demographics, and extensive property data. Bulk verification enables the verification and enrichment of US and global records within all standard and custom object fields, including contacts, leads, and accounts.

"Listware for Salesforce is a smart, elegant solution that seamlessly addresses all of the common, yet time-consuming issues facing developers or enterprise administrators as they work to integrate efficient data quality operations into their applications," said Bud Walker, director of data quality solutions, Melissa Data. "Along with the ability to customize auto-completion of address data in any mapped field, Listware's batch processing offers significant enterprise value. Endusers are in turn armed with a powerful data quality tool, providing unprecedented access to clean, up-to-date data that supports a worldwide customer base."

Listware for Salesforce is available for a one-time $19.99 license fee (per company) that includes 10,000 credits that can be used for any of the various data quality processes available. Click here to purchase and download Listware for Salesforce. For more information call 1-800-MELISSA (635-4772).

News Release Library


Verified and Correct Worldwide Customer Addresses Reduce Shipping Costs and Eliminate Online Fraud; Fast, Address Auto-Completion Boosts Shopper Conversion Rates


Rancho Santa Margarita, CALIF. - March 24, 2015 - Melissa Data, a leading provider of contact data quality and data integration solutions, today announced a new global address verification plugin for users of the Magento content management system for ecommerce websites. The Magento plugin was developed by Crafty Clicks, a Magento technology partner and address lookup service provider, and incorporates Melissa Data's Global Address Verification cloud service so online merchants can verify, correct, and auto-fill addresses as they are entered, validating information for more than 240 countries and territories in real-time. Crafty Clicks and Melissa Data are now engaged in an exclusive partnership enabling data quality in Magento-based ecommerce sites, with plans for continued strategic development of high-value data quality plugins for other popular ecommerce platforms.

"Melissa Data's global address capabilities complement our own expertise in UK-based address verification. Using proven solutions and without wasting development resources, Magento users can now extend the value of contact data quality across a worldwide customer base," said Adam Stylo, founder and president, Crafty Clicks. "By adding address auto-completion and post-checkout address verification to their sites, online merchants not only assure fewer lost parcels and reduced delivery support, but also increase overall usability for customers. Shopper conversions improve, boosted by a fast, accurate, and convenient checkout experience so essential to online sales."

Magento-based sites can seamlessly validate and cleanse international addresses at point of entry, correcting and standardizing them into the official postal format of each geographic locale, and adding missing components such as postal codes or region. Address fields are also populated automatically after the first few digits or letters have been entered using Melissa Data's Express Entry address auto-completion functionality. This speeds data entry with up to 50 percent fewer keystrokes; online shoppers have an improved shopping experience with just one step between shopping cart and checkout, drastically reducing the drop-off rate during the checkout process.

"By working with Crafty Clicks, we are helping merchants maintain data quality as an essential business strategy," said Gary Van Roekel, COO, Melissa Data. "Online merchants can improve shipping costs and customer satisfaction, as well as the success rate of their direct marketing activities. Magento users have a distinct competitive advantage in reaching new markets and customer groups based on better data."

Click here to download the Magento data quality plugin, configurable through the Magento Admin Panel. A free trial is available so interested users can test the global address verification and address auto-completion functionality.

News Release Library


Strategic Alliances Fuel Global Growth for Melissa Data

| No Comments | No TrackBacks

Technology Partnerships Advance Data Quality as Central Business Process;Enable Worldwide Expansion of Both Direct Mail and Data Quality Divisions


Rancho Santa Margarita, CALIF - December 16, 2014 - Melissa Data, a leading provider of contact data quality and address management solutions, today recognized 2014 as a milestone year for company partnerships in both its direct mail and data quality divisions. By working with leaders in ecommerce, data integration and comprehensive mailing solutions, Melissa Data has cemented strategic alliances that further expand its customer base worldwide. Essential to the company's growth strategy, Melissa Data's technology relationships are designed to fuel data quality as a central business process integrated into the earliest stages of master data operations.

"As the world recognizes the scope and value of data as a business asset, Melissa Data's global perspective on contact data quality has increasing impact. By providing sophisticated data quality that is simple to deploy, we're enabling businesses worldwide to embrace the competitive value of correct, validated customer information," said Ray Melissa, CEO, Melissa Data. "Collaborating with other technology leaders is essential in these efforts, and 2014 saw some of our most significant partnerships to date. Working closely with key partners, we're building existing business, growing in new markets, and seeing a greater understanding of data quality as the foundation for optimized master data systems."

Melissa Data's newest direct mail partnerships include Deutsche Post and Royal Mail, integrating global address verification and geocoding into their existing solutions and customer base. Melissa Data is one of only a handful of vendors licensed by Canada Post to provide Canadian NCOA (National Change of Address) processing so mailers can reach customers in both Canada and the U.S.

In the data quality realm, Melissa Data partnered with EXTOL International to enable seamless data quality operations in tandem with EDI. The company's alliance with Scribe Software uniquely enables cleansing, validating and enhancing customer information in a single integration as data moves between CRM, ERP and marketing automation applications. Melissa Data's relationship with Semarchy unites data quality and master data operations; Semarchy users have a fast and easy method for consolidating unstructured data sources and enriching master data, while Melissa Data customers have a strategic path to upgrade data quality projects into more comprehensive data governance initiatives. Melissa Data has increased its already deep support for developers by aligning with Varigence, incorporating data quality in Varigence's business intelligence accelerator tools based on Business Intelligence Markup Language (Biml).

Building data quality into ecommerce applications has also been a priority; by working with NetzTurm GmbH and Crafty Clicks, service providers for the implementation of online stores, Melissa Data has enabled plug-in data quality for users of Shopware and Magento-based ecommerce sites. Support for additional ecommerce platforms is imminent, enabling a greater number of online merchants to verify and correct addresses as they are entered, validating information from more than 240 countries and territories in real-time.

Earlier this year, Melissa Data also partnered with Blu Sky to solve healthcare data management challenges; data quality tools are now integrated into Blu Sky's EpicCare data capture technologies used to administer medical groups, hospitals and integrated healthcare organizations. Furthering its role in healthcare data quality initiatives, Melissa Data has also partnered with TriZetto, integrating data quality into software solutions that support nearly a quarter million doctors and healthcare providers under 350 different healthcare plans nationwide. Melissa Data's recent alliance with V3Gate expands public sector market dramatically, while enhancing V3Gate's big data capabilities with integrated data quality tools and solutions. Together the two firms are actively targeting business growth in federal, state and local government sectors, offering cutting-edge IT solutions that support high-level public agencies in achieving their diverse missions.

Partnerships on the 2015 horizon focus on ecommerce as well as enterprise data quality. Melissa Data conducts business worldwide, supporting its global clientele with sales and service from key locations in the United States, United Kingdom, Germany and India. For information about partnering with Melissa Data, contact sales@melissadata.com or call 1-800-MELISSA (635-4772).

News Release Library


Powerful Features Support Developers with Enriched, De-Duplicated Customer Records; Combats Exponential Increase in Costly Data Decay, Highlighted in Company Magazine


Rancho Santa Margarita, CALIF. - October 29, 2014 - Melissa Data, a leading provider of global contact data quality and data enrichment solutions, today announced significant enhancements to its flagship Data Quality Components for SQL Server Integration Services (SSIS), including the addition of three new services: global email, global phone verification, and U.S. property data enrichment. Data Quality Components for SSIS is a suite of custom data cleansing transformation components for Microsoft SSIS, used to standardize, verify, correct, consolidate and update contact data. With these new features, developers and DBAs are positioned to verify, enrich and retain all the best pieces of global customer data, using a single comprehensive and proven data quality tool.

New to the suite of tools is global email verification, which includes real-time email mailbox verification to eliminate up to 95 percent of invalid emails, so emails get delivered and don't bounce. Global phone numbers from over 230 countries can be verified and appended with geographic information, such as latitude and longitude coordinates, administrative area and predominant language spoken in that region. In addition, global phone features include the ability to return the digits necessary to dial out of your country and into the country of the phone number that was input. For users seeking to enrich U.S. address data, the property feature will provide up-to-date property and mortgage information on more than 140 million properties to improve overall customer intelligence.

"Contact data is always in flux, in fact, half of the customer records held in the average database are invalid or out-of-date in just 45 months - what we call the half-life of data," said Bud Walker, director of data quality solutions, Melissa Data. "Particularly as data becomes more global and increasingly includes email as a critical path of contact, database design must incorporate flexible, scalable tools that rely on a comprehensive approach to managing constant changes in customer data."

Melissa Data's research into the half-life of data, including the operation and long-term costs associated with undeliverable shipments, low customer retention and unsuccessful CRM initiatives, along with other SQL-based data quality challenges are featured in the current issue of Melissa Data Magazine, the company's quarterly resource for DBAs and data quality developers.

Melissa Data Magazine will be available at PASS Summit 2014, Booth #407, starting November 4 in Seattle, Washington. Click here to download the SQL Server edition of Melissa Data Magazine, or call 1-800-MELISSA (635-4772) for more information.

News Release Library


Categories