Comprehensive Database System Research Articles

Development of database structure and indexing for siddha medicine system - A platform for siddha literature analytics.

Siddha Medicine system is one among the oldest traditional systems of medicines in India and has its entire literature in the Tamil language in the form of poems (padal in tamil). Even if the siddha poems are available in public domain, they are not known to other parts of the world because, researchers of other languages are not able to understand the contents of these poems and there exists a language barrier. Hence there is a need to develop a system to extract structured information from these texts to facilitate searching, comparing, analysis and implementing. This study aimed at creating a comprehensive digital database system that systematically stores information from classical Siddha poems and to develop a web portal to facilitate information retrieval for comparative and logical analysis of Siddha content. We developed an expert system for siddha (eSS) that can collect, annotate classical siddha text, and visualizes the pattern in siddha medical prescriptions (Siddha Formulations) that can be useful for exploration in this system using modern techniques like machine learning and artificial learning. eSS has the following three aspects: (1) extracting data from Siddha classical text (2) defining the annotation method and (3) visualizing the patterns in the medical prescriptions based on multiple factors mentioned in the Siddha system of medicine. The data from three books were extracted, annotated and integrated into the developed eSS database. The annotations were used for analyzing the pattern in the drug prescriptions as a pilot work. Overall, 110 medicinal preparations from 2 Siddhars (Agathiyar and Theran) were extracted and annotated. The generated annotations were indexed into the data repository created in eSS. The system can compare and visualize individual and multiple prescriptions to generate a hypothesis for siddha practitioners and researchers. We propose an eSS framework using standard siddha terminologies created by WHO to have a standard expert system for siddha. This proof-of-concept work demonstrated that the database can effectively process and visualize data from siddha formulations which can help students, researchers from siddha and other various fields to expand their research in herbal medicines.

Reducing Food Waste at Retail Stores—An Explorative Study

Grocery retailers are in a dilemma. They often prioritize availability over other aspects due to strong competition in this sector and the imperative of realizing sales. The target for many grocery retailers has been high on-shelf availability and large variety to increase customer satisfaction. However, this policy contributes to a significant share of overstock. The economic pressure of unsold products, the environmental impact of wasted resources, and the ethical questions arising from discarding edible food, have increasingly thrown the spotlight on grocery retailers to change their strategies. Grocery retailers are thus facing a trade-off between increasing attractiveness via high availability on the one hand, and the environmental, social, and financial impacts of overstock, on the other. One common practice in dealing with overstock is mainly being reactive to mitigate the impact, using initiatives such as price promotions or donations. This explorative study investigates options for how grocery retailers can proactively reduce food waste via better planning of their store operations. Seven case companies participated in this qualitative study, where we focused on ultra-fresh products as the most important waste category. Face-to-face interviews with managers were the primary source for data collection. The heterogeneity of our sample enabled us to build a common understanding of proactive options to reduce food waste with enhanced operations. The analysis reveals six coherent and distinct topics. A basis for all proactive operational planning processes is (1) the use of a comprehensive database and information systems. This builds the foundation for (2) tailored demand forecasts related to perishable product-specific requirements. Subsequently, consideration is needed of (3) the enhanced planning of assortment sizes, (4) the definitions of differentiated service levels and (5) the tailored ordering and replenishment processes that impact food waste. Finally, (6) salvage options, such as dynamic pricing, secondary usage, and sustainable waste streams constitute valuable mitigation strategies. We formulated 15 propositions that could support the decisions of grocery retailers developing proactive food waste reduction practices. These propositions will guide future research, as they provide a coherent and cohesive picture of related topics in grocery retail operations.

Peran Tenaga Administrasi dalam Meningkatkan Mutu Layanan Administrasi di MTs Hidayatul Muhisinin

