Database Management Program Research Articles

Interprofessional Learning and Psychiatric Expertise in Mental Health Courts.

Interprofessional collaboration is crucial to reduce overincarceration of people with severe mental illness. Learning how to collaborate occurs in 2 complementary ways. One model emphasizes cognitive tasks: becoming familiar with the values and knowledge of other disciplines. Another model emphasizes practical interactive skills: calibrating one's preexisting expertise to the demands of the local workplace. This qualitative study assesses the 2 models in the case of psychiatrists in a multidisciplinary mental health court who learned to divert people with psychiatric disease from jail and hence advance the court's mission. Ethnographic research was conducted over 4 years with the staff of a US mental health court. Interviews with 3 psychiatrists and observations of 87 staff meetings and probation review hearings were recorded on handwritten notes. Notes were transcribed, entered into a qualitative database management program (NVivo 12), and coded using the grounded theory approach. A master codebook was developed to identify crosscutting themes. Psychiatrists did not need deep familiarity with the values or skills of legal professionals to divert people with psychiatric disease from incarceration. They successfully inserted their expertise through 3 strategies-teaching about pharmaceutics, suggesting concrete interventions based on details of diagnosis and behavior, and shifting the collective assessment of defendants from a punitive to a therapeutic framework-that depended on their acquiring new interactive skills. However, they failed in their efforts to refine the eligibility criteria for admitting new defendants to the court; their expertise was underutilized because of the makeup of this interprofessional team. Reducing the overincarceration of people with severe mental illness depends on interprofessional collaboration. This study shows that discerning opportunities for (and blockages to) applying one's preexisting expertise and learning the perspective of other disciplines are key complementary ingredients of interprofessional learning in this setting. Research in other treatment courts is needed to assess the generalizability of this single case study.

Review on Decision Support System for Agrotechnology Transfer (DSSAT) Model

Traditional agronomic experiments were conducted at a specific location in time and space, resulting in long, seasonal, time-consuming, and expensive experiments. An international team of scientists has developed a decision support system for the transfer of agrotechnology, which has been used by researchers from around and the world for 15 years. This package incorporates models for over 42 crops (since Version 4.7.5) as well as tools to facilitate effective use of the models. Tools include database management programs for soil, weather, crop management, and experimental data, utilities, and implementation programs. Crop simulation models simulate growth, development, and yield in accordance with soil-plant-atmosphere dynamics. Over the last few years, it has become increasingly difficult to maintain the DSSAT crop models, partly due to the fact that there were different sets of computer code for different crops with little attention to software design at the level of crop models themselves. Thus, the DSSAT crop models have been re-designed and programmed to facilitate more efficient incorporation of new scientific advances, applications, documentation, and maintenance. The basis for the new DSSAT cropping system model (CSM) design is a modular structure in which components separate along scientific discipline lines and are structured to allow easy replacement or addition of modules. In this review paper, I described the approaches used to model the primary scientific components (soil, crop, weather, and management). Besides, the review paper describes the limitations, the future of the DSSAT model, and its importance. The benefits of the new, re-designed DSSAT–CSM will provide considerable opportunities for its development and others in the scientific community for greater cooperation in interdisciplinary research and in the application of knowledge to solve problems in the field, farm, and higher levels.

การพัฒนาโปรแกรมการจัดการฐานข้อมูลสำหรับการบันทึกข้อมูลการซ่อมบำรุงรักษาเครื่องคอมพิวเตอร์และอุปกรณ์: กรณีศึกษาบริษัทในอุตสาหกรรมอิเล็กทรอนิกส์

การพัฒนาโปรแกรมการจัดการฐานข้อมูลสำหรับการบันทึกข้อมูลการซ่อมบำรุงรักษาเครื่องคอมพิวเตอร์และอุปกรณ์: กรณีศึกษาบริษัทในอุตสาหกรรมอิเล็กทรอนิกส์

Diversity and gradients of vegetation of Sivrihisar Mountains (Eskişehir-Turkey)

AbstractThis study was carried out to determine the plant communities and understand the main topographical driving factors of floristic differentiation in the Sivrihisar Mountains (Eskişehir Province). Vegetation samplings were carried out according to the Braun-Blanquet approach. The relevés were stored in the TURBOVEG database management program. Hierarchical classification was carried out in PC-ORD program with Ward’s method and Euclidean distance as a resemblance measure. The diagnostic species were identified by a fidelity measure in the JUICE program. The results of the classification were visualized by ordination techniques in the CANOCO package by using principal component analysis. In conclusion, except for the degraded forest community, all the 7 steppe and 1 scrub plant communities studied were identified and described as new associations. Also, a syntaxonomical scheme for the vegetation of Sivrihisar Mountains was suggested.

