{"entities":{"Q1114452":{"pageid":1125201,"ns":120,"title":"Item:Q1114452","lastrevid":66157848,"modified":"2026-04-12T07:56:26Z","type":"item","id":"Q1114452","labels":{"en":{"language":"en","value":"Fuzzy querying with SQL: Extensions and implementation aspects"}},"descriptions":{"en":{"language":"en","value":"scientific article; zbMATH DE number 4083042"}},"aliases":{},"claims":{"P31":[{"mainsnak":{"snaktype":"value","property":"P31","hash":"fd5912e4dab4b881a8eb0eb27e7893fef55176ad","datavalue":{"value":{"entity-type":"item","numeric-id":56887,"id":"Q56887"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$DFA3C573-3848-4C4D-8A40-0359EA613B5B","rank":"normal"}],"P159":[{"mainsnak":{"snaktype":"value","property":"P159","hash":"46f32d1a44e8885d84005afd8e53c3ef69cd9f68","datavalue":{"value":{"text":"Fuzzy querying with SQL: Extensions and implementation aspects","language":"en"},"type":"monolingualtext"},"datatype":"monolingualtext"},"type":"statement","id":"Q1114452$F29FCE26-6B3E-454A-893E-7168616A22BE","rank":"normal"}],"P225":[{"mainsnak":{"snaktype":"value","property":"P225","hash":"918755acc9b857bfd95ae3a3f7cd7eefe689e84d","datavalue":{"value":"0662.68114","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1114452$8CDD508A-98A9-42F8-8DD9-9B6D310C3583","rank":"normal"}],"P27":[{"mainsnak":{"snaktype":"value","property":"P27","hash":"581918c23a3cb69e72e245757af1e7fe83c538ad","datavalue":{"value":"10.1016/0165-0114(88)90039-5","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1114452$AF0AE259-59A7-4D23-A729-23F102F64FA1","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"aedf720352fcca932fab3523c4bbcafd7c4c7cdb","datavalue":{"value":{"entity-type":"item","numeric-id":1104176,"id":"Q1104176"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$BDB3A7D6-751A-41E1-AB31-9343522E48E8","rank":"normal"}],"P200":[{"mainsnak":{"snaktype":"value","property":"P200","hash":"784d2dc06e2a3bb008e6a3a15801a0f0231d6262","datavalue":{"value":{"entity-type":"item","numeric-id":65161,"id":"Q65161"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$DA3F3647-EDD0-4739-91CD-25A6227E029A","rank":"normal"}],"P28":[{"mainsnak":{"snaktype":"value","property":"P28","hash":"31a1937240ca4a323604b4728c31d242b5596d7c","datavalue":{"value":{"time":"+1988-00-00T00:00:00Z","timezone":0,"before":0,"after":0,"precision":9,"calendarmodel":"http://www.wikidata.org/entity/Q1985727"},"type":"time"},"datatype":"time"},"type":"statement","id":"Q1114452$C40FDC1B-A924-4B0B-98A4-494699488BD0","rank":"normal"}],"P1448":[{"mainsnak":{"snaktype":"value","property":"P1448","hash":"f37663b4dd2c8049f2052046fa72d719c94b7106","datavalue":{"value":"All the database management systems (DBMS) commercially available provide querying capabilities that are based on Boolean selection. Consequently, it is possible to express conditions applying to individual tuples or sets of tuples. However, this characteristic turns out to be a severe limitation when some types of applications are under consideration. Especially, we have been led to deal with an application, called HAVANE, that gave rise to two main constraints: the number of answers has to be controlled and some parts of queries are not Boolean conditions. So, we turn towards an extension of DBMS querying capabilities in order to allow fuzzy queries against a usual database, i.e., composed of precise facts. Thus an extension of the well known language SQL is presented along with some considerations about how such fuzzy queries can be processed to get acceptable performances.","type":"string"},"datatype":"string"},"type":"statement","id":"Q1114452$1886FC33-51B7-4A2B-B392-5E1899E008C9","rank":"normal"}],"P226":[{"mainsnak":{"snaktype":"value","property":"P226","hash":"a762d1a2468ec8882180d0d1124f12b94f8eb1b0","datavalue":{"value":"68P20","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1114452$9D1F370B-7B9D-4FA1-A424-716E603A99CF","rank":"normal"}],"P1451":[{"mainsnak":{"snaktype":"value","property":"P1451","hash":"d8ec596d5f67c21516595008a0e978e68fea7e07","datavalue":{"value":"4083042","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1114452$7FFDE172-171E-4ADC-9008-A43E0074A3A2","rank":"normal"}],"P1450":[{"mainsnak":{"snaktype":"value","property":"P1450","hash":"74473800caa00ca2354e3822045142f9adaae316","datavalue":{"value":"relational database","type":"string"},"datatype":"string"},"type":"statement","id":"Q1114452$A30B7F54-9796-44D1-A4B9-204232809783","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"157ad860b668c5e46f54e1ac614d201ec8b37af1","datavalue":{"value":"non-Boolean queries","type":"string"},"datatype":"string"},"type":"statement","id":"Q1114452$C8874C61-AB91-415A-B263-4E8C36301BF1","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"05daa97dbaec71e9df9bc9403359433cb3b918cc","datavalue":{"value":"fuzzy conditions","type":"string"},"datatype":"string"},"type":"statement","id":"Q1114452$220E55CC-49E9-4DB1-8DC0-D7E7B4268C35","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"c6e10caa61cf7fa5230fcc3983ef5dbf2c2aefe9","datavalue":{"value":"SQL query language","type":"string"},"datatype":"string"},"type":"statement","id":"Q1114452$6A3376A1-C017-4B88-918D-41AB77115150","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"867a4785f0e748ba3df6e75deeef9adf1e4ec040","datavalue":{"value":"query processing","type":"string"},"datatype":"string"},"type":"statement","id":"Q1114452$64E75C74-92B5-4224-A331-B46054271CB7","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"a3d1ede154af145f32d96fd914e8671c42a5ea8e","datavalue":{"value":"indexing","type":"string"},"datatype":"string"},"type":"statement","id":"Q1114452$1BE35827-1BFB-4012-86BC-18B8A2B83287","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"394106f82689002c52edbcd8a72545e6a2a2bce6","datavalue":{"value":"filtering mechanisms","type":"string"},"datatype":"string"},"type":"statement","id":"Q1114452$FDAF3535-4E55-4EEE-823F-4DC3A602816E","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"270f8db5ec321547abe3d37398fd050ba8783d75","datavalue":{"value":"fuzzy queries","type":"string"},"datatype":"string"},"type":"statement","id":"Q1114452$FB471E9F-63A9-4367-96CF-1880EABDFA88","rank":"normal"}],"P1460":[{"mainsnak":{"snaktype":"value","property":"P1460","hash":"57f7fea50d2ce1b39b695c4a1313582eed405e38","datavalue":{"value":{"entity-type":"item","numeric-id":5976449,"id":"Q5976449"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$9890FA09-DBBC-4D14-87FD-097C213AAB78","rank":"normal"}],"P205":[{"mainsnak":{"snaktype":"value","property":"P205","hash":"3a65db7a92261ff714783fbcf58669f854ec2639","datavalue":{"value":"https://doi.org/10.1016/0165-0114(88)90039-5","type":"string"},"datatype":"url"},"type":"statement","id":"Q1114452$73B1A784-238E-49FA-8728-9491F20185B8","rank":"normal"}],"P388":[{"mainsnak":{"snaktype":"value","property":"P388","hash":"9c98554c8906f4eeba725ec4bfff9dcd006ed6b1","datavalue":{"value":"W2101204711","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1114452$9E61A787-2856-4B11-A172-6C07BBDC4795","rank":"normal"}],"P223":[{"mainsnak":{"snaktype":"value","property":"P223","hash":"094fc2823056ff356592477a14deab5722c21f28","datavalue":{"value":{"entity-type":"item","numeric-id":3678703,"id":"Q3678703"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$E5E14BDC-425C-4BA5-AC27-3FD66DD7074F","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"4e6697d859d020f580e824367dc5c122959911d3","datavalue":{"value":{"entity-type":"item","numeric-id":4111077,"id":"Q4111077"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$C864F9D4-A6A9-44AA-9ACD-A3CCA713BFA3","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"6b00c51201f67e59e740260c694a944ba5779880","datavalue":{"value":{"entity-type":"item","numeric-id":5607609,"id":"Q5607609"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$F70ACBCB-7155-4315-BA37-70FD050F648A","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"ff81489e80366438468bf6dfe10c7a159bc3ea8c","datavalue":{"value":{"entity-type":"item","numeric-id":4057549,"id":"Q4057549"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$9C21CE5C-8FB5-41A9-B1B1-3BE64D0F8E9F","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"1adb9b8cb046f54bbbd361517a79c3c1b644ad05","datavalue":{"value":{"entity-type":"item","numeric-id":3731049,"id":"Q3731049"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$41DA8AF1-E2A1-4927-A259-A854F970EA8F","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"d3c2b433a996ab28c48cba2a1065aba150b08a54","datavalue":{"value":{"entity-type":"item","numeric-id":801697,"id":"Q801697"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$D9708890-44C5-413A-81DF-C827A5671898","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"9c312ae0e4b3d4af87ac0fde7b28851407e1d0ad","datavalue":{"value":{"entity-type":"item","numeric-id":1239615,"id":"Q1239615"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$16A079D1-1BDD-43C2-9F04-ACACC57DC900","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"9b61a2a8de7d4f043c62eff17893dd9df5711b3b","datavalue":{"value":{"entity-type":"item","numeric-id":3347337,"id":"Q3347337"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$D16E9D62-79B8-4BA5-9721-5B320646F36E","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"76e69ce7e7df50206769f5d11e1d20775dd96cad","datavalue":{"value":{"entity-type":"item","numeric-id":1246531,"id":"Q1246531"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$FB2945B3-6889-4FBE-A797-7BDDD01A306F","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P223","hash":"6a5afc2a46eb9c5c1020f6b6ae09aa846933e212","datavalue":{"value":{"entity-type":"item","numeric-id":3683559,"id":"Q3683559"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1114452$BA8D6DD0-EC15-4D90-9530-C0BCC761D7D7","rank":"normal"}],"P1643":[{"mainsnak":{"snaktype":"value","property":"P1643","hash":"9f706732b8eeea7620ed69142e8262ad1270326e","datavalue":{"value":{"entity-type":"item","numeric-id":2853255,"id":"Q2853255"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"46b2d3428e45d8dd123091dada4241ee9f8adcc2","datavalue":{"value":{"amount":"+0.8346495628356934","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"a327a09ea0305e98d5cf33bd4036320e19f2aed0","datavalue":{"value":{"entity-type":"item","numeric-id":6821328,"id":"Q6821328"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q1114452$7F1F4A32-19DD-4F5A-B1D7-FC254A32DE56","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"33c927063848f1cc0ade4b8127b28cd79d9d9605","datavalue":{"value":{"entity-type":"item","numeric-id":3105860,"id":"Q3105860"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"f321de2b88d04ad076c1cb6a7fabe21abe767b3b","datavalue":{"value":{"amount":"+0.8282700777053833","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"a327a09ea0305e98d5cf33bd4036320e19f2aed0","datavalue":{"value":{"entity-type":"item","numeric-id":6821328,"id":"Q6821328"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q1114452$8D1A0663-D5EF-41A8-A256-1CA17C72CAC4","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"2b24e1d61d7695dc3efc7fa4ec80de42d67794cd","datavalue":{"value":{"entity-type":"item","numeric-id":3466290,"id":"Q3466290"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"f267f30087fcadbd5635b76667adb7ce180d4963","datavalue":{"value":{"amount":"+0.8254272937774658","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"a327a09ea0305e98d5cf33bd4036320e19f2aed0","datavalue":{"value":{"entity-type":"item","numeric-id":6821328,"id":"Q6821328"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q1114452$927936BF-118D-4568-B9F9-272AD9F4520D","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"be5ee8f2e628edc79fc9f2d422b2843cfe42a08a","datavalue":{"value":{"entity-type":"item","numeric-id":4373459,"id":"Q4373459"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"3acdfb81fdaa1a171faa706091d8ae0de59490b9","datavalue":{"value":{"amount":"+0.8250881433486938","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"a327a09ea0305e98d5cf33bd4036320e19f2aed0","datavalue":{"value":{"entity-type":"item","numeric-id":6821328,"id":"Q6821328"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q1114452$080F3DF8-9482-4228-AB0C-6ADC23754049","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"4faa2e441955860e24307f6a265f483288868c76","datavalue":{"value":{"entity-type":"item","numeric-id":4494049,"id":"Q4494049"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"e8b7db906b6d677833cf2817f5ba8e09e5c02c0c","datavalue":{"value":{"amount":"+0.8152286410331726","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"a327a09ea0305e98d5cf33bd4036320e19f2aed0","datavalue":{"value":{"entity-type":"item","numeric-id":6821328,"id":"Q6821328"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q1114452$A107971A-C967-4955-A6CB-17F52E921D3F","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"Fuzzy querying with SQL: Extensions and implementation aspects","badges":[],"url":"https://portal.mardi4nfdi.de/wiki/Fuzzy_querying_with_SQL:_Extensions_and_implementation_aspects"}}}}}