SciELO - Scientific Electronic Library Online

vol.12 número3Revisao de 15 casos submetidos a oclusao temporaria bilateral de arteria iliaca interna em pacientes com alto risco para hemorragia obstetricaVariacoes anatomicas dos vasos tibiais: diagnostico diferencial de trombose venosa profunda antiga pela ecografia vascular índice de autoresíndice de assuntospesquisa de artigos
Home Pagelista alfabética de periódicos  

Serviços Personalizados




Links relacionados


Jornal Vascular Brasileiro

versão impressa ISSN 1677-5449

J. vasc. bras. vol.12 no.3 Porto Alegre junio/set. 2013 

Original Articles

Electronic clinical and surgical database in chronic lower limb ischemia

Carlos Seme  Nejm Junior1 

Jorge Rufino Ribas  Timi1 

Valentina Bistolf  Amaral2 

1Universidade Federal do Paraná - UFPR, Department of Surgery, Curitiba, PR, Brazil

2Universidade Federal do Paraná - UFPR, Curitiba, PR, Brazil



Electronic medical record systems may optimize future studies by improving speed, as well as data comparison and analysis.


(a) To create a general database of clinical and surgical vascular diseases and select data from it to create a specific database of chronic lower limb ischemia; b) to store this database in the form of an electronic system; c) to incorporate this database into the Brazilian integrated electronic medical record system (SINPE(c)); and (d) to conduct a pilot study to test the system.


A general database of clinical vascular disease was created, and a specific system was developed to record the individual characteristics of the diseases that cause chronic ischemia of lower limbs. When completed, the database was incorporated into SINPE(c).


For data collection, an authorized user enters patient data and creates a medical record for that patient. After that, chronic ischemia of lower limbs is selected in the master system to access clinical data. Aided by the autofill tool, the user selects only the data for that specific patient. Data may be retrieved for studies, to find out the number of entries that meet the chosen parameters, and to provide statistical information about them.


(a) The theoretical database of clinical and surgical vascular diseases and the derived database of chronic lower limb ischemia were created; (b) the theoretical electronic database was created; c) the electronic medical records in both the master and the specific database were incorporated into SINPE(c), (d) the pilot study was successfully created and tested using the parser module of SINPE(c).

Key words: electronic database; electronic medical record; medical records; vascular surgery; chronic ischemia of lower limbs


Few services keep medical records for purely clinical purposes. Medical records, in the past stored in hospital files, should be easily accessed for data collection and scientific quality control1.

After the creation of an electronic clinical and surgical database of chronic lower limb ischemia, a significant number of standardized data may be made available. Data use will be easier, which may lead to greater technical and scientific development2.

The research line Electronic Medical Records was created in our Graduate Program on Clinical Surgery after we were authorized to use the software of the Brazilian electronic medical record system (Sistema Nacional de Protocolos Eletrônicos, SINPE(c)), which can be used to create electronic databases and collect data for prospective clinical studies in several medical areas3 , 4.

The electronic medical record system for cases of chronic lower limb ischemia originated from the master electronic vascular surgery database. It is a resource for comprehensive investigations, as it provides access to data about epidemiology, diagnostic tools and treatments, and will, therefore, increase the production of studies in this area. The objectives of this study were:

    •. To create a comprehensive and up-to-date database of vascular diseases, called a master system, and use the master system to define a theoretical database of diseases that cause chronic lower limb ischemia

    • . To standardize this electronic database and adapt it to a specific computer program, called electronic data collection system

    • . To incorporate this program into the Brazilian Electronic Medical Record System (SINPE(c))

    •. To conduct a pilot study to test the medical records and the SINPE(c) parser module using the description of data collected, and analyze the correlations with the incidence of myocardial ischemia defined by findings of pharmacological stress echocardiography using dobutamine or dipyridamole, and with the need of carotid endarterectomy in patients with chronic lower limb ischemia


This descriptive study about the Electronic Clinical and Surgical Database of Chronic Lower Limb Ischemia is in agreement with the Universidade Federal do Paraná rules.

This study was approved by the Ethics in Research Committee of the university where it was conducted.