Researchers are interested in researching this in order to find out: The Role of Administrative Personnel in Improving the Quality of Administrative Services at Mts. Hidayatul Muhsinin With the main problem: Activities and Role of Administrative Personnel in Improving Service Quality, Barriers in Improving Administrative Service Quality and Strategies in Improving Administrative Service Quality. The method used in this study is a descriptive method with a qualitative approach. The main data sources in this study were school principals, Deputy Head of Curriculum, Finance Head of Administration and teachers obtained through interviews, observation, and documentation. The results of this study indicate that 1). The performance of administrative staff with the strategy implemented is to facilitate the payment or fee system that has been implemented since 2008, and maintain and manage school infrastructure facilities. The integration of the program from administrative staff with daily activities at school is still ongoing, although there are several obstacles in implementation. 2). The obstacles faced by schools in managing administrative services are archive warehouses that have not been optimal, a comprehensive database system has not been implemented and the preparation of the School Revenue and Expenditure Budget Plan still has difficulties related to costs that are not raised, existing facilities still have complaints from service users but complaints These complaints are not always handled quickly because they are related to the number of administrative staff. 3). Efforts are being made to overcome some of these obstacles, namely providing a letter of notification to parents to collect files immediately, increasing the payment of school fees to new students to cover the financing system that is not increased, so that each class pays school fees with different fees, the next strategy implementation of a system for controlling the condition of school facilities. The most important aspect that determines the success of an educational institution is the efficient implementation of all school organizational activities. The role of the administrative staff themselves in the school is very meaningful in supporting the smooth and successful administration of the school. Therefore, the administration must be able to carry out its duties and functions properly so that competence and expertise are needed to support the field of administration.

6 Evaluation of the Shock Index for Out-of-Hospital Sepsis Recognition

The purpose of this study was to assess the utility of sepsis suspicion and field vital signs, including calculation of SI and MSI in the out-of-hospital setting as a predictor for sepsis and sepsis-related outcomes including hyperlactatemia ≥2 mmol, as a marker of sepsis severity and a surrogate indicator for poor prognosis, and as a predictor for ICU admission and 28-day mortality. The authors present their real-world experience in a county EMS system evaluating the correlation of out-of-hospital shock index with hospital lactate, considered a marker for sepsis. This was a prospective observational study conducted as part of our county EMS system’s quality and research program. Our IRB-approved out-of-hospital research registry uses a comprehensive database and record-keeping system that prospectively identifies and collects relevant data for all potential sepsis cases. Patients with abnormal vital signs meeting SIRS criteria and either having suspected infection, or a shock index (defined as heart rate [HR]/systolic blood pressure [SBP] >1.0) or modified shock index [MSI] (defined as HR/mean arterial pressure <0.7 or > 1.3), or having high risk factors such as being from a nursing home or having human immunodeficiency virus, are called in as sepsis alerts (figure 1). Data were analyzed using JMP Pro 14.0. Contingency analyses with Fisher’s exact test and Pearson correlation were performed on serum lactate vs. sepsis diagnosis and in-hospital death, with relative risks calculated. A total of 1426 patients over the 24-month period were transported to five main receiving hospitals. The median age was 71 years, with an interquartile range of 60-80 years. The cohort was 45% female, 85% Caucasian, 14% Black, and 1% Hispanic. The initial shock index (SI1) ranged from 0.260 to 2.840 with a median of 1.11, and an IQR of 0.94 to 1.34. Sixty-eight percent had a “positive” SI1 (>1.0). The initial modified shock index ranged from 0.336 to 3.727, with a median of 1.465 and an IQR of 1.26 to 1.72. Seventy-four percent of the cohort had a “positive” MSI (<0.7, or >1.3). Three percent had MSI <0.7, while 71% had MSI > 1.3. 1321 patients (92%) had repeat vitals during transport, so a second SI was also calculated. The second SI (SI2) was elevated in 41%. All patients with elevated serum lactate were admitted to the hospital for sepsis. An elevated serum lactate was significantly associated with being diagnosed with sepsis (Pearson correlation, P<0.0001) with a relative risk of 38 (95% CI 20-72). Patients who were had an elevated SI were significantly more likely to be admitted for sepsis (P<0.0001, 95% CI 0.1038 to 0.2714). An elevated shock index mirrors an elevated lactate and as such appears to provide a reliable “invisible lactate” surrogate for use in the field.

Digitizing Premodern Text with the Chinese Text Project

AbstractThe widespread availability of digitized premodern textual sources – together with increasingly sophisticated means for their manipulation – has brought enormous practical benefits to scholars whose work relies upon reference to their contents. While great progress has been made with the construction of ever more comprehensive database systems and archives, far more remains not only possible but also realistically achievable in the near future. This paper discusses some of the key challenges faced, and progress made towards solving them, in the context of a widely used open digital platform attempting to expand the range of digitized sources available while simultaneously increasing the scope of meaningful tasks that can be performed with them computationally. This paper aims to suggest how seemingly simple human-mediated additions to the digitized historical record – when combined with the power of digital systems to repeatedly perform mechanical tasks at enormous scales – quickly lead to transformative changes in the feasible scope of computational analysis of premodern writing.

Developing the Chinese Academic Map Publishing Platform

The discipline of the humanities has long been inseparable from the exploration of space and time. With the rapid advancement of digitization, databases, and data science, humanities research is making greater use of quantitative spatiotemporal analysis and visualization. In response to this trend, our team developed the Chinese academic map publishing platform (AMAP) with the aim of supporting the digital humanities from a Chinese perspective. In compiling materials mined from China’s historical records, AMAP attempts to reconstruct the geographical distribution of entities including people, activities, and events, using places to connect these historical objects through time. This project marks the beginning of the development of a comprehensive database and visualization system to support humanities scholarship in China, and aims to facilitate the accumulation of spatiotemporal datasets, support multi-faceted queries, and provide integrated visualization tools. The software itself is built on Harvard’s WorldMap codebase, with enhancements which include improved support for Asian projections, support for Chinese encodings, the ability to handle long text attributes, feature level search, and mobile application support. The goal of AMAP is to make Chinese historical data more accessible, while cultivating collaborative opensource software development.

Orthopaedic registries - the UK view (National Joint Registry): impact on practice.

The National Joint Registry (NJR) was established in 2002 as the result of an unexpectedly high failure rate of a cemented total hip replacement.Initial compliance with the Registry was low until data entry was mandated. Current case ascertainment is approximately 95% for primary procedures and 90% for revision procedures.The NJR links to other data sources to enrich the reporting processes. The NJR provides several web-based and open-access reports to the public and detailed confidential performance reports to individual surgeons, hospitals and industry bodies.A transparency and accountability process ensures that device and surgical performance are actively monitored on a six-monthly basis, and adverse variation is dealt with in an appropriate way that underpins patient safety.The NJR also manages a comprehensive research-ready database and data protection compliant access system that enables external researchers to use the dataset and perform independent analyses for patient benefit.Moving forwards, the NJR intends to look at factors that lead to better outcomes so that good practice can be embedded into routine care.Cite this article: EFORT Open Rev 2019;4 DOI: 10.1302/2058-5241.4.180084

5) Progress in Internal Medicine by a Novel Comprehensive Database System Directly Connected with Electric Medical Records

5) Progress in Internal Medicine by a Novel Comprehensive Database System Directly Connected with Electric Medical Records

5) Progress in Internal Medicine by a Novel Comprehensive Database System Directly Connected with Electric Medical Records

5) Progress in Internal Medicine by a Novel Comprehensive Database System Directly Connected with Electric Medical Records

Definition of variables required for comprehensive description of drug dosage and clinical pharmacokinetics.

Electronic clinical decision support systems (CDSS) require drug information that can be processed by computers. The goal of this project was to determine and evaluate a compilation of variables that comprehensively capture the information contained in the summary of product characteristic (SmPC) and unequivocally describe the drug, its dosage options, and clinical pharmacokinetics. An expert panel defined and structured a set of variables and drafted a guideline to extract and enter information on dosage and clinical pharmacokinetics from textual SmPCs as published by the European Medicines Agency (EMA). The set of variables was iteratively revised and evaluated by data extraction and variable allocation of roughly 7% of all centrally approved drugs. The information contained in the SmPC was allocated to three information clusters consisting of 260 variables. The cluster "drug characterization" specifies the nature of the drug. The cluster "dosage" provides information on approved drug dosages and defines corresponding specific conditions. The cluster "clinical pharmacokinetics" includes pharmacokinetic parameters of relevance for dosing in clinical practice. A first evaluation demonstrated that, despite the complexity of the current free text SmPCs, dosage and pharmacokinetic information can be reliably extracted from the SmPCs and comprehensively described by a limited set of variables. By proposing a compilation of variables well describing drug dosage and clinical pharmacokinetics, the project represents a step forward towards the development of a comprehensive database system serving as information source for sophisticated CDSS.

Glioblastoma multiforme in the very elderly.

Glioblastoma is the most malignant and most common primary brain tumour and is treated with resection followed by post-operative radiotherapy and chemotherapy. However, a significant amount of patients are older than 80 years, and such an approach may not be appropriate. Data on patients aged 80 or older with glioblastoma from two hospitals was collected using the CNS Tumour Database on the Australian Comprehensive Cancer Outcomes and Research Database (ACCORD) system operated by BioGrid. Between 2008 and July 2011, 40 patients aged 80 years or older were diagnosed with glioblastoma. The median ECOG PS was 2 and the ASA score was 3. All 40 patients underwent surgery and 33% had a gross total resection. Only six patients (15%) had either post-operative radiotherapy or chemotherapy. The overall median survival was 4 months (range 0-18 months) and 28% of patients lived between 6 and 24 months. This is the largest reported cohort of very elderly patients with glioblastoma. Patients tolerated surgery but few went on to receive post-operative radiotherapy or chemotherapy. This patient population requires special attention and in particular would benefit from participation in suitable clinical trials to determine the best care regime.

Development of a Comprehensive Database System for Safety Analyst.

This study addressed barriers associated with the use of Safety Analyst, a state-of-the-art tool that has been developed to assist during the entire Traffic Safety Management process but that is not widely used due to a number of challenges as described in this paper. As part of this study, a comprehensive database system and tools to provide data to multiple traffic safety applications, with a focus on Safety Analyst, were developed. A number of data management tools were developed to extract, collect, transform, integrate, and load the data. The system includes consistency-checking capabilities to ensure the adequate insertion and update of data into the database. This system focused on data from roadways, ramps, intersections, and traffic characteristics for Safety Analyst. To test the proposed system and tools, data from Clark County, which is the largest county in Nevada and includes the cities of Las Vegas, Henderson, Boulder City, and North Las Vegas, was used. The database and Safety Analyst together help identify the sites with the potential for safety improvements. Specifically, this study examined the results from two case studies. The first case study, which identified sites having a potential for safety improvements with respect to fatal and all injury crashes, included all roadway elements and used default and calibrated Safety Performance Functions (SPFs). The second case study identified sites having a potential for safety improvements with respect to fatal and all injury crashes, specifically regarding intersections; it used default and calibrated SPFs as well. Conclusions were developed for the calibration of safety performance functions and the classification of site subtypes. Guidelines were provided about the selection of a particular network screening type or performance measure for network screening.

Construction challenges for urban tunnelling – The Copenhagen Metro Circle Line

AbstractThe Cityringen (The City Circle) project is the latest phase of the metro system in Copenhagen, Denmark. The phase comprises the construction of 17 new stations, three shafts, a control and maintenance centre and 16.5 km of twin‐tube tunnel excavated by four Earth Pressure Balance TBMs. The design and build contract was awarded in January 2011 and inauguration is planned for late 2018.The geology in the project area includes 10 to 30 m of Quaternary sand, gravel and clay tills underlain by limestone, often containing benches of flint or other hard horizons. The stations and shafts are constructed with secant pile walls or diaphragm walls. Permeation grouting is undertaken for one cavern and grouting for the break‐in and break‐out of the TBMs.Groundwater control is carried out by pumping from abstraction wells at the bottom of the deep excavation, treating the abstracted groundwater and recharging between 95 and 100 % of the groundwater.A monitoring system consisting of a comprehensive database system has been adopted, where real time information from the TBMs and from buildings and structures adjacent to the works is collected. Movement is monitored by an extensive 3D monitoring system together with extensometers, inclinometers and piezometers.

