{"entities":{"Q2740461":{"pageid":2751200,"ns":120,"title":"Item:Q2740461","lastrevid":82912295,"modified":"2026-05-06T22:24:02Z","type":"item","id":"Q2740461","labels":{"en":{"language":"en","value":"Data mining and statistical analysis using SQL"}},"descriptions":{"en":{"language":"en","value":"scientific article; zbMATH DE number 1646765"}},"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":"Q2740461$B7A8189D-1F8B-426C-BF80-0FAE3CF63147","rank":"normal"}],"P225":[{"mainsnak":{"snaktype":"value","property":"P225","hash":"28498e6faebb3497c2d0c07d1f81ab2c181edf7a","datavalue":{"value":"0985.68018","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q2740461$73EDFED8-0A6C-4960-A992-71718E3F559C","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"3aa2bf2c329f8d3d4b801109bce7753a69be5d64","datavalue":{"value":{"entity-type":"item","numeric-id":1321804,"id":"Q1321804"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q2740461$E4F9FAFD-ADF1-479B-9A1F-D2E1DDBF2CE1","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P16","hash":"66fb046565ba382e680a6e83a425b4841248bf97","datavalue":{"value":{"entity-type":"item","numeric-id":2740460,"id":"Q2740460"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q2740461$0EBA4F78-6A72-484D-AA5B-9A5E0D14E8D9","rank":"normal"}],"P28":[{"mainsnak":{"snaktype":"value","property":"P28","hash":"81f8906f510a1a7a3f5462e696b50f1cf7c22137","datavalue":{"value":{"time":"+2001-09-16T00:00:00Z","timezone":0,"before":0,"after":0,"precision":11,"calendarmodel":"http://www.wikidata.org/entity/Q1985727"},"type":"time"},"datatype":"time"},"type":"statement","id":"Q2740461$816856D4-784E-4CA1-B616-66E1B284CB83","rank":"normal"}],"P226":[{"mainsnak":{"snaktype":"value","property":"P226","hash":"bf2726c5c2109371cc10358eaa69bc4df711caf7","datavalue":{"value":"68P15","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q2740461$2EC6229F-08A1-4924-9171-006828814102","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P226","hash":"a50ad10d859c37581a66df0bd2c759d3d47ad6a4","datavalue":{"value":"68U35","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q2740461$9EF5A159-8B18-4C94-9D2D-5629BE87C7EB","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P226","hash":"efc18770377997605fa0afd0c8c5849057981bb8","datavalue":{"value":"68P99","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q2740461$2C6B8459-3147-4980-BC1B-18EE5D73FFF7","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P226","hash":"e53f88ab24e1da510f2fd88cf614c6c4cc09d513","datavalue":{"value":"62-07","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q2740461$EAEC41A8-EF13-4762-813B-F3B139FD35E7","rank":"normal"}],"P1451":[{"mainsnak":{"snaktype":"value","property":"P1451","hash":"f5e096e13f508950660e4352339f6a70dc1e40aa","datavalue":{"value":"1646765","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q2740461$493647FB-27B4-4E05-B03E-8A35A228023B","rank":"normal"}],"P1450":[{"mainsnak":{"snaktype":"value","property":"P1450","hash":"9967a0b50804407b20f63da0231cb5fcf3f7a4e1","datavalue":{"value":"SQL","type":"string"},"datatype":"string"},"type":"statement","id":"Q2740461$702C71E7-054B-4F91-8777-6F71FB021C53","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"ecbedf45a7c783b1e7b0538cb87d3d3c2b5725d0","datavalue":{"value":"data mining","type":"string"},"datatype":"string"},"type":"statement","id":"Q2740461$E0CFFBBE-4157-4DCA-BD4F-33DA8BCF2FB6","rank":"normal"}],"P1463":[{"mainsnak":{"snaktype":"value","property":"P1463","hash":"2caf5d4f19b92475d701831970f41c4fa80b97de","datavalue":{"value":{"entity-type":"item","numeric-id":16058,"id":"Q16058"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q2740461$326212ED-8066-4315-B66C-1E10FF697BB3","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1463","hash":"fa84fd84e2bc1845b62bcc119bec989a70fdd222","datavalue":{"value":{"entity-type":"item","numeric-id":16049,"id":"Q16049"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q2740461$0515E75F-0D11-42E0-A2FE-4090976DB42E","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1463","hash":"f8a5d83b41965fd53bd48af4d5c7f8c836696499","datavalue":{"value":{"entity-type":"item","numeric-id":27720,"id":"Q27720"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q2740461$8C7B4F44-016E-4504-B3D8-F93A2FCC0879","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":"Q2740461$C8B60FAB-13DB-4C10-8708-34A77C8B800D","rank":"normal"}],"P159":[{"mainsnak":{"snaktype":"value","property":"P159","hash":"21ec74fd20a815a567f50a59125868c2764509e4","datavalue":{"value":{"text":"Data mining and statistical analysis using SQL","language":"en"},"type":"monolingualtext"},"datatype":"monolingualtext"},"type":"statement","id":"Q2740461$D49A53C5-F292-426C-8E1C-6ACE5E1FEA05","rank":"normal"}],"P1448":[{"mainsnak":{"snaktype":"value","property":"P1448","hash":"2cdc9c45d4337b26c849af2e70d6c46a06113b14","datavalue":{"value":"The purpose of the book is to present to anyone who must extract information from the collected data the ways in which statistical techniques and SQL can be employed to answer useful questions. Individual chapters cover basic principles and diagnostic tree, measures of central tendency and dispersion, goodness of fit, tests of hypotheses, curve fitting, control charts, analysis of experimental designs and time series analysis. The book contains SQL statements in Microsoft Access 2000 and Transaction SQL for Microsoft SQL Server 2000, and is accompanied by a download from the web site \\url{http://www.apress.com} containing the databases, SQL statements and routines used in all the examples, and all the corresponding statistical tables. Knowledge of SQL isn't required to understand the statistics and/or follow the examples. However, since SQL is very popular and easy to read, the reader will find the SQL statements a bonus for his/her work. Professionals who may possess minimal statistical knowledge but are looking for a specific ``how to'' information on accomplishing statistical calculations can find this book of great value, and students of computer science, business management etc. will find it more useful in explaining the tools and techniques of data mining than their traditional textbooks.","type":"string"},"datatype":"string"},"type":"statement","id":"Q2740461$9F6F4392-72BD-49E8-8B36-C2CB4BDE5968","rank":"normal"}],"P1643":[{"mainsnak":{"snaktype":"value","property":"P1643","hash":"6ea65a19fe53005cc2041b01d1879f7f3f38d401","datavalue":{"value":{"entity-type":"item","numeric-id":5465938,"id":"Q5465938"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"a4e162dfcb61463a77187035d2a7ed966cb43316","datavalue":{"value":{"amount":"+0.7851583361625671","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":"Q2740461$F8A720CC-AF31-40B4-A4B9-90D7BCB4A68F","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"ad5d078145a9937936d57cce617730e7db29d42c","datavalue":{"value":{"entity-type":"item","numeric-id":4860804,"id":"Q4860804"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"f8e3725d132e5c5872888a19749224a15b775b27","datavalue":{"value":{"amount":"+0.7554137110710144","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":"Q2740461$3A008355-DBC9-44B5-9529-0316C6B370FC","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"dd38ff6a608ac3fe7d7420a91c2e280e4513bfaf","datavalue":{"value":{"entity-type":"item","numeric-id":884941,"id":"Q884941"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"d7d8b5662a8ff6deebd4f9d4d2fc06c52d668bde","datavalue":{"value":{"amount":"+0.7524274587631226","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":"Q2740461$94BE6BE7-D1CE-4DBE-852B-315216D4E4A0","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"baa70c0f7769cc7e4cb8ad37cc35e4597d81190a","datavalue":{"value":{"entity-type":"item","numeric-id":4821313,"id":"Q4821313"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"c2fa1fe1c64011729f0e93af1db7d2953008da31","datavalue":{"value":{"amount":"+0.7397533655166626","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":"Q2740461$6FD35D9F-BDBB-48FB-9A88-D0CA309C9263","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"de17fc28518d323c14ea8b6e4e73e3ebdb4c46fd","datavalue":{"value":{"entity-type":"item","numeric-id":4433594,"id":"Q4433594"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"301750383e0e7c8a7bc27ef634dac1644c2c7f48","datavalue":{"value":{"amount":"+0.7293088436126709","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":"Q2740461$A75B11F0-3B8C-48F9-B224-CA4CAD3476EE","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"Data mining and statistical analysis using SQL","badges":[],"url":"https://portal.mardi4nfdi.de/wiki/Data_mining_and_statistical_analysis_using_SQL"}}}}}