• Journal of the Korea Society of Computer and Information
• /
• v.14 no.1
• /
• pp.217-228
• /
• 2009

Data analysis applications typically aggregate data across many dimensions looking for unusual patterns in data. Even though such applications are usually possible with standard structured query language (SQL) queries, the queries may become very complex. A complex query may result in many scans of the base table, leading to poor performance. Because online analytical processing (OLAP) queries are usually complex, it is desired to define a new operator for aggregation, called the data cube or simply cube. Data cube supports OLAP tasks like aggregation and sub-totals. Many aggregate functions can be used to construct a data cube. Those functions can be classified into three categories, the distributive, the algebraic, and the holistic. It has been thought that the distributive functions such as SUM, COUNT, MAX, and MIN can be used to construct a data cube, and also the algebraic function such as AVG can be used if the function is replaced to an intermediate function. It is believed that even though AVG is not distributive, but the intermediate function (SUM, COUNT) is distributive, and AVG can certainly be computed from (SUM, COUNT). In this paper, however, it is found that the intermediate function (SUM COUNT) cannot be applied to OLAP cubes, and consequently the function leads to erroneous conclusions and decisions. The objective of this study is to identify some problems in applying aggregate function AVG to OLAP cubes, and to design a process for solving these problems.

• KSCE Journal of Civil and Environmental Engineering Research
• /
• v.28 no.3D
• /
• pp.355-362
• /
• 2008

Fast track completion of urgent typhoon damage recovery construction project is becoming crucial for the prevention of the secondary damage from the next year typhoon, prompt psychological stabilization of flood sufferers, the early recovery of damaged infrastructure condition and so forth. As the recovery learning process has been continued for last consecutive typhoons and experts suggested, the keys in attaining the goals of the project (preventative, sustainable, cleaner and fast tracking development) are found to be the early contracting and improved competencies in project management especially during the design phase. It can be presumed that the former is attainable through administrative supports in the form of government guidelines, but the latter necessitates more research efforts. In this regards, this study aims to find a way how to lift up the current level of project management capability facing ever changing project mangement environment of urgent typhoon recovery project. By comparing the current level of application of government guidelines in flooded districts and analyzing the time required for each phase from design contracting to construction starting, several reformative ideas are illustrated in association with the necessity of adopting CM method in the deign phase. It is highly expected that CM application in the design phase can be an effective alternative in overcoming current limits in improving the quality of the project and prevent the delay due to the lack of expertise and professional workers in the owner side.

• Journal of the Korean Society for information Management
• /
• v.41 no.3
• /
• pp.461-485
• /
• 2024

This study empirically analyzes the impact of role stress, user misconduct, and job satisfaction on turnover intention by categorizing turnover intention into workplace turnover intention and occupational turnover intention among academic librarians working at national, public, and private universities across South Korea. Data were collected through a survey conducted from September 13 to September 20, 2023, yielding 447 responses, which were subsequently analyzed using hierarchical regression analysis. The results revealed that role ambiguity and severe user misconduct (physical threats) positively influenced both workplace turnover intention and occupational turnover intention, while age negatively influenced both. The study found that librarians who experience unclear responsibilities and physical threats are more likely to have a strong intention to leave both their workplace and occupation. As differential factors, role overload and the location of the workplace in the metropolitan area were found to be significant. Role overload positively influenced only occupational turnover intention, while the metropolitan location negatively influenced only workplace turnover intention. These findings suggest that excessive workload increases doubt about the occupation itself, leading to consideration of occupational turnover and that librarians working outside the metropolitan area exhibit higher workplace turnover intention. Both intrinsic and extrinsic job satisfaction negatively influenced workplace and occupational turnover intention. These results indicate that differentiated strategies tailored to specific types of turnover intention are warranted to effectively manage turnover intention among academic librarians.

• Journal of Korean Society of Forest Science
• /
• v.100 no.4
• /
• pp.672-680
• /
• 2011

