Автор: C. J. Date Название: Database Design and Relational Theory ISBN: 1484255399 ISBN-13(EAN): 9781484255391 Издательство: Springer Рейтинг: Цена: 7685.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
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 impacts of poor design can be extraordinarily widespread.
This second edition includes greatly expanded coverage of exotic and little understood normal forms such as: essential tuple normal form (ETNF), redundancy free normal form (RFNF), superkey normal form (SKNF), sixth normal form (6NF), and domain key normal form (DKNF). Also included are new appendixes, including one that provides an in-depth look into the crucial notion of data consistency. Sequencing of topics has been improved, and many explanations and examples have been rewritten and clarified based upon the author’s teaching of the content in instructor-led courses.
This book aims to be different from other books on design by bridging the gap between the theory of design and the practice of design. The book explains theory in a way that practitioners should be able to understand, and it explains why that theory is of considerable practical importance. Reading this book provides you with an important theoretical grounding on which to do the practical work of database design. Reading the book also helps you in going to and understanding the more academic texts as you build your base of knowledge and expertise. Anyone with a professional interest in database design can benefit from using this book as a stepping-stone toward a more rigorous design approach and more lasting database models.
What You Will Learn
Understand what design theory is and is notBe aware of the two different goals of normalizationKnow which normal forms are truly significant Apply design theory in practice Be familiar with techniques for dealing with redundancy Understand what consistency is and why it is crucially important
Who This Book Is For
Those having a professional interest in database design, including data and database administrators; educators and students specializing in database matters; information modelers and database designers; DBMS designers, implementers, and other database vendor personnel; and database consultants. The book is product independent.
Автор: Chris Date Название: Fifty Years of Relational, and Other Database Writings ISBN: 1634628322 ISBN-13(EAN): 9781634628327 Издательство: Gazelle Book Services Рейтинг: Цена: 8792.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Fifty years of relational. Its hard to believe the relational model has been around now for over half a century! But it has -- it was born on 19 August 1969, when Codds first database paper was published. And Chris Date has been involved with it for almost the whole of that time, working closely with Codd for many years and publishing the very first, and definitive, book on the subject in 1975. In this books title essay, Chris offers his own unique perspective (two chapters) on those fifty years. No database professional can afford to miss this one of a kind history. But theres more to this book than just a little personal history. Another unique feature is an extensive and in depth discussion (nine chapters) of a variety of frequently asked questions on relational matters, covering such topics as mathematics and the relational model; relational algebra; predicates; relation valued attributes; keys and normalization; missing information; and the SQL language. Another part of the book offers detailed responses to critics (four chapters). Finally, the book also contains the text of several recent interviews with Chris Date, covering such matters as RM/V2, XML, NoSQL, The Third Manifesto, and how SQL came to dominate the database landscape.
Описание: Blockchain is a technology that transcends cryptocurrencies. There are other services in different sectors of the economy that can benefit from the trust and security that blockchains offer. For example, financial institutions are using blockchains for international money transfer, and in logistics, it has been used for supply chain management and tracking of goods. As more global companies and governments are experimenting and deploying blockchain solutions, it is necessary to compile knowledge on the best practices, strategies, and failures in order to create a better awareness of how blockchain could either support or add value to other services.
Cross-Industry Use of Blockchain Technology and Opportunities for the Future provides emerging research highlighting the possibilities inherent in blockchain for different sectors of the economy and the added value blockchain can provide for the future of these different sectors. Featuring coverage on a broad range of topics such as data privacy, information sharing, and digital identity, this book is ideally designed for IT specialists, consultants, design engineers, cryptographers, service designers, researchers, academics, government officials, and industry professionals.
Описание: This book introduces new logic primitives for electronic design automation tools. The author approaches fundamental EDA problems from a different, unconventional perspective, in order to demonstrate the key role of rethinking EDA solutions in overcoming technological limitations of present and future technologies. The author discusses techniques that improve the efficiency of logic representation, manipulation and optimization tasks by taking advantage of majority and biconditional logic primitives. Readers will be enabled to accelerate formal methods by studying core properties of logic circuits and developing new frameworks for logic reasoning engines.
Описание: Presents research highlighting the possibilities inherent in blockchain for different sectors of the economy and the added value blockchain can provide for the future of these different sectors. The book featuring coverage on a broad range of topics, including data privacy, information sharing, and digital identity.
Learn everything you need to know to build efficient SQL queries using this easy-to-follow beginner's guide
Key Features
Explore all SQL statements in depth using a variety of examples
Get to grips with database querying, data aggregate, manipulation, and much more
Understand how to explore and process data of varying complexity to tell a story
Book Description
SQL is a powerful querying language that's used to store, manipulate, and retrieve data, and it is one of the most popular languages used by developers to query and analyze data efficiently.
If you're looking for a comprehensive introduction to SQL, Learn SQL Database Programming will help you to get up to speed with using SQL to streamline your work in no time. Starting with an overview of relational database management systems, this book will show you how to set up and use MySQL Workbench and design a database using practical examples. You'll also discover how to query and manipulate data with SQL programming using MySQL Workbench. As you advance, you'll create a database, query single and multiple tables, and modify data using SQL querying. This SQL book covers advanced SQL techniques, including aggregate functions, flow control statements, error handling, and subqueries, and helps you process your data to present your findings. Finally, you'll implement best practices for writing SQL and designing indexes and tables.
By the end of this SQL programming book, you'll have gained the confidence to use SQL queries to retrieve and manipulate data.
What you will learn
Install, configure, and use MySQL Workbench to restore a database
Explore different data types such as string, numeric, and date and time
Query a single table using the basic SQL SELECT statement and the FROM, WHERE, and ORDER BY clauses
Query multiple tables by understanding various types of table relationships
Modify data in tables using the INSERT, UPDATE, and DELETE statements
Use aggregate functions to group and summarize data
Detect bad data, duplicates, and irrelevant values while processing data
Who this book is for
This book is for business analysts, SQL developers, database administrators, and students learning SQL. If you want to learn how to query and manipulate SQL data for database administration tasks or simply extract and organize relevant data for analysis, you'll find this book useful. No prior SQL experience is required.
Автор: Date Chris Название: Relational Theory for Computer Professionals ISBN: 144936943X ISBN-13(EAN): 9781449369439 Издательство: Wiley Рейтинг: Цена: 5067.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: 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. Most books try to use SQL as a vehicle for teaching relational theory, but this book deliberately takes the opposite approach.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru