Structured Query Language Server Research Articles

Structure of data in cell biology research

Bioinformatics is a scientific field on the border between informatics and biology where problems in the field of biology are solved using statistical methods. Another part of it are database systems which serve to store data necessary for meta-analysis. In recent years, there has been a boom mainly thanks to enabling technologies that make it possible to obtain big data about the functioning of living cells of organisms. Bioinformatics tools are necessary to process these data and form an integral part of research in modern biological and medical sciences. Scientific research focused on molecular biology, as well as medicine, is increasingly focusing on data storage. It is understood that the correct structure of the database is important for the correct interpretation of the results of their research activities. For communication between tables in the database, it is essential to set the data type, assign Primary key and Foreign key, ensure data integrity, remove data plurality and understand the research logic. Based on these needs, we created a relational database using SQL Server 2017 and Microsoft SQL Server Management Studio 2017 (SSMS). We created the source code for programming the database and filling it with data in Structured Query Language (SQL) and T-SQL on the Microsoft platform. Of the data types, we used float for numbers with a floating decimal line, integer values were assigned an integer (int), date had a date data type, and text strings had a defined nvarchar data type. Our results bring new information in the field of bioinformatics about the creation of a database structure for data storage in cell biology research. These new insights will help big data in meta-analyses of data and applying scientific results to medical and scientific practice. The database will store data obtained in real time, which will ensure relevance in pointing out biological trends, regularities, relationships and links between cellular structures. All these aspects are very important for the spatial modeling of data and the creation of models of interactions of cell structures with use for applications in medical and biological practice.

BT07 Creation of a skin lesion image pipeline: key steps in developing a mobile application with DICOM® fields and metadata

Abstract A key issue facing artificial intelligence (AI) for dermatology is the lack of standardization around capture, transfer and storage of skin images and clinical data. To assist systematic capture of clinical data, we developed a nationally agreed proposed minimum dataset, based on Digital Imaging and Communications in Medicine (DICOM®) standards. Subsequently, we collaborated with an established image management system (IMS) supplier, Waba [supported by grants from our local National Health Service (NHS) innovation department], to incorporate these fields into a dermatology-specific mobile application (app), facilitating real-time capture and data transfer. We describe our steps in developing this app. The app integrates with the national Patient Administration System (SCI Store), allowing retrieval of real-time patient demographics linked to hospital or Community Health Index number. Each care episode captures a standardized dataset, including lesion views, clinical information and consent level. On episode completion, datasets are securely transferred to the IMS via WiFi or GPRS signal, following a fully auditable pathway. The IMS is a web-based app developed on a Microsoft Structured Query Language server, which allows authenticated users to access our trust’s centralized repository of nonradiological images. Adherence to industry-standard data storage format, patient safety reporting and specific access rights ensure compliance with Caldicott recommendations and data protection standards. For AI research, we are exploring conversion of datasets into DICOM format. Close collaboration between software developers and end users, including clinical photography, dermatology and general practice, was essential for app design. We worked on design architecture through fortnightly technical meetings, scheduled to progress development in months 1–8. Installation and functionality testing was performed in months 9 and 10, followed by comprehensive user testing in months 10–12. Live app test-of-change rollout was performed in months 13–16, with continued usability refinement during this period. To develop a standardized minimum dataset, we conducted a consensus exercise with the British Association of Dermatology AI working group. Based on DICOM standards, a comprehensive international standard for medical imaging, this could improve the quality, availability and interoperability of data for AI development. In summary, we have developed an app to standardize the capture, transmission and storage of skin lesion images and associated metadata. By collaborating with an industry partner with NHS experience, iterative user-led design and national engagement for standard-setting, we believe this is a useful step toward a national UK skin database for training and validating AI systems. Future work is planned to evaluate the output of this data pipeline.

The Design and Construction of a 12-Channel Electrocardiogram Device Developed on an ADS1293 Chip Platform

