• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.12 no.4
• /
• pp.1693-1713
• /
• 2018

An important technique used by database administrators (DBAs) is to improve performance in decision-support workloads associated with a Star schema is multi-level partitioning. Queries will then benefit from performance improvements via partition elimination, due to constraints on queries expressed on the dimension tables. As the task of multi-level partitioning can be overwhelming for a DBA we are proposing a wizard that facilitates the task by calculating a partitioning scheme for a particular workload. The system resides completely on a client and interacts with the costing estimation subsystem of the query optimizer via an API over the network, thereby eliminating any need to make changes to the optimizer. In addition, since only cost estimates are needed the wizard overhead is very low. By using a greedy algorithm for search space enumeration over the query predicates in the workload the wizard is efficient with worst-case polynomial complexity. The technology proposed can be applied to any clustering or partitioning scheme in any database management system that provides an interface to the query optimizer. Applied to the Teradata database the technology provides recommendations that outperform a human expert's solution as measured by the total execution time of the workload. We also demonstrate the scalability of our approach when the fact table (and workload) size increases.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.16 no.10
• /
• pp.7204-7210
• /
• 2015

This paper has developed the system for supporting the approximate construction cost and the quantity estimation based on 3D model information in the pre-project planning phase of 3-span continuous cable-bridge with 2-pylons. First of all, we'd analyzed the design information (structural design report, blueprint and quantity) of the existing cable-stayed bridges and derived the design variables of cable-stayed bridges. We developed the BIM wizard that generates a cable-stayed bridge model parametrically based on derived design variables. The principle material quantities of cable-stayed bridge are calculated directly from 3-dimensional bridge model built by using the BIM wizard. Then, we can estimate the construction cost in relation to its quantities and unit cost of cable-stayed bridge. In a result, we have established the system that the construction cost can be estimated more specific than the conventional method (construction estimates per meter or square meter). We hereby will be able to review various alternatives as soon as possible in bidding process.

• Journal of the Korean Society for Advanced Composite Structures
• /
• v.6 no.4
• /
• pp.24-29
• /
• 2015

Bridge construction cost estimates have generally been conducted by using historial unit-price(per meter or square meter). The traditional estimating method based on unit-price references can never completely reflect the specialty of cable supported bridge. In this paper, we have developed the system for supporting the approximate construction cost and the quantity estimation based on 3D model information in the pre-project planning phase of 3-span continuous suspension bridge with 2-pylons. First of all, we'd analyzed the design information (such as structural design report, blueprint and quantity) and the real cost data from the existing suspension bridges and derived the design variables of the bridges. We developed the BIM wizard that generates a suspension bridge model parametrically based on derived design variables. The principle material quantities of suspension bridge are calculated directly from 3-dimensional bridge model built by using the BIM wizard. We have established the system that the construction cost can be estimated more specific than the traditional estimating method.

• The KIPS Transactions:PartB
• /
• v.9B no.4
• /
• pp.437-444
• /
• 2002

There are some important that development of tools to retrieve information by simple operation in large of nave users in the world wide web. In general, query formulation method and operators are variety, not easy to formulate query in information retrieval system or web based retrieval engine. In this paper, we propose "Concept Wizard" to support query formulation with concept term expansion in natural language query information retrieval system. The Concept Wizard are interactively supporting query formulation using thesaurus and Providing plug-in on the web.

• The Journal of the Korea Contents Association
• /
• v.5 no.6
• /
• pp.109-119
• /
• 2005

The Internet is widely used by general people and the use of Internet is spread to all industrial fields. Especially, cyber education fields have been changed a lot with the Internet application development. One of them is the field of consultation for university admission. As for the business of university admission, there were two ways applicants handed in their applications directly to school which they applied to and to each place to receive applications or sent them through FAX. Recently, highlighted is the Internet environment to receive the application for admission which integrated organically the two ways. In this thesis, I designed and implemented on-line admission consulting system using of multi-agent. The examines can apply for safely and according to their conviction by recommending the university course suitable for their academic aptitude and scores with test KSAT(Scholastic Aptitude Test Administered by the Korean Ministry) and a university grade report on students' record using intelligent multi-agents and through a university course recommending wizard in the process of choosing it.

