• Title/Summary/Keyword: MS-SQL Database

Search Result 50, Processing Time 0.024 seconds

Web-based Agricultural Machinery Rental Business Management System

  • Shin, Seung-Yeoub;Kang, Chang-Ho;Yu, Seok-Cheol;Kim, Byounggap;Kim, Yu-Yong;Kim, Jin-Oh;Lee, Kyou-Seung
    • Journal of Biosystems Engineering
    • /
    • v.39 no.4
    • /
    • pp.267-273
    • /
    • 2014
  • Purpose: This study was conducted to develop a web-based business management system to ensure the efficient operation and transparent management of government-subsidized agricultural machinery rental businesses. Methods: An MS_SQL2000 database management system (DBMS) solution was utilized in the system for high system compatibility and integrated management. This system was targeted to be compatible with Internet Explorer 6.0 or later and to ensure security and seamless web operations. The system administrator is able to manage a fleet of agricultural machinery, including various inventory codes, release and return, fleet registry, and business performance. Users (farmers) may search the database of rental machinery and reserve them. Results: With respect to rental reservations, the system administrator can manage the fleet by setting the rental status to Approved, Released, or Returned. Through the web, the administrator can also create a database that includes machinery specifications, features, and rental rates. In addition, business performance data can be analyzed using a diverse array of tools to streamline the rental business. Without having to go to the rental office, users can save time and money by searching for and renting agricultural machinery through the information available on the website, including availability, specifications, and rental fees. After deploying the system, the time required to analyze monthly performance and create reports was dramatically reduced from 20 days per person to one day per person. Conclusions: Since 2014, AMRB has been installed and is operating in agricultural machinery rental businesses in 31 cities and counties in South Korea. This study recommends continued expansion and dissemination of AMRB for the systematic and efficient management of agricultural machinery rental businesses.

A Study on Developing XML Documents and RDB Mapping Using Tag Free XML Development Tools (Tag free XML 개발 툴을 이용한 XML 문서 개발과 RDB 매핑에 관한 연구)

  • Woo, Won-Taek
    • Journal of Korea Society of Industrial Information Systems
    • /
    • v.11 no.5
    • /
    • pp.37-52
    • /
    • 2006
  • XML architecture is important to wireless or wired presentation. It is also important for data exchange between businesses. XML forces the separation of content from style and gives wired or wireless devices flexibility for interpretation. Separation of content, style, and logic is key to advanced architecture. XML can be exchanged among databases on multiple systems with presentation on wired or wireless devices. An XML schema might need to be defined, or an established DTD might need to be transformed to access a relational database on the server. The purpose of this study is to generate XML documents such as DTD, XML schema, RDB mapping using Tagfree's XML developer tools in order to experience whole processes mentioned above. Overall understanding of data structures of and database processing with XML documents, which is essential to XML programming and database processing, can be accomplished with this study without much endeavor to learn complex XML syntax. The future study can be extended on the subject of web programming with DOM or SAX API.

  • PDF

Development of a Web-based Information System for Rural Settlement Environment Diagnosis (웹기반의 농촌정주환경진단 정보시스템 개발)

  • Bae, Seung-Jong;Kim, Dae-Sik;Kim, Tae-Gon
    • Journal of Korean Society of Rural Planning
    • /
    • v.16 no.3
    • /
    • pp.117-129
    • /
    • 2010
  • The purpose of this paper is to develop a web-based information system for rural settlement environment diagnosis which is useful to apply the village based evaluation for new rural development projects. To achieve this purpose, this study performed : 1) analyzing the business process in the field of rural settlement environment diagnosis, 2) designing the data flow diagram and the database based on settlement environment diagnostic indices(SEDI), and 3) developing the system using APM (Apache, PHP, and MySQL) of web-system development environment. The developed system was applied to the study rural villages for testing of efficient and logical working. Users of the system, such as, researchers, decision makers, and rural residents, can input directly the village data to diagnose through a file format of Excel in MS Office. Futhermore, they can analyze the visual results with graphic and graph types, simultaneously. From the results of this study, it showed that the developed system enables decision-makers not only to assist the planning process of the rural village development project, but also to improve the level of information technology in the research and planning field concerning with rural development.

A Study on Implementation and Design of Web-based Web-Cost Management System: Part 1; Design (웹 기반의 품질코스트 관리시스템 구축 : 제1부;시스템 설계)

  • Chung Young-Bae;Kim Yon-Soo;Kim Jun-Hong
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.27 no.3
    • /
    • pp.97-105
    • /
    • 2004
  • The purpose of this study is to design and implement web-based quality cost management system to measure the performance of quality improvement activities in the business firms. The designed web-based quality cost management system which is also known as WQCMS (Web-based Q-Cost Management System) utilized newly classified objective performance indicator items to measure quality related activities. Well-classified performance measurement Indicator item lists which are played key role in the system was researched and standardized according to size and business categories of enterprise. Its code standards are based from fundamental PAF Model. Developed WQCMS have ability to collect and analyze quality data generated from various different departments in the inside or outside of the enterprise without any limitations, if end-users are able to access wide area network. It provides the capability to integrate quality information from database and to generate various easy analysis reports to management's needs using built-in analysis tool modules with real-time. The proposed system was developed using Microsofi's .Net technology, ASP.NET and MS-SQL Server 2000. By web-enabling Q-cost management system, the effectiveness of the system management and utilization was realized by easiness of information Integration and economical efficiency.

A Case Study on Mobile Web-service Implementation for a VMI System of Small.medium sized the Auto-parts Manufacturer in Supply Chain (공급사슬관계에서 중.소 자동차부품제조업체의 VMI시스템에 관한 웹서비스구현)

  • Na, Sang-Gyun;Oh, Myung-Hyun;Jeong, Byung-Ho;Lee, Jun-Su
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.30 no.2
    • /
    • pp.29-36
    • /
    • 2007
  • This study was concerned about mobile web-service of a VMI in the SCM system. The VMI would be a main module part of the SCM and regarded as very important thing on supply chain. Therefore, it was essential to react in real time of materials production and situation of used auto-part in procurement company. We could find an affordable method to realize the VMI in a web service. The web service has made inter relevant enterprise easy to collaborate because of supporting most operating system and frame-work. Moreover, the use of a mobile tools was guaranteed a product recording and requirement of materials to real time in a rapid changing of production environments. The result of this research was very useful to apply the VMI system in medium and small sized auto parts company. This web service package has programmed the Visual Studio Dot Net 2003 and the MS SQL 2000 as database.

Development of Operating S/W and DBMS for Deep-sea Manganese Nodule Miner (심해저 망간단괴 집광기의 운영 소프트웨어 및 데이터베이스 관리시스템 개발)

  • Park, Soung-Jae;Yeu, Tae-Kyeong;Yoon, Suk-Min;Hong, Sup;Kim, Hyung-Woo;Choi, Jong-Su;Kim, Sang-Bong
    • The Sea:JOURNAL OF THE KOREAN SOCIETY OF OCEANOGRAPHY
    • /
    • v.13 no.3
    • /
    • pp.229-236
    • /
    • 2008
  • The deep-sea miner is the tracked vehicle system which drives on the deep-seabed and gathers a manganese nodules. The miner is operated by remote control in real-time by the station of surface vessel. So operating S/W is a important part of miner remote operating. At present, the test miner has been designed and manufactured for near-shore sea-test. The test miner consists of mechanical parts, and electric-electronic parts. Because those parts should be controled and monitored remotely, operating S/W for control and monitoring is necessary by all means. In this paper, real-time operating S/W for a control and monitoring of the test miner was designed and developed using PXI, embedded controller and LabVIEW. This real-time operating S/W was developed for an efficient test of test miner in a near seabed area. Moreover, database management system(DBMS) was developed too for the data management of test miner monitoring using MS SQL and LabVIEW.

Web-Based Data Processing and Model Linkage Techniques for Agricultural Water-Resource Analysis (농촌유역 물순환 해석을 위한 웹기반 자료 전처리 및 모형 연계 기법 개발)

  • Park, Jihoon;Kang, Moon Seong;Song, Jung-Hun;Jun, Sang Min;Kim, Kyeung;Ryu, Jeong Hoon
    • Journal of The Korean Society of Agricultural Engineers
    • /
    • v.57 no.5
    • /
    • pp.101-111
    • /
    • 2015
  • Establishment of appropriate data in certain formats is essential for agricultural water cycle analysis, which involves complex interactions and uncertainties such as climate change, social & economic change, and watershed environmental change. The main objective of this study was to develop web-based Data processing and Model linkage Techniques for Agricultural Water-Resource analysis (AWR-DMT). The developed techniques consisted of database development, data processing technique, and model linkage technique. The watershed of this study was the upper Cheongmi stream and Geunsam-Ri. The database was constructed using MS SQL with data code, watershed characteristics, reservoir information, weather station information, meteorological data, processed data, hydrological data, and paddy field information. The AWR-DMT was developed using Python. Processing technique generated probable rainfall data using non-stationary frequency analysis and evapotranspiration data. Model linkage technique built input data for agricultural watershed models, such as the TANK and Agricultural Watershed Supply (AWS). This study might be considered to contribute to the development of intelligent watercycle analysis by developing data processing and model linkage techniques for agricultural water-resource analysis.

Data Mining and Construction of Database Concerning Effects of Vitis Genus (산머루 관련 정보수집 및 데이터베이스의 구축)

  • Kim, Min-A;Jo, Yun-Ju;Shin, Jee-Young;Shin, Min-Kyu;Bae, Hyun-Su;Hong, Moo-Chang;Kim, Yang-Seok
    • Journal of Physiology & Pathology in Korean Medicine
    • /
    • v.26 no.4
    • /
    • pp.551-556
    • /
    • 2012
  • The database for the oriental medicine had been existed in documentation in past times and it has been developed to the database type for random accesses in the information society. However, the aspects of the database are not so diversified and the database for the bio herbal material exists in widened type dictionary style. It is a situation that the database which handles the in-depth raw herbal medicines is not sufficient in its quantity and quality. Korean wild grape is a deciduous plant categorized into the Vitaceae and it was found experimentally that it has various medical effects. It is one of the medical materials with higher potentiality of academic study and commercialization recently because it has a bigger possibility to be applied into diverse industrial fields including the medical product for health, food and beauty. We constituted the cooperative system among the Muju cluster business group for Korean mountain wild grapes, Physiology Laboratory in Kyung Hee University Oriental Medicine and Medical Classics Laboratory in Kyung Hee University Oriental Medicine with a view to focusing on such potentiality and a database for Korean wild grapes was made a touchstone for establishing the in-depth database for the single bio medical materials. First of all, the literatures based on the North East Asia in ancient times had been categorized into the classical literature (Korean literature published by government organization, Korean classical literature, Chinese classical literature and classical literature fro Korean and Chinese oriental medicine) and modern literature (Modern literature for oriental medicine, modern literature for domestic and foreign herbal medicine) to cover the eastern and western research records and writings related to Korean wild grapes and the text-mining work has been performed through the cooperation system with the Medical Classics Laboratory in Kyung Hee University Oriental Medicine. First of all, the data for the experiment and theory for Korean wild grape were collected for the Medline database controlled by the Parliament Library of USA to arrange the domestic and foreign theses with topic for Korean wild grapes and the network hyperlink function and down load function were mounted for self-thesis searching function and active view based on the collected data. The thesis searching function provides various auxiliary functions and the searching is available according to the diverse searching/queries such as the name of sub species of Korean wild grape, the logical intersection index for the active ingredients, efficacy and elements. It was constituted for the researchers who design the Korean wild grape study to design of easier experiment. In addition, the data related to the patents for Korean wild grape which were collected from European Patent Office in response to the commercialization possibility and the system available for searching and view was established in the same viewpoint. Perl was used for the query programming and MS-SQL for database establishment and management in the designing of this database. Currently, the data is available for free use and the address is as follows. http://163.180.41.43:8011/index.html