After the topic was chosen (chronic lower limb ischemia), material was selected for data collection. Classical textbooks had to be used because they describe recent advances and revisions5 - 8. After the first structure of the system was built based on those books, more specific textbooks had to be checked to clarify some questions9 - 11.

After the diseases described by the specific subsystem had been defined, a detailed literature review was conducted using electronic medical databases in the Internet and specialized journals in the field of vascular surgery, such as the books mentioned above.

Four diseases were included according to decreasing order of prevalence6: peripheral arterial occlusive disease (PAOD); thromboangiitis obliterans (TAO); popliteal artery entrapment syndrome (PAES); and cystic adventitial disease of the popliteal artery (CAD-PA).

Some of the items added after the review for each disease generated sub-items at several orders, according to their importance and prevalence. The changes in data distribution, as well as their updating, were first made using the software Microsoft Word XP(r), where all contents were visualized and corrected if necessary, and then entered into SINPE(c).

After the database was created, the method and form of data inclusion into SINPE(c) were defined. This part of the study demanded the participation of a team of IT specialists. The database management software used was Microsoft(r) Access, which simplifies CD-ROM recording and program distribution. This program has been used in our Graduate Program on Clinical Surgery, where it is an aid for students to build medical records, as in this study.

All the items included in the records were electronically processed using a tool to incorporate them into SINPE(c). The purpose of this program was to allow other researcher to retrieve and collect data in different centers and to operate the system online, from different places.

If SINPE(c) has not been previously downloaded and installed in the computer using the CD-ROM, records may still be visualized and included, as SINPE(c) may be accessed remotely in the Internet at Therefore, the records in the database may be updated and collected from any place in the world.

The Vascular Surgery Service of the Universidade Federal do Paraná was selected for the pilot study to test the electronic medical record system.

First, together with the IT department of Hospital de Clínicas of Universidade Federal do Paraná, a search was conducted to identify hospitalizations of patients with chronic lower limb ischemia in six months.

The electronic medical record system was retrospectively applied to a sample of 36 patients to test its operation and validate its applicability for the collection of data to be used in scientific studies.

After data collection for the pilot study, the SINPE Analisador (c) , a parser module, was used to interpret the information collected. This module provides an interface for the rapid visualization of data included in the SINPE(c) electronic medical records and generates graphs and statistical analysis, prints and saves results and exports data.


A chronic lower limb ischemia medical record system was created. All items that are important for the medical record are selected and added to the system. In addition, unwanted items may be removed from the records using the same SINPE(c) tool (Figure 1). This action may be taken at any time.

Figure 1 Selection of medical record item. 

After selecting the items that should be part of the specific chronic lower limb ischemia database, a total of 4612 items were included.

The procedure to include medical records for a specific patient is described below.

Click on Patient (Paciente in the original in Portuguese) in the main menu and then on Record (Cadastro). The screen will show a form to be filled with patient data, such as code, name, ethnicity, sex and occupation.Data collection begins by clicking on Data (Dados) and then on Collect (Coletar). Click on Visualize/Edit Collection (Visualizar/Editar Coleta), and a form will be displayed with a list of previous data collections, the identification of the collection in the system, patient number and name, the name of the specific record and the username, and the date. This screen also shows the button New Collection (Nova Coleta), which initiates a new round of data collection (Figure 2).

Figure 2 New data collection. 

To start data collection again, select a specific medical record system (disease) and the patient registered; after that, click on Go (Avançar) (Figure 2). The data collection screen shows the patient's name, the specific record and the area of healthcare. Using the clinical data from the medical record, select the items available in the electronic medical record system, as in the example below.

Specific medical record system - chronic lower limb ischemia, with the following items selected: history, living conditions and habits, and smoking, considering the natural clinical and chronological form of any disease at any time.

The details of the selection will appear automatically on the right side of the screen; also on the right, click on Save (Salvar) and End Collection (Finalizar coleta) to save the data files selected and to end collection (Figure 3).

Figure 3 Specific data collection. 

In the case the purpose is to search for clinical data about vascular diseases, click on Data (Dados) in the menu bar and then on Search (Pequisa) in the drop-down menu. The program will display options to select a specific medical record system, the type of search, the collection period and the list of institutions included in the search. Below the top pane, in the left side, the search items previously selected are displayed; in the right side, there are tabs for the parameters of the item selected, their statistical results and other cases, as well as details of the search item (Figure 4).

