基于ORACLE双库结构解决历史数据的查询

随着HIS的长期运行 ,数据库中存储的数据增多。同时 ,统计、分析需求增加 ,导致数据库的吞吐量降低。本文提出建立在用数据库和历史数据库的方法 ,该方法将联机事务处理在用的数据存储在在用数据中 ,联机事务处理不再用的数据存储在历史数据库中。文章对在用数据库中历史数据的标识、删除 ,在用数据库和历史数据库之间的数据归档和回迁等进行了论述。     

利用高级复制功能和触发器实现数据复制

在医院信息系统的数据库应用中,经常需要实现部分数据库复制的功能,基于oracle数据库的数据库复制技术(Advanced Replication),可以实现这一目标。本文介绍了数据复制机制原理,并对数据复制机制在军号卫一号数据库和药房数据库中的应用给出了具体的应用实例。     

医院Oracle数据库的安全策略

目的:在医院数据库的应用和建设中,减少数据库的事故发生率,保护数据库的安全、稳定,为医院用户提供正确可靠的数据。方法:从医院局域网硬件系统存在的问题、网络用户和数据库用户的密码安全问题、数据库的备份和恢复的重要性、以及Oracle数据库自身的特性等方面,分析研究网络数据库存在的安全隐患及各自的特点。并针对各自的问题提出解决方案;结果:通过规范的网络软件防火墙、硬件网闸设备、杀毒软件和数据库的备份等一系列措施,极大地降低了数据库受外界破坏的概率,使Oracle数据库的安全使用率基本达到100%;结论:根据实际情况建立一套安全、可靠、切实可行的Oracle数据库安全策略,成功地解决了医院Oracle数据库的安全问题。     

建立HIS历史数据库的实践与体会

历史数据库用于存储HIS数据库中的历史数据,并承担对历史数据的查询统计和数据挖掘任务。根据HIS历史数据库的用途,论述了HIS历史数据库的数据库配置特点;总结了HIS历史数据转储的方法和实施要点。     

LIS数据库迁移及dataguard方案研究

目的：论述LIS数据库的迁移及构建LIS数据库dataguard方案的具体实施步骤。方法：完成数据库的顺利迁移后使用RMAN创建备库dataguard。结果：实现了某院LIS数据库的顺利迁移,搭建了dataguard容灾服务器。结论：升级后的数据库性能明显得到提升,访问速度加快,同时构建dataguard后能增强了数据库的安全性。     

医科大学特种文献数据库建设研究

文章阐述医科大学建设特种文献学位论文数据库的目的意义及作用,就建立学位论文数据库的远程提交制度,规范、采集和加工数字化学位论文数据,建数据库检索平台,运用加密技术发布解决版权问题探讨数据库建设实施步骤。并就实践问题进行思考。结论:医科大学学位论文数据库建设具有现实意义。     

国内学术期刊数据库标引问题例证探析

对《中国学术期刊》和《中文科技期刊数据库》就我国学术期刊数据库的建设情况、同一数据库内的标引问题、数据库内关键词的标引问题、数据库内期刊文献无标引在数据库中的处理等问题进行了对比分析,指出：学术期刊数据库的文献标引应规范化,并应加强数据库标准化建设,从而达到学术期刊数据库标引统一化,提高文献检中率,进而真正实现文献资源的共享。     

胃癌数据库系统的构建

目的：设计并构建胃癌数据库系统。方法：采用Microsoft SQL Sever数据库管理系统构建数据库。利用VB进行编程,完成数据库应用程序设计。结果：完成了数据库、应用程序及相应的自定义查询工具的设计和构建。数据库功能模块包括录入、查询、系统管理、输出、用户和帮助。结论：胃癌数据库管理系统具有独立、清晰和升级快等优点,为临床研究提供了完整准确的原始数据记录,可投入临床使用。     

综合医院数据库非常规热备份问题分析

目的:通过对1例数据库热备份出现的问题进行分析,寻求医院数据库非常规热备份解决方案。方法:对数据库服务器扩容升级过程中进行数据库非常规热备份,观察并重现非常规热备份导致的异常现象,详细记录扩容升级步骤及出现的问题,分析原因,总结综合医院数据库服务器备份方案。结果:解决了医院数据库系统热备份过程中出现的问题,成功进行了数据库无损备份。结论:对数据库进行非常规热备份目的是,一旦出现问题可以利用备份数据最大程度进行数据恢复,尽管期间有可能会导致数据不一致等不确定问题,但还是应该按照规范流程进行数据库备份。     

