• Title/Summary/Keyword: 데이터베이스 관리

검색결과 3,416건 처리시간 0.045초

A Study on the Construction of Database, Online Management System, and Analysis Instrument for Biological Diversity Data (생물다양성 자료의 데이터베이스화와 온라인 관리시스템 및 분석도구 구축에 관한 연구)

  • Bec Kee-Yul;Jung Jong-Chul;Park Seon-Joo;Lee Jong-Wook
    • Journal of Environmental Science International
    • /
    • 제14권12호
    • /
    • pp.1119-1127
    • /
    • 2005
  • The management of data on biological diversity is presently complex and confusing. This study was initiated to construct a database so that such data could be stored in a data management, and analysis instrument to correct the problems inherent in the current incoherent storage methods. MySQL was used in DBMS(DataBase Management System), and the program was basically produced using Java technology Also, the program was developed so people could adapt to the requirements that are changing every minute. We hope this was accomplished by modifying easily and quickly the advanced programming technology and patterns. To this end, an effective and flexible database schema was devised to store and analyze diversity databases. Even users with no knowledge of databases should be able to access this management instrument and easily manage the database through the World Wide Web. On a basis of databases stored in this manner, it could become routinely used for various databases using this analysis instrument supplied on the World Wide Web. Supplying the derived results by using a simple table and making results visible using simple charts, researchers could easily adapt these methods to various data analyses. As the diversity data was stored in a database, not in a general file, this study makes the precise, error-free and high -quality storage in a consistent manner. The methods proposed here should also minimize the errors that might appear in each data search, data movement, or data conversion by supplying management instrumentation on the Web. Also, this study was to deduce the various results to the level we required and execute the comparative analysis without the lengthy time necessary to supply the analytical instrument with similar results as provided by various other methods of analysis. The results of this research may be summerized as follows: 1)This study suggests methods of storage by giving consistency to diversity data. 2)This study prepared a suggested foundation for comparative analysis of various data. 3)It may suggest further research, which could lead to more and better standardization of diversity data and to better methods for predicting changes in species diversity.

Ecotourism Visitors' Motivation/Attitude-Based Market Segmentation - Focused on Visitors at the Daebu Haesolgil, Gyeonggi Province - (생태관광지 방문객의 동기 및 태도에 따른 시장세분화 - 경기도 대부 해솔길 방문객을 중심으로 -)

  • Jeong, Yoonjeong;Kim, Seong-il
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • 제46권3호
    • /
    • pp.46-57
    • /
    • 2018
  • To increase knowledge regarding the ecotourism market in Korea, this study conducted a market segmentation based on tourists' motivations and attitudes. An onsite survey of visitors to Daebu Haesol 1 gil, Gyeonggi Province, was conducted from late November 2016 to early January 2017. An exploratory factor analysis and K-means cluster analysis were employed to identify market segments by using data collected from 434 respondents. The results showed three distinct segments labelled 'Nature Seeking Responsible Tourists', 'Passive Nature Seeking Tourists' and 'Nature/Cohesion Seeking Responsible Tourists.' All three segments had different levels of 'escape', 'health' and 'cohesion' motivations but commonly they all had a relatively high level of 'nature' motivation. As they also differed from each other in terms of sociodemographic and travel related characteristics as well as satisfaction level, it was concluded that motivation and attitudes of responsibility can be used for ecotourism market segmentation. A significant implication is that this research confirmed that the indicators on tourists' attitude of responsibility toward local communities are useful in segmenting visitors to ecotourism sites, which have been rarely studied in previous ecotourism market studies.

Development of Anti-disaster System for Natural Gas Governor Station Using Wire and/or Wireless Communication ($\cdot$무선 데이터 통신을 이용한 천연가스 정압소의 안전방재 시스템 개발)

  • Yoo Hui Ryong;Park Dae Jin;Koo Sung Ja;Park Seoung Soo;Rho Yong Woo
    • Journal of the Korean Institute of Gas
    • /
    • 제3권2호
    • /
    • pp.17-23
    • /
    • 1999
  • The wire and/or wireless data communication system for anti-disaster system of natural gas governor station was developed. In oder to prevent accidents of governor station, the operator was replaced by RTU(Remote Terminal Unit) which gather and transmit safety situation of governor station. The database and MMI(Man Machine Interface) were also developed to analyze the situation of governor station. The data communication between server and RTU was designed to switch automatically from wire to wireless communication and vice versa when one of them failed communication. We also have developed the patrol car management system which was applied GPS(Global Position System)/GIS(Geometric Information System), and the earthquake detection/transmission system which was adopted three dimension acceleration sensor. When a earthquake may occur, the earthquake detection/transmission system monitors data such as PGA(Peak Ground Acceleration), Sl(Spectrum Intensity) and orders the emergency shutoff valve close immediately.

  • PDF

