{"entities":{"Q2768442":{"pageid":2779181,"ns":120,"title":"Item:Q2768442","lastrevid":79227503,"modified":"2026-05-06T13:26:15Z","type":"item","id":"Q2768442","labels":{"en":{"language":"en","value":"Entity-relationship-attribute designs and sketches"}},"descriptions":{"en":{"language":"en","value":"scientific article; zbMATH DE number 1699523"}},"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":"Q2768442$96B2AFA4-CD28-484F-A1A3-500706FBC7F6","rank":"normal"}],"P225":[{"mainsnak":{"snaktype":"value","property":"P225","hash":"4cf917c187116610ded56a44ff0f156ebd43ab40","datavalue":{"value":"0990.18003","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q2768442$2BA6D0AE-9C62-4DA8-B235-FD694148EAA7","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"aea706b37d8a171735c74cc5012b0a5da2aee9fe","datavalue":{"value":{"entity-type":"item","numeric-id":218992,"id":"Q218992"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q2768442$41578458-BA4F-4F7A-9338-292974D72B21","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P16","hash":"287c1ad9c4b9498e19d911ca6d4d32d1c217a55d","datavalue":{"value":{"entity-type":"item","numeric-id":1394133,"id":"Q1394133"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q2768442$91D8AB60-F11D-4F43-9775-645BD5ADABF1","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P16","hash":"768eb84f904cea244496fad91b6f670d4cc635cc","datavalue":{"value":{"entity-type":"item","numeric-id":633804,"id":"Q633804"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q2768442$23E4F019-3D7E-4058-AF7C-4B784D1850C9","rank":"normal"}],"P28":[{"mainsnak":{"snaktype":"value","property":"P28","hash":"a58c0c334590fe3ab2e759e1b681637074ea80c2","datavalue":{"value":{"time":"+2002-02-07T00:00:00Z","timezone":0,"before":0,"after":0,"precision":11,"calendarmodel":"http://www.wikidata.org/entity/Q1985727"},"type":"time"},"datatype":"time"},"type":"statement","id":"Q2768442$67351E79-8AF7-45A3-9EE0-655EE3E67377","rank":"normal"}],"P205":[{"mainsnak":{"snaktype":"value","property":"P205","hash":"239512a42029d7d416b96b9e9136bbf1231c26ed","datavalue":{"value":"https://eudml.org/doc/121924","type":"string"},"datatype":"url"},"type":"statement","id":"Q2768442$ED1A322C-28ED-4D0B-AED3-1B44606FDB57","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P205","hash":"a1dbbb8a577444bb92f09b2261da06fcc91d0bc0","datavalue":{"value":"http://www.emis.de/journals/TAC/#vol10","type":"string"},"datatype":"url"},"type":"statement","id":"Q2768442$29D02AF5-5628-43F9-AB03-7AF4F49C59B4","rank":"normal"}],"P226":[{"mainsnak":{"snaktype":"value","property":"P226","hash":"71b35794875cb356cb85d10b480bcf4949f79b93","datavalue":{"value":"18C30","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q2768442$4289A79F-8E4F-44C3-AA6D-184FCD87A170","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P226","hash":"bf2726c5c2109371cc10358eaa69bc4df711caf7","datavalue":{"value":"68P15","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q2768442$6D5C8396-D59A-46E9-8E6F-419C1806FDFA","rank":"normal"}],"P1451":[{"mainsnak":{"snaktype":"value","property":"P1451","hash":"6a3d2c083d8f4c46fc712f3ad5d01efa0fb384ab","datavalue":{"value":"1699523","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q2768442$A1AA6158-DF7E-40BC-8D02-B75A10A766D7","rank":"normal"}],"P1450":[{"mainsnak":{"snaktype":"value","property":"P1450","hash":"7e6331dfbf4973a8f4b1848bbf5e00e2308f757d","datavalue":{"value":"sketch","type":"string"},"datatype":"string"},"type":"statement","id":"Q2768442$D14791E6-EF1F-4D8B-992A-F663346C2A6A","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"fea9a03b5dc56f980d477656272a4aec82f77f56","datavalue":{"value":"model","type":"string"},"datatype":"string"},"type":"statement","id":"Q2768442$91CF6D5F-1B40-48D0-AA0A-A5E89D6A0A11","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"aab5c54aaec05be29fceb916ef026faad12b93e9","datavalue":{"value":"database","type":"string"},"datatype":"string"},"type":"statement","id":"Q2768442$16723976-2392-4848-A675-A3616018674D","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"8c61da4d0f953ae6ac684ebed199df1260b610dc","datavalue":{"value":"update","type":"string"},"datatype":"string"},"type":"statement","id":"Q2768442$6D16FE47-252E-464C-82DA-70F40F537809","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"b671a4c2c5f0b1dd9a3e3c716e5644a340d1e0f3","datavalue":{"value":"ERA diagrams","type":"string"},"datatype":"string"},"type":"statement","id":"Q2768442$EC41E547-D150-463B-97EC-76D7AAC14F5D","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"78ae311069c1af077ec9512c087d3f9541ef2c34","datavalue":{"value":"data base design","type":"string"},"datatype":"string"},"type":"statement","id":"Q2768442$9AF3CB3E-4DB7-49C7-885B-6834ADCBE4DA","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"62706010b2a8ae1287e596efceb01692584eb55e","datavalue":{"value":"lextensive category","type":"string"},"datatype":"string"},"type":"statement","id":"Q2768442$80E5E119-3FFD-4BBB-A5FE-14C4F7850F68","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"ac9dbe40e8f53c9e57d4066c94f466b2f235fec2","datavalue":{"value":"query language","type":"string"},"datatype":"string"},"type":"statement","id":"Q2768442$E6B7DA1D-C226-42A5-9029-BB5241EEB7ED","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":"Q2768442$ACC9A911-7D86-4A49-93C4-7184D62B4C02","rank":"normal"}],"P1633":[{"mainsnak":{"snaktype":"value","property":"P1633","hash":"29e2c139a1dfcdbab6ae48ffe0b6cb44e94931f6","datavalue":{"value":"bafkreifk2qz57dk3lx5savsm4guhnkizxzxjzoq4r25eetocpal23zt2xa","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q2768442$37C769DF-429F-4ECC-849B-57D2CA35EF78","rank":"normal"}],"P159":[{"mainsnak":{"snaktype":"value","property":"P159","hash":"2fdf7add8b60abf06261fdfd57056e6ee97faeb2","datavalue":{"value":{"text":"Entity-relationship-attribute designs and sketches","language":"en"},"type":"monolingualtext"},"datatype":"monolingualtext"},"type":"statement","id":"Q2768442$7C1DF740-09BE-40FE-82B0-B42D5C62438F","rank":"normal"}],"P200":[{"mainsnak":{"snaktype":"value","property":"P200","hash":"06b1e008340f04c1e2c29991be66793881c442d7","datavalue":{"value":{"entity-type":"item","numeric-id":6499416,"id":"Q6499416"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q2768442$53CC588A-07C6-4E41-B6EA-D667AEEB6CDA","rank":"normal"}],"P1448":[{"mainsnak":{"snaktype":"value","property":"P1448","hash":"173dc85165647283b1d4fc5009ee66847b23c253","datavalue":{"value":"Entity-Relationship-Attribute (ERA) diagrams are commonly used to specify and design information systems. In a previous paper the authors have shown how ERA diagrams can be enhanced by the inclusion of commutative diagrams and specification of finite limits and finite sums to model constraints and queries. NEWLINENEWLINENEWLINEIn the present paper the authors argue that the categorical notion of sketch is the natural environment to formalize the data base design process. NEWLINENEWLINENEWLINEA data base design is a finite-limit, finite-sum sketch with a terminal node, called EA sketch, a data base state is a model of an EA sketch in a lextensive category. The category of models of an EA sketch is an object of models of the sketch in a 2-category of lextensive categories. Moreover, modelling the same sketch in certain objects in other 2-categories defines both the query language for the data base and the updates for the data base. NEWLINENEWLINENEWLINETherefore, the categorical model idea is used to capture not only the statics of the data base, namely the states, but also the dynamics, namely queries and updates.","type":"string"},"datatype":"string"},"type":"statement","id":"Q2768442$362296EE-576F-486F-80A2-6210FEF87067","rank":"normal"}],"P1447":[{"mainsnak":{"snaktype":"value","property":"P1447","hash":"14df87f03128769fb7e76235928bf393d9238874","datavalue":{"value":{"entity-type":"item","numeric-id":256972,"id":"Q256972"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q2768442$871D5F4C-BCED-44F5-9D91-00E134C2A675","rank":"normal"}],"P1643":[{"mainsnak":{"snaktype":"value","property":"P1643","hash":"07b8efafc85100e8159c2743c890c2bbb8d36e69","datavalue":{"value":{"entity-type":"item","numeric-id":5505426,"id":"Q5505426"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"94da2d232dbf34b37fa23d8150eb97e732c6c0cd","datavalue":{"value":{"amount":"+0.7612711191177368","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":"Q2768442$09EE776E-4090-4390-B23C-ACE985A1EF4C","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"38fc6259d3e19f30937a5541e172a628507ec9c9","datavalue":{"value":{"entity-type":"item","numeric-id":4888795,"id":"Q4888795"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"47823d8b68b9f752bc3b88f4964bfcee49f1743b","datavalue":{"value":{"amount":"+0.6910602450370789","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":"Q2768442$8827A93C-AF0D-4810-9A31-31D0AF760544","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"0773164c036a0f6a119180a261dc227f8f93220d","datavalue":{"value":{"entity-type":"item","numeric-id":4332061,"id":"Q4332061"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"0b43f58e5390d5e000deb479a20f08e11ce02808","datavalue":{"value":{"amount":"+0.6908856630325317","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":"Q2768442$9C657663-4BDD-4057-82E6-26FD18275A07","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"dd9e46b588334f5036c33535fcb0afbb66ebe085","datavalue":{"value":{"entity-type":"item","numeric-id":4004249,"id":"Q4004249"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"f0cadc12a7bcaa76bdf13c9d4b762bcc7be9f1f3","datavalue":{"value":{"amount":"+0.6902840733528137","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":"Q2768442$CD7AA4AF-FDBB-4813-A2CB-2E0C5E02C97D","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"20a79d21216401ad16d89d0981ca5fc227b19bcc","datavalue":{"value":{"entity-type":"item","numeric-id":2843913,"id":"Q2843913"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"7f6ceea182a96d4c05cec9bbb8b5ca492049a89f","datavalue":{"value":{"amount":"+0.6902839541435242","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":"Q2768442$A5EB1E0D-F3BE-4B01-8C5A-4B7EA42B95FA","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"Entity-relationship-attribute designs and sketches","badges":[]}}}}}