📄 ewtoc.html

📁 linux-unix130.linux.and.unix.ebooks130 linux and unix ebookslinuxLearning Linux - Collection of 12 E
💻 HTML
字号:
<HTML>

<HEAD>

<TITLE>The Linux Database:Table of Contents</TITLE>

<META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW">
<SCRIPT>
<!--
function displayWindow(url, width, height) {
        var Win = window.open(url,"displayWindow",'width=' + width +
',height=' + height + ',resizable=1,scrollbars=yes');
}
//-->
</SCRIPT>
</HEAD>

 -->




<!--ISBN=1558284915//-->

<!--TITLE=The Linux Database//-->

<!--AUTHOR=Fred Butzen//-->

<!--PUBLISHER=IDG Books Worldwide, Inc.//-->

<!--IMPRINT=M & T Books//-->

<!--CHAPTER=0//-->

<!--PAGES=0//-->

<!--UNASSIGNED1//-->

<!--UNASSIGNED2//-->





<FONT FACE="Arial,Helvetica" SIZE="-1">

To access the contents, click the chapter and section titles.

</FONT>

<P>

<B>The Linux Database</B>

<IMG SRC="/images/new.gif" height=17 width=48 border=0 alt="new">

<A TARGET="resource window" HREF="http://barnesandnoble.bfast.com/booklink/click?sourceid=216514&ISBN=1558284915">

<IMG SRC="/images/buybutton.gif" height=17 width=48 border=0 alt="buy it"></A>

<FONT SIZE="-1">

<BR>

<I>(Imprint: M & T Books)</I>

<BR>

<I>(Publisher: IDG Books Worldwide, Inc.)</I>

<BR>

Author: Fred Butzen

<BR>

ISBN: 1558284915

</FONT>

<BR>

<HR>

<P>



<DL>

<FONT SIZE="4"><B>

<DD><A HREF="index.html">Introduction</A>

<DD><A HREF="about_author.html">Acknowledgments</A>

</B></FONT>

<BR>

<BR><DD><A HREF="ch01/005-009.html"><FONT SIZE="4"><B>PART I&#151;The Relational Database</B></FONT></A>

<DL>

<DD><A HREF="ch01/005-009.html#Heading1"><FONT SIZE="4"><B>Chapter 1&#151;The Relational Model</B></FONT></A>

<FONT SIZE="3"><B>

<DL>

<DD><A HREF="ch01/005-009.html#Heading2">What Is a Database?</A>

<DL>

<DD><A HREF="ch01/005-009.html#Heading3">What Are Data?</A>

<DD><A HREF="ch01/012-016.html#Heading4">What Does It Mean to Maintain a Body of Data?</A>

<DD><A HREF="ch01/016-019.html#Heading5">Data Relationality</A>

</DL>

<DD><A HREF="ch01/016-019.html#Heading6">The Relational Model</A>

<DL>

<DD><A HREF="ch01/016-019.html#Heading7">What is the Relational Model?</A>

<DD><A HREF="ch01/019-022.html#Heading8">Structure of the Relational Model</A>

<DD><A HREF="ch01/028-031.html#Heading9">Relational Algebra and Relational Calculus</A>

<DD><A HREF="ch01/048-052.html#Heading10">Integrity</A>

</DL>

<DD><A HREF="ch01/059-062.html#Heading11">How the Relational Model Differs from Other Database Designs</A>

<DL>

<DD><A HREF="ch01/059-062.html#Heading12">Systems, Not Models</A>

<DD><A HREF="ch01/059-062.html#Heading13">The Hierarchic Database</A>

<DD><A HREF="ch01/059-062.html#Heading14">The Network Database</A>

<DD><A HREF="ch01/062-065.html#Heading15">The Object-Oriented Database</A>

<DD><A HREF="ch01/062-065.html#Heading16">Choosing a Type of Database</A>

</DL>

<DD><A HREF="ch01/062-065.html#Heading17">Summary</A>

<DD><A HREF="ch01/065-066.html#Heading18">Further Reading</A>

</DL>

</B></FONT>

<DD><A HREF="ch02/067-070.html#Heading1"><FONT SIZE="4"><B>Chapter 2&#151;Designing a Relational Database</B></FONT></A>

<FONT SIZE="3"><B>

<DL>

<DD><A HREF="ch02/067-070.html#Heading2">From Real World to Relations</A>

<DL>

<DD><A HREF="ch02/067-070.html#Heading3">What Does It Mean to Design a Database?</A>

<DD><A HREF="ch02/067-070.html#Heading4">The Steps of Designing a Database</A>

<DD><A HREF="ch02/079-083.html#Heading5">The Art of Database Design</A>

