SQL Performance Explained


Book Description




Indexing Books, Second Edition


Book Description

Since 1994, Nancy Mulvany's Indexing Books has been the gold standard for thousands of professional indexers, editors, and authors. This long-awaited second edition, expanded and completely updated, will be equally revered. Like its predecessor, this edition of Indexing Books offers comprehensive, reliable treatment of indexing principles and practices relevant to authors and indexers alike. In addition to practical advice, the book presents a big-picture perspective on the nature and purpose of indexes and their role in published works. New to this edition are discussions of "information overload" and the role of the index, open-system versus closed-system indexing, electronic submission and display of indexes, and trends in software development, among other topics. Mulvany is equally comfortable focusing on the nuts and bolts of indexing—how to determine what is indexable, how to decide the depth of an index, and how to work with publisher instructions—and broadly surveying important sources of indexing guidelines such as The Chicago Manual of Style, Sun Microsystems, Oxford University Press, NISO TR03, and ISO 999. Authors will appreciate Mulvany's in-depth consideration of the costs and benefits of preparing one's own index versus hiring a professional, while professional indexers will value Mulvany's insights into computer-aided indexing. Helpful appendixes include resources for indexers, a worksheet for general index specifications, and a bibliography of sources to consult for further information on a range of topics. Indexing Books is both a practical guide and a manifesto about the vital role of the human-crafted index in the Information Age. As the standard indexing reference, it belongs on the shelves of everyone involved in writing and publishing nonfiction books.




Indexing


Book Description




Index, A History of the


Book Description

A New York Times Editors' Choice Book Named a Most Anticipated Book of 2022 by Literary Hub and Goodreads A playful history of the humble index and its outsized effect on our reading lives. Most of us give little thought to the back of the book—it’s just where you go to look things up. But as Dennis Duncan reveals in this delightful and witty history, hiding in plain sight is an unlikely realm of ambition and obsession, sparring and politicking, pleasure and play. In the pages of the index, we might find Butchers, to be avoided, or Cows that sh-te Fire, or even catch Calvin in his chamber with a Nonne. Here, for the first time, is the secret world of the index: an unsung but extraordinary everyday tool, with an illustrious but little-known past. Charting its curious path from the monasteries and universities of thirteenth-century Europe to Silicon Valley in the twenty-first, Duncan uncovers how it has saved heretics from the stake, kept politicians from high office, and made us all into the readers we are today. We follow it through German print shops and Enlightenment coffee houses, novelists’ living rooms and university laboratories, encountering emperors and popes, philosophers and prime ministers, poets, librarians and—of course—indexers along the way. Revealing its vast role in our evolving literary and intellectual culture, Duncan shows that, for all our anxieties about the Age of Search, we are all index-rakers at heart—and we have been for eight hundred years.




Research and Evaluation for Busy Practitioners


Book Description

More and more people working in public services have to do research on top of their main jobs. This can include workplace research, such as evaluation, audit, training needs analysis or satisfaction surveys, or research for a professional development qualification such as diploma, master's degree or PhD. Unlike most how-to books that treat research as if it exists in isolation, this book will show you how to juggle research, work, family, and social life. Based on interviews with practitioners from health, education, social care, criminal justice, government and the third sector, as well as the author's extensive experience, it provides a wealth of practical information and tips to save you time, effort and stress. This book is for anyone in the public or third sector, an independent research organisation or academia, who wants to know how to do research on top of their main job and still have a life. The book is supported by a companion website, containing additional materials for both students and lecturers, which is available from the link above.




Book Indexing For Authors


Book Description

