Creating and Maintaining a Database Systems Textbook

Creating and Maintaining a Database Systems Textbook Presented by Carolyn Begg School of Computing Paisley University Scotland Overview of Presentation • To demonstrate the main features of a textbook called – Database Systems: A Practical Approach to the Design, Implementation and Management by T. Connolly and C. Begg. • To identify the factors that led to the creation of the this book. • To describe the process of maintaining this book. Database Systems: A Practical Approach to the Design, Implementation and Management • 1st edition published 1995. Latest is 4th edition published 2005. Book is on a 3 year cycle of revision. • Size of text has grown from 1st edition at 839 pages to 4th edition at 1374 pages. • Instructor’s Guide has accompanied textbook since 1st edition. Available on companion website since 3rd edition. • Translated into 9 languages. Creating & Maintaining a Database Textbook New Database Systems Textbook Establish Content of Database Systems Textbook Need to update Database Systems Textbook New Edition of Database Systems Textbook Publish Database Systems Textbook Creating & Maintaining a Database Textbook Perceived ‘gap’ in market Publisher seeking new product Establish Content of Database Systems Textbook Need to update Database Systems Textbook New Edition of Database Systems Textbook New careers emerging New Database Systems Textbook Increasing number of users Filling the ‘gap’ Database design methodology Authors’ motivation More practical coverage More ‘realistic’ case studies Publish Database Systems Textbook Factors Driving Creation of New Database Systems Textbook Perceived ‘gap’ in market Publisher seeking new product New careers emerging New Database Systems Textbook Increasing number of users Filling the ‘gap’ Database design methodology Authors’ motivation More practical coverage More ‘realistic’ case studies • In mid-1990s, database systems growing in popularity. • Two main textbooks were by Elmasri and Navanthe; Date • Perceived ‘gap’ in the market. • Authors’ motivation to fill this ‘gap’. Creating & Maintaining a Database Textbook Publisher Competitor textbooks Industry Educational bodies New Database Systems Textbook Establish Content of Database Systems Textbook Need to update Database Systems Textbook Professional bodies New Edition of Database Systems Textbook Lecturers adopters and non-adopters Students Programmes at other institutions Publish Database Systems Textbook Factors Affecting Content of Database Systems Textbook Publisher Competitor textbooks Industry Establish Content of Database Systems Textbook Lecturers adopters and non-adopters Students Publish Database Systems Textbook • 1st edition influenced by competitor textbooks and Educational requirement to create Bodies e.g. IEEE, ACM appropriate textbook for our students. • Later editions influenced Professional through use and by Bodies e.g. BCS observing how database Programmes at other institutions systems taught at other institutions. Creating & Maintaining a Database Textbook Publisher Falling sales/ second-hand market Publication date / passage of time New Database Systems Textbook Establish Content of Database Systems Textbook Need to update Database Systems Textbook New Edition of Database Systems Textbook New developments in computing Competitor publishes book Publish Database Systems Textbook Factors Influencing Need to Update Database Systems Textbook Publisher Falling sales/ second-hand market Publication date / passage of time Need to update Database Systems Textbook • Greatest driver for updates is the Publisher. • Next is requirement to keep content up to date. • Web now supports the second-hand book market. New developments in computing Competitor publishes book Creating & Maintaining a Database Textbook Emerging / new standards New topics New software /new versions of software Adapt methodology New Database Systems Textbook Establish Content of Database Systems Textbook Need to update Database Systems Textbook New questions / exercises / case studies New Edition of Database Systems Textbook Data Cube New website Analysis resources Identify chapters/sections for Appendix Publish Database Systems Textbook Identify chapters/sections for website What’s New in Next Edition? Emerging / new standards New topics New software /new versions of software Adapt methodology New Edition of Database Systems Textbook New questions / exercises / case studies NewData Cube website Analysis resources Identify chapters/sections for Appendix • New material is added to content to reflect new or emerging developments. • Creating space for new material means that some established content must be moved to appendix / website. Identify chapters/sections for website Creating & Maintaining a Database Textbook New Database Systems Textbook Establish Content of Database Systems Textbook Need to update Database Systems Textbook New Edition of Database Systems Textbook Any Questions? Publish Database Systems Textbook