</DL>

<DD><A HREF="ch02/083-086.html#Heading6">Building a Database: A Simple Example</A>

<DL>

<DD><A HREF="ch02/083-086.html#Heading7">The Baseball Score Problem</A>

</DL>

<DD><A HREF="ch02/090-093.html#Heading8">Building a Database: A Longer Example</A>

<DL>

<DD><A HREF="ch02/090-093.html#Heading9">The Library Problem</A>

</DL>

<DD><A HREF="ch02/108-112.html#Heading10">Building a Database: A Still Longer Example</A>

<DL>

<DD><A HREF="ch02/108-112.html#Heading11">The Auction Problem</A>

</DL>

<DD><A HREF="ch02/128-130.html#Heading12">Summary</A>

<DD><A HREF="ch02/128-130.html#Heading13">Further Reading</A>

</DL>

</B></FONT>

<DD><A HREF="ch03/131-134.html#Heading1"><FONT SIZE="4"><B>Chapter 3&#151;Structured Query Language</B></FONT></A>

<FONT SIZE="3"><B>

<DL>

<DD><A HREF="ch03/131-134.html#Heading2">A History of Structured Query Language (SQL)</A>

<DL>

<DD><A HREF="ch03/131-134.html#Heading3">SQL Standards</A>

<DD><A HREF="ch03/131-134.html#Heading4">Dialects of SQL</A>

<DD><A HREF="ch03/134-138.html#Heading5">Disadvantages and Advantages of SQL</A>

<DD><A HREF="ch03/134-138.html#Heading6">Implementation of the Language</A>

</DL>

<DD><A HREF="ch03/134-138.html#Heading7">SQL Structure</A>

<DL>

<DD><A HREF="ch03/134-138.html#Heading8">SQL Terminology</A>

<DD><A HREF="ch03/138-141.html#Heading9">Structure of the Language</A>

<DD><A HREF="ch03/138-141.html#Heading10">SQL Keywords</A>

</DL>

<DD><A HREF="ch03/138-141.html#Heading11">Data Types</A>

<DL>

<DD><A HREF="ch03/141-144.html#Heading12">Example Databases</A>

</DL>

<DD><A HREF="ch03/150-154.html#Heading13">Setting Up a Database</A>

<DL>

<DD><A HREF="ch03/150-154.html#Heading14">CREATE: Create a Database and Tables</A>

<DD><A HREF="ch03/164-168.html#Heading15">DROP: Remove a Table or Index</A>

<DD><A HREF="ch03/164-168.html#Heading16">GRANT and REVOKE: Set Permissions</A>

</DL>

<DD><A HREF="ch03/168-171.html#Heading17">Inserting Data into the Database</A>

<DL>

<DD><A HREF="ch03/168-171.html#Heading18">INSERT: Insert a Row Into a Table</A>

</DL>

<DD><A HREF="ch03/171-176.html#Heading19">Selecting Data from the Database</A>

<DL>

<DD><A HREF="ch03/171-176.html#Heading20">SQL and Relational Calculus</A>

<DD><A HREF="ch03/171-176.html#Heading21">One-Table Selection</A>

<DD><A HREF="ch03/179-183.html#Heading22">The Restrictive WHERE Clause</A>

<DD><A HREF="ch03/198-201.html#Heading23">Multi-Table Selections</A>

<DD><A HREF="ch03/201-205.html#Heading24">Unions</A>

<DD><A HREF="ch03/208-212.html#Heading25">ORDER BY: Sort Output</A>

<DD><A HREF="ch03/212-217.html#Heading26">DISTINCT and ALL: Eliminate or Request Duplicate Rows</A>

<DD><A HREF="ch03/212-217.html#Heading27">Outer Joins</A>

<DD><A HREF="ch03/217-221.html#Heading28">Built-in Functions</A>

<DD><A HREF="ch03/225-229.html#Heading29">Sub-Selects</A>

<DD><A HREF="ch03/229-233.html#Heading30">SELECT: Conclusion</A>

</DL>

<DD><A HREF="ch03/229-233.html#Heading31">Modifying the Data Within a Database</A>

<DL>

<DD><A HREF="ch03/229-233.html#Heading32">COMMIT and ROLLBACK: Commit or Abort Database Changes</A>

<DD><A HREF="ch03/233-237.html#Heading33">DELETE: Remove Rows From Tables</A>

<DD><A HREF="ch03/233-237.html#Heading34">Head UPDATE: Modify Rows Within a Table</A>

</DL>

<DD><A HREF="ch03/237-241.html#Heading35">Views</A>