An accurate and compact electrocardiogram (ECG) device will greatly assist doctors in diagnosing heart diseases. It will also help to address the increasing number of deaths caused by heart disease. Accordingly, the goal of the project is to design and construct an easy-to-use compact 12-lead electrocardiogram device that communicates with a computer to create a system that can continuously monitor heart rate and which can be connected to allied medical systems. The design is based on an ECG receiver circuit utilizing an IC ADS1293 and an Arduino Nano. The ADS1293 has built-in input Electromagnetic Interference (EMI) filters, quantizers, and digital filters, which help in reducing the size of the device. The software has been created using the C# programming language, with Windows Presentation Foundation (WPF), aiding the collection of the ECG signals from the receiving circuit via the computer port. An ECG Multiparameter Simulator has been used to calibrate the ECG device. Finally, a plan has been developed to connect the arrangement to health systems according to HL7 FHIR (Health Level Seven Fast Healthcare Interoperability Resources) through Representational State Transfer Application Programming Interface (Rest API). The ECG device, completed at the cost of U$169 excluding labor, allows for the signal of 12 leads of ECG signal to be obtained from 10 electrodes mounted on the body. The processed ECG data was written to a JSON file with a maximum recording time of up to three days, managed by a Structured Query Language Server (SQL) Server database. The software retrieves patient data from electrical medical records in accordance with HL7 FHIR standards. A compact and easy-to-use ECG device was successfully designed to record ECG signals. An in-house developed software was also completed to display and store the ECG signals.

Web-based Database Courses E-Learning Application

This study was focused on the development of a web e-learning application for the database courses taken by Information Technology (IT) students at the College of Information and Communications Technology (CICT) of Bulacan State University (BulSU). The research methodology used in this project was the cross-sectional developmental approach. The Agile Software Development methodology was followed phase by phase, up to the development phase, to develop the system. It was used to produce the desired output rapidly while allowing users to go back through phases without finishing the whole cycle. The goal of this study was to create a web application that teaches Structured Query Language (SQL) in both the MySQL and SQL Server approaches. The application contains quizzes and examinations to allow self-assessment of learning. Additionally, an Entity Relationship Diagram (ERD) simulation was included to provide ERD creations in a drag-and-drop fashion. This study was evaluated using ISO/IEC 25010 software quality evaluation criteria. The study's overall mean was 4.24, 4.41, and 4.33, all with the descriptive meaning of "Very Good," which showed that the system performed its necessary functions as perceived by students, faculty members, and experts, respectively. In summary, the e-learning web application for database courses was fully developed. Moreover, the entity-relationship diagram was integrated well within the system and is accessible to the users. Lastly, respondents evaluated the developed web application using the ISO/IEC 25010 with an overall descriptive interpretation of "Very Good." For future developments of the study, an administrator panel may be developed to manage users and do other administrative tasks. Lastly, higher-order thinking skills questions on assessments and quizzes may be included.

Impact of trucks registered in other provinces on ETC differentiated charging in provincial expressway network

To evaluate the effect of policy on province-wide toll discount for electronic toll collection (ETC) trucks, and to clarify the influence of trucks registered in other provinces on the toll discount flowed back to the local enterprises, we use structured query language server (SQL Server) database technology to process the toll collection data on expressway network, and propose an algorithm of recovery rate for the explanatory variables of toll preference, and verify the feasibility of the algorithm is by a case study. The results show that the recovery rate of the study case is 43.38% when there is an 85% discount on ETC truck toll in 2019, and 52.77% of the 56.62% toll discount outflowed from the case studied is generated by the trucks registered in other provinces according to a conservative estimate. Among them, the proportion of the toll discount of trucks registered in other provinces with 6 axles accounts for 77.29%, which is the root of toll discount loss. Although the traffic number across the province is not large, the toll discount is rather large owing to the long distance and heavy load. The recovery or loss of toll discount concentrates in the trucks with 2 axles, 4 axles and 6 axles, and trucks with 6 axles accounting for the largest proportion. This paper provides a reliable analysis basis for the accuracy of the differential charging policy on expressway, and promotes the rapid development of transportation economy.

Storing and structuring big data in histological research (vertebrates) using a relational database in SQL

Database systems store data (big data) for various areas dealing with finance (banking, insurance) and are also an essential part of corporate firms. In the field of biology, however, not much attention has been paid to database systems, with the exception of genetics (RNA, DNA) and human protein. Therefore data storage and subsequent implementation is insufficient for this field. The current situation in the field of data use for the assessment of biological relationships and trends is conditioned by constantly changing requirements, while data stored in simple databases used in the field of biology cannot respond operatively to these changes. In the recent period, developments in technology in the field of histology caused an increase in biological information stored in databases with which database technology did not deal. We proposed a new database for histology with designed data types (data format) in database program Microsoft SQL Server Management Studio. In order that the information to support identification of biological trends and regularities is relevant, the data must be provided in real time and in the required format at the strategic, tactical and operational levels. We set the data type according to the needs of our database, we used numeric (smallint,numbers, float), text string (nvarchar, varchar) and date. To select, insert, modify and delete data, we used Structured Query Language (SQL), which is currently the most widely used language in relational databases. Our results represent a new database for information about histology, focusing on histological structures in systems of animals. The structure and relational relations of the histology database will help in analysis of big data, the objective of which was to find relations between histological structures in species and the diversity of habitats in which species live. In addition to big data, the successful estimation of biological relationships and trends also requires the rapid accuracy of scientists who derive key information from the data. A properly functioning database for meta-analyses, data warehousing, and data mining includes, in addition to technological aspects, planning, design, implementation, management, and implementation.

Database System Development Life Cycle (DSDLC) on System Libraries for Data Manipulation Language (DML) Using SQL Server 2008

Database System Development Life Cycle (DSDCL) is a method in database development. While the database language used to modify and retrieve data in a database is Data Manilation Language (DML). The DML that is often used is Structured Query Language (SQL) which is used to search and manipulate data in relational databases. SQL consists of simple syntax in the form of commands to manipulate data, these commands are called queries. The query language is used in implementing the Library System database using SQL Server 2008 RDBMS. The first step before performing DML using the query editor, must have a database and data that has been implemented with SQL Server 2008. In this discussion, only 4 (four) DML statements are explained. namely select, insert, update and delete by using the Library System database with SQL Server 2008 RDBMS. The select statement is used to display data from a table (1 or more) in the database. Update is used to make changes to data in tables in the database. Insert is used to fill in data and delete is used to delete data in tables in the database.

Analysis of the possibilities of optimizing SQL queries

Most of today's web applications run on relational database systems. Communication with them is possible through statements written in Structured Query Language (SQL). This paper presents the most popular relational database management systems and describes common ways to optimize SQL queries. Using the research environment based on fragment of the imdb.com database, implementing OracleDb, MySQL, Microsoft SQL Server and PostgreSQL engines, a number of test scenarios were performed. The aim was to check the performance changes of SQL queries resulting from syntax modication while maintaining the result, the impact of database organization, indexing and advanced mechanisms aimed at increasing the eciency of operations performed, delivered in the systems used. The tests were carried out using a proprietary application written in Java using the Hibernate framework.

A joint neuro-fuzzy malaria diagnosis system

Diagnosis takes a definitive role in the course of determining about clarifying patients as either having or not having the disorder. This method is relatively sluggish and tedious. Various fact-finding and data-mining methods are part of the approach of this article. In the development of the Collaborative Neuro-Fuzzy Expert System diagnosis platform, Neural Networks and Fuzzy Logic, which are artificial intelligence methods, have been merged together. Oral interviews were conducted with medical professionals whose experience was caught in the Expertise Developed Fuzzy Proficient Scheme. With Microsoft Visual C # (C Sharp) Programming Language and Microsoft SQL (Structured Query Language) Server 2012 to handle the database, the Neuro-Fuzzy Expert Framework diagnostic software was introduced. To capture the predominant signs, questionnaires were administered to the patients and filled out by the doctors on behalf of the patients.

Rams Have Heart, a Mobile App Tracking Activity and Fruit and Vegetable Consumption to Support the Cardiovascular Health of College Students: Development and Usability Study.

BackgroundWith the increasing use of mobile devices to access the internet and as the main computing system of apps, there is a growing market for mobile health apps to provide self-care advice. Their effectiveness with regard to diet and fitness tracking, for example, needs to be examined. The majority of American adults fail to meet daily recommendations for healthy behavior. Testing user engagement with an app in a controlled environment can provide insight into what is effective and not effective in an app focused on improving diet and exercise.ObjectiveWe developed Rams Have Heart, a mobile app, to support a cardiovascular disease (CVD) intervention course. The app tracks healthy behaviors, including fruit and vegetable consumption and physical activity, throughout the day. This paper aimed to present its functionality and evaluated adherence among the African American college student population.MethodsWe developed the app using the Personal Health Informatics and Intervention Toolkit, a software framework. Rams Have Heart integrates self-reported health screening with health education, diary tracking, and user feedback modules to acquire data and assess progress. The parent study, conducted at a historically black college and university-designated institution in southeastern United States, consisted of a semester-long intervention administered as an academic course in the fall, for 3 consecutive years. Changes were made after the cohort 1 pilot study, so results only include cohorts 2 and 3, comprising a total of 115 students (n=55 intervention participants and n=54 control participants) aged from 17 to 24 years. Data collected over the study period were transferred using the secure Hypertext Transfer Protocol Secure protocol and stored in a secure Structured Query Language server database accessible only to authorized persons. SAS software was used to analyze the overall app usage and the specific results collected.ResultsOf the 55 students in the intervention group, 27 (49%) students in cohort 2 and 25 (45%) in cohort 3 used the Rams Have Heart app at least once. Over the course of the fall semester, app participation dropped off gradually until exam week when most students no longer participated. The average fruit and vegetable intake increased slightly, and activity levels decreased over the study period.ConclusionsRams Have Heart was developed to allow daily tracking of fruit and vegetable intake and physical activity to support a CVD risk intervention for a student demographic susceptible to obesity, heart disease, and type 2 diabetes. We conducted an analysis of app usage, function, and user results. Although a mobile app provides privacy and flexibility for user participation in a research study, Rams Have Heart did not improve compliance or user outcomes. Health-oriented research studies relying on apps in support of user goals need further evaluation.

Automation and Simplification: Drivers of Innovative Collection and Use of Patient-Reported Outcomes Data.

The aim was to develop an electronic data capture (EDC) system to capture patient-reported outcome (PRO) measures successfully by automating processes identified as barriers to implementation. Clinical success, research impact, and patient acceptance of this system were evaluated during a pilot and a follow-up period 2 years later. During the pilot, there were 44,831 eligible visits. Capture rate was 99.0% (44,374 visits) and completion rate was 99.4% (44,108 visits). Capture rate was 99.4% and completion rate was 95.2% during the follow-up period. Zero help desk tickets were put in for the EDC system during either time period. Patients accepted the EDC system both during the pilot (1.4% refusal rate) and follow-up period (1.2%). An automated Structured Query Language server feed provided data used to produce numerous abstracts and manuscripts. Automation was crucial to overcoming implementation barriers and delivering PRO scores to the electronic health record in real time with minimal impact on clinical workflow. Automation also has supported PRO research.

Major complications of regional anesthesia in 11 teaching hospitals of China: a prospective survey of 106,569 cases