Developing a comprehensive database management system for organization and evaluation of mammography datasets.

We aimed to design and develop a comprehensive mammography database system (CMDB) to collect clinical datasets for outcome assessment and development of decision support tools. A Health Insurance Portability and Accountability Act (HIPAA) compliant CMDB was created to store multi-relational datasets of demographic risk factors and mammogram results using the Breast Imaging Reporting and Data System (BI-RADS) lexicon. The CMDB collected both biopsy pathology outcomes, in a breast pathology lexicon compiled by extending BI-RADS, and our institutional breast cancer registry. The audit results derived from the CMDB were in accordance with Mammography Quality Standards Act (MQSA) audits and national benchmarks. The CMDB has managed the challenges of multi-level organization demanded by the complexity of mammography practice and lexicon development in pathology. We foresee that the CMDB will be useful for efficient quality assurance audits and development of decision support tools to improve breast cancer diagnosis. Our procedure of developing the CMDB provides a framework to build a detailed data repository for breast imaging quality control and research, which has the potential to augment existing resources.

Databases and in silico tools for vaccine design.

In vaccine design, databases and in silico tools play different but complementary roles. Databases collect experimentally verified vaccines and vaccine components, and in silico tools provide computational methods to predict and design new vaccines and vaccine components. Vaccine-related databases include databases of vaccines and vaccine components. In the USA, the Food and Drug Administration (FDA) maintains a database of licensed human vaccines, and the US Department of Agriculture keeps a database of licensed animal vaccines. Databases of vaccine clinical trials and vaccines in research also exist. The important vaccine components include vaccine antigens, vaccine adjuvants, vaccine vectors, and -vaccine preservatives. The vaccine antigens can be whole proteins or immune epitopes. Various in silico vaccine design tools are also available. The Vaccine Investigation and Online Information Network (VIOLIN; http://www.violinet.org ) is a comprehensive vaccine database and analysis system. The VIOLIN database includes various types of vaccines and vaccine components. VIOLIN also includes Vaxign, a Web-based in silico vaccine design program based on the reverse vaccinology strategy. Vaccine information and resources can be integrated with Vaccine Ontology (VO). This chapter introduces databases and in silico tools that facilitate vaccine design, especially those in the VIOLIN system.

서울시 공공체육시설의 입지패턴 및 이용실태 분석에 관한 연구 : 구민체육센터를 중심으로

The study intends to suggest planning and policy recommendations to improve current supply system of the Public Sports service facilities in Seoul. To achieve the goal, a geographic database was built, while focusing on the social and elderly Public Sports service facilities. It is found that the number of facilities provided has sharply increased around 1995; then it has been decreasing mainly due to the lack of local public finance. The level of Public Sports service has been continuously improved. However, the service gap among local governments still exists although it has been smaller. Also, the levels of spatial service overlapping and exclusion are relatively serious. In light of the findings, two policy directions and six measures are proposed in order to improve current planning and supply system in Seoul. Fist, more systematic and planning-oriented policies are needed. They include the construction of comprehensive database system, a guideline and general plan for provision and management prepared by Seoul and local governments, and enhanced roles of current local welfare consultative group. Second, efficient and fair ways to supply new facilities in response to increasing demand for public services. Functional changes among them should be considered, and multi-use public facilities and contributions of public facilities by the private sector should be encouraged through institutional and planning reforms.

From Corynebacterium glutamicum to Mycobacterium tuberculosis--towards transfers of gene regulatory networks and integrated data analyses with MycoRegNet

Year by year, approximately two million people die from tuberculosis, a disease caused by the bacterium Mycobacterium tuberculosis. There is a tremendous need for new anti-tuberculosis therapies (antituberculotica) and drugs to cope with the spread of tuberculosis. Despite many efforts to obtain a better understanding of M. tuberculosis' pathogenicity and its survival strategy in humans, many questions are still unresolved. Among other cellular processes in bacteria, pathogenicity is controlled by transcriptional regulation. Thus, various studies on M. tuberculosis concentrate on the analysis of transcriptional regulation in order to gain new insights on pathogenicity and other essential processes ensuring mycobacterial survival. We designed a bioinformatics pipeline for the reliable transfer of gene regulations between taxonomically closely related organisms that incorporates (i) a prediction of orthologous genes and (ii) the prediction of transcription factor binding sites. In total, 460 regulatory interactions were identified for M. tuberculosis using our comparative approach. Based on that, we designed a publicly available platform that aims to data integration, analysis, visualization and finally the reconstruction of mycobacterial transcriptional gene regulatory networks: MycoRegNet. It is a comprehensive database system and analysis platform that offers several methods for data exploration and the generation of novel hypotheses. MycoRegNet is publicly available at http://mycoregnet.cebitec.uni-bielefeld.de.

Database systems in the forest department: the experience in Karnataka and strategies for the future

SUMMARY Karnataka forest department (KFD) has repeatedly attempted to develop and implement comprehensive database systems under externally aided projects. None has survived. KFD has also attempted to develop a GIS, and now has a 1:50 000 GIS for each forest division, developed by the State Remote Sensing Applications Centre. However, interactions with front line staff (FLS) show that while technologies like GPS are eagerly embraced, the database system is not. The main reason for this selective uptake of technology is that the MIS/GIS systems developed in the past were oriented mainly to the higher level information needs of top management and the outside world on a broad landscape scale, whereas FLS need specific information that can be satisfied only with village maps. The immediate priority is to develop a forest document database for all forest notifications and village maps for FLS, linking these to the higher departmental-level GIS later.

A PROTOTYPE OF GIS-BASED TRAFFIC ACCIDENT DATABASE SYSTEM: THAILAND CASE STUDY

This study aims to develop the comprehensive GIS-based traffic accident database system through the integration of hospital-based data, police data and the road inventory data. To determine how to integrate the data from three data sources, data taxonomy is utilized. Available data are hierarchically classified based on their share characteristic. Grouping data in this way is useful for understanding, designing, and building integrated data system. Data warehouse, a common data storage approach to integration, is utilized for the data integration. GIS is an enabling technology for the integration as well. The scope of data integration is established by identifying the model of target data (or integrated data) and identifying the disparate data that would be mapped to the target data. During the physical data integration process, data from the three data sources are extracted, transformed, cleaned and finally loaded into an integrated data source, a data mart or data warehouse.

SPATIAL PLANNING FOR INTEGRATED WATERSHED MANAGEMENT

Spatial planning is a valuable tool to support sustainable development by basing the plans, measures and interventions on key sustainability principles. The development of a spatial plan runs through three main processes; baseline data analysis of the existing situation and problems and potentials; formulation of objectives and strategies; and integration across sectors and synthesis of all aspects into a coherent balanced spatial framework. The technical part of planning was based on development of a comprehensive Geographic Information System (GIS) and database system and also included mathematical models to predict outcomes of certain measures. The planning maps of the relevant issues are constructed in order to plan for watershed management. As an example, the initial analysis determined that reforestation was a high priority issue for many reasons, both related to preservation and enhancement of nature and environment and people′s living conditions. GIS was applied to define potential zones for reforestation and mathematical models calculated the result in terms of runoff, sedimentation and water quality. The potential zones for reforestation were then used as a framework for integrated planning. This paper will demonstrate the planning maps used for integrated water shed management on the basis of spatial planning concept.