Design-by-example: a design tool for relational databases:
In recent years, research in relational design theory and in query optimization has established a firm ground for designing well-structured logical and physical database schemes. However, the design process prequires mastering a considerable amount of theoretical results. Furthermore, even for the i...
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Ithaca, NY
1985
|
| Schriftenreihe: | Cornell University <Ithaca, NY> / Dep. of Computer Science: Technical report
692. |
| Schlagworte: | |
| Zusammenfassung: | In recent years, research in relational design theory and in query optimization has established a firm ground for designing well-structured logical and physical database schemes. However, the design process prequires mastering a considerable amount of theoretical results. Furthermore, even for the initiated database designer, many of the known algorithms for logical design do not provide constructive guidelines for generating a database scheme that would prevent update anomalies and data inconsistencies. Nor do the algorithms and evaluation methods for file structures and query processing provide constructive physical design rules We propose an expert tool that would make knowledge in relational design theory and query optimization automatically and transparently available to the database designer. This tool is a system with an interactive, graphical interface that uses examples to guide the designer through several phases of logical and physical database design. Logical design is based on example relations, and physical design on example queries. The example relations are automatically generated by the system. They contain sample data and satisfy the data dependencies that the designer specifies with the assistance of the expert tool. The example queries and their expected frequency are specified by the designer, using graphically displayed skeleton queries. The system generates a physical design scheme that optimizes the mix of queries expected by the designer, and computes a performance forecast. Both example relations and example queries can be modified by the designer, until the expert tool generates a satisfactory design |
| Beschreibung: | 25 S. |
Internformat
MARC
| LEADER | 00000nam a2200000 cb4500 | ||
|---|---|---|---|
| 001 | BV006527922 | ||
| 003 | DE-604 | ||
| 007 | t| | ||
| 008 | 930210s1985 xx |||| 00||| eng d | ||
| 035 | |a (OCoLC)16650242 | ||
| 035 | |a (DE-599)BVBBV006527922 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-91G | ||
| 100 | 1 | |a Bitton, Dina |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Design-by-example: a design tool for relational databases |c Dina Bitton ; Heikki Mannila ; Kari-Jouko Räihä |
| 264 | 1 | |a Ithaca, NY |c 1985 | |
| 300 | |a 25 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 1 | |a Cornell University <Ithaca, NY> / Dep. of Computer Science: Technical report |v 692. | |
| 520 | 3 | |a In recent years, research in relational design theory and in query optimization has established a firm ground for designing well-structured logical and physical database schemes. However, the design process prequires mastering a considerable amount of theoretical results. Furthermore, even for the initiated database designer, many of the known algorithms for logical design do not provide constructive guidelines for generating a database scheme that would prevent update anomalies and data inconsistencies. Nor do the algorithms and evaluation methods for file structures and query processing provide constructive physical design rules | |
| 520 | 3 | |a We propose an expert tool that would make knowledge in relational design theory and query optimization automatically and transparently available to the database designer. This tool is a system with an interactive, graphical interface that uses examples to guide the designer through several phases of logical and physical database design. Logical design is based on example relations, and physical design on example queries. The example relations are automatically generated by the system. They contain sample data and satisfy the data dependencies that the designer specifies with the assistance of the expert tool. The example queries and their expected frequency are specified by the designer, using graphically displayed skeleton queries. The system generates a physical design scheme that optimizes the mix of queries expected by the designer, and computes a performance forecast. Both example relations and example queries can be modified by the designer, until the expert tool generates a satisfactory design | |
| 650 | 4 | |a Computer-aided design | |
| 650 | 4 | |a Database management | |
| 650 | 4 | |a Expert systems (Computer science) | |
| 700 | 1 | |a Mannila, Heikki |e Verfasser |4 aut | |
| 700 | 1 | |a Räihä, Kari-Jouko |e Verfasser |4 aut | |
| 810 | 2 | |a Dep. of Computer Science: Technical report |t Cornell University <Ithaca, NY> |v 692. |w (DE-604)BV006185504 |9 692 | |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-004157538 | |
Datensatz im Suchindex
| _version_ | 1820882584304877568 |
|---|---|
| adam_text | |
| any_adam_object | |
| author | Bitton, Dina Mannila, Heikki Räihä, Kari-Jouko |
| author_facet | Bitton, Dina Mannila, Heikki Räihä, Kari-Jouko |
| author_role | aut aut aut |
| author_sort | Bitton, Dina |
| author_variant | d b db h m hm k j r kjr |
| building | Verbundindex |
| bvnumber | BV006527922 |
| classification_rvk | SS 4570 |
| ctrlnum | (OCoLC)16650242 (DE-599)BVBBV006527922 |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000 cb4500</leader><controlfield tag="001">BV006527922</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">930210s1985 xx |||| 00||| eng d</controlfield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)16650242</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV006527922</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91G</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Bitton, Dina</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Design-by-example: a design tool for relational databases</subfield><subfield code="c">Dina Bitton ; Heikki Mannila ; Kari-Jouko Räihä</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Ithaca, NY</subfield><subfield code="c">1985</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">25 S.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Cornell University <Ithaca, NY> / Dep. of Computer Science: Technical report</subfield><subfield code="v">692.</subfield></datafield><datafield tag="520" ind1="3" ind2=" "><subfield code="a">In recent years, research in relational design theory and in query optimization has established a firm ground for designing well-structured logical and physical database schemes. However, the design process prequires mastering a considerable amount of theoretical results. Furthermore, even for the initiated database designer, many of the known algorithms for logical design do not provide constructive guidelines for generating a database scheme that would prevent update anomalies and data inconsistencies. Nor do the algorithms and evaluation methods for file structures and query processing provide constructive physical design rules</subfield></datafield><datafield tag="520" ind1="3" ind2=" "><subfield code="a">We propose an expert tool that would make knowledge in relational design theory and query optimization automatically and transparently available to the database designer. This tool is a system with an interactive, graphical interface that uses examples to guide the designer through several phases of logical and physical database design. Logical design is based on example relations, and physical design on example queries. The example relations are automatically generated by the system. They contain sample data and satisfy the data dependencies that the designer specifies with the assistance of the expert tool. The example queries and their expected frequency are specified by the designer, using graphically displayed skeleton queries. The system generates a physical design scheme that optimizes the mix of queries expected by the designer, and computes a performance forecast. Both example relations and example queries can be modified by the designer, until the expert tool generates a satisfactory design</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Computer-aided design</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Expert systems (Computer science)</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Mannila, Heikki</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Räihä, Kari-Jouko</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="810" ind1="2" ind2=" "><subfield code="a">Dep. of Computer Science: Technical report</subfield><subfield code="t">Cornell University <Ithaca, NY></subfield><subfield code="v">692.</subfield><subfield code="w">(DE-604)BV006185504</subfield><subfield code="9">692</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-004157538</subfield></datafield></record></collection> |
| id | DE-604.BV006527922 |
| illustrated | Not Illustrated |
| indexdate | 2025-01-10T17:09:13Z |
| institution | BVB |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-004157538 |
| oclc_num | 16650242 |
| open_access_boolean | |
| owner | DE-91G DE-BY-TUM |
| owner_facet | DE-91G DE-BY-TUM |
| physical | 25 S. |
| publishDate | 1985 |
| publishDateSearch | 1985 |
| publishDateSort | 1985 |
| record_format | marc |
| series2 | Cornell University <Ithaca, NY> / Dep. of Computer Science: Technical report |
| spelling | Bitton, Dina Verfasser aut Design-by-example: a design tool for relational databases Dina Bitton ; Heikki Mannila ; Kari-Jouko Räihä Ithaca, NY 1985 25 S. txt rdacontent n rdamedia nc rdacarrier Cornell University <Ithaca, NY> / Dep. of Computer Science: Technical report 692. In recent years, research in relational design theory and in query optimization has established a firm ground for designing well-structured logical and physical database schemes. However, the design process prequires mastering a considerable amount of theoretical results. Furthermore, even for the initiated database designer, many of the known algorithms for logical design do not provide constructive guidelines for generating a database scheme that would prevent update anomalies and data inconsistencies. Nor do the algorithms and evaluation methods for file structures and query processing provide constructive physical design rules We propose an expert tool that would make knowledge in relational design theory and query optimization automatically and transparently available to the database designer. This tool is a system with an interactive, graphical interface that uses examples to guide the designer through several phases of logical and physical database design. Logical design is based on example relations, and physical design on example queries. The example relations are automatically generated by the system. They contain sample data and satisfy the data dependencies that the designer specifies with the assistance of the expert tool. The example queries and their expected frequency are specified by the designer, using graphically displayed skeleton queries. The system generates a physical design scheme that optimizes the mix of queries expected by the designer, and computes a performance forecast. Both example relations and example queries can be modified by the designer, until the expert tool generates a satisfactory design Computer-aided design Database management Expert systems (Computer science) Mannila, Heikki Verfasser aut Räihä, Kari-Jouko Verfasser aut Dep. of Computer Science: Technical report Cornell University <Ithaca, NY> 692. (DE-604)BV006185504 692 |
| spellingShingle | Bitton, Dina Mannila, Heikki Räihä, Kari-Jouko Design-by-example: a design tool for relational databases Computer-aided design Database management Expert systems (Computer science) |
| title | Design-by-example: a design tool for relational databases |
| title_auth | Design-by-example: a design tool for relational databases |
| title_exact_search | Design-by-example: a design tool for relational databases |
| title_full | Design-by-example: a design tool for relational databases Dina Bitton ; Heikki Mannila ; Kari-Jouko Räihä |
| title_fullStr | Design-by-example: a design tool for relational databases Dina Bitton ; Heikki Mannila ; Kari-Jouko Räihä |
| title_full_unstemmed | Design-by-example: a design tool for relational databases Dina Bitton ; Heikki Mannila ; Kari-Jouko Räihä |
| title_short | Design-by-example: a design tool for relational databases |
| title_sort | design by example a design tool for relational databases |
| topic | Computer-aided design Database management Expert systems (Computer science) |
| topic_facet | Computer-aided design Database management Expert systems (Computer science) |
| volume_link | (DE-604)BV006185504 |
| work_keys_str_mv | AT bittondina designbyexampleadesigntoolforrelationaldatabases AT mannilaheikki designbyexampleadesigntoolforrelationaldatabases AT raihakarijouko designbyexampleadesigntoolforrelationaldatabases |