{"entities":{"Q969190":{"pageid":971038,"ns":120,"title":"Item:Q969190","lastrevid":65819424,"modified":"2026-04-12T05:35:26Z","type":"item","id":"Q969190","labels":{"en":{"language":"en","value":"Entity relationship modelling of business rules: an oracle prototype"}},"descriptions":{"en":{"language":"en","value":"scientific article; zbMATH DE number 5707187"}},"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":"Q969190$233EE4FA-1461-4EBF-8AF1-9A929F3456A4","rank":"normal"}],"P159":[{"mainsnak":{"snaktype":"value","property":"P159","hash":"7125249d036542da7622add719dfbc4858e70612","datavalue":{"value":{"text":"Entity relationship modelling of business rules: an oracle prototype","language":"en"},"type":"monolingualtext"},"datatype":"monolingualtext"},"type":"statement","id":"Q969190$35E42029-0AD7-4BD3-AFED-4C0566040E34","rank":"normal"}],"P225":[{"mainsnak":{"snaktype":"value","property":"P225","hash":"dca5ac19ebdb080133d0b05f0bf18cb56996d528","datavalue":{"value":"1198.68128","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q969190$0577FF42-712A-4736-8117-158793B4C3AE","rank":"normal"}],"P27":[{"mainsnak":{"snaktype":"value","property":"P27","hash":"e3b475e68b676d248e3495684d2135fed34ffbf0","datavalue":{"value":"10.1504/IJDMMM.2010.032146","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q969190$CD4F7EF2-9DD5-483B-9DC3-30392F616FD3","rank":"normal"}],"P16":[{"mainsnak":{"snaktype":"value","property":"P16","hash":"e5eaefaff5cc6b2c1e3f97887a84c910fc29ff38","datavalue":{"value":{"entity-type":"item","numeric-id":969189,"id":"Q969189"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q969190$C533CE30-935B-4238-92E7-56DB4EA2D97B","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":"Q969190$10BC9BDB-C835-41F2-9433-8ABD0C8C52C6","rank":"normal"}],"P28":[{"mainsnak":{"snaktype":"value","property":"P28","hash":"ebf4d5783d24fecd8febc323b6d339d3afd0426e","datavalue":{"value":{"time":"+2010-05-12T00:00:00Z","timezone":0,"before":0,"after":0,"precision":11,"calendarmodel":"http://www.wikidata.org/entity/Q1985727"},"type":"time"},"datatype":"time"},"type":"statement","id":"Q969190$BED86818-0DAE-4A5B-A356-6DBBA9E52816","rank":"normal"}],"P1448":[{"mainsnak":{"snaktype":"value","property":"P1448","hash":"a82836fb2893f3593dfc4a97669f9559a1997a63","datavalue":{"value":"Summary: Business rules are generally developed as an addendum to database development using proprietary techniques. This paper provides an approach to apply the techniques of traditional entity-relationship modelling to structure the business rules as a rule repository for interaction with transactional entity types in a relational database management system. A prototype to model a sample set of business rules into relational database is provided to demonstrate the application of the concept. The paper utilises the Oracle database for illustrating the concepts. The prototype is explained through an application in Oracle's PL/SQL server pages.","type":"string"},"datatype":"string"},"type":"statement","id":"Q969190$BB6CA03F-663F-41D8-A43E-8F57DF035711","rank":"normal"}],"P226":[{"mainsnak":{"snaktype":"value","property":"P226","hash":"bf2726c5c2109371cc10358eaa69bc4df711caf7","datavalue":{"value":"68P15","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q969190$9AA2865F-2185-46F7-A2C8-468AB1D69407","rank":"normal"}],"P1451":[{"mainsnak":{"snaktype":"value","property":"P1451","hash":"be3d98b77756cf91c386df1c8f6cce322a82a73e","datavalue":{"value":"5707187","type":"string"},"datatype":"external-id"},"type":"statement","id":"Q969190$C5362203-EA24-44D2-BBE2-2FABBFEB080E","rank":"normal"}],"P1450":[{"mainsnak":{"snaktype":"value","property":"P1450","hash":"45cfb763492e2144915c2454ba89ea1ecb073c16","datavalue":{"value":"business rules","type":"string"},"datatype":"string"},"type":"statement","id":"Q969190$601E5FF3-02E3-4C9E-B56D-EFEFCBDF659F","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"536875abf9e7d56f842c6daa26666f2d20be91d8","datavalue":{"value":"data modelling","type":"string"},"datatype":"string"},"type":"statement","id":"Q969190$A7204A92-B605-4A8F-91D2-5E13E5FEE129","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"fdd9f3bedeb05876c199b132ac3640809a990dc5","datavalue":{"value":"entity-relationship modelling","type":"string"},"datatype":"string"},"type":"statement","id":"Q969190$CE1A89E6-F0B0-4C24-B7E0-2377B19E2256","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"ac873341ab34d6db98676ef037e18583cae25841","datavalue":{"value":"oracle","type":"string"},"datatype":"string"},"type":"statement","id":"Q969190$F278C8F5-9692-4609-8890-B77D29FAC13C","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"e938b8535a41895933d8d58d137f1deaccdfd146","datavalue":{"value":"PL/SQL server pages","type":"string"},"datatype":"string"},"type":"statement","id":"Q969190$238F76AA-CF74-4E37-8964-B389B4EE4DC4","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"b6ad4ad295d4a97c376815685e97cbf4b9ede5d1","datavalue":{"value":"database development","type":"string"},"datatype":"string"},"type":"statement","id":"Q969190$861F97DA-B5DD-4411-9F42-93BD3CA9638C","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"c6fc20978e385d0f02588a407eca6534f00b31d8","datavalue":{"value":"relational database management","type":"string"},"datatype":"string"},"type":"statement","id":"Q969190$B0756254-1574-4781-8A2B-DDE3D65F9F97","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1450","hash":"dd87141bf9407a8f6082d7474798082feb19af15","datavalue":{"value":"RDBMS","type":"string"},"datatype":"string"},"type":"statement","id":"Q969190$71698866-EC84-48C3-8DB4-EC2B90AAAEBA","rank":"normal"}],"P1463":[{"mainsnak":{"snaktype":"value","property":"P1463","hash":"21403b0e58561e65fe7b82759d26857a8ae8413b","datavalue":{"value":{"entity-type":"item","numeric-id":27719,"id":"Q27719"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","id":"Q969190$E998F84F-766C-4A6E-B294-0CC626E18D08","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":"Q969190$886E0042-BA54-4535-97BB-8795261C0E96","rank":"normal"}],"P1643":[{"mainsnak":{"snaktype":"value","property":"P1643","hash":"4ac7ae651e05b3047379aa3344257b6934b32885","datavalue":{"value":{"entity-type":"item","numeric-id":4435850,"id":"Q4435850"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"37407d0b0b7a359b7b8f617d3eb93328a892981c","datavalue":{"value":{"amount":"+0.731819748878479","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":"Q969190$E7390C54-22AD-4FDB-AFF7-D00F63501E77","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"1ea22bedef05046c26f47515881eb2f78a73290a","datavalue":{"value":{"entity-type":"item","numeric-id":4473511,"id":"Q4473511"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"642c337033b67ce20df5f1c106aea782fadbf58e","datavalue":{"value":{"amount":"+0.7042438983917236","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":"Q969190$49BFE5BB-5DA8-4060-96A6-6ACD24A1AC92","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"40e87efaca74e6bbf8531b6e6ee710d151af381f","datavalue":{"value":{"entity-type":"item","numeric-id":3644924,"id":"Q3644924"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"12f39b18208ccdf521bc53aa9aa250d6a3f3a02a","datavalue":{"value":{"amount":"+0.6994335055351257","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":"Q969190$FEC39CC2-DE2A-421B-865B-47608A7C39F3","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"cbe21b99682ebb29035fe83be1720f8408920fd2","datavalue":{"value":{"entity-type":"item","numeric-id":3431079,"id":"Q3431079"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"5680cb2f8cdd32ce068c5474363e41495399e50c","datavalue":{"value":{"amount":"+0.697982668876648","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":"Q969190$CDFAD76F-E909-45F1-9572-F6048A224653","rank":"normal"},{"mainsnak":{"snaktype":"value","property":"P1643","hash":"6171c291c3e32ab2fc022915d77e3418d63bff80","datavalue":{"value":{"entity-type":"item","numeric-id":1857283,"id":"Q1857283"},"type":"wikibase-entityid"},"datatype":"wikibase-item"},"type":"statement","qualifiers":{"P1659":[{"snaktype":"value","property":"P1659","hash":"db092302ff1f82bd4995359d75469e695fb8bfd6","datavalue":{"value":{"amount":"+0.6920390129089355","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":"Q969190$8FD4A084-8611-4849-AF66-87CDC0D53AB4","rank":"normal"}]},"sitelinks":{"mardi":{"site":"mardi","title":"Entity relationship modelling of business rules: an oracle prototype","badges":[],"url":"https://portal.mardi4nfdi.de/wiki/Entity_relationship_modelling_of_business_rules:_an_oracle_prototype"}}}}}