{"entities":{"Q4549768":{"pageid":6579360,"ns":120,"title":"Item:Q4549768","lastrevid":108947729,"modified":"2026-11-10T22:21:31Z","type":"item","id":"Q4549768","labels":{},"descriptions":{"en":{"language":"en","value":"scientific article; zbMATH DE number 1790670"}},"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":"Q4549768$AB68C425-9CAE-420B-A1B1-E9C100D7D52C","rank":"normal"}],"P225":[{"mainsnak":{"snaktype":"value","property":"P225","hash":"9e94f61cef75286c01fe89c2c8e1363e64a3387e","datavalue":{"value":"1007.68043","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q4549768$83022FBF-B58A-4289-8716-541BFE015C4F","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"928ea11a26bcaec9b51565b2e911431d77a56849","datavalue":{"value":{"entity-type":"item","numeric-id":4549767,"id":"Q4549767"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q4549768$B6D1E2CE-3CEC-40AE-B845-5D927F5F0E0F","rank":"normal"}],"P28":[{"mainsnak":{"snaktype":"value","property":"P28","hash":"142362e6d8f26628ca200c5bf9158be42ab9f824","datavalue":{"value":{"time":"+2002-08-28T00:00:00Z","timezone":0,"before":0,"after":0,"precision":11,"calendarmodel":"http://www.wikidata.org/entity/Q1985727"},"type":"time"},"datatype":"time"},"type":"statement","id":"Q4549768$6952342D-DF0E-4D6C-A0CD-A2578D8B7D08","rank":"normal"}],"P226":[{"mainsnak":{"snaktype":"value","property":"P226","hash":"bf2726c5c2109371cc10358eaa69bc4df711caf7","datavalue":{"value":"68P15","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q4549768$D1B5C184-8F5B-4918-8A26-083FC3D923CD","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P226","hash":"98c5206e338942c77451c20a9a5ffe8ae1a4cf18","datavalue":{"value":"68-01","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q4549768$CDAE54FD-62C5-4FA2-8CE4-3F468C651D46","rank":"normal"}],"P1451":[{"mainsnak":{"snaktype":"value","property":"P1451","hash":"0d59ee55e599333ba5e5d28838fcc9ae346d6afa","datavalue":{"value":"1790670","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q4549768$ADC584B7-F7A9-40AF-A09D-5C3ABF016439","rank":"normal"}],"P1450":[{"mainsnak":{"snaktype":"value","property":"P1450","hash":"2600aaba1f819f7d3ad24bab0da3f73740086e75","datavalue":{"value":"databases","type":"string"},"datatype":"string"},"type":"statement","id":"Q4549768$239F81DE-EF0C-4FCC-A600-4B136C594B84","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"9967a0b50804407b20f63da0231cb5fcf3f7a4e1","datavalue":{"value":"SQL","type":"string"},"datatype":"string"},"type":"statement","id":"Q4549768$53BD0D75-FF05-411E-9A8E-49F7082C8B11","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"f1be242e2c8a96fb5f850e5e3f376b15d8efca7c","datavalue":{"value":"Postgres","type":"string"},"datatype":"string"},"type":"statement","id":"Q4549768$A43EB3CF-6A96-477D-8EC6-EE8349AE0EB9","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"9d2b400f102a2b6120d4fa330b11f0d655e19d8d","datavalue":{"value":"PHP","type":"string"},"datatype":"string"},"type":"statement","id":"Q4549768$83C13577-9A50-4B5E-A20B-1E4CC5502F5C","rank":"normal"}],"P1463":[{"mainsnak":{"snaktype":"value","property":"P1463","hash":"742bc83855ba75ffd2b302eaf3320fef047e24e8","datavalue":{"value":{"entity-type":"item","numeric-id":38174,"id":"Q38174"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q4549768$23F6606C-31D4-4FB0-A109-A098ED7EE20F","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1463","hash":"269a6fa6fb65715095a4f55319c87d31b71ec7c1","datavalue":{"value":{"entity-type":"item","numeric-id":27808,"id":"Q27808"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q4549768$D5D59E71-5517-4C6A-A4FE-E812E0FE59A6","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":"Q4549768$93A917F9-A56B-472E-B728-466CCCFC9157","rank":"normal"}],"P1643":[{"mainsnak":{"snaktype":"value","property":"P1643","hash":"fd066a38c75dc2bcf513313fe95b7d03f60d80c8","datavalue":{"value":{"entity-type":"item","numeric-id":4778584,"id":"Q4778584"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"187d7ae459b204c328c973dcf265bc6e5e728662","datavalue":{"value":{"amount":"+0.7119227051734924","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":"Q4549768$C9733445-EDF9-4437-8319-D9E05E87D827","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"da490c624cd446d9347aade47f595ab5bbf5d1a9","datavalue":{"value":{"entity-type":"item","numeric-id":2761223,"id":"Q2761223"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"8bb02f3a91bbf375fbe0bbd372bbc51d112cebed","datavalue":{"value":{"amount":"+0.7071904540061951","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":"Q4549768$C32213D1-2A8F-422A-8C6A-1F9F1CCCC1C9","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"be7d071c70ab515f39924cbb1a0d1e6fa1710fcf","datavalue":{"value":{"entity-type":"item","numeric-id":2739735,"id":"Q2739735"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"b7337dd175876f6a7a8a2809fb2e773919251ae1","datavalue":{"value":{"amount":"+0.7032442688941956","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":"Q4549768$FDC75132-9995-447D-AF93-0508551C546E","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"7e8a46101df6ead2c1e216c0a9fe805ca23e2dce","datavalue":{"value":{"entity-type":"item","numeric-id":4436210,"id":"Q4436210"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"109f0c314cc2cdd361eea8b8e9c022c65e5f43f5","datavalue":{"value":{"amount":"+0.6834614276885986","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":"Q4549768$5CBDBD66-5888-4973-8DE6-6AAFE833DE29","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"5301b74e049c1ee856a2aee49768b0e190604dcb","datavalue":{"value":{"entity-type":"item","numeric-id":4229318,"id":"Q4229318"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"329c8ced8d4bd833fb965edb612e4886e09c839e","datavalue":{"value":{"amount":"+0.6832367777824402","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":"Q4549768$D74C87CD-F45F-4625-B51A-F3DD284914BB","rank":"normal"}],"P1448":[{"mainsnak":{"snaktype":"value","property":"P1448","hash":"0ce6f800b9efb6fd767116964e95f85813c088f4","datavalue":{"value":"This book contains more than the title suggests. Of course it is focused on Postgres, but besides that it gives a complete introduction into database systems and their architecture, data modelling, design of databases and normal forms (including BCNF). The reader is provided with checklists which help him to create sound relational models. After this first chapter a large part of the book is concerned with PostgreSQL in all its aspects. Since PostgreSQL is in good accordance with the SQL-2 standard this is a profound course of SQL-2 too. Differences to PostgreSQL are always made explicit. PostgreSQL has many special features: several non-standard datatypes like arrays (circumventing the first normal form), large objects (which are handled like real objects via object identifiers), binary and bit strings and last not least inheritance give Postgres its object-relational properties. The wealth of functions is remarkable, especially in connection with the so called geometric datatypes, which serve well for geometric construction an design. Here the author tries to give a complete reference which results in being rather scarce about it. Further themes are: PostgreSQL data dictionary, stored procedures, rules and Triggers -- where rules are PostgreSQL specific and similar to SQL-conform triggers, MVCC (multiversion concurrency control), listen and notify. This is already a lot of stuff, but there is still more: a reader with some programming experience finds several chapters concerned with PHP and how to build web applications based on PostgreSQL. All this is kept together by a continuously developed example which absorbes more and more features as the book goes on. There are lots of programs which are rather complex, but always well commented -- and of course available online. Some supplements should be mentioned: chapters on database tuning, download and installation of PostgreSQL and PHP, migration from MySQL to PostgreSQL and description of some PostgreSQL tools. There are however no exercises and instead of a bibliography there are only some references to weblinks. In principle a newcomer to databases could go the long way from database design to dynamic webpages with this one book if he is willing to use PostgreSQL together with PHP, and he will end up with satisfactory practical and theoretical knowledge.","type":"string"},"datatype":"string"},"type":"statement","id":"Q4549768$8A838CA4-F8E8-4C37-BED2-C57FF1322315","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"Publication:4549768","badges":[],"url":"https://portal.mardi4nfdi.de/wiki/Publication:4549768"}}}}}