Gambit: An Interactive Database Design Tool for Data Structures, Integrity Constraints, and Transactions

The design of a database is a rather complex and dynamic process that requires comprehensive knowledge and experience. There exist many manual design tools and techniques, but the step from a schema to an implementation is still a delicate subject. The interactive database design tool Gambit support...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:IEEE transactions on software engineering 1985-07, Vol.SE-11 (7), p.574-583
Hauptverfasser: Braegger, R.P., Dudler, A.M., Rebsamen, J., Zehnder, C.A.
Format: Artikel
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page 583
container_issue 7
container_start_page 574
container_title IEEE transactions on software engineering
container_volume SE-11
creator Braegger, R.P.
Dudler, A.M.
Rebsamen, J.
Zehnder, C.A.
description The design of a database is a rather complex and dynamic process that requires comprehensive knowledge and experience. There exist many manual design tools and techniques, but the step from a schema to an implementation is still a delicate subject. The interactive database design tool Gambit supports the whole process in an optimal way. It is based on an extended relational-entity relationship model. The designer is assisted in outlining and describing data structures and consistency preserving update transactions. The constraints are formulated using the database programming language Modula/R which is based upon first-order predicate calculus. The update transactions are generated automatically as Modula/R programs and include all defined integrity constraints. They are collected in so-called data modules that represent the only interface to the database apart from read operations. The prototype facility of Gambit allows the designer to test the design of the database. The results can be used as feedback leading to an improvement of the conceptual schema and the transactions.
doi_str_mv 10.1109/TSE.1985.232501
format Article
fullrecord <record><control><sourceid>proquest_RIE</sourceid><recordid>TN_cdi_crossref_primary_10_1109_TSE_1985_232501</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><ieee_id>1702061</ieee_id><sourcerecordid>35182855</sourcerecordid><originalsourceid>FETCH-LOGICAL-c346t-cbaaa28a2a60097e00a6f254404bac1983c9b42dad87f9518390f93fc0d52a833</originalsourceid><addsrcrecordid>eNpdkM1LxDAQxYMouH6cPXgpIp7sOkmaNvEm6ycIHlzPYZpNNdJNNUkF_3uzrih4mjDz3uPlR8gBhSmloM7mj1dTqqSYMs4E0A0yoYqrkgsGm2QCoGQphFTbZCfGVwAQTSMm5OUGl61L58WFL-58sgFNch-2uMSELcb8sNE9-2I-DH3RDeH7UDymMJo0BhtPv13PwaXPYjb4mAI6n_Ia_aKYB_RxFZgPe2Srwz7a_Z-5S56ur-az2_L-4eZudnFfGl7VqTQtIjKJDOtcubEAWHdMVBVULZr8P25UW7EFLmTTKUElV9Ap3hlYCIaS811yss59C8P7aGPSSxeN7Xv0dhij5tnDpBBZePRP-DqMwedumqpMijO6Sjtbi0wYYgy202_BLTF8agp6hV1n7HqFXa-xZ8fxTyxGg32XERgXf22yhjrXzrLDtcxZa_9CG2BQU_4FmZGKdQ</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>195583213</pqid></control><display><type>article</type><title>Gambit: An Interactive Database Design Tool for Data Structures, Integrity Constraints, and Transactions</title><source>IEEE Electronic Library (IEL)</source><creator>Braegger, R.P. ; Dudler, A.M. ; Rebsamen, J. ; Zehnder, C.A.</creator><creatorcontrib>Braegger, R.P. ; Dudler, A.M. ; Rebsamen, J. ; Zehnder, C.A.</creatorcontrib><description>The design of a database is a rather complex and dynamic process that requires comprehensive knowledge and experience. There exist many manual design tools and techniques, but the step from a schema to an implementation is still a delicate subject. The interactive database design tool Gambit supports the whole process in an optimal way. It is based on an extended relational-entity relationship model. The designer is assisted in outlining and describing data structures and consistency preserving update transactions. The constraints are formulated using the database programming language Modula/R which is based upon first-order predicate calculus. The update transactions are generated automatically as Modula/R programs and include all defined integrity constraints. They are collected in so-called data modules that represent the only interface to the database apart from read operations. The prototype facility of Gambit allows the designer to test the design of the database. The results can be used as feedback leading to an improvement of the conceptual schema and the transactions.</description><identifier>ISSN: 0098-5589</identifier><identifier>EISSN: 1939-3520</identifier><identifier>DOI: 10.1109/TSE.1985.232501</identifier><identifier>CODEN: IESEDJ</identifier><language>eng</language><publisher>New York, NY: IEEE</publisher><subject>Applied sciences ; Computer languages ; Computer science; control theory; systems ; Data modules ; Data structures ; Database design ; database programming language ; Database systems ; Design ; Engineering ; entity relationship model ; Exact sciences and technology ; Feedback ; Information systems. Data bases ; integrity constraints ; Memory organisation. Data processing ; Methods ; Programming languages ; propagation path concept ; Prototypes ; Relational databases ; Satellite broadcasting ; Semantics ; Software ; Testing ; Transaction databases ; User interface ; User interfaces</subject><ispartof>IEEE transactions on software engineering, 1985-07, Vol.SE-11 (7), p.574-583</ispartof><rights>1986 INIST-CNRS</rights><rights>Copyright Institute of Electrical and Electronics Engineers, Inc. (IEEE) Jul 1985</rights><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed><citedby>FETCH-LOGICAL-c346t-cbaaa28a2a60097e00a6f254404bac1983c9b42dad87f9518390f93fc0d52a833</citedby></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://ieeexplore.ieee.org/document/1702061$$EHTML$$P50$$Gieee$$H</linktohtml><link.rule.ids>314,780,784,796,27924,27925,54758</link.rule.ids><linktorsrc>$$Uhttps://ieeexplore.ieee.org/document/1702061$$EView_record_in_IEEE$$FView_record_in_$$GIEEE</linktorsrc><backlink>$$Uhttp://pascal-francis.inist.fr/vibad/index.php?action=getRecordDetail&amp;idt=8606951$$DView record in Pascal Francis$$Hfree_for_read</backlink></links><search><creatorcontrib>Braegger, R.P.</creatorcontrib><creatorcontrib>Dudler, A.M.</creatorcontrib><creatorcontrib>Rebsamen, J.</creatorcontrib><creatorcontrib>Zehnder, C.A.</creatorcontrib><title>Gambit: An Interactive Database Design Tool for Data Structures, Integrity Constraints, and Transactions</title><title>IEEE transactions on software engineering</title><addtitle>TSE</addtitle><description>The design of a database is a rather complex and dynamic process that requires comprehensive knowledge and experience. There exist many manual design tools and techniques, but the step from a schema to an implementation is still a delicate subject. The interactive database design tool Gambit supports the whole process in an optimal way. It is based on an extended relational-entity relationship model. The designer is assisted in outlining and describing data structures and consistency preserving update transactions. The constraints are formulated using the database programming language Modula/R which is based upon first-order predicate calculus. The update transactions are generated automatically as Modula/R programs and include all defined integrity constraints. They are collected in so-called data modules that represent the only interface to the database apart from read operations. The prototype facility of Gambit allows the designer to test the design of the database. The results can be used as feedback leading to an improvement of the conceptual schema and the transactions.</description><subject>Applied sciences</subject><subject>Computer languages</subject><subject>Computer science; control theory; systems</subject><subject>Data modules</subject><subject>Data structures</subject><subject>Database design</subject><subject>database programming language</subject><subject>Database systems</subject><subject>Design</subject><subject>Engineering</subject><subject>entity relationship model</subject><subject>Exact sciences and technology</subject><subject>Feedback</subject><subject>Information systems. Data bases</subject><subject>integrity constraints</subject><subject>Memory organisation. Data processing</subject><subject>Methods</subject><subject>Programming languages</subject><subject>propagation path concept</subject><subject>Prototypes</subject><subject>Relational databases</subject><subject>Satellite broadcasting</subject><subject>Semantics</subject><subject>Software</subject><subject>Testing</subject><subject>Transaction databases</subject><subject>User interface</subject><subject>User interfaces</subject><issn>0098-5589</issn><issn>1939-3520</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>1985</creationdate><recordtype>article</recordtype><sourceid>8G5</sourceid><sourceid>ABUWG</sourceid><sourceid>AFKRA</sourceid><sourceid>AZQEC</sourceid><sourceid>BENPR</sourceid><sourceid>CCPQU</sourceid><sourceid>DWQXO</sourceid><sourceid>GNUQQ</sourceid><sourceid>GUQSH</sourceid><sourceid>M2O</sourceid><recordid>eNpdkM1LxDAQxYMouH6cPXgpIp7sOkmaNvEm6ycIHlzPYZpNNdJNNUkF_3uzrih4mjDz3uPlR8gBhSmloM7mj1dTqqSYMs4E0A0yoYqrkgsGm2QCoGQphFTbZCfGVwAQTSMm5OUGl61L58WFL-58sgFNch-2uMSELcb8sNE9-2I-DH3RDeH7UDymMJo0BhtPv13PwaXPYjb4mAI6n_Ia_aKYB_RxFZgPe2Srwz7a_Z-5S56ur-az2_L-4eZudnFfGl7VqTQtIjKJDOtcubEAWHdMVBVULZr8P25UW7EFLmTTKUElV9Ap3hlYCIaS811yss59C8P7aGPSSxeN7Xv0dhij5tnDpBBZePRP-DqMwedumqpMijO6Sjtbi0wYYgy202_BLTF8agp6hV1n7HqFXa-xZ8fxTyxGg32XERgXf22yhjrXzrLDtcxZa_9CG2BQU_4FmZGKdQ</recordid><startdate>19850701</startdate><enddate>19850701</enddate><creator>Braegger, R.P.</creator><creator>Dudler, A.M.</creator><creator>Rebsamen, J.</creator><creator>Zehnder, C.A.</creator><general>IEEE</general><general>Institute of Electrical and Electronics Engineers</general><general>IEEE Computer Society</general><scope>IQODW</scope><scope>AAYXX</scope><scope>CITATION</scope><scope>3V.</scope><scope>7WY</scope><scope>7WZ</scope><scope>7X7</scope><scope>7XB</scope><scope>87Z</scope><scope>88E</scope><scope>88F</scope><scope>88I</scope><scope>88K</scope><scope>8AL</scope><scope>8FE</scope><scope>8FG</scope><scope>8FI</scope><scope>8FJ</scope><scope>8FK</scope><scope>8FL</scope><scope>8G5</scope><scope>ABJCF</scope><scope>ABUWG</scope><scope>AFKRA</scope><scope>ARAPS</scope><scope>AZQEC</scope><scope>BENPR</scope><scope>BEZIV</scope><scope>BGLVJ</scope><scope>CCPQU</scope><scope>DWQXO</scope><scope>FRNLG</scope><scope>FYUFA</scope><scope>F~G</scope><scope>GHDGH</scope><scope>GNUQQ</scope><scope>GUQSH</scope><scope>HCIFZ</scope><scope>JQ2</scope><scope>K60</scope><scope>K6~</scope><scope>K7-</scope><scope>K9.</scope><scope>L.-</scope><scope>L6V</scope><scope>M0C</scope><scope>M0N</scope><scope>M0S</scope><scope>M1P</scope><scope>M1Q</scope><scope>M2O</scope><scope>M2P</scope><scope>M2T</scope><scope>M7S</scope><scope>MBDVC</scope><scope>P5Z</scope><scope>P62</scope><scope>PQBIZ</scope><scope>PQBZA</scope><scope>PQEST</scope><scope>PQQKQ</scope><scope>PQUKI</scope><scope>PRINS</scope><scope>PTHSS</scope><scope>Q9U</scope><scope>7SC</scope><scope>7SP</scope><scope>8FD</scope><scope>F28</scope><scope>FR3</scope><scope>L7M</scope><scope>L~C</scope><scope>L~D</scope></search><sort><creationdate>19850701</creationdate><title>Gambit: An Interactive Database Design Tool for Data Structures, Integrity Constraints, and Transactions</title><author>Braegger, R.P. ; Dudler, A.M. ; Rebsamen, J. ; Zehnder, C.A.</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-c346t-cbaaa28a2a60097e00a6f254404bac1983c9b42dad87f9518390f93fc0d52a833</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>1985</creationdate><topic>Applied sciences</topic><topic>Computer languages</topic><topic>Computer science; control theory; systems</topic><topic>Data modules</topic><topic>Data structures</topic><topic>Database design</topic><topic>database programming language</topic><topic>Database systems</topic><topic>Design</topic><topic>Engineering</topic><topic>entity relationship model</topic><topic>Exact sciences and technology</topic><topic>Feedback</topic><topic>Information systems. Data bases</topic><topic>integrity constraints</topic><topic>Memory organisation. Data processing</topic><topic>Methods</topic><topic>Programming languages</topic><topic>propagation path concept</topic><topic>Prototypes</topic><topic>Relational databases</topic><topic>Satellite broadcasting</topic><topic>Semantics</topic><topic>Software</topic><topic>Testing</topic><topic>Transaction databases</topic><topic>User interface</topic><topic>User interfaces</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Braegger, R.P.</creatorcontrib><creatorcontrib>Dudler, A.M.</creatorcontrib><creatorcontrib>Rebsamen, J.</creatorcontrib><creatorcontrib>Zehnder, C.A.</creatorcontrib><collection>Pascal-Francis</collection><collection>CrossRef</collection><collection>ProQuest Central (Corporate)</collection><collection>ABI/INFORM Collection</collection><collection>ABI/INFORM Global (PDF only)</collection><collection>Health &amp; Medical Collection</collection><collection>ProQuest Central (purchase pre-March 2016)</collection><collection>ABI/INFORM Global (Alumni Edition)</collection><collection>Medical Database (Alumni Edition)</collection><collection>Military Database (Alumni Edition)</collection><collection>Science Database (Alumni Edition)</collection><collection>Telecommunications (Alumni Edition)</collection><collection>Computing Database (Alumni Edition)</collection><collection>ProQuest SciTech Collection</collection><collection>ProQuest Technology Collection</collection><collection>Hospital Premium Collection</collection><collection>Hospital Premium Collection (Alumni Edition)</collection><collection>ProQuest Central (Alumni) (purchase pre-March 2016)</collection><collection>ABI/INFORM Collection (Alumni Edition)</collection><collection>Research Library (Alumni Edition)</collection><collection>Materials Science &amp; Engineering Collection</collection><collection>ProQuest Central (Alumni Edition)</collection><collection>ProQuest Central UK/Ireland</collection><collection>Advanced Technologies &amp; Aerospace Collection</collection><collection>ProQuest Central Essentials</collection><collection>ProQuest Central</collection><collection>Business Premium Collection</collection><collection>Technology Collection</collection><collection>ProQuest One Community College</collection><collection>ProQuest Central Korea</collection><collection>Business Premium Collection (Alumni)</collection><collection>Health Research Premium Collection</collection><collection>ABI/INFORM Global (Corporate)</collection><collection>Health Research Premium Collection (Alumni)</collection><collection>ProQuest Central Student</collection><collection>Research Library Prep</collection><collection>SciTech Premium Collection</collection><collection>ProQuest Computer Science Collection</collection><collection>ProQuest Business Collection (Alumni Edition)</collection><collection>ProQuest Business Collection</collection><collection>Computer Science Database</collection><collection>ProQuest Health &amp; Medical Complete (Alumni)</collection><collection>ABI/INFORM Professional Advanced</collection><collection>ProQuest Engineering Collection</collection><collection>ABI/INFORM Global</collection><collection>Computing Database</collection><collection>Health &amp; Medical Collection (Alumni Edition)</collection><collection>Medical Database</collection><collection>Military Database</collection><collection>Research Library</collection><collection>Science Database</collection><collection>Telecommunications Database</collection><collection>Engineering Database</collection><collection>Research Library (Corporate)</collection><collection>Advanced Technologies &amp; Aerospace Database</collection><collection>ProQuest Advanced Technologies &amp; Aerospace Collection</collection><collection>ProQuest One Business</collection><collection>ProQuest One Business (Alumni)</collection><collection>ProQuest One Academic Eastern Edition (DO NOT USE)</collection><collection>ProQuest One Academic</collection><collection>ProQuest One Academic UKI Edition</collection><collection>ProQuest Central China</collection><collection>Engineering Collection</collection><collection>ProQuest Central Basic</collection><collection>Computer and Information Systems Abstracts</collection><collection>Electronics &amp; Communications Abstracts</collection><collection>Technology Research Database</collection><collection>ANTE: Abstracts in New Technology &amp; Engineering</collection><collection>Engineering Research Database</collection><collection>Advanced Technologies Database with Aerospace</collection><collection>Computer and Information Systems Abstracts – Academic</collection><collection>Computer and Information Systems Abstracts Professional</collection><jtitle>IEEE transactions on software engineering</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Braegger, R.P.</au><au>Dudler, A.M.</au><au>Rebsamen, J.</au><au>Zehnder, C.A.</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Gambit: An Interactive Database Design Tool for Data Structures, Integrity Constraints, and Transactions</atitle><jtitle>IEEE transactions on software engineering</jtitle><stitle>TSE</stitle><date>1985-07-01</date><risdate>1985</risdate><volume>SE-11</volume><issue>7</issue><spage>574</spage><epage>583</epage><pages>574-583</pages><issn>0098-5589</issn><eissn>1939-3520</eissn><coden>IESEDJ</coden><abstract>The design of a database is a rather complex and dynamic process that requires comprehensive knowledge and experience. There exist many manual design tools and techniques, but the step from a schema to an implementation is still a delicate subject. The interactive database design tool Gambit supports the whole process in an optimal way. It is based on an extended relational-entity relationship model. The designer is assisted in outlining and describing data structures and consistency preserving update transactions. The constraints are formulated using the database programming language Modula/R which is based upon first-order predicate calculus. The update transactions are generated automatically as Modula/R programs and include all defined integrity constraints. They are collected in so-called data modules that represent the only interface to the database apart from read operations. The prototype facility of Gambit allows the designer to test the design of the database. The results can be used as feedback leading to an improvement of the conceptual schema and the transactions.</abstract><cop>New York, NY</cop><pub>IEEE</pub><doi>10.1109/TSE.1985.232501</doi><tpages>10</tpages></addata></record>
fulltext fulltext_linktorsrc
identifier ISSN: 0098-5589
ispartof IEEE transactions on software engineering, 1985-07, Vol.SE-11 (7), p.574-583
issn 0098-5589
1939-3520
language eng
recordid cdi_crossref_primary_10_1109_TSE_1985_232501
source IEEE Electronic Library (IEL)
subjects Applied sciences
Computer languages
Computer science
control theory
systems
Data modules
Data structures
Database design
database programming language
Database systems
Design
Engineering
entity relationship model
Exact sciences and technology
Feedback
Information systems. Data bases
integrity constraints
Memory organisation. Data processing
Methods
Programming languages
propagation path concept
Prototypes
Relational databases
Satellite broadcasting
Semantics
Software
Testing
Transaction databases
User interface
User interfaces
title Gambit: An Interactive Database Design Tool for Data Structures, Integrity Constraints, and Transactions
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-28T13%3A03%3A25IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest_RIE&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Gambit:%20An%20Interactive%20Database%20Design%20Tool%20for%20Data%20Structures,%20Integrity%20Constraints,%20and%20Transactions&rft.jtitle=IEEE%20transactions%20on%20software%20engineering&rft.au=Braegger,%20R.P.&rft.date=1985-07-01&rft.volume=SE-11&rft.issue=7&rft.spage=574&rft.epage=583&rft.pages=574-583&rft.issn=0098-5589&rft.eissn=1939-3520&rft.coden=IESEDJ&rft_id=info:doi/10.1109/TSE.1985.232501&rft_dat=%3Cproquest_RIE%3E35182855%3C/proquest_RIE%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_pqid=195583213&rft_id=info:pmid/&rft_ieee_id=1702061&rfr_iscdi=true