DOI QR코드

DOI QR Code

An Application of Recursive Method for Efficient Retrieval in Business Material Management

기업 자재관리시스템에서 효율적인 검색을 위한 순환적 방법의 적용

  • Kim, Young-Jun (Economics & Commerce Division, Baekseok Culture University)
  • Received : 2010.07.21
  • Accepted : 2010.09.08
  • Published : 2010.09.30

Abstract

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.

기업의 자재관리 영역에서 자재소요계획은 효과적인 의사결정을 위한 중요한 활동 중 하나이다. 수요가 점차 늘어남에 따라 실용성 있는 데이터 모델이 필수적으로 요구되고 있다. 본 연구는 다양한 형태로 표현되는 데이터를 적절한 구조로 모델링하여 기업 자재관리 응용 분야에서 효율적으로 사용할 수 있도록 연역 모델 릴레이션을 설계한다. 이를 이용하여 순환적 데이터 검색을 가능하게 하는 새로운 질의 방법을 제시하며, 그 효율성을 비교한다.

Keywords

References

  1. Chakravarthy, U., J. Grant, and J. Minker, "Logic-Based Approach to Semantic Query Optimization," ACM Transactions on Database Systems, Vol. 15, No. 2, 2005, pp102-121.
  2. Chase, B., and N. Aquilano, Production and Operations Management : A Life Cycle Approach, 5th ed., Richard D. Irwin Inc., 2009.
  3. Emerson, L., M. Darnovsky, and J. Bowman, The Practice SQL Handbook using Structures Query Language, Addison-Wesley Publishing Company, 2007.
  4. Fratarcangeli, C., "Technique for Universal Quantification in SQL," ACM SIGMOD RECORD, Vol. 20, No. 3, Sep., 2001, pp.304-325.
  5. Gallaire, H., J. Minker, and J. Nicolas, "Logic and Database : A Deductive Approach," ACM Computing Surveys, Vol. 16, No. 5, 2008, pp.145-156.
  6. Naughton, F., "Minimizing Function-Free Recursive Inference Rules," Journal of the ACM, Vol. 36, No. 1, Jan., 2009, pp.69-91
  7. Parsaye, K., M. Chignell, S. Khoshafian, and H. Wong, Intelligence Database, John Wiley & Sons Inc., 2000.
  8. Saraiya, P., "Hard Problems for Simple Logic Programs," ACM SIGMOD, 2004, PP.64-80.
  9. Sarda, L., "Extensions to SQL for Historical Database," IEEE Transactions on Knowledge and Data Engineering, Vol 23, No. 5, June, 2006, pp.220-235.
  10. Thur, S., and C. Zaniolo, "LDL: A Logic-Based Data Language," Proceedings of the 12th International Conference on Very Large Database, Kyoto, Aug., 2008, pp.302-320.