Study ObjectiveTo determine the incidence of major complications in patients undergoing regional anesthesia (RA) in China. DesignMulticenter prospective survey. SettingEleven teaching hospitals in China. Patients and InterventionsA total of 106,569 patients undergoing RA from April 1, 2009, to April 30, 2011, were involved. MeasurementInformation on patients, types of surgery, and RA techniques was collected with a standardized chart. After RA, the patients were followed up by an investigator in each center for 1 to 3 weeks according to the patient's condition. Data were integrated and analyzed with a structured query language server system. Main resultsAmong the patients undergoing RA, 37 developed major complications, including Horner syndrome (n = 9; 0.84/10,000), recurrent laryngeal nerve blockade (n = 6; 0.56/10,000), cardiac arrest (n = 1; 0.09/10,000), hematoma (n = 2; 0.19/10,000), seizures (n = 5; 0.46/10,000), catheter break (n = 1; 0.09/10,000), paraplegia (n = 1; 0.09/10,000), cauda equina syndrome (n = 2; 0.19/10,000), and extensive neuraxial block (n = 10; 0.94/10,000). The incidence of major RA complications varied from 0.8/10,000 to 18.8/10,000 among centers and was highest in cervical plexum block. Plastic surgery had the highest incidence of complications (19.0/10,000), most of which were recurrent extensive neuraxial block. The total incidence of major RA complications was 3.47/10,000. ConclusionThis large, multicenter, prospective survey revealed the incidence of major complications after RA in China's hospitals. Although severe complication like cardiac arrest is rare, it is distressing and challenging. Hence, there is still a room to improve on daily basis to further reduce complications related to RA.

SU-E-T-255: Development of a Michigan Quality Assurance (MQA) Database for Clinical Machine Operations

Purpose: A unified database system was developed to allow accumulation, review and analysis of quality assurance (QA) data for measurement, treatment, imaging and simulation equipment in our department. Recording these data in a database allows a unified and structured approach to review and analysis of data gathered using commercial database tools. Methods: A clinical database was developed to track records of quality assurance operations on linear accelerators, a computed tomography (CT) scanner, high dose rate (HDR) afterloader and imaging systems such as on-board imaging (OBI) and Calypso in our department. The database was developed using Microsoft Access database and visual basic for applications (VBA) programming interface. Separate modules were written for accumulation, review and analysis of daily, monthly and annual QA data. All modules were designed to use structured query language (SQL) as the basis of data accumulation and review. The SQL strings are dynamically re-written at run time. The database also features embedded documentation, storage of documents produced during QA activities and the ability to annotate all data within the database. Tests are defined in a set of tables that define test type, specific value, and schedule. Results: Daily, Monthly and Annual QA data has been taken in parallel with established procedures to test MQA. The database has been used to aggregate data across machines to examine the consistency of machine parameters and operations within the clinic for several months. Conclusion: The MQA application has been developed as an interface to a commercially available SQL engine (JET 5.0) and a standard database back-end. The MQA system has been used for several months for routine data collection.. The system is robust, relatively simple to extend and can be migrated to a commercial SQL server.

Applications of Ship Domain Theory to Identify Risky Sector in VTS Area

This paper describes the application method of bumper area defined in the ship domain theory and it is to identify risky sectors in VTS(Vessel Traffic Services) area. The final goal of this work is to develop early warning system providing the location information with high traffic risks in Mokpo VTS area and to prevent the human errors of VTS Officer(VTSO). The current goal of this paper is to find evaluation and detection method of risky sectors. The ratio between overlapped bumper area of each vessels and the summing area of a designated sector, Ratio to Evaluate Risk(RER) <TEX>${\gamma}$</TEX> is used as one of evaluation and detection parameter. The usability of overlapped bumper area is testified through three kinds of scenarios for various traffic situations. The marine traffic data used in the experiments is collected by AIS(Automatic Identification System) receiver and then compiled in the SQL(Structured Query Language) Server. Through the analysis of passing vessel's tracks within the boundary of Mokpo VTS area, the total of 11 sectors are identified as evaluation unit sector. As experiment results from risk evaluation for the 11 sectors, it is clearly known that the proposed method with RER <TEX>${\gamma}$</TEX> can provide the location information of high risky sectors which are need to keep traffic tracks of vessel movements and to maintain traffic monitoring by VTSO.

