Book Finder
    
 
> Computers & Internet > Databases > Relational Database
 

Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems)

0126853525


·
 
Review
"An explicit presentation on Business Intelligence."
- P. Pichappan, Department of Information Science, Annamalai University, India

Book Description
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?

In the extensively revised fourth edition, youll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any...


Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
Michael J. Hernandez
0201752840
March 2003
Paperback
·
 
Book Review
Programmers and software architects don't really make a conscious decision to design an application (particularly one with online exposure) around the three-tier model-view-controller design pattern anymore. Three-tier, largely because of its adaptability and stability, is the norm. All of which means you need a database to underpin each of your applications. Designing your databases correctly can make the difference between slow-running, complicated code and software that's speedy, modular, and easy to work with. Database Design for Mere Mortals prepares someone with only a passing familiarity with databases for the important job of building the persistence layer (also called the data model) for software.

Michael Hernandez explains database design in tradesman's terms. That is, he shows his readers how to identify the...



Relational Database Systems
Dan A. Simovici
0126443750
December 1995
Textbook Hardcover
·
 
Book Description
Relational Database Systems provides a timely introduction to the type of systems that are the current mainstay of the database management field. This book serves as a text for advanced undergraduate and graduate students, as well as an informative reference for researchers and professionals in all database aspects of computer science. It presents important querying systems including SQL and QUEL, and covers their respective theoretical foundations in relational algebra, tuple calculus, and domain calculus.

The presentation of SQL adheres to the ANSI standard; however, the book discusses the most popular SQL dialects; a separate chapter covers imbedded SQL. The text also contains references to many significant relational database products, including INGRES, ORACLE, DB2, PARADOX, and SYBASE.

Relational...


Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions
Thomas Kyte
1590595300
September 15, 2005
Paperback
·
 
Book Description

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly.

Expert Oracle Database Architecture is the first of a three-book series that completely explores and defines the Oracle database. It covers all of the most important Oracle architecture features, including:


    Files, memory structures and processes
    Locking and latching...



Relational Database Theory
Paolo Atzeni
0805302492
December 1992
Textbook Hardcover
·
 


Microsoft. SQL Server. 2000 for Dummies. with CDROM
Anthony T. Mann
0764507753
Jan 2001
Paperback
·
 
Book Review
Microsoft SQL Server 2000 has become standard equipment in lots of organizations, largely owing to its relatively friendly user interface on top of its solid infrastructure. That user interface, however, can intimidate users who are new to the environment and lack the experience to interpret what they see. Microsoft SQL Server 2000 for Dummies decodes this top-of-the-line relational database management system (RDBMS) for the benefit of such novices, as well as for people coming to SQL Server 2000 from one of its competitors. Anthony Mann does a fine job of explaining not only administrative matters, but also issues of database design, Structured Query Language (SQL), and integration of SQL Server databases into larger information systems.

The instructional style in this book varies depending on the subject at hand. When...



Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)
Kevin Loney, Kevin Loney
0072253517
May 5, 2004
Paperback
·
 
Book Description
Get a thorough understanding of Oracle Database 10 g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

From the Back Cover

The Ultimate Resource on Oracle Database 10g

Get thorough coverage of Oracle Database 10g from the most comprehensive reference available,...



Oracle Database 10g DBA Handbook
Kevin Loney
0072231459
Apr 2005
Paperback
·
 
Book Description
Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it's been fully revised and updated for Oracle Database 10 g . Co-author Kevin Loney is the all-time, best-selling Oracle Press author.

From the Back Cover

The Essential Resource for All Oracle Database Administrators

Maintain a high-performance Oracle enterprise database with help from this exclusive Oracle Press guide. Oracle Database 10g DBA Handbook explains how to install Oracle Database 10g, or upgrade from an earlier version, and take full advantage of all the new and improved management, scalability, availability, and security features. Written by Oracle experts, the book covers Automatic Undo Management, Oracle...



Relational Database Design Clearly Explained
Jan L. Harrington
1558608206
January 2002
Paperback
·
 
Book Description


Fully revised and updated, Relational Database Design, Second Edition is the most lucid and effective introduction to relational database design available. Here, you'll find the conceptual and practical information you need to develop a design that ensures data accuracy and user satisfaction while optimizing performance, regardless of your experience level or choice of DBMS.


Supporting the book's step-by-step instruction are three case studies illustrating the planning, analysis, and design steps involved in arriving at a sound design. These real-world examples include object-relational design techniques, which are addressed in greater detail in a new chapter devoted entirely to this timely subject.

* Concepts you need to master to put the book's practical instruction to work.
*...



Relational Database Principles
Colin Ritchie
0826457134
May 2002
Paperback
·
 
Book Description
This new edition of an established textbook provides an introduction to the practice and principles of relational databases. It emphasises data modelling and the consequent construction of a database and reflects the importance of Structured Query Language (SQL). It contains new material on web-based databases and MySQL. There is increased coverage of the differences between Access and Oracle in SQL. Case studies and sample data feature on an accompanying web-sites.


