{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,26]],"date-time":"2025-10-26T20:35:26Z","timestamp":1761510926359,"version":"3.40.5"},"reference-count":3,"publisher":"National Library of Serbia","issue":"2","license":[{"start":{"date-parts":[[2007,1,1]],"date-time":"2007-01-01T00:00:00Z","timestamp":1167609600000},"content-version":"unspecified","delay-in-days":0,"URL":"http:\/\/creativecommons.org\/licenses\/by-nc-nd\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["ComSIS","COMPUT SCI INF SYST","COMPUT SCI INFORM SY","COMPUTER SCI INFORM","COMSIS J"],"published-print":{"date-parts":[[2007]]},"abstract":"<jats:p>IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3rd normal form with all relevant data constraints. SQL Generator is an IIS*Case tool that generates the implementation specification of a database schema according to ANSI SQL:2003 standard. The generator may also produce a database schema specification for Microsoft SQL Server or Oracle DBMSs. The paper describes SQL Generator's traits, considers aspects of its application, and shows its use in the implementation of a complex database constraint using procedural mechanisms of a particular relational DBMS. SQL Generator is implemented in Java and Oracle JDeveloper environment.<\/jats:p>","DOI":"10.2298\/csis0702081a","type":"journal-article","created":{"date-parts":[[2009,3,27]],"date-time":"2009-03-27T07:28:51Z","timestamp":1238138931000},"page":"81-100","source":"Crossref","is-referenced-by-count":5,"title":["A generator of SQL schema specifications"],"prefix":"10.2298","volume":"4","author":[{"given":"Slavica","family":"Aleksic","sequence":"first","affiliation":[{"name":"Faculty of Technical Sciences, Novi Sad"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-1319-488X","authenticated-orcid":false,"given":"Ivan","family":"Lukovic","sequence":"additional","affiliation":[{"name":"Faculty of Technical Sciences, Novi Sad"}]},{"given":"Pavle","family":"Mogin","sequence":"additional","affiliation":[{"name":"Victoria University of Wellington, Wellington, New Zealand"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-1698-0800","authenticated-orcid":false,"given":"Miro","family":"Govedarica","sequence":"additional","affiliation":[{"name":"Faculty of Technical Sciences, Novi Sad"}]}],"member":"1078","reference":[{"key":"1","doi-asserted-by":"publisher","DOI":"10.2298\/CSIS0401117G"},{"key":"2","doi-asserted-by":"publisher","DOI":"10.1002\/spe.820"},{"key":"3","doi-asserted-by":"publisher","DOI":"10.1145\/1118890.1118892"}],"container-title":["Computer Science and Information Systems"],"original-title":[],"language":"en","deposited":{"date-parts":[[2023,5,29]],"date-time":"2023-05-29T08:29:29Z","timestamp":1685348969000},"score":1,"resource":{"primary":{"URL":"https:\/\/doiserbia.nb.rs\/Article.aspx?ID=1820-02140702081A"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2007]]},"references-count":3,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2007]]}},"URL":"https:\/\/doi.org\/10.2298\/csis0702081a","relation":{},"ISSN":["1820-0214","2406-1018"],"issn-type":[{"type":"print","value":"1820-0214"},{"type":"electronic","value":"2406-1018"}],"subject":[],"published":{"date-parts":[[2007]]}}}