BeeDIGITAL and DEYDE, a 17 year partnership

Páginas Amarillas

Since 2004, and after several changes over time, BeeDIGITAL has relied on DEYDE’s services to provide the highest quality data.

It has been more than 17 years since the leading company in digitisation technology solutions for SMEs and the self-employed in Spain, Páginas Amarillas, currently known under the name of BeeDIGITAL, relied on DEYDE Data Quality’s normalisation, enrichment and duplicate identification services.

Its name change is due to the digital evolution of the company over the years, and throughout this transformation process BeeDIGITAL has relied on DEYDE for the optimisation of its clients’ internal data.

DEYDE and BeeDIGITAL began their relationship in 2004, when the British group Yell owned Yellow Pages. At that time it was already established as the reference business search engine with its telephone directories and, after taking its first steps in the digital world, they decided to include the MyData Names, Addresses and Dedupe modules in their Batch Usage licence for large databases with massive records.

After two years of collaboration, BeeDIGITAL decided to continue to rely on DEYDE for its databases and extended the licence with the addition of a new tool, MyDataQ Geo Coordinates, essential for a business based on the search and location of SMEs by users.

The MyDataQ modules contracted by BeeDigital are fundamental, as the search engine provides information on the exact address of the businesses and how close they are to the customer’s location.

A portal such as PáginasAmarillas.es, which has more than one million entries, is very likely to find duplicate entries. Finding and eliminating them is fundamental to avoid errors, improve the company’s image and achieve a unique vision of its customers.

Present and future of BeeDIGITAL together with DEYDE

BeeDIGITAL currently relies on DEYDE as its reference standardiser, having renewed its Cloud licence for the unlimited processing of its database in the cloud for Spain and Andorra. It also has the MyDataQ Addresses, Geo Coordinates and Geo Inverse tools, which help to generate postal addresses from coordinates.

José Luis Torregrosa, IT Manager at BeeDIGITAL has indicated that DEYDE has been a great help. “We use the services that provide us with operations to validate, search, complete addresses and normalise them so that we can include them in our system properly”, he explained. For his part, Luis Martínez, General Manager of DEYDE, expressed his satisfaction and thanked BeeDIGITAL for once again placing its trust in DEYDE’s services to improve the quality of the information contained in its databases. DEYDE always “seeks to improve the quality of our clients’ data so that they can get the most out of it”, he said.

The future of BeeDIGIAL and DEYDE

Both companies face the future in harmony and effectiveness. Over the years, the importance of companies having a digital identity has been demonstrated. The survival of small and medium-sized companies depends on their digitalisation and localisation on the internet.

Two years ago, Yellow Pages reinvented itself again, becoming BeeDIGITAL. The company has been adapting to changing consumer habits to offer customers answers to their needs in the world of digital marketing, and proof of this are the more than 70,000 customers, the database of more than one million SMEs and more than 140,000 websites produced so far.

For its part, DEYDE Data Quality will continue to support its project thanks to the unlimited licence. After DEYDE joins Accumin, we will work on the development of new ideas to further enhance the current tools and solutions that can benefit all companies.

The importance of database address standardization

Database address standardization is a fundamental process in order for this data to be functional. As we will explain below, this operation is of fundamental importance when it comes to making any type of analysis effective, generating efficient campaigns and setting strategies in any company.

What is address standardization?

The standardization of addresses in a database is a fundamental operation for the correct development of an infinity of actions in any company and especially in marketing campaigns. Address standardization will apply rules and verify addresses against master files, generating clean, standardised and validated data. Among other benefits, this improved addressing will reduce both costs and delivery times.

At the same time, it allows us to comply with the Spanish Personal Data Protection Act (LOPD). This law requires the accuracy of the personal data of each person who appears in the databases.

Why is it important to standardise addresses in databases?

By having standardised and validated addresses in our database we can comply with the above requirements. At the same time, we can avoid returns in our mailings (mainly in direct marketing campaigns) as well as have better delivery times with postal intermediaries.

Enriching our database with the coordinates of each address will allow us to visualise the location of our customers, competitors, etc. on a map. At the same time, it allows us to segment them in order to be able to implement specific strategies according to the socio-demographic profile of each one. It is therefore a fundamental task to establish efficient marketing campaigns.

How is database address standardization carried out?

The standardisation of database addresses is carried out by cross-referencing the data with the master files generated with information from official sources. The official bodies that provide this information are the National Statistics Institute (INE), the General Directorate of Cadastre, the National Geographic Institute and the Post Office.

What aspects does it include?

Among the functions included in the standardization of address databases, we could highlight the following:

1.- Inclusion and processing of files in different formats such as text files, access, excel, etc.

2.- Correcting errors that may be corrected during the data collection process as well as those derived from the different updates. This point is especially important in order to comply with the LOPD.

