Skip to main content
Elsevier
View Cart
openUserAccount

Books in Database management

BooksJournals
121-130 of 161 results in All results

Oracle High Performance Tuning for 9i and 10g

  • 1st Edition
  • December 29, 2003
  • Gavin JT Powell
  • English
  • eBook
    9 7 8 - 0 - 0 8 - 0 5 1 3 2 9 - 4
There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration.A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures.Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert.

Proceedings 2003 VLDB Conference

  • 1st Edition
  • December 2, 2003
  • VLDB
  • English
  • eBook
    9 7 8 - 0 - 0 8 - 0 5 3 9 7 8 - 2
Proceedings of the 29th Annual International Conference on Very Large Data Bases held in Berlin, Germany on September 9-12, 2003. Organized by the VLDB Endowment, VLDB is the premier international conference on database technology.

How to Build a Business Rules Engine

  • 1st Edition
  • October 29, 2003
  • Malcolm Chisholm
  • English
  • eBook
    9 7 8 - 0 - 0 8 - 0 4 9 1 4 7 - 9
· This is the only book that demonstrates how to develop a business rules engine. Covers user requirements, data modeling, metadata, and more.· A sample application is used throughout the book to illustrate concepts. The code for the sample application is available online at http://www.refdataportal.com. · Includes conceptual overview chapters suitable for management-level readers, including general introduction, business justification, development and implementation considerations, and more.

Oracle Real Application Clusters

  • 1st Edition
  • October 22, 2003
  • Murali Vallath
  • English
  • eBook
    9 7 8 - 0 - 0 8 - 0 4 9 2 0 4 - 9
Clustered configuration first hit the scene nearly 20 years ago when Digital Equipment Corporation (DEC) introduced the VaxCluster. Until now, the topic of Real Application Clusters (RAC) implementation had never been fully explored. For the first time, Murali Vallath dissects RAC mysteries in his book Oracle Real Application Clusters to enlighten and educate readers on the internals of RAC operations, cache fusion, fusion recovery processes and the fast reconfiguration of RAC.This book provides comprehensive coverage of the features, technology and principles of RAC that is part of the Oracle9i release of Oracle's RDBMS product. It is divided into three main parts: application/database design, development and maintenance life cycles. Compared to its predecessor OPS, the architecture behind RAC implementation have changed significantly. Vallath discusses Oracle9i features in a RAC implementation with respect to usage and design considerations, as well as those parameters that are and are not applicable. Areas covered include partitioning, indexes, tablespace management, transaction management, backup and recovery principles. Performance tuning with examples, troubleshooting and problem solving scenarios are covered in detail, as well as discussions on the migration process from a single instance database to RAC and migration from an OPS implementation to RAC.Oracle Real Application Clusters takes readers through a logical flow from RAC concepts to operations, covering each facet with a fine-tooth comb. Vallath's skilled writing style makes each chapter entertaining and informative as only a true RAC connoisseur can provide. New and experienced users of RAC, as well as those seeking to expand their knowledge of this dynamic technology, will find this book to be a necessity for both home and office reference libraries.

Database Modeling with Microsoft® Visio for Enterprise Architects

  • 1st Edition
  • August 14, 2003
  • Terry Halpin + 3 more
  • English
  • eBook
    9 7 8 - 0 - 0 8 - 0 4 9 1 0 3 - 5
This book is for database designers and database administrators using Visio, which is the database component of Microsoft's Visual Studio .NET for Enterprise Architects suite, also included in MSDN subscriptions. This is the only guide to this product that tells DBAs how to get their job done. Although primarily focused on tool features, the book also provides an introduction to data modeling, and includes practical advice on managing database projects. The principal author was the program manager of VEA's database modeling solutions.

Bioinformatics

  • 1st Edition
  • July 18, 2003
  • Zoé Lacroix + 1 more
  • English
  • eBook
    9 7 8 - 0 - 0 8 - 0 5 2 7 9 8 - 7
Life science data integration and interoperability is one of the most challenging problems facing bioinformatics today. In the current age of the life sciences, investigators have to interpret many types of information from a variety of sources: lab instruments, public databases, gene expression profiles, raw sequence traces, single nucleotide polymorphisms, chemical screening data, proteomic data, putative metabolic pathway models, and many others. Unfortunately, scientists are not currently able to easily identify and access this information because of the variety of semantics, interfaces, and data formats used by the underlying data sources. Bioinformatics: Managing Scientific Data tackles this challenge head-on by discussing the current approaches and variety of systems available to help bioinformaticians with this increasingly complex issue. The heart of the book lies in the collaboration efforts of eight distinct bioinformatics teams that describe their own unique approaches to data integration and interoperability. Each system receives its own chapter where the lead contributors provide precious insight into the specific problems being addressed by the system, why the particular architecture was chosen, and details on the system's strengths and weaknesses. In closing, the editors provide important criteria for evaluating these systems that bioinformatics professionals will find valuable.

SQL Clearly Explained

  • 3rd Edition
  • May 28, 2003
  • Jan L. Harrington
  • English
  • Paperback
    9 7 8 - 0 - 1 2 - 3 7 5 6 9 7 - 8
  • eBook
    9 7 8 - 0 - 1 2 - 3 8 5 1 7 5 - 8
  • eBook
    9 7 8 - 0 - 1 2 - 3 7 5 6 9 8 - 5
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.

SQL Clearly Explained

  • 2nd Edition
  • May 28, 2003
  • Jan L. Harrington
  • English
  • eBook
    9 7 8 - 0 - 0 8 - 0 5 1 7 5 8 - 2
This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including · formulating SQL queries, · understanding how queries are processed by the DBMS,· maximizing performance,· using SQL to enter, modify, or delete data,· creating and maintaining database structural elements, and· embedding SQL in applications.Features· Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92.· Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based.· Web enhanced with extra features available online at www.mkp.com.

Business Modeling and Data Mining

  • 1st Edition
  • May 6, 2003
  • Dorian Pyle
  • English
  • eBook
    9 7 8 - 0 - 0 8 - 0 5 0 0 4 5 - 4
Business Modeling and Data Mining demonstrates how real world business problems can be formulated so that data mining can answer them. The concepts and techniques presented in this book are the essential building blocks in understanding what models are and how they can be used practically to reveal hidden assumptions and needs, determine problems, discover data, determine costs, and explore the whole domain of the problem. This book articulately explains how to understand both the strategic and tactical aspects of any business problem, identify where the key leverage points are and determine where quantitative techniques of analysis -- such as data mining -- can yield most benefit. It addresses techniques for discovering how to turn colloquial expression and vague descriptions of a business problem first into qualitative models and then into well-defined quantitative models (using data mining) that can then be used to find a solution. The book completes the process by illustrating how these findings from data mining can be turned into strategic or tactical implementations.

Modeling Business Objects with XML Schema

  • 1st Edition
  • April 7, 2003
  • Dave Hollander + 1 more
  • English
  • eBook
    9 7 8 - 0 - 0 8 - 0 5 1 1 8 1 - 8
XML Schema is the new language standard from the W3C and the new foundation for defining data in Web-based systems. There is a wealth of information available about Schemas but very little understanding of how to use this highly formal specification for creating documents. Grasping the power of Schemas means going back to the basics of documents themselves, and the semantic rules, or grammars, that define them. Written for schema designers, system architects, programmers, and document authors, Modeling Business Objects with XML Schema guides you through understanding Schemas from the basic concepts, type systems, type derivation, inheritance, namespace handling, through advanced concepts in schema design.