Retained Ureteral Stents at a Tertiary Referral Stone Center—Who is at Risk?

IntroductionEncrustation of retained ureteral stents can lead to significant morbidity. We examined the treatment of patients with retained stents. MethodsPatients with retained stents were identified from a prospectively collected stone registry at a high volume center. The electronic medical record was queried using a relational database management program to parse operative notes for the terms “retained” and “encrusted.” The generated list was manually validated, and data were collected and analyzed retrospectively. We collected demographics, medical history, insurance type, and surgical and postoperative data. Preoperative degree of encrustation was graded using the forgotten, encrusted, calcified system. A cohort of patients undergoing ureteroscopy for urolithiasis was identified as a control group. ResultsOverall 66 patients with retained, encrusted stents and 4,962 controls were identified. The indication for stent insertion was most commonly obstructing stone (53%), after ureteroscopy (15%) and after extracorporeal shock wave lithotripsy (11%). There were no differences in age, body mass index or gender distribution. Patients in the encrusted stent group were more likely to have Medicaid or no insurance (p <0.001). Longer indwelling time predicted a higher degree of encrustation (mild—3 months, moderate/severe—9 months, p=0.02) as did prior stone history (mild 57%, moderate 76%, severe 93%, p=0.01). Patients with prior stone history, higher grade encrustation and upper coil encrustation were more likely to require more than 1 procedure for stent clearance (p=0.04, p=0.0001 and p <0.001, respectively). ConclusionsEncrustation of retained stents is a preventable phenomenon which can lead to significant morbidity. Indwelling time and history of stone disease are predictive of the degree of encrustation. Upper coil encrustation increases complexity of management, more often requiring multiple procedures.

The Development of Database Management Program to Reduce Searching Time of the Machine: A Case Study in a Stamping Press Manufacturer

The Development of Database Management Program to Reduce Searching Time of the Machine: A Case Study in a Stamping Press Manufacturer

Employing Information technology in Designing a Network Based Human Resources Information System

The research deals with the importance of ICT in the design of HRIS based on the network. Its importance lies in the practical side, through the adoption of the Technical Institute / Nineveh (application environment) on the HRIS based on the network as this system will reduce the effort and time required for data entry, and which also is maintained and confidentiality of information as well as access to information necessary for all individuals working in various units of the relationship, away from the movement between these units of information sources, participation is the objective basis of the objectives of the network. It has been used database management program MS Access in the development of the proposed system, as characterized by this program in its ability to work through the network with the same efficiency in which it operates on a personal computer, and that this program allows the possibility of sharing data, either by placing the entire database on the server, or put to share their data on the server. We has been taking the second option, where the database was divided and put tables on the server and then to copy all the objects on the workstations to reduce the pressure on the network, data is transmitted on the network and the rest of the organisms are present on all network computers.

Foreword: programming language interference and dependence

Interference and dependence are closely related concepts: interference being the observable phenomenon connected with dependence. Essentially, interference means that the behaviour of some parts of a dynamic system may influence the behaviour of other parts of the same system, while dependence specifies how the semantics of sub-components of a dynamic system are related. Identifying, measuring and controlling interference is essential in many aspects of modern computer science, in particular, in security, program analysis and verification, debugging, systems specification, model checking, program manipulation, program slicing, reverse engineering, data mining, distributed databases and systems biology. In all these fields, dependency and interference play a key role in designing suitable abstractions or in partitioning complex systems into simpler ones. Reasoning about dependency and interference requires theories, models and semantics, as well as algorithms and tools for their analysis. Beginning in 2004, the series of Programming Language Interference and Dependence (PLID) workshops has been devoted to promoting and spreading cutting-edge research in this field, with a particular emphasis on unpublished results with great impact on the theoretical basis. PLID2007, which was held at the The Technical University of Denmark on 21 August 2007, was particularly successful, and constituted the ideal forum for announcing a call for papers for a special journal issue on programming language interference and dependence, which would not necessarily be restricted to PLID2007 contributions. From the many expressions of interest, we selected six contributions by leading researchers in the field, some of which had been presented at the PLID2007 workshop. The selected papers focus on foundational aspects of dependency and interference, with applications in language-based security, data-base management systems and program slicing.