The Construction and Common Use of Old Document DB in the Foreign Countries (해외 소장 고문헌의 DB구축과 공동활용 방안)

  • Kang, Soon-Ae
    • Journal of the Korean Society for Library and Information Science
    • /
    • 제42권3호
    • /
    • pp.61-79
    • /
    • 2008
  • The purpose of this paper is to investigate the three aspects of the construction and common use of old document DB in the foreign countries: i) the processing of old documents, ii) the problem and improvement of DB systems of old documents. and iii) the common use of old document DB. Results from this research are as follows: The National Library of Korea(NLK) copied old documents in the foreign countries from 1982 to 2006 and published the brief catalog. The Reogang Publishing company issued four volumes catalogs of old document in Japan. The National Research Institute of Cultural Heritage(NRICH) investigated old books and published some catalogs of several organizations in Japan. America. France. and all. The National Institute of Korean History(NIKH) investigated old archives and published some catalogs of several organizations in Japan. The characteristics of the Korean Old and Rare Collection Information System(KORCIS) of the NLK, the Old Books Cultural Heritage in Overseas System of the NRICH. and the Korea History DB System and MF Catalog/ Image System of NIKH were described in the DB systems of old documents, the problems of DB systems were checked over and some alternatives were suggested. In the common use of old document DB, KORMARC format and description rules(draft) for archives should be revised to adopt a new standard such as KS editions. and all the institutes involved should thoroughly follow the standards. when creating bibliographic records and digitizing texts. It is necessary to educate and train the specialists of old documents. A government organization should be established to supervise all the procedures of developing technology for sharing digitized resources. using contents. and cooperating with the related internationl organizations and institutes.

Reduction Factors of Pesticides with Different Physicochemical Properties under Washing and Cooking Conditions (물리화학적 특성이 다른 농약의 세척 및 조리방법에 의한 감소계수 산출)

  • You, Young-Hwa;Lee, Young-Sun;Kwon, Hoon-Jeong
    • Korean Journal of Food Science and Technology
    • /
    • 제43권5호
    • /
    • pp.537-543
    • /
    • 2011
  • The reduction factor of pesticides is getting more crucial these days. However, most studies have focused on the relationship between pesticides and commodities. This study was conducted to examine the pesticide reduction factor based on their physicochemical properties. Five pesticides were selected among 288 insecticides by considering the presence of an ionizable group, the log P, and boiling points. The correlation coefficients between log P and removal by tap water, 5% acetic acid, 20% ethanol, and 0.15% detergent were -0.835 (p<0.001), 0.336 (p=0.221), 0.659 (p<0.01), and -0.939 (p<0.001), respectively. Removal by blanching was affected by log P as it showed a positive correlation with a log P of 0.620 (p<0.05). Removal by frying showed a strong negative correlation with a log P of -0.913 (p<0.001). The results suggest that removing pesticides was affected largely by log P and by vapor pressure during cooking, whereas during washing, the matrix of the food also contributed to the reduction.

XML View Indexing Using an RDBMS based XML Storage System (관계 DBMS 기반 XML 저장시스템 상에서의 XML 뷰 인덱싱)

  • Park Dae-Sung;Kim Young-Sung;Kang Hyunchul
    • Journal of Internet Computing and Services
    • /
    • 제6권4호
    • /
    • pp.59-73
    • /
    • 2005
  • Caching query results and reusing them in processing of subsequent queries is an important query optimization technique. Materialized view and view indexing are the representative examples of such a technique. The two schemes had received much attention for relational databases, and have been investigated for XML data since XML emerged as the standard for data exchange on the Web. In XML view indexing, XML view xv which is the result of an XML query is represented as an XML view index(XVI), a structure containing the identifiers of xv's underlying XML elements as well as the information on xv. Since XVI for xv stores just the identifiers of the XML elements not the elements themselves, when xv is requested, its XVI should be materialized against xv's underlying XML documents. In this paper, we address the problem of integrating an XML view index management system with an RDBMS based XML storage system. The proposed system was implemented in Java on Windows 2000 Server with each of two different commercial RDBMSs, and used in evaluating performance improvement through XML view indexing as well as its overheads. The experimental results revealed that XML view indexing was very effective with an RDBMS based XML storage system while its overhead was negligible.

  • PDF

A Study on the Effective VTS Communications Analysis by the Method of VCDF in Busan Port (VCDF 방식을 통한 효율적인 VTS 통신 데이터 분석에 관한 연구 - 부산항을 대상으로 -)

  • Kim, Bong-Hyun;Park, Young-Soo
    • Journal of the Korean Society of Marine Environment & Safety
    • /
    • 제22권4호
    • /
    • pp.311-318
    • /
    • 2016
  • The VTS concept was located as a principal methods of maritime safety administration in world's major harbors and expected to become the pivotal role for the future of the maritime and harbor society with e-Navigation epoch. If recent limelight concept of big-data has been included in aspect of information gathering and analysis with various studies, it's required advanced studies to improve the information analysis capability and application range of the data that can be mining by the VTS. In this study, contrast to other studies that aimed quantitative analysis as communication number, it can be mining the time information and each of the communication VTS for the target vessel, including qualitative analysis, such as the purpose or the type of communication. This comparison across multiple items of the collected information, and presenting the VTS data mining model (VCDF) that can be analyzed for the purpose of analyzing way, type and number of communication by ship's type, also number of violations through VTS communication. First, In Busan port case, it shows frequently information service and shows frequently communicating with particular types of vessels. Second, Passive VTS carried out notwithstanding many kinds of traffic violations due to communication congestion. This arranged information can be used as data for the analysis, as possible the level of traffic for VTSO situational awareness, which pointed to the 'workloads' in 'IALA Guideline' and could be used as a database for future research of e-Navigation.

