• Title/Summary/Keyword: DB Management Tool

Search Result 84, Processing Time 0.026 seconds

Design and Implementation of Educational Activity Based Groupware for Elementary School (초등학교 교육활동 기반 그룹웨어의 설계 및 구현)

  • Kim, Yung-Sik;Kim, Young-Bok;Yoo, Seon-Tack
    • Journal of The Korean Association of Information Education
    • /
    • v.4 no.1
    • /
    • pp.12-23
    • /
    • 2000
  • Education using the internet, such as a virtual school and distance education, has been limited to the studies of content and method in learning, It has been less studied to make advantage of internet with regard to school administration, teachers' research, and efficient communication within a school. Therefore, it is suggested to implement groupware which can be used in a school environment. For this purpose, this study attempts to design and implement groupware on that purpose. The main content consists of 7 areas: introduction of the school(including children's room), notice room, working room, room for educational materials, individual information, parents' room, internet journey. The basic tool for a groupware is implemented on Windows NT 4.0 Server and subsequent IIS 2.0. DB management based on SQL Server 6.5 makes it enable to manage various information.

  • PDF

SIPMan : SIP Traffic Management Tool (SIPMan : SIP 트래픽 관리 도구의 구현)

  • Kang, Kyong-Cheol;Chu, Seung-Woo;Lee, Kang-Hee;Ryu, Yeon-Seung
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2002.04b
    • /
    • pp.1491-1494
    • /
    • 2002
  • 본 논문에서는 VoIP(Voice over IP) 표준 프로토콜로 사용되고 있는 SIP 프로토콜의 트래픽을 감시, 분석하는 관리 도구인 SIPMan을 구현하였다. SIPMan은 SIP 패킷을 실시간으로 캡처할 수 있으며 call 에 대한 정보를 분석하고 DB 에 저장하는 기능을 가진다. 관리자 인터페이스는 web-based로 구현하였고 리눅스에서 구현되었다. SIPMan 관리자는 call detail record, SIP 트래픽 정보 등을 모니터링하고 분석할 수 있다.

  • PDF

A Study on Identification and Distribution of the Village Wetland Inventory Based on GIS - Focused on Seocheon-gun Province, Chungnam, Korea - (GIS를 기반으로 한 농촌 마을습지 판별 및 분포 특성 연구 - 충남 서천군을 사례로 -)

  • Park, Miok
    • Journal of Wetlands Research
    • /
    • v.20 no.1
    • /
    • pp.20-26
    • /
    • 2018
  • The purpose of this study is to construct a GIS / DB by grasping a small but ecologically valuable village wetland distribution, and to propose conservation management and wise use plan. The study area is Seocheon-gun, a typical farming village. Firstly, based on the digital topographical map (1:5,000), the Arc-GIS tool was used to identify the provisional(draft) village wetlands. In addition, for the management of village wetlands, wetlands with an area of more or less than $625m^2$ each were derived and according to ecological regions study area was classified into urban areas, inland areas and coastal areas. And finally, according to the wetland identifying indicators, the village wetlands were identified as the final village wetlands through indoor and field trips. The results of the study show that there are 570 village wetlands in Seocheon - gun province, which are 74 in urban areas, 220 in inland areas, and 276 in coastal areas. The case study for village wetland identification was conducted in one out of two urban areas (Seocheon - eup), two of four coastal areas (Biin - myeon and Seo - myeon), and three of seven inland areas (Masan - myeon, Hansan - myeon, and Sicho - myeon). The distribution of village wetlands was found mainly to be a village wetland with an area of less than $625m^2$. In addition, compared with inland areas, the discrimination rate of village wetlands in coastal areas and urban areas was relatively low, indicating that inland areas were still less disturbed, and land use in urban areas and coastal areas is changing rapidly. Especially, land with less awareness such as village wetlands is relatively easily damaged, and management strategy is urgent.

A Study on Typology of Japanese Institutional Repositories and Features of Groups (일본 기관 레포지토리 유형화 및 군집의 특성 분석)

  • Cho, Jane
    • Journal of the Korean Society for information Management
    • /
    • v.31 no.1
    • /
    • pp.143-161
    • /
    • 2014
  • While dCollections of Korea have been initiated by a government for metadata harvesting, institutional repositories of Japan have been managed as instituion's independent tool for not only collectiong, archiving and distributing their intellecture assets, but also realizing open access. This study analyzes IRDB of Japanese statistically for understanding features of institutional repositories and by clustering the repository on the basis of types of contents, the differences have been brightened. According to analysis result, Japanese repository contains diverse types of contents, such as journal articles;scholarly papers, text books and technical reports. etc. and clustered by five distinguished group with different contents type.

