• 제목/요약/키워드: Microsoft access

검색결과 75건 처리시간 0.028초

근로자 정기건강검진을 기초로 한 영양 및 건강관리 전산화 프로그램 개발에 관한 연구 (A Study on the Development of a Computerized Nutritional and Health Guide Program Based on Periodic Health Examination at Work Sites)

  • 조여원;노성윤
    • 대한지역사회영양학회지
    • /
    • 제7권2호
    • /
    • pp.266-276
    • /
    • 2002
  • In this study, a computerized nutritional and health guide program for workers was developed. The dietitian at the work site could utilize periodically conducted medical examination data to develop an effective health care counseling model based on the developed Nutritional and Health Guide Program. A personal computer (Pentium II PC MMX-150, 32MB RAM, 2.95 GB HDD) with Microsoft Visual Basic 6.0 Enterprise Edition and Microsoft Access 97 installed, was used. The Nutritional and Health Guide Program consisted of seven main menus and 43 sub-menus. Included in the main menu were Basic Information, Periodic Health Check-ups, Visitors' Consultations, Nutritional/Health Tips, Nutritional Education according to Diseases, Help and Exit. In the Periodic Health Check-up menu, dieticians could input the health examination data of employees and touch for the recommended treatments for diseases such as obesity, diabetes, high cholesterol, hypertension and hepatitis. The Visitors'Consultation menu has been designed to compile health information about the employees who sought consultations. The Nutritional/Health Tips menu was designed to provide 14 kinds of programmed nutritional educational media and information. In the Nutritional Education According to Diseases menu, the dietitian could judge the subject's willingness to obtain treatment based on the Stage of Change Model. According, the content of the administered respective nutritional education was classified by stages. The Help menu, provide a chart of the method and procedure used as nutritional guidelines, by which the results of the health examination were classified as people in good health and those requiring special medical attention. The results of the evaluation of this program showed highly positive rates for usefulness (4.09), convenience (4.04), lettering size (4.02), interest (3.93), design (3.49). It also showed that 97.5% of the subjects thought that this program would be helpful for implementation of their company's nutritional educational program. Therefore, this menu could help dietitians plan, conduct, and evaluate their nutritional guidelines for employees. It is expected that The Nutritional and Health Guide Program developed in this study will play a role as a scientific and effective guide in conjunction with health examination results.

국유림(國有林) 관리(管理) 영림계획(營林計劃) 운영(運營)을 위(爲)한 데이터베이스 프로그램의 개발(開發) (Development of a Database Program for Management Planning in National Forests)

  • 박은식;정주상
    • 한국산림과학회지
    • /
    • 제88권1호
    • /
    • pp.63-72
    • /
    • 1999
  • 이 연구에서는 산림계획에 관계되는 자료관리는 물론 국유림에 적용되는 영림계획의 운영을 관계형 데이터베이스체계로 개발하였다. 이 데이터베이스체계에서는 영림계획 업무에서 요구되는 여러 가지 기능들을 메뉴체계에 반영하였으며, 산림조사, 영림계획, 연차계획 및 임반연혁 자료들을 유기적으로 관리할 수 있도록 하였다. 이 모델은 한글 윈도우 95 환경에서 구동하도록 설계되어 있으며 프로그램은 Visual Basic 5.0을 사용하여 작성하였고 데이터베이스 기본 엔진으로 Microsoft사의 ACCESS를 이용하였다. 이 논문에서는 영림계획업무 내용을 분석하고, 이를 토대로 작성된 관계형 데이터베이스 설계내역, 모델구조 및 응용체계를 설명하였다. 그리고 이상에서 설명한 데이터베이스의 응용체계를 실제 화면모드 출력창을 이용하여 제시하였다.

  • PDF

클라우드 스토리지에서의 중요데이터 보호 (Securing Sensitive Data in Cloud Storage)

  • 이셜리;이훈재
    • 한국정보처리학회:학술대회논문집
    • /
    • 한국정보처리학회 2011년도 춘계학술발표대회
    • /
    • pp.871-874
    • /
    • 2011
  • The fast emerging of network technology and the high demand of computing resources have prompted many organizations to outsource their storage and computing needs. Cloud based storage services such as Microsoft's Azure and Amazon's S3 allow customers to store and retrieve any amount of data, at anytime from anywhere via internet. The scalable and dynamic of the cloud storage services help their customer to reduce IT administration and maintenance costs. No doubt, cloud based storage services brought a lot of benefits to its customer by significantly reducing cost through optimization increased operating and economic efficiencies. However without appropriate security and privacy solution in place, it could become major issues to the organization. As data get produced, transferred and stored at off premise and multi tenant cloud based storage, it becomes vulnerable to unauthorized disclosure and unauthorized modification. An attacker able to change or modify data while data inflight or when data is stored on disk, so it is very important to secure data during its entire life-cycle. The traditional cryptography primitives for the purpose of data security protection cannot be directly adopted due to user's lose control of data under off premises cloud server. Secondly cloud based storage is not just a third party data warehouse, the data stored in cloud are frequently update by the users and lastly cloud computing is running in a simultaneous, cooperated and distributed manner. In our proposed mechanism we protect the integrity, authentication and confidentiality of cloud based data with the encrypt- then-upload concept. We modified and applied proxy re-encryption protocol in our proposed scheme. The whole process does not reveal the clear data to any third party including the cloud provider at any stage, this helps to make sure only the authorized user who own corresponding token able to access the data as well as preventing data from being shared without any permission from data owner. Besides, preventing the cloud storage providers from unauthorized access and making illegal authorization to access the data, our scheme also protect the data integrity by using hash function.

