Linux database bible

Michèle Petrovsky, Stephen Wysham, Majo Nichols

716 pages, parution le 01/10/2001

Ajouter à une liste

Indisponible

Résumé

The Linux Database Bible is the only comprehensive reference on the market for both OpenSource and commercial database products. The book includes: an introduction to Linux Databases; advice for determining user needs for data manipulation and storage; selection of an appropriate database; installation and configuration of the selected database; the administration, care, and feeding of the database; security and disaster recovery issues; and special considerations when integrating a database with the Internet. In addition to the above material, you'll find in-depth analysis of the programming issues involved, appendices for each covered database, command summaries and examples of schema and coding to address commonly encountered problems.

Table of Contents

Preface

Acknowledgments

Part I: Linux and Databases

Chapter 1: Introduction and Background
Origins of Linux: Whirlwind adolescence; The future
Some Established Linux Distributions: Slackware Linux; Debian GNU/Linux
Introduction to Databases: History of databases on Linux

Chapter 2: The Relational Model
What Is a Database?: What are data?; What does it mean to "maintain a body of data"?; Relationality
The Relational Model: What is the relational model?; Structure of the relational model; Relational algebra and relational calculus; Relational integrity
Hierarchic and Network Databases: The hierarchic database; The network database
Object Databases: The impedance mismatch problem; Storing objects as they are programmed; The object-relational compromise
Choosing a Type of Database
Application Architectures: Client-server; Three-tier architecture
Modern Advancements: The era of open standards; eXtensible markup language; Universal databases

Chapter 3: SQL
Origins of SQL: SQL standards; Dialects of SQL; Disadvantages and advantages of SQL; Implementation of the language
SQL Structure: Terminology; Structure of the language; Keywords
Data Types
Creating a Database: CREATE: Create a database; GRANT: Grant permissions; DROP: Remove a table or index; INSERT: Insert a row into a table
Selecting Data from the Database: SQL and relational calculus; One-table selection; The restrictive WHERE clause; Multitable selections; Unions; ORDER BY: Sort output; DISTINCT and ALL: Eliminate or request duplicate rows; Outer joins; Functions; Sub-SELECTs; SELECT: Conclusion
Modifying the Data Within a Database: COMMIT and ROLLBACK: Commit or abort database changes; DELETE: Remove rows from tables; UPDATE: Modify rows within a table
Views
Stored Procedures and Triggers
Chapter 4: Designing a Database
Planning and Executing a Database Project: What is a methodology and why have one; Getting to first base -- Phases and components of the plan; Evaluating and analyzing the organizational environment; Project hardware and software; Implementation strategy and design; People resources and project roles; Testing the system; Change control; Planning for the operation's manual documentation
From Project Plan to Tables: What does it mean to "design" a database?; The steps of designing a database; The art of database design
Building a Simple Database: The Baseball Example: Step 1: Articulate the problem; Step 2: Define the information we need; Step 3: Decompose the entities; Step 4: Design the tables; Step 5: Write domain-integrity rules
Building a More Complex Database: The Library Example: Step 1: Articulate the problem; Step 2: Define the information we need; Step 3: Decompose the entities; Step 4: Design the tables; Step 5: Write domain-integrity rules

Chapter 5: Deciding on Linux Databases
Evaluating Your Data Requirements: Business categories of organizational data
Assessing Your Existing Data
Environmental Factors: Network infrastructure; Technical staff; Organizational processes; Cross-platform issues

Chapter 6: Identifying Your Requirements
Introduction to the Database Management Life Cycle: State your goal; Identify constraints; Layout requirements; Finalize your requirements; Plan your execution process; Build the system
Assessing the Requirements of Your Database Installation: What is a database server?; Read the documentation; Set up a user account; Assess disk space
Classification of Information and Data Needs: Amount of data and data growth; Importance of data; Common database activity
Choosing the Proper System and Setup: Processor; Memory; Disk storage; Backup media

Chapter 7: Choosing a Database Product
Overview of Choosing Database Products: Architecture; Relationship modeling and the relational model; Hardware and operating system platforms; SQL standards; Stored procedures, triggers, and rules; Operating system-related performance issues; Means of multiprocessing; Managing connections; Administrative and other tools; Security techniques; Overall performance; Capability to interface; General design and performance questions
Choosing a DBMS: MySQL; Oracle; PostgreSQL
Candidates: Commercial products; Open source products
Recommendations

Part II: Installation and Configuration

