• Journal of the Korean Society of Environmental Restoration Technology
• /
• v.25 no.4
• /
• pp.49-65
• /
• 2022

Since trees in the city are green assets that create a healthy environment for the city, systematic management of trees improves urban ecosystem services. The sporadic urban tree information centered on the site is vast, and it is difficult to manage the data, so efforts to increase efficiency are needed. This paper summarizes tree data inventory based on data constructed by Seoul Green Trust activists and constructs and discloses online database maps using Tableau Software. In order to verify the utilization of the map, we divided into consumer and supplier aspects to collect various opinions and reflect feedback to implement tree database maps for each area and species of Seoul Forest. As a result, the utilization value of tree database in urban parks was presented. The technical significance of this study is to systematically record the process of constructing and implementing a dashboard directly using the Mapbox platform and Tableau Software in the field of landscaping for the first time in Korea. In addition, the implications and supplements of landscape information were derived by collecting user opinions on the results. This can be used as an exploratory basis in the process of developing online-based services such as web and apps by utilizing landscaping tree information in the future. Although the visualization database currently constructed has limitations that ordinary users cannot interact in both directions because it utilizes business intelligence tools in terms of service provision it has affirmed both the database construction and its usability in web public format. In the future it is essential to investigate the assets of the trees in the city park and to build a database as a public asset of the city. The survey participants positively recognized that information is intuitively presented based on the map and responded that it is necessary to provide information on the overall urban assets such as small parks and roadside trees by using open source maps in the future.

• Proceedings of the Korean Institute of Intelligent Systems Conference
• /
• 2003.09a
• /
• pp.146-149
• /
• 2003

As the information that can collect from the web to local database is increasing, we propose a system that can suggest related local documents when new document arrives. We also propose for constructing an association dictionary using web search engines for similarity calculation. The prototype system is also developed, which is described in detail.

• Convergence Security Journal
• /
• v.12 no.1
• /
• pp.17-25
• /
• 2012

SQL Injection techniques disclosed web hacking years passed, but these are classified the most dangerous attac ks. Recent web programming data for efficient storage and retrieval using a DBMS is essential. Mainly PHP, JSP, A SP, and scripting language used to interact with the DBMS. In this web environments application does not validate the client's invalid entry may cause abnormal SQL query. These unusual queries to bypass user authentication or da ta that is stored in the database can be exposed. SQL Injection vulnerability environment, an attacker can pass the web-based authentication using username and password and data stored in the database. Measures against SQL Inj ection on has been announced as a number of methods. But if you rely on any one method of many security hole ca n occur. The proposal of four levels leverage is composed with the source code, operational phases, database, server management side and the user input validation. This is a way to apply the measures in terms of why the accident preventive steps for creating a phased step-by-step response nodel, through the process of management measures, if applied, there is the possibility of SQL Injection attacks can be.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.3 no.2
• /
• pp.433-445
• /
• 1999

Today's Web tends to change from simple guideline to more complex information Provider based on large amount of data, enabling a better understanding of the objects. It provides various information retrieval techniques. Therefore, these data have to be stored and maintained in a database system for efficiency and consistency. But database system absolutely requires systematic and consistent management techniques. As a consequence, a high trained and well-educated person should do it. In this paper, we design and implement a tool for easy and reliable database table creation and management on the web. If users log in this system, they can get a list of tables created by themselves and will find a hyper link per each table. Futhermore, they can view and manage it's contents.

• Journal of the Korea Society of Computer and Information
• /
• v.20 no.1
• /
• pp.185-195
• /
• 2015

During hospital peak times of outpatients, an effective mechanism that informs the newly receipted patient information to corresponding medical departments is lacking in current hospital reception systems. Since every department repeatedly searches entire patient reception database in sequential manner to acquire its reception information, this is a significant performance degradation factor in hospital information system. To improve hospital reception system efficiency, we developed two web socket based systems, a primary key transmitting batch system and a reception information transmitting real time system. The former reduced database access time compared to sequential search system as well as kept search time low regardless of receipted patient number. The latter effectively reduced waiting list updating time in request/response patient reception system by eliminating database access.

