• The Journal of Korean Institute of Communications and Information Sciences
• /
• v.25 no.6A
• /
• pp.870-884
• /
• 2000

Among OLAP(On-Line Analytical Processing) approaches, ROLAP(Relational OLAP) based on the star, snowflake schema which offer the multidimensional analytical method has performance problem and MOLAP (Multidimensional OLAP) based on Multidimensional Database System has scalability problem. In this paper, to solve the limitaions of previous approaches, design and implementation of multidimensional data model based on Object-Relation DBMS was proposed. With the extensibility of Object-Relation DBMS, it is possible to advent multidimensional data model which more expressively define multidimensional concept and analysis functions that are optimized for the defined multidimensional data model. In addition, through the hierarchy between data objects supported by Object-Relation DBMS, the aggregated data model which is inherited from the super-table, multidimensional data model, was designed. One these data models and functions are defined, they behave just like a built-in function, w th the full performance characteristics of Object-Relation DBMS engine.

• Journal of The Korean Astronomical Society
• /
• v.55 no.4
• /
• pp.111-121
• /
• 2022

Based on the light an exoplanet blocks from its host star as it passes in front of it during a transit, the mid-transit time can be determined. Periodic variations in mid-transit times can indicate another planet's gravitational influence. We investigate 83 transits of TrES-1 b as observed from 6-inch telescopes in the MicroObservatory robotic telescope network. The EXOTIC data reduction pipeline is used to process these transits, fit transit models to light curves, and calculate transit midpoints. This paper details the methodology for analyzing transit timing variations (TTVs) and using transit measurements to maintain ephemerides. The application of Lomb-Scargle period analysis for studying the plausibility of TTVs is explained. The analysis of the resultant TTVs from 46 transits from MicroObservatory and 47 transits from archival data in the Exoplanet Transit Database indicated the possible existence of other planets affecting the orbit of TrES-1 and improved the precision of the ephemeris by one order of magnitude. We now estimate the ephemeris to be (2 455 489.66026 BJD_TDB ± 0.00044 d) + (3.0300689 ± 0.0000007) d × epoch. This analysis also demonstrates the role of small telescopes in making precise midtransit time measurements, which can be used to help maintain ephemerides and perform TTV analysis. The maintenance of ephemerides allows for an increased ability to optimize telescope time on large ground-based telescopes and space telescope missions.

• The Bulletin of The Korean Astronomical Society
• /
• v.46 no.2
• /
• pp.66.3-67
• /
• 2021

Low-mass stars form by the gravitational collapse of dense molecular cores. Observations and theories of low-mass protostars both suggest that accretion bursts happen in timescales of ~100 years with high accretion rates, so called episodic accretion. One mechanism that triggers accretion bursts is infalling fragments from the outer disk. Such fragmentation happens when the disk is massive enough, preferentially activated during the embedded phase of star formation (Class 0 and I). Most observations and models focus on the gas structure of the protostars undergoing episodic accretion. However, the dust and ice composition are poorly understood, but crucial to the chemical evolution through thermal and energetic processing via accretion burst. During the burst phase, the surrounding material is heated up, and the chemical compositions of gas and ice in the disk and envelope are altered by sublimation of icy molecules from grain surfaces. Such alterations leave imprints in the ice composition even when the temperature returns to the pre-burst level. Thus, chemical compositions of gas and ice retain the history of past bursts. Infrared spectral observations of the Spitzer and AKARI revealed a signature caused by substantial heating, toward many embedded protostars at the quiescent phase. We present the AKARI IRC 2.5-5.0 ㎛ spectra for embedded protostars to trace down the characteristics of accretion burst across the evolutionary stages. The ice compositions obtained from the absorption features therein are used as a clock to measure the timescale after the burst event, comparing the analyses of the gas component that traced the burst frequency using the different refreeze-out timescales. We discuss ice abundances, whose chemical change has been carved in the icy mantle, during the different timescales after the burst ends.

• The Bulletin of The Korean Astronomical Society
• /
• v.44 no.2
• /
• pp.55.3-55.3
• /
• 2019

We present a pipeline to estimate baryonic properties of a galaxy inside a dark matter (DM) halo in DM-only simulations using a machine trained on high-resolution hydrodynamic simulations. As an example, we use the IllustrisTNG hydrodynamic simulation of a (75 h^-1 Mpc)³ volume to train our machine to predict e.g., stellar mass and star formation rate in a galaxy-sized halo based purely on its DM content. An extremely randomized tree (ERT) algorithm is used together with multiple novel improvements we introduce here such as a refined error function in machine training and two-stage learning. Aided by these improvements, our model demonstrates a significantly increased accuracy in predicting baryonic properties compared to prior attempts --- in other words, the machine better mimics IllustrisTNG's galaxy-halo correlation. By applying our machine to the MultiDark-Planck DM-only simulation of a large (1 h^-1 Gpc)³ volume, we then validate the pipeline that rapidly generates a galaxy catalogue from a DM halo catalogue using the correlations the machine found in IllustrisTNG. We also compare our galaxy catalogue with the ones produced by popular semi-analytic models (SAMs). Our so-called machine-assisted semi-simulation model (MSSM) is shown to be largely compatible with SAMs, and may become a promising method to transplant the baryon physics of galaxy-scale hydrodynamic calculations onto a larger-volume DM-only run. We discuss the benefits that machine-based approaches like this entail, as well as suggestions to raise the scientific potential of such approaches.