<DD><A HREF="ch03/237-241.html#Heading36">Stored Procedures and Triggers</A>

<DD><A HREF="ch03/241-243.html#Heading37">Summary</A>

<DD><A HREF="ch03/243-246.html#Heading38">Further Reading</A>

</DL>

</DL>

</B></FONT>

<BR><DD><A HREF="ch04/247-251.html"><FONT SIZE="4"><B>PART II&#151;Programming Database Applications</B></FONT></A>

<FONT SIZE="3"><B>

<DL>

<DL>

<DD><A HREF="ch04/247-251.html#Heading1">Introduction</A>

</DL>

</B></FONT>

<DD><A HREF="ch04/247-251.html#Heading2"><FONT SIZE="4"><B>Chapter 4&#151;The Architecture of a Database Application</B></FONT></A>

<FONT SIZE="3"><B>

<DL>

<DD><A HREF="ch04/247-251.html#Heading3">What Is a Database Application?</A>

<DL>

<DD><A HREF="ch04/247-251.html#Heading4">Evolution of the Database Application</A>

</DL>

<DD><A HREF="ch04/251-255.html#Heading5">The Three-Tier Model</A>

<DL>

<DD><A HREF="ch04/255-259.html#Heading6">How the Tiers Relate to Each Other</A>

<DD><A HREF="ch04/255-259.html#Heading7">Benefits of the Three-Tier Model</A>

<DD><A HREF="ch04/255-259.html#Heading8">Three-Tier Model: An Example</A>

</DL>

<DD><A HREF="ch04/259-263.html#Heading9">Organization of Tiers into Programs</A>

<DL>

<DD><A HREF="ch04/259-263.html#Heading10">Clients and Servers</A>

<DD><A HREF="ch04/263-267.html#Heading11">Drivers</A>

</DL>

<DD><A HREF="ch04/267-271.html#Heading12">Web Access to a Database</A>

<DD><A HREF="ch04/271-275.html#Heading13">Summary</A>

<DD><A HREF="ch04/271-275.html#Heading14">Further Reading</A>

<DL>

<DD><A HREF="ch04/271-275.html#Heading15">ODBC</A>

<DD><A HREF="ch04/271-275.html#Heading16">JDBC</A>

<DD><A HREF="ch04/271-275.html#Heading17">CGI and Java</A>

<DD><A HREF="ch04/275-276.html#Heading18">Networking and Communication</A>

</DL>

</DL>

</B></FONT>

<DD><A HREF="ch05/277-282.html#Heading1"><FONT SIZE="4"><B>Chapter 5&#151;Accessing the Database</B></FONT></A>

<FONT SIZE="3"><B>

<DL>

<DD><A HREF="ch05/277-282.html#Heading2">Embedded SQL</A>

<DL>

<DD><A HREF="ch05/277-282.html#Heading3">Compiling Embedded SQL</A>

<DD><A HREF="ch05/277-282.html#Heading4">Structure of a Program</A>

<DD><A HREF="ch05/302-306.html#Heading5">Complex (Dynamic) SQL Statements</A>

</DL>

<DD><A HREF="ch05/321-324.html#Heading6">Open Database Connectivity (ODBC)</A>

<DL>

<DD><A HREF="ch05/321-324.html#Heading7">Structure of an ODBC Application</A>

<DD><A HREF="ch05/327-331.html#Heading8">Compiling and Running an ODBC Application</A>

<DD><A HREF="ch05/327-331.html#Heading9">Basic Program Structure</A>

<DD><A HREF="ch05/342-346.html#Heading10">Binding a Variable to a Parameter</A>

<DD><A HREF="ch05/346-350.html#Heading11">Reading Data from a SELECT Statement</A>

<DD><A HREF="ch05/355-359.html#Heading12">Handling User Input</A>

<DD><A HREF="ch05/355-359.html#Heading13">Transactions</A>

<DD><A HREF="ch05/359-363.html#Heading14">SQL Interpreter</A>

</DL>

<DD><A HREF="ch05/367-370.html#Heading15">Java Database Connectivity (JDBC)</A>

<DL>

<DD><A HREF="ch05/367-370.html#Heading16">Mini-SQL</A>

<DD><A HREF="ch05/367-370.html#Heading17">Structure of a JDBC Program</A>

<DD><A HREF="ch05/367-370.html#Heading18">Elements of the JDBC Standard</A>

<DD><A HREF="ch05/373-378.html#Heading19">A Simple Example</A>

<DD><A HREF="ch05/378-382.html#Heading20">Modifying the Database</A>

<DD><A HREF="ch05/382-386.html#Heading21">NULL Data</A>

<DD><A HREF="ch05/382-386.html#Heading22">Preparing a Statement</A>

<DD><A HREF="ch05/386-389.html#Heading23">General SQL Statements</A>

<DD><A HREF="ch05/393-396.html#Heading24">Meta-Data</A>

<DD><A HREF="ch05/396-400.html#Heading25">Other Features</A>

</DL>

<DD><A HREF="ch05/396-400.html#Heading26">Summary</A>

<DD><A HREF="ch05/396-400.html#Heading27">Further Reading</A>

<DL>

<DD><A HREF="ch05/396-400.html#Heading28">Embedded SQL</A>

<DD><A HREF="ch05/396-400.html#Heading29">ODBC</A>

<DD><A HREF="ch05/396-400.html#Heading30">mSQL</A>

<DD><A HREF="ch05/396-400.html#Heading31">JDBC</A>

</DL>

</DL>

</B></FONT>

<DD><A HREF="ch06/401-405.html#Heading1"><FONT SIZE="4"><B>Chapter 6&#151;Coding Front Ends</B></FONT></A>

<FONT SIZE="3"><B>

<DL>

<DD><A HREF="ch06/401-405.html#Heading2">Design Principles</A>

<DL>

<DD><A HREF="ch06/401-405.html#Heading3">Know Your User</A>

<DD><A HREF="ch06/401-405.html#Heading4">Programming Style</A>

<DD><A HREF="ch06/401-405.html#Heading5">Presenting Data</A>

<DD><A HREF="ch06/401-405.html#Heading6">Moving from Screen to Screen</A>

<DD><A HREF="ch06/401-405.html#Heading7">Modifying the Database</A>

<DD><A HREF="ch06/401-405.html#Heading8">Exiting</A>

</DL>

<DD><A HREF="ch06/401-405.html#Heading9">Common Gateway Interface</A>

<DL>

<DD><A HREF="ch06/401-405.html#Heading10">Disadvantages and Advantages</A>

<DD><A HREF="ch06/405-409.html#Heading11">Structure of the CGI Interface</A>

<DD><A HREF="ch06/418-421.html#Heading12">Coupling CGI with a Database</A>

<DD><A HREF="ch06/444-446.html#Heading13">CGI and Databases: An Extended Example</A>

<DD><A HREF="ch06/474-476.html#Heading14">Conclusion</A>

</DL>

<DD><A HREF="ch06/474-476.html#Heading15">Java</A>

<DL>

<DD><A HREF="ch06/476-479.html#Heading16">From Application to Applet</A>

<DD><A HREF="ch06/480-485.html#Heading17">Baseball Example</A>

<DD><A HREF="ch06/485-508.html#Heading18">An Extended Example</A>

</DL>

<DD><A HREF="ch06/508-510.html#Heading19">Summary</A>

<DD><A HREF="ch06/510-512.html#Heading20">Further Reading</A>

<DL>

<DD><A HREF="ch06/510-512.html#Heading21">Common-Gateway Interface</A>

<DD><A HREF="ch06/510-512.html#Heading22">HTTP Servers</A>

<DD><A HREF="ch06/510-512.html#Heading23">Javascript</A>

</DL>

</DL>

</B></FONT>

<DD><A HREF="ch07/513-516.html#Heading1"><FONT SIZE="4"><B>Chapter 7&#151;Middleware</B></FONT></A>

<FONT SIZE="3"><B>

<DL>

<DD><A HREF="ch07/513-516.html#Heading2">Encoding Semantic Information</A>

<DL>

<DD><A HREF="ch07/513-516.html#Heading3">Middleware Tasks</A>

<DD><A HREF="ch07/516-519.html#Heading4">Example: Inserting Data</A>

</DL>

<DD><A HREF="ch07/516-519.html#Heading5">Batch-Like Approach</A>

<DL>

<DD><A HREF="ch07/519-522.html#Heading6">Error Detection</A>

<DD><A HREF="ch07/525-528.html#Heading7">Decomposition of the Input</A>

</DL>

<DD><A HREF="ch07/528-531.html#Heading8">Drag-and-Drop Interface</A>

<DD><A HREF="ch07/531-532.html#Heading9">Protecting Against Deletion Anomalies</A>

<DD><A HREF="ch07/531-532.html#Heading10">Summary</A>

</DL>

</DL>

</DL>

<B></FONT>

<FONT SIZE="4"><B>

<DD><A HREF="appendix-a.html">Appendix A</A>

<DD><A HREF="appendix-b.html">Appendix B</A>

</B></FONT>

</DL>





</td>
</tr>
</table>

<!-- begin footer information -->





</body></html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -