Skip to main content
Fachgebiete
Automobil + Motoren Bauwesen + Immobilien Business IT + Informatik Elektrotechnik + Elektronik Energie + Nachhaltigkeit Finance + Banking Management + Führung Marketing + Vertrieb Maschinenbau + Werkstoffe Versicherung + Risiko
DE
EN
Bücher
Zeitschriften
Themenseiten
Organisationspsychologie Projektmanagement Marketing Smart Manufacturing
Weitere Formate
Podcasts Webinare Technik Webinare Wirtschaft Kongresse Veranstaltungskalender Awards
Jetzt Einzelzugang starten
Zugang für Unternehmen
Referenzkunden
SLX-Digitalkonferenz: Zukunftswerkstatt 2024

Mehr Umsatz mit Top-Kontakten

Am 7. Mai erfahren Sie, wie Vertriebsteams Leadgenerierung, Leadnurturing und Leadstrategien effizient steuern können.
Erweiterte Suche
Anmelden
nach oben
Erschienen in:
Fuzzy Set and Fuzzy Logic Theory in Brief Kapitel lesen Erstes Kapitel lesen

2016 | OriginalPaper | Buchkapitel

5. Fuzzy Data in Relational Databases

verfasst von : Miroslav Hudec

Erschienen in: Fuzziness in Information Systems

Verlag: Springer International Publishing

Einloggen

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

Abstract

Many agree that relational databases, like any other model of the real world, are imperfect artefacts. Hence, they cannot cover all occurrences and variety of data, in our case fuzzy data. Fuzzy values of attributes cannot be directly stored in traditional relational databases due to the first normal form. On the other hand, relational databases are broadly used. We firstly examine the way, how to store fuzzy data in traditional relational databases by satisfying normal forms in order to keep the integrity of a database in an usual way. Databases which are in use should be straightforwardly converted into fuzzy relational databases, when users decide that some attributes are better expressed by fuzzy data than by crisp values. Moreover, attributes which remain crisp, should not be affected. This improvement can be realized by fuzzy meta model of relational database. The second part of the chapter is focused on querying and summarizing fuzzy databases.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Jetzt informieren

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Jetzt informieren

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Jetzt informieren
Vorheriges Kapitel Fuzzy Inference
Nächstes Kapitel Perspectives, Synergies and Conclusion
Literatur
1.
Altin, L., Tiru, M., Saluveer, E., Puura, A.:Using passive mobile positioning data in tourism and population statistics. In: New Techniques and Technologies for Statistics (NTTS 2015), Brussels (2015)
2.
Aguilera, A., Mata-Toledo, R., Subero, A., Monger, M., Gupta, P.: On an extension of fuzzy aggregate functions for databases. J. Inf. Syst. Oper. Manage. 7, 1–8 (2013)
3.
Balbi, S., Triunfo, N.: Statistical tools in the joint analysis of closed and open-ended questions. In: Davino, C., Fabbris, L. (eds.) Survey Data Collection and Integration, pp. 61–72. Springer, Berlin Heidelberg (2012)
4.
Bojadziev, G., Bojadziev, M.: Fuzzy logic for business, finance and management, 2nd edn. World Scientific Publishing Co., Ltd., London (2007)
5.
Borkowski, L. (ed.), Lukasiewicz, J.: Selected Works. North-Holland Publishing Company, Amsterdam and Warsaw (1970)
6.
Buckles, B.P., Petry, F.E.: Extending the fuzzy database with fuzzy numbers. Inf. Sci. 34, 45–55 (1984)
7.
Buckles, B.P., Petry, F.E.: Fuzzy databases and their applications. In: Gupta, M., Sanchez, E. (eds.) Fuzzy Information and Decision Processes, vol. 2, pp. 361–371. North-Holland, New York (1982)
8.
de Caluwe, R., de Tré G. (eds.): Special issue on advances in fuzzy database technology. Int. J. Intell. Syst. 22 (2007)
9.
Chen, G.Q., Kerre, E.E., Vandenbulcke, J.: Normalization based on functional dependency in a fuzzy relational data model. Inf. Syst. 21, 299–310 (1996)
10.
Chen, P.P-S.: The entity-relationship model—towards a unified view of data. ACM Trans. Database Syst. 1, 9–36 (1976)
11.
Codd, E.F.: Missing information (applicable and inapplicable) in relational databases. ACM SIGMOD Rec. 15(4) (1986)
12.
Codd, E.F.: Extending the database relational model to capture more meaning. ACM Trans. Database Syst. 4, 397–434 (1979)
13.
Date, C.J.: Date on Databases: Writings 2000–2006. Apress, New York (2006)
14.
Galindo, J., Medina, J.M., Aranda-Garrido, M.C.: Fuzzy division in fuzzy relational databases: an approach. Fuzzy Sets Syst. 121, 471–490 (2001)
15.
Galindo, J., Medina, J.M., Pons, O., Cubero, J.C.: A server for fuzzy SQL Queries. In: Andreasen, T., Christiansen, H., Larsen, H.L. (eds.) Flexible Query Answering Systems, vol. 1495, pp. 164–174. Springer, Heidelberg (1998)
16.
Galindo, J., Urrutia, A., Piattini, M.: Fuzzy Databases—Modeling. Design and Implementation. Idea Group Publishing, Hershey (2006)
17.
Hudec, M.: Storing and analysing fuzzy data from surveys by relational databases and fuzzy logic approaches. In: XXVth IEEE International Conference on Information, Communication and Automation Technologies (ICIT2015), pp. 220–225. Sarajevo (2015)
18.
Hudec, M., Praženka, D.: Collecting, storing and managing fuzzy data in statistical relational databases. Stat. J. IAOS, 32(2), 245–255 (2016)
19.
Hudec, M.: Fuzzy data in traditional relational databases. In: 12th Symposium on Neural Network Applications in Electrical Engineering, pp. 195–200. Belgrade (2014)
20.
Kunii, T.L.: Data plan: an interface generator for database semantics. Inf. Sci. 10, 279–298 (1976)
21.
Likert, R.: A technique for te measurement of attitudes. Arch. Psychol. 22(140), 1–55 (1932)
22.
Li, Q.: A novel Likert scale based on fuzzy set theory. Expert Syst. Appl. 40, 1609–1618 (2013)
23.
Ma, Y., van Dalen, J., De Blois, C., Kroon, L.G.: Estimation of dynamic traffic densities for official statistics. J. Transport. Res. Board 2256, 104–111 (2011)
24.
Ma, Z.M., Yan, L.: A literature overview of fuzzy database models. J. Inf. Sci. Eng. 24, 189–202 (2008)
25.
Majumdar, A.K., Raju, K.N.: GEFRED: fuzzy functional dependencies and lossless join decomposition of fuzzy relational database system. ACM Trans. Database Syst. 13, 129–166 (1993)
26.
Medina, J.M.: Pons., O., Villa, M.A.: GEFRED: a generalized model of fuzzy relational databases. J. Inf. Sci. Eng. 76(1–2), 87–109 (1994)
27.
Pavese, F.: Why should correction values be better known than the measurand true value. J. Phys. Conf. Series 459 (2013)
28.
Perović, A., Takači, A., Škrbić, S.: Formalising PFSQL queries using LP1/2 fuzzy logic. Math. Struct. Comput. Sci. 22, 533–547 (2012)
29.
Perović, A., Takači, A., Škrbić, S.: Towards the formalization of fuzzy relational database queries. Acta Polytechnica Hung. 6, 185–193 (2009)
30.
Petry, F.E.: Fuzzy Databases—Principles and Applications. Kluwer, Boston (1996)MATH
31.
Prade, H., Testemale, C.: Representation of soft constraints and fuzzy attribute values by means of possibility distributions in databases. In: Bezdek, J. (ed.) Analysis of Fuzzy Information (Vol, II): Artificial Intelligence and Decision Systems, pp. 213–229. CRC Press (1987)
32.
Puts, M., Daas, P., Tennekes, M.: High frequency road sensor data for official statisitics. In: New Techniques and Technologies for Statistics (NTTS 2015), Brussels (2015)
33.
Shenoi, S., Melton, A.: Functional dependencies and normal forms in the fuzzy relational database model. Inf. Sci. 60, 1–28 (1992)
34.
Škrbić, S.: Using fuzzy logic in relational databases. Ph.D. Dissertation. University of Novi Sad, Novi Sad (2008)
35.
Škrbić, S., Racković, M.: PFSQL: a fuzzy SQL language with priorities. In: 4th International Conference on Engineering Technologies, pp. 58–63, Novi Sad (2009)
36.
Škrbić, S., Racković, M., Takači, A.: Towards the methodology for development of fuzzy relational database applications. Comp. Sci. Inf. Syst. 8, 27–40 (2011)
37.
Sözat, M.I., Yazici, A.: A complete axiomatization for fuzzy functional and multivalued dependencies in fuzzy database relations. Fuzzy Sets Syst. 117, 161–181 (2001)MathSciNetCrossRefMATH
38.
Takači, A., Škrbić, S.: Data model of FRDB with different data types and PFSQL. In: Galindo, J. (ed.) Handbook of Research on Fuzzy Information Processing in Databases, pp. 407–434. Information Science Reference, Hershey (2008)CrossRef
39.
Torres van Grinsven, V., Snijkers, G.: Sentiments and perceptions of business respondents on social media: an exploratory analysis. J. Official Stat. 31, 283–304 (2015)
40.
Umano, M., Fukami, S.: Fuzzy relational algebra for possibility-distribution-fuzzy-relation model of fuzzy data. J. Intell. Inf. Syst. 3, 7–27 (1994)
41.
Urrutia, A., Tineo, L., Gonzales, C.: FSQL and SQLf: Towards a standard in fuzzy databases. In: Galindo, J. (ed.) Handbook of Research on Fuzzy Information Processing in Databases, pp. 270–298. Information Science Reference, Hershey (2008)CrossRef
42.
Viertl, R.: Fuzzy data and information systems. In: 15th International WSEAS Conference on Systems, pp. 83–85, Corfu (2011)
43.
Vucetic, M., Hudec, M., Vujošević, M.: A new method for computing fuzzy functional dependencies in relational database systems. Expert Syst. Appl. 40, 2738–2745 (2013)
44.
Yang, M.F., Chou, Y.T., Lo, M.C., Tseng, W.C.: Fuzzy time distribution in PERT model. In: International Multiconference of Engineers and Computer Scientists (IMECS 2014), pp. 1084–1087, Hong Kong (2014)
45.
Zadeh, L.A.: Fuzzy sets as a basis for a theory of possibility. Fuzzy Sets Syst. 1, 3–28 (1978)
46.
Zadeh, L.A.: Similarity relations and fuzzy ordering. Inf. Sci. 3, 177–200 (1971)
47.
Zemankova-Leech, M., Kandel, A.: Implementing imprecision in information systems. Inf. Sci. 37(1–3), 107–141 (1985)
Metadaten
Titel
Fuzzy Data in Relational Databases
verfasst von
Miroslav Hudec
Copyright-Jahr
2016
Buch
Fuzziness in Information Systems

Print ISBN: 978-3-319-42516-0

Electronic ISBN: 978-3-319-42518-4

Copyright-Jahr: 2016

DOI
https://doi.org/10.1007/978-3-319-42518-4_5