An Online Portal on Outcomes for Dutch Service Users

An Online Portal on Outcomes for Dutch Service Users

Establishment of Water Quality Monitoring Database in Poyang Lake

Abstract By selecting the data that can objectively reflect the water quality of Poyang Lake, using currently popular database management software and program language, a water quality database system is developed which can collect, manage, analyze and present water environment data. The result can provide information service for protecting precious lake data resources and for lake environmental protection and resources utilization.

A Reprise, Or Round Three: Using a Database Management Program as a Decision-Support System for the Cancellation of Serials

Annual journal inflation rates of eight percent or higher have compelled libraries to cancel journals. Since 1992 Purdue Libraries have had three major cancellation projects. This article reviews how the Humanities, Social Science and Education Library approached this task in 2009 and developed a database management program to identify titles based on two criteria: low use and the availability of the title in full text in one of three aggregator databases. The education and humanities departments reached the cancellation goal, but several social science departments had to transfer funds from the book budget to accommodate their journal subscription costs. This indicates the importance of the journal to research in these areas.

The Korea national research resource center.

Research resources with associated information are the most essential materials in the study and application of the life sciences, since these are employed in everything from basic research to advanced industrial high technology. Numerous nations recognize the importance of these scientific assets and are simultaneously enhancing their internal security measures and strengthening international cooperation to protect and share them. Consequently, most resource centers are sustained by governments under various national strategic plans. The Korea National Research Resource Center (KNRRC) is supported by the Ministry of Education, Science, and Technology (MEST) and consists of 33 research resource centers (RRCs), 5 core centers, and a head office. Its collection includes microorganisms, plants, animals, human specimens, and non-biologic materials. The KNRRC headquarters provides a total management system for the RRCs including database management, guidelines and educational programs, and certification of resources, workers, and the research centers themselves. These supervisory powers are granted to the KNRRC headquarters under national legislation entitled "Management and Application for Biological Resources." The KNRRC has signed memorandums of understanding for cooperation with 9 national and 5 international agencies. The former include the National Agro-biodiversity Center, the Rural Development Administration, and the Functional Proteomics Center, and the latter include the International Vaccine Institute and the RIKEN BRC of Japan. Currently, the KNRRC is serving as head office of the Asian Chapter of the International Society for Biological and Environmental Repositories.

HyperCard for the Design, Development, and Delivery of Instruction

The innovative software product HyperCard™ introduced in August, 1987, and today distributed free of charge with Apple Computer Incorporated's Macintosh line of computers, has sparked a flurry of interest among computer users. HyperCard represents advanced technology that, in a short time, has been put in the hands of hundreds of thousands of users, including a significant number of instructional designers and performance technologists. This article has three sections that introduce instructional designers and performance technologists to HyperCard. The first section describes just what HyperCard is and summarizes how it works. The second section presents the theoretical background of the program, from the perspectives of both cognitive psychologists and futuristic thinkers in the computing world. Finally, the third section describes three uses of HyperCard: (a) as a database management program, (b) as a vehicle for implementing hypermedia applications, and (c) as an authoring tool. For each of these three functions, the advantages and disadvantages of HyperCard for instructional designers and performance technologists are explored.

Database 101 and Bento