使用RMAN实现克隆复制ORACLE数据库

目的：阐述RMAN克隆ORACLE数据库的概念,运用RMAN克隆ORACLE数据库技术,完善医院信息系统数据库平台的维护工作。方法：探讨使用克隆ORACLE数据库的目的与内容,介绍克隆数据库技术,并详细介绍创建辅助库实现数据库克隆的步骤以及列出部分实例内容。结果：利用RMAN克隆ORACLE技术,快速成功的生成了副本数据库,并围绕克隆过程中常遇到的问题和主要特点等展开讨论,提出相应的解决方案。结论：RMAN技术是ORACLE数据库克隆的一个安全可靠的工具,为完成医院信息系统的各项工作任务提供了安全、快速、方便、有效的保证。     

Job dimensions associated with severe disability due to cardiovascular disease.

This study explored associations among job activities and disability due to cardiovascular disease by merging national disability data with independently-obtained job activity data. Disability data were taken from a 1978 U.S. health interview survey (n = 9855). Expert ratings of job activities (dimensions) were obtained from a job analysis database (n = 2485 occupations). The two databases were merged such that job dimension data were imputed to each occupation in the disability database. Odds ratios for cardiovascular disability were calculated for scores in the second, third, and fourth quartiles for each of the 32 job dimensions, using scores in the first quartile as the standard. Job dimensions associated with cardiovascular disability were (a) hazardous situations; (b) vigilant work and responsibility for others; (c) exchanging job-related information; and (d) attention to devices. Occupations identified with high scores on these job dimensions included transportation jobs (air traffic controllers, airline pilots and attendants, bus drivers, locomotive engineers, truck drivers), teachers (preschool, adult education), and craftsmen/foremen (machinists, carpenters, and foremen).     

Cohort mortality study of roofing granule mine and mill workers. Part I: Estimation of historical crystalline silica exposures

A study was conducted to construct a job exposure matrix for the roofing granule mine and mill workers at four U.S. plants. Each plant mined different minerals and had unique departments and jobs. The goal of the study was to generate accurate estimates of the mean exposure to respirable crystalline silica for each cell of the job exposure matrix, that is, every combination of plant, department, job, and year represented in the job histories of the study participants. The objectives of this study were to locate, identify, and collect information on all exposure measurements ever collected at each plant, statistically analyze the data to identify deficiencies in the database, identify and resolve questionable measurements, identify all important process and control changes for each plant-department-job combination, construct a time line for each plant-department combination indicating periods where the equipment and conditions were unchanged, and finally, construct a job exposure matrix. After evaluation, 1871 respirable crystalline silica measurements and estimates remained. The primary statistic of interest was the mean exposure for each job exposure matrix cell. The average exposure for each of the four plants was 0.042 mg/m(3) (Belle Mead, N.J.), 0.106 mg/m(3) (Corona, Calif.), 0.051 mg/m(3) (Little Rock, Ark.), and 0.152 mg/m(3) (Wausau, Wis.), suggesting that there may be substantial differences in the employee cumulative exposures. Using the database and the available plant information, the study team assigned an exposure category and mean exposure for every plant-department-job and time interval combination. Despite a fairly large database, the mean exposure for > 95% of the job exposure matrix cells, or specific plant-department-job-year combinations, were estimated by analogy to similar jobs in the plant for which sufficient data were available. This approach preserved plant specificity, hopefully improving the usefulness of the job exposure matrix.     

Use of a Computerized Decision Support System for Primary and Secondary Prevention of Work-Related MSD Disability

The present study evaluates the effectiveness of a decision support system used to evaluate and control physical job stresses and prevent re-injury of workers who have experienced or are concerned about work-related musculoskeletal disorders. The software program is a database that stores detailed job information such as standardized work data, videos, and upper-extremity physical stress ratings for over 400 jobs in the plant. Additionally, the database users were able to record comments about the jobs and related control issues. The researchers investigated the utility and effectiveness of the software by analyzing its use over a 20-month period. Of the 197 comments entered by the users, 25% pertained to primary prevention, 75% pertained to secondary prevention, and 94 comments (47.7%) described ergonomic interventions. Use of the software tool improved primary and secondary prevention by improving the quality and efficiency of the ergonomic job analysis process.     

Job strain predicts survey response in healthcare industry workers

OBJECTIVES: To examine the effect of job strain on survey response. METHODS: 1,613 health care workers received a self-administered questionnaire. Thirty percent of them completed the survey on personal time without any personal monetary compensation. Working conditions were extracted by job title from the national database O*NET 6.0. Job strain was defined as the ratio of job demands to job control. Two complementary models (multi-level logistic and binomial pseudo Poisson regressions) were used to model individual survey response as a function of individual level demographic variables (age and gender), job-level socioeconomic status (SES) and job strain, and facility type (third level). RESULTS: Survey response was associated with higher SES and with less job strain. The association of SES and survey response was mediated by job strain. CONCLUSION: Employees' exposure to job strain may be an important influence on survey response, at least for workers who are not compensated for their time in completing a survey.     

基于Web of Science的养老护理员工作满意度研究可视化分析

目的了解养老护理员工作满意度领域的研究热点、前沿动态,为我国开展相关研究提供参考。方法运用CiteSpace 5.8.R1软件,对Web of Science核心合集数据库于1993年1月1日—2021年12月14日收录的养老护理员工作满意度相关文献的发文量、发文国家、关键词、共被引和突现词等进行可视化分析。结果 共纳入304篇文献,发文量总体呈上升趋势。养老护理员工作满意度的相关结局、影响因素和干预措施是研究热点,离职意向是研究趋势。结论我国养老护理员工作满意度研究处于起步阶段。建议相关学者加强理论研究,强化模型构建,拓展研究视角。     

Development, use, and availability of a job exposure matrix based on national occupational hazard survey data

A job exposure matrix has been developed based on potential exposure data collected during the 1972-1974 National Occupational Hazard Survey (NOHS). The survey sample was representative of all U.S. non-agricultural businesses covered under the Occupational Safety and Health Act of 1970 and employing eight or more employees. Potential worker exposure to all chemical, physical, or biological agents was recorded during the field survey if certain minimum guidelines for exposure were met. The job exposure matrix (JEM) itself is a computerized database that assists the user in determining potential chemical or physical exposures in occupational settings. We describe the structure and possible uses of the job exposure matrix. In one example, potential occupational exposures to elemental lead were grouped by industry and occupation. In a second example, the matrix was used to determine exposure classifications in a hypothetical case-control study. Present availability as well as future enhancements of the job exposure matrix are described.     

上海市工种暴露模式(1):化学性职业危害因素资料库的建立

[目的]建立化学性职业危害因素资料库，为设计上海市工种暴露模式(JEM)提供线索。[方法]按照上海JEM设计路径的有关步骤，按集1952-1989年化学性职业危害因素监测资料，对行业、工种、职业危害因素进行编码后将信息输入计算机，建立资料库。在整个过程中，注意对各个步骤进行质量控制。[结果]建成后的资料库共197965条记录，541种职业危害因素，样品总数为383486个；共涉及上海市20个区县的23192个工厂，408个行业，455个工种。记录数前3位的地区为杨浦、长宁和虹口；记录数前3位的行业和工种分别为工业专用设备制造业、化学原料业、玻璃制造业以及喷漆工、油漆工和铸工。[结论]通过汇总分析表明，资料库较客观地记录了1952-1989年这一阶段的化学性职业危害因素监测信息。     

Inter-method agreement between O*NET and survey measures of psychosocial exposure among healthcare industry employees

BACKGROUND: Imputed job characteristics had been used as proxy of exposure to working conditions. O*NET database provides job information that could be useful to evaluate psychosocial working conditions. METHODS: Consistency and total agreement between O*NET and self-reported psychosocial exposure (demand/control (DC), effort/reward (ER) proxy models, and emotional labor scale) were compared between healthcare specific (12 occupations, 215 workers) and other jobs (12 occupations, 146 workers). RESULTS: For dimensions of the DC and ER models, Spearman correlation and ICC coefficients were, in general, consistently high (ICC = 0.61 for decision latitude, 0.41 for rewards, 0.53 for ER ratio, and lower for others), particularly in the healthcare specific jobs. CONCLUSION: O*NET and questionnaire based psychosocial indicators showed a good job level agreement particularly on healthcare specific jobs. O*NET may be a useful source of job level psychosocial exposure, especially for the DC and ER models, for healthcare occupations within these types of facilities.