A Water Quality Modeling Study of Chunggye Stream during Combined Sewer OverFlow Period (합류식 하수관거 월류수 유입 기간 동안에 나타나는 청계천 수질 변화 모델 연구)

  • Yi, Hye-Suk;Park, Seok-Soon
    • Journal of Korean Society of Environmental Engineers
    • /
    • 제27권12호
    • /
    • pp.1340-1346
    • /
    • 2005
  • A water quality modeling study was performed for Chunggye stream during combined sewer overflow(CSO) period, utilizing the diagnostic system for water management in small watershed, CREEK-1(Cyber River for Environment and Economy in Korea). This system integrated geogaphic information system, data base, landscape ecological model(FRAGSTATS), watershed model(SWMM), water quality model (WASP5), and computer graphic. In this study, the watershed model and water quality model were extensively utilized so as to simulate water qualities and flow in Chunggye stream during wet periods. The Chunggye stream watershed was divided into 18 sub-basins in the watershed model and the stream reach into 11 segments in the water quality model. The watershed model was validated against field measurements of BOD, TN, TP, and flow at the downstream location, where the model results showed a reasonable agreement with the field measurements at all parameters. From this study, it was shown that the stream water quality would change along with elapsed time from rainfall start as well as rainfall intensity. The model results indicated that the water quality would significantly upgrade due to the first flush and high sewage ratio of CSO at the beginning of rainfall event, but become degraded along with the runoff increase due to dilution effect.

Prevalence and related risk factors of problem drinking in Korean adult population (한국 성인의 문제 음주 유병률 및 위험요인)

  • Park, Hyejin
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • 제19권1호
    • /
    • pp.389-397
    • /
    • 2018
  • The purpose of this study is to evaluate the prevalence and related risk factors of problem drinking in the Korean adult population. Participants (n=7,867) aged 19 years or older were selected from the Korea National Health and Nutrition Examination Survey [KNHANES] of 2007-2008. Sociodemographic characteristics and AUDIT score were obtained from the KNHANES dataset. AUDIT scores were categorized into three groups, including low risk, intermediate risk, and high-risk alcohol drinking according to WHO guidelines. In this study, the prevalence of high-risk and intermediate-risk alcohol drinking were 12.2% and 21.0%, respectively. Adjusted mean AUDIT score was higher in men, younger individuals, as well as those with lower education levels and those that smoked. Results revealed that demographic variables, including sex, age, education level, and smoking, were important factors affected high-risk drinking. In particular, since smoking was the most significant risk factor, the adjusted odds ratio for high-risk drinking among participants that smoked was 4.78 [(95% confidence interval (CI)=3.75-6.10, p<.0001)]. This study suggests that men, younger age, low educational level, and smoking are the risk factors for a high-risk alcohol drinking.

An Efficient Mobile Transaction Processing Scheme over Multiple Wireless Broadcast Channels (다중 무선 방송채널에서의 효과적인 모바일 트랜잭션 처리 기법)

  • Jeong, Ho-Ryun;Jung, Sung-Won;Park, Sung-Wook
    • Journal of KIISE:Databases
    • /
    • 제35권3호
    • /
    • pp.257-271
    • /
    • 2008
  • Wireless broadcast environments has character that a number of mobile client can receive data streaming from central server no matter how they are so many. Because it is asymmetric bandwidth in that uplink and downlink bandwidth are different. This advantage helps wireless broadcast environments is used in many applications. These applications work almost read operation and need control concurrency using transaction unit. Previous concurrency control scheme in single channel is not adapted in multi channel environments because consistency of data are broken when a mobile client tunes in a broadcast cycle in a channel and then move into another channel and listen to different broadcast cycle with already accessed broadcast cycle. In this paper, we propose concurrency control for read-only mobile transactions in multiple wireless broadcast channel. First of all, we adapt index and data dedicated channel and propose LBCPC(Longest Broadcast Cycle Per Channel) as new unit of consistency. In index dedicated channel, it is repeatedly broadcasted data in same BCPC(Broadcast Cycle Per Channel) until LBCPC. And mobile transaction executes validation using control information every LBCPC. As a result, consistency of data is kept and average response time is shorter than one in single channel because waiting time for restart reduces. And as control information is broadcasted more frequently than in single channel, it is guaranteed currency about data accessed by transaction. Finally, according to the simulation result, we verify performance of our scheme in multi channel as comparing average response time with single channel.