Design and Implementation of MongoDB-based Unstructured Log Processing System over Cloud Computing Environment (클라우드 환경에서 MongoDB 기반의 비정형 로그 처리 시스템 설계 및 구현)

  • Kim, Myoungjin;Han, Seungho;Cui, Yun;Lee, Hanku
    • Journal of Internet Computing and Services
    • /
    • v.14 no.6
    • /
    • pp.71-84
    • /
    • 2013
  • Log data, which record the multitude of information created when operating computer systems, are utilized in many processes, from carrying out computer system inspection and process optimization to providing customized user optimization. In this paper, we propose a MongoDB-based unstructured log processing system in a cloud environment for processing the massive amount of log data of banks. Most of the log data generated during banking operations come from handling a client's business. Therefore, in order to gather, store, categorize, and analyze the log data generated while processing the client's business, a separate log data processing system needs to be established. However, the realization of flexible storage expansion functions for processing a massive amount of unstructured log data and executing a considerable number of functions to categorize and analyze the stored unstructured log data is difficult in existing computer environments. Thus, in this study, we use cloud computing technology to realize a cloud-based log data processing system for processing unstructured log data that are difficult to process using the existing computing infrastructure's analysis tools and management system. The proposed system uses the IaaS (Infrastructure as a Service) cloud environment to provide a flexible expansion of computing resources and includes the ability to flexibly expand resources such as storage space and memory under conditions such as extended storage or rapid increase in log data. Moreover, to overcome the processing limits of the existing analysis tool when a real-time analysis of the aggregated unstructured log data is required, the proposed system includes a Hadoop-based analysis module for quick and reliable parallel-distributed processing of the massive amount of log data. Furthermore, because the HDFS (Hadoop Distributed File System) stores data by generating copies of the block units of the aggregated log data, the proposed system offers automatic restore functions for the system to continually operate after it recovers from a malfunction. Finally, by establishing a distributed database using the NoSQL-based Mongo DB, the proposed system provides methods of effectively processing unstructured log data. Relational databases such as the MySQL databases have complex schemas that are inappropriate for processing unstructured log data. Further, strict schemas like those of relational databases cannot expand nodes in the case wherein the stored data are distributed to various nodes when the amount of data rapidly increases. NoSQL does not provide the complex computations that relational databases may provide but can easily expand the database through node dispersion when the amount of data increases rapidly; it is a non-relational database with an appropriate structure for processing unstructured data. The data models of the NoSQL are usually classified as Key-Value, column-oriented, and document-oriented types. Of these, the representative document-oriented data model, MongoDB, which has a free schema structure, is used in the proposed system. MongoDB is introduced to the proposed system because it makes it easy to process unstructured log data through a flexible schema structure, facilitates flexible node expansion when the amount of data is rapidly increasing, and provides an Auto-Sharding function that automatically expands storage. The proposed system is composed of a log collector module, a log graph generator module, a MongoDB module, a Hadoop-based analysis module, and a MySQL module. When the log data generated over the entire client business process of each bank are sent to the cloud server, the log collector module collects and classifies data according to the type of log data and distributes it to the MongoDB module and the MySQL module. The log graph generator module generates the results of the log analysis of the MongoDB module, Hadoop-based analysis module, and the MySQL module per analysis time and type of the aggregated log data, and provides them to the user through a web interface. Log data that require a real-time log data analysis are stored in the MySQL module and provided real-time by the log graph generator module. The aggregated log data per unit time are stored in the MongoDB module and plotted in a graph according to the user's various analysis conditions. The aggregated log data in the MongoDB module are parallel-distributed and processed by the Hadoop-based analysis module. A comparative evaluation is carried out against a log data processing system that uses only MySQL for inserting log data and estimating query performance; this evaluation proves the proposed system's superiority. Moreover, an optimal chunk size is confirmed through the log data insert performance evaluation of MongoDB for various chunk sizes.

A Study on Assessment of Land Characteristics using Geographic Information Contents (지리정보콘텐츠를 활용한 토지특성의 평가 방안)

  • Kim, Hang-Jib
    • Proceedings of the Korea Contents Association Conference
    • /
    • 2004.11a
    • /
    • pp.170-174
    • /
    • 2004
  • Land assessement is a procedure that assesses developmental, agricultural or heritage suitability of land parcel according to such criteria as soil, location and usability. There are much problems to execute land assessment by law. Problems include inadequate basic data, lack of linkage with the spatial planning system, and inefficiency in operation. The purpose of this study is to investigate methods of developing land assessment as a sustainable land use management tool in a Korean context, using case study. In the case study, land assessment will be executed through GIS- based assessment method. On the basis of the results of this case study, practical and institutional problems are described, and technical and institutional solutions are suggested.

  • PDF

