• Journal of KIISE:Databases
• /
• v.34 no.1
• /
• pp.18-34
• /
• 2007

In order to provide various business analysis methods, OLAP(On-Line Analytical Processing) systems represent their data with multidimensional structures. These multidimensional data are often delivered to users in the horizontal format of tables whose columns are corresponding to values of dimension attributes. Since the horizontal tables nay have a large number of columns, they cannot be stored directly in relational database systems. Furthermore, the tables are likely to have many null values (i.e., sparse tables). In order to manage the horizontal tables efficiently, we can store them as the vertical format of tables which has dimension attribute names as their columns thus transforms the columns of horizontal tables into rows. In this way, every queries for horizontal tables have to be transformed into those for vertical tables. This paper proposed a technique for transforming horizontal table queries into vertical table ones by utilizing not only traditional relational algebraic operators but also the PIVOT operator which recent DBMS versions are providing. For achieving this goal, we designed a relational algebraic expression equivalent to the PIVOT operator and we formally proved their equivalence. Then, we developed a transformation technique for horizontal table queries using the PIVOT operator. We also performed experiments to analyze the performance of the proposed method. From the experimental results, we revealed that the proposed method has better performance than existing methods.

• The KIPS Transactions:PartD
• /
• v.16D no.4
• /
• pp.463-474
• /
• 2009

To analyze multidimensional data conveniently and efficiently, OLAP (On-Line Analytical Processing) systems or e-business are widely using views in a horizontal form to represent measurement values over multiple dimensions. These views can be stored as materialized views derived from several sources in order to support accesses to the integrated data. The horizontal views can provide effective accesses to complex queries of OLAP or e-business. However, we have a problem of occurring maintenance of the horizontal views since data sources are distributed over remote sites. We need a method that propagates the changes of source tables to the corresponding horizontal views. In this paper, we address incremental maintenance of horizontal views that makes it possible to reflect the changes of source tables efficiently. We first propose an overall framework that processes queries over horizontal views transformed from source tables in a vertical form. Under the proposed framework, we propagate the change of vertical tables to the corresponding horizontal views. In order to execute this view maintenance process efficiently, we keep every change of vertical tables in a differential file and then modify the horizontal views with the differential file. Because the differential file is represented as a vertical form, its tuples should be converted to those in a horizontal form to apply them to the out-of-date horizontal view. With this mechanism, horizontal views can be efficiently refreshed with the changes in a differential file without accessing source tables. Experimental results show that the proposed method improves average performance by 1.2$\sim$5.0 times over the existing methods.

• Journal of Korea Multimedia Society
• /
• v.9 no.6
• /
• pp.700-708
• /
• 2006

In this paper, we propose a method of managing versions of XML documents by using relational databases. Data structures based on relational tables are developed for accommodating versions of XML documents. The structure information, the contents, and changes of the versions are stored in relational tables. Thus, SQL can be exploited in queries such as horizontal queries, vertical queries, and delta queries without parsing the documents. The structure information and contents of all versions are not represented explicitly in the tables, those of certain versions which are called snapshot versions are represented. Other versions are represented indirectly as sequences of operations that are stored in the corresponding tables. The experiment shows the space performance.

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 2004.10a
• /
• pp.672-676
• /
• 2004

In this paper, measuring system of 5 DOF motion errors are proposed using two capacitive type sensor, a straight edge and a laser interfoerometer. Yawing error and pitching error are measured using the laser interferometer, and rolling error is measured by the reversal method using a capacitive type sensor. Linear motion errors of horizontal and vertical direction are measured using the sequential two point method. In this case, influence of angular motion errors is compensated using the previously measured angular motion errors. In the horizontal direction, measuring accuracy is within 0.05 $\mu$m and 0.27 arcsec, and in the vertical direction, it is within 0.15 $\mu$m and 0.5 arcsec. From these results, it is confirmed that the proposed measureing system is very effective to the measurement of 5 DOF motion errors in the ultra precision feed tables.

• The KIPS Transactions:PartD
• /
• v.14D no.2
• /
• pp.157-168
• /
• 2007

For effective analyses in various business applications, OLAP(On-Line Analytical Processing) systems represent the multidimensional data as the horizontal format of tables whose columns are corresponding to values of dimension attributes. Because the traditional RDBMSs have the limitation on the maximum number of attributes in table columns(MS SQLServer and Oracle permit each table to have up to 1,024 columns), horizontal tables cannot be directly stored into relational database systems. In this paper, we propose various efficient optimization strategies in transforming horizontal queries to equivalent vertical queries. To achieve this goral, we first store a horizontal table using an equivalent vertical table, and then develop various query transformation rules for horizontal table queries using the PIVOT operator. In particular, we propose various alternative query transformation rules for the basic relational operators, selection, projection, and join. Here, we note that the transformed queries can be executed in several ways, and their execution times will differ from each other. Thus, we propose various optimization strategies that transform the horizontal queries to the equivalent vertical queries when using the PIVOT operator. Finally, we evaluate these methods through extensive experiments and identify the optimal transformation strategy when using the PIVOT operator.

• The Magazine of the Society of Air-Conditioning and Refrigerating Engineers of Korea
• /
• v.5 no.3
• /
• pp.178-197
• /
• 1976

Based on the measurement data on Radiation on a Horizontal Surface at 84 different areas in South Korea which were collected and recorded by the Central Meteorological Office, the average values in the period of 5 years from 1971 thru 1975 at 12 particular areas of Gangreung, Gyeongju, Gwangju, Gimhae, Mogpo, Seoul, Iri, Jeju, Jinju, Cheongju and Chungju are indicated in this report. For above 12 areas the following data have been obtained and are indicated in each tables. Annual totalization of Radiation on a Horizontal Surface and its yearly averaged daily totalization$cdots$Table 1. Monthly totalization of Radiation on a Horizontal Surface and its monthly averaged daily totalization$cdots$Table 2 Maximum and minimum values of daily totalization of Radiation on a Horizontal Surface$cdots$Table 3 Daily variation of monthly averaged Radiation on a Horizontal Surface$cdots$Table 4 thru 15 Decade averaged Radiation on a Horizontal Surface$cdots$Table 16 thru 27

• Proceedings of the Korean Society for Noise and Vibration Engineering Conference
• /
• 2012.04a
• /
• pp.324-329
• /
• 2012

Isolation tables are widely used for precision equipments and their isolation performances have been usually expressed and evaluated by transsmissibility. However, transmissibility is a concept for 1-degree of freedom(DOF) system. In practice, isolation tables are supproted by more than 4 springs. Each spring is subjected to vertical and horizontal ground vibrations, and also the table has more than 1-DOF. Therefore, isolation tables should be treated as multi-input/multi-output(MIMO) system of which isolation performance is expressed by transmissibility matrix. However, the matrix is too complicated to be an index for a system. In this paper, maximum singular value of transmissibility matrx is suggested as a simple performance index of a MIMO isolation system. Physical meaning of singular value is explained using a simple a 2-DOF isolation table. Furthermore, maximum singular values of passive, 3-DOF active and 6-DOF active isolation tables are obtained through experiments, and their meaning are explained and compared with each other.

• International Journal of Precision Engineering and Manufacturing
• /
• v.4 no.2
• /
• pp.57-63
• /
• 2003

A new method using a transfer function was proposed in the previous paper for analyzing motion errors of hydrostatic tables. The calculated motion errors by the new method, named as the transfer (unction method (TFM), were compared with the results by the conventional multi pad method, and the validity of the proposed method was theoretically verified. In this paper, the relationship between rail form error and motion errors of a hydrostatic table is examined theoretically in order to comprehand so-called 'the averaging effect of an oil film', and the characteristics of the motion errors in a hydrostatic table is tested. The tested hydrostatic table has three single-side pads in the vertical direction and three pairs of double-sides pads in the horizontal direction. The motion errors are tested for three rails which have different form errors. The experimental results are compared with the theoretical results calculated by the TFM, and both results show good agreement. From the results, it is shown that the TFM is very effective to analyze the motion errors of hydrostatic tables.

• Education of Primary School Mathematics
• /
• v.20 no.1
• /
• pp.53-68
• /
• 2017

Although the table, as one of the representations for helping mathematics understanding, steadily has been shown in the mathematics textbooks, there have been little studies that focus on the table and analyze how the table may be used in understanding students' functional thinking. This study investigated the elementary school 5th graders' abilities to design function tables. The results showed that about 75% of the students were able to create tables for themselves, which shaped horizontal and included information only from the problem contexts. And the students had more difficulties in solving geometric growing pattern problems than story problems. Building on these results, this paper is expected to provide implications of instructional directions of how to use the table as 'function table'.

• Proceedings of the Earthquake Engineering Society of Korea Conference
• /
• 1998.10a
• /
• pp.163-172
• /
• 1998

The design fundamentals of the shaking tables are briefly discussed. In order to understand the recent trends in development of the shaking tables, the characteristics and performances of the major seismic testing facilities are investigated. The international standards related to the vibration tests using shaking table are also overviewed. The newly designed multipurpose biaxial shaking table of Hyundai Heavy Industries, Co., Ltd. is introduced. It has the capabilities to perform the vibration, shock and seismic qualification tests in two simultaneous and independent directions (vertical and horizontal directions). Since the shaking table adapts four extremely stiff torque instead of much more expensive hydraulic actuators, these tubes can restrain two undesired rotational motions. Regarding the manufacturing and maintenance costs, two system is more economical since it has only two hydraulic actuators unlike others.