Literature-based analysis on relationship of symptoms, drugs and therapies in treatment of intestinal diseases

ObjectiveTo evaluate clinical articles published in the past 30 years using the Traditional Chinese Medicine (TCM) theory of the lung being connected with large intestine to treat intestinal diseases. We also analyzed the relationship between symptoms, drugs and therapies with data-excavating technology to aid management. MethodsAfter retrieving relevant clinical articles, we set up a database, used Microsoft Structured Query Language Server 2005 Analysis Services as a data-excavating tool, and applied the association rule to study the relationship between the symptoms, drugs and therapies of intestinal diseases. ResultsThe key symptoms of dyschesia, constipation, abdominal fullness, fatigue and pale tongue could be treated with Kuxingren (Semen Armeniacae Amarum), Huangqi (Radix Astragali Mongolici) and Gualou (Fructus et Semen Trichosanthis) to invigorate Qi and moisten the intestine. Among these agents, Kuxingren (Semen Armeniacae Amarum) was used most frequently. Clearing Fu-organs was the most prevalent therapy for abdominal fullness, dyschesia, constipation and red tongue. Clearing Fu-organs could be achieved with Kuxingren (Semen Armeniacae Amarum) and Gualou (Fructus et Semen Trichosanthis), whereas Qi could be invigorated using Huangqi (Radix Astragali Mongolici), Gancao (Radix Glycyrrhizae), Baizhu (Rhizoma Atractylodis Macrocephalae) and Kuxingren (Semen Armeniacae Amarum). Moistening the intestine was possible with Kuxingren (Semen Armeniacae Amarum), Huomaren (Fructus Cannabis) and Jiegeng (Radix Platycodi). Also, moistening the lungs was done with Kuxingren (Semen Armeniacae Amarum), ventilating the lungs with Kuxingren (Semen Armeniacae Amarum) and Gualou (Fructus et Semen Trichosanthis), and nourishing the lungs with Huangqi (Radix Astragali Mongolici), Gancao (Radix Glycyrrhizae) and Kuxingren (Semen Armeniacae Amarum). These data demonstrated that Kuxingren (Semen Armeniacae Amarum) was a key agent. ConclusionOur analyses of the literature showed clear relationships between symptoms (constipation, dyschesia, abdominal fullness), drugs [Gualou (Fructus et Semen Trichosanthis), Kuxingren (Semen Armeniacae Amarum), Huangqi (Radix Astragali Mongolici)] and therapies (moistening the intestine, clearing Fu-organs, invigorating Qi, ventilating the lungs).

Performance Analysis of Query Optimizers under Varying Hardware Components in RDBMS

Performance Analysis of Query Optimizers under Varying Hardware Components in RDBMS Query Optimization is the process of choosing the most efficient way to execute a Structured Query Language (SQL) statement, while query optimizer is a tool in Relational Database Management System (RDBMS) that carries out the process of optimizing a query. In this paper, four different RDBMS were considered namely Microsoft SQL 2010 Server, Oracle 11g Release 2, My SQL 5.6 and Microsoft Access 2010. For the purpose of testing four different data sets were used. The data was run using each data set (1 310 116, 1 047 999, 750 000, 500 000, 250 000 and 125 000). It was discovered that adding more memory to the system shows improved performance of the RDBMS query optimizer. Also, increasing Hard Disk Size has little effect on the performance of RDBMS. While changing the processor size from single core to duo core does not visibly show improved performance of the RDBMS. In all the cases stated, SQL Server 2010 offers better performance followed by My SQL 5.6, Oracle 11g release 2 and Ms Access 2010 respectively. Therefore this paper provides a framework to monitor the trend of the increasing/decreasing changes in hardware components on the performance of query optimizers in RDBMS. The application is recommended for RDBMS developers and maintainers.

Study on CAPP System Based on Rough Set Theory

