{"entities":{"Q1046598":{"pageid":1048446,"ns":120,"title":"Item:Q1046598","lastrevid":66029454,"modified":"2026-04-12T07:03:11Z","type":"item","id":"Q1046598","labels":{"en":{"language":"en","value":"ER modelling -- a zoom in and zoom out approach"}},"descriptions":{"en":{"language":"en","value":"scientific article; zbMATH DE number 5651389"}},"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":"Q1046598$578FA101-8A6F-49BF-B08D-0F12ADD825CE","rank":"normal"}],"P159":[{"mainsnak":{"snaktype":"value","property":"P159","hash":"da7e57e3258b175f307c8b038a475e19e662bab3","datavalue":{"value":{"text":"ER modelling -- a zoom in and zoom out approach","language":"en"},"type":"monolingualtext"},"datatype":"monolingualtext"},"type":"statement","id":"Q1046598$28C74F6F-0E83-4C94-9883-7146A57F0699","rank":"normal"}],"P225":[{"mainsnak":{"snaktype":"value","property":"P225","hash":"b7a855704f43e4829adc751452dd99f2861378b9","datavalue":{"value":"1184.68220","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1046598$18155161-A27E-43AA-9BFE-3A4B0E760B04","rank":"normal"}],"P27":[{"mainsnak":{"snaktype":"value","property":"P27","hash":"ccfa690d4208efd047bf458962a39aea7f56199e","datavalue":{"value":"10.1504/IJDMMM.2009.029031","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1046598$C37EA42E-BCBC-4C64-885E-FBDE4F0D6730","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"0b1e1bf30a5579891343b1ca5c4423edb1e72eea","datavalue":{"value":{"entity-type":"item","numeric-id":364513,"id":"Q364513"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1046598$26B54155-DE16-4A82-9D14-E25B6FD67036","rank":"normal"}],"P200":[{"mainsnak":{"snaktype":"value","property":"P200","hash":"f8491fe5c6cca3bbbe9bb714c9b4c67bae1c7ddd","datavalue":{"value":{"entity-type":"item","numeric-id":532628,"id":"Q532628"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q1046598$6DDA6D2C-778E-4A5D-A1FA-A5DCFB26EDE9","rank":"normal"}],"P28":[{"mainsnak":{"snaktype":"value","property":"P28","hash":"cba7e298819d113214826f07c43d3e95a6b456c6","datavalue":{"value":{"time":"+2009-12-22T00:00:00Z","timezone":0,"before":0,"after":0,"precision":11,"calendarmodel":"http://www.wikidata.org/entity/Q1985727"},"type":"time"},"datatype":"time"},"type":"statement","id":"Q1046598$5E20D4F6-CD11-472D-90F5-33F0096725F2","rank":"normal"}],"P1448":[{"mainsnak":{"snaktype":"value","property":"P1448","hash":"a3c82e0e3f78b391f5ed4cb2524a813f1bc1da27","datavalue":{"value":"Summary: Entity-relationship modelling is an effective design method for relational databases. It is covered in almost every textbook on database systems. Yet, there is not a single book that gives a systematic process on building an entity-relationship model step-by-step from the requirement specifications. In this paper, a zoom in and zoom out approach for such a process is introduced. A toolkit called ERZoom has been developed to assist the designer in the zoom in and zoom out design process. ERZoom provides a unique feature that enables the designer to view a selected subset of the entities and their attributes, while hiding the rest of the entity-relationship model. This is especially useful in distributed database design where vertical fragmentation is a major issue. ERZoom is developed as an open source package using Java. The zoom in and zoom out approach has been taught to beginners for several years and was well-received by the audience.","type":"string"},"datatype":"string"},"type":"statement","id":"Q1046598$59B0775B-9878-4F59-82EB-71C4B9E6D51C","rank":"normal"}],"P226":[{"mainsnak":{"snaktype":"value","property":"P226","hash":"bf2726c5c2109371cc10358eaa69bc4df711caf7","datavalue":{"value":"68P15","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1046598$701FE018-88CE-4165-A010-25FC023B2C6D","rank":"normal"}],"P1451":[{"mainsnak":{"snaktype":"value","property":"P1451","hash":"48aeb7c5c43437756f91ef44368c363e5b620513","datavalue":{"value":"5651389","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1046598$C04E9F6C-BD22-4695-98AA-E4842B52B956","rank":"normal"}],"P1450":[{"mainsnak":{"snaktype":"value","property":"P1450","hash":"fdd9f3bedeb05876c199b132ac3640809a990dc5","datavalue":{"value":"entity-relationship modelling","type":"string"},"datatype":"string"},"type":"statement","id":"Q1046598$01B8C06C-999F-4750-91D4-053E8B1C5337","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"31706c1e4d31518767545879eb8613a19910d732","datavalue":{"value":"conceptual modelling","type":"string"},"datatype":"string"},"type":"statement","id":"Q1046598$517DDD91-4D27-446A-B238-E23A371C016F","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"c6c7b2a3f9e70451a675de58da81edec2a509c7d","datavalue":{"value":"relational database design","type":"string"},"datatype":"string"},"type":"statement","id":"Q1046598$DC1DCB7E-6176-4458-8A53-9A458EE03557","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"536875abf9e7d56f842c6daa26666f2d20be91d8","datavalue":{"value":"data modelling","type":"string"},"datatype":"string"},"type":"statement","id":"Q1046598$E0275914-5402-494F-83EB-3ED6D91BAF01","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"4a720126bb07687c927e9552243872f3a42667b9","datavalue":{"value":"distributed database design","type":"string"},"datatype":"string"},"type":"statement","id":"Q1046598$F4E6407A-85E7-469D-923E-1C8F651700C7","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":"Q1046598$8C693807-1A38-4C7A-9BA4-46F4856E8EC3","rank":"normal"}],"P205":[{"mainsnak":{"snaktype":"value","property":"P205","hash":"f3347d9ee3c07f4f019d7880470c74406261cdb1","datavalue":{"value":"https://doi.org/10.1504/ijdmmm.2009.029031","type":"string"},"datatype":"url"},"type":"statement","id":"Q1046598$9290C36C-A340-4161-B986-A943F02B5524","rank":"normal"}],"P388":[{"mainsnak":{"snaktype":"value","property":"P388","hash":"1162133227504cd4233f35549644eb952275707b","datavalue":{"value":"W2018616117","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q1046598$C280BEE3-B8F4-46A6-8F67-C057E5A100CF","rank":"normal"}],"P1643":[{"mainsnak":{"snaktype":"value","property":"P1643","hash":"f7eb9673b89e5be26aa41df602a845fbb2683539","datavalue":{"value":{"entity-type":"item","numeric-id":1884937,"id":"Q1884937"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"eb8343e325a2709fb6898d75a855f6bd69cf3d99","datavalue":{"value":{"amount":"+0.79664767","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q1046598$D58E6FBC-DAAA-4D4B-81EB-C48F3FA67202","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"ae169dac032f833361802bbe74bf71d4e8593cb8","datavalue":{"value":{"entity-type":"item","numeric-id":4674191,"id":"Q4674191"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"14cc2ce49e30c63a4db79a337e9c456934af9ddf","datavalue":{"value":{"amount":"+0.7829886","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q1046598$108197E6-1DE6-4D51-93E8-0441F57D85CB","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"96541eb872fb3eb0b732052f4d4bd296873c4257","datavalue":{"value":{"entity-type":"item","numeric-id":1400640,"id":"Q1400640"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"f1a3f586aa31aaf639f04b79c6b92008c1c2532c","datavalue":{"value":{"amount":"+0.7818513","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q1046598$45FD6C46-7590-4CF6-BC34-0DF36917A245","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"2e69825744ab099e75577f302e583cf37f23b29e","datavalue":{"value":{"entity-type":"item","numeric-id":4494039,"id":"Q4494039"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"e71466618946f5fa4e3c1d9b721cbd363607574d","datavalue":{"value":{"amount":"+0.7696167","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q1046598$FC8007FE-7AFC-4858-9C97-632EF14D2CA5","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"8bf0a79606ecaeca7d352c7dfe3259dfb23c1543","datavalue":{"value":{"entity-type":"item","numeric-id":4332062,"id":"Q4332062"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"ce379b4cb510eeaa65edd937a082ebe7cdae123d","datavalue":{"value":{"amount":"+0.76960796","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q1046598$EC3698B9-8E0F-44ED-BC28-8D3E628B297D","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"37be66c63de4ef04070b83a2082669c75684474c","datavalue":{"value":{"entity-type":"item","numeric-id":1601613,"id":"Q1601613"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"52c432f86c05fc64385223fa4e66c291d9157ef1","datavalue":{"value":{"amount":"+0.7573933","unit":"1"},"type":"quantity"},"datatype":"quantity"}],"P1660":[{"snaktype":"value","property":"P1660","hash":"ac3c626774dcd0d16f89557f66586245841a01db","datavalue":{"value":{"entity-type":"item","numeric-id":6767936,"id":"Q6767936"},"type":"wikibase-entityid"},"datatype":"wikibase-item"}]},"qualifiers-order":["P1659","P1660"],"id":"Q1046598$DA9D997B-4637-4947-83C2-D3EE5D1A0FD2","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"ER modelling -- a zoom in and zoom out approach","badges":[],"url":"https://portal.mardi4nfdi.de/wiki/ER_modelling_--_a_zoom_in_and_zoom_out_approach"}}}}}