• Journal of the Korea Society of Computer and Information
• /
• v.11 no.4 s.42
• /
• pp.243-250
• /
• 2006

A recursive relationship is a relationship among entities of the same class. N : M recursive relationships can be used to represent bills of materials. A bill of materials is a special data structure that occurs frequently in manufacturing applications. This data structure is a hierarchy. Most business dimensions have a hierarchical structure. In this study, a design of a hierarchical dimension of the bill of materials type is carried out. As with other N : M relationships, an intersection table that shows pairs of related rows is created, and this table is transformed into a dimension in the OLAP(OnLine Analytical Processing) model. This transformation consists of two tasks: (1)replacing the first column of the intersection table with the lowest level of the dimension: and (2)replacing the second column of the table with the only upper level of the dimension. A case multidimensional information system using the hierarchical dimension is also developed.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1991.10a
• /
• pp.42-43
• /
• 1991

• Proceedings of the Korea Association of Information Systems Conference
• /
• 2005.12a
• /
• pp.389-397
• /
• 2005

오늘날 급변하는 경영환경에서 기업은 존속과 성장을 위해 기업 내외부에 걸친 경영혁신의 노력을 끊임없이 전개하고 있다. 특히 자동차부품산업의 제조자원계획 업무는 기업의 자본(Money), 인력(Man), 물자(Material), 설비(Machine) 등과 같은 중요한 경영자원을 활용하여 부가가치를 창출하는 업무이다. 본 논문은 국내의 자동차부품 기업을 대상으로 기존 자재소요 계획(MRPI) 업무를 AS-IS 분석에 따라 문제점을 찾아내어 타 업무와의 수평적인 통합에 의해 MRP 업무를 혁신적으로 개선할 수 있는 방안을 도출하고, 제조자원 계획의 관점에서 새로운 TO-BE 모델을 도출함으로써 자동차부품 기업의 수주-생산-자재간의 업무연계를 통하여 제조자원관리(MRPII) 업무를 개선하고자 하였다.

• Proceedings of the Korea Society of Information Technology Applications Conference
• /
• 2001.05a
• /
• pp.113-115
• /
• 2001

전기 공사는 만들어져 있는 상품을 선택하는 것이 아니기 때문에 현장을 실제로 측정하지 않고 정확한 견적을 산출하는 것은 매우 어렵다. 본 연구에서는 인터넷상의 웹을 기반으로 하는 견적 프로그램을 개발하여 외부 사용자가 기업에서 제시할 수 있는 적정 경비와 소요 자재 등을 파악할 수 있게 해주는 것이다. 총체적인 경비와 소요 자재, 인건비 등의 항복을 산출해주기 때문에 발주자의 입장에서는 사업비의 타당성을 검증할 수 있게 되고 기업측에서는 사전에 낙찰 가능한 공사에 대한 정보를 획득하고 낙찰 가능성을 높일 수 있게 된다. 사용된 기술을 최근에 각광을 받고 있는 XML과 ASP를 이용하였다.

• Journal of Bio-Environment Control
• /
• v.20 no.4
• /
• pp.269-276
• /
• 2011

The aim of this study was to evaluate the effect of 3 environment- friendly farming materials on the growth of pepper and tomato seedlings under low level of solar radiation. The pepper and tomato seedlings were separately grown on commercial substrate and non-fertilizer substrate under 30% shading condition, respectively. The microbe-, enzyme-, and amino acid-supplements were used for the foliar application to the seedlings. The application of enzyme- and amino acid-supplements significantly enhanced the growth of tomato and pepper seedlings grown on non-fertilizer substrate, while there was no significant effect on the seedlings grown on commercial substrate. The foliar application of enzyme- and amino acid-supplements reduced the days to flowering by 3 to 4 days and lowered the node order of fruit set in tomato plants grown on non-fertilizer substrate. The results showed that the enzyme- and amino acid-supplements could enhance the seedling growth and lower the node order of fruit set under limited nutritional conditions.

• Proceedings of the Korean Institute Of Construction Engineering and Management
• /
• autumn
• /
• pp.498-503
• /
• 2002

Connecting with cost, schedule, and quality in a construction project, resource management is one of the essential management elements. However, the material requirement planning is built at the beginning stage of construction and needs various concerned factors, it is limited to build the resource management planning on enterprise level. The disconnected communication among managements makes impossible to control historical data. In the construction project control system, the core of management elements is to manage cost and schedule information, therefore material requirement planning should be established based on historical data about EVM which is intergating schedule and cost. In this study, a resource management system concerning material requirement planning and attribute of procurement is suggested by connecting the historical data of EVM and the material requirement planning.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.11 no.9
• /
• pp.3289-3295
• /
• 2010

In business material management, as the number of products and their parts increases, the employment of databases becomes inevitable. Many researchers have tried to incorporate semantics in traditional models using logic programming, resulting in the deductive method. However, since the designer of this method does not overcome the traditional design concept of relational method, there have been not much successful implementations in deductive method. Therefore, this paper propose the new way designing the retrieval methods for deductive databases and using those relations the query that makes recursive retrievals possible and hypotheses test in business material management.

• Proceedings of the Korean Institute of Building Construction Conference
• /
• 2008.11a
• /
• pp.141-145
• /
• 2008

Because of world financial crisis, The Korea domestic construction industry has been damaged hugely on material supplying work. A current domestic material supply system can't react properly on a great rise of foreign exchange rate and raw material price, so the system has a problem which is not properly supplying material. To solve this problem, a more innovative material supply work system is seriously needed than ever. So this study wants to improve material supply system for supplying material right time, right place through applying a web-based system. Applying this, overall process of material-supply-work can be done on a web-based system for immediately understanding change of ordering and warehousing by material-supply-schedule to a domestic construction field.

• Proceedings of the Korean Institute Of Construction Engineering and Management
• /
• 2006.11a
• /
• pp.702-707
• /
• 2006

There have been certain extent of material inventory in construction site because of difficulties in ordering by small quantity, strategy of securing future requirements and prevention of delay. However, carrying these inventory entails a financial cost called inventory holding cost and decrease construction productivity, so proper inventory management in construction industry is important for construction efficiency and cost reduction. This study tries to find analytical method of inventory management. It includes ordering decision which decide how much to order and when to order. Setting these strategies including deciding safety inventory, input and ouput variability are able to controled.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.9 no.13
• /
• pp.13-16
• /
• 1986

In this paper we study the decision rule for the amount of purchasing materials according to the fraction defective in the single sampling inspection by attributes based on operating characteristics. In deciding the amount of purchasing materials, it is important that we ought to occupy the practical purchasing amount, considering the fraction defective of the lot in acceptance inspection, because the acceptance probability is variant with the fraction defective of the lot.