Previous research on data extraction and integration for data warehousing has concentrated mainly on the relational DBMS or partly on the object-oriented DBMS. Mostly, it describes issues related with the change data (deltas) capture and the incremental update by using the triggering technique of active database systems. But, little attention has been paid to data extraction approaches from other types of source systems like hierarchical DBMS, etc. and from source systems without triggering capability. This paper argues, from the practical point of view, that we need to consider not only the types of information sources and capabilities of ETT tools but also other factors of source systems such as operational characteristics (i.e., whether they support DBMS log, user log or no log, timestamp), and DBMS characteristics (i.e., whether they have the triggering capability or not, etc), in order to find out appropriate data extraction techniques that could be applied to different source systems. Having applied several different data extraction techniques (e.g., DBMS log, user log, triggering, timestamp-based extraction, file comparison) to S bank's source systems (e.g., IMS, DB2, ORACLE, and SAM file), we discovered that data extraction techniques available in a commercial ETT tool do not completely support data extraction from the DBMS log of IMS system. For such IMS systems, a new date extraction technique is proposed which first creates Index database and then updates the data warehouse using the Index database. We illustrates this technique using an example application.

A workflow management system is a software system to support accurate execution, control and management of business processes. It has been known that the system automatically executes complex processes and effectively manages them to improve the productivities. However though existing systems assure the automatic execution of an individual process, there is a room for enhancement from the view of efficient execution of all the processes. In this paper, we propose a method of executing business processes efficiently by introducing the PERT/CPM techniques in the workflow management systems. We first consider the differences between workflow process models and PERT/CPM models, and then develop a method of calculating the critical path and slack time in workflow processes. This leads us to develop a dispatching rule that can guide task performers to prioritize their tasks to increase the efficiency of ail the processes. We have carried out a set of simulation experiments and analyzed the results to demonstrate the effectiveness of the proposed method.

In this paper we applied dynamic programming to determining work schedule type. In dynamic programming formulation, each day during a planning horizon represents a stage for which a decision is made. The alternatives are given by work schedule types that combine regular time, overtime, additional shift, and so on. In this case, their associated return function is labor cost. The state is defined as the amount of work time allocated to stage 1, stage 2,…, and current stage. A case study for a real manufacturing company was performed to apply dynamic programming to scheduling daily work hours during a week. The case study showed that total cost of our solution derived from dynamic programming decreased by about 6％ as compared with the solution obtained from the previous method.

This study considers the local players in the European steel industry, whose the amounts of crude production are more or less 5 million tons per annum. They do not belong to the Pan-EU mega-group of steel mills with more than 15 million tons of crude production yearly. However, these mid-sized steel mills in European countries have been originated from the strong foundation of steel, scientifically and technically, as well as the centennial history. They concentrate on the niche market adjacent to the local area, which takes advantage of the geographical location. The companies considered here are VoestAlpine in Austria, Salzgitter in Germany, Rautaruukki in finland, and SSAB in Sweden. Their corporate strategies are compared on the basis of product mix and sales structure. And, the deep analysis for each company is performed, such as business strategies with the sales volumes, market strategies. competitiveness improvement planning. and R&D policies with the technology management. These analysis results can be benchmarked as the cases of best practices for domestic steel mills, especially mid & small sized companies, that develop business and market strategies for the sustainable growth and profitability.

At the end of 2002, about 91% of mobile telecommunications service subscribers have mobile phones with the mobile internet access function. However, despite the rapid spread of mobile internet phones, the number of real mobile internet users is very small. In this situation, this paper focuses on the effect of consumer demographics such as sex, age, job, etc. and consumer life-style on the use of mobile internet. This study tries to find the answers about the following questions ; 1) Which consumer demographic variables affect the use of mobile internet\ulcorner 2) How can we categorize the consumers with the mobile internet phones\ulcorner 3) What are the characteristics of categorized groups and is there any difference in using the mobile internet\ulcorner For this purpose, an off-line survey was conducted over 1,500 consumers with the mobile internet phones. This study concludes as follows ; The important demographic factors of the use of mobile internet are age, job, marriage, academic career and personal spending money. Totally viewed in the consumer demographics, the typical type of mobile internet users can be described as the young student. On the other hand, sex and family income variables do not significantly affect the use of mobile internet. And the mobile internet users can be categorized by the life-style into four distinct groups, which are named as the innovation oriented group, the practicality oriented group, the conservation oriented group, the ostentation oriented group. These findings show that the consumer life-style have various effects on the use of mobile internet.

These days we come across many wicked problems whose solutions are beyond individuals intellectual ability. These problems can be resolved through collaborative group interaction. We developed an internet-based asynchronous group interaction support system, after looking into the collaborative problem solving process and the IBIS (Issue-Based Information System) argumentation model. It has the following characteristics ; 1) it is developed based on the modified IBIS model which is a model for group interaction to resolve wicked problems ; 2) it supports both processes of seeking and comparing solutions, while most similar systems do not have a feature to support the latter process ; 3) different structures can be defined dynamically according to the purpose of group interaction, so that it could be used for collaborative problem solving in a specific domain. To show the usability of the system, we carried out an experiment, whose result is shown at the end.

The standard issue in the information and telecommunication industry is increasingly important with the rapid development of technology. This paper proposes an index model which can measure the degree of standardization in the Korean information and telecommunication field. We first classified ICT sector into 14 sub-sectors. Then for each sub-sector, we considered a set of important determinants to measure the level of standardization, and constructed a linear equation using this set of determinants. Finally we estimated the relative degree of importance of each determinant using the AHP methodology. The proposed model found that overall level of standardization in the Korean ICT industry is relatively low, and ‘IMT-2000 technology’ and ‘computer network technology’ among 14 sub-sectors are highly standardized sub-sectors. The validity of the proposed model was also partially proved using two different methods, holistic and historical approach.

This study developed the ISM (Electronic Store Success Model) by basing upon the revised D&M IS Success Model and reflecting the characteristics of marketing and e business. The theoretical rationale of this model was as following : 1) Though the revised D&M IS Success Model (2002) must be more logical and complete model than the original D&M IS Success Model (1992), it did not reflect characteristics of marketing and e business. 2) In the marketing studios, Service Quality has been suggested as one of basic strategies for success. 3) In e business studies, Trust has been emerging as a potentially important antecedent of e loyalty. 4) There has been a paradigm shift from satisfaction to loyalty in marketing emphasis. 5) Nowadays, ERP (Enterprise Resource Planning) has been pervaded in many organizations and has supported PCA (Profit Center Accounting) or Channel based Accounting, so it has not been difficult to evaluate financial performance of Electronic Store. The ESM that has six dimensions (System Quality, information Quality. Service Quality, Trust, Loyalty, Financial Performance) and expresses the causal relationship among them was proposed and was compared with BSC (Balanced Scorecard), WebQual, and EWAM (Extended Web Assessment Method). The results showed that the ESM coincides with BSC and contains dimensions of WebQual, and EWAM.

Developing a proper program for customer evaluation is one of the most imminent tasks to implement CRM (Customer Relationship Management). Design of the Customer Value model is an important key to the customer evaluation progrgm. This paper proposes two models for estimating Customer Value. The first one is a Description Model for Customer Value based on customer CSI (Customer Satisfaction Index) data. This model represents as quantitative numbers what customers feel from the company or the service. The second one is a Prediction Model which employs factor analysis and regression to predict customer value. This paper exploits the two models to evaluate Customer Value as well as for customer behavior prediction.

Although there has been growing interests in outsourcing the logistics sectors in the industry, not much research was undertaken to provide the processes and standards in choosing the right 3PL for the company. In this research, we attempt to provide the 3PL selection criteria and its priority orders. We surveyed and interviewed the various industry experts and analyzed results using Analytic Hierarchy Process(AHP). The study reveals that manufactures and logistics companies have different understanding of the selection criteria and priorities in outsourcing the 3PL.

This paper presents the prototype of corporate credit rating system using analytic hierarchy process (AHP). Prior studios have proposed various models of credit rating system, but most studies considered only financial information. Financial information, however, is only a small part of corporate information. In this study, the proposed credit rating system integrates both financial and non-financial information. Fifteen corporations are tested for the usefulness of the proposed system.

Function point model is the international standard method to measure the software size which is one of the most important factors to determine the software development cost. Function point model can successfully be applied only when the detailed specification of users' requirements is available. In the domestic public sector, however, the budgeting for software projects is carried out before the requirements of softwares ere specified in detail. Therefore, an efficient function point estimation method is required to apply function point model at the early stage of software development projects. The purpose of this paper is to compare various function point estimation methods and analyse their accuracies in domestic software projects. We consider four methods : NESMA model, ISBSG model, the simplified function point model and the backfiring method. The methods are applied to about one hundred of domestic projects, and their estimation errors are compared. The results can used as a criterion to select an adequate estimation model for function point counts.

Comparison challenge approach is proposed as a form of challenger-activated. just-in-time Internet advertising. To develop a framework for a comparison challenge, we propose a theory of comparison value. A comparison is regarded valuable if a comparison opportunity is available and if the comparison is relevant and informative, has an appropriate level of detail, and is advantageous and trustworthy. Based on this theory, the CompareMe and CompareThem strategies are devised, and comparable objects are classified in terms of price and performance dominance as well as the scope of proximity. The idea is demonstrated with a comparison of PCs from five leading manufacturers. To assist in the planning of the comparison challenge, a mathematical programming model was formulated to maximize the value of comparison under the constraints of the comparison opportunity and budget. The model is applied to eight scenarios in terms of the range of comparing objects. The models under various scenarios are tested and contrasted with the real-world example of PCs. We found the ad effect of comparison challenge to be substantially better than banners (4.75 times) and similarity-based comparisons (2.77 times), providing customers with better performance and reduced prices.