The purpose of this study has been carried to develop a criterion for the selection of evaluation factors on Forest Carbon Cycle Community(F.C.C.C) based on the result of survey of 96 participants who were operation managers on mountain eco village(31), relevant experts(33), and officers of local government(32). For analysis of the results of survey, DHP(Delphi Hierarchy Process) method was used which is a combination of Delphi method and AHP(Analytic Hierarchy Process) method. The key factors on selection of a suitable area to launch F.C.C.C. project of Korea Forest Service was selected under three hierarchical classes. Class 1 comprises 3 indices(Physical resource index, Human resource index, Vision index), and Class 2 which contains 10 indices (Existing resource, Surroundings resource, Forest biomass resource, Humanities Social quality, Local resident participation, Leader's ability, External support, Planning of operation, Capability of operation, and Effect of operation). Class 3 is sub-level class of class which possess 38 indices. From the results of analysis, Consistency Index(C.I) of each index in the 3 classes was used as evaluation factor. In Class 1, index 'human resources' showed highest Consistency Index(0.454). In Class 2, index 'forest biomass resources' was the highest Consistency Index(0.376) in 'physical resources' of Class 1, index 'leader's ability' was the highest Consistency Index(0.326) in 'human resources' of Class 1, and index 'planning of operation' was the highest Consistency Index(0.346) in 'vision' of Class 1. In Class 3, relative importance of 38 index including 'Joint ownership land security(C.I.-0.266)' was evaluated. Based on the result of this study, a criterion for the selection of evaluation factors for F.C.C.C was developed and the evaluation criterion is expected to be use to select of a suitable area to launch F.C.C.C. project since 2011.

• Journal of the Korean Institute of Landscape Architecture
• /
• v.47 no.6
• /
• pp.53-66
• /
• 2019

The purpose of this study was to suggest indicator-based selection and improvement plans for evaluating urban regeneration projects. First, we selected the indicators by conducting expert surveys and analysis of the responses received. Additionally, using the selected indicators, we analyzed the residents' opinions in Wongogae Village, where urban regeneration projects were in progress. Based on these, we suggested a plan to improve Wongogae Village. According to the study, we classified the urban regeneration evaluation indicators into 'Physical environment', 'Social environment' and 'Economic environment' according to their characteristics. We selected urban regeneration evaluation factors through the first expert survey and MCB analysis. As a result, we selected six factors for the 'Physical environment' category: 'Traffic and pedestrian environment', 'Residential (housing) environment', 'Safety and security environment', 'Greenspace', 'Landscape improvement' and 'Public space', In the 'Social environment' category, four factors were chosen: 'Resident participation', 'Community activation', 'Role of the local government and support centers' and 'Resident education' while for the 'Economic environment' category three factors were selected: 'Local economic revitalization', 'Creating an economy-based environment', 'Job creation'. Next, we conducted a second expert survey and carried out an AHP analysis using the selected evaluation factors to derive the overall weight for each. Among the evaluation factors for urban regeneration, the 'Residential (housing) environment' has the highest weighted value of 0.108, followed by 'Local economic revitalization' and 'Resident participation'. Lastly, the analysis of the residents' opinions of Wongogae Village using the urban regeneration evaluation factors, Parking environment', 'Maintenance of old houses and living environment', 'Environment for founding town and social enterprises', 'Improve commercial and business environment', 'Maintain and activate existing business' and 'Vitalizing small regional economies such as domestic handicrafts and side-job' had high overall importance, but low satisfaction, which means that it is necessary to improve the focus. Therefore, in order to improve the urban regeneration project in villages, it is necessary to improve the parking environment by expanding public parking lots, eliminate close houses, and idle lands, or open a school playground in the village for the residents. In addition, it is essential to encourage economic activities, such as fostering village enterprises and social enterprises in connection with cooperatives and allow for the selling of the products through resident activities, such as neighboring markets.

• Archives of design research
• /
• v.17 no.2
• /
• pp.425-436
• /
• 2004

A new design field called eDesign appears as if eBiz is an online related business in which an industrialized design creates the individual value added facing a digital revolution. The field of eDesign requires a special design process and management methodology regardless of the fact that human sensitivity will be satisfied through a dehumanized computer technique. However, it is the reality of eDesign that has been dependent upon a simple process or project management tool of general design. In this study, we develop an eDesign platform based on an eDesign process and template mainly focused on eBusiness in order to overcome the wrong situation. The template is a kind of document that has a standardization form. We aim to establish a general process through various case projects, store information using a necessary template, and use for the way of visual communication. We propose a standard of eDesign platform that can be widely applied to the field of design, medium and small enterprises focused on IT businesses or design-team through this project performed as an educational-industrial study. It makes it possible to get a detailed process methodology, which can be applied to many small design related companies that don't have their own process yet, and will be a scale for comparing their own process in which the company has a process of opened standard eDesign with it. In addition, it makes possible a systematic control of the own projects within and outside the firm, accumulating information for the firm through the database, and easy communication. Furthermore, it can be applied to check the process of the project as a checklist, and then it will reduce trial and error repeated for every project that has been done.

• KSCE Journal of Civil and Environmental Engineering Research
• /
• v.29 no.4B
• /
• pp.385-396
• /
• 2009

Non-household unit water use for each type of business are estimated in this study. The business types are subdivided into forty based on nine categories by the national industrial standard classification, such as office, commerce, public bathing, public water use etc. Correlation analysis and analysis of variance (ANOVA) are applied to obtain statistical characteristics between industrial water use data, surveyed in six cities including Nonsan, Seosan and the National Statistical Bureau and site area, employees number etc. for each detailed business area. As the proposed non-household unit water uses are compared with five surveyed data in USA, it is shown that almost of water uses per unit area are less than those in USA. Non-household unit water uses of 25% cumulative probability water use recommended as efficiency benchmarks among surveyed data in Korea are also less than those in USA. Especially, in the case of water use in school, the average and the range are similar results showing water use range between 0.4 and 6.2 ($l/m^2/day$) as liter per capita day per an unit area, also water use range between 11.9 to 64.0 (l/student/day) as liter per capita day per a person. From the result of correlation analysis with internal and exogenous affecting factors on non-household water use, it can be concluded that a unit area is most appropriate factor as a standard of non-household unit water use. In case of water use in educational business, the number of students including staffs is more correlated than site ares with water use for the settled water consumption tendency. Although the increase and decrease of educational institutes, retail/wholesale store and restaurants are shown remarkable by the temperature as a representative factor, low correlations are shown in water use fluctuation in lodging house and hospital.

• Journal of Korean Home Economics Education Association
• /
• v.22 no.4
• /
• pp.91-107
• /
• 2010

The purpose of this study was to investigate what middle school Home Economics(HE) teachers perceive, practice and need for self-supervision at school related to HE. Questionnaires were sent by E-mail and 150 were collected. Descriptive statistics including frequency, percentage, average, standard deviation, t-test and ANOVA analysis were reported using SPSS/win 10.1. The results of this research were as follows: First, middle school HE teachers perceived that self-supervision at school was essential since it promoted self reflection of teachers themselves and improved professional skills. Furthermore, peer-coaching was highly preferred. Second, negative responses to the supervision of principal, vice-principal, and peer teachers overwhelmed positive answers. Information exchange among peer teachers was frequent, yet, approximately 22.6% of middle school HE teachers were still avoiding sharing information process for several reasons. About half of the teachers answered that all teachers needed to participate in this process. Third, they pointed out that self-supervision at school was not implemented well because of the lack of time due to the heavy work load, negative and passive attitude for the improvement of teaching-learning activities, administration-centered supervision that did not reflect teachers' opinion, and shortage of economical, and environmental support.. HE teachers perceived that peer teachers who were doing good practices were most helpful for the supervision. Also, they preferred self-evaluation at the end of the self-supervision at school. Forth, to improve self-supervision at school, there were very high demands for reduction of administrative work, additional time, fundamental philosophy toward HE education. Fifth, the purpose and detailed plans of self-supervision were recognized as the results that were democratically derived by the HE teachers. Sixth, class inspection and informal inspection were operated once in a year, and self-training was rarely operated. Peer coaching and self-coaching were operated occasionally. Self-coaching and peer coaching were reported as the most helpful types of supervision. In addition, HE teachers answered that supervision was helpful to teaching method followed by contents, evaluation, and philosophy of education.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.8 no.4
• /
• pp.853-860
• /
• 2007

In this modern era, human beings lead their life in complex environment where there are lots of parameters such as temperature, light, smell, sound, visual stimulus etc. that play important role for quality life. These parameters affect physical and mental behavior of a human being immensely. To ensure quality life the demand for quality products is always associated with human emotion and sensibility. Due to human sensibility and emotion involvement with quality life, the design stages of any kind of product must include some certain features related with emotion and sensibility. The cues for optimizing artificial environment are the physiological responses of human in that environment. The conventional approach of environmental physiology is to measure the relationship between environmental physical parameters and human psychological parameters under artificial conditions. Using that approach we tried to design an artificial environment for our daily lives and activities associated with both physiological and psychological behavior. We developed the technique to present the mock environment and software to measure and evaluate sensibility physiologically or psychologically and a simulator to measure and evaluate sensibility that can be utilized for large scale industrial production and design of environment. Simulator to measure and analyze human sensibility (SMAS) was constructed, which was utilized to estimate human sensibility and to simulate living and office environment.

• The Korean Journal of Archival Studies
• /
• no.37
• /
• pp.189-237
• /
• 2013

Since central governments began to establish and use the Standard Records Management System(RMS) in 2007, more and more local governments and other public organizations have constructed RMS. RMS is the essential tool for records management in electronic environments, but it is not known how well the functions of RMS reflect standards and practice related records management or how many records managers use RMS in performing their works. This paper deals with analyzing the evaluation of 'classification & disposal schedule management' function in RMS. 'Classification & disposal schedule management' function has 4 subfunctions of review of classification & preservation period, management of the schedule items, assignment of classification scheme and reclassification. Classification and disposal schedule is at the heart of intellectual control of records and core area of records management. So it is important to analyze whether this function plays well a role in RMS or not. This research carried out evaluation of function and use about classification & disposal schedule management in RMS. Functional evaluation is to compare and analyze how well RMS meets the functional requirements which home and foreign standards give. Use evaluation is to investigate how records managers use RMS in accomplishing their task of managing classification & disposal schedule and to look into what is the problem with the use. This paper could get the implications through the survey of records managers who are working at central governments, regional local governments and basic local governments. And these implications are considered in institutional, functional, use and administrative aspect. It is important to communicate with stakeholders so that 'classification & disposal schedule management' function, further, all functions of the RMS in practice of records management could be used smoothly. Users of RMS have to raise demands or call for technical solutions of the problems which come up in use, while RMS developers and administrators must make more of an effort to satisfy their demands, reflect them on the RMS and enhance the system.