Development of Integrated Biomedical Signal Management System Based on XML Web Technology

  • Lee Joo-sung;Yoon Young-ro
    • Journal of Biomedical Engineering Research
    • /
    • v.26 no.6
    • /
    • pp.399-406
    • /
    • 2005
  • In these days, HIS(Hospital Information System) raise the quality of medical services by effective management of medical records. As computing environment was developed, it is possible to search information quickly. But, standard medical data exchange is not completed between medical clinic and another organ so far. In case of patient transfer, past medical record was not efficiently transmitted. It be feasible treatment delay or medical accident. It is trouble that medical records is transferred by a person and communicate with each other. Extensible Markup Language (XML) is a simple, very flexible text format derived from SGML. Originally designed to meet the challenges of large-scale electronic publishing, XML is also playing an increasingly important role in the exchange of a wide variety of data on the Web and elsewhere. Form in system of company product, relative organs that handle bio-signal data is each other dissimilar and integration and to transmit to supplement bottleneck this research uses XML. In this study, it is discussed about sharing of medical data using XML web technology to standard medical record between hospital and relative organization The data structure model was designed to manage bio-signal data and patient record. We experimented about data transmission and all-in-one between different systems (one make use of MS-SQL database system and the other manage existent bio-signal data in itself form in file in this research). In order to search and refer medical record, the web-based system was implemented. The system that can be shared medical data was tested to estimate the merits of XML. Implemented XML schema confirms data transmission between different data system and integration result.

A Dynamic Management Method for FOAF Using RSS and OLAP cube (RSS와 OLAP 큐브를 이용한 FOAF의 동적 관리 기법)

  • Sohn, Jong-Soo;Chung, In-Jeong
    • Journal of Intelligence and Information Systems
    • /
    • v.17 no.2
    • /
    • pp.39-60
    • /
    • 2011
  • Since the introduction of web 2.0 technology, social network service has been recognized as the foundation of an important future information technology. The advent of web 2.0 has led to the change of content creators. In the existing web, content creators are service providers, whereas they have changed into service users in the recent web. Users share experiences with other users improving contents quality, thereby it has increased the importance of social network. As a result, diverse forms of social network service have been emerged from relations and experiences of users. Social network is a network to construct and express social relations among people who share interests and activities. Today's social network service has not merely confined itself to showing user interactions, but it has also developed into a level in which content generation and evaluation are interacting with each other. As the volume of contents generated from social network service and the number of connections between users have drastically increased, the social network extraction method becomes more complicated. Consequently the following problems for the social network extraction arise. First problem lies in insufficiency of representational power of object in the social network. Second problem is incapability of expressional power in the diverse connections among users. Third problem is the difficulty of creating dynamic change in the social network due to change in user interests. And lastly, lack of method capable of integrating and processing data efficiently in the heterogeneous distributed computing environment. The first and last problems can be solved by using FOAF, a tool for describing ontology-based user profiles for construction of social network. However, solving second and third problems require a novel technology to reflect dynamic change of user interests and relations. In this paper, we propose a novel method to overcome the above problems of existing social network extraction method by applying FOAF (a tool for describing user profiles) and RSS (a literary web work publishing mechanism) to OLAP system in order to dynamically innovate and manage FOAF. We employed data interoperability which is an important characteristic of FOAF in this paper. Next we used RSS to reflect such changes as time flow and user interests. RSS, a tool for literary web work, provides standard vocabulary for distribution at web sites and contents in the form of RDF/XML. In this paper, we collect personal information and relations of users by utilizing FOAF. We also collect user contents by utilizing RSS. Finally, collected data is inserted into the database by star schema. The system we proposed in this paper generates OLAP cube using data in the database. 'Dynamic FOAF Management Algorithm' processes generated OLAP cube. Dynamic FOAF Management Algorithm consists of two functions: one is find_id_interest() and the other is find_relation (). Find_id_interest() is used to extract user interests during the input period, and find-relation() extracts users matching user interests. Finally, the proposed system reconstructs FOAF by reflecting extracted relationships and interests of users. For the justification of the suggested idea, we showed the implemented result together with its analysis. We used C# language and MS-SQL database, and input FOAF and RSS as data collected from livejournal.com. The implemented result shows that foaf : interest of users has reached an average of 19 percent increase for four weeks. In proportion to the increased foaf : interest change, the number of foaf : knows of users has grown an average of 9 percent for four weeks. As we use FOAF and RSS as basic data which have a wide support in web 2.0 and social network service, we have a definite advantage in utilizing user data distributed in the diverse web sites and services regardless of language and types of computer. By using suggested method in this paper, we can provide better services coping with the rapid change of user interests with the automatic application of FOAF.