|
| |
|
EBooks » Database
 Don't think Joe Celko's Data and Databases: Concepts in Practice is for computer beginners. It starts by defining mathematically what data is, relationships between data, and how all this becomes the information and wisdom that you really want from your database, with a host of fascinating examples and warnings. Read the introduction and you'll even understand statistics better. The data and relationships in any database are only ever a subset of the real world with just the attributes and relationships that matter to how your database needs to work. As well as explaining all the concepts you need to build and design databases, Celko shows why these matter and how to decide what entities to use to represent data. He covers the major database design techniques; this soon becomes technical, with code snippets and references to various database theories, but usually the examples make sense of it all. The section on time is fascinating as well as useful, but while the Y2K discussion covers all the important issues, it does seem dated, referring to problems in DOS and Windows 3.1 rather than Windows NT or Windows 95/98. Read this to understand the problem, not for information on how to fix it. The details of how to deal with numerical data, text and "exotic" data like multimedia and geographical information, how to encode data, and how to check for errors are certainly useful, but oddly all of these come before the explanation of what relational databases actually are and how they work. Location-based services (LBS) are a new concept integrating a user’s
geographic location with the general notion of services, such as dialing an
emergency number from a cell phone or using a navigation system in a car. Incorporating
both mobile communication and spatial data, these applications represent a novel
challenge both conceptually and technically.
The purpose of this book is to describe, in an accessible fashion, the various
concepts underlying mobile location-based services. These range from general
application-related ideas to technical aspects. Each chapter starts with a high
level of abstraction and drills down to the technical details. Contributors
examine each application from all necessary perspectives, namely, requirements,
services, data, and scalability. An illustrative example begins early in the
book and runs throughout, serving as a reference.
· This book defines the LBS field and identifies its capabilities, challenges,
and technologies.
· The contributors are recognized experts from academia and industry.
· Coverage includes navigation systems, middleware, interoperability, standards,
and mobile communications.
· A sample application, the “find-friend” application, is used
throughout the book to integrate the concepts discussed in each chapter.  The message of this book is that building stored procedures in Transact-SQL
is very much like building programs in any other language. It requires the same
type of skill, planning, attention to detail, and overall grasp of technology
that successful development in other languages requires. To master Transact-SQL,
one must first master the fundamental concepts of software development, then
build on this foundation by embracing and studying Transact-SQL as a programming
language in its own right. This book teaches you how to do that and more.
More than just a catalog of coding tricks and syntax subtleties, The
Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML explores
the philosophy of Transact-SQL programming. It teaches readers how to apply
this philosophy in order to develop their own coding techniques and discover
their own solutions to real-world programming problems. A follow-up to the widely
acclaimed The Guru's Guide to Transact-SQL, this book teaches that stored
procedure development does not occur in a vacuum--it involves a wide variety
of skills, subjects, and technologies--and helps the reader become a better
software engineer, not just a stored procedure expert.
SQL Server is the dominant relational database in the Windows market and data
security is a huge and growing concern for all businesses. Securing SQL Server
is one of the most important responsibilities of the SQL Server professional.
SQL Server Distilled, Second Edition is a very carefully researched,
clearly explained book on securing SQL Server, by an author who knows SQL Server
inside and out. If you follow the practical guidelines that are clearly set
out in this book, then you stand a very good chance of making sure that the
data stored in your database is secure and that the conversation between your
applications and the database is secure (preventing SQL injection attacks, etc.).
For example, any DBA who implemented the security precautions detailed in the
book would not have been affected by the infamous Slammer virus.
This second edition will have more practical advice on how to implement good
practices that will ward off future viruses before they are even created. This
book will contain new content that reflects all updates to SQL Server's security
mechanisms.
Sequence Analysis in a Nutshell: A Guide to Common Tools and Databases
pulls together all of the vital information about the most commonly
used databases, analytical tools, and tables used in sequence analysis.
The book contains details and examples of the common database formats
(GenBank, EMBL, SWISS-PROT) and the GenBank/EMBL/DDBJ Feature Table
Definitions. It also provides the command line syntax for popular
analysis applications such as Readseq and MEME/MAST, BLAST, ClustalW,
and the EMBOSS suite, as well as tables of nucleotide, genetic, and
amino acid codes. Written in O'Reilly's enormously popular,
straightforward "Nutshell" format, this book draws together essential
information for bioinformaticians in industry and academia, as well as
for students. If sequence analysis is part of your daily life, you'll
want this easy-to-use book on your desk.
|
| |
|