A study on conducting benchmarking plan for information services innovation (정보서비스 혁신을 위한 벤치마킹 계획 수립에 관한 연구)

  • Kim, Hye-sun;Lee, Seon-hee;Jeong, Do-heon;Shin, Ki-jeong
    • Proceedings of the Korea Contents Association Conference
    • /
    • 2007.11a
    • /
    • pp.391-395
    • /
    • 2007
  • Benchmarking is a process used in a lot of companies and public institutions because it is considered to be a practical tool for management innovation. However, it is hard to find out the development of systematic methods and applied cases for benchmarking on information services environment. This study tried to apply the benchmarking process to information distribution environment. This study examined the basic definition and standard process of benchmarking, and then conducted benchmarking plan to innovate tasks of database construction for information services at KISTI.

  • PDF

Electronic Commerce Workflow Modeling Tool Design Using Database Agent (DB에이전트를 이용한 전자상거래 워크플로우 모델링 도구 설계)

  • 오종태
    • Journal of the Korea Society of Computer and Information
    • /
    • v.8 no.3
    • /
    • pp.16-25
    • /
    • 2003
  • Modeller is defined as the office work procedures(business processes), and that is systemically based upon the real-time collaborative operations by a set of actors, which is called group. This paper describes the design of the ICN editor that is operable under the real-time collaborative computing environment. We use the database agent that enables the ICN editor to operate among multiple actors(group) through the event-driven collaboration platform. Consequently, a set of workflow and business processes defined through this editor is not only stored onto database but also transformed into the format of the workflow process definition language(WPDL) that is a standardized worflow description and specification language proposed by the workflow management coalition(WfMC). This method can improve the performance of workflow processing by minimizing the workflow execution cost occurred during workflow definition.

  • PDF

Applying NIST AI Risk Management Framework: Case Study on NTIS Database Analysis Using MAP, MEASURE, MANAGE Approaches (NIST AI 위험 관리 프레임워크 적용: NTIS 데이터베이스 분석의 MAP, MEASURE, MANAGE 접근 사례 연구)

  • Jung Sun Lim;Seoung Hun, Bae;Taehoon Kwon
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.47 no.2
    • /
    • pp.21-29
    • /
    • 2024
  • Fueled by international efforts towards AI standardization, including those by the European Commission, the United States, and international organizations, this study introduces a AI-driven framework for analyzing advancements in drone technology. Utilizing project data retrieved from the NTIS DB via the "drone" keyword, the framework employs a diverse toolkit of supervised learning methods (Keras MLP, XGboost, LightGBM, and CatBoost) enhanced by BERTopic (natural language analysis tool). This multifaceted approach ensures both comprehensive data quality evaluation and in-depth structural analysis of documents. Furthermore, a 6T-based classification method refines non-applicable data for year-on-year AI analysis, demonstrably improving accuracy as measured by accuracy metric. Utilizing AI's power, including GPT-4, this research unveils year-on-year trends in emerging keywords and employs them to generate detailed summaries, enabling efficient processing of large text datasets and offering an AI analysis system applicable to policy domains. Notably, this study not only advances methodologies aligned with AI Act standards but also lays the groundwork for responsible AI implementation through analysis of government research and development investments.

Development of Data Base and Interface for Sofa Design Considering Consumer Sensibility (소비자 감성을 고려한 소파 설계 DB 및 Interface 개발)

  • Song, Mi-Jin;Sim, Joung-Hoon;Heo, Chun-Wook;Yoon, Hoon-Yong
    • Journal of the Ergonomics Society of Korea
    • /
    • v.26 no.3
    • /
    • pp.81-89
    • /
    • 2007
  • The purpose of this study is to develop data base and interface for sofa consumers and sofa designers. The human sensibility ergonomics method was used to find the consumer needs and Quality Function Deployment (QFD) method was used to extract the designing characteristics required for sofa production. About 200 words and 100 images were gathered from sofa and furniture related catalogs and internet sites to find the best emotional words and images that can express the various sofa aspect. Among the collected words and images, 34 emotional words were selected for sensibility experiment according to the opinions of experts, relations of closeness and frequency of use, and 50 images were selected for the experiment by the diversity. Selected words and images were used for the semantic differential method with 94 subjects, and sensibility characteristics of sofas were defined through various statistical analysis methods including basic statistical analysis, factor analysis and multi-dimensional scale. In reflecting design characteristics of sofas, design factors of sofas were divided into backrest, seat, armrest, neck support and leg, and relative importance of each factor for design was determined with analytic hierarchy process (AHP) by utilizing the experts' opinions. Based on the results above, relationship analysis between emotional evaluation results and design factors was performed. Also, as various sofa images are presented diagrammatically through multidimensional scaling method, it can be used as an important tool for the development of sofa design. This study will contribute improving the product quality of sofas as it enables applying consumer needs into the sofa design.