The DrugBase: 21 pharmaceutical and medical databases in one product
Deutscher Apotheker Verlag Dr. Roland Schmiedel GmbH & Co. KG

The DrugBase: 21 pharmaceutical and medical databases in one product

Implemented by Basilicom, DrugBase is a digital information source for pharmacies, doctors' practices, hospitals, companies, and pharmaceutical and medical institutions. In one product, it combines information from 21 pharmaceutical and medical databases, which can be licensed individually or in combination.

The Customer

Deutscher Apotheker Verlag (DAV) is the largest pharmaceutical publisher in Germany. It provides pharmacists as well as pharmaceutical technical assistants and commercial employees with scientific information and professional know-how, whether they’re still training or mid-career.

  • 250 Employees
  • 1500 Online products
  • 950 Works
  • 67 Mio. € Turnover

Projectdescription

Complex data structures and heterogenous usage scenarios
Challenge

Complex data structures and heterogenous usage scenarios

Pharmacies, doctors’ practices, companies, hospitals, and institutions draw on a wide range of medical and pharmaceutical information sources for their research. With DrugBase, Deutsche Apotheker Verlag (DAV) wanted to offer its clients a product that would serve as a centralized source of information for questions pertaining to medications and pharmaceuticals. The research base would be made up of 21 databases, including the Index Nominum and the Normdosen, all combined into a single product. DAV created and maintained some of these databases itself, and made others available to customers via licensing. The challenges for the integrated implementation of all these databases were complex, because the data were modeled differently, included a mix of identical and different data types, and were updated at varied intervals. In addition, there was also a range of usage scenarios and licensing options.
Search results in one click
Solution

Search results in one click

Using Pimcore's master data management platform, we created the foundation on which to implement DrugBase. To enable users to conduct targeted searches on a central, modern, responsive user interface, we referenced the PZN numbers, substance classes, substances, and structural formulas from different database sources. We designed the search in a way that has made it possible to select either a targeted manual database search or an intelligent global search. By implementing Elasticsearch, depending on a search query’s structure, the algorithm can already offer contextual suggestions for relevant results during the search input, guiding users more quickly to the information they need. In addition, we have made it possible to filter and facet search results on a database-specific basis.
Result

Positioned for the future with fast, contextual search

With DrugBase, Deutsche Apotheker Verlag now offers its customers yet another innovative digital product. The various search functions are a special highlight. Implemented with Elasticsearch and a modern responsive user interface, they allow the user to choose between a manual search of the databases or an intelligent global search. During input, results are already output as autosuggestions — depending on the structure of the search query, the algorithm generates individual suggestions of relevant results. This shortens search processes and intelligently guides users to the information they are looking for in the extensive database. The DrugBase significantly reduces search time. Due to the cross-device interface and modern backend architecture, new technical developments can be easily adapted in the future and additional new databases can be integrated quickly and flexibly.

Success Parameters

  • 600000 Pharmaceutical products
  • 10000 Substances
  • 5.6 Mio. Pimcore objects
  • 1 Click for desired search results
Great job. You find your way around faster and better.

Apothekerin an den DAV-Vertrieb

Base data

Industry Pharma & Health, Media

Pimcore products PIM, CMS

Technologies Elasticsearch, VueJS, MySQL, PHP, Pimcore

Services Tech Operations

Solution Marketing platform, Content Management System, Product Information Management, Product Finder, Master Data Management

Competencies Product Ownership, Data Modeling, Interface Design, User Experience Design, Frontend Development