As a significant technology of Computer Integrated Manufacturing System (CIMS), Computer Aided Process Planning (CAPP) is the bridge between Computer Aided Design (CAD) and Computer Aided Manufacturing (CAM). Meanwhile, it is a momentous foundation for building the overall information model of manufacturing of engineering product. By using of which along with the theory of rough set in rule reduction of expert system, the development of CAPP system framework is basis of .net platform, utilizing Visual Studio 2003 to design the system interface and associated structured query language (SQL) allow distributed data processing and data access, which is supported by SQL Server 2000. By designing and running the program, the method of designing is verified.

Surveillance of community genital Chlamydia trachomatis testing in the East of England, 2008-2010

Widespread testing for chlamydia is expected to result in a reduction in prevalence. In 2008, coverage indicators introduced by the Department of Health (DH) required collection and submission of all tests performed outside of genitourinary medicine clinics. No mechanism existed to collect community-based tests conducted outside of the National Chlamydia Screening Programme. The Health Protection Agency Regional Epidemiology Unit in the East of England (EoE) set up a new system to routinely collect and submit these tests on behalf of the regional Primary Care Organizations (PCOs). Testing data were requested from all laboratories commissioned to undertake chlamydia testing by EoE PCOs. Data were imported into a bespoke Structured Query Language server database and automated data processing routines were run. Data fulfilling national criteria were submitted for inclusion in the DH indicators. High-quality data were submitted to set deadlines with minimum impact on laboratories. Completeness of data variables varied by laboratory and by variable type. After complex data processing, 96% of laboratory reported tests in the 15-24 year age range were eligible for submission. This centralized method of data collection provides high-quality data, allowing for further analysis, which can be used to inform improvements in health care. These methods could be transferred to any of the hundreds of organisms for which similar laboratory data exist.

The Design and Implementation of an Automated System for Logging Clinical Experiences Using an Anesthesia Information Management System

Residents in anesthesia training programs throughout the world are required to document their clinical cases to help ensure that they receive adequate training. Current systems involve self-reporting, are subject to delayed updates and misreported data, and do not provide a practicable method of validation. Anesthesia information management systems (AIMS) are being used increasingly in training programs and are a logical source for verifiable documentation. We hypothesized that case logs generated automatically from an AIMS would be sufficiently accurate to replace the current manual process. We based our analysis on the data reporting requirements of the American College of Graduate Medical Education (ACGME). We conducted a systematic review of ACGME requirements and our AIMS record, and made modifications after identifying data element and attribution issues. We studied 2 methods (parsing of free text procedure descriptions and CPT4 procedure code mapping) to automatically determine ACGME case categories and generated AIMS-based case logs and compared these to assignments made by manual inspection of the anesthesia records. We also assessed under- and overreporting of cases entered manually by our residents into the ACGME website. The parsing and mapping methods assigned cases to a majority of the ACGME categories with accuracies of 95% and 97%, respectively, as compared with determinations made by 2 residents and 1 attending who manually reviewed all procedure descriptions. Comparison of AIMS-based case logs with reports from the ACGME Resident Case Log System website showed that >50% of residents either underreported or overreported their total case counts by at least 5%. The AIMS database is a source of contemporaneous documentation of resident experience that can be queried to generate valid, verifiable case logs. The extent of AIMS adoption by academic anesthesia departments should encourage accreditation organizations to support uploading of AIMS-based case log files to improve accuracy and to decrease the clerical burden on anesthesia residents.

Design and development of the database platform for C/C composites experiment data based on a structured query language server

For resolving the problems of storage and reasonable application of a great deal of experimental data in the production of C/C composites by CVI,an experimental database platform for C/C composites was deve～loped based on a structured query language server software as the basic database and VC++ as the development platform.The connection between the platform and database was constructed with the ActiveX Data Objects,a data interface technique developed by Microsoft.The experimental data were divided into five classes,including process methods,process analysis,property analysis,microstucture analysis,and anti-oxidation coating and its efficacy.The CVI simulation and optimization were performed by integrating this platform with the Matlab-engine technique,results of which can be used to shorten the C/C composite production time,to improve the efficiency,and to lower the cost.