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

• Science of Emotion and Sensibility
• /
• v.21 no.3
• /
• pp.115-128
• /
• 2018

Tibetans who live in the Tibetan highlands, the Roof of the World, have their own unique lifestyle wherein they conform to its long history, natural environment, and their own form of clothing culture. In their costumes, the use of colors, patterns and designs express religious meaning and represent the hopes and heart of life, which respects nature. This study aims to analyze the colors used in Tibetan costumes and examine the meaning of these colors. In addition, this study intends to understand the specificity of Tibetan culture through a consideration of the symbolism of the colors of ethnic costumes. By examining the literature and conducting case studies, colors of Tibetan costumes were analyzed through the I.R.I HUE-TONE system. We analyzed 96 photographs of the costumes photographed during the Tibet ceremony costume, photographs seen at the Qinghai Tibet Culture Museum and photographs from the Internet museum. The results revealed the following: First, the most important element of the costumes is connected to the five colors of JangOsaek, which gives meaning to each color. Red, navy blue, yellow, white and green symbolize fire, the sky, earth, clouds or snow, and grasslands, respectively. Second, Tibetan costumes are characterized by bold color contrasts such as red and green, black and white, red and yellow, and yellow and purple to achieve an intense harmony of colors. Third, these fancy costumes express the unique aesthetics of the Tibetan people. The primary colors follow general emotions, but they can also include their own emotion.

• Science of Emotion and Sensibility
• /
• v.22 no.2
• /
• pp.83-100
• /
• 2019

The purposes of this study are to identify the meaning of the geometrical patterns preferred by ancient Korean peoples and to classify them into some groups by their similarity. We investigated various patterns found on clothing and relics from GoJoseon to Goguryeo period, and utilized secondary sources such as history articles, Internet materials and photo and analyzed the associations of the varied patterns found in pottery, handicrafts, and clothing with the ancient cultures. We found the letters (ㅇ, ㅁ, and ㅅ of Korean alphabet, Hangul) preferred by ancestors who worshipped nature to identify the significations attached by them to particular patterns. The results confirm the following: first, the circle pattern indicated the sun, moon, stars in the sky, a bronze mirror, and a man's face. Circles and ovals were also observed to represent the individual souls of the clan or community. Second, square patterns symbolized the land and the patterns that signified the wellbeing of family and the country. Oblique rectangles were more frequently used as they represented a double use of the triangle, a shape that implied mystic power. Third, triangle symbolized regeneration, power, and humanity. While the Neolithic Age jade remnants of hair combs appear not to be irrelevant to the process of comb-shaped pottery production of the time, many fine comb-like lines may be found on bronze mirrors. Through its review of the glorious designs inherited from and established by ancient ancestors, the present research endeavor may help in identifying the spirits and traditions of Korean history.

• Korean Journal of Heritage: History & Science
• /
• v.51 no.2
• /
• pp.92-107
• /
• 2018

In 2013~2016, gilt-bronze shoes were excavated from the ancient tombs in Jeongchon Village located at Bogam-ri, Dasi-myeon in Naju. They are estimated to have been made in the late 5th or early 6th centuries. The gilt-bronze shoes are significant in that they serve to explicate the relationship between the center of Baekje and the local forces in the Yeongsan River Basin. This study's specific focus was the gilt-bronze shoes from the ancient tombs in Jeongchon Village. Based on the findings, a restoration drawing was designed and restored products were manufactured by considering metalwork techniques used to manufacture the original ones. At first, manufacturing techniques were tested by using a scientific analysis and visual observation. The manufacturing method, structures, and patterns of the gilt-bronze shoes were closely examined. Then, a design drawing of gilt-bronze shoes was created through field measurement and they were recreated on the basis of the analysis. The original form of the restored products were manufactured through cutting out the outward form, bore carving, engraving, molding, plating, and an assembly process. In the restoration process, this study examined the formal characteristics of gilt-bronze shoes, manufacturing techniques, and archetypes during Baekje's late Hanseong era. Products restored from this study are expected to be used as achievements for more easily understanding the culture of Baekje.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.19 no.12
• /
• pp.186-196
• /
• 2018

