• Title/Summary/Keyword: MS-SQL 데이터베이스

Search Result 36, Processing Time 0.027 seconds

Quick Decision Making Using Visual Dynamic Mining Tool;Spotfire (비쥬얼 다이나믹 마이닝 툴을 이용한 신속한 의사결정;Spotfire)

  • Kim, Seong-Ki
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 2008.04a
    • /
    • pp.89-91
    • /
    • 2008
  • 엄청나게 쏟아져 나오는 데이터 홍수 속에서 오늘날의 업체와 연구기관에서는 신속하게 의사 결정을 해야 한다. 당면한 문제점들을 해결하기 위하여 접근할 수 있는 수많은 다양한 데이터 속에서 정확하게 경향을 파악하고 그 근본 원인을 찾아내어 신속하고 action을 행하는 것은 어떠한 회사에서도 성공에 있어서 가장 중요한 인자들 중의 하나이다. 초기 아이디어 도출, 연구 개발에서부터 제품의 생산, 판매 및 서비스에 이르기까지 모든 팀원들은 아주 빠르게 고도의 정확성으로 중요한 결정을 할 필요가 있다. 오늘날의 경쟁 시장에서 기업의 성공은 다른 경쟁자들보다 더 빠르게 결정을 할 수 있는 능력에 달려 있다. 이에 Sporfire에서는 사용자가 쉽고 빠르게 데이터를 분석하여 의사 결정을 할 수 있도록 다양한 기능을 제공하고 있다. 사용자가 SQL같은 전문 언어를 사용하지 않고도 다양한 데이터 source에서 쉽게 데이터를 가져오도록 Information Library를 이용할 수 있으며, 데이터베이스에 들어 있는 숫자들의 집합체를 다양한 차트와 도표들을 이용, 그래픽 적으로 제공해 줌으로써 데이터에 대하여 직관적으로 파악하여 신속하게 대응할 수 있도록 도와준다. 또한 그 결과물들을 MS 파워포인트, 엑셀시트, xml 등으로 저장하여 다른 용도로 사용할 수 있도록 하고 있다.

  • PDF

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.

The Development of a Mobile-based E-Bookstore system (모바일 E-Book Store System의 설계 및 구현)

  • Min, Gi-Hong;Jeon, Seung-Min;Kim, Song-Rae;Park, Dong-Won
    • The Journal of Engineering Research
    • /
    • v.6 no.1
    • /
    • pp.29-39
    • /
    • 2004
  • In the recent IT field, the biggest concerns may be Mobile environment. This means that it becomes part of our life: the Mobile is applied to the areas of teaching, studying, commercial transaction, entertainment etc. In this paper, we implemented Mobile E-BOOK bookstore using WEB, DB, and a Mobile technology. This system takes duplex from to be available in Mobile WEB environment by PDA and actuality WEB site under desk top environment. This paper have presented big possibility in terms of embodied electronic commerce based on the Mobile-based E-BOOKstore system that has not attempted yet commercially.

  • PDF

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

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

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.