• The Bulletin of The Korean Astronomical Society
• /
• v.45 no.1
• /
• pp.42.2-42.2
• /
• 2020

We report on multi-wavelength observations of AA Ori, a Young Stellar Object in Orion-A star-forming region. AA Ori is known to have a pre-transitional disk based on infrared observations including Spitzer/IRS data. We construct its broadband spectral energy distribution (SED) by not only taking data in the optical and IR region but also including Herschel/PACS, JCMT/SCUBA, and SMA observational data. We use the Monte Carlo radiative transfer code (RADMC-3D) to reconstruct the SED with a viscous accretion disk model initialized by a radially continuous disk and finally having an inner and outer dusty disk separated by a dust-depleted radial gap. By comparing the model SEDs with different configurations of disk parameters, we discuss the limits to find a single solution of model parameters to fit the data. We suggest that some models with a modified inner disk surface density gradient and some degree of dust depletion in the inner disk can explain the AA Ori's SED, from which we infer that the inner disk of AA Ori has evolved. We present that model configurations of a pre-transitional disk with a large gap extended to 60-80 AU in a settled dusty disk of a few hundred AU size with a high inclination angle (~60°) also create model SEDs close to the observed one. To distinguish whether the disk has a just-opened narrow gap or a large gap, with an altered surface density of the inner disk extended to 10 AU, we suggest a further investigation of AA Ori with high angular resolution observations.

• Journal of Intelligence and Information Systems
• /
• v.28 no.1
• /
• pp.69-88
• /
• 2022

One of the characteristics of South Korea's economic structure is that it is highly dependent on exports. Thus, many businesses are closely related to the global economy and diplomatic situation. In addition, small and medium-sized enterprises(SMEs) specialized in exporting are struggling due to the spread of COVID-19. Therefore, this study aimed to develop a model to forecast exports for next year to support SMEs' export strategy and decision making. Also, this study proposed a strategy to recommend promising export countries of each item based on the forecasting model. We analyzed important variables used in previous studies such as country-specific, item-specific, and macro-economic variables and collected those variables to train our prediction model. Next, through the exploratory data analysis(EDA) it was found that exports, which is a target variable, have a highly skewed distribution. To deal with this issue and improve predictive performance, we suggest a separated learning method. In a separated learning method, the whole dataset is divided into homogeneous subgroups and a prediction algorithm is applied to each group. Thus, characteristics of each group can be more precisely trained using different input variables and algorithms. In this study, we divided the dataset into five subgroups based on the exports to decrease skewness of the target variable. After the separation, we found that each group has different characteristics in countries and goods. For example, In Group 1, most of the exporting countries are developing countries and the majority of exporting goods are low value products such as glass and prints. On the other hand, major exporting countries of South Korea such as China, USA, and Vietnam are included in Group 4 and Group 5 and most exporting goods in these groups are high value products. Then we used LightGBM(LGBM) and Exponential Moving Average(EMA) for prediction. Considering the characteristics of each group, models were built using LGBM for Group 1 to 4 and EMA for Group 5. To evaluate the performance of the model, we compare different model structures and algorithms. As a result, it was found that the separated learning model had best performance compared to other models. After the model was built, we also provided variable importance of each group using SHAP-value to add explainability of our model. Based on the prediction model, we proposed a second-stage recommendation strategy for potential export countries. In the first phase, BCG matrix was used to find Star and Question Mark markets that are expected to grow rapidly. In the second phase, we calculated scores for each country and recommendations were made according to ranking. Using this recommendation framework, potential export countries were selected and information about those countries for each item was presented. There are several implications of this study. First of all, most of the preceding studies have conducted research on the specific situation or country. However, this study use various variables and develops a machine learning model for a wide range of countries and items. Second, as to our knowledge, it is the first attempt to adopt a separated learning method for exports prediction. By separating the dataset into 5 homogeneous subgroups, we could enhance the predictive performance of the model. Also, more detailed explanation of models by group is provided using SHAP values. Lastly, this study has several practical implications. There are some platforms which serve trade information including KOTRA, but most of them are based on past data. Therefore, it is not easy for companies to predict future trends. By utilizing the model and recommendation strategy in this research, trade related services in each platform can be improved so that companies including SMEs can fully utilize the service when making strategies and decisions for exports.

• Journal of the Korean Society of Marine Environment & Safety
• /
• v.24 no.5
• /
• pp.628-636
• /
• 2018

Because large buoys are mainly made of steel, they are heavy and vulnerable to corrosion by sea water. This makes buoy installation and maintenance difficult. Moreover, vessel collision accidents with buoys and damage to vessels due to the material of buoys (e.g., steel) are reported every year. Recently, light buoys adopting eco-friendly and lightweight materials have come into the spotlight in order to solve the previously-mentioned problems. In Korea, a new lightweight buoy with a 7-Nautical Mile lantern adopting expanded polypropylene (EPP) and aluminum to create a buoyant body and tower structure, respectively, was developed in 2017. When these light buoys are operated in the ocean, the visibility and angle of light from the lantern installed on the light buoys changes, which may cause them to function improperly. Therefore, research on the performance of light buoys is needed since the weight distribution and motion characteristics of these new buoys differ from conventional models. In this study, stability estimation and motion analyses for newly-developed buoys under various environmental conditions considering a mooring line were carried out using ANSYS AQWA. Numerical simulations for the estimation of wind and current loads were performed using commercial CFD software, Siemens STAR-CCM+, to increase the accuracy of motion analysis. By comparing the estimated maximum significant motions of the light buoys, it was found that waves and currents were more influential in the motion of the buoys. And, the estimated motions of the buoys became larger as the sea state became worser, which might be the reason that the peak frequencies of the wave spectra got closer to those of the buoys.

• Culinary science and hospitality research
• /
• v.18 no.4
• /
• pp.1-14
• /
• 2012

The focus of this study is on investigating an appropriate selling strategy for the guests of a fine dining restaurant in deluxe hotels located on seoul. As survey methods, questionnaires were prepared and distributed to the customers who visited the restaurants of five-star hotels in Seoul. The survey was carried out from July 1 to August 30, 2010. Total 223 copies of questionnaire were used for final analysis. Frequency analysis, descriptive statistics, exploration factor analysis, and reliability analysis were conducted through SPSS 18.0 for final analysis, and path analysis was conducted through AMOS 18.0 for verification of hypotheses. The hypothesized relationships among the models were tested simultaneously by using a structure equation model(SEM). The proposed model provided an adequate fit to the date, $X^2$ = 143.934(df=120, p<.001), GFI=0.935. AGFI= 0.907, RMR=0.022, CFI=0.983. The study results are as follows. First, the restaurant employee's adaptive selling strategies consist of persuasion-suggestion, kindness-rapidity. Second, in the result of analysis to understand the influences between customer satisfaction and adaptive selling strategies, customer satisfaction is shown to have an influential relationships with persuasion-suggestion strategy and kindness-rapidity strategy of employee's adaptive selling. Third, all adaptive selling strategies did not affect customer loyalty. Finally, customers who are satisfied with such services have a significant effect on customer loyalty and supports the existing previous studies.

• Journal of Intelligence and Information Systems
• /
• v.28 no.2
• /
• pp.171-189
• /
• 2022

Online reviews play an essential role in the consumer's purchasing decision-making process, and thus, providing helpful and reliable reviews is essential to consumers. Previous online review helpfulness prediction studies mainly predicted review helpfulness based on the consistency of text and rating information of online reviews. However, there is a limitation in that representation capacity or review text and rating interaction. We propose a CNN-RHP model that effectively learns the interaction between review text and rating information to improve the limitations of previous studies. Multi-channel CNNs were applied to extract the semantic representation of the review text. We also converted rating into independent high-dimensional embedding vectors representing the same dimension as the text vector. The consistency between the review text and the rating information is learned based on element-wise operations between the review text and the star rating vector. To evaluate the performance of the proposed CNN-RHP model in this study, we used online reviews collected from Amazom.com. Experimental results show that the CNN-RHP model indicates excellent performance compared to several benchmark models. The results of this study can provide practical implications when providing services related to review helpfulness on online e-commerce platforms.

• Journal of Intelligence and Information Systems
• /
• v.29 no.4
• /
• pp.31-49
• /
• 2023

With the growth of the food-catering industry, consumer preferences and the number of dine-in restaurants are gradually increasing. Thus, personalized recommendation services are required to select a restaurant suitable for consumer preferences. Previous studies have used questionnaires and star-rating approaches, which do not effectively depict consumer preferences. Online reviews are the most essential sources of information in this regard. However, previous studies have aggregated online reviews into long documents, and traditional machine-learning methods have been applied to these to extract semantic representations; however, such approaches fail to consider the surrounding word or context. Therefore, this study proposes a novel review textual-based restaurant recommendation model (RT-RRM) that uses deep learning to effectively extract consumer preferences from online reviews. The proposed model concatenates consumer-restaurant interactions with the extracted high-level semantic representations and predicts consumer preferences accurately and effectively. Experiments on real-world datasets show that the proposed model exhibits excellent recommendation performance compared with several baseline models.