Sports has become one way to improve our own health and to enjoy life by changing the lifestyle of modern-day people. Sports athletes not only give pleasure to the public, but also play a role in elevating a nation's reputation through sports. Tennis is popular with the public, and women players receive tennis wear from various sports companies to promote the designs to the public. This study considers the design-related characteristics of women's tennis wear through content analysis of design elements from the tennis wear in four major tournaments over the most recent five years. This is important in order to provide basic data on design directions for tennis wear in the future. The results of this study are as follows. First, the silhouette plays a role in enhancing activity by considering the physical movement of tennis players who are very active. Second, color emphasizes the rules and clarity of traditional tennis tournaments, and reflects a diversified trend in tennis wear by considering smooth game play by players and combining popular colors in the year. Third, patterns and decorations on material are used as a means to emphasize the esthetics of tennis wear, and tape plays an auxiliary role in emphasizing the physical beauty of women or preventing physical movement causing injury. In addition, sponsor logos are generally located at the center of the chest of tennis wear tops by mixing letters and images. This can be interpreted as a part of the marketing strategy to enhance clarity of the sponsor's brand.

• Journal of Conservation Science
• /
• v.35 no.3
• /
• pp.217-225
• /
• 2019

The chimi(ridge-end tile) of Wangheungsa temple is the oldest in our country. The upper part of the chimi was excavated from the southern side of Wangheungsa temple and the lower part from the northern side. These parts are considered to be portions of the same chimi, because they are similar in shape and are excavated from two sides of the same temple structure. However, the original shape of the chimi cannot be determined owing to substantial deterioration. Hence, in this study, replicas of the deteriorated chimi portions of Wangheungsa temple were fabricated by employing 3D scanning technology and the computer numerical control machining method. While observing the bending phenomenon of the chimi, the proposed model was warped realistically on the basis of the bending direction of the actual chimi. Consequently, the restoration process was modified several times. The results indicated that no gaps can be found between the upper and lower parts, and the corresponding patterns connect naturally. Furthermore, the proposed method is contactless, safe, operable, reproducible, and appropriate for restoration of artifacts. Additionally, the modeling data is semi-permanent. Hence, if modelling data is appropriately applied as per the characteristics of artifacts, it can be utilized in various fields such as virtual exhibitions, hands-on exhibitions, cultural heritage restoration, and production of teaching aids and souvenirs.

• Science of Emotion and Sensibility
• /
• v.26 no.4
• /
• pp.71-92
• /
• 2023

This study investigates the symbolism and meaning of the bead design, its relationship with the Silla culture, and the conditions of glass bead manufacturing to verify the theory of Silla's production of Silla face-inlaid glass beads with excellent artistry and technology. The research method includes investigating the design analysis, ancient documents, myths, relics, glass, and metal production techniques. Moreover, Hongshan cultural relics and other cases of inlaid glass beads were collected. There are records in the literature that the people of Makhan, Buyeo and Silla of ancient Korea people considered beads as treasures and used them for accessories. It was confirmed that all the design elements of the bead-patterned hair topknot, golden crown, birds, and flower trees were closely related to the myth of Kim Al-ji of Silla, the oviparous tales and the sacred birds and divine beasts of the north. Moreover, the pattern and arrangements were found to be similar in other Silla relics. The origin of beads and face pendants was Hongsan culture, and a stone cast for beads was discovered in Bukpyo of Gojoseon, the lower-level culture of Hajiajeom. In addition, excavating inlaid glass beads from Sik-ri tombs of Korea and a face-inlaid glass bead from Toganmori tombs in Japan confirms the theory of Silla's production. The fact that the Baekje people of ancient Korea had a glass bead manufacturing office in Japan in the fifth centuries suggests that the Silla people also had a manufacturing plant in Java, Indonesia, because this place was a crossroads of Silla's Sea Silk Road and a source of raw materials and labors with a close relationship to Silla. Therefore, the face-inlaid glass bead was indeed self-made by Silla, who possessed the tradition of bead myths and hair topknot, and the high-level skills such as gold crowns and metal inlays.

• Korean Journal of Heritage: History & Science
• /
• v.45 no.3
• /
• pp.160-173
• /
• 2012

Roofing tile research conducted in Korea so far is mostly related to studies on roofing tile patterns excavation report on the roof tile klin site in the aspects of archeology architecture and history of art. There have been continuous studies on kiln ground and manufacture techniques of roofing tiles. However it is difficult to find roofing tiles research based on scientific experiments. The research on this paper performs physical and chemical experimental study to understand order, manufacturing techniques and other characteristics of Chosun Dynasty roofing tiles excavated in Dongdaemun stadium. As for physical experimental study water absorption, specific gravity, whole-rock Magnetic susceptibility rate and Differential Thermal Analysis are conducted. As for chemical experimental study, neutron activation analysis(NAA), microstructure observation, X-ray diffractometry(XRD) analysis are conducted. Result of neutron activation analysis and statistical analysis on piece of roof tile 22 samples clearly show that the roofing tile samples are from different time line and places. It also shows different composition when compare average value of rare earth resources per findspots. It means roofing tiles were manufactured from clay mineral from several places. Close inspection using XRD and polarization microscope reveals that main components of roofing tiles are quartz and felspar. Mica and Illite are found partially. XRD analysis shows mullite mineral composition which occurs when roofing tile is calcined around $1000^{\circ}C$. Differential thermal analysis shows gradual exothermic peak near $900^{\circ}C$. Based on these results, it is assumed that roofing tile is made at $900{\sim}1000^{\circ}C$. result of XRD analysis shows mullite were made near $1000^{\circ}C$. in Differential Thermal Analysis shows gradual exothermic peak near $900^{\circ}C$. this results shows that roof tiles were made near 900~1000 near $1000^{\circ}C$ mean value of whole-rock Magnetic susceptibility rate. When performed comparative analysis using whole-rock Magnetic susceptibility rate average value, findspots provided no certain classification to arrange. Nonetheless low whole-rock Magnetic susceptibility rate 0.2~0.78(${\times}103$ SI unit) is found when roofing tile patterns are Pasangmun, Taesangmun, Eosangmun, Kyukjamun, Heongsunmun. Overall absorptivity is 14~21%. It is similar to 14~18% of roofing tile from Chosun Dynasty. There is only 1.4~2.5g/cm3 of roof tile sample specific gravity. The analysis finds no difference in specific gravity by findspots.

• Korean Journal of Heritage: History & Science
• /
• v.56 no.1
• /
• pp.182-205
• /
• 2023

The use of royal artificial flowers was finally found through schematics and records in Wonhaeng Eulmyojeongri Uigwe, which organized the procession to Hwaseong in 1795. The results of classifying the uses of artificial flowers in the brthday banquet at Bongsudang Hall in 1795 and considering the shape, user, and usage are as follows. According to literature records, artificial flowers were made with high-quality materials such as gold, silver, and silk thread in the early period, but were mainly made of paper in the later period. Artificial flowers were used for decorating official hats, Bongsudang Hall, and banquet tables. The Sagwonhwa was used for decoration of the official hats of members of the royal family, and the one on the top was called Eosam-Sagwonhwa. At the birthday banquet inBongsudang Hall, King Jeongjo and Hyegyeonggung used the Eosam-Sagwonhwa and put it on the right side of the official hats. Officials put peach blossom with two petals on the left side of the official hats for decoration. The artificial flowers for decoration of the official hats of musicians and dancers were more expensive and flashier than the officials' ones. Depending on the dance, several artificial flowers were inserted into the official hats. When measuring the size of artificial flowers, the scale used was when making a ceremonial article. For artificial flowers for decoration of the banquet hall, red and white peach blossoms were placed in two jars with dragons painted on them and them placed on two red-painted tables, respectively. The table and jar with flowers were tied together with a red cotton string and fixed so as not to fall over. The artificial flowers for decoration of the banquet table of King Jeongjo, Hyegyeonggung, and the king's sisters were a large lotus, medium-sized lotus, peony, rose, and specially made peach flowers. The artificial flowers for decoration of the banquet table of guests and officials were small lotuses and peach blossoms. The artificial flowers used in the birthday banquet at Bongsudang Hall the most were peach blossoms, and peaches had the meaning of longevity and exorcism. It is expected that the above research results will be helpful in understanding the characteristics and usage of artificial flowers in the period of King Jeongjo and use in reproducing royal feasts and producing traditional cultural contents.

• Journal of the Korean Geotechnical Society
• /
• v.21 no.4
• /
• pp.65-70
• /
• 2005

Many case histories of re-liquefaction phenomena seem to support the idea that sand deposits, if they once have been liquefied, could be reliquefied again by a subsequent earthquake even though the earthquake is smaller than the previous one. The magnitude of the strains induced in the initial liquefaction has a significant influence on the resistance of the sample to re-liquefaction. The deposits undergoing liquefaction experience large shear strain during liquefaction. And this previous strain changes the microstructure into highly anisotropic structure such as columnlike structure and connected voids. This type of anisotropy is so unstable that it can reduce re-liquefaction resistance. It is blown that the extent of anisotropic structural change depends on the gradation characteristics of ground. The purpose of this study is to estimate the correlation between the gradation characteristics of the sand and the ratio of re-liquefaction resistance to liquefaction resistance. In this study, 1-g shaking table tests were carried out on five different kinds of sands. During the tests the values of excess pore pressure at various depths and surface settlements were measured. Re-liquefaction resistances were not affected by the initial void ratio and the effective confining pressures, and the deposits of all test sands which had once been liquefied were reliquefied in the cyclic loading number below 1 to 1.5. The ratio of re-liquefaction resistance to liquefaction resistance linearly decreased as $D_{10}/C_u$ increased, and was constant as about 0.2 above the value of $D_{10}/C_u$, 0.15 mm.