With this insightful book, you’ll learn from the best data practitioners in the field just how wide-ranging — and beautiful — working with data can be. Join 39 contributors as they explain how they developed simple and elegant solutions on projects ranging from the Mars lander to a Radiohead video.
With a focus on proper database design, Databases: A Beginner’s Guide provides an introduction to Structured Query Language (SQL) and Microsoft Access. The book covers key topics such as security, data warehouse and data mart design techniques, storing complex data such as XML documents, and connecting databases to applications. Written by a database technology instructor and bestselling author, this book offers a proven, self-paced technique for learning how to design, implement, maintain, and use databases. You can follow clear examples and step-by-step instructions that cover the fundamental concepts and demonstrate how to effectively apply them.
Date on Database: Writings 2000 2006 captures some of the freshest thinking from widely known and respected relational database pioneer C. J. Date. Known for his tenacious defense of relational theory in its purest form, Date tackles many topics that are important to database professionals, including the difference between model and implementation, data integrity, data redundancy, deviations in SQL from the relational model, and much more.
This book places a strong emphasis on good design practice, allowing readers to master design methodology in an accessible, step-by-step fashion. In this book, database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice. Extensive treatment of the Web as an emerging platform for database applications is covered alongside many code samples for accessing databases from the Web including JDBC, SQLJ, ASP, ISP, and Oracle’s PSP. A thorough update of later chapters covering object-oriented databases, Web databases, XML, data warehousing, data mining is included in this new edition. A clear introduction to design implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable, complete reference for database professionals.
Want to know how the best software engineers and architects structure their applications to make them scalable, reliable, and maintainable in the long term? This book examines the key principles, algorithms, and trade-offs of data systems, using the internals of various popular software packages and frameworks as examples.