SQL Bible
Alex Kriegel, Boris M. Trukhnov
0764525840
April 1, 2003
Paperback
·
 
Book Description
Covers the latest version of the ISO SQL standard (SQL-99) and gives readers information they need to know about the differences in vendor-specific SQL implementations including Oracle, Microsoft SQL Server, and IBM DB2 Knowledge of this ubiquitous database programming language is becoming more critical as IT departments move toward more integrated heterogeneous platforms Covers growing use of SQL with Web services and XML CD-ROM includes a complete sample database and trial versions of major relational database management software




From the Back Cover
If SQL can do it, you can do it too...

Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with...



SQL
James R. Groff
0072225599
Aug 2002
Paperback
·
 
Book Description
Learn all you need to know about SQL with this one-stop resource. Updated to include information on Web services and XML, this complete guide also comes with a Windows 2000- and XP- compatible CD containing 4 databases (SQL Server 2000, IBM DB2 Version 7.2, Sybase, and mySQL).

Download Description
This one-stop resource will show you everything you need to know about SQL--including coverage of Web services and XML. NOTE: due to the large amount of text and graphics, this eBook file is 18.3 MG. We recommend that you download this eBook using the fastest Internet connection at your disposal, otherwise you may notice a longer downloading time than usual.

See all Editorial Reviews


Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days
Richard Waymire
0672324695
November 2002
Paperback
·
 
Book Description
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days, 2E will clearly define and walk the reader through the features of SQL Server 2000. The reader will be given tips and tricks for working within the new SQL Server 2000 product environment as well as working with SQL Server databases. The book will feature information on:Create and alter databases.Manage security and implement permissions.Protect, backup, and restore data.Enforce and ensure data integrity.Modify and manipulate data.Create views, triggers, functions, and stored procedures.

Download Description
A beginning level tutorial for administrators and developers interested in learning SQL Server 2000. Written by Richard Waymire--the lead Project Manager for the Microsoft SQL Server group. Microsoft SQL Server is...


SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
Michael J. Hernandez, John L. Viescas
0201433362
August 21, 2000
Paperback
·
 
Book Review
To the people who are accomplished in its use, Structured Query Language (SQL) is a highly capable, eminently flexible, even beautiful way of describing the data that you want from a database, or the changes that you want to make to a database. For the rest of us, however, SQL is a first-class nuisance that we do our best to avoid by relying on relatively user-friendly--but usually less powerful--tools. SQL Queries for Mere Mortals aims to bring SQL-phobes closer to the first camp by tutoring them carefully in what SQL can do.

The authors recognize that SQL queries usually come about as a result of questions from human beings, and so usefully spend a fair bit of time showing how to convert, say, "In what cities do our customers live?" into, "Select city from the customers table" and, finally, "SELECT city FROM...



Oracle9ifor Dummies
Carol McCullough-Dieter
0764508806
Jan 2002
Paperback
·
 
Book Description
If you have Oracle9i, you have the database to beat all databases. Besides being among the cream of the crop when it comes to relational database packages, Oracle9i is one of the more complex. Oracle9i does some amazingly fancy things, but the easy things are sometimes tricky.

Oracle9i For Dummies covers the tough stuff in a straightforward and conversational manner, touching on key points and new features. This friendly guide leads you through a complete tour of Oracle9i, hitting the highlights the object relational world and these important product components: Enterprise Manager Console Major DBA tools SQL *Plus XML Developer's Kit Dataspeak Java applets

If you're new to relationship databases, you're bound to appreciate the many examples of simple database...



Understanding DB2: Learning Visually with Examples
Raul F. Chong
0131859161
January 2005
Hardcover
·
 
From the Back Cover
The Easy, Visual Guide to IBM DB2 V8.2

IBM DB2 Universal Database™ V8.2 for Linux®, UNIX®, and Windows® is a flexible, scalable, cost-effective, and easy-to-use enterprise database. Now, one book makes DB2 even easier. Understanding DB2 teaches DB2 V8.2 visually, step by step, with dozens of examples and case studies drawn from the authors' unsurpassed experience as DB2 consultants at IBM.

Understanding DB2 doesn't just present the big picture. It thoroughly introduces every DB2 concept, procedure, and tool you'll need to get results as an administrator, user, or developer. You'll find authoritative coverage of installation, configuration, objects, database instances, storage, connectivity, security, performance, backup and recovery, SQL fundamentals, and much...