SPREADSHEETS are good at some things but bad at others. They are good at all things related to math and money. For example, a spreadsheet is the ideal application to use to create a customized grade book. On the other hand, spreadsheets are poor at sorting or displaying information in different ways. The trouble with spreadsheets is that, unless you are very careful, sorting a column does not sort all the other information in the row. Thus if you want to sort the students by their final grade in your customized grade book, you could end up just sorting the final grade column, which would disassociate the grades from the students. If you have a lot of information in a spreadsheet but do not use a lot of the math functions, there is a good chance that you would be better off putting the information in a database. One of the strengths of a database--technically, it is database management software--is the ability to sort the information in various ways. Another strength is the ability to view or print a single record, for example, all the grades an individual student has received. You can do this with a spreadsheet by setting the print range to a single row, but you would have to do this individually for each student, which would be very time-consuming. In a database, you just print all records individually or custom design reports. Another strength of modern databases is the ability to place such media as pictures, sounds, and video into the database. For example, if you had a database of students, you could include pictures in each student's record. FileMaker, a subsidiary of Apple, makes the highly regarded database management program called, appropriately, FileMaker 9. This capable database is available for Macs, PCs, and multi-user file servers. FileMaker 9 can manage enough data to meet the needs of a fairly large school district. One of FileMaker 9's strengths is its ability to retrieve and use up-to-the-minute information, such as news feeds and weather maps. Another strength of FileMaker is its ability to almost effortlessly display data dynamically on Web pages that it can create for you. But alas, FileMaker's $300 price tag is probably too steep for many Kappan readers. However, not long ago FileMaker released Bento 1 for $50. Bento 1 is an easy-to-use database for Macs running OS 10.5, Leopard. Currently, Bento 1 is the only version available, and it does require Leopard. Before I discuss Bento, I need to go over some database terminology. In Bento, information is stored in fields, which are part of a record, which is part of a collection, which is part of a library. For example, a person's last name would be one field, and all the fields containing information on a person constitute a record. All the people in a group make up a collection. Various collections make up a library. In most other databases, a library is called a database. And some database software allows you to subdivide your information into many more levels. The basic increment of a database is a record. Records can be likened to spreadsheet rows. An advantage of Bento, and most other databases, is the ability to display records in two ways: a view, which is like a spreadsheet, or a view. In form view, all the information in a record is displayed on a single screen or printed on a single page. If you have a media field--for example, a field with a person's photograph--you can display it in form view, but not in table view. Another advantage of form view is that it gives you plenty of room on a screen or page to display the information in various ways. If you get too many columns in a spreadsheet, the rows wrap across several pages. Another nice feature of Bento is that it comes with 24 templates for libraries, organized into Education, Personal, and Work. These templates work much like those that come with such presentation software as PowerPoint or Keynote. In the Education category, there are templates for Projects, Classes, Files, Contacts, To Do Items, Events, Digital Media, Student List, Membership List, and Notes. …

Bitki sosyolojisi çalışmalarında kullanılan sayısal metotlar ve bazı bilgisayar programları

As the phytosociological works in Turkey are examined, it can be seen that they were mainly focused on the classification of plant communities, but the number of the studies on ecologic, biologic and structural properties of the plant communities are not many. In this sense, numeric techniques (ordination and classification) and computer programs including these techniques are important assistant tools. The classification of plant communities and determination of their ecologic, biologic and structural properties is much easier today thanks to these techniques and computer programs. In this work, some knowledge were presented about ordination and classification techniques, which are widely used in vegetation science in the world and especially in Europe. TURBOVEG data base management program and JUICE program, which is used to classify and arrange the vegetation data were also presented. Keywords: Phytosociology, Juice, Ordination, Classification, Turboveg.

A standardized database management of middle ear surgery in Korea

Conclusion. The classification and hearing result reporting system of middle ear surgery provide a set of standard that otologic surgeons should comply with when they investigate the efficacy of procedures or report the post-operative results of middle ear surgery. Keeping up with this system will, in turn, facilitate and activate the evidence-based clinical research they would ask for. Objectives. The aims of the project were to establish the standardized classification nomenclature, to propose a guideline for the post-operative result reporting system, and to develop a database management program for middle ear surgery. Methods. Nine otologic surgeons from seven university hospitals in Korea carried out a field survey on the nation-wide status of middle ear surgery and its records, and also collected the information regarding international classification and result reporting system from 2001 through 2004. To make a consensus, it also underwent a process of public audit and, a questionnaire investigation, as well. Results. The classification of surgery consisted of four kinds of procedures of mastoidectomy, tympanoplasty, extraneous procedures, and concurrent procedures. Post-operative hearing result reporting consisted of basic requirement and reporting guidelines of hearing success. The basic requirements stated minimum follow up duration, and computing formulae of pure tone average (PTA) and post-operative air bone gap (ABG). The reporting guidelines included criteria of hearing success (Post-operative ABG ≤ 20 dB, hearing gain ≥15 dB, or hearing level ≤30 dB), post-operative ABG grading of excellent, good, no or poor improvement, and comparisons of hearing improvement among the groups. Next, a database management program was developed using the standardized classification and result reporting system. Structure of database is composed of 144 fields including patient information/preoperative findings (45 fields), operative findings (36 fields), operative procedures (29 fields), and post-operative follow up (23 fields).

The usefulness of a multidisciplinary educational programme after breast cancer surgery: A prospective and comparative study

A system has been implemented using a commercial database management program and a microcomputer for computerising pre-prosthetic surgery. Using selection criteria, clinical records can be added, edited/deleted, searched for, displayed on screen, generate consultation summaries and operative discharge letters to the referring consultant, general medical and general dental practitioners together with a synopsis of the clinical assessment and surgical admission. Surgical audit may be conducted on the records. This progam will hold 30 000 clinical records. Such a system is beneficial for personal and departmental audit, epidemiological studies and research into the prevalence of surgical treatment and postoperative morbidity.

Recent Development of Data Acquisition System on HL-2A

This paper introduced recent development of data acquisition system(DAS) on the HL-2A tokamak. The existing DAS has to be remodeled because of the evident improvement on HL-2A itself and the increasing amount of corresponding experimental data. First, the experimental network on HL-2A Tokamak as a communication center is described in detail. Secondly, "The File's Format & Criterion of Experimental Data on HL-2A Tokamak" as the core of the new software is also presented. Thirdly, not only a multi-screen image display system on HL-2A is discussed, but also the build-up of a new display wall system is dealt with. Finally, on the graphical WINDOWS platform and on the basis of the new Data File's Format & Criterion, the new software on HL-2A is described, including a new multi-layer database management program, a real-time processing program, a common interactive analytic processing program and a data post-processing program, which is now under development.

Reduction of amputation rates among Alaska Natives with diabetes following the development of a high-risk foot program

Objective. The prevalence of diabetes is increasing rapidly among Alaska’s Indian, Eskimo and Aleut populations. Approximately half the Native people with diabetes have no road access to hospitals or physicians, presenting a challenge in the attempt to prevent lower extremity amputation as a complication. In late 1998 funding became available for diabetes prevention and treatment among Native Americans. The tribal health corporations in Alaska decided to use a portion of this funding to implement a high-risk foot program to decrease the amputation rate. Program Design. The program initially involved a surgical podiatrist who provided training to local staff and performed preventive and reconstructive surgery on several patients with impending amputations. The program then provided training for a physical therapist to become a certified pedorthist. This individual established the long-term maintenance phase of the program by conducting diabetic foot clinics routinely at the Alaska Native Medical Center, a referral center in Anchorage. He also travels to other regions of the state to provide training for village and hospital-based health care providers and to conduct field clinics. A system was established in a common database management program to track the patients’ foot conditions. Patient education is emphasized. Results. The overall amputation incidence among all Alaska Native patients with diabetes decreased from 7.6/1,000 in the pre-program period (1996 to 1998) to 2.7/1,000 in the post-program period (1999–2001)(p<.001). The rate among Aleuts, who previously had the highest amputation incidence, decreased from 17.4/1,000 to 3.1/1,000 over the same time periods (p<.001). Among people who had had diabetes at least 10 years, the overall amputation incidence decreased from 16.4/1,000 to 6.8/1,000 (p=.021); among Aleuts the rate fell from 24.5/1,000 to 2.6/1,000 (p=.01). Conclusions. Though longer follow-up is needed, these data suggest that even in populations living in isolated regions, diabetic amputations can be prevented by a coordinated system to identify high-risk feet and provide preventive treatment and education in the context of a comprehensive diabetes management program in an integrated health system.

"Utstein style" spreadsheet and database programs based on Microsoft Excel and Microsoft Access software for CPR data management of in-hospital resuscitation.

In 1997, The American Heart Association in association with representatives of the International Committee on Resuscitation (ILCOR) published recommended guidelines for reviewing, reporting and conducting in-hospital cardiopulmonary resuscitation (CPR) outcomes using the "Utstein style". Using these guidelines, we developed two Microsoft Office based database management programs that may be useful to the resuscitation community. We developed a user-friendly spreadsheet based on MS Office Excel. The user enters patient variables such as name, age, and diagnosis. Then, event resuscitation variables such as time of collapse and CPR team arrival are entered from a "code flow sheet". Finally, outcome variables such as patient condition at different time points are recorded. The program then makes automatic calculations of average response times, survival rates and other important outcome measurements. Also using the Utstein style, we developed a database program based on MS Office Access. To promote free public access to these programs, we established at a website. These programs will help hospitals track, analyze, and present their CPR outcomes data. Clinical CPR researchers might also find the programs useful because they are easily modified and have statistical functions.