An index could be the thing your book is missing. Take a look in a library or bookstore and you will find few nonfiction books that don't have indexes. That's because publishers know how important the presence of an index is to readers - and therefore how vital it is for sales. Indies often don't realize this - and miss out on potential sales and potential good reviews. A book index is like a guidepost or map for your readers. It tells them what to expect from your book, where to find topics that interest them, and - importantly - what isn't in the book. This means that it reduces the chances of poor reviews and increases the chances of positive reviews. An index helps usability, which makes it more useful to readers.If you are an author thinking of creating your own index, you're in good company. There is quite a precedent for author-indexes (especially in the world of academia, where subjects are so specialist that it's hard to find a professional indexer with relevant experience). This book will guide you through the process and show you how to do it yourself in Microsoft Word. (Sorry, no Mac instructions.) This book is for you if... You need easy-to-understand instructions on how to create your own index for a non-fiction book using Microsoft Word; Your [traditional] publisher is insisting on an index and expecting you to pay for it; You don't have a big budget; You aren't a computer or publishing expert; You don't want to spend weeks (or months) learning how to index. This book is not for you if... You need an in-depth, theory-based book. Many people like the jump-right-in, workbook approach. You are looking for something to help you become a professional indexer, or to win indexing awards. Most professional training courses and organizations often recommend Nancy C. Mulwary's Indexing Books. Also check out the American Society of Indexers (ASI) - www.asindexing.org - and other professional and standards organizations in other countries. You can find courses on indexing in local colleges, as well as online. If you do buy this [print] book, you will have the opportunity of joining the forthcoming online course based on it - free of charge. You will be able to ask questions, receive help, and see in real-time what the creation of an index involves.




Designing Secure Software


Book Description

What every software professional should know about security. Designing Secure Software consolidates Loren Kohnfelder’s more than twenty years of experience into a concise, elegant guide to improving the security of technology products. Written for a wide range of software professionals, it emphasizes building security into software design early and involving the entire team in the process. The book begins with a discussion of core concepts like trust, threats, mitigation, secure design patterns, and cryptography. The second part, perhaps this book’s most unique and important contribution to the field, covers the process of designing and reviewing a software design with security considerations in mind. The final section details the most common coding flaws that create vulnerabilities, making copious use of code snippets written in C and Python to illustrate implementation vulnerabilities. You’ll learn how to: • Identify important assets, the attack surface, and the trust boundaries in a system • Evaluate the effectiveness of various threat mitigation candidates • Work with well-known secure coding patterns and libraries • Understand and prevent vulnerabilities like XSS and CSRF, memory flaws, and more • Use security testing to proactively identify vulnerabilities introduced into code • Review a software design for security flaws effectively and without judgment Kohnfelder’s career, spanning decades at Microsoft and Google, introduced numerous software security initiatives, including the co-creation of the STRIDE threat modeling framework used widely today. This book is a modern, pragmatic consolidation of his best practices, insights, and ideas about the future of software.




Sams Teach Yourself SQL in 24 Hours


Book Description

In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up. Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL. Step-by-step instructions carefully walk you through the most common SQL tasks. Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge. Notes and Tips point out shortcuts and solutions. New terms are clearly defined and explained. Learn how to... Use SQL-2003, the latest standard for the Structured Query Language Design and deploy efficient, secure databases Build advanced queries for information retrieval Sort, group, and summarize information for best presentation Tune databases and queries for maximum performance Understand database administration and security techniques For more than ten years the authors have studied, applied, and documented the SQL standard and its application to critical database systems. Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm which specializes in database technologies. They taught database courses for Indiana University–Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and the high availability of critical systems. Arie D. Jones is Senior SQL Server database administrator and analyst for PTI. He is a regular speaker at technical events and has authored several books and articles. Category: Database Covers: ANSI SQL User Level: Beginning–Intermediate Register your book at informit.com/title/9780672330186 for convenient access to updates and corrections as they become available.




Relational Database Index Design and the Optimizers


Book Description

Improve the performance of relational databases with indexes designed for today's hardware Over the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprising that relational database performance now receives much less attention. Unfortunately, the reality is that the improved hardware hasn't kept pace with the ever-increasing quantity of data processed today. Although disk packing densities have increased enormously, making storage costs extremely low and sequential read very fast, random reads are still painfully slow. Many of the old design recommendations are therefore no longer valid-the optimal point of indexing has come a long way. Consequently many of the old problems haven't actually gone away-they have simply changed their appearance. This book provides an easy but effective approach to the design of indexes and tables. Using lots of examples and case studies, the authors describe how the DB2, Oracle, and SQL Server optimizers determine how to access data, and how CPU and response times for the resulting access paths can be quickly estimated. This enables comparisons to be made of the various designs, and helps you choose available choices for the most appropriate design. This book is intended for anyone who wants to understand the issues of SQL performance or how to design tables and indexes effectively. With this title, readers with many years of experience of relational systems will be able to better grasp the implications that have been brought into play by the introduction of new hardware.




How to Make an Index


Book Description