SQL Cookbook (Cookbooks (O'Reilly))
Anthony Molinaro
0596009763
December 16, 2005
Paperback
·
 
Book Description

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.

Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT <columns> FROM <table> WHERE <conditions>. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about: Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not...



Oracle SQL Plus Pocket Reference
Jonathan Gennick
0596008856
November 2004
Paperback
·
 
Book Description
The Oracle SQL*Plus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQL*Plus. As Oracle's long-standing interactive query tool, SQL*Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQL*Plus is still often not completely understood or fully utilized. Database administrators and developers alike will therefore find the Oracle SQL*Plus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQL*Plus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to: Differentiate between SQL and SQL*Plus Interact with SQL*Plus from...


SQL Server 2000 Programming by Example with CDROM
Fernando Guerrero
0789724499
Apr 2001
Paperback
·
 
Book Review
Ideal for the database programmer or system DBA, Microsoft SQL Server 2000 Programming by Example is an excellent example-based tutorial on mastering today's SQL features. Packed with plenty of tips and tricks, this title will let most anyone do more with SQL Server.

While there are plenty of screen shots showing graphical SQL Server tools, the focus of this book is clearly on learning real command-line Transact-SQL (T-SQL). The authors provide a patient and very thorough tour of T-SQL with full coverage of both basic and advanced features. You'll learn how to define new tables, manage users in groups, and perform all kinds of queries. Standout material includes an excellent guide to SQL data types and how to choose the right one for your needs. When it comes to queries, the book does a great job of exploring all your...



Oracle Database 10g High Availability with Rac, Flashback & Data Guard
Matthew Hart
0072254289
Apr 2004
Paperback
·
 
Book Description
Attain real solutions for current availability challenges. Based on a DBA-centric approach to High Availability, Oracle Database 10g High Availability concentrates on explaining Oracle Database 10 g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery, and distributed database solutions. Hardware and application needs are also taken into account. While Oracle Database 10 g is the main focus, many of the options discussed are available in earlier database releases. Organized to provide conceptual understanding of High Availability, included are HA Workshops, step-by-step instructions to get you through certain implementations, plus real-world inspired case studies.

About the...


Business Objects: The Complete Reference (Osborne Complete Reference Series)
Cindi Howson
0072226811
May 2, 2003
Paperback
·
 
Book Description
If your objective in business intelligence reporting is Business Objects success, this is the resource for you. Gives a thorough run-down of the software, plus coverage of Web intelligence, complex queries, multidimensional analysis, and more. Author Cindi Howson has plenty of hands-on experience with the product.

Download Description
If your objective in business intelligence reporting is Business Objects success, this is the resource for you. Gives a thorough run-down of the software, plus coverage of Web intelligence, complex queries, multidimensional analysis, and more. Author Cindi Howson has plenty of hands-on experience with the product.

See all Editorial Reviews


Microsoft SQL Server 2000 Bible
Paul Nielsen
0764549359
December 2002
Paperback
·
 
Book Description
Organization: The book is divided into 6 parts: Preparing to Develop with SQL Server; Building and Managing Databases with SQL Server; Managing Data with SQL Server; Implementing Business Rules with SQL Server; Monitoring and Performance Tuning with SQL Server; and Advanced Data Transfer and Analysis with SQL Server.
Comprehensive coverage: This Bible covers both beginning and advanced topics. Topics covered include: installing and configuring SQL Server; using SQL server's development tools; securing databases; retrieving data; SQL Server transactions; working with XML; understanding transact SQL language extensions; developing stored procedures; tuning queries and indexes; and developing for English query.
Sample database applications: The book builds on sample database applications to demonstrate...


Sams Teach Yourself SQL in 10 Minutes, Third Edition
Ben Forta
0672325675
April 7, 2004
Paperback
·
 
Book Description
Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Forta's examples are clear and his writing style is crisp and concise. As with earlier editions, this revision includes coverage of current versions of all major commercial SQL platforms. New this time around is coverage of MySQL, and PostgreSQL. All examples have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained.

Download Description
Sams Teach Yourself SQL in 10 Minutes, 2E is a tutorial-based book, organized into a series of easy-to-follow, 10-minute lessons. These well targeted lessons...


Foundation for Object / Relational Databases: The Third Manifesto
Chris J. Date
0201309785
June 1998
Hardcover
·
 
From the Inside Flap
The Third Manifesto is a detailed proposal for the future direction of data and database management systems (DBMSs). Like Codd's original papers on the relational model, it can be seen as an abstract blueprint for the design of a DBMS and the language interface to such a DBMS. In particular, it lays the foundation for what we believe is the logically correct approach to integrating relational and object technologies--a topic of considerable interest at the present time, given the recent appearance in the marketplace of several "object/relational" DBMS products (sometimes called universal servers). Perhaps we should add immediately that we do not regard the idea of integrating relational and object technologies as "just another fad," soon to be replaced by some other briefly fashionable idea. On the contrary, we...


Oracle9i: The Complete Reference
Kevin Loney, George Koch
0072225211
August 16, 2002
Paperback
·
 
Book Description
Master all the powerful features of Oracle9 i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9 i . This is a must-have reference for all Oracle professionals.

Book Info
Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. A must-have for all Oracle professionals. Softcover. CD-ROM included.

See all Editorial Reviews

  ©BookFinder USA LLC.
  All rights reserved.