• Journal of Internet Computing and Services
• /
• v.2 no.5
• /
• pp.21-29
• /
• 2001

In this paper, we present the development of a system(WebPierrot) that helps end-users to generate home pages with the construction of their corresponding web databases without the web programming technique. It consists of a page editor. a database wizard and a database manager. The page editor creates and modifies multimedia home pages. The database wizard generates databases operated with home pages automatically, and the database manager maintains the database related to the home pages. The page editor has been made based on the DHTML(Dynamic Hypertext Markup Language) and lets users generate multimedia home pages interactively. The database manager creates, updates and manages web databases. The system has the advantage which end-users can create multimedia home pages containing databases without requiring web database programming.

• Journal of the Korean Society for Nondestructive Testing
• /
• v.28 no.4
• /
• pp.331-338
• /
• 2008

Ultrasonic testing for welds is widely used to ensure the integrity of facilities in NPPs. Automated ultrasonic testing(AUT) is more consistent than the manual ultrasonic testing(MUT). It can scan welded parts, examines the scanned images, and saves the results as data files. AUT in NPPs is making use of commercial systems, and there has been some difficulties in calibration of the system. An AUT system is developed. It comprises of pulser/receiver, scanner and a control program(SonicWizard). The performance demonstration for piping welds in NPPs and the piping wall thickness measurement on site were conducted to verify this system. The test results of the ultrasonic testing system developed is satisfactory and effective.

• The Journal of Information Systems
• /
• v.29 no.1
• /
• pp.201-224
• /
• 2020

Purpose The study focuses on the physical activity behavior change effect of smart wristband, which is the most popular type of fitness tracker nowadays. The purpose of the research is to investigate how people's workout behavior may change after wearing a smart band and examine what kind of role persuasive design plays in behavior change. Design/Methodology/Approach This research employed an experimental study to examine whether the user's workout behaviors changed after using wristband from the "Behavior Wizard" perspective. A representative smart wristband from a major vendor was selected as the objects of experimental study. In the experiment, by comparing users' workout behavior before and after using the wristband, behavior changes of all the experiment participants were classified into one of the 15 behavior change types. Users perceived persuasive design characteristics were measured and group differences were tested among different behavior change groups. Findings This research found that nearly half of the participants changed their workout behavior while half retained their workout status or no exercise status. Half of the participants who did not do exercise in their spare time started walking in the experiment. Results also showed that participants who started working out perceived higher levels of persuasive design devised into the smart band than participants who preserved no exercise status, except for facilitation and reward strategies. Participants who retained workout and those who increased workout frequency perceived no difference in smart band persuasive design.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.5 no.5
• /
• pp.960-969
• /
• 2001

In this paper we researched the homepage automation system and its implementation methods that made it possible for even the non-majors or the beginners to make a specific useful homepage with the simple manipulation of a mouse and the minimal input of necessary information. This system is the customer request-based homepage automation system that makes it possible with ease not only to manufacture homepage and install it on user specified server but also to maintain homepage without direct handling of homepage source.

• Journal of Food Hygiene and Safety
• /
• v.18 no.1
• /
• pp.6-13
• /
• 2003

Various kinds of genetically modified organisms (GMO) and processed foods have been developed during recent years. Genetically modified organisms can be classified into several groups as their development methods. Generally, GMO has three foreign DNA regions such as gene expression adjustment region(Promoter), termination region (terminator) and structure gene. Detection of these regions can be done particularly by polymerase chain reaction (PCR). PCR-based detection can virtually be performed for any GMO within short of time. The most important prerequisite for the application of PCR-based detection is to decide abstraction method of efficient nucleic acids. Specially, in the case of processed food, because nucleic acids of foodstuffs are damaged by heat treatment (sterilization), pressure and fermentation, DNA must be extracted ken the samples prior to PCR analysis. Although many DNA extraction protocols are available, they have rarely been compared in a comprehensive method. In this study low widely used commercial and non-commercial DNA extraction methods-DNeasy$^{TM}$, Wizard$^{TM}$, CTAB, phenol/chloroform system-were compared with respect to the quality and yield of nucleic acids and insertion genes.nes.