해수침투 조사자료의 통합적 해석을 위한 GIS의 적용 (Application of Geographic Information System for Synthetic Analysis of Multidisciplinary Data in Seawater Intrusion Assessment)

  • 최선영;황세호;박권규;신제현;윤왕중
    • Spatial Information Research
    • /
    • 제12권3호
    • /
    • pp.275-283
    • /
    • 2004
  • 국내 연안지역에서 광범위하게 발생하고 있는 해수침투를 정확하게 평가하고, 이에 대한 대책을 수립하기 위해서는 다양한 분야의 연구와 이들 상호간의 자료 통합과 유기적인 해석은 매우 중요하다. 현재 수리지구화학, 지구물리탐사 및 수리지질 등의 다양한 분야에서 해수침투 연구를 수행하고 있지만, 이들 자료의 공유나 체계적인 관리분야는 초보적인 수준으로 다양한 자료에 대한 검색과 관리가 어려울 뿐만 아니라, 자료를 통합하여 해석하는데 어려움이 따른다 따라서 본 연구에서 정밀조사 지역인 전남 영광군 백수읍 일대에서 획득하고 분석한 지표 및 시추공 물리탐사자료와 수리지화학자료를 데이터베이스로 구축하고, ArcView 스크립트어인 Avenue를 이용하여 데이터베이스 관리 및 시추공 3차원 가시화 인터페이스를 개발하였다. 이와 같은 지리정보시스템(GIS; Geographic Information System) 기반의 데이터베이스 구축과 사용자 인터페이스 개발로 다양한 종류의 해수침투 조사자료를 효율적으로 관리하고 통합할 수 있기 때문에 보다 정확하고 종합적인 분석이 가능할 것이다.

  • PDF

데이터베이스를 이용한 식료찬요(食療纂要)의 통계적 연구 (A Statistical Study on Sikryo-chanryo by Applying Database)

  • 이병욱;김기욱;황수정
    • 한국조리학회지
    • /
    • 제21권4호
    • /
    • pp.251-270
    • /
    • 2015
  • 본 연구의 목적은 한국 고유의 전통지식에 기반하여 음식을 이용한 건강증진 방법에 대한 지식을 체계화하고 통계적으로 활용할 수 있는 방법에 대하여 연구하는 데 있다. 이를 위하여 한국 고유의 음식을 이용한 질병치료에 대하여 언급한 고문헌인 식료찬요(食療纂要)의 지식을 DB로 구축하였다. 데이터의 처리는 Relational Data Model을 이용하였고, 9개의 데이터 테이블을 사용하였다. 소프트웨어는 MS사의 Access 2014를 사용하였다. 그 결과, 데이터베이스 쿼리문장을 이용하여 식재료, 약재별, 증상, 병명, 효능, 변증 정보를 유기적으로 조건을 만들어 통계적 결과를 즉시 확인할 수 있었다. 따라서 이러한 Relational Data Model을 이용하여 기존 방식의 연구논문을 대체할 수 있었다.

Constructing a Metadata Database to Enhance Internet Retrieval of Educational Materials

  • Oh Sam-Gyun
    • 한국문헌정보학회지
    • /
    • 제32권3호
    • /
    • pp.143-156
    • /
    • 1998
  • 이 논문은 미국 초중고교 교사들을 이용 대상자로 인터넷 상에 산재해 있는 강의안 및 교육자료의 메타데이터 DB를 구축한 GEM 프로젝트에 대한 보고이다. GEM 프로젝트에서는 현재 거의 표준으로 간주되는 더블린 코어의 15개 요소(Elements)를 채택하였고, 여기에 8개 요소를 첨가하여 검색을 원활히 하고자 하였다. GEM 메타데이터 DB의 구축에는 메타데이터 요소들간의 관계를 좀 더 명확히 표현할 수 있는 개념적 데이터 마들링을 사용하였고 메타데이터는 Sybase라는 관계형 데이터베이스에 저장했으며, 이 DB에 웹 인터페이스를 장착하는데에는 Microsoft 액티브 서버 페이지 (ASP) 기술을 이용하였다. GEM 메타데이터의 실제목록은 미국 전역에서 참가하고있는 컨소시엄 회원들에 의해서 이뤄지고 있으며, 그 결과는 인터넷을 통해 Sybase 관계형 데이터베이스에 자동적으로 입력된다. 이 논문에서는 더블린코어, GEM의 개념 및 논리 스키마들을 제시하는 한편, 메타데이터 DB의 구축에 개념적 데이터 마들링을 사용함으로써 얻어지는 장점들을 논하였다. GEM 프로토타입 시스템이 가동되고 있는 URL은 다음과 같다: http://lis.skku.ac.kr/gem/.

  • PDF