Figure 4 Example of a search. 

At this point, click on Begin Search (Iniciar Pesquisa) to obtain the data collected for the item selected and the statistical results (Figure 5).

Figure 5 Example of search results. 

After the selection of an item for the analysis of results, click on the first tab to visualize the number of collections; on the second, to see the statistical data about the search (number of collections and percentage of occurrences); and on the third, to see the list of cases found in the search (Figure 5).

This pilot study was conducted using a retrospective search of the records entered for patients with chronic lower limb ischemia and hospitalized in Hospital de Clínicas of Universidade Federal do Paraná in a period of six months.

Thirty-six patients (12 women) with chronic lower limb ischemia were evaluated, and the age of most patients (36.11%) ranged from 63 to 71 years. Most patients were white, and most were men. Mean age was 70 years, and age ranged from 47 to 90 years.

The system automatically generated graphs that showed data collected about morbidity in the family, as well as living conditions and habits. Nine (30%) patients had a family history of heart disease; eight (26.6%), of diabetes; and six (20%), of systemic hypertension and vascular disease. Thirty-two (47%) patients were smokers, and smoking was the most prevalent item in the category of living conditions and habits.

The pilot study analysis consisted of the correlation of chronic lower limb ischemia with two diseases that contributed to morbidity and mortality and affected treatment: myocardial ischemia defined by the results of pharmacological stress echocardiography, and severe carotid stenosis defined by Doppler echocardiography findings.

Twenty-seven (75%) patients underwent pharmacological stress echocardiography using dobutamine or dipyridamole. Twelve of them (44.44%) had abnormal echocardiograms (Figure 6). The most prevalent abnormality was myocardial ischemia after pharmacological stress with dobutamine or dipyridamole (Figure 7).

Figure 6 Echocardiography results. 

Figure 7 Abnormal echocardiography results. 

Severe stenosis (>70%), defined by Doppler echocardiography findings, is indicative of carotid endarterectomy according to the Asymptomatic Carotid Atherosclerosis Study (ACAS) and the Asymptomatic Carotid Surgery Trial (ACST).

Only 14 (38.89%) patients underwent Doppler ultrasound of neck arteries, and the results were abnormal in 12 (85.71%) (Figure 8). Severe stenosis, an indication for carotid endarterectomy, was found in 4 (28.57%) patients (Figure 9).

Figure 8 Doppler ultrasound of neck arteries. 

Figure 9 Carotid artery stenosis. 


The design of descriptive studies is often limited by the difficulty in obtaining quality data, a result of the incorrect filling of medical records, the lack of coordination and of standardization of the descriptions and, sometimes, the illegibility of those records, which characterizes subjective data and may compromise results12 - 14.

Most hospital medical centers do not use electronic medical record systems. Their use is often restricted to certain sectors, such as logistics and diagnostic tests. The development and implementation of electronic data collection may organize prospective data searches and enable constant updating and future medical studies.

In Europe and the United States of America, standardized computer-based data collection was developed to overcome the limitations of medical records kept on paper and to eliminate the subjective character of those medical records15 - 17.

The delay in obtaining patient clinical data and the incompleteness of the clinical history handwritten by different professionals, which is often the case in university medicine, greatly complicate the correct assessment of different aspects and undermine the credibility of a database, which is a barrier to the development of high-quality studies12 , 13.

The purpose of using electronic medical record systems to collect clinical data is not the mere replacement of medical charts, important documents for physicians and their patients, but, rather, to provide a safe source of information for future medical studies.

Future data searches using computer-based systems depend on data collection according to defined parameters, preferably using collection forms that provide lists of acceptable values18.

Medical studies based on clinical data collection using guided electronic medical record systems may increase the reliability and the quality of scientific studies19 , 20. These systems also make it possible to analyze the data collected, but do not require large physical spaces for their operation.

Electronic medical record systems used to build large clinical databases that are constantly searched may improve the quality of medical studies, as databases are reliable sources for scientific investigations21 , 22. The University of Alabama, for example, has become a reference center for patients with acquired immunodeficiency syndrome (AIDS) because of its publication of scientific studies using clinical data stored in computer-based systems23.

