Welcome to Loot.co.za!
Sign in / Register |Wishlists & Gift Vouchers |Help | Advanced search
|
Your cart is empty |
|||
Books > Academic & Education > Professional & Technical > Data Management
SQL Clearly Explained, Third Edition, provides an in-depth introduction to using SQL (Structured Query Language). Readers will learn not only SQL syntax, but also how SQL works. Although the core of the SQL language remains relatively unchanged, the most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. As a result, the set of standard SQL commands has been greatly extended and this new edition takes that into account. This new edition includes updated tips and tricks to reflect the current concepts of SQL and XML standards; several new chapters covering object-relational and XML extensions; and an ancillary package that includes case studies, a syllabus, exams and more. This book is intended for working SQL programmers, database administrators, database designers, database analysts, and application system developers as well as those who are developing new features for database management systems who want to know about user needs. This would include anyone working with electronic content in the relational database context but also XML. Web services, etc.
The Bayesian network is one of the most important architectures for representing and reasoning with multivariate probability distributions. When used in conjunction with specialized informatics, possibilities of real-world applications are achieved. Probabilistic Methods for BioInformatics explains the application of probability and statistics, in particular Bayesian networks, to genetics. This book provides background material on probability, statistics, and genetics, and then moves on to discuss Bayesian networks and applications to bioinformatics. Rather than getting bogged down in proofs and algorithms,
probabilistic methods used for biological information and Bayesian
networks are explained in an accessible way using applications and
case studies. The many useful applications of Bayesian networks
that have been developed in the past 10 years are discussed.
Forming a review of all the significant work in the field that will
arguably become the most prevalent method in biological data
analysis.
This book brings all of the elements of database design together in
a single volume, saving the reader the time and expense of making
multiple purchases. It consolidates both introductory and advanced
topics, thereby covering the gamut of database design methodology ?
from ER and UML techniques, to conceptual data modeling and table
transformation, to storing XML and querying moving objects
databases.
This book brings all of the elements of data mining together in a
single volume, saving the reader the time and expense of making
multiple purchases. It consolidates both introductory and advanced
topics, thereby covering the gamut of data mining and machine
learning tactics ? from data integration and pre-processing, to
fundamental algorithms, to optimization techniques and web mining
methodology.
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.
In this fully updated second edition of the highly acclaimed
Managing Gigabytes, authors Witten, Moffat, and Bell continue to
provide unparalleled coverage of state-of-the-art techniques for
compressing and indexing data. Whatever your field, if you work
with large quantities of information, this book is essential
reading--an authoritative theoretical resource and a practical
guide to meeting the toughest storage and access challenges. It
covers the latest developments in compression and indexing and
their application on the Web and in digital libraries. It also
details dozens of powerful techniques supported by mg, the authors'
own system for compressing, storing, and retrieving text, images,
and textual images. mg's source code is freely available on the
Web.
In "Distributed Algorithms," Nancy Lynch provides a blueprint
for designing, implementing, and analyzing distributed algorithms.
She directs her book at a wide audience, including students,
programmers, system designers, and researchers. "Distributed Algorithms" contains the most significant
algorithms and impossibility results in the area, all in a simple
automata-theoretic setting. The algorithms are proved correct, and
their complexity is analyzed according to precisely defined
complexity measures. The problems covered include resource
allocation, communication, consensus among distributed processes,
data consistency, deadlock detection, leader election, global
snapshots, and many others. The material is organized according to the system model first by
the timing model and then by the interprocess communication
mechanism. The material on system models is isolated in separate
chapters for easy reference. The presentation is completely rigorous, yet is intuitive enough for immediate comprehension. This book familiarizes readers with important problems, algorithms, and impossibility results in the area: readers can then recognize the problems when they arise in practice, apply the algorithms to solve them, and use the impossibility results to determine whether problems are unsolvable. The book also provides readers with the basic mathematical tools for designing new algorithms and proving new impossibility results. In addition, it teaches readers how to reason carefully about distributed algorithms to model them formally, devise precise specifications for their required behavior, prove their correctness, and evaluate their performance with realistic measures."
Managing Time in Relational Databases: How to Design, Update and Query Temporal Data introduces basic concepts that will enable businesses to develop their own framework for managing temporal data. It discusses the management of uni-temporal and bi-temporal data in relational databases, so that they can be seamlessly accessed together with current data; the encapsulation of temporal data structures and processes; ways to implement temporal data management as an enterprise solution; and the internalization of pipeline datasets. The book is organized into three parts. Part 1 traces the history of temporal data management and presents a taxonomy of bi-temporal data management methods. Part 2 provides an introduction to Asserted Versioning, covering the origins of Asserted Versioning; core concepts of Asserted Versioning; the schema common to all asserted version tables, as well as the various diagrams and notations used in the rest of the book; and how the basic scenario works when the target of that activity is an asserted version table. Part 3 deals with designing, maintaining, and querying asserted version databases. It discusses the design of Asserted Versioning databases; temporal transactions; deferred assertions and other pipeline datasets; Allen relationships; and optimizing Asserted Versioning databases.
Joe Celko has looked deep into the code of SQL programmers and
found a consistent and troubling pattern - a frightening lack of
consistency between their individual encoding schemes and those of
the industries in which they operate. This translates into a series
of incompatible databases, each one an island unto itself that is
unable to share information with others in an age of
internationalization and business interdependence. Such
incompatibility severely hinders information flow and the quality
of company data.
XML has become the lingua franca for representing business data,
for exchanging information between business partners and
applications, and for adding structure
XML in Data Management is for IT managers and technical staff
involved in the creation, administration, or maintenance of a data
management infrastructure that includes XML. For most IT staff, XML
is either just a buzzword that is ignored or a silver bullet to be
used in every nook and cranny of their organization. The truth is
in between the two. This book provides the guidance necessary for
data managers to make measured decisions about XML within their
organizations. Readers will understand the uses of XML, its
component architecture, its strategic implications, and how these
apply to data management.
Making the move from an IT technician or team member to management is one of the most difficult career steps you ll face. Help from management and targeted training can be hard to come by - and your success depends on your ability to adapt to your new role almost overnight. You might have years of experience in the trenches, but you ll quickly find that managing a team, setting budgets, and creating a winning strategy for the first time can be daunting tasks. Now in its third edition, "IT Manager s Handbook" provides a
practical reference that you will return to again and again in an
ever-changing corporate environment where the demands on IT
continue to increase. Make your first 100 days really count with
the fundamental principles and core concepts critical to your
success as a new IT Manager. The book also includes discusses how
to develop an overall IT strategy as well as demonstrate the value
of IT to the company. In this book, you ll learn how to: Manage your enterprise s new level of connectivity with a NEW chapter covering social media, handheld devices, and moreImplement and optimize cloud services to provide a better experience for your mobile and virtual workforce at a lower cost to your bottom lineIntegrate mobile applications into your company s strategyManage the money, including topics such as department budgets and leasing versus buyingWork with your "customers," whomever those might be for your IT shopHire, train, and manage your team and their projects so that you come in on time and budgetSecure your systems to face some of today's most challenging security challenges"
How do you approach answering queries when your data is stored in multiple databases that were designed independently by different people? This is first comprehensive book on data integration and is written by three of the most respected experts in the field. This book provides an extensive introduction to the theory and concepts underlying today's data integration techniques, with detailed, instruction for their application using concrete examples throughout to explain the concepts. Data integration is the problem of answering queries that span multiple data sources (e.g., databases, web pages). Data integration problems surface in multiple contexts, including enterprise information integration, query processing on the Web, coordination between government agencies and collaboration between scientists. In some cases, data integration is the key bottleneck to making progress in a field. The authors provide a working knowledge of data integration
concepts and techniques, giving you the tools you need to develop a
complete and concise package of algorithms and applications. *Offers a range of data integration solutions enabling you to focus on what is most relevant to the problem at hand. *Enables you to build your own algorithms and implement your own data integration applications *Companion website with numerous project-based exercises and solutions and slides. Links to commercially available software allowing readers to build their own algorithms and implement their own data integration applications. Facebook page for reader input during and after publication.
The demand for SQL information and training continues to grow
with the need for a database behind every website capable of
offering web-based information queries. SQL is the de facto
standard for database retrieval, and if you need to access, update,
or utilize data in a modern database management system, youwill
need SQL to do it. TheSecond Editionof "Joe Celko's Trees and
Hierarchies in SQL for Smarties" covers two new sets of extensions
over three entirelynew chapters and expounds upon the changes that
have occurred in SQL standards since the previous edition's
publication. Benefit from mastering the challenging aspects of
these database applications in SQL as taught by Joe Celko, one of
the most-read SQL authors in the world. *Expert advice from a noted SQL authority and award-winning columnist who has given 10 years of service to the ANSI SQL standards committee *Teaches scores of advanced techniques that can be used with any product, in any SQL environment *Offers graph theory and programming techniques for working around deficiencies and gives insight into real-world challenges"
A multitude of problems is likely to arise when developing data models. With dozens of attributes and millions of rows, data modelers are always in danger of inconsistency and inaccuracy. The development of the data model itself could result in difficulties presenting accurate data. The need to improve data models begins with getting it right in the first place. Using real-world examples, "Developing High Quality Data Models"
walks the reader through identifying a number of data modeling
principles and analysis techniques that enable the development of
data models that both meet business requirements and have a
consistent basis. The reader is presented with a variety of generic
data model patterns that both exemplify the principles and
techniques discussed and build upon one another to give a powerful
and integrated generic data model. This model has wide
applicability across many disciplines in government and industry,
including but not limited to energy exploration, healthcare,
telecommunications, transportation, military defense,
transportation, and more. * Uses a number of common data model patterns to explain how to develop data models over a wide scope in a way that is consistent and of high quality *Offers generic data model templates that are reusable in many applications and are fundamental for developing more specific templates *Develops ideas for creating consistent approaches to high quality data models
The key to client/server computing. The authors provide detailed explanations of why various
problems occur as
Data is an expensive and expansive asset. Information capture has forced storage capacity from megabytes to terabytes, exabytes and, pretty soon, zetabytes of data. So the need for accessible storage space for this data is great. To make this huge amount of data usable and relevant, it needs to be organized effectively. Database Base Management Systems, such as Oracle, IBM s DB2, and Microsoft SqlServer are used often, but these are being enhanced continuously and auxiliary tools are being developed every week; there needs to be a fundamental starting point for it all. That stating point is Data Architecture, the blueprint for organizing and structuring of information for services, service providers, and the consumers of that data. "Data Architecture: From Zen to Reality" explains the principles underlying data architecture, how data evolves with organizations, and the challenges organizations face in structuring and managing their data. It also discusses proven methods and technologies to solve the complex issues dealing with data. The book uses a holistic approach to the field of data architecture by covering the various applied areas of data, including data modelling and data model management, data quality, data governance, enterprise information management, database design, data warehousing, and warehouse design. This book is a core resource for anyone emplacing, customizing or aligning data management systems, taking the Zen-like idea of data architecture to an attainable reality. Presents fundamental concepts of enterprise architecture with definitions and real-world applications and scenariosTeaches data managers and planners about the challenges of building a data architecture roadmap, structuring the right team, and building a long term set of solutions Includes the detail needed to illustrate how the fundamental principles are used in current business practice"
Database systems and database design technology have undergone
significant evolution in recent years. The relational data model
and relational database systems dominate business applications; in
turn, they are extended by other technologies like data
warehousing, OLAP, and data mining. How do you model and design
your database application in consideration of new technology or new
business needs? Loaded with design rules and illustrative case studies that are applicable to any SQL, UML, or XML-based system Immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data. "
"How to Build a Digital Library" is the only book that offers
all the knowledge and tools needed to construct and maintain a
digital library, regardless of the size or purpose. It is the
perfectly self-contained resource for individuals, agencies, and
institutions wishing to put this powerful tool to work in their
burgeoning information treasuries. The Second Edition reflects new
developments in the field as well as in the Greenstone Digital
Library open source software. In Part I, the authors have added an
entire new chapter on user groups, user support, collaborative
browsing, user contributions, and so on. There is also new material
on content-based queries, map-based queries, cross-media queries.
There is an increased emphasis placed on multimedia by adding a
"digitizing" section to each major media type. A new chapter has
also been added on "internationalization," which will address
Unicode standards, multi-language interfaces and collections, and
issues with non-European languages (Chinese, Hindi, etc.). Part II,
the software tools section, has been completely rewritten to
reflect the new developments in Greenstone Digital Library
Software, an internationally popular open source software tool with
a comprehensive graphical facility for creating and maintaining
digital libraries. As with the First Edition, a web site,
implemented as a digital library, will accompany the book and
provide access to color versions of all figures, two online
appendices, a full-text sentence-level index, and an automatically
generated glossary of acronyms and their definitions. In addition,
demonstration digital library collections will be included to
demonstrate particular points in the book. to access the online
content please visit, http: //www.greenstone.org/howto *Outlines the history of libraries-- both traditional and digital-- and their impact on present practices and future directions. *Written for both technical and non-technical audiences and covers the entire spectrum of media, including text, images, audio, video, and related XML standards. *Web-enhanced with software documentation, color illustrations, full-text index, source code, and more."
Perfectly intelligent programmers often struggle when forced to
work with SQL. Why? Joe Celko believes the problem lies with their
procedural programming mindset, which keeps them from taking full
advantage of the power of declarative languages. The result is
overly complex and inefficient code, not to mention lost
productivity.
In this complete revision and expansion of his first SQL Puzzles
book, Joe Celko challenges you with his trickiest puzzles and then
helps solve them with a variety of solutions and explanations. Joe
demonstrates the thought processes that are involved in attacking a
problem from an SQL perspective to help advanced database
programmers solve the puzzles you frequently face. These techniques
not only help with the puzzle at hand, but help develop the mindset
needed to solve the many difficult SQL puzzles you face every day.
Of course, part of the fun is to see whether or not you can write
better solutions than Joe s.
Are you an SQL programmer that, like many, came to SQL after
learning and writing procedural or object-oriented code? Or have
switched jobs to where a different brand of SQL is being used, or
maybe even been told to learn SQL yourself?
Information Modeling and Relational Databases, second edition,
provides an introduction to ORM (Object-Role Modeling)and much
more. In fact, it is the only book to go beyond introductory
coverage and provide all of the in-depth instruction you need to
transform knowledge from domain experts into a sound database
design. This book is intended for anyone with a stake in the
accuracy and efficacy of databases: systems analysts, information
modelers, database designers and administrators, and programmers.
Would the basics of SQL querying be useful to you, but you don't
want to start at the very beginning? Do you wish you had an easy
way to ramp up quickly to get a basic understanding of key features
and capability? Then you need this book! Without a ton of
conceptual information or general programming basics you already
know, this book is a quick guide for computing professionals and
programmers to learn the basics--and more--in an easily digestible
way. |
You may like...
Bioinformatics - Managing Scientific…
Zoe Lacroix, Terence Critchlow
Hardcover
R2,412
Discovery Miles 24 120
Principles of Transaction Processing
Philip A. Bernstein, Eric Newcomer
Paperback
R2,159
Discovery Miles 21 590
Physical Database Design - The Database…
Sam S. Lightstone, Toby J. Teorey, …
Paperback
R2,067
Discovery Miles 20 670
Java Data Mining: Strategy, Standard…
Mark F. Hornick, Erik Marcade, …
Paperback
R2,130
Discovery Miles 21 300
Designing Data-Intensive Web…
Stefano Ceri, Piero Fraternali, …
Paperback
R2,992
Discovery Miles 29 920
Database Tuning - Principles…
Dennis Shasha, Philippe Bonnet
Paperback
R2,778
Discovery Miles 27 780
The Object Data Standard - ODMG 3.0
R. Cattell, Douglas K. Barry, …
Paperback
R2,481
Discovery Miles 24 810
|