• Journal of KIISE:Databases
• /
• v.31 no.5
• /
• pp.468-478
• /
• 2004

It is essential in various application areas of data mining and bioinformatics to effectively retrieve the occurrences of interesting patterns from sequence databases. For example, let's consider a network event management system that records the types and timestamp values of events occurred in a specific network component(ex. router). The typical query to find out the temporal casual relationships among the network events is as fellows: 'Find all occurrences of CiscoDCDLinkUp that are fellowed by MLMStatusUP that are subsequently followed by TCPConnectionClose, under the constraint that the interval between the first two events is not larger than 20 seconds, and the interval between the first and third events is not larger than 40 secondsTCPConnectionClose. This paper proposes an indexing method that enables to efficiently answer such a query. Unlike the previous methods that rely on inefficient sequential scan methods or data structures not easily supported by DBMSs, the proposed method uses a multi-dimensional spatial index, which is proven to be efficient both in storage and search, to find the answers quickly without false dismissals. Given a sliding window W, the input to a multi-dimensional spatial index is a n-dimensional vector whose i-th element is the interval between the first event of W and the first occurrence of the event type Ei in W. Here, n is the number of event types that can be occurred in the system of interest. The problem of‘dimensionality curse’may happen when n is large. Therefore, we use the dimension selection or event type grouping to avoid this problem. The experimental results reveal that our proposed technique can be a few orders of magnitude faster than the sequential scan and ISO-Depth index methods.hods.

• Korean Journal of Poultry Science
• /
• v.35 no.4
• /
• pp.327-333
• /
• 2009

In Korea chicken meat price is not determined in the auction markets, but it is artificially calculated using the live chicken price of one day before, transporting cost, converting rate of live chicken into carcass, and slaughtering cost. This calculated price is published through the mass media and used as the base for chicken meat transaction. By the way, since 85% of the Korean broiler industry is composed by the integrated system, the live chicken price is nothing to do with ex-factory price of chicken meat produced by the integrators. Under this pricing system, when we estimate the margin of the chicken meat through the marketing process, the margin of the integrator is fluctuated by the live chicken price of one day before, which is nothing to do with integrators; When the live chicken price is low, the margin of the integrators is low, but the margin of the selling agencies' is relatively high. On the contrast, when the live chicken price is high, the margin of the integrators is high, but the selling agencies' margin will be relatively low, because consumer's price could not be increased in parallel with increase of the live chicken price. Accordingly, the ex-factory price of chicken meat determined using the production cost of live chicken and slaughtering cost of the integrator by adding resonable margin of the integrator should be determined and published, so that it could be used for chicken meat transaction. In Japan the Zen-Noh Chicken Foods Corporation announce the ideal piece of chicken every morning, and all the transactions of the chicken meat will be determined based on this price. In Korea, it will be desirable to make bench marking from Japanese case, in other words the NH could announce the ideal price of chicken meat every morning, so that it would be the base price of chicken meat transaction. Even though the market share of the NH is less than 5%, its publicity should be accepted, since it is a subsidiary of the National Agricultural Cooperative Federation of Korea.