The clinical data collected from an electronic database does not have to belong to a single institution, as it may be a multicenter initiative. For example, in France, 38 intensive care units use standardized data storage in a single database, and in Italy, databases are shared for multicenter studies about liver diseases, particularly cirrhosis24.

In Brazil, the Brazilian Association of Intensive Care (AMIB) has an online database ( that provides access to information about the main ICUs in Brazil, and allows clinical data exchanges and the analysis of all registered services.

Therefore, the collection of electronic clinical data promotes the development of multicenter studies, increases the number of data available and improves the quality of scientific studies. At the same time, it reduces the length of studies, increases the size of the population under study and yields more accurate results in a shorter time25.

The original structure of the electronic medical record system of chronic lower limb ischemia cannot be changed by users that collect data, visualize data or conduct searches, and only the administrator can change the database. However, because of the advances and developments in medicine, this electronic medical record system accepts the addition of new items without changing the database already in use.

As IT keeps changing rapidly, data storage and exchange should be the cornerstone of medical research, development and improvement.

Patients with chronic lower limb ischemia account for a percentage of the population whose treatment and complications directly affect patient quality of life. Advanced age, number of comorbidities and, consequently, number of hospitalizations make data searches burdensome and tiring.

The electronic medical record system of chronic lower limb ischemia will provide uniform and safe collection and storage of clinical and surgical data to be used in future studies. The costs for its implementation, considering also the number of years of studies and initial investment, are relatively low in light of its importance and scope.

The participation and support of IT specialists are essential to choose methods to build and implement the system and collect data, as well as to maintain electronic medical record systems. The rapidly growing field of IT brings continuous improvement and adaptations for the development of current and future electronic medical record systems.

This electronic medical record system was developed to be easily operated in computers and systems disseminated in the Brazilian and international IT market, which minimizes its risk of not running due to any incompatibility. Its purpose, in addition to motivating workers in the medical field to conduct scientific studies, is to provide a computer-based tool to collect and analyze clinical data and improve the quality and reliability of future scientific studies.

This system may contribute to the advancement of the scientific medical community, and electronic collection of clinical data about patients with chronic lower limb ischemia may be the beginning of a new scientific paradigm, based on the multidisciplinary integration of IT and the medical field to promote new and more reliable high-quality studies.


This study created a theoretical database to collect clinical data about chronic lower limb ischemia that is operated as a computer program incorporated into the Brazilian integrated medical record system (SINPE(c)); the electronic medical record system was tested in a pilot study in which data were collected and analyzed using the SINPE(c) parser module.

The pilot study showed that myocardial ischemia was found in 44.44% of the patients, which was an indication of the need for further investigation of coronary artery diseases in patients with chronic lower limb ischemia. Moreover, carotid endarterectomy was indicated in 28.57% of the patients, which justified the investigation of carotid stenosis in this group of patients.


1. Sigwalt MF. Base eletrônica de dados clínicos das doenças do esôfago. [Dissertação]. Curitiba: Universidade Federal do Paraná; 2001. [ Links ]

2. Tolley EA, Headley AS. Meta-analyses: what they can and cannot tell about clinical research. Curr Opin Clin Nutr Metab Care. 2005;8(2):177-81. Links ]

3. Malafaia O, Borsato EP, Pinto JSP. Gerenciamento do conhecimento em protocolos eletrônicos de coleta de dados. In: Anais do 3º Simpósio Internacional de Gestão do Conhecimento; 2003; Curitiba. 2003. [ Links ]

4. Malafaia O, Borsato EP, Pinto JSP. Manual do usuário do SINPE(r). Curitiba: UFPR; 2003. [ Links ]

5. Maffei FU, Lastória S, Yoshida WB, Rollo HA. Doenças vasculares periféricas. 3 ed. 2008 [ Links ]

6. Brito CJ, Duqu A, Merlo I, Murilo R, Fonseca VL Fº. Cirurgia Vascular - Cirurgia Endovascular - Angiologia. 2. ed. Rio de Janeiro: Revinter; 2008. [ Links ]

7. Haimovici H, Ascher E, Hollier LH et al. Cirurgia Vascular. 5. ed. Rio de Janeiro: Revinter; 2006. [ Links ]