3.- Updating of address data due to the most frequent factors. These may include changes to the postcode, or to the street name, etc.

4.- Location and marking of duplicated data to make them into a single piece of data.

5.- Return in digital and postal format of the assigned addresses.

Advantages of standardization addresses in a database

We will now tell you about the advantages of standardizing addresses in a database. This is an essential service for keeping the addresses of our clients and other companies relevant to our professional activity up to date.

1.- Guarantees

The first advantage of address standardization in a database is that it offers all the necessary guarantees for the successful delivery of our marketing campaigns, avoiding errors and returned deliveries.

2.- Verification

The standardisation of addresses in the database also has the advantage of offering verification for the data included in it. This means that we can have an updated register with all the addresses as well as the profile of the different members. A fundamental aspect to be able to carry out more efficient campaigns. Thanks to knowing the socio-demographic profile of each of its members, we will be able to adapt and make our campaigns more flexible.

3.- Accessibility

The standardization of database addresses gives us greater accessibility to them both for strategic use and for consultation. Thus, data standardisation tools become very useful for companies in general and their marketing campaigns in particular.

4.- Speed

As a consequence of a more efficient use of the address data in our database, the delivery times of the correspondence itself are also reduced.

5.- Cost savings

Thanks to a better use of the data for all the factors we have explained, we can also save on costs arising from errors or returns in the whole process and in our marketing campaign.

Improve your customer’s experience thanks to MyDataQ

The standardization of addresses in a database becomes an important step for our business to function optimally. DEYDE offers the MyDataQ solution to improve the quality of data that will help you to sort and enrich your information. If you want to improve your experience and that of your customers as well as make a leap in quality in your daily marketing strategies, this is the best option for you.

What is a data manager and what are its functions?

gestor de datos

Database normalisation has become a vital process to survive in the age of data and data quality. But what do we need to do it? Do you know what a data manager is?

DBMS as a form of data quality assurance

A database management system (DBMS) is system software for creating and managing databases. This solution provides users and programmers with a systematic way to create, retrieve, update and manage their information. Accordingly, a data manager is the most effective way to detect duplicates and ensure data quality.

In addition, it allows end users to create, read, update and delete information in a database. It also serves as an interface between the database and end users or application programs; thus ensuring that data is organised in a consistent and easily accessible manner.

Functions of the Database Management System

The DBMS controls three vital elements: the information, the database engines that allow access, locking and modification of information, and the database schemas, which define the logical structures of the databases. In addition, these elements are essential to ensure data security and integrity, as well as uniformity in administration procedures.

Thus, typical database administration functions supported by the DBMS include change management, monitoring and recovery. Many database management systems are also responsible for mechanised restores, resets and recoveries, as well as analysis and activity monitoring.

It can therefore provide logical and physical independence of data. This means that it is able to protect users and applications from needing to know where data is stored or having to worry about changes in the physical structure of data, storage and hardware.

Popular types of DBMS

Popular database models and their management systems include:

  • Relational database management system (RDBMS): fits most use cases, but can be quite expensive.
  • In-memory database management system (MDBMS): provides faster response times and better performance.
  • NoSQL DBMS: ideal for loosely defined data structures that may evolve over time.
  • Columnar database management system (CDBMS): ideal for data warehouses that have a large number of similar data elements.
  • Cloud-based data management system: the cloud service provider is responsible for providing and maintaining the DBMS.

Advantages of a DBMS

One of the main advantages of using a DBMS is that it allows end users and application developers to access and use the same data while managing data integrity.

Thus, data is better protected and maintained when it can be shared using such a solution rather than creating new iterations of the same data stored in new files for each new application. It also provides a central repository of data that can be accessed by multiple users in a controlled manner. Central storage and data management within the DBMS provides:

  • Data abstraction and independence.
  • Data security.
  • A locking mechanism for concurrent access.
  • An efficient handler to balance the needs of multiple applications using the same data.
  • The ability to recover quickly from crashes and errors, including restart capability and resiliency.
  • Robust data integrity capabilities.
  • Activity logging and auditing.
  • Simple access via a standard application programming interface (API).
  • Uniform data management procedures.

Another advantage is that it can be used to impose a logical and structured organisation on data. In this sense, it offers economy of scale for processing large amounts of data because it is optimised for such operations.

Single schema views

On the other hand, it can provide many views of a single database schema. A view defines what data the user sees and how that user sees the data. Thus, the database management system provides a level of abstraction between the conceptual schema that defines the logical structure of the database and the physical schema that describes the files, indexes and other physical mechanisms used by the database.

When used, systems can be modified much more easily when business requirements change. Thus, new categories of data can be added to the database without disrupting the existing system and applications can be isolated from how data is structured and stored.

At DEYDE we work to achieve data standardisation in a fast and easy way, adapted to the needs of our customers. Do not hesitate to contact us to design an effective action plan.