New answers tagged

1

You can look at the datasets used for TPC benchmarks. You can find the tools and instructions needed at http://www.tpc.org/tpc_documents_current_versions/current_specifications5.asp The advantages of the TPC benchmarks are: The data is generated and loaded by scripts. The schema is also created by SQL scripts (like you have asked). The size of the ...


1

Great question! I went through the same dilemma as you. After reading multiple perspectives on database normalization, I condensed my learning into the article at https://bkmjournal.wordpress.com/2010/07/29/database-normalization-as-i-remember-it/. One suggestion I have for you is to make students "measure" the cost of a denormalized schema by executing ...


1

I worked as a data modeler at Siebel. One of the books that the Siebel data model is based upon is Data Model Patterns by David C. Hay. The book will not teach you how to build great data models. It is a collection of robust data models that are used in big systems used world wide. The one book that I have used (in teaching) that focusses solely on data ...


1

Database Systems Concepts by Silberschatz, Korth and Sudarshan comes with a comprehensive instructor/student resources web site provided by the authors. You can find slides, assignments and even a web based tool to practice SQL at https://www.db-book.com/db7/index.html If you are an instructor in a qualified educational institution, you can contact the book ...


1

The text book I use for teaching database indexing is "Database Systems Concepts" by Silberschatz, Korth and Sudarshan. The book is regularly updated to keep pace with the multiple advances happening in the data management domain. The chapter on indexing in the book is good and has a few examples. You can get a feel for the examples from the slides made ...


Top 50 recent answers are included