"Dates doesn't speak on his own authority. He takes us to the authority of God expressed in Scripture to demonstrate how the wrongful tearing apart of righteousness and justice within much of the church has also torn us apart." — Beth Moore, founder and president of Living Proof MinistriesJustice is God's Righteousness in ActionReclaim what was always meant to be whole. Justice and righteousness are not opposing forces but inseparable pilla...

All of today’s mainstream database products support the SQL language, and relational theory is what SQL is supposed to be based on. But are those products truly relational? Sadly, the answer is no. This book shows you what a real relational product would be like, and how and why it would be so much better than what’s currently available.With this unique book, you will:Learn how to see database systems as programming systemsGet a careful, precise, and detaile...

This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the work that goes on in the computing world today. Database in Depth: The Relational Model for Practitioners goes beyond the hype and gets to the heart of how relational databases actually work.Ideal for experienced database developers and designers, this concise guide gives you a clear view of the technology--a view tha...

What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in ways practitioners can understand—drawing on lessons learned over four decades of experience to demonstrate why proper database design is so critical in the first place.Every chapter includes...

Create database designs that scale, meet business requirements, and inherently work toward keeping your data structured and usable in the face of changing business models and software systems.This book is about database design theory. Design theory is the scientific foundation for database design, just as the relational model is the scientific foundation for database technology in general. Databases lie at the heart of so much of what we do in the computing world that negative impa...

SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put that theory into practice. In this book, Chris Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it to your use of SQL.This third edition has been revised, extended, and improved throughout. Topics whose treatment has been expanded include data types and domains, table compari...

Most evangelical Christians believe that those people who are not saved before they die will be punished in hell forever. But is this what the Bible truly teaches? Do Christians need to rethink their understanding of hell? In the late twentieth century, a growing number of evangelical theologians, biblical scholars, and philosophers began to reject the traditional doctrine of eternal conscious torment in hell in favor of a minority theological perspective called conditional immortality. Th...

No matter what DBMS you are using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can always arise over the precise meanings of terms, misunderstandings that can have a serious effect on the success of your database projects. For example, here are some common database terms: attribute, BCNF, consistency, denormalization, predicate, repeating group, join dependency. Do you know what they all mean? Are you sure?...

Type inheritance is that phenomenon according to which we can say, for example, that every square is also a rectangle, and so properties that apply to rectangles in general apply to squares in particular. In other words, squares are a subtype of rectangles, and rectangles are a supertype of squares. Recognizing and acting upon such subtype / supertype relationships provides numerous benefits: Certainly it can help in data modeling, and it can also provide for code reuse in applications. Fo...

United in their commitment to faithful orthodoxy, scholars on both sides of this controversial doctrine invite you to consider a question central to understanding God's justice: What is the true nature of hell?Throughout history, most Christians have believed that the lost will endure eternal suffering in hell. In recent decades, however, a growing number of evangelicals have questioned this view and embraced alternatives such as conditional immortality (a...

Views are virtual tables. That means they should be updatable, just as "real" or base tables are. In fact, view updatability isn’t just desirable, it’s crucial, for practical reasons as well as theoretical ones. But view updating has always been a controversial topic. Ever since the relational model first appeared, there has been widespread skepticism as to whether (in general) view updating is even possible.In stark contrast to this conventional wisdom, this book...

Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data. Traditionally, database management systems provide little or no special support for temporal data at all. This situation is changing because: - Cheap storage enables retention of large volumes of historical data in data warehouses - Users are now faced with temporal data problems, and need solutions - Temp...