Related Experiment Video
Updated: Jan 31, 2026

Performing Data Mining And Integrative Analysis Of Biomarker in Breast Cancer Using Multiple Publicly Accessible Databases
Published on: May 17, 2019
Relational database for drug utilization studies (DUS) in Brazil: analysis and integration of outpatient data
Roberto Eduardo Schneiders1,2, Andréia Turmina Fontanella2, Ivan Ricardo Zimmermann3
1Coordenação-Geral do Componente Especializado da Assistência Farmacêutica, Departamento de Assistência Farmacêutica, Ministério da Saúde. Esplanada dos Ministérios, Bloco G, sobreloja. 70058-900 Brasília DF Brasil. roberto.eduardo@saude.gov.br.
None:
The present study aims to create a unified relational database (BEM-SUS) to analyze the use of medicines from the assistance program called Specialized Component of Pharmaceutical Assistance (Componente Especializado da Assistência Farmacêutica - CEAF) within the Brazilian National Health System (SUS). It integrates information from different SUS data sources and considers data on CEAF medicines dispensing from 2013 to 2022. The study is based on 5,991 public datafiles from the SUS Outpatient Information System, including data on outpatient production (produção ambulatorial - PA) and APAC Medicines (APAC-M). The PA data contains 239,125,819 records, while the APAC-M data contains 180,692,466 records. APAC-M accounts for 75.6% of the PA records, and PA lacks variables in the APAC-M files. The BEM-SUS was constructed from PA data in addition to APAC-M data. Deterministic linking enabled the matching of 99.96% of the records, resulting in 239,027,991 records from 6,431,208 different users. This study emphasizes the importance of prior data treatment and linkage between available databases for a correct interpretation of the data in drug utilization studies (DUS).
More Related Videos
Related Concept Videos
Relative Motion Analysis - Velocity
When an external force is exerted, it sets the crank into a rotational movement. This, in turn, instigates the motion of the connecting rod, leading to what is referred to as a general plane motion. This process involves two key points - point A on the connecting rod...
Relative Motion Analysis - Acceleration
Relative Motion Analysis using Rotating Axes
However, to express the relative position of point B relative to point A, an additional frame of reference, denoted as x'y', is necessary. This additional frame not only translates but also rotates relative to the fixed frame, making it...
Relative Motion Analysis using Rotating Axes-Problem Solving
Here, in order to determine the magnitude of velocity and acceleration for point...
Analysis of Population Pharmacokinetic Data
Relative Motion Analysis using Rotating Axes - Acceleration
Time differentiation is...