8. Rutherford RB, Cronenwett JL, Johnston W, et al. Cirurgia Vascular. 6. ed. 2007. [ Links ]

9. Zelonockmatery GB. Mastery of Vascular and Endovascular Surgery by. Lippincott Williams & Wilkins; 2005 [ Links ]

10. Lobato AC, Colli DF Jr, Costa CAF, Pereira AH. Cirurgia Endovascular. 2006. [ Links ]

11. De Luccia N. Amputação e reconstrução nas Doenças Vasculares. São Paulo; 2005. [ Links ]

12. Dick RS. The computer-based patient record - an essential technology for health care. Washington: Institute of Medicine, National Academy Press; 1991. [ Links ]

13. Rind DM. Real and imagined barriers to an electronic medical record. Proc Annu Symp Comput Appl Med Care. 1993:74-8. [ Links ]

14. Tang PC, Larosa MP, Laine C. Use of computer-based records, completeness of documentation, and appropriateness of documented clinical decisions. J Am Med Inform Assoc. 1999;6(3):235-51. Links ]

15. McDonald CJ, Tierney WN, Overhage M. The Regentrief Medical Record System : 20 years of experience in hospitals, clinics, and neighborhood health centers. Med Data Computing. 1992;9(4):206-17. [ Links ]

16. Sittig DF. Grand challenges in medical informatics?. J Am Med Inform Assoc. 1994;1(5):412-3. Links ]

17. Kohane IS, Greenspun P, Fackler J. Building National Eletronic Medical Record Systems via the World Wide Web. J Am Med Inform Assoc. 1996;3(3):191-207. Links ]

18. Coeira E. Guide to medical informatics, the internet and telemedicine. 3rd ed. Chicago: Arnold Publication; 1997. p. 376-379. [ Links ]

19. Weinberger M, Hui S, Laine C. Perspectives from the sixth Regenstrief Conference. Ann Intern Med. 1997;2:127-8. [ Links ]

20. McDonald CJ, Overhage JM, Dexter P, Takesue B, Suico JG. What is done, what is needed and what is realistic to expect from medical informatics standards. Int J Med Inform. 1998;48:1-12. Links ]

21. Goonan KJ. The Juran prescription: clinical quality management. San Francisco: Jossey-Bass; 1995. [ Links ]

22. Davidoff F. Dabatases in the next millennium. Ann Intern Med. 1997;127(8):770-4. Links ]

23. Lee JY. Uses of clinical databases. Am J Med Sci. 1994;308:58-62. Links ]

24. Coltorti M, Del Vecchio-Blanco C, Caporaso N, Gallo C, Castellano L. Liver cirrhosis in Italy. A muticenter study on presenting modalities and the impact on health care resources. National project on liver cirrhosis Group. Ital J Gastroenterol. 1991;23(1):42-8. [ Links ]

25. Blumeinstein BA. Medical research data. Control Clin Trials. 1995;16:453-5. Links ]

Received: July 17, 2013; Accepted: August 12, 2013

Correspondence Carlos Seme Nejm Junior Rua Teixeira Soares, 361 - Seminário CEP 80240-440 - Curitiba (PR), Brazil Tel: +55 (41)32449541 E-mail:

Author information CSNJ holds an MSc degree and is a PhD candidate in surgical practice from Universidade Federal do Paraná (UFPR). JRRT holds MSc and PhD degrees in surgical practice and is associate professor of vascular surgery of the Department of Surgery from Universidade Federal do Paraná (UFPR). VBA is a physician and former student at Universidade Federal do Paraná (UFPR).

Author's contributions Conception and design: CSNJ, JRRT Analysis and interpretation: CSNJ Data collection: VBA Writing the article: CSNJ Critical revision of the article: JRRT Final approval of the article*: CSNJ, JRRT, VBA Statistical analysis: CSNJ Overall responsibility: CSNJ Obtained funding: None.

Financial support: None.

Conflicts of interest: No conflicts of interest declared concerning the publication of this article.

Creative Commons License This is an Open Access article distributed under the terms of the Creative Commons Attribution Non-Commercial License, which permits unrestricted non-commercial use, distribution, and reproduction in any medium, provided the original work is properly cited.