An introduction to databases with web applications:
Gespeichert in:
1. Verfasser: | |
---|---|
Format: | Buch |
Sprache: | English |
Veröffentlicht: |
Harlow; München [u.a.]
Pearson Prentice Hall
2008
|
Ausgabe: | 1. publ. |
Schlagworte: | |
Online-Zugang: | Inhaltsverzeichnis |
Beschreibung: | Literaturverz. S. 675 - 680 |
Beschreibung: | XVII, 689 S. graph. Darst. 24 cm |
ISBN: | 9780321263599 |
Internformat
MARC
LEADER | 00000nam a2200000 c 4500 | ||
---|---|---|---|
001 | BV035119694 | ||
003 | DE-604 | ||
005 | 20081202 | ||
007 | t | ||
008 | 081027s2008 d||| |||| 00||| eng d | ||
015 | |a GBA765203 |2 dnb | ||
020 | |a 9780321263599 |9 978-0-321-26359-9 | ||
035 | |a (OCoLC)228418939 | ||
035 | |a (DE-599)OBVAC06612285 | ||
040 | |a DE-604 |b ger |e aacr | ||
041 | 0 | |a eng | |
049 | |a DE-92 |a DE-739 | ||
050 | 0 | |a QA76.9.W43 | |
084 | |a ST 252 |0 (DE-625)143627: |2 rvk | ||
100 | 1 | |a Prigmore, Martyn |e Verfasser |4 aut | |
245 | 1 | 0 | |a An introduction to databases with web applications |c Martyn Prigmore |
250 | |a 1. publ. | ||
264 | 1 | |a Harlow; München [u.a.] |b Pearson Prentice Hall |c 2008 | |
300 | |a XVII, 689 S. |b graph. Darst. |c 24 cm | ||
336 | |b txt |2 rdacontent | ||
337 | |b n |2 rdamedia | ||
338 | |b nc |2 rdacarrier | ||
500 | |a Literaturverz. S. 675 - 680 | ||
650 | 4 | |a Web services | |
650 | 0 | 7 | |a Web Services |0 (DE-588)4691234-4 |2 gnd |9 rswk-swf |
689 | 0 | 0 | |a Web Services |0 (DE-588)4691234-4 |D s |
689 | 0 | |5 DE-604 | |
856 | 4 | 2 | |m Digitalisierung UB Passau - ADAM Catalogue Enrichment |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016787383&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
999 | |a oai:aleph.bib-bvb.de:BVB01-016787383 |
Datensatz im Suchindex
_version_ | 1804138096918265856 |
---|---|
adam_text | Brief contents Preface 1 The web database environment xv 1 2 Network, database and web technology 29 3 Data models 77 4 Web database Implementation 133 5 Introduction to the SQL data language 187 6 More features of the SQL data language 228 7 Further issues in web database implementation 276 8 Conceptual database design 346 9 Logical database design 406 10 Physical database design 470 11 Web data design 531 12 XML 559 Appendix A The Pennine University’s Staff Directory case study 636 Appendix В The Pennine University’s Web Timetable case study 652 Glossary 655 References and bibliography 675 Index 681 vii
Contents Preface Aims of the book How to use this book Thanks Acknowledgements 1 2 The web database environment xv xv xvi xvii xvii 1 Chapter objectives Chapter outline 1.1 Developing information systems 1.2 Case studies of information systems 1.2.1 The Staff Directory case study 1.3 Business rules 1.4 Databases and database technology 1.5 The Web and web technology 1.6 Web database applications 1.6.1 Data duplication 1.6.2 Program - data dependence 1.6.3 Fixed queries 1.6.4 Data integrity 1.6.5 Concurrent access 1.7 Roles Chapter summary Further reading Review questions Exercises Investigations 1 1 2 5 6 8 9 13 18 21 21 22 23 24 24 26 26 27 28 28 Network, database and web technology 29 Chapter objectives Chapter outline 2.1 Client-server computing 2.2 Networks, interconnected networks and the Internet 2.3 Database technology 2.4 Web technology 2.5 Web database applications 29 29 30 32 43 57 71 IX
Chapter summary Further reading Review questions Exercises Investigations 73 73 74 75 75 Data models 77 Chapter objectives Chapter outline 3.1 Representing data items 3.2 The relational data model 3.2.1 Organizing data in the relational data model 3.2.2 Integrity constraints in the relational data model 3.2.3 Relational data languages 3.3 Semistructured data models and XML 3.3.1 Organizing data in XML 3.3.2 Integrity constraints in XML 3.3.3 Data languages for XML 3.3.4 Some comments on XML as a data model Chapter summary Further reading Review questions Exercises Investigations 77 77 79 87 88 93 102 110 113 122 123 127 128 129 130 131 131 Web database implementation 133 Chapter objectives Chapter outline 4.1 Gathering user input with HTML forms 4.2 Introduction to PHP 4.3 Handling user input in PHP 4.4 PHP and the MySQL DBMS 4.4.1 Querying the database instance 4.4.2 Handling DBMS communication errors 4.4.3 Modifying the database instance Chapter summary Further reading Review questions Exercises Investigations 133 133 135 140 147 162 162 174 178 182 182 183 184 186 Introduction to the SQL data language 187 Chapter objectives Chapter outline 5.1 SQL queries: the basic select statement 5.2 The where clause 5.3 Modifying the database instance with SQL DML 187 187 188 195 204
Contents 6 7 8 5.4 Creating, and removing, databases and tables with SQL DDL 5.5 Altering tables with SQL DDL Chapter summary Further reading Review questions Exercises Investigations 207 214 222 222 222 223 226 More features of the SQL data language 228 Chapter objectives Chapter outline 6.1 Joining data from two or more tables 6.2 SQL built-in value functions 6.3 Aggregate queries 6.4 Subqueries 6.5 Views Chapter summary Further reading Review questions Exercises Investigations 228 228 229 243 252 261 267 271 271 272 272 275 Further issues in web databaseimplementation 276 Chapter objectives Chapter outline 7.1 Error reporting and debugging 7.2 Managing large result sets 7.3 Single script database modifications anddata validation 7.4 The reload problem 7.5 Gathering complex data using wizards 7.6 Managing application state with sessions 7.7 Identifying and authenticating users 7.7.1 Gathering registration data 7.7.2 Controlling HTTP authenticationwith PHP Chapter summary Further reading Review questions Exercises Investigations 276 276 278 284 290 304 309 319 328 329 334 342 342 343 343 345 Conceptual database design 346 Chapter objectives Chapter outline 8.1 The database design process 8.2 Introduction to entity-relationship (ER) diagrams 8.3 Attributes 346 346 348 350 357 xi
9 8.4 8.5 8.6 Entities Associations Association multiplicity constraints 8.6.1 Multiplicity constraints in the UML 8.6.2 Other approaches to association multiplicity 8.7 Generalization relationships 8.8 Validating an ER diagram 8.8.1 Missing associations and connection traps 8.8.2 Redundant associations 8.8.3 Access path analysis Chapter summary Further reading Review questions Exercises Investigations 361 368 375 376 386 390 395 396 399 400 402 402 403 404 405 Logical database design 406 Chapter objectives Chapter outline 9.1 Introducing logical database design 9.2 Logical ER diagrams 9.2.1 How to deal with multivalued attributes 9.2.2 Resolving a many-to-many association 9.2.3 Replace n-ary associations 9.3 The process of relational database design 9.3.1 Create a logical ER diagram 9.3.2 Write down table schema 9.4 Normalization Chapter summary Further reading Review questions Exercises Investigations 406 406 407 414 416 421 427 430 431 432 446 464 465 465 465 468 10 Physical database design Chapter objectives Chapter outline 10.1 Physical table designs 10.1.1 Datatypes 10.1.2 Derived attributes 10.1.3 Business rules 10.1.4 SOL statements as physical table designs 10.2 Analysing database usage and performance 10.2.1 Analysing data storage requirements 10.2.2 Entity transaction matrices 10.2.3 Transaction path analysis and transaction workloads 470 - 470 470 472 472 475 480 481 484 485 487 488
Contents 10.3 General issues in physical database design 10.3.1 Surrogate keys 10.3.2 Binary data 10.3.3 Controlled redundancy 10.3.4 Structured codes and missing attributes 10.3.5 Dealing with a surfeit of nulls 10.3.6 Writing efficient SQL queries 10.4 Designing data storage 10.4.1 Datafiles 10.4.2 Indexes 10.4.3 Storage engines 10.5 Security Chapter summary Further reading Review questions Exercises Investigations 11 Web data design Chapter objectives Chapter outline 11.1 Conceptual web data design 11.2 Logical web data design 11.3 Physical web data design Chapter summary Further reading Review questions Exercises Investigations 12 XML Chapter objectives Chapter outline 12.1 XML Namespaces 12.2 RELAX NG: a schema language for XML 12.2.1 Basic patterns 12.2.2 Complex patterns 12.2.3 Datatype libraries 12.2.4 A schema for the Staff Directory document model 12.2.5 Checking relational-style candidate and foreign key constraints 12.3 An introduction to XPath 12.4 Designing XML databases Chapter summary Further reading Review questions Exercises Investigations 491 492 494 495 499 502 504 507 507 510 519 520 525 526 526 527 530 531 531 531 534 543 550 556 556 556 557 558 559 559 559 560 567 570 575 584 586 595 601 611 630 631 631 632 634
Contents XIV Appendix A The Pennine University’s Staff Directory case study 636 A.1 Requirements A.2 Deriving the ER diagram from the use casespecifications A.2.1 Identify and document entities and attributes A.2.2 Identify and document relationships betweenentities A. 3 Database creation script 636 640 640 641 646 Appendix В The Pennine University’s Web Timetable case study 652 B. 1 Requirements 652 Glossary 655 References and bibliography 675 Index 681
|
adam_txt |
Brief contents Preface 1 The web database environment xv 1 2 Network, database and web technology 29 3 Data models 77 4 Web database Implementation 133 5 Introduction to the SQL data language 187 6 More features of the SQL data language 228 7 Further issues in web database implementation 276 8 Conceptual database design 346 9 Logical database design 406 10 Physical database design 470 11 Web data design 531 12 XML 559 Appendix A The Pennine University’s Staff Directory case study 636 Appendix В The Pennine University’s Web Timetable case study 652 Glossary 655 References and bibliography 675 Index 681 vii
Contents Preface Aims of the book How to use this book Thanks Acknowledgements 1 2 The web database environment xv xv xvi xvii xvii 1 Chapter objectives Chapter outline 1.1 Developing information systems 1.2 Case studies of information systems 1.2.1 The Staff Directory case study 1.3 Business rules 1.4 Databases and database technology 1.5 The Web and web technology 1.6 Web database applications 1.6.1 Data duplication 1.6.2 Program - data dependence 1.6.3 Fixed queries 1.6.4 Data integrity 1.6.5 Concurrent access 1.7 Roles Chapter summary Further reading Review questions Exercises Investigations 1 1 2 5 6 8 9 13 18 21 21 22 23 24 24 26 26 27 28 28 Network, database and web technology 29 Chapter objectives Chapter outline 2.1 Client-server computing 2.2 Networks, interconnected networks and the Internet 2.3 Database technology 2.4 Web technology 2.5 Web database applications 29 29 30 32 43 57 71 IX
Chapter summary Further reading Review questions Exercises Investigations 73 73 74 75 75 Data models 77 Chapter objectives Chapter outline 3.1 Representing data items 3.2 The relational data model 3.2.1 Organizing data in the relational data model 3.2.2 Integrity constraints in the relational data model 3.2.3 Relational data languages 3.3 Semistructured data models and XML 3.3.1 Organizing data in XML 3.3.2 Integrity constraints in XML 3.3.3 Data languages for XML 3.3.4 Some comments on XML as a data model Chapter summary Further reading Review questions Exercises Investigations 77 77 79 87 88 93 102 110 113 122 123 127 128 129 130 131 131 Web database implementation 133 Chapter objectives Chapter outline 4.1 Gathering user input with HTML forms 4.2 Introduction to PHP 4.3 Handling user input in PHP 4.4 PHP and the MySQL DBMS 4.4.1 Querying the database instance 4.4.2 Handling DBMS communication errors 4.4.3 Modifying the database instance Chapter summary Further reading Review questions Exercises Investigations 133 133 135 140 147 162 162 174 178 182 182 183 184 186 Introduction to the SQL data language 187 Chapter objectives Chapter outline 5.1 SQL queries: the basic select statement 5.2 The where clause 5.3 Modifying the database instance with SQL DML 187 187 188 195 204
Contents 6 7 8 5.4 Creating, and removing, databases and tables with SQL DDL 5.5 Altering tables with SQL DDL Chapter summary Further reading Review questions Exercises Investigations 207 214 222 222 222 223 226 More features of the SQL data language 228 Chapter objectives Chapter outline 6.1 Joining data from two or more tables 6.2 SQL built-in value functions 6.3 Aggregate queries 6.4 Subqueries 6.5 Views Chapter summary Further reading Review questions Exercises Investigations 228 228 229 243 252 261 267 271 271 272 272 275 Further issues in web databaseimplementation 276 Chapter objectives Chapter outline 7.1 Error reporting and debugging 7.2 Managing large result sets 7.3 Single script database modifications anddata validation 7.4 The reload problem 7.5 Gathering complex data using wizards 7.6 Managing application state with sessions 7.7 Identifying and authenticating users 7.7.1 Gathering registration data 7.7.2 Controlling HTTP authenticationwith PHP Chapter summary Further reading Review questions Exercises Investigations 276 276 278 284 290 304 309 319 328 329 334 342 342 343 343 345 Conceptual database design 346 Chapter objectives Chapter outline 8.1 The database design process 8.2 Introduction to entity-relationship (ER) diagrams 8.3 Attributes 346 346 348 350 357 xi
9 8.4 8.5 8.6 Entities Associations Association multiplicity constraints 8.6.1 Multiplicity constraints in the UML 8.6.2 Other approaches to association multiplicity 8.7 Generalization relationships 8.8 Validating an ER diagram 8.8.1 Missing associations and connection traps 8.8.2 Redundant associations 8.8.3 Access path analysis Chapter summary Further reading Review questions Exercises Investigations 361 368 375 376 386 390 395 396 399 400 402 402 403 404 405 Logical database design 406 Chapter objectives Chapter outline 9.1 Introducing logical database design 9.2 Logical ER diagrams 9.2.1 How to deal with multivalued attributes 9.2.2 Resolving a many-to-many association 9.2.3 Replace n-ary associations 9.3 The process of relational database design 9.3.1 Create a logical ER diagram 9.3.2 Write down table schema 9.4 Normalization Chapter summary Further reading Review questions Exercises Investigations 406 406 407 414 416 421 427 430 431 432 446 464 465 465 465 468 10 Physical database design Chapter objectives Chapter outline 10.1 Physical table designs 10.1.1 Datatypes 10.1.2 Derived attributes 10.1.3 Business rules 10.1.4 SOL statements as physical table designs 10.2 Analysing database usage and performance 10.2.1 Analysing data storage requirements 10.2.2 Entity transaction matrices 10.2.3 Transaction path analysis and transaction workloads 470 - 470 470 472 472 475 480 481 484 485 487 488
Contents 10.3 General issues in physical database design 10.3.1 Surrogate keys 10.3.2 Binary data 10.3.3 Controlled redundancy 10.3.4 Structured codes and missing attributes 10.3.5 Dealing with a surfeit of nulls 10.3.6 Writing efficient SQL queries 10.4 Designing data storage 10.4.1 Datafiles 10.4.2 Indexes 10.4.3 Storage engines 10.5 Security Chapter summary Further reading Review questions Exercises Investigations 11 Web data design Chapter objectives Chapter outline 11.1 Conceptual web data design 11.2 Logical web data design 11.3 Physical web data design Chapter summary Further reading Review questions Exercises Investigations 12 XML Chapter objectives Chapter outline 12.1 XML Namespaces 12.2 RELAX NG: a schema language for XML 12.2.1 Basic patterns 12.2.2 Complex patterns 12.2.3 Datatype libraries 12.2.4 A schema for the Staff Directory document model 12.2.5 Checking relational-style candidate and foreign key constraints 12.3 An introduction to XPath 12.4 Designing XML databases Chapter summary Further reading Review questions Exercises Investigations 491 492 494 495 499 502 504 507 507 510 519 520 525 526 526 527 530 531 531 531 534 543 550 556 556 556 557 558 559 559 559 560 567 570 575 584 586 595 601 611 630 631 631 632 634
Contents XIV Appendix A The Pennine University’s Staff Directory case study 636 A.1 Requirements A.2 Deriving the ER diagram from the use casespecifications A.2.1 Identify and document entities and attributes A.2.2 Identify and document relationships betweenentities A. 3 Database creation script 636 640 640 641 646 Appendix В The Pennine University’s Web Timetable case study 652 B. 1 Requirements 652 Glossary 655 References and bibliography 675 Index 681 |
any_adam_object | 1 |
any_adam_object_boolean | 1 |
author | Prigmore, Martyn |
author_facet | Prigmore, Martyn |
author_role | aut |
author_sort | Prigmore, Martyn |
author_variant | m p mp |
building | Verbundindex |
bvnumber | BV035119694 |
callnumber-first | Q - Science |
callnumber-label | QA76 |
callnumber-raw | QA76.9.W43 |
callnumber-search | QA76.9.W43 |
callnumber-sort | QA 276.9 W43 |
callnumber-subject | QA - Mathematics |
classification_rvk | ST 252 |
ctrlnum | (OCoLC)228418939 (DE-599)OBVAC06612285 |
discipline | Informatik |
discipline_str_mv | Informatik |
edition | 1. publ. |
format | Book |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01388nam a2200373 c 4500</leader><controlfield tag="001">BV035119694</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20081202 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">081027s2008 d||| |||| 00||| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBA765203</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780321263599</subfield><subfield code="9">978-0-321-26359-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)228418939</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)OBVAC06612285</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-92</subfield><subfield code="a">DE-739</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.W43</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 252</subfield><subfield code="0">(DE-625)143627:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Prigmore, Martyn</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">An introduction to databases with web applications</subfield><subfield code="c">Martyn Prigmore</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. publ.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Harlow; München [u.a.]</subfield><subfield code="b">Pearson Prentice Hall</subfield><subfield code="c">2008</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVII, 689 S.</subfield><subfield code="b">graph. Darst.</subfield><subfield code="c">24 cm</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="500" ind1=" " ind2=" "><subfield code="a">Literaturverz. S. 675 - 680</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Web services</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Web Services</subfield><subfield code="0">(DE-588)4691234-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Web Services</subfield><subfield code="0">(DE-588)4691234-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Passau - ADAM Catalogue Enrichment</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016787383&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-016787383</subfield></datafield></record></collection> |
id | DE-604.BV035119694 |
illustrated | Illustrated |
index_date | 2024-07-02T22:20:54Z |
indexdate | 2024-07-09T21:22:46Z |
institution | BVB |
isbn | 9780321263599 |
language | English |
oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-016787383 |
oclc_num | 228418939 |
open_access_boolean | |
owner | DE-92 DE-739 |
owner_facet | DE-92 DE-739 |
physical | XVII, 689 S. graph. Darst. 24 cm |
publishDate | 2008 |
publishDateSearch | 2008 |
publishDateSort | 2008 |
publisher | Pearson Prentice Hall |
record_format | marc |
spelling | Prigmore, Martyn Verfasser aut An introduction to databases with web applications Martyn Prigmore 1. publ. Harlow; München [u.a.] Pearson Prentice Hall 2008 XVII, 689 S. graph. Darst. 24 cm txt rdacontent n rdamedia nc rdacarrier Literaturverz. S. 675 - 680 Web services Web Services (DE-588)4691234-4 gnd rswk-swf Web Services (DE-588)4691234-4 s DE-604 Digitalisierung UB Passau - ADAM Catalogue Enrichment application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016787383&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
spellingShingle | Prigmore, Martyn An introduction to databases with web applications Web services Web Services (DE-588)4691234-4 gnd |
subject_GND | (DE-588)4691234-4 |
title | An introduction to databases with web applications |
title_auth | An introduction to databases with web applications |
title_exact_search | An introduction to databases with web applications |
title_exact_search_txtP | An introduction to databases with web applications |
title_full | An introduction to databases with web applications Martyn Prigmore |
title_fullStr | An introduction to databases with web applications Martyn Prigmore |
title_full_unstemmed | An introduction to databases with web applications Martyn Prigmore |
title_short | An introduction to databases with web applications |
title_sort | an introduction to databases with web applications |
topic | Web services Web Services (DE-588)4691234-4 gnd |
topic_facet | Web services Web Services |
url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016787383&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
work_keys_str_mv | AT prigmoremartyn anintroductiontodatabaseswithwebapplications |