Skip to main content
SpringerLink
Log in

Database Integrations in Distributed Enterprise Information Systems: A Database Model with Imprecise Information and Query Processing

  • Chapter
Flexible Databases Supporting Imprecision and Uncertainty

Part of the book series: Studies in Fuzziness and Soft Computing ((STUDFUZZ,volume 203))

  • 294 Accesses

Abstract

To increase product competitiveness, today’s manufacturing enterprises have to deliver their products at reduced cost and high quality in a short time. The change from sellers’ market to buyers’ market results in a steady decrease in the product life cycle time and the demands for tailor made and small-batch products. All these changes require that manufacturing enterprises quickly respond to market changes. Traditional production patterns and manufacturing technologies may find it difficult to satisfy the requirements of current product development. Many types of advanced manufacturing techniques, such as Computer Integrated Manufacturing, Agile Manufacturing, Concurrent Engineering, and Virtual Enterprise based on global manufacturing have been proposed to meet these requirements. One of the foundational supporting strategies is the computer-based information technology. Information systems have become the nerve center of current manufacturing systems. It should be noted that, for various organizational and technological reasons, multiple information systems used in information-based manufacturing enterprises are independently developed, locally administered, and different in logical or physical design [10, 24]. Therefore, a fundamental challenge in heterogeneous and distributed enterprise information management is the sharing of information for enterprise users across organizational boundaries [20].

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 129.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 169.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Altareva, E. and Conrad, S., 2001, The Problem of Uncertainty and Database Integration, Proc. of the 4th International Workshop on Engineering Federated Information Systems, 92–99.

    Google Scholar 

  2. Batini, C., Lenzerini, M. and Navathe, S. B., 1986, A Comparative Analysis of Methodologies for Database Schema Integration, ACM Computing Surveys, 18 (4), 323–364.

    Article  Google Scholar 

  3. Bergamaschi, S., Castano, S., Vincini, M. and Beneventano, D., 2001, Semantic integration of heterogeneous information sources, Data & Knowledge Engineering, 36 (3), 215–249.

    Article  MATH  Google Scholar 

  4. Bourett, R., 2001, XML and Databases, http://www.rpbourret.com/xml/ XMLAndDatabases. htm

    Google Scholar 

  5. Bukhres, O. A. and Elmagarmid, A. K., 1996, Object-Oriented Multidatabase Systems: A Solution for Advanced Applications, Prentice-Hall 1996.

    Google Scholar 

  6. Candan, K. S., Grant, J. and Subrahmanian, V. S., 1997, A Unified Treatment of Null Values Using Constraints, Information Sciences, 98 (1–4), 99–156.

    Article  Google Scholar 

  7. Chen, G. Q., Vandenbulcke, J. and Kerre, E. E., 1992, A General Treatment of Data Redundancy in a Fuzzy Relational Data Model, JASIS, 43 (4), 304–311.

    Article  Google Scholar 

  8. Chen, S. M. and Lee, S. W., 2003, A New Method to Generate Fuzzy Rules From Relational Database Systems for Estimating Null Values, Cybernetics and Systems: An International Journal, 34 (1), 33–57.

    Article  MATH  Google Scholar 

  9. Chen, S. M. and Yeh, M. S., 1997, Generating Fuzzy Rules From Relational Database Systems for Estimating Null Values, Cybernetics and Systems: An International Journal, 28 (8), 695–723.

    Article  MATH  Google Scholar 

  10. Cheung, W. M. and Hsu, C., 1996, The Model-Assisted Global Query System for Multiple Databases in Distributed Enterprises, ACM Trans. on Information Systems, 14 (4), 421–470.

    Article  Google Scholar 

  11. Codd, E. F., 1987, More Commentary on Missing Information in Relational Databases (Applicable and Inapplicable Information), SIGMOD Record, 16 (1), 42–50.

    Article  Google Scholar 

  12. DeMichiel, L. G., 1989, Resolving Database Incompatibility: An Approach to Performing Relational Operations over Mismatched Domains, IEEE Trans. on Knowledge and Data Engineering, 1 (4), 485–493.

    Article  Google Scholar 

  13. Dutta, S., 1991, Approximate Reasoning by Analogy to Null Queries, International Journal of Approximate Reasoning, 5, 373–398.

    Article  MATH  MathSciNet  Google Scholar 

  14. Elmagarmid, A. K., Rusinkiewicz, M. and Sheth, A., 1998, Management of Heterogeneous and Autonomous Database Systems, Morgan Kaufmann Publishers, CA.

    Google Scholar 

  15. Florescu, D., Koller, D. and Levy, A. Y., 1997, Using Probabilistic Information in Data Integration, Proc. of the 23rd International Conference on Very Large Data Bases, 216–225.

    Google Scholar 

  16. Galindo-Legaria, C. A., 1994, Outerjoins as Disjunctions, Proc. of the 1994 ACM SIGMOD International Conference on Management of Data, 348–358.

    Google Scholar 

  17. García-Solaco, M., Saltor, F. and Castellanos, M., 1995, A Structure Based Schema Integration Methodology, Proc. of the Eleventh International Conference on Data Engineering, 505–512.

    Google Scholar 

  18. Giachetti, R. E., 1999, A Standard Manufacturing Information Model to Support Design for Manufacturing in Virtual Enterprises, Journal of Intelligent Manufacturing, 10,49–60.

    Article  Google Scholar 

  19. Grahne, G. and Mendelzon, A. O., 1999, Tableau Techniques for Querying Information Sources Through Global Schemas, Proc. of 7th International Conference on Database Theory, Lecture Notes in Computer Science, 1540, 332–347.

    Google Scholar 

  20. Hardwick, M., Spooner, D. L., Rando, T. and Morris, K. C., 1996, Sharing Manufacturing Information in Virtual Enterprises, Communications of the ACM, 39 (2), 46–54.

    Article  Google Scholar 

  21. Hull, R., 1997, Managing Semantic Heterogeneity in Databases: A Theoretical Perspective, Proc. of the Sixteenth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, 51–61.

    Google Scholar 

  22. Kirk, T., Levy, A. Y., Sagiv, Y. and Srivastava, D., 1995, The Information Manifold, Proc. of the AAAI Spring Symposium on Information Gathering in Distributed Heterogeneous Environments.

    Google Scholar 

  23. Klein, H. J., 1999, Efficient Algorithms for Approximating Answers to Queries Against Incomplete Relational Databases, Proc.of 6th International Workshop on Knowledge Representation meets Databases, 26–30.

    Google Scholar 

  24. Krishnakumar, N. and Sheth, A., 1995, Managing Heterogeneous Multisystem Tasks to Support Enterprise-wide Operations, Distributed and Parallel Databases Journal, 3 (2), 155–186.

    Article  Google Scholar 

  25. Li, Q., Zhang, W. J. and Tso, S. K., 2000, Generalization of Strategies for Product Data Modeling with Special Reference to Instance-As-Type Problem, Computers in Industry, 41 (1), 25–34.

    Article  Google Scholar 

  26. Liao, S. Y., Wang, H. Q. and Liu, W. Y., 1999, Functional Dependencies with Null Values, Fuzzy Values, and Crisp Values, IEEE Trans, on Fuzzy Systems, 7 (1), 97–103.

    Article  Google Scholar 

  27. Lim, E. P., Srivastava, J. and Shekhar, S., 1994, Resolving Attribute Incompatibility in Database Integration: An Evidential Reasoning Approach, Proc. of the Tenth International Conference on Data Engineering, 154–163.

    Google Scholar 

  28. Lipski, W., 1979, On Semantic Issues Connected with Incomplete Information Databases, ACM Trans.s on Database Systems, 4 (3), 262–296.

    Article  Google Scholar 

  29. Litwin, W., Mark, L. and Roussopoulos, N., 1990, Interoperability of Multiple Autonomous Databases, ACM Computing Surveys, 22(3), 267–293.

    Article  Google Scholar 

  30. Ma, Z. M., Zhang, W. J. and Ma, W. Y., 2000, Semantic Measure of Fuzzy Data in Extended Possibility-Based Fuzzy Relational Databases, International Journal of Intelligent Systems, 15 (8), 705–716.

    Article  MATH  MathSciNet  Google Scholar 

  31. Mena, E., Kashyap, V., Illarramendi, A. and Sheth A., 2000, Imprecise Answers in Distributed Environments: Estimation of Information Loss for Multi-Ontology Based Query Processing, International Journal of Cooperative Information Systems, 9 (4), 403–425.

    Article  Google Scholar 

  32. Mendelzon, A. O. and Mihaila, G. A., 2001, Querying Partially Sound and Complete Data Sources, Proc. of the Fifteenth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, 162–170.

    Google Scholar 

  33. Morrissey, J. M., 1990, Imprecise Information and Uncertainty in Information Systems, ACM Trans. on Information Systems, 8 (2), 157–180.

    Google Scholar 

  34. Parent, C. and Spaccapietra, S., 1998, Issues and Approaches of Database Integration, Communications of the ACM, 41 (5): 166–178.

    Article  Google Scholar 

  35. Reiter, R., 1986, A Sound and Sometimes Complete Query Evaluation Algorithm for Relational Databases with Null Values, Journal of the Association for Computing Machinery, 33 (2), pp. 349–370.

    MathSciNet  Google Scholar 

  36. Rolstadas, A., 1995, Enterprise Modeling for Competitive Manufacturing, International Journal of Control Engineering Practice, 3 (1), 43–50.

    Article  Google Scholar 

  37. Sheth, A. P. and Larson, J. A., 1990, Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases, ACM Computing Surveys, 22 (3), 183–236

    Article  Google Scholar 

  38. Silberschatz, A., Stonebraker, M. and Ullman, J. D., 1991, Database Systems: Achievements and Opportunities, Communications of the ACM, 34(10): 110–120.

    Article  Google Scholar 

  39. Tatarinov, I., Viglas, S., Beyer, K. S., Shanmugasundaram, J., Shekita, E. J. and Zhang, C., 2002, Storing and Querying Ordered XML Using a Relational Database System, Proc. of the 2002 ACM SIGMOD International Conference on Management of Data, 204–215.

    Google Scholar 

  40. 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, 1 (3), 281–302.

    Article  Google Scholar 

  41. Yuan, L. Y. and Chiang, D. A., 1989, A Sound and Complete Query Evaluation Algorithm for Relational Databases with Disjunctive Information, Proc. of the 14 th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, 66–74.

    Google Scholar 

  42. Zaniolo, C., Faloutsos, S. and Subrahmanian, Z., 1997, Advanced Database Systems, Morgan Kaufmann Publishers.

    Google Scholar 

  43. Zhang, W. J. and Li, Q., 1999, Information Modeling for Made-to-Order Virtual Enterprise Manufacturing Systems,Computer Aided Design, 31 (10), 611–619.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Northeastern University, Shenyang, Liaoning, 110004, China

    Li Yan

Authors
  1. Li Yan
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. CNR IDPA, National Research Council of Italy Institute for the Study of Environmental Process Dynamics, via Pasubio 5, Dalmine, BG, I-24044, Italy

    Gloria Bordogna Dr.

  2. Faculty of Engineering, University of Bergamo, viale Marconi 5, Dalmine, BG, I-240044, Italy

    Giuseppe Psaila Professor

Rights and permissions

Reprints and permissions

Copyright information

© 2006 Springer

About this chapter

Cite this chapter

Yan, L. (2006). Database Integrations in Distributed Enterprise Information Systems: A Database Model with Imprecise Information and Query Processing. In: Bordogna, G., Psaila, G. (eds) Flexible Databases Supporting Imprecision and Uncertainty. Studies in Fuzziness and Soft Computing, vol 203. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-33289-8_7

Download citation

  • DOI: https://doi.org/10.1007/3-540-33289-8_7

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-33288-6

  • Online ISBN: 978-3-540-33289-3

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation