The international database community refers to the manipulation of data with inaccuracy and uncertainty using the term fuzzy, which has been translated into Spanish as "borroso" and into French as "flou". Semantically, this term conveys two main ideas: first, the natural concept of ambiguity or vagueness in human reasoning, and second, its connection to fuzzy set theory, fuzzy logic, and possibility theory, as developed by Zadeh between 1965 and 1977. This article explores two key aspects: the attributes of the fuzzy data model GEFRED (GENeralized model for Fuzzy RElational Database) and their implementation in a Relational Database (RDB). The modeling of these attributes was conducted in a Chilian cardboard manufacturing company located in the Maule Region, where the described phenomena involve imprecise and uncertain attributes and values. Specifically, our focus is on the knowledge related to the manufacturing process of coated cardboard, particularly the quality control process for finished products in the company's Conversion Department. The quality of these products, categorized as either stacks or rolls, is characterized using both classical and fuzzy attributes. Classical attributes are typically measured with physical instruments, whereas fuzzy attributes are assessed through human senses, primarily sight and touch, as perceived by the operators.
翻译:国际数据库界将处理不精确和不确定数据的技术称为"模糊"(fuzzy),该术语在西班牙语中译为"borroso",在法语中译为"flou"。从语义上看,这一术语传达两个核心概念:一是人类推理中固有的模糊性或不确定性,二是其与扎德在1965至1977年间发展的模糊集合论、模糊逻辑及可能性理论的关联。本文重点探讨两个关键方面:模糊数据模型GEFRED(广义模糊关系数据库模型)的属性特征及其在关系数据库中的实现。这些属性的建模工作是在位于马乌莱地区的一家智利纸板制造企业完成的,该企业生产过程中涉及的属性和数值具有不精确与不确定特性。具体而言,我们聚焦于涂布纸板制造过程的相关知识,特别是企业转化车间成品质量控制流程。这些以垛或卷形式分类的产品质量,通过经典属性和模糊属性共同表征。经典属性通常通过物理仪器测量,而模糊属性则依赖操作人员通过视觉和触觉等感官进行主观评估。