Chapter 8: Installation
MySQL: Requirements and decisions; Preparation; Installing
PostgreSQL: Requirements; Preparation; Installation
Oracle8i: Requirements and preparation; Installing

Chapter 9: Configuration
Effective Schema Design: Data modeling; Normalization; Joins; Data definition language; Data manipulation languages and schema design; Database query languages and schema design
Capacity Planning: Storage; RAID; Memory; Examples of demands on memory: MySQL; Processors; Redundancy and backup
Initial Configuration: Linux concepts and commands; Generic configuration tasks; Vendor-specific configuration

Part III: Interaction and Usage

Chapter 10: Interacting with the Database
Interacting with MySQL: Dumping a database; Importing text files; Displaying database summary information
Interacting with PostgreSQL: Dumping a database; Importing text files; Displaying database summary information
Interacting with Oracle8i
Navigating the Server Console: MySQL; PostgreSQL; Oracle8i
Basic Operations: MySQL; PostgreSQL; Oracle8i

Chapter 11: Linux Database Tools
Vendor-Supplied Tools: Open source tools: PostgreSQL; Open source tools: MySQL
Third-Party Tools: Brio.Report; C/Database Toolchest; CoSORT; DBMS/COPY for UNIX/Linux; OpenAccess ODBC and OLE DB SDK; OpenLink Virtuoso

Part IV: Programming Applications

Chapter 12: Application Architecture
What Is a Database Application?: Evolution of the database application; Costs and benefits
The Three-Tier Model: Bottom tier: Access to the database; Middle tier: Business logic; Top tier: User interface; How the tiers relate to each other; Benefits of the three-tier model; Three-tier model: An example
Organization of the Tiers: Clients and servers; Drivers
From Tiers to Programs
Chapter 13: Programming Interfaces
Basic Database Connectivity Concepts through an API: Connecting to a database; Disconnecting from a database
API and Code Examples: ODBC and C/C++; DBI and Perl
Using the interface: Connecting to a database; Disconnecting from a database; Retrieving results; Transactions; Retrieving metadata
Java and JDBC: Using JDBC
PHP and MySQL
Linux Shell Scripts and Piping
Some Notes about Performance: Connecting to a data source; Using column binding; Executing calls with SQLPrepare and SQLExecute versus direct execution; Transactions and committing data

Chapter 14: Programming APIs -- Extended Examples
Open Database Connectivity: Structure of an ODBC application; Installing and configuring ODBC under Linux; Basic program structure; Binding a variable to a parameter; Reading data returned by a SELECT statement; Handling user input; Transactions; SQL interpreter
Java Database Connectivity: Structure of JDBC; Installing a JDBC driver; Elements of the JDBC standard; A simple example; Modifying the database; NULL data; Preparing a statement; General SQL statements; Metadata; Other features
Perl DBI: Structure of Perl DBI; Installing and configuring a Perl DBI driver; A simple example; Methods of execution; NULL data; Binding parameters; Transactions; Metadata

Chapter 15: Standalone Applications
Standalone Database Applications: Application architecture; Scope
An Example of a Standalone Linux Database Application: Initial database design; Requirements; User interface
Implementation: Choosing the language/API; Object-oriented programming; The customer class; The menu class; Main

Chapter 16: Web Applications
The New Problem to Solve: Security; Logging in; Looking up prior purchase history; Checking for prior discount; Displaying the welcome page banner; The order-entry form; Using a buffer for the products table; Processing each line
Accepting and Posting the Customer Order: Posting a new order header record; Posting new order detail records; Posting "discount given" in the customer's record; Posting new customer data

Part V: Administrivia

Chapter 17: Administration
System Administration: Backing up; Managing Performance; Managing processes; Managing users; Managing the file system; Miscellaneous or intermittent tasks
Database Administration
Chapter 18: Security and Disaster Recovery
Security Tools: Corporate policy statements; Database auditing procedures; Operating system auditing procedures; Incident reporting procedures; Physical security; Logical security
Disaster Prevention and Recovery: Environmental protection; Backups; Disaster recovery plan

Chapter 19: Modern Database Deployment
System Architecture: Designing for n-tier success
Internet Databases
Universal Databases
Advanced Applications: Transaction monitors

Appendix: Frequently Used Linux Commands

Index

Caractéristiques techniques

	PAPIER
Éditeur(s)	IDG
Auteur(s)	Michèle Petrovsky, Stephen Wysham, Majo Nichols
Parution	01/10/2001
Nb. de pages	716
Format	19 x 23,3
Couverture	Broché
Poids	850g
Intérieur	Noir et Blanc
EAN13	9780764546419