Modeling of Incomplete and Uncertain Information in Relational Database for Engineering Design and Production Management: Review and Future Work

Proceedings of the ASME Design Engineering Technical Conference

Volumn 7, Issue , 1998, Pages

  Li, Q ^a   Ma, Z M ^b   Zhang, W J ^c  

^a UNIVERSITY OF ADELAIDE   (Australia)

^b CITY UNIVERSITY OF HONG KONG   (Hong Kong)

^c UNIVERSITY OF SASKATCHEWAN   (Canada)

Author keywords

[No Author keywords available]

Indexed keywords

INDUSTRIAL MANAGEMENT; INFORMATION MANAGEMENT;

ENGINEERING DESIGN; EVOLUTIONARY INFORMATION; INFORMATION MODELING; PROBABILISTIC INFORMATION; PRODUCTION MANAGEMENT; PRODUCTION PROCESS; RELATIONAL DATABASE; UNCERTAIN INFORMATIONS;

RELATIONAL DATABASE SYSTEMS;

EID: 0009808883     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1115/DETC98/EIM-5686     Document Type: Conference Paper

References (41)

1. Barbara, D., Garcia-Molina, H. and Porter, D., 1992, "The Management of Probabilistic Data", IEEE Trans. Knowledge and Data Engineering, Vol. 4(5), pp. 487-502.
2. Buckles, B.P. and Petry, F.E., 1983, "Information-Theoretical Characterisation of Fuzzy Relational Databases", IEEE Trans. Syst. Man Cybern, Vol. 13(1), pp. 74-77.
3. Buckles, B.P. and Petry, F.E., 1984, "Extending the Fuzzy Database with Fuzzy Numbers", Inf. Sci.(New York) 34, pp. 145-155.
4. Cavallo, R. and Pittarelli, M., 1987, "The Theory of Probabilistic Databases", In Proceedings of the 13th VLDB Conference. Brighton, Eng., pp. 71-81.
5. Codd, E.F., 1979, "Extending the Database Relational model to Capture More Meaning", ACM Trans. Database System., Vol. 4(4), pp. 397-434.
6. Codd, E.F., 1986, "Missing Information (Applicable and Inapplicable) in Relational Databases", SIGMOD Rec., Vol. 15(4), pp. 781-823.
7. Codd, E.F. 1987, "More Commentary on Missing Information (Applicable and Inapplicable) in Relational Databases", SIGMOD Rec., Vol. 16(1), pp. 453-468.
8. Date, C.J. 1986, "Relational Database: Selected Writings", Addison-Wesley.
9. Dey, D. and Sarkar, S., 1996, "A Probabilistic Relational Model and Algebra", ACM Trans. Database System, Vol. 21(3), pp. 339-369.
10. Gessert, G.H., 1990, "Four Valued Logic for Relational Database System", SIGMOD Rec., Vol. 19(1), pp. 351-367.
11. Hao, Z.X. and Ma, Z.M., 1994a, "Updating Relational Databases under Null Value I: Extended Model and Basic Operations", Chinese J. of Computers, Vol. 17(7), pp. 481-492.
12. Hao, Z.X. and Ma, Z. M, 1994b, "Updating Relational Databases under Null Value II: the Algorithms for Insertion, Deletion and Modification Operations", Chinese J. of Computers, Vol. 17(7), pp. 493-504.
13. He, J.C., 1987, "Extending Relational Model to Deal with Null Value", Chinese J. of Computers, Vol. 10(8), pp. 449-459.
14. He, X.G., 1989a, "Data Models of the Fuzzy Relational Databases", Chinese J. of Computers, Vol. 12(2), pp. 120-126.
15. He, X.G., 1989b, "Semantic Distance and Fuzzy User's View in Fuzzy Databases", Chinese J. of Computers, Vol. 12(10), pp. 757-764.
16. Klir, G.J. and Folger, T.A. 1988, "Fuzzy Sets, Uncertainty, and Information", Prentice Hall, Englewood
17. Cliffs, N.J. Lee, S.K., 1992, "An Extended Relational Database Model for Uncertain and Imprecise Information", In Proceedings of the 18th VLDB Conference. British Columbia, Eng. 2, pp. 211-220.
18. Li, Q., Zhang, W.J., 1997, "Product data modeling for computer aided product design with partner synthesis in make-to-order virtual enterprise", Int. J. of Computers in Industry (in revision).
19. Li, Q., W.J. Zhang, S.K. Tso, 1997, "A note on product data modeling with special reference to instance as type", Int. J. of Computers in Industry (in revision). Liu, W.Y., 1997, "The Fuzzy Data Dependencies Based on The Semantic Proximity", Chinese Journal of Computers, Vol. 20(8), pp. 725-730.
20. Lui, K.C. and Sunderraman R., 1990, "Indefinite and Maybe Information in Relational Databases", ACM Trans. Database System, Vol. 15(1), pp. 1-39.
21. Lui, K.C. and Sunderraman R., 1991, "A Generalised Relational Model for Indefinite and Maybe Information", IEEE Trans. Knowledge and Data Engineering, Vol. 3(1), pp. 65-77.
22. Ma, Z.M. and Yan, L., 1995a, "Querying Relational Database Containing Indefinite and Maybe Information under Null Value Circumstances", Mini-Micro System, Vol. 16(2), pp. 44-49.
23. Ma, Z.M. and Yan, L. 1995b, "Query Processing of Relational Database Containing Null Value", Computer Research and Development, Vol. 32(9), pp. 31-36.
24. Ma, Z.M., 1996, "Querying Information of Different Kinds under Update Operations in Relational Database Containing Null Value", Chinese J. of Computers, Vol. 19(1), pp. 68-71.
25. Ma, Z.M. and Yan, L., 1996a, "Using Multi-valued Valued Logic in Relational Database Containing Null Value", Chinese J. Comput. Sci. & Technol., Vol. 11(4), pp. 421-426.
26. Ma, Z.M. and Yan, L., 1996b, "Introducing One Kind of Mixed-type Incomplete Information into Relational Database", Computer Research and Development, Vol. 33(11), pp. 829~833.
27. Ma, Z. M., Zhang, W. J., Li, Q., 1998, "Fuzzy probabilistic information in relational database", IEEE Trans. Knowledge and Data Engineering (submitted).
28. Maier, D., 1983, "The Theory of Relational Databases", Computer Science Press, USA.
29. Ola, A., 1992, "Relational Database with Exclusive Disjunction", In Proceedings of the 8th International Conference on Data Engineering, pp. 328-336.
30. Prade, H. and Testemale C., 1984, "Generalizing Database Relational Algebra for the Treatment of Incomplete or Uncertain Information and Vague Queries", Inf. Sci.(New York) 34, pp. 115-143.
31. Raju, K.V.S.V.N. and Majumdar, A.K., 1988, "Fuzzy Functional Dependencies and Lossless Join Decomposition of Fuzzy Relational Database Systems", ACM Trans. Database System, Vol. 13(2), pp. 129-166.
32. Rolstadas A., 1995, "Enterprise modeling for competitive manufacturing", Int. J. of Control Eng. Practice, Vol. 3(1), pp. 43-50.
33. Ter Bekke J.H., 1992, "Semantic data modeling in relational environments", Ph.D. Dissertation, TU Delft, The Netherlands.
34. Tseng, F.S.C., Chen, A.L.P. and Yang W.P., 1993, "Answering Heterogeneous Database Queries with Degrees of Uncertainty", Distributed and Parallel Databases: An International Journal, Vol. 1(3), pp. 281-302.
35. Yao, Q.D. and Xiao Y.Q., 1994, "Expressing and Handling the imprecise Information-A Extended Relational Data Model (IRDM)", In Proceeding of the 12th National Databases Conference of China. Wuhan, pp. 14-19.
36. Zadeh, L.A. 1965, "Fuzzy Sets", Information and Control, Vol. 8(3), pp. 338-353.
37. Zemankova, M. and Kandel, A., 1985, "Implementing Imprecision in Information Systems", Inf. Sci.(New York) 37, pp. 107-141.
38. Zhang, W.J., 1994, "An Integrated Environment for CADCAM of Mechanical Systems", PhD thesis, Delft University of Technology, The Netherlands, ISBN 90-370-0113-0, 1-263.
39. Zhang, W.J. and Werff K. van der, 1994, "A critique of conceptual data modeling notions relative to the machine design domain", Proc. of 1994 ASME Engineering Database Symposium'94, Sept. 11-14, Minneapolis, USA, pp. 59-66.
40. Zhang, W. J., Werff van der K. and Crone H.A., 1994, "A step towards intelligent support for mechanism design through a generic mechanism data model", Proc of 1994 Int. Conf. on Data and Knowledge Systems for Manufacturing and Engineering, 2, Hong Kong, pp. 143-151.
41. Zhang, W. J., 1996, "Methodology for Designing a Conceptual Database System to Support Partner Synthesis in Virtual Enterprises", The Proceedings of the 3rd CIRP Workshop on Design and Implementation of Intelligent Manufacturing System (IMS), June 19-21, Tokyo, Japan, pp. 137-144.