"침구갑을경(鍼灸甲乙經)"의 용어체계(用語體系)에 관한 연구 (A Study on Terminology in ZhenJiuJiaYiJing(鍼灸甲乙經))

  • 박찬영;이병욱;김기욱
    • 대한한의학원전학회지
    • /
    • 제26권3호
    • /
    • pp.127-139
    • /
    • 2013
  • Objectives : In the traditional oriental medicine, efforts to utilize the knowledge system so called Ontology have been achieved for systemic researches and efficient propagation of knowledge on oriental medicine. So far, in Korea, studies on drug ontology, pathological ontology, Cold Damage ontology and diagnostic ontology had been implemented, however, any development of ontology in the field of Acupuncture &, Moxibustion has not been achieved. Methods : We used Microsoft Access to collect terms in ZhenJiuJiaYiJing. The terms are related to human body area and structure. And then we built relationship of 'part of' and 'criterion of acupuncture point location' between the terms. Result & Conclusions : The terms used to explain acupuncture points in order to describe the position of acupuncture point name in ZhenJiuJiaYiJing were 8 words concerning different name of acupuncture point(穴名) 109, body part name(人體部位名稱) 150, meridian(經脈) 6 and structure(構造物).

The Development of Forest Fire Statistical Management System using Web GIS Technology

  • Jo, Myung-Hee;Kim, Joon-Bum;Kim, Hyun-Sik;Jo, Yun-Won
    • 대한원격탐사학회:학술대회논문집
    • /
    • 대한원격탐사학회 2002년도 Proceedings of International Symposium on Remote Sensing
    • /
    • pp.183-190
    • /
    • 2002
  • In this paper forest fire statistical information management system is constructed on web environment using web based GIS(Geographic Information System) technology. Though this system, general users can easily access forest fire statistical information and obtain them in visual method such as maps, graphs, and text if they have web browsers. Moreover, officials related to forest fire can easily control and manage all information in domestic by accessing input interface, retrieval interface, and out interface. In order to implement this system, IIS 5.0 of Microsoft is used as web server and Oracle 8i and ASP(Active Server Page) are used for database construction and dynamic web page operation, respectively. Also, Arc IMS of ESRI is used to serve map data using Java and HTML as system development language. Through this system, general users can obtain the whole information related to forest fire visually in real time also recognize forest fire prevention. In addition, Forest officials can manage the domestic forest resource and control forest fire dangerous area efficiently and scientifically by analyzing and retrieving huge forest data through this system. So, they can save their manpower, time and cost to collect and manage data.

  • PDF

Development of Crop Information System using Satellite Images

  • Kim, Seong-Joon;Kwon, Hyung-Joong;Park, Geun-Ae;Lee, Mi-Seon
    • 한국농공학회논문집
    • /
    • 제47권7호
    • /
    • pp.3-9
    • /
    • 2005
  • A computer system for crop information was developed using Visual Basic and ArcGIS VBA. The system is operated on ArcGIS 8.3 with Microsoft Access MDB. Landsat +ETM, KOMPSAT-1 EOC, ASTER VNIR and IKONOS panchromatic (Pan) and multi-spectral (MIS) images were included in the system to extract agricultural land use items identifiable at various spatial resolutions of images. Agriculture related data inventories using crop cover information such as texture and average pixel value of each band based on crop cultivation calendar were designed and implemented. Three IKONOS images were loaded in the system to show crop cover characteristics such as rice, pear, grape, red pepper, garlic, and surface water cover of reservoir with field surveys. GIS layers such as DEM (Digital Elevation Model), stream, road, soil, land use and administration boundary were prepared to understand the related characteristics and identify the location easily.

통계적 방법에 의한 건물 부하 산정 (Building Energy Load Estimation by a Statistical Method)

  • 정모;박화춘;임용훈
    • 한국태양에너지학회:학술대회논문집
    • /
    • 한국태양에너지학회 2008년도 춘계학술발표대회 논문집
    • /
    • pp.342-347
    • /
    • 2008
  • A Microsoft $Access^{(R)}$ application that estimates hourly building energy load is developed based on statistical field measurements. Hourly patterns of heating, hot water, cooling, and electricity loads are evaluated for an energy consuming community composed of various types of buildings. Popular building types such as apartments, offices, hotels and accomodations, stores, churches, schools and educational institutes are included in the model. For each type of buildings, hourly patterns for a month are measured and compiled to derive a 24-hour load distributions. Daily sum of heating, hot water, cooling, and electricity loads are also measured for the building types. The annual energy need profiles are generated by combining the 24-hour distribution and 365-day consumption patterns. The annual maximum values of the 8760 hours of a year for each load type serves as a guide for selecting a device capacity. A user-friendly interface that ushers users throughout the whole process is provided.

  • PDF