• Journal of the Korea Society of Computer and Information
• /
• v.14 no.3
• /
• pp.57-64
• /
• 2009

XML has become a do facto standard for structured document and data on the Web. An XML data deluge over the network will be more, since XML based standards such as Web Service and Semantic Web gets popular. There are efforts to store and query XML documents in a relational database system and recent efforts focus on how to provide such operations using XPath and XQuery. In this paper, we present study about those research efforts and we propose a new scheme to stoγe and query XML documents in a relational database using XPath query. The scheme uses a 'shred' method to store and translates XPath queries to SQL. We also present our empirical experiments using a RDBMS.

• The Journal of Society for e-Business Studies
• /
• v.6 no.3
• /
• pp.209-225
• /
• 2001

This paper Proposes the individual roles for developing small web application systems based on the Client/Server architecture with the activities and artifacts of each role and cooperation. The roles of Web Server part (i.e. User Interface Designer, Web Designer, HTML Writer), the roles of Application Server part (i.e. Domain Expert, Application Developer, Tester) and the roles of DB Server part (i.e. Database Administrator, Data Designer) are described. Furthermore, the role of the Development Leader that participates in development and manages all works in project and finds the solutions of problems in project, is also discussed. The Domain Expert analyzes the domain of the application in order to send the artifacts to the Application Developer. Then the Application Developer analyzes, designs and implements the application based on the artifacts of the Domain Expert and integrates the implemented program modules. Roles are related each other in this way, and cooperate until the application development is completed. Finally, we analyzed and compared these roles with the roles of RUP(Rational Unified process) and web wave. Suggested roles in this paper turned out to be efficient compared to the roles of the existing large-scale methodology.

• The Journal of the Institute of Internet, Broadcasting and Communication
• /
• v.18 no.2
• /
• pp.141-147
• /
• 2018

The group is one of the hobbies and other life groups, and each person in the group directly attends the meeting and works on the topic of the group. In this paper, we implemented voting, announcements, surveys, and suggestions, which are necessary functions for similar groups including group. We also provide web sites based on Apache web server for convenience of Android smartphone applications, OS except Android, Group management can be managed by using the manager's website which can manage the whole group management. It is designed with Apache web server, web communication language PHP, MySQL database, and Android.

• Korean Journal of Oriental Medicine
• /
• v.14 no.1
• /
• pp.91-96
• /
• 2008

Although the theory of Sasang Consititution is widely used in oriental clinic, there is only conceptual definition about the constitution not technical definition which is consented by every experts. In the present, the effect and different responses of constitutional medicines is the most widely accepted criteria among technical definitions. However, these medicines consist of several herbs which are included specific constitution. So, it is hard to define the characters about the Sasang Constitution through analysis of the medicines. In this paper, we collected the various information about the constitutional herbs, and constructed database and web application for accessing this information. It is useful and can be basis for finding the characteristics of constitutional medicines.

• Proceedings of the KSR Conference
• /
• 2006.11b
• /
• pp.1126-1131
• /
• 2006

Risk assessment of a railway system should be periodically conducted managing a large amount of accumulating accident/incident data and scenarios, which generally requires enormous time and efforts. Therefore, special information management system is essential for railway risk assessment, where data needed for decisions on managing the railway safety could be promptly supported. The objective of this study is to develop a railway accident analysis program for risk assessment. The program is application running on the web which links railway accident analysts throughout the railway industry to a central database. Data entered, together with associated code tables. is stored on MS-SQL database. The program uses the concepts of accident, safety events, causes, related factors(vehicle, person, infrastructure, tool/equipment), recommendations to bring together the various elements of railway accidents. The program will be useful in finding hazard conditions, accident scenarios, quantitatively assessing the risk, and providing pertinent risk measures, eventually serving to prevent railway accidents and reduce severities of railway accidents.