• 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.

• Journal of Korea Spatial Information System Society
• /
• v.6 no.1 s.11
• /
• pp.73-85
• /
• 2004

Recently, as the growth of the wireless Internet, PDA and HPC, the focus of research and development related with GIS(Geographic Information System) has been changed to the Real-Time Mobile GIS to service LBS. To offer LBS efficiently, there must be the Real-Time GIS platform that can deal with dynamic status of moving objects and a location index which can deal with the characteristics of location data. Location data can use the same data type(e.g., point) of GIS, but the management of location data is very different. Therefore, in this paper, we studied the Real-Time Mobile GIS using the HBR-tree to manage mass of location data efficiently. The Real-Time Mobile GIS which is developed in this paper consists of the HBR-tree and the Real-Time GIS Platform HBR-tree. we proposed in this paper, is a combined index type of the R-tree and the spatial hash Although location data are updated frequently, update operations are done within the same hash table in the HBR-tree, so it costs less than other tree-based indexes Since the HBR-tree uses the same search mechanism of the R-tree, it is possible to search location data quickly. The Real-Time GIS platform consists of a Real-Time GIS engine that is extended from a main memory database system. a middleware which can transfer spatial, aspatial data to clients and receive location data from clients, and a mobile client which operates on the mobile devices. Especially, this paper described the performance evaluation conducted with practical tests if the HBR-tree and the Real-Time GIS engine respectively.

• Progress in Medical Physics
• /
• v.26 no.4
• /
• pp.286-293
• /
• 2015

The purpose of this study was to evaluate the set up accuracy using stereotactic body frame and frameless immobilizer for lung stereotactic body radiation therapy (SBRT). For total 40 lung cancer patients treated by SBRT, 20 patients using stereotactic body frame and other 20 patients using frameless immobilizer were separately enrolled in each group. The setup errors of each group depending on the immobilization methods were compared and analyzed. All patients received the dose of 48~60 Gy for 4 or 5 fractions. Before each treatment, a patient was first localized to the treatment isocenter using room lasers, and further aligned with a series of image guidance procedures; orthogonal kV radiographs, cone-beam CT, orthogonal fluoroscopy. The couch shifts during these procedures were recorded and analyzed for systematic and random errors of each group. Student t-test was performed to evaluate significant difference depending on the immobilization methods. The setup reproducibility was further analyzed using F-test with the random errors excluding the systematic setup errors. In addition, the ITV-PTV margin for each group was calculated. The setup errors for SBF were $0.05{\pm}0.25cm$ in vertical direction, $0.20{\pm}0.38cm$ in longitudinal direction, and $0.02{\pm}0.30cm$ in lateral direction, respectively. However the setup errors for frameless immobilizer showed a significant increase of $-0.24{\pm}0.25cm$ in vertical direction while similar results of $0.06{\pm}0.34cm$, $-0.02{\pm}0.25cm$ in longitudinal and lateral directions. ITV-PTV margins for SBF were 0.67 cm (vertical), 0.99 cm (longitudinal), and 0.83 cm (lateral), respectively. On the other hand, ITV-PTV margins for Frameless immobilizer were 0.75 cm (vertical), 0.96 cm (longitudinal), and 0.72 cm (lateral), indicating less than 1 mm difference for all directions. In conclusion, stereotactic body frame improves reproducibility of patient setup, resulted in 0.1~0.2 cm in both vertical and longitudinal directions. However the improvements are not substantial in clinic considering the effort and time consumption required for SBF setup.

• Journal of Food Hygiene and Safety
• /
• v.38 no.2
• /
• pp.37-45
• /
• 2023

The surge in food delivery systems during the coronavirus 2019 pandemic necessitated this study of heavy metal migration from food contact materials (FCMs). A total of 104 samples of FCMs, comprising 51 polypropylene (PP), 21 polyethylene (PE), and 32 polystyrene (PS) samples of six different types of FCMs (containers, covers, table utensils, cups, pouches, and wrappers) used for food delivery distributed in Korea, were collected and investigated for migration of three heavy metals (Pb, Cd, and As) using inductively coupled plasma-mass spectrometry (ICP-MS) to determine whether they complied with Korea's Standards and Specifications for Utensils, Containers, and Packages. Acetic acid (4%, v/v) was used as the food simulant, and tests were performed at 100℃ (in harsh conditions) for 30 min. Linearity of Pb, Cd, and As showed acceptable results with a coefficient of determination (R²) value of 0.9999. Limit of detection (LOD) and limit of quantification (LOQ) of Pb, Cd, and As were 0.001, 0.001, and 0.001 ㎍/L and 0.002, 0.003, and 0.003 ㎍/L, respectively. Accuracy and precision results complied with the criteria presented in the European Commission Joint Research Centre guidelines. The average concentration of Pb, Cd, and As migration detected in a total of 104 samples was 0.009-0.260 ㎍/L, which was very low compared with the migration specification set in the Standards and Specifications for Utensils, Containers, and Packages. The maximum level of Pb corresponded to 0.23% of the migration limit. There were no samples exceeding the limit. Thus, this study confirmed that the heavy metal contents of FCMs used for delivery food distributed in Korea were safely managed. The data from this study represent an invaluable source for science-based safety management of hazardous heavy metals migrating from FCMs used in the food delivery industry.

• Strategy21
• /
• s.46
• /
• pp.239-276
• /
• 2020

The failure of early economic sanctions aimed at hurting the overall economies of targeted states called for a more sophisticated design of economic sanctions. This paved way for the advent of 'smart sanctions,' which target the supporters of the regime instead of the public mass. Despite controversies over the effectiveness of economic sanctions as a coercive tool to change the behavior of a targeted state, the transformation from 'comprehensive sanctions' to 'smart sanctions' is gaining the status of a legitimate method to impose punishment on states that do not conform to international norms, the nonproliferation of weapons of mass destruction in this particular context of the paper. The five permanent members of the United Nations Security Council proved that it can come to an accord on imposing economic sanctions over adopting resolutions on waging military war with targeted states. The North Korean nuclear issue has been the biggest security threat to countries in the region, even for China out of fear that further developments of nuclear weapons in North Korea might lead to a 'domino-effect,' leading to nuclear proliferation in the Northeast Asia region. Economic sanctions had been adopted by the UNSC as early as 2006 after the first North Korean nuclear test and has continually strengthened sanctions measures at each stage of North Korean weapons development. While dubious of the effectiveness of early sanctions on North Korea, recent sanctions that limit North Korea's exports of coal and imports of oil seem to have an impact on the regime, inducing Kim Jong-un to commit to peaceful talks since 2018. The purpose of this paper is to add a variable to the factors determining the success of economic sanctions on North Korea: preventing North Korea's evasion efforts by conducting illegal transshipments at sea. I first analyze the cause of recent success in the economic sanctions that led Kim Jong-un to engage in talks and add the maritime element to the argument. There are three conditions for the success of the sanctions regime, and they are: (1) smart sanctions, targeting commodities and support groups (elites) vital to regime survival., (2) China's faithful participation in the sanctions regime, and finally, (3) preventing North Korea's maritime evasion efforts.