tag:blogger.com,1999:blog-69950623839428500382011-11-27T16:10:17.681-08:00Indian Bloggernoreply@blogger.comBlogger601100tag:blogger.com,1999:blog-6995062383942850038.post-35085472480560046872009-02-13T11:17:00.000-08:002011-04-21T11:36:49.298-07:00<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: justify;">You can find book reviews regarding Oracle 10g, 11g, PL/SQL, SQL Server 2005 and MySQL. These books teaches you to install, create and share SQL Server 2005 reports, SQL server rendering, SQL Server reporting, Deploy and maintain report models, SQL Server report servicing, data accessing methods of MySQL, MySQL data retrieving and Data storing, Data accessing methods from multiple tables and MySQL statements, copy tables between different servers and MySQL database creation according to time schedules, Oracle Administration, Oracle practical examples, Oracle security implementations, oracle advance security, PL/SQL coding styles &amp; conventions, PL/SQL program construction and package construction, Oracle 11g new features, Oracle resiliency, Data gaurd, RMAN, secure files using encryption, Practical Questions and Lab Questions for OCP, Oracle 10g Database Administrators, drill exams for OCP, and 300 OCP exam questions with detailed answers and explanation.<br /><blockquote></blockquote>Following are the Database book reviews.<br /><ol><li><a href="http://freesqlebooks.blogspot.com/2008/11/professional-sql-server-2005-reporting.html">Professional SQL Server 2005 Reporting Services</a></li><li><a href="http://freesqlebooks.blogspot.com/2008/11/microsoft-sql-server-2005-reporting.html">Microsoft SQL Server 2005 Reporting Services Step by Step</a></li><li><a href="http://freesqlebooks.blogspot.com/2008/11/mysql-language-reference.html">MySQL Language Reference</a></li><li><a href="http://freesqlebooks.blogspot.com/2008/04/mysql-cookbook.html">MySQL Cookbook</a></li><li><a href="http://freeoracleebook.blogspot.com/2008/11/oca-oracle-10g-administration-i-study.html">OCA: Oracle 10g Administration I Study Guide (1Z0-042)</a></li><li><a href="http://freeoracleebook.blogspot.com/2008/11/oracle-plsql-best-practices.html">Oracle PL/SQL Best Practices</a></li><li><a href="http://freeoracleebook.blogspot.com/2008/11/oracle-database-11g-new-features-for.html">Oracle Database 11g: New Features for DBAs and Developers</a></li><li><a href="http://freeoracleebook.blogspot.com/2008/04/ocp-oracle-database-10g-new-features.html">OCP Oracle Database 10g: New Features for Administrators Exam Guide</a></li></ol><span style="color: red; font-weight: bold;">Related DBMS Ebooks</span><br /><ul><li><a href="http://more-database.blogspot.com/2008/01/download-free-dbms-ebooks.html">60 Oracle, PL/SQL, SQL, MySQL, Sybase, Microsoft SQL Server, ebooks</a></li></ul></div></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-3508547248056004687?l=more-database.blogspot.com' alt='' /></div>Indian Bloggernoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-71613324285947835702008-12-27T13:50:00.000-08:002011-04-21T13:39:55.770-07:00<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: justify;"><span style="color: #000099;">Sybase Stored Procedures for the World Wide Web is written by Denis D. Workman.</span><br /><span style="font-weight: bold;"><blockquote></blockquote>Introduction</span> (By author)<br />This guide will attempt to show you how to create stored procedures for the World Wide Web. As I was in the middle of writing this guide, I realized it was about 10 times more lengthy than what I intended. The interface you will be using is slick, writing stored procedures is a snap, and you can do some marvelous things in a very short time. But, there is lots of good information in this guide, and I wanted to be as complete as possible.</div><blockquote></blockquote><div style="text-align: justify;">There is a facility known as the Common Gateway Interface or CGI that extends the functionality of a Web Server. This feature makes it possible to pass information from the client to an external application (known as the CGI application) which processes the information and returns the result to the client through the Web Server. Sybernet is a CGI that talks to a Sybase database....</div><div style="text-align: justify;"><blockquote></blockquote>Following are the topics covered in this Sybase book. <br /><blockquote></blockquote>1. Introduction<br />2. What you will need<br />* A Web Server<br />* A Web Browser<br />* A Stored Procedure Editor<br />* Knowledge of HTML syntax<br />* Knowledge of writing stored procedures<br />* A Sybase account<br />3. Writing your stored procedure<br />* The Form Screen<br />* The Report Screen<br />* Explaining the Form Screen<br />* Explaining the Report Screen<br />* Registering your procedure<br />4. Formatting Result Sets<br />5. Tips and Techniques<br />* Frames<br />* Tables and Forms<br />* Buttons<br />* User Preferences and the Menu Bar<br />* Putting It All Together<br />* Advanced Form Input<br />* Form Input and Line Items<br />6. Sending Partial Result Sets<br />7. Handling Text and Image Data Types<br />* Selecting Text and Image Data<br />* Storing Text and Image Data<br />* Retrieving Images<br />8. Advanced Topics<br />* URL's<br />* Redirection<br />* Image Maps<br />* HTTP Cookies<br />* HTTP Headers<br />* Filters<br />* Filters, Formats, and Content-types<br />* Rich Text Format<br />9. Reference<br />* Sybernet Reserved Words<br />* Security<br />* The Stored Procedure Editor<br />* The Stored Procedure Register<br />* Interactive SQL<br />* Limitations<br />* Bibliography<br />* Links</div><blockquote></blockquote>You can download or read this Sybase ebook from the following link.<br /><blockquote></blockquote><a href="http://sybernet.sri.com/" target="_blank">Read More/Download</a><br /><blockquote></blockquote><span style="color: red; font-weight: bold;">Related DBMS Books</span><br /><ol><li><a href="http://more-database.blogspot.com/2008/01/download-free-dbms-ebooks.html">Download free DBMS Ebooks (50+ books)<br /></a></li><li><a href="http://freee-booksdownload.blogspot.com/2008/04/free-structured-query-language-sql.html">SQL free ebooks</a></li><li><a href="http://freee-booksdownload.blogspot.com/2008/02/free-database-management-systems-ebooks.html">Database Management Systems</a></li></ol><span style="color: red; font-weight: bold;">Buy DBMS books</span><br /><ol><li><a href="http://www.amazon.com/gp/product/0672329166?ie=UTF8&amp;tag=frsaabeb-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=0672329166" target="_blank">PHP and MySQL Web Development (4th Edition) (Developer's Library)</a></li><li><a href="http://www.amazon.com/gp/product/0596527608?ie=UTF8&amp;tag=frsaabeb-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=0596527608" target="_blank">Access 2007: The Missing Manual</a></li><li><a href="http://www.amazon.com/gp/product/0672328240?ie=UTF8&amp;tag=frsaabeb-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=0672328240" target="_blank">Microsoft SQL Server 2005 Unleashed</a></li><li><a href="http://www.amazon.com/gp/product/0072263172?ie=UTF8&amp;tag=frsaabeb-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=0072263172" target="_blank">Oracle Database 10g RMAN Backup &amp; Recovery</a></li><li><a href="http://www.amazon.com/gp/product/0072253517?ie=UTF8&amp;tag=frsaabeb-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=0072253517" target="_blank">Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)</a><br /></li></ol></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-7161332428594783570?l=more-database.blogspot.com' alt='' /></div>Indian Bloggernoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-37206620368947654872008-01-31T11:07:00.000-08:002011-10-27T11:36:13.432-07:00<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: justify;">This posting helps you to get free ebooks and tutorials on Datawarehousing, Data Mining, DBMS, RDBMS, ORACLE, PL/SQL, MySQL, Microsoft SQL Server, Microsoft ACCESS, Data modelling techniques, Database programming with several languages, DB2, information modelling, information retrieval, Oracle datawarehousing, sqlplus , etc</div><div style="text-align: justify;"><blockquote></blockquote>Visit the following links to get free ebooks downloads in oracle, pl/sql, mysql, sql server, access , etc. Ebooks provided by this site are</div><ol><li><a href="http://more-database.blogspot.com/2007/03/advanced-oracle-plsql-programming-with.html">Advanced Oracle PL/SQL Programming with Packages By Steven Feuerstein</a></li><li><a href="http://more-database.blogspot.com/2006/12/building-database-driven-web-site-using.html">Building a Database-Driven Web Site Using PHP and MySQL by Kevin Yank</a></li><li><a href="http://more-database.blogspot.com/2006/12/concurrency-control-and-recovery-in.html">Concurrency Control and Recovery in Database Systems By Philip A. Bernstein, Vassos Hadzilacos and Nathan Goodman</a></li><li><a href="http://more-database.blogspot.com/2006/12/data-mining-desktop-survival-guide-by.html">DATA MINING Desktop Survival Guide by Graham Williams</a></li><li><a href="http://more-database.blogspot.com/2007/02/data-modeling-techniques-for-data.html">Data Modeling Techniques for Data Warehousing</a></li><li><a href="http://more-database.blogspot.com/2006/12/data-transfer-strategies-transferring.html">Data Transfer Strategies - Transferring data between XML documents and relational databases by Ronald Bourret</a></li><li><a href="http://more-database.blogspot.com/2006/12/database-programming-with-perl-by.html">Database Programming with Perl By Kirrily Robert</a></li><li><a href="http://more-database.blogspot.com/2006/12/db2-java-stored-procedures-learning-by.html">DB2 Java Stored Procedures By Maria Sueli Almeida, Kirk Condon, Michael Fischer and Julian Stuhler</a></li><li><a href="http://more-database.blogspot.com/2006/12/developing-clientserver-applications.html">Developing Client/Server Applications with Oracle by Paul Hipsley</a></li><li><a href="http://more-database.blogspot.com/2006/12/developing-personal-oracle7-for.html">Developing Personal Oracle7ª for Windows[rm]95 Applications, Second Edition By David Lockman</a></li><li><a href="http://more-database.blogspot.com/2006/12/dilips-brief-introduction-to-relational.html">Dilip's Brief Introduction to Relational Databases - cs.unc.edu</a></li><li><a href="http://more-database.blogspot.com/2006/12/getting-started-with-mysql-1995-2006.html">Getting Started with MySQL From dev.mysql.com</a></li><li><a href="http://more-database.blogspot.com/2006/12/gradiance-sql-tutorial-gradiance.html">Gradiance SQL Tutorial</a></li><li><a href="http://more-database.blogspot.com/2006/12/ibm-db2-application-development-guide.html">IBM DB2 Application Development Guide</a></li><li><a href="http://more-database.blogspot.com/2006/12/information-modeling-by-david-edmond.html">Information Modeling By David Edmond</a></li><li><a href="http://more-database.blogspot.com/2007/02/information-retrieval.html">Information Retrieval By C. J. van RIJSBERGEN</a></li><li><a href="http://more-database.blogspot.com/2006/12/interactive-sql-tutorial-sqlzoo.html">Interactive SQL tutorial From sqlzoo.net</a></li><li><a href="http://more-database.blogspot.com/2006/12/introduction-to-databases-for-web.html">Introduction to Databases for web developers</a></li><li><a href="http://more-database.blogspot.com/2006/12/introduction-to-structured-query.html">Introduction to Structured Query Language: Version 4.11 By James Hoffman</a></li><li><a href="http://more-database.blogspot.com/2006/12/jccs-sql-standards-page-this-page-is.html">JCC's SQL Standards Page</a></li><li><a href="http://more-database.blogspot.com/2007/02/microsoft-access-97-quick-reference.html">Microsoft® Access 97 Quick Reference</a></li><li><a href="http://more-database.blogspot.com/2006/12/mysql-5.html">MySQL 5.1 Reference Manual - MySQL AB</a></li><li><a href="http://more-database.blogspot.com/2007/03/oracle-built-in-packages.html">Oracle Built-in Packages By Steven Feuerstein, Charles Dye and John Beresniewicz</a></li><li><a href="http://more-database.blogspot.com/2007/03/oracle-data-warehousing-unleashed.html">Oracle Data Warehousing Unleashed By Bonnie O'neill et al</a></li><li><a href="http://more-database.blogspot.com/2007/02/oracle-database-10g-release-1-101.html">Oracle Database 10g Release 1 (10.1) Documentation Library</a></li><li><a href="http://more-database.blogspot.com/2007/02/oracle-documentation-absolute-unique.html">ORACLE Documentation (Absolute Unique Library)</a></li><li><a href="http://more-database.blogspot.com/2006/12/oracle-performance-tuning-and.html">Oracle Performance Tuning and Optimization by Edward Whalen</a></li><li><a href="http://more-database.blogspot.com/2007/03/oracle-plsql-built-ins-pocket-reference.html">Oracle PL/SQL Built-ins Pocket Reference By Steven Feuerstein, John Beresniewicz and Chip Dawes</a></li><li><a href="http://more-database.blogspot.com/2007/03/oracle-plsql-language-pocket-reference.html">Oracle PL/SQL Language Pocket Reference By Steven Feuerstein, Bill Pribyl and Chip Dawes</a></li><li><a href="http://more-database.blogspot.com/2007/03/oracle-plsql-programming-guide-to.html">Oracle PL/SQL Programming - Guide to Oracle8i Features By Steven Feuerstein</a></li><li><a href="http://more-database.blogspot.com/2007/03/oracle-plsql-programming-second-edition.html">Oracle PL/SQL Programming Second Edition By Steven Feuerstein and Bill Pribyl</a></li><li><a href="http://more-database.blogspot.com/2007/03/oracle-web-applications-plsql.html">Oracle Web Applications PL/SQL Developer's Introduction By Andrew Odewahn</a></li><li><a href="http://more-database.blogspot.com/2006/12/oracle8-black-book-publisher-coriolis.html">Oracle8 Black Book By Michael R. Ault</a></li><li><a href="http://more-database.blogspot.com/2006/12/oracler-programming-with-visual-basic.html">Oracler Programming with Visual Basicr By Nick Snowdon</a></li><li><a href="http://more-database.blogspot.com/2007/04/oracle-database-sql-reference-10g.html">Oracle® Database SQL Reference 10g Release 2</a></li><li><a href="http://more-database.blogspot.com/2006/12/oracle-unleashed-first-edition-sams.html">Oracle™ Unleashed First Edition</a></li><li><a href="http://more-database.blogspot.com/2006/12/practical-postgresql-by-john-c.html">Practical PostgreSQL by John C. Worsley and Joshua D. Drake</a></li><li><a href="http://more-database.blogspot.com/2006/12/rdbms-relational-database-management.html">RDBMS - Relational Database Management Systems By Christopher Browne</a></li><li><a href="http://more-database.blogspot.com/2006/12/relational-databases-by-anthony-and.html">Relational Databases by Anthony and Hala Awtrey</a></li><li><a href="http://more-database.blogspot.com/2006/12/oracle-unleashed-sams-publishing.html">Sams Oracle™ Unleashed</a></li><li><a href="http://more-database.blogspot.com/2007/02/sams-teach-yourself-microsoft-sql.html">Sams Teach Yourself Microsoft SQL Server 7 in 21 Days By Richard Waymire and Rick Sawtell</a></li><li><a href="http://more-database.blogspot.com/2007/02/sams-teach-yourself-sql-in-24-hours.html">Sams Teach Yourself SQL in 24 Hours By Ron Plew and Ryan Stephens</a></li><li><a href="http://more-database.blogspot.com/2006/12/special-edition-using-microsoft-sql.html">Special Edition Using Microsoft SQL Server 6.5 by Stephen Wynkoop</a></li><li><a href="http://more-database.blogspot.com/2006/12/sql-structured-query-language-by.html">SQL - Structured Query Language By Welland Barn</a></li><li><a href="http://more-database.blogspot.com/2006/12/sql-for-web-nerds-by-philip-greenspun.html">SQL for Web Nerds by Philip Greenspun</a></li><li><a href="http://more-database.blogspot.com/2006/12/sql-fundamentals-by-mike-chapple.html">SQL Fundamentals By Mike Chapple</a></li><li><a href="http://more-database.blogspot.com/2006/12/sql-server-2000-administrators-pocket.html">SQL Server 2000 Administrator's Pocket Consultant By William R. Stanek</a></li><li><a href="http://more-database.blogspot.com/2006/12/sql-tutorial-by-sqlcourse2.html">SQL Tutorial By SQLCourse2.com</a></li><li><a href="http://more-database.blogspot.com/2006/12/structured-query-languagesql-practical.html">Structured Query Language(SQL) A Practical Introduction By Akeel I Din</a></li><li><a href="http://more-database.blogspot.com/2006/12/sybase-sql-server-11-unleashed-by-jeff.html">Sybase SQL Server 11 Unleashed by Jeff Garbus</a></li><li><a href="http://more-database.blogspot.com/2007/02/teach-yourself-oracle-8-in-21-days.html">Teach Yourself Oracle 8 In 21 Days By Edward Whalen</a></li><li><a href="http://more-database.blogspot.com/2006/12/teach-yourself-sql-in-21-days-second.html">Teach Yourself SQL in 21 Days, Second Edition- Macmillan Computer Publishing</a></li><li><a href="http://more-database.blogspot.com/2006/12/rise-of-relational-databases-www.html">The Rise of Relational Databases From www.nap.edu</a></li><li><a href="http://more-database.blogspot.com/2007/02/up-and-running-with-db2-udb-ese.html">Up and Running with DB2 UDB ESE: Partitioning for Performance in an e-Business Intelligence World</a></li><li><a href="http://more-database.blogspot.com/2006/12/using-oracle-plsql-infolab.html">Using Oracle PL/SQL - infolab.stanford.edu</a></li><li><a href="http://more-database.blogspot.com/2006/12/using-oracle8-macmillan-computer.html">Using Oracle8 - Macmillan Computer Publishing</a></li><li><a href="http://more-database.blogspot.com/2006/12/xml-query-language-xql-authors-jonathan.html">XML Query Language (XQL) By Jonathan Robie, Joe Lapp and David Schach</a></li></ol><a href="http://more-database.blogspot.com/"><br /></a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-3720662036894765487?l=more-database.blogspot.com' alt='' /></div>Indian Bloggernoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-52379661658092455372007-04-27T04:34:00.000-07:002008-12-18T12:14:45.291-08:00<div align="justify">This reference contains a complete description of the Structured Query Language (SQL) used to manage information in an Oracle Database. Oracle SQL is a superset of the American National Standards Institute (ANSI) and the International Standards Organization (ISO) SQL:1999 standard.</div><div align="justify"><blockquote></blockquote>The Oracle Database SQL Reference is intended for all users of Oracle SQL.</div><blockquote></blockquote><div align="justify">For more information, see these Oracle resources:</div><div align="justify"><ul><li>PL/SQL User's Guide and Reference for information on PL/SQL, the procedural language extension to Oracle SQL</li><li>Pro*C/C++ Programmer's Guide, Oracle SQL*Module for Ada Programmer's Guide, and the Pro*COBOL Programmer's Guide for detailed descriptions of Oracle embedded SQL</li></ul></div><p align="justify">Many of the examples in this book use the sample schemas, which are installed by default when you select the Basic Installation option with an Oracle Database installation. Refer to Oracle Database Sample Schemas for information on how these schemas were created and how you can use them yourself.</p><p align="justify"><a href="http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-5237966165809245537?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-28947150451965435372007-03-23T16:36:00.000-07:002008-12-18T12:14:45.292-08:00<div align="center">By Steven Feuerstein, John Beresniewicz and Chip Dawes</div><blockquote></blockquote><div align="justify">The Oracle PL/SQL Built-ins Pocket Reference is a quick reference guide to the many built-in packages and functions provided by Oracle Corporation. It contains a concise description of the syntax for the following:</div><ul><li><div align="justify">Built-in packages</div></li><li><div align="justify">Built-in functions</div></li><li><div align="justify">RESTRICT REFERENCES pragmas for the built-in packages</div></li><li><div align="justify">Nonprogram elements (e.g., constants, exceptions, etc.) defined in the built-in packages</div></li></ul><p align="justify">Although we don't include every single package and function in this pocket reference, we've included all the built-ins that most PL/SQL developers will ever need to use.</p><p align="justify">The purpose of this pocket reference is to help PL/SQL users find the syntax of specific built-in headers. It is not a self-contained user guide; basic knowledge of PL/SQL and its built-ins is required. For more information, see the following books:</p><ul><li><div align="justify">Oracle PL/SQL Programming, by Steven Feuerstein and Bill Pribyl (O'Reilly & Associates, Second Edition, 1997).</div></li><li><div align="justify">Oracle Built-in Packages, by Steven Feuerstein, Charles Dye, and John Beresniewicz (O'Reilly &amp; Associates, 1998).</div></li></ul><p align="justify"><a href="http://nukz.net/reference/plsql/bipkt/index.htm" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-2894715045196543537?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-14247881745473621732007-03-23T16:31:00.000-07:002008-12-18T12:14:45.292-08:00<div align="center">By Steven Feuerstein, Bill Pribyl and Chip Dawes</div><div align="justify"><blockquote></blockquote>The Oracle PL/SQL Language Pocket Reference is a quick reference guide to the PL/SQL programming language, which provides procedural extensions to the SQL relational database language and a range of Oracle development tools.<br /><blockquote></blockquote>Where a package, program, or function is supported only for a particular version of Oracle (e.g., Oracle8i), we indicate this in the text.<br /><blockquote></blockquote>The purpose of this pocket reference is to help PL/SQL users find the syntax of specific language elements. It is not a self-contained user guide; basic knowledge of the PL/SQL programming language is required. </div><blockquote></blockquote><div align="justify">For more information, see the following books:<br /></div><blockquote></blockquote><ul><li><div align="justify">Oracle PL/SQL Programming, 2nd Edition, by Steven Feuerstein with Bill Pribyl (O'Reilly & Associates, 1997).</div></li><li><div align="justify">Oracle Built-in Packages, by Steven Feuerstein, Charles Dye, and John Beresniewicz (O'Reilly &amp; Associates, 1998).</div></li><li><div align="justify">Oracle PL/SQL Built-ins Pocket Reference, by Steven Feuerstein, John Beresniewicz, and Chip Dawes (O'Reilly &amp; Associates, 1998).</div></li></ul><p align="justify"><a href="http://nukz.net/reference/plsql/langpkt/index.htm" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-1424788174547362173?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-6194609504026335232007-03-23T16:28:00.000-07:002008-12-18T12:14:45.293-08:00<div align="center">By Andrew Odewahn</div><div align="justify"><blockquote></blockquote>The goal of Oracle Web Applications is to help Oracle SQL and PL/SQL developers who have little or no web programming experience to learn to develop useful web applications, using technologies most IS developers can grasp fairly quickly: WebDB, Oracle Application Server (OAS), PL/SQL, HTML, and XML.<br /><blockquote></blockquote>In addition, the book introduces several other Oracle8i technologies -- Advanced Queuing (AQ), the Internet File System (iFS), interMedia, InternetLite, and Java(TM) -- and shows how they form a cohesive development framework that addresses the pressing issues of web content management, application development, and application integration. While there have been many changes in Oracle8i, it's still just a database, and there's no need to panic: data is data, whether it comes from the accounts payable system or from the Internet.<br /><blockquote></blockquote>This book acknowledges that you're a busy person. Since most of us simply don't have time to read and digest an 800-page book on each individual technology, I've tried to present fundamental elements of the topics you'll use most often in your daily development efforts. This book will get you started and solidly on your way, but it's not, obviously, the ultimate reference. Rather, it is a "Cliff Notes" of Oracle web development -- enough to help you pass the test, but not enough to help you appreciate the finer points. Once you've read the book, however, you'll be ready to delve into the various areas (WebDB, PL/SQL, Java, etc.) more deeply. Your first step on that journey should be to consult the appendix for information on further resources.</div><div align="justify"><blockquote></blockquote><a href="http://nukz.net/reference/plsql/webapp/index.htm" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-619460950402633523?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-69270323113598815532007-03-23T16:22:00.000-07:002008-12-18T12:14:45.293-08:00<div align="center">By Steven Feuerstein</div><blockquote></blockquote><div align="justify">Who would have thought that just one year after the publication of Oracle PL/SQL Programming, a 916-page tome on "everything PL/SQL", I'd end up writing a second book about the PL/SQL language? Although back in September 1995 I wasn't arrogant enough to think that I knew all there was to know about PL/SQL, I also underestimated how much more I had still to learn!<br /><blockquote></blockquote>I am firmly of the belief that one never stops learning -- as long as one is open to learning. The area of PL/SQL in which I needed lots more education turned out to be packages. In my first book I explained how to build and use packages. I even provided lots of examples of package construction. But I started to realize that this wasn't enough. Over the past year, I have been designing and developing a set of packages to help me build PL/SQL-based applications. This was a thoroughly selfish effort: I wanted to be as productive as possible, and I wanted to overcome a number of weaknesses -- however transient -- in the PL/SQL language. In the process of writing this software, I learned a good deal about the best ways to build PL/SQL code, especially regarding packages. I also discovered some very interesting techniques that can make packaged software more maintainable, accessible, and easy to use.<br /><blockquote></blockquote>As my thinking on the construction of packages crystallized, I began to view all of my packages as a library of code that could be used by any PL/SQL developer. I also realized that I wanted to share the new techniques and lessons I had uncovered. The result? This book and the PL/Vision product.<br /><blockquote></blockquote>How often do you find yourself writing a program and simultaneously thinking: somebody must have done this before! You feel certain that you are reinventing the wheel. Worse, if you are sufficiently honest with yourself, you will also admit that someone else has probably spent more time on the problem and has already come up with a better solution than you are likely to develop for your specific application.<br /><blockquote></blockquote>Often, you know you should take the time to "genericize" a program so that you can use it again and again in different circumstances. Somehow, however, you never find the time -- and the mental space -- to take your code to that higher level of abstraction.<br /><blockquote></blockquote>So you limp along, accepting a relatively low level of productivity and reusing a truly minimal amount of code. You write the same things over and over and simply push aside the feeling that you are wasting your time.<br /><blockquote></blockquote>Oracle developers are fortunate to be able to use an advanced, robust language like PL/SQL. PL/SQL developers are, on the other hand, less than fortunate (at least as of September 1996) to find that the supporting environment for PL/SQL is still very immature. Where are the debuggers, the code formatters and generators, the toolboxes of reusable programs and objects? When will we have a powerful editor that knows about PL/SQL syntax and -- more importantly -- the stored code available for execution?<br /><blockquote></blockquote>When, you might also ask, will this guy stop complaining? It is acceptable to identify weaknesses. It is constructive to analyze areas for improvement. At some point, however, you have to stop whining and start improving things for yourself. Best yet, keep on whining but engage in self-improvement at the same time!<br /><blockquote></blockquote>This book will help you write better packages. It will also show you how to use the "prebuilt" packages of the PL/Vision software product -- my attempt to change the "situation on the ground" for PL/SQL programmers. Finally, I hope that it will, via examination of my source code and the way I separated functional areas in PL/Vision, offer a blueprint for PL/SQL developers to discover how to take full advantage of PL/SQL packages in their day-to-day programming. </div><p align="justify"><a href="http://nukz.net/reference/plsql/advprog/index.htm" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-6927032311359881553?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-91939949244739737542007-03-23T16:18:00.000-07:002008-12-18T12:14:45.294-08:00<div align="center">By Steven Feuerstein, Charles Dye and John Beresniewicz</div><div align="justify"><blockquote></blockquote>After publishing more than 1,600 pages on Oracle PL /SQL in two previous books, I marvel at the existence now of this third book covering yet other aspects of the PL /SQL language. I can still remember quite distinctly a moment in September, 1994, when I embarked on writing the first draft of Oracle PL /SQL Programming and wondered: are there really 400 pages worth of material on that much-used and often-maligned procedural language from a nonprocedural (SQL) company? If the answer to that question was a resounding "yes" in 1994, then the answer is a deafening roar today!<br /><blockquote></blockquote>Maybe PL /SQL isn't the answer to every object-oriented programmer's deepest desires. Maybe developers are badly in need of -- and unreservedly deserve -- better tools with which to write, debug, and reuse PL /SQL programs. Maybe PL /SQL isn't perfect, but the reality is that hundreds of thousands of people around the world work (and struggle) with PL /SQL on a daily basis. We all need as much information as possible about how we can make the best possible use of Oracle PL /SQL.<br /><blockquote></blockquote>And that is the objective of Oracle Built-in Packages. If you are going to build complex applications using PL /SQL, you will not succeed unless you learn about and figure out how to utilize many of the packages described in this book. Packages are the method of choice for Oracle and third parties like RevealNet, Inc., to extend the base PL /SQL language, to improve ease of use, and to provide brand-new functionality in the language. Writing PL /SQL code without knowing about or using built-in packages is akin to building an automobile and ignoring the last 20 years of technological advances. The resulting machine will run more slowly, use more gas, and be harder to repair.<br /><blockquote></blockquote>Oracle Built-in Packages grew out of Chapter 15 of the first edition of Oracle PL /SQL Programming. When Oracle released Oracle8, it was time to update that book to include the wide-ranging new PL /SQL8 functionality. It was clear from the start that this second edition, if organized like the first, would have been well over 1,500 pages in length -- a totally impractical size for a developer's handbook.<br /><blockquote></blockquote>What to do? Based on feedback from developers about Oracle PL /SQL Programming, there was an enormous amount of interest in, and often confusion surrounding, the built-in packages. These Oracle-provided "add-ons" to PL /SQL clearly needed more detailed coverage, more examples, more tips, more of just about everything. My single chapter of 100 pages was woefully inadequate. We made the decision to move that single chapter out of Oracle PL /SQL Programming and expand it into a book all its own. You are holding the result.<br /><blockquote></blockquote>I recognized early in the process that I couldn't personally cover all of the Oracle built-in packages discussed in this book. I didn't have the necessary expertise, nor the time to learn, nor the time to write it all. So I sought and received the help of two excellent Oracle technologists: John Beresniewicz and Charles Dye.<br /><blockquote></blockquote>Over the past six months, John, Charles, and I have researched the packages provided by Oracle in the database, verified the documentation, uncovered aberrant behavior, and discovered neat tricks. We also made it a priority to construct package-based utilities that you will be able to put to immediate use.<br /><blockquote></blockquote>While Oracle Built-in Packages is a collaborative effort, it is also a combination of very individual efforts. As such, you will find differences in coding styles and philosophies. Rather than try to enforce a single standard throughout, I welcomed the variations (as long as all contributed in their own way to a deeper, clearer understanding of the PL /SQL technology). There is rarely a single right way to do anything, and there is an enormous amount we can learn from the different journeys each of us takes to a solution.</div><div align="justify"><blockquote></blockquote><a href="http://nukz.net/reference/plsql/bipack/index.htm" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-9193994924473973754?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-10805574447257950652007-03-23T16:13:00.000-07:002008-12-18T12:14:45.294-08:00<div align="center">By Steven Feuerstein</div><div align="justify"><blockquote></blockquote>2700 pages and still writing! Sometimes I feel like the Energizer Bunny of PL/SQL. But Oracle keeps the features coming, and after all these years, I'm still enthusiastic about what PL/SQL can do to improve the quality of life for developers. Even with the coming of Java(TM) in Oracle8i, I believe strongly that the future is bright for PL/SQL developers.<br /><blockquote></blockquote>This short book is something of a departure for me -- those of you who have read my larger tomes may wonder if I've found a ghostwriter! Now that Oracle8i is here, it's my intention to update Oracle PL/SQL Programming (now in its second edition) to cover the new version of the Oracle database. Along with developing a third edition of that book (with my coauthor Bill Pribyl), I'm taking a critical look at all of my books to make sure that the O'Reilly & Associates PL/SQL series offers a comprehensive resource for PL/SQL developers.<br /><blockquote></blockquote>For now, though, PL/SQL developers need current and useful information about the latest PL/SQL features; there are a lot of them, and some represent major changes in the language. This small book is intended to get you started on understanding these features and using them to best advantage.<br /><blockquote></blockquote>For many people, the big news about Oracle8i is Java, and the big question for many PL/SQL developers is how (and whether) to use Java in conjunction with PL/SQL. Chapter 9, Calling Java from PL/SQL, is a roadmap showing PL/SQL developers how to employ Java right now. It doesn't attempt to teach you the basics of Java -- there are many other books that serve that purpose -- but it does teach you how to access Java from within PL/SQL.</div><div align="justify"><blockquote></blockquote><a href="http://nukz.net/reference/plsql/guide8i/index.htm" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-1080557444725795065?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-47364657621611638192007-03-23T16:07:00.000-07:002008-12-18T12:14:45.295-08:00<div align="center">By Steven Feuerstein and Bill Pribyl</div><div align="justify"><blockquote></blockquote><strong>What, specifically, will this book help you do?</strong><br /><em>Take full advantage of PL/SQL.</em> The reference manuals may describe all the features of the PL/SQL language, but they don't tell you how to apply the technology. In fact, in some cases, you'll be lucky to even understand how to use a given feature after you've made your way through the railroad diagrams. Books and training courses tend to cover the same standard topics in the same limited way. In this book, we'll venture beyond to the edges of the language, to the nonstandard ways in which a particular feature can be tweaked to achieve a desired result.<br /><blockquote></blockquote><em>Use PL/SQL to solve your problems.</em> You don't spend your days and nights writing PL/SQL modules so that you can rise to a higher plane of existence. You use PL/SQL to solve problems for your company or your customers. In this book, I try hard to help you tackle real-world problems, the kinds of issues developers face on a daily basis (at least those problems that can be solved with mere software). To do this, I've packed the book with examples -- not just small code fragments, but complete application components you can apply immediately to your own situations. There is a good deal of code in the book itself, and much more on the disk that accompanies the book. In this book I guide you through the analytical process used to come up with a solution. In this way I hope you'll see, in the most concrete terms, how to apply PL/SQL features and undocumented applications of those features to a particular situation.<br /><blockquote></blockquote><em>Write efficient, maintainable code.</em> PL/SQL and the rest of the Oracle products offer the potential for incredible development productivity. If you aren't careful, however, this rapid development capability will simply let you dig yourself into a deeper, darker hole than you've ever found yourself in before. I would consider this book a failure if it only ended up helping programmers write more code in less time than ever before. I want to help you develop the skills and techniques that give you the time to build modules which readily adapt to change and are easily understood and maintained. I want to teach you to use comprehensive strategies and code architectures which allow you to apply PL/SQL in powerful, general ways to many of the problems you will face. </div><div align="justify"><blockquote></blockquote><a href="http://nukz.net/reference/plsql/prog2/index.htm" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-4736465762161163819?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-69177593183993620202007-03-23T15:57:00.000-07:002008-12-18T12:14:45.295-08:00<div align="center">By Bonnie O'neill et al </div><div align="justify"><blockquote></blockquote>You have decided to embark on a data warehouse journey. You are probably a little scared and overwhelmed by the immensity of the project in front of you. You are probably also wondering where to start.<br /><blockquote></blockquote>This book is designed to be a definitive reference guide for all project staff having anything to do with the data warehouse. Here is an overview of the types of job classes that would benefit from this book:<br /><blockquote></blockquote><em>Project managers:</em> The book provides a chapter on project management, and one of the appendixes has a task checklist to assist you. The methodology and architecture chapters help you in understanding what you are going to build and some best-practice guidelines in how to do it. In addition, the rest of the book, while geared for a more technical audience, can give you a feel for what to expect and what kinds of obstacles you will likely encounter throughout the expedition.<br /><blockquote></blockquote><em>Data administrators:</em> A few chapters are designed especially for you: "Data Integration: The Challenges," "Defining Your Data," "Metadata," and the database design chapters. You might also find the architecture and methodology chapters interesting.<br />Quality analysts: the data integration, metadata, and data scrubbing chapters are right up your alley.<br /><blockquote></blockquote><em>DBAs:</em> Many chapters are of interest to DBAs, including (but not limited to) storage concerns, physical database design, exploiting parallel technology, indexes, kernel performance tuning, and security.<br /><blockquote></blockquote><em>Application architects and developers:</em> There are lots of chapters that help you get a feel for how to exploit the warehouse so the end user can get the maximum benefit possible. Some of these chapters are "Using the Intranet," "Front-End Tools," "Tuning Queries," and "Data Mining."<br /><blockquote></blockquote><em>Data warehouse architects:</em> The book contains a wealth of architecture and methodology information, and also discusses related constructs tangential to the data warehouse, including the operational data store and data marts. </div><div align="justify"><blockquote></blockquote><a href="http://freebooks.by.ru/view/OracleDataWarehouseUnleashed/ewtoc.html" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-6917759318399362020?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-26036813299685677032007-02-15T03:44:00.000-08:002008-12-18T12:14:45.296-08:00<div align="center">By Ron Plew and Ryan Stephens</div><div align="justify"><blockquote></blockquote><strong>Who Should Read This Book?</strong><br />Welcome to the world of relational databases and SQL! This book is written for those self-motivated individuals out there who would like to get an edge on relational database technology by learning the Structured Query LanguageSQL. This book was written primarily for those with very little or no experience with relational database management systems using SQL. This book also applies to those who have some experience with relational databases but need to learn how to navigate within the database, issue queries against the database, build database structures, manipulate data in the database, and more. This book is not geared toward individuals with significant relational database experience who have been using SQL on a regular basis.<br /><blockquote></blockquote><strong>What This Book Intends to Accomplish</strong><br />This book was written for individuals with little or no experience using SQL or those who have used a relational database, but their tasks have been very limited within the realm of SQL. Keeping this thought in mind, it should be noted up front that this book is strictly a learning mechanism, and one in which we present the material from ground zero and provide examples and exercises with which to begin to apply the material covered. This book is not a complete SQL reference and should not be relied on as a sole reference of SQL. However, this book combined with a complete SQL command reference could serve as a complete solution source to all of your SQL needs.<br /><blockquote></blockquote><strong>What We Added to This Edition</strong><br />This edition contains the same content and format as the first and second editions. We have been through the entire book, searching for the little things that could be improved to produce a better edition. We have also added concepts and commands from the new SQL standard, SQL3, to bring this book up to date, making it more complete and applicable to today's SQL user. The most important addition was the use of MySQL for hands-on exercises. By using an open source database such as MySQL, all readers have equal opportunity for participation in hands-on exercises.<br /><blockquote></blockquote><strong>What You Need</strong><br />You may be wondering, what do I need to make this book work for me? Theoretically, you should be able to pick up this book, study the material for the current hour, study the examples, and either write out the exercises or run them on a relational database server. However, it would be to your benefit to have access to a relational database system to which to apply the material in each lesson. The relational database to which you have access is not a major factor because SQL is the standard language for all relational databases. Some database systems that you can use include Oracle, Sybase, Informix, Microsoft SQL Server, Microsoft Access, MySQL, and dBASE.</div><div align="justify"><blockquote></blockquote><a href="http://www.samspublishing.com/library/library.asp?b=STY_Sql_24hours&amp;rl=1" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-2603681329968567703?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-75391161164530119872007-02-15T03:38:00.000-08:002008-12-18T12:14:45.297-08:00<div align="center">By Richard Waymire and Rick Sawtell</div><blockquote></blockquote><div align="justify">Welcome to Sams Teach Yourself Microsoft SQL Server 7.0 in 21 Days. We hope this book will help not only teach you about SQL Server but also prove valuable for everyday work involving SQL Server. We have worked hard to see that the skills you learn from this book will easily translate into real-world methods and solutions.</div><blockquote></blockquote><div align="justify">There are certain skills you need to successfully install, administer, troubleshoot, and configure SQL Server. The kinds of skills you must know can be divided into two general categories:</div><ul><li><div align="justify">SQL Server programmer </div></li><li><div align="justify">SQL Server administrator </div></li></ul><p align="justify"><strong>Note</strong><br />In a small company, the developer, programmer, and administrator might be the same person; large companies usually have the functions separate.</p><p align="justify">A SQL Server developer is generally responsible for designing, programming, and populating the database. Sams Teach Yourself Transact-SQL in 21 Days is a great place to start for beginning SQL programmers. After the database has been created, responsibility for the database is often turned over to an administrator, who takes care of the ongoing maintenance.</p><p align="justify">A SQL Server administrator is usually responsible for the day-to-day administration of the database. This book is designed more for administrators, although many lessons apply to programmers as well. Although some administrators might never have to do any SQL programming, we have these lessons in enough detail so that administrators can begin to pick up on SQL programming if they want to. Programming tasks covered here relate to skills administrators might be called on to perform—such as creating tables, creating indexes, and writing complex queries.</p><p align="justify"><a href="http://www.samspublishing.com/library/library.asp?b=STY_Sql_Server_7&amp;rl=1" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-7539116116453011987?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-21055592872531486812007-02-14T07:35:00.000-08:002008-12-18T12:14:45.297-08:00<div align="justify">Data warehouses in the 1990s were for the privileged few business analysts. Business Intelligence is now being democratized by being shared with the rank and file employee demanding higher levels of RDBMS scalability and ease of use, being delivered through Web portals. </div><blockquote></blockquote><div align="justify">To support this emerging e-Business Intelligence world, the challenges that face the enterprises for their centralized data warehouse RDBMS technology are scalability, performance, availability and smart manageability.</div><blockquote></blockquote><div align="justify">This IBM Redbook focuses on the innovative technical functionalities of DB2 UDB ESE V8.1 and discusses:</div><blockquote></blockquote><ul><li><div align="justify">Guidelines on building the large database and determining the number of partitions</div></li><li><div align="justify">Bulk load using the new multipartition load </div></li><li><div align="justify">Performance enhancements using MultiDimensional Clustering and Materialized Query Tables.</div></li><li><div align="justify">Availability through the new online utilities</div></li><li><div align="justify">Self Managing And Resource Tuning features</div></li><li><div align="justify">Migration scenarios </div></li></ul><p align="justify">This book positions the new functionalities, so you can understand and evaluate their applicability in your own enterprise data warehouse environment, and get started prioritizing and implementing them.</p><p align="justify"><a href="http://www.redbooks.ibm.com/abstracts/sg246917.html" target="_blank">Click to Download</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-2105559287253148681?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-60954275950497405572007-02-14T07:31:00.000-08:002008-12-18T12:14:45.298-08:00<div align="justify">This redbook gives detail coverage to the topic of data modeling techniques for data warehousing, within the context of the overall data warehouse development process.</div><blockquote></blockquote><div align="justify">The process of data warehouse modeling, including the steps required before and after the actual modeling step, is discussed. Detailed coverage of modeling techniques is presented in an evolutionary way through a gradual, but well-managed, expansion of the content of the actual data model. </div><blockquote></blockquote><div align="justify">Coverage is also given to other important aspects of data warehousing that affect, or are affected by, the modeling process. These include architecting the warehouse and populating the data warehouse. </div><div align="justify"><blockquote></blockquote>Guidelines for selecting a data modeling tool that is appropriate for data warehousing are presented. </div><div align="justify"><blockquote></blockquote><a href="http://www.redbooks.ibm.com/abstracts/sg242238.html" target="_blank">Click to Download</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-6095427595049740557?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-58671290101849409982007-02-14T07:22:00.000-08:002008-12-18T12:14:45.298-08:00<div align="center">By C. J. van RIJSBERGEN</div><div align="justify"><blockquote></blockquote>The material of this book is aimed at advanced undergraduate information (or computer) science students, postgraduate library science students, and research workers in the field of IR. Some of the chapters, particular chapter 6 (this became chapter 7 in the second edition), make simple use of a little advanced mathematics. However, the necessary mathematical tools can be easily mastered from numerous mathematical texts that now exist and, in any case, references have been given where the mathematics occur.</div><div align="justify"><blockquote></blockquote>Information retrieval is a wide, often loosely-defined term but in these pages I shall be concerned only with automatic information retrieval systems. Automatic as opposed to manual and information as opposed to data or fact. Unfortunately the word information can be very misleading. In the context of information retrieval (IR), information, in the technical meaning given in Shannon's theory of communication, is not readily measured (Shannon and Weaver). In fact, in many cases one can adequately describe the kind of retrieval by simply substituting 'document' for 'information'. Nevertheless, 'information retrieval' has become accepted as a description of the kind of work published by Cleverdon, Salton, Sparck Jones, Lancaster and others. A perfectly straightforward definition along these lines is given by Lancaster: 'Information retrieval is the term conventionally, though somewhat inaccurately, applied to the type of activity discussed in this volume. An information retrieval system does not inform (i.e. change the knowledge of) the user on the subject of his inquiry. It merely informs on the existence (or non-existence) and whereabouts of documents relating to his request.' This specifically excludes Question-Answering systems as typified by Winograd and those described by Minsky. It also excludes data retrieval systems such as used by, say, the stock exchange for on-line quotations.</div><div align="justify"><blockquote></blockquote><a href="http://www.dcs.gla.ac.uk/Keith/Preface.html" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-5867129010184940998?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-25432346340203874632007-02-14T06:29:00.000-08:002008-12-18T12:14:45.299-08:00<div align="justify">This page contains links to the most current documentation for Oracle Database, Application Server, Developer Suite, Collaboration Suite and Applications/E-Business Suite.<br /></div><blockquote></blockquote><p align="center"><strong><span style="font-size:130%;">Database</span></strong></p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/documentation/database10gR2.html" target="_blank">Oracle Database 10g Release 2 </a><br /><a class="bodylink" href="http://www.oracle.com/pls/db102/gateways" target="_blank">Oracle Gateways 10g Release 2 </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/database10gR2.html" target="_blank">Oracle Database Lite 10g Release 2 </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/contentdb.html" target="_blank">Oracle Content Database 10g Release 1</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/database10g.html" target="_blank">Oracle Database 10g Release 1 </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/gateways10g.html" target="_blank">Oracle Gateways 10g Release 1 </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle9i.html" target="_blank">Oracle9i Database Release 2 </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle9i_arch_901.html" target="_blank">Oracle9i Database Release 1 </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/gateways.html" target="_blank">Oracle Gateways for Oracle9i (Rel. 1&2)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/intermedia.html" target="_blank">Oracle interMedia</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/spatial.html" target="_blank">Oracle Spatial</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/failsafe.html" target="_blank">Oracle Fail Safe</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/timesten_doc.html" target="_blank">Oracle TimesTen In-Memory Database</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/berkeley-db/db/index.html" target="_blank">Oracle Berkeley DB</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/berkeley-db/je/index.html" target="_blank">Oracle Berkeley DB Java Edition</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/berkeley-db/xml/index.html" target="_blank">Oracle Berkeley DB XML</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/database10gR2.html" target="_blank">Oracle 10g R2 Lite </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle9i_arch_901.html" target="_blank">Oracle 9i Lite </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/securebackup.html" target="_blank">Oracle Secure Backup</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/apex.html" target="_blank">Oracle Application Express</a><br /></p><strong><blockquote><strong></strong></blockquote><p align="center"><span style="font-size:130%;">Enterprise Management</span></strong> </p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/documentation/oem.html" target="_blank">Oracle Enterprise Manager 10g Release 3 (10.2)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oem101.html" target="_blank">Oracle Enterprise Manager 10g Release 1 (10.1)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oem92.html" target="_blank">Oracle Enterprise Manager Release 2.(9.2)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oem_arch_902.html" target="_blank">Oracle Enterprise Manager (Rel. 9.0.2 &amp; 9.0.1)</a><br /></p><blockquote></blockquote><p align="center"><strong><span style="font-size:130%;">Secure Enterprise Search</span><span style="font-size:130%;"> </span></strong></p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/documentation/ses.html" target="_blank">Oracle Secure Enterprise Search 10g</a></p><p align="center"><span style="font-size:130%;"><strong>Tape Backup</strong></span></p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/documentation/securebackup.html" target="_blank">Oracle Secure Backup</a></p><blockquote></blockquote><p align="center"><span style="font-size:130%;"><strong>Technologies / Utilities</strong></span></p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/tech/blaf/" target="_blank">BLAF</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ocm.html" target="_blank">Oracle Configuration Manager</a><br /><a class="bodylink" href="http://www.oracle.com/technology/docs/tech/java/help/index.html" target="_blank">Oracle Help Technologies</a><br /><a class="bodylink" href="http://www.oracle.com/technology/docs/tech/java/servlets/index.html" target="_blank">Oracle JSP Engine</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/migration.html" target="_blank">Oracle Migration Tools</a><br /><a class="bodylink" href="http://www.oracle.com/technology/docs/tech/windows/odbc/index.html" target="_blank">Oracle ODBC Drivers</a></p><p align="center"><span><strong><span style="font-size:130%;">Applications</span></strong></span></p><p align="justify"><span><strong>E-Business Suite</strong> </span></p><p align="justify"><span><a href="http://www.oracle.com/technology/documentation/applications.html" target="_blank">Applications Releases 11i and 12</a></span></p><p align="justify"><strong>PeopleSoft Enterprise<br /></strong><a class="bodylink" href="http://www.oracle.com/technology/documentation/psftent.html" target="_blank">PeopleSoft Enterprise</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/psftarch.html" target="_blank">Archive PeopleSoft Enterprise</a></p><p align="justify"><strong>JD Edwards EnterpriseOne</strong><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/jdedent.html" target="_blank">JD Edwards EnterpriseOne</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/jdedarch.html" target="_blank">Archive JD Edwards EnterpriseOne</a></p><p align="justify"><strong>Oracle Retail</strong><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle_retail.html" target="_blank">Oracle Retail </a></p><p align="justify"><strong>Siebel Applications</strong><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/siebel.html" target="_blank">Siebel Applications </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/siebelinteg.html" target="_blank">Siebel Integrations</a></p><p align="justify"><strong>Other Applications</strong><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/glog.html" target="_blank">Oracle Transportation Management (OTM) 5.5</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/glog50.html" target="_blank">Oracle Transportation Management (G-Log GC3) 5.0</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/pharmaceutical.html" target="_blank">Pharmeceutical </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/demantra.html" target="_blank">Oracle Demantra </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/workforce.html" target="_blank">Oracle Workforce Scheduling</a></p><p align="center"><span style="font-size:130%;"><strong>Middleware</strong></span></p><p align="justify"><strong>Application Server</strong> </p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/documentation/oim1014.html" target="_blank">Oracle Identity Management 10g (10.1.4)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/appserver10132.html" target="_blank">Oracle Application Server 10g Release 3 (10.1.3.2)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/appserver10131.html" target="_blank">Oracle Application Server 10g Release 3 (10.1.3.1)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/appserver1013.html" target="_blank">Oracle Application Server 10g Release 3 (10.1.3)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/appserver101202.html" target="_blank">Oracle Application Server 10g Release 2 (10.1.2.0.2)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/appserver1012.html" target="_blank">Oracle Application Server 10g Release 2 (10.1.2)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/cm_sdk_9042.html" target="_blank">Oracle Content Management SDK, 10g (9.0.4.2)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/appserver10g.html" target="_blank">Oracle Application Server Release 10g (9.0.4)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/cm_sdk.html" target="_blank">Oracle Content Management SDK, 10g (9.0.4)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/9i_forms.html" target="_blank">Oracle Forms 10g (10.1.2 and 9.0.4) and Oracle9i Forms (9.0.2)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ias.html" target="_blank">Oracle9i Application Server Release 2</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ifs.html" target="_blank">Oracle Content Management SDK</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ias_arch_9i.html" target="_blank">Oracle9i Application Server Release 1</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ifs_arch.html" target="_blank">Oracle Internet File System </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oim.html" target="_blank">Oracle Identity Manager</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ias_arch_8i.html" target="_blank">Internet Application Server 8i</a></p><p align="justify"><strong>Oracle Collaboration Suite</strong> </p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/documentation/collab.html" target="_blank">Oracle Collaboration Suite 10g Release 1 </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/collab904.html" target="_blank">Oracle Collaboration Suite Release 2 </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/collab903.html" target="_blank">Oracle Collaboration Suite Release 1 </a></p><p align="justify"><strong>Development Tools</strong> </p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/documentation/devsuite.html" target="_blank">Oracle Developer Suite Release 10g Release 2 </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/dev10g.html" target="_blank">Oracle Developer Suite Release 10g </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ids.html" target="_blank">Oracle9i Developer Suite Release 2 </a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/9i_jdev.html" target="_blank">Oracle9i JDeveloper</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ids_arch.html" target="_blank">Oracle9i Developer Suite Release 1</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ids_arch.html#ids10241" target="_blank">Oracle9i Internet Developer Suite Release 1.0.2.4.1</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ids_arch.html#ids101" target="_blank">Internet Developer Suite Release 1.0.1</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ids_arch.html#ids10" target="_blank">Internet Developer Suite Release 1.0</a><br /><a class="bodylink" href="http://www.oracle.com/technology/products/designer/documentation.html" target="_blank">Oracle Designer</a><br /><a class="bodylink" href="http://www.oracle.com/technology/products/designer/documentation.html" target="_blank">Oracle SCM (Repository)</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/reports.html" target="_blank">Oracle Reports</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/10g_forms.html" target="_blank">Oracle Forms</a></p><p align="justify"><strong>Data Warehousing and Business Intelligence</strong></p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/documentation/bi_doc.html" target="_blank">Oracle Business Intelligence</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/bi.html" target="_blank">Oracle Business Intelligence Standard Edition</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/bi_ee.html" target="_blank">Oracle Business Intelligence Enterprise Edition</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/bi_apps.html" target="_blank">Oracle Business Intelligence Applications</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/bib.html" target="_blank">Oracle BI Beans</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/datamining.html" target="_blank">Oracle Data Mining</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/olap.html" target="_blank">Oracle OLAP</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/warehouse.html" target="_blank">Oracle Warehouse Builder</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/discoverer.html" target="_blank">Oracle Discoverer</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/express_objects.html" target="_blank">Oracle Express Analyzer/Objects</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/express_server.html" target="_blank">Oracle Express Server</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/express_web.html" target="_blank">Oracle Express Web Agent</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/datamart.html" target="_blank">Oracle Data Mart Suite</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ofa.html" target="_blank">Oracle Financial Analyzer</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/reports.html" target="_blank">Oracle Reports</a></p><p align="justify"><strong>On Demand</strong><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ondemand_ebs.html" target="_blank">Oracle E-Business Suite On Demand</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ondemand_tech.html" target="_blank">Oracle Technology On Demand</a></p><p align="center"><strong><span style="font-size:130%;">Previously Released Oracle Documentation</span></strong></p><p align="center"><span style="font-size:130%;"><strong>Database</strong></span></p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle8i.html" target="_blank">Oracle8i Database</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle8i.html" target="_blank">Oracle8i Database Release 8.1.7</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle8i_arch_816.html" target="_blank">Oracle8i Database Release 8.1.6</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle8i_arch_815.html" target="_blank">Oracle8i Database Release 8.1.5</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle8.html" target="_blank">Oracle8 Database</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle8.html" target="_blank">Oracle8 Database Release 8.0.6</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle8_arch_805.html" target="_blank">Oracle8 Database Release 8.0.5</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle8_arch_804.html" target="_blank">Oracle8 Database Release 8.0.4</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oracle7.html" target="_blank">Oracle7 Release 7.3.4</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oem_arch_2x.html" target="_blank">Oracle Enterprise Manager and Management Packs</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oem_arch_2x.html" target="_blank">Release 2.x</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oem_arch_1x.html" target="_blank">Release 1.x</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/gateways_arch.html" target="_blank">Oracle Gateways</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/rdb.html" target="_blank">Oracle Rdb</a></p><p align="center"><span style="font-size:130%;"><strong>Data Warehousing and Business Intelligence</strong></span></p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/documentation/reports.html" target="_blank">Oracle Reports</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/darwin.html" target="_blank">Oracle Darwin</a></p><p align="center"><strong><span style="font-size:130%;">Application Server</span></strong></p><p align="justify"><a class="bodylink" href="http://www.oracle.com/technology/documentation/oas.html" target="_blank">Oracle Application Server</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/forms.html" target="_blank">Oracle Forms Services</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/6i_forms.html" target="_blank">Oracle Forms 6i</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/dev_arch.html" target="_blank">Oracle Forms Archive</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/portal.html" target="_blank">Oracle Portal</a><br /><a class="bodylink" href="http://portalcenter.oracle.com/servlet/page?_pageid=2752&_dad=ops&amp;_schema=OPSTUDIO" target="_blank">Oracle9iAS Portal Center</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/clickstream.html" target="_blank">Oracle9iAS Clickstream Intelligence</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/personalization.html" target="_blank">Oracle9iAS Personalization</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/ifs_arch.html" target="_blank">Oracle Internet File System</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/uni_mess.html" target="_blank">Oracle Unified Messaging</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/oid.html" target="_blank">Oracle Internet Directory</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/emailserver.html" target="_blank">Oracle eMail Server</a><br /><a class="bodylink" href="http://www.oracle.com/technology/documentation/appliance.html" target="_blank">Oracle8i and 9iAS Appliance</a></p><p align="justify"></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-2543234634020387463?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-92168156229518783782007-02-14T06:16:00.000-08:002008-12-18T12:14:45.299-08:00<div align="justify">Welcome to the Oracle Database 10g Documentation Library. Here you can research new information, look up reference information, and search across the entire library.</div><div align="justify"><blockquote></blockquote><strong>Getting Started</strong></div><div align="justify">These books provide background information for new users:<br />2 Day DBA <a title="Contents of 2 Day DBA" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10742%2Ftoc.htm&remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of 2 Day DBA" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=server.101%2Fb10742.pdf&amp;remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Concepts <a title="Contents of Concepts" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10743%2Ftoc.htm&remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Concepts" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=server.101%2Fb10743.pdf&amp;remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Administrator's Guide <a title="Contents of Administrator's Guide" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10739%2Ftoc.htm&remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Administrator's Guide" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=server.101%2Fb10739.pdf&amp;remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Master Glossary <a title="Contents of Master Glossary" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=mix.101%2Fb12040%2Ftoc.htm&remark=portal+%28Getting+Started%29" target="_top">HTML</a> </div><blockquote></blockquote><div align="justify"><strong>Most Popular</strong><br />These books contain the most commonly used information for general database administration and application development:<br />2 Day DBA <a title="Contents of 2 Day DBA" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10742%2Ftoc.htm&remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of 2 Day DBA" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=server.101%2Fb10742.pdf&amp;remark=portal+%28Getting+Started%29" target="_top">PDF</a> </div><div align="justify">Concepts <a title="Contents of Concepts" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10743%2Ftoc.htm&remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Concepts" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=server.101%2Fb10743.pdf&amp;remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Administrator's Guide <a title="Contents of Administrator's Guide" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10739%2Ftoc.htm&remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Administrator's Guide" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=server.101%2Fb10739.pdf&amp;remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Application Developer's Guide - Fundamentals <a title="Contents of Application Developer's Guide - Fundamentals" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=appdev.101%2Fb10795%2Ftoc.htm&remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Application Developer's Guide - Fundamentals" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=appdev.101%2Fb10795.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Reference <a title="Contents of Reference" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10755%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Reference" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=server.101%2Fb10755.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Performance Tuning Guide <a title="Contents of Performance Tuning Guide" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10752%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Performance Tuning Guide" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=server.101%2Fb10752.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />PL/SQL User's Guide and Reference <a title="Contents of PL/SQL User's Guide and Reference" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=appdev.101%2Fb10807%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of PL/SQL User's Guide and Reference" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=appdev.101%2Fb10807.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />SQL Reference <a title="Contents of SQL Reference" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10759%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of SQL Reference" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=server.101%2Fb10759.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a> </div><blockquote></blockquote><div align="justify"><strong>Upgrade Information</strong></div><div align="justify">If you are familiar with earlier Oracle releases and are moving to Oracle Database 10g, these books describe the new features, and explain how to upgrade your database.<br />New Features Guide <a title="Contents of New Features Guide" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10750%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of New Features Guide" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=server.101%2Fb10750.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Upgrade Guide <a title="Contents of Upgrade Guide" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=server.101%2Fb10763%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Upgrade Guide" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=server.101%2Fb10763.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a> </div><div align="justify"><strong><blockquote><strong></strong></blockquote>License Information</strong></div><div align="justify">This book explains how certain database features are licensed:<br />Licensing Information <a title="Contents of Licensing Information" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=license.101%2Fb13552%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Licensing Information" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=license.101%2Fb13552.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a> </div><blockquote></blockquote><div align="justify"><strong>Companion CD Installation Guides<br /></strong>The Companion CD Installation Guides cover the software other than the main database server. This software works in conjunction with the database, and requires a separate, optional installation. Again, there is a set of Quick Installation Guides for typical scenarios, and a full Installation Guide for advanced scenarios. </div><div align="justify"><blockquote></blockquote>Companion CD Installation Guide for 64-Bit Windows<a title="Contents of Companion CD Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13806_02%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13806_02.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Companion CD Installation Guide for Linux x86-64 <a title="Contents of Companion CD Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB14401_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB14401_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Companion CD Installation Guide for UNIX Systems <a title="Contents of Companion CD Installation Guide for UNIX Systems" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB10886_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Installation Guide for UNIX Systems" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB10886_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Companion CD Installation Guide for Windows <a title="Contents of Companion CD Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13693_02%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13693_02.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Companion CD Quick Installation Guide for 64-Bit Windows <a title="Contents of Companion CD Quick Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13801_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Quick Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13801_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Companion CD Quick Installation Guide for AIX-Based Systems <a title="Contents of Companion CD Quick Installation Guide for AIX-Based Systems" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12083_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Quick Installation Guide for AIX-Based Systems" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12083_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Companion CD Quick Installation Guide for HP Tru64 UNIX <a title="Contents of Companion CD Quick Installation Guide for HP Tru64 UNIX" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12082_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Quick Installation Guide for HP Tru64 UNIX" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12082_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Companion CD Quick Installation Guide for HP-UX PA-RISC (64-Bit) <a title="Contents of Companion CD Quick Installation Guide for HP-UX PA-RISC (64-Bit)" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12084_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Quick Installation Guide for HP-UX PA-RISC (64-Bit)" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12084_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Companion CD Quick Installation Guide for Linux x86 <a title="Contents of Companion CD Quick Installation Guide for Linux x86" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12086_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Quick Installation Guide for Linux x86" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12086_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Companion CD Quick Installation Guide for Linux x86-64 <a title="Contents of Companion CD Quick Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB14404_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Quick Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB14404_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Companion CD Quick Installation Guide for Solaris Operating System (SPARC) <a title="Contents of Companion CD Quick Installation Guide for Solaris Operating System (SPARC)" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12085_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Quick Installation Guide for Solaris Operating System (SPARC)" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12085_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Companion CD Quick Installation Guide for Windows <a title="Contents of Companion CD Quick Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13692_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Companion CD Quick Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13692_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a></div><div align="justify"><blockquote></blockquote><strong>Quick Installation Guides</strong></div><div align="justify">The Quick Installation Guides cover the basics of installing on a clean machine, using a specific operating system.</div><div align="justify">Quick Installation Guide for 64-Bit Windows <a title="Contents of Quick Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13803_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Quick Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13803_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Quick Installation Guide for AIX-Based Systems <a title="Contents of Quick Installation Guide for AIX-Based Systems" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12080_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Quick Installation Guide for AIX-Based Systems" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12080_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Quick Installation Guide for HP Tru64 UNIX <a title="Contents of Quick Installation Guide for HP Tru64 UNIX" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12081_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Quick Installation Guide for HP Tru64 UNIX" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12081_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Quick Installation Guide for HP-UX PA-RISC (64-Bit) <a title="Contents of Quick Installation Guide for HP-UX PA-RISC (64-Bit)" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB10815_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Quick Installation Guide for HP-UX PA-RISC (64-Bit)" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB10815_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Quick Installation Guide for Linux x86 <a title="Contents of Quick Installation Guide for Linux x86" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB10813_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Quick Installation Guide for Linux x86" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB10813_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Quick Installation Guide for Linux x86-64 <a title="Contents of Quick Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB14402_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Quick Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB14402_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Quick Installation Guide for Solaris Operating System (SPARC) <a title="Contents of Quick Installation Guide for Solaris Operating System (SPARC)" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB10814_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Quick Installation Guide for Solaris Operating System (SPARC)" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB10814_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Quick Installation Guide for Windows <a title="Contents of Quick Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13669_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Quick Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13669_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Real Application Clusters Quick Installation Guide for Oracle Database Standard Edition for Windows <a title="Contents of Real Application Clusters Quick Installation Guide for Oracle Database Standard Edition for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13889_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Real Application Clusters Quick Installation Guide for Oracle Database Standard Edition for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13889_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a></div><blockquote></blockquote><div align="justify"><strong>Installation Guides</strong><br />The full Installation Guides cover a wide variety of installation scenarios. Use them if your situation is not covered in the Quick Installation Guides. </div><div align="justify"><blockquote></blockquote>Enterprise Manager Grid Control Installation and Basic Configuration <a title="Contents of Enterprise Manager Grid Control Installation and Basic Configuration" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12012_03%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Enterprise Manager Grid Control Installation and Basic Configuration" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12012_03.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Installation Guide for 64-Bit Windows <a title="Contents of Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13805_02%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13805_02.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Installation Guide for Linux x86-64 <a title="Contents of Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB14399_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB14399_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Installation Guide for UNIX Systems <a title="Contents of Installation Guide for UNIX Systems" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB10811_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Installation Guide for UNIX Systems" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB10811_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Installation Guide for Windows <a title="Contents of Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB10130_02%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB10130_02.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Procedural Gateway for APPC Installation and Configuration Guide for Microsoft Windows <a title="Contents of Procedural Gateway for APPC Installation and Configuration Guide for Microsoft Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13694_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Procedural Gateway for APPC Installation and Configuration Guide for Microsoft Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13694_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Real Application Clusters Installation and Configuration for All Platforms <a title="Contents of Real Application Clusters Installation and Configuration for All Platforms" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB10766_08%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Real Application Clusters Installation and Configuration for All Platforms" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB10766_08.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Real Application Clusters Installation and Configuration for Linux x86-64 <a title="Contents of Real Application Clusters Installation and Configuration for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB14406_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Real Application Clusters Installation and Configuration for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB14406_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Transparent Gateway for DRDA Installation and User's Guide for Microsoft Windows <a title="Contents of Transparent Gateway for DRDA Installation and User's Guide for Microsoft Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12010_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Transparent Gateway for DRDA Installation and User's Guide for Microsoft Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12010_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Universal Installer Concepts Guide <a title="Contents of Universal Installer Concepts Guide" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=em.101%2Fb12140%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Universal Installer Concepts Guide" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=em.101%2Fb12140.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a></div><div align="justify"><blockquote></blockquote><strong>Client Installation Guides</strong><br />The Client Installation Guides cover the simplified install for just the Oracle client software, which lets you connect to a database running on a different system, using a database application or the interactive SQL*Plus tool. Again, there is a set of Quick Installation Guides for typical scenarios, and a full Installation Guide for advanced scenarios.<br /><blockquote></blockquote>Client Installation Guide for 64-Bit Windows <a title="Contents of Client Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13804_02%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13804_02.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Client Installation Guide for Linux x86-64 <a title="Contents of Client Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB14400_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB14400_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Client Installation Guide for UNIX Systems <a title="Contents of Client Installation Guide for UNIX Systems" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12087_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Installation Guide for UNIX Systems" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12087_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Client Installation Guide for Windows <a title="Contents of Client Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB10131_02%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB10131_02.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Client Quick Installation Guide for 64-Bit Windows <a title="Contents of Client Quick Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13802_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Quick Installation Guide for 64-Bit Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13802_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Client Quick Installation Guide for AIX-Based Systems <a title="Contents of Client Quick Installation Guide for AIX-Based Systems" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12088_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Quick Installation Guide for AIX-Based Systems" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12088_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Client Quick Installation Guide for HP-UX PA-RISC (64-Bit) <a title="Contents of Client Quick Installation Guide for HP-UX PA-RISC (64-Bit)" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12089_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Quick Installation Guide for HP-UX PA-RISC (64-Bit)" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12089_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Client Quick Installation Guide for Linux x86 <a title="Contents of Client Quick Installation Guide for Linux x86" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12091_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Quick Installation Guide for Linux x86" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12091_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Client Quick Installation Guide for Linux x86-64 <a title="Contents of Client Quick Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB14403_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Quick Installation Guide for Linux x86-64" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB14403_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Client Quick Installation Guide for Solaris Operating System (SPARC) <a title="Contents of Client Quick Installation Guide for Solaris Operating System (SPARC)" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12092_01%2Ftoc.htm&amp;remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Quick Installation Guide for Solaris Operating System (SPARC)" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12092_01.pdf&remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Client Quick Installation Guide for Windows <a title="Contents of Client Quick Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB13691_01%2Ftoc.htm&remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Quick Installation Guide for Windows" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB13691_01.pdf&amp;remark=portal+%28Getting+Started%29" target="_top">PDF</a><br />Client Quick Installation Guide HP Tru64 UNIX <a title="Contents of Client Quick Installation Guide HP Tru64 UNIX" href="http://www.oracle.com/pls/db10g/db10g.to_toc?pathname=..%2F..%2Fhtml%2FB12090_01%2Ftoc.htm&remark=portal+%28Getting+Started%29" target="_top">HTML</a> <a title="PDF file of Client Quick Installation Guide HP Tru64 UNIX" href="http://www.oracle.com/pls/db10g/db10g.to_pdf?pathname=..%2F..%2Fpdf%2FB12090_01.pdf&amp;remark=portal+%28Getting+Started%29" target="_top">PDF</a> </div><div align="justify"> </div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-9216815622951878378?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-4655284484014590562007-02-14T05:55:00.000-08:002008-12-18T12:14:45.300-08:00<div align="center">By Edward Whalen </div><div align="center"><blockquote></blockquote>Contributing Author: Steve Adrien DeLuca </div><div align="justify"><blockquote></blockquote>I have worked with Oracle for many years. Every time a new version is released or a new problem crops up, I am rejuvenated; I become excited about working with Oracle again. I want to share this enthusiasm with you, and I hope that after you become familiar with Oracle, more and more aspects of the Oracle RDBMS will interest you. The most important thing is that you enjoy what you are doing; I hope that you enjoy working with Oracle as much as I do.<br /><blockquote></blockquote>The Oracle RDBMS is an enormous environment with unlimited potential. When you start working with Oracle, you might find it overwhelming. Don't give up; you will see how the different components work together as you learn about the Oracle RDBMS. Rarely do I undertake a project without learning something new about Oracle. </div><div align="justify"><blockquote></blockquote>This book is designed for inexperienced Oracle users. Experienced Oracle DBAs will likely find this book too elementary. Most of the lessons are designed to step the reader through specific administrative and user tasks. </div><div align="justify"><blockquote></blockquote>The best way to use this book is to read each lesson, then practice the techniques and tasks outlined in that lesson. Each lesson covers a single topic, so some lessons might be longer than others. If you complete one lesson per day, you can easily complete the full course in three weeks.<br /><blockquote></blockquote>At the end of each lesson, you'll find a series of questions and answers. These questions are designed to point out some of the key concepts that were covered in the lesson. Following the Q&amp;A section, you'll find a series of quiz questions that focus on techniques and tasks covered in the lesson. Each lesson also includes a series of exercises that are intended to familiarize you with some of the key tasks covered in that lesson. </div><div align="justify"><blockquote></blockquote><a href="http://www.webbasedprogramming.com/Teach-Yourself-Oracle-8-In-21-Days/fm/fm.htm" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-465528448401459056?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-62284704485451855922007-02-14T05:51:00.000-08:002008-12-18T12:14:45.300-08:00<div align="center">By Rick Winter</div><div align="justify"><blockquote></blockquote>The Microsoft Access 97 Quick Reference is the latest in a series of comprehensive, task-oriented references and details how to use the features and functionality of Access 97. Compiled for the intermediate-to-advanced user who wants a concise, comprehensive reference, the Microsoft Access 97 Quick Reference is loaded with detailed instructions outlining important tasks you need to complete.<br /><blockquote></blockquote>The Microsoft Access 97 Quick Reference presents the tasks and functions most often sought by users of Access 97. The book also includes a comprehensive glossary with many terms and definitions that refer to the newest features in Access 97. </div><div align="justify"><blockquote></blockquote>The Microsoft Access 97 Quick Reference is written for casual to advanced computer users who need a fast reference to Access 97 tasks, functions, and features. It is an ideal companion to Que's Special Edition Using Microsoft Access 97. The Quick Reference size makes it ideal for travel.<br /><blockquote></blockquote>If you are upgrading from Access 95 or Access 2, you will find this reference useful for finding new features and looking up new ways of getting a job done. If you are converting from other field data types--for example, dBASE, Paradox, or Btrieve--this Quick Reference might be the right amount of instruction you need to transfer your know-how investment to new products.<br /><blockquote></blockquote>As a reference, this book is not intended to tutor learners. If you are just starting to use Access software for the first time, or are a very casual user, you might want to consider Que's User-Friendly Using Microsoft Access 97 or The Complete Idiot's Guide to Microsoft Access 97 as a book to get you up to speed. For beginner or very casual task reference, check out Que's Easy Microsoft Access 97. If you want the most complete reference as well as tutorial and foundation information, then you need Que's Special Edition Using Microsoft Access 97. This Microsoft Access 97 Quick Reference makes an ideal companion to the comprehensive Special Edition. </div><div align="justify"><blockquote></blockquote><a href="http://www.cs.rtu.lv/PharePub/Microsoft%20Access%2097%20Quick%20Reference/htm/fm.htm" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-6228470448545185592?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-86475160434308839902006-12-26T12:18:00.000-08:002008-12-18T12:14:45.301-08:00<div align="center">Learning by Example</div><div align="center"><blockquote></blockquote>By Maria Sueli Almeida, Kirk Condon, Michael Fischer and Julian Stuhler</div><blockquote></blockquote><div align="justify">Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. The DB2 Family of products has offered support for stored procedures for some time, with each release offering significant enhancements over the last. </div><blockquote></blockquote><div align="justify">In the meantime, Java has been making steady inroads as the standard application development language for many companies large and small. Its inherent portability and openness, combined with the good availability of skilled programming resource, has made it an increasingly attractive choice, and the central plank in many organization’s e-business strategy. </div><blockquote></blockquote><div align="justify">Until recently, DB2 did not support stored procedures written in Java, so the advantages of the two technologies could not be combined. The latest releases of DB2 have changed all that, opening up new possibilities for efficient, secure, highly portable application development. </div><blockquote></blockquote><div align="justify">This IBM Redbook aims to give the reader an in-depth understanding of the techniques and issues associated with the development of DB2 stored procedures written in Java and using SQLJ and/or JDBC for their SQL operations. The extensive collection of sample code presented in this book and included on the accompanying CD-ROM was designed to run against DB2 UDB Server across the OS/390, Windows, and UNIX platforms. </div><div align="justify"><blockquote></blockquote>We have assumed that the reader has at least a basic understanding of Java terminology (such as classes, methods and packages) in addition to exposure to general DB2 application development concepts.</div><div align="justify"><blockquote><a href="http://www.redbooks.ibm.com/redbooks/SG245945.html" target="_blank"></a><a href="http://www.redbooks.ibm.com/redbooks/SG245945.html" target="_blank"></a></blockquote><a href="http://www.redbooks.ibm.com/redbooks/SG245945.html" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-8647516043430883990?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-20735686937985927042006-12-26T12:09:00.000-08:002008-12-18T12:14:45.301-08:00<div align="center">From IBM</div><blockquote></blockquote><div align="justify">This book discusses how to design and code application programs that access DB2 databases and application servers. It presents detailed information on the use of Structured Query Language (SQL) in supported host language programs. For information unique to your specific operating system, see the Application Building Guide. </div><blockquote></blockquote><div align="justify">You can access data with: </div><blockquote></blockquote><ol><li><div align="justify">SQL statements embedded in a host language, including embedded SQL for Java (SQLJ) </div></li><li><div align="justify">dynamic APIs including Java Database Connectivity (JDBC), Perl DBI, and DB2 Call Level Interface (DB2 CLI) </div></li></ol><p align="justify">This book discusses all these ways to access data except DB2 CLI, which is discussed in the CLI Guide and Reference. JDBC, SQLJ, and DB2 CLI provide some data access capabilities that are not available through embedded SQL. These capabilities include scrollable cursors and stored procedures that return multiple result sets. See the discussion in Access to Data to help you decide which data access method to use. </p><p align="justify">To effectively utilize the information in this book to design, write, and test your DB2 application programs, you need to refer to the SQL Reference along with this book. If you are using the DB2 Call Level Interface (CLI) or Open Database Connectivity (ODBC) interface in your applications to access DB2 databases, refer to the CLI Guide and Reference. To perform database manager administration functions using the DB2 adminstration APIs in your application programs, refer to the Administrative API Reference. </p><p align="justify">You can also develop applications where one part of the application runs on the client and another part runs on the server. Version 6 of DB2 introduces support for stored procedures with enhanced portability and scalability across platforms. Stored procedures are discussed in Stored Procedures...........</p><p align="justify"><a href="ftp://ftp.software.ibm.com/ps/products/db2/info/vr6/htm/db2a0/index.htm" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-2073568693798592704?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-40011049186052290672006-12-26T12:03:00.000-08:002008-12-18T12:14:45.302-08:00<div align="center">By David Edmond</div><div align="justify"><blockquote></blockquote>This PDF version of book covers Introduction (brief intro to Z and to SQL), Specific facts (relations and functions in Z), Sets (set extension, comprehension, power sets, product sets), Relations (database relations - Z style) , Introducing SQL, SQL retrieval (select from where), SQL modularization (group by, views), Facts and relations (conceptual schema modelling), Uncovering facts (brief methodology), Fact-based analysis (case-study), Entity-relationship modeling, Knowledge (predicate calculus, quantification), The knowledge base (intro to schemas in Z), From specification to implementation (specifying in Z, implementing in SQL), Database definition in SQL (create table, index, view), Database manipulation in SQL (insert, update, delete), Application programming, Case studies, and Refinement.</div><div align="justify"><blockquote></blockquote><a href="http://www.csis.ul.ie/Modules/CS4513/IMbook.htm" target="_blank">Click to Read More/Download</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-4001104918605229067?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-69690461796043719212006-12-26T11:57:00.000-08:002008-12-18T12:14:45.302-08:00<div align="center">extropia.com</div><blockquote></blockquote><div align="justify"><strong>Types of Database</strong></div><div align="justify">These days, when you talk about databases in the wild, you are primarily talking about two types: </div><blockquote></blockquote><ul><li><div align="justify">Analytical databases </div></li><li><div align="justify">Operational databases. </div></li></ul><p align="justify">Let's examine each type </p><p align="justify">Analytic databases (a.k.a. OLAP- On Line Analytical Processing) are primarily static, read-only databases which store archived, historical data used for analysis. For example, a company might store sales records over the last ten years in an analytic database and use that database to analyze marketing strategies in relationship to demographics. </p><p align="justify">On the web, you will often see analytic databases in the form of inventory catalogs such as the one shown on the previous page from Amazon.com. An inventory catalog analytical database usually holds descriptive information about all available products in the inventory. </p><p align="justify">Web pages are generated dynamically by querying the list of available products in the inventory against some search parameters. The dynamically-generated page will display the information about each item (such as title, author, ISBN) which is stored in the database.</p><p align="justify"><a href="http://www.extropia.com/tutorials/sql/toc.html" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-6969046179604371921?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-28991976752286870192006-12-26T11:53:00.000-08:002008-12-18T12:14:45.303-08:00<div align="center">by Jeff Garbus </div><blockquote></blockquote><div align="justify">This Unleashedbook is meant for anyone who is responsible for designing, building, administering and tuning systems that rely on SQL Server. Among other things, this book contains performance information you may not find anywhere else, including tuning methods and advanced SQL techniques that are undocumented or not well described.</div><blockquote></blockquote><ul><li><div align="justify">System Administrators will learn how to install and administer SQL Server. You will also learn about important standards and protocols to ensure that SQL Server applications can be maintained and supported for the long haul. </div></li><li><div align="justify">Database Administrators will learn to make the best use of SQL Server objects and datatypes and will learn to write effective stored procedures and triggers. The “Performance And Tuning” section of the book will help you understand what’s going on under the hood of the server, including a detailed analysis of the query optimizer and the physical storage mechanisms used by SQL Server. You can start to understand what performance you can reasonably expect with SQL Server so that you can focus on problems that you can really fix and on practical solutions. </div></li><li><div align="justify">Programmers will learn how to write code that runs well on SQL Server and will acquire a complete understanding of how the server interprets SQL statements when running. We also provide a solid foundation for your work in C and Visual Basic with DB-Library, ct-Library, and ODBC in the “Introduction to Open Client Programming” section of this book.</div></li></ul><p align="justify"><a href="http://freebooks.by.ru/view/SybaseSQLServer11Unleashed/ewtoc.html" target="_blank">Click to Read More</a> </p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-2899197675228687019?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-11020174294057695072006-12-26T11:48:00.000-08:002008-12-18T12:14:45.304-08:00<div align="center">By <a name="AEN6">Kirrily Robert</a></div><strong></strong><blockquote><strong><a name="AEN166"><strong></strong></a><a name="AEN166"></a></strong></blockquote><div align="justify"><strong><a name="AEN166">Types of databases</a></strong><br />There are many different types of databases, including:<br /></div><blockquote></blockquote><ul><li><div align="justify">Flat-file text databases</div></li><li><div align="justify">Associative flat-file databases such as Berkeley DB</div></li><li><div align="justify">Relational databases</div></li><li><div align="justify">Object databases</div></li><li><div align="justify">Network databases</div></li><li><div align="justify">Hierarchical databases such as LDAP</div></li></ul><p align="justify">Relational databases are by far the most useful type commonly available, and this training module focusses largely on them, after looking briefly at flat file text databases.</p><p align="justify"><a href="http://zoic.org/training/perldb/book1.html" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-1102017429405769507?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-73653490875815807582006-12-26T11:42:00.000-08:002008-12-18T12:15:03.934-08:00<div align="center">by Kevin Yank</div><blockquote></blockquote><div align="justify">On the Web today, content is king. After you've mastered HTML and learned a few neat tricks in JavaScript and Dynamic HTML, you can probably build a pretty impressive-looking Web site design. But then comes the time to fill that fancy page layout with some real information. Any site that successfully attracts repeat visitors has to have fresh and constantly updated content. In the world of traditional site building, that means HTML files--and lots of 'em.</div><div align="justify"><blockquote></blockquote>The problem is that, more often than not, the people providing the content for a site are not the same people handling its design. Oftentimes, the content provider doesn't even know HTML. How, then, is the content to get from the provider onto the Web site? Not every company can afford to staff a full-time Webmaster, and most Webmasters have better things to do than copying Word files into HTML templates anyway........</div><div align="justify"><blockquote></blockquote><a href="http://dev.mysql.com/tech-resources/articles/ddws/index.html" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-7365349087581580758?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-61727031070743733022006-12-26T11:23:00.000-08:002008-12-18T12:15:03.934-08:00<div align="center"><span style="font-size:180%;"><strong><span style="font-size:100%;">Version 4.11 </span></strong></span></div><div align="center"><blockquote></blockquote>By James Hoffman</div><blockquote></blockquote><div align="justify">This page is a tutorial of the Structured Query Language (also known as SQL) and is a pioneering effort on the World Wide Web, as this is the first comprehensive SQL tutorial available on the Internet. SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. SQL also allows users to define the data in a database, and manipulate that data. </div><div align="justify"><blockquote></blockquote>This page will describe how to use SQL, and give examples. The SQL used in this document is "ANSI", or standard SQL, and no SQL features of specific database management systems will be discussed until the "Nonstandard SQL" section. It is recommended that you print this page, so that you can easily refer back to previous examples.</div><div align="justify"><blockquote></blockquote><a href="http://www.intermedia.net/support/sql/sqltut.asp" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-6172703107074373302?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-82727278533923943662006-12-26T11:17:00.000-08:002008-12-18T12:15:03.935-08:00<div align="center"><strong>A Practical Introduction</strong></div><div align="center"><blockquote></blockquote>By Akeel I Din</div><div align="justify"><blockquote></blockquote><strong>Introduction</strong><br />The Structured Query Language, SQL is a query language which is used with relational databases. This chapter starts by describing some of the terms used in data processing and how they relate to SQL. The later part of this chapter describes relational databases and how SQL is used to query them.<br /><strong><blockquote><strong></strong></blockquote>"A Collection of Related Data": Databases and Database Management Systems.<br /></strong>Let's start from basics. What is a database? In very general terms, a database is a collection of related data. Notice the word related, this implies that the collection of letters on this page do not by themselves constitute a database. But if we think of them as a collection of letters arranged to form words, then they can be conceptualised as data in a database. Using similar reasoning, we can also say that a tome such as a telephone directory is also a database. It is a database first, because it is a collection of letters that form words and second, because it is an alphabetical listing of people's names, their addresses and their telephone numbers. How we think of a database depends on what use we want to make of the information that it contains.</div><div align="justify"><blockquote></blockquote><a href="http://www.managedtime.com/freesqlbook.php" target="_blank">Click to Read More/Download</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-8272727853392394366?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-11453542112673911882006-12-26T11:13:00.000-08:002008-12-18T12:15:03.935-08:00<div align="center"><strong>Transferring data between XML documents and relational databases</strong></div><div align="center"><blockquote></blockquote>by Ronald Bourret</div><div align="justify"><blockquote></blockquote>In this paper we will discuss strategies for transferring data between XML documents and relational databases according to two mappings (a table-based mapping and an object-based mapping) commonly used to map DTDs to relational databases. Although the discussion largely focuses on the difference between using SAX- and DOM-based tools to transfer data, it also discusses a number of strategies for traversing both the XML and database hierarchies and the tradeoffs among them.</div><div align="justify"><blockquote></blockquote><a href="http://www.rpbourret.com/xml/DataTransfer.htm" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-1145354211267391188?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-45270171998770317522006-12-26T11:04:00.000-08:002008-12-18T12:15:03.936-08:00<div align="center">First Edition</div><div align="center"><blockquote></blockquote>Sams Publishing</div><div align="justify"><blockquote></blockquote><strong>Introduction</strong></div><div align="justify">When I first started using Oracle many years ago, it was possible to know the database and the tools available. With the rash of recent releases of different options for the database and the spate of new tools, only people who wear their underpants over their trousers will be able to know everything there is to know about the Oracle products. If you were an experienced Oracle developer three years ago and since then have been locked away—not able to see the new Oracle versions of the database and tools—there will be very little that you will recognize today. Along with changes in other computing technologies, the rate of change with Oracle is constantly increasing, which is all the more interesting for us who get turned on by the software. You'll get a running start with the pages that follow. </div><div align="justify"><blockquote></blockquote>Oracle Unleashed is one of the most comprehensive books on Oracle and its tools available today. It's written by authors who have real-life experience using the Oracle tools (most of whom are members of the Oracle Business Alliance Program). We will show you what's important, the pitfalls, tips from real-life experiences, and code examples—The kind of information that can give you the cumulative experience of many years of expertise.</div><div align="justify"><blockquote></blockquote><a href="http://docs.rinet.ru/Krikun/" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-4527017199877031752?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-4764563615039517472006-12-26T10:47:00.000-08:002008-12-18T12:15:03.936-08:00<div align="center">By Philip A. Bernstein, Vassos Hadzilacos and Nathan Goodman</div><div align="justify"><blockquote></blockquote>For over 20 years, businesses have been moving their data processing activities on-line. Many businesses, such as airlines and banks, are no longer able to function when their on-line computer systems are down. Their on-line databases must be up-to-date and correct at all times.</div><blockquote></blockquote><div align="justify">In part, the requirement for correctness and reliability is the burden of the application programming staff. They write the application programs that perform the business’s basic functions: make a deposit or withdrawal, reserve a seat or purchase a ticket, buy or sell a security, etc. Each of these programs is designed and tested to perform its function correctly. However, even the most carefully implemented application program is vulnerable to certain errors that are beyond its control. These potential errors arise from two sources: concurrency and failures.</div><div align="justify"><blockquote></blockquote>Multiprogramming is essential for attaining high performance. Its effect is to allow many programs to interleave their executions. That is, they execute concwrently. When such programs interleave their accesses to the database, they can interfere. Avoiding this interference is called the concurrency control problem.</div><div align="justify"><blockquote></blockquote><a href="http://www.informatik.uni-trier.de/%7Eley/db/books/dbtext/bernstein87.html" target="_blank">Click to Read More/Download</a><br /><blockquote></blockquote><a href="http://www.amazon.com/gp/product/B000OKZU92?ie=UTF8&amp;tag=frsaabeb-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=B000OKZU92" target="_blank">Concurrency Control and Recovery in Database Systems</a><br /></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-476456361503951747?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-44046861266294443412006-12-26T10:41:00.000-08:002008-12-18T12:15:03.937-08:00<div align="center">By William R. Stanek</div><blockquote></blockquote><div align="justify">As you get started with Microsoft SQL Server 2000, you should concentrate on these areas:<br /></div><blockquote></blockquote><ul><li><div align="justify">How SQL Server 2000 works with your hardware</div></li><li><div align="justify">What versions and editions of SQL Server 2000 are available</div></li><li><div align="justify">How SQL Server 2000 works with Microsoft Windows-based operating systems</div></li><li><div align="justify">What administration tools are available</div></li></ul><p align="justify"><strong>SQL Server 2000 and Your Hardware</strong><br />Successful database server administration depends on three things:</p><blockquote></blockquote><ul><li><div align="justify">Good database administrators</div></li><li><div align="justify">Strong database architecture</div></li><li><div align="justify">Appropriate hardware</div></li></ul><p align="justify">The first two ingredients are covered: you're the administrator, you're smart enough to buy this book to help you through the rough spots, and you've enlisted SQL Server 2000 to provide your high-performance relational database management system (RDBMS) needs. This brings us to the issue of hardware. SQL Server 2000 should run on a system with adequate memory, processing speed, and disk space. You also need an appropriate data and system protection plan at the hardware level.</p><p align="justify"><a href="http://www.freetechbooks.com/microsoft-sql-server-2000-administrator-s-pocket-consultant-t314.html" target="_blank">Click to Read More</a></p><p align="justify"><a href="http://www.amazon.com/gp/product/0735611297?ie=UTF8&amp;tag=frsaabeb-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=0735611297" target="_blank">Microsoft SQL Server(TM) 2000 Administrator's Pocket Consultant (It-Administrator's Pocket Consultant)</a><a href="http://www.freetechbooks.com/microsoft-sql-server-2000-administrator-s-pocket-consultant-t314.html" target="_blank"><br /></a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-4404686126629444341?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-33836177310340097682006-12-26T10:31:00.000-08:002008-12-18T12:15:03.937-08:00<div align="center">by John C. Worsley and Joshua D. Drake </div><div align="center"><blockquote></blockquote>Command Prompt Inc </div><blockquote></blockquote><div align="justify">PostgreSQL is one of the most successful open source databases available. It is arguably also the most advanced, with a wide range of features that challenge even many closed-source databases.</div><div align="justify"><blockquote></blockquote>This book is intended to be a practical guide to PostgreSQL v7.1.x, though most of the book should also apply to earlier and future releases of PostgreSQL. The content is focused on getting you comfortable with PostgreSQL in the most expedient fashion possible. Although we will touch on some academic database subjects, such discussion will be kept brief. Our core focus is to provide the reader with enough of an understanding of PostgreSQL to manage a fully operational PostgreSQL database. Our hope is that by introducing this book to the community we will provide a better understanding of PostgreSQL and its functionality.</div><div align="justify"><blockquote></blockquote>This book is for anyone interested in utilizing the PostgreSQL object-relational database-management system (ORDBMS). The reader should be familiar with Linux- and UNIX-based systems, but is not expected to be a database guru. Although the test operating system for this book is Red Hat Linux, the tasks in this book that apply to Linux should apply to most UNIX variants without much modification.</div><div align="justify"><blockquote></blockquote><a href="http://www.commandprompt.com/ppbook/" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-3383617731034009768?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-26843297907581760502006-12-26T10:28:00.000-08:002008-12-18T12:15:03.938-08:00<div align="center">by Graham Williams </div><blockquote></blockquote><div align="justify">Knowledge leads to wisdom and better understanding. Data mining builds knowledge from information, adding value to the tremendous stores of data that abound today--stores that are ever increasing in size and availability. Emerging from the database community in the late 1980's the discipline of data mining grew quickly to encompass researchers from Machine Learning, High Performance Computing, Visualisation, and Statistics, recognising the growing opportunity to add value to data. Today, this multi-disciplinary effort continues to deliver new techniques and tools for the analysis of very large collections of data. Searching through databases measuring in gigabytes and terabytes data mining delivers discoveries that can change the way an organisation does business. It can enable companies to remain competitive in this modern data rich, knowledge hungry, wisdom scarce world. Data mining delivers knowledge to drive wisdom. </div><blockquote></blockquote><div align="justify">For a long time, Statisticians and more recently Machine Learning researchers, have sought to add value to data by building models from data samples. From a statistics point of view, the aim is generally to build accurate models. From a machine learning point of view, the aim is generally to gain understanding that can be turned into actionable knowledge. Irrespective the models can help better understand the general behaviour of systems and even predict outcomes for new cases. </div><blockquote></blockquote><div align="justify">Statistical and symbolic techniques have often been hamstrung by their computational and memory requirements, leading to long waits for models to be built over very large datasets. Alternatively sampling of the data is required in order to generate models in a reasonable time. Traditionally we might also characterise the statistical approach as apriori hypothesis testing rather than data exploration. </div><div align="justify"><blockquote></blockquote>Data mining strives to discover new knowledge (new hypotheses) from data, effectively letting the data speak for itself. Previously unknown patterns in very large databases are searched for, presenting discoveries in a human accessible form. </div><div align="justify"><blockquote></blockquote><a href="http://www.togaware.com/datamining/survivor/index.html" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-2684329790758176050?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-44974294379233026342006-12-14T13:15:00.000-08:002008-12-18T12:15:03.938-08:00<div align="center">By Mike Chapple</div><blockquote></blockquote><div align="justify"><strong>Introduction</strong><br />The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major platforms. At first glance, the language may seem intimidating and complex but it's really not all that bad. In a series of articles over the next few weeks we'll explore the inner workings of SQL together. By the time we're through, you'll have the fundamental knowledge you need to go out there and start working with databases!</div><div align="justify"><blockquote></blockquote>This week, our first article in the SQL series provides an introduction to the basic concepts behind SQL and we'll take a brief look at some of the main commands used to create and modify databases. Throughout this article, please keep our goal in mind: we're trying to get the "big picture" of SQL -- not a mastery of the individual commands.......</div><div align="justify"><blockquote></blockquote><a href="http://databases.about.com/od/sql/a/sqlfundamentals.htm" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-4497429437923302634?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-40949233405493878762006-12-14T13:09:00.000-08:002008-12-18T12:15:03.939-08:00<div align="center">by Philip Greenspun </div><blockquote></blockquote><div align="justify">After writing a preface lampooning academic eggheads who waste a lot of ink placing the relational database management system (RDBMS) in the context of 50 years of database management software, how does this book start? With a chapter placing the RDBMS in the context of other database management software. </div><blockquote></blockquote><div align="justify">Why? You ought to know why you're paying the huge performance, financial, and administration cost of an RDBMS. This chapter doesn't dwell on mainframe systems that people stopped using in the 1970s, but it does cover the alternative approaches to data management taken by Web sites that you've certainly visited and perhaps built. </div><div align="justify"><blockquote></blockquote>The architect of any new information system must decide how much responsibility for data management the new custom software should take and how much should be left to packaged software and the operating system. This chapter explains what kind of packaged data management software is available, covering files, flat file database management systems, the RDBMS, object-relational database management systems, and object databases. This chapter also introduces the SQL language. </div><div align="justify"><blockquote></blockquote><a href="http://philip.greenspun.com/sql/" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-4094923340549387876?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-90384466633242936962006-12-14T13:05:00.000-08:002008-12-18T12:15:03.939-08:00<div align="center">By Welland Barn</div><blockquote></blockquote><div align="justify">The objective of this chapter is to introduce the main concepts of data storage and retrieval in the context of database information systems. </div><blockquote></blockquote><div align="justify">In view of their prominence this booklet concentrates on the general characteristics of Relational Database Management Systems (RDBMS) and the Structured Query Language SQL and does not consider any of the numerous other types of databases. No prior knowledge of SQL is assumed. </div><blockquote></blockquote><div align="justify">It is intended that the SQL presented in this booklet be followed interactively and that the you should try all the given examples in the order in which they are presented. At the end of the booklet you should have attained a thorough knowledge of SQL and its capabilities as an interactive statement language. </div><blockquote></blockquote><div align="justify">In the main the SQL covered complies with the standard definition for SQL were proprietary SQL features are referred to this will be made clear. On this basis the skills obtained from this unit should be transferable across a wide range of RDBMS's which support SQL. </div><div align="justify"><blockquote></blockquote>To enable you to make effective use of your local facilities a number of RDBMS specific appendices containing access instructions and other supplementary information specific to your environment have been included. </div><div align="justify"><blockquote></blockquote><a href="http://lara.is/kennsla/gagnasafn/tenglar.htm" target="_blank">Find it from here</a><br /></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-9038446663324293696?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-33324459248485185412006-12-14T13:00:00.000-08:002008-12-18T12:15:03.940-08:00<div align="justify">This page is designed to be a central source of information about the SQL standards process and its current state. It also contains pointers to other sources of information about the SQL standard. The information available here is:<br /></div><blockquote></blockquote><ul><li><div align="justify">Current Status </div></li><li><div align="justify">Parts of the SQL Standard and Timeline </div></li><li><div align="justify">Definition of the Parts </div></li><li><div align="justify">Timeline </div></li><li><div align="justify">Number of Pages Devoted to Each Part </div></li><li><div align="justify">How to Get Copies of the Standards </div></li><li><div align="justify">The SQL Standards Process </div></li><li><div align="justify">SQL/MM </div></li></ul><p align="justify"><a href="http://www.jcc.com/sql.htm" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-3332445924848518541?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-44718838796662298262006-12-14T12:50:00.000-08:002008-12-18T12:15:03.940-08:00<div align="center">Authors: Jonathan Robie, Joe Lapp and David Schach</div><blockquote></blockquote><div align="justify">The XML Query Language (XQL) is a notation for addressing and filtering the elements and text of XML documents. XQL is a natural extension to the XSL pattern syntax. It provides a concise, understandable notation for pointing to specific elements and for searching for nodes with particular characteristics. This proposal was provided in September 1998 to the XSL Working Group (http://www.w3.org/Style/XSL/Group/1998/09/XQL-proposal.html) as input when considering extensions to the XSL pattern syntax.</div><div align="justify"><blockquote></blockquote>The companion document Querying and Transforming XML describes the benefits of basing query and transformation languages for XML on the XSL transformation language and the extensions to the pattern language proposed here.</div><blockquote><a name="Introduction"></a><a name="Introduction"></a></blockquote><div align="justify"><a name="Introduction"><strong>Introduction</strong></a><br />The XSL pattern language ( http://www.w3.org/TR/WD-xsl, section 2.6) provides an extremely understandable way to describe a class of nodes to process. It is declarative rather than procedural. One simply describes the types of nodes to look for using a simple pattern modeled after directory notation. For example, book/author means find author elements contained in book elements.</div><blockquote></blockquote><div align="justify">XQL (XML Query Language) provides a natural extension to the XSL pattern language. It builds upon the capabilities XSL provides for identifying classes of nodes, by adding Boolean logic, filters, indexing into collections of nodes, and more.</div><div align="justify"><blockquote></blockquote>XQL is designed specifically for XML documents. It is a general purpose query language, providing a single syntax that can be used for queries, addressing, and patterns. XQL is concise, simple, and powerful.......</div><div align="justify"><blockquote></blockquote><a href="http://www.w3.org/TandS/QL/QL98/pp/xql.html" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-4471883879666229826?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-90941247278150616952006-12-14T12:45:00.000-08:002008-12-18T12:15:03.941-08:00<div align="justify">Welcome to SQLCourse2.com! This unique SQL Tutorial is the "sequel" to the highly successful SQLCourse.com site and will provide you with more advanced easy-to-follow SQL Instruction and the ability to practice what you learn on-line with immediate feedback! You will receive immediate results on a web page after submitting your SQL Commands.</div><blockquote></blockquote><div align="justify">This continuation course will provide you with critical need-to-know advanced features and clauses of the SELECT statement that weren't supported in the previous SQLCourse.com site. Everything you learn here will be ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, mySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. </div><div align="justify"><blockquote></blockquote>If you're already familar with the basics of SQL, you can still use this as a refresher, and practice some SQL statements.</div><div align="justify"><blockquote></blockquote><strong>Overview</strong></div><div align="justify">This Intermediate/Advanced SQL Tutorial will cover the SELECT statement in great detail. The SELECT statement is the core of SQL, and it is likely that the vast majority of your SQL commands will be SELECT statements. Due to the enormous amount of options available for the SELECT statement, this entire tutorial has been dedicated to it. </div><blockquote></blockquote><div align="justify">When constructing SQL Queries (with the SELECT statement), it is very useful to know all of the possible options and the best or more efficient way to do things. This Tutorial will help provide you with those skills. </div><div align="justify"><blockquote></blockquote>Although it is recommended that you go through SQLCourse.com (the original site) or at least the SELECT statement on SQLCourse.com, it isn't required. YOu can start with this site, and then proceed to SQLCourse.com when you are finished. SQLCourse.com covers four other SQL Commands and allows you to practice those as well. </div><div align="justify"><blockquote></blockquote><a href="http://sqlcourse2.com/" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-9094124727815061695?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-19612870145467071412006-12-14T12:37:00.000-08:002008-12-18T12:15:03.941-08:00<div align="center">Gradiance.com</div><div align="justify"><blockquote></blockquote>Our approach to teaching SQL is to use a combination of coding exercises (writing queries) and quizzes, to emphasize the "learning by programming" paradigm, along with providing a set of slide sets covering the relevant material. The programming exercises are on-line and feature immediate constructive feedback about the correctness of the submitted queries. Test cases, comments and hints are provided to illustrate the errors and help you debug the queries on-line. </div><blockquote></blockquote><div align="justify">The Gradiance SQL tutorial covers the following core topics:<br /></div><blockquote></blockquote><ul><li><div align="justify">Basics - the SELECT-FROM-WHERE framework for SQL queries</div></li><li><div align="justify">Null Values and Aggregation - dealing with NULL values in SQL tables; aggregating column values </div></li><li><div align="justify">Grouping and Ordering - GROUP BY and ORDER BY clauses </div></li><li><div align="justify">Join queries - multi-table queries involving join operations </div></li><li><div align="justify">Aggregation and NULL values in join queries - grouping and aggregation across multiple tables; NULL values and outer-join operations </div></li><li><div align="justify">Subqueries - notion of queries embedded in other queries; IN, NOT IN, ANY, ALL and EXISTS operations </div></li></ul><p align="justify">The estimated duration for the tutorial is from 30 to 60 hours, spread over a total of 150 slides, 30 problems to solve (in the quizzes) and 50 programming exercises to work on (in the lab projects). The material is organized into six lesson packages, with associated quizzes and lab projects, so that each item can be handled in a short session...........</p><p align="justify"><a href="http://www.gradiance.com/STwelcome.html" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-1961287014546707141?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-47196772504405885222006-12-14T12:32:00.000-08:002008-12-18T12:15:03.942-08:00<div align="center">Macmillan Computer Publishing</div><strong></strong><blockquote><strong><a name="Introduction"><strong></strong></a><a name="Introduction"></a></strong></blockquote><div align="justify"><strong><a name="Introduction">Introduction</a></strong><br />Welcome to Using Oracle8! This book identifies the many functions an Oracle DBA needs to perform on an Oracle8 database and explains how to do them as efficiently and effectively as possible. You learn about the key functions of database administration, including installing the product, designing and creating a database and its tablespaces, designing and creating the tables and other objects that make up an Oracle database, designing and executing a good backup strategy with a recovery methodology, and monitoring and tuning performance. You also learn about creating and maintaining users and performing an upgrade to Oracle8, as well as other tasks that you may need in your position as DBA. You also learn when and how to use the various tools Oracle8 provides to assist you in database management, performance monitoring and tuning, data loading, backup and recovery, and data export and import. </div><blockquote></blockquote><div align="justify">The book is designed to let you read about a topic at length when you have the time and the inclination, or to use as a quick reference guide when you need an answer to a pressing technical question or an example to follow when performing a specific task. </div><blockquote></blockquote><div align="justify">Using Oracle8 contains cross-references to related topics so that you can look at all aspects of a topic, even if they're covered in different chapters. These cross-references also enable you to read the book in any order you choose. If you run across a subject you don't fully understand, you can easily switch your attention to the area(s) identified and carry on your reading there. Where applicable, the book also references the Oracle documentation materials, so you can find even more detail if you need it. </div><div align="justify"><blockquote></blockquote>Don't forget to keep this book handy at work, just in case you need to check something in a hurry that you haven't read about yet or is a new topic to you. Be sure also to use the tear-out card inside the book's cover. It contains some of the most common, but difficult to remember, information you'll need. </div><div align="justify"><blockquote></blockquote><a href="http://docs.rinet.ru/O8/" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-4719677250440588522?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-79623417961691096522006-12-14T12:29:00.000-08:002008-12-18T12:15:03.942-08:00<div align="center">by Paul Hipsley</div><div align="center"><blockquote></blockquote>Sams, Macmillan Computer Publishing </div><blockquote></blockquote><div align="justify">Oracle Developer/2000 is the next generation of development tools for Microsoft Windows applications development from Oracle Corporation. Oracle Developer/2000 leverages the power of Oracle7 and Microsoft Windows. Oracle7 is the most popular Relational Database Management System (RDBMS) in the world and Microsoft Windows is the most popular Graphical User Interface (GUI) in the world. The previous release of Oracle Developer/2000 was know as the Oracle Cooperative Development Environment (CDE). At times you may see or hear references to CDE2, which is now known as Oracle Developer/2000. </div><div align="justify"><blockquote></blockquote>This book is intended to be of value to many different types of readers, including managers of Oracle client/server projects, individuals evaluating development tools, programmers who are new to the Oracle environment, experienced Oracle programmers who are new to the Windows development environment, and students interested in investing in their future careers in the Oracle application development job market........</div><div align="justify"><blockquote></blockquote><a href="http://freebooks.by.ru/view/OracleClientServer/ewtoc.html" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-7962341796169109652?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-86378330668253954762006-12-14T12:23:00.000-08:002008-12-18T12:15:03.943-08:00<div align="center">SAMS Publishing</div><blockquote><a id="I8" name="I8"></a><a id="I8" name="I8"></a></blockquote><div align="justify"><a id="I8" name="I8"><strong>Introduction </strong></a><br />When I first started using Oracle many years ago, it was possible to know the database and the tools available. With the rash of recent releases of different options for the database and the spate of new tools, only people who wear their underpants over their trousers will be able to know everything there is to know about the Oracle products. If you were an experienced Oracle developer three years ago and since then have been locked away—not able to see the new Oracle versions of the database and tools—there will be very little that you will recognize today. Along with changes in other computing technologies, the rate of change with Oracle is constantly increasing, which is all the more interesting for us who get turned on by the software. You'll get a running start with the pages that follow. </div><blockquote></blockquote><div align="justify">Oracle Unleashed is one of the most comprehensive books on Oracle and its tools available today. It's written by authors who have real-life experience using the Oracle tools (most of whom are members of the Oracle Business Alliance Program). We will show you what's important, the pitfalls, tips from real-life experiences, and code examples—The kind of information that can give you the cumulative experience of many years of expertise. </div><div align="justify"><blockquote><a href="http://docs.rinet.ru/Krikun/" target="_blank"></a><a href="http://docs.rinet.ru/Krikun/" target="_blank"></a></blockquote><a href="http://docs.rinet.ru/Krikun/" target="_blank">Click to Read More</a></div><div align="justify"></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-8637833066825395476?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-57860810884686166662006-12-14T12:20:00.000-08:002008-12-18T12:15:03.943-08:00<div align="center">Publisher: Sybex, Inc.</div><div align="center"><blockquote></blockquote>Author(s): Nick Snowdon </div><blockquote></blockquote><div align="justify"><strong>Why a Book on Oracle and Visual Basic?<br /></strong>This is an unusual book as far as computer literature goes in that it covers two quite separate areas of information technology. Many good books are available on Oracle, although nearly every one is designed as a source of information for database administrators. There are probably more books on Visual Basic than any other topic except perhaps the Web, but you will rarely see the word “Oracle” in the indexes. The lack of information is what I found myself dealing with a few years ago. Even with my strong background in Visual Basic (version 3 at the time), I found getting myself connected to an Oracle database and making it perform efficiently and effectively posed a problem that needed an answer.</div><blockquote></blockquote><div align="justify">This book is a personal one because it provides the resource I would have liked to have had a few years ago. It combines an understanding of the basic concepts about Oracle without which you will have a hard time communicating with database administrators or carrying out the administration role yourself if you are caught in that situation. (Oracle is not the simplest of databases to administer, which is something that is not always appreciated by project managers.)</div><blockquote></blockquote><div align="justify">Most Oracle texts are generally too complicated for the novice who has a hard time trying to decide which things are important enough to learn and which can be safely discarded until more time is available for training. Visual Basic books, on the other hand, are either introductory or deal exclusively with Microsoft SQL Server. So many questions are left unanswered for Oracle developers, even if it is just seeing an example of how something works.</div><div align="justify"><blockquote></blockquote>The paucity of books for Oracle developers and the absence of any coverage of Oracle in the Visual Basic literature has led to the need for such coverage; this book will provide you with the information to proceed with your VB front ends to Oracle.</div><div align="justify"><blockquote></blockquote><a href="http://freebooks.by.ru/view/OracleProgWithVB/ewtoc.html" target="_blank">Click to Read More</a></div><div align="justify"></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-5786081088468616666?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-11682038706518946152006-12-14T12:15:00.000-08:002008-12-18T12:15:03.944-08:00<div align="center">by Edward Whalen </div><div align="center"><blockquote></blockquote>Sams, Macmillan Computer Publishing </div><a name="Heading1"></a><blockquote></blockquote><div align="justify"><strong>Introduction</strong><br />Database management software and the manipulation of data has evolved to where it touches every aspect of our lives. A day doesn’t go by in which we don’t access a database. Whether we are withdrawing money from an ATM machine, opening a checking account, or purchasing groceries, every aspect of our lives is affected by databases. Hand in hand with the new power of information comes the frustration of having to wait for data to be retrieved. I’m sure there isn’t a person today who hasn’t had to wait for a credit card to be approved. Although the speed of computers has been increasing every year, so has the amount of data being manipulated. Amounts of data that several years ago were unheard of are now a daily part of many companies. In years past, databases were used strictly in the realm of big business because large mainframes cost millions of dollars; today, gigabytes of data are being manipulated on the same types of computer you may have in your own home. </div><blockquote></blockquote><div align="justify">No matter how fast new generations of computers get, applications will always be written to take advantage of them. As the cost of storage continues to drop, the amount of data stored will continue to increase. A perfect example of this is the CD-ROM. The advent of the CD-ROM allowed large amounts of data to be inexpensively stored; predictably, many new applications have arisen to take advantage of that technology. These applications are now augmenting written text with video and audio clips. The same type of information revolution is also happening in the database industry.</div><div align="justify"><blockquote></blockquote>Oracle already has the capability to store video, documents, and large binary objects in the database and allow quick access to this data. Oracle databases can store hundreds of gigabytes of data and can easily retrieve it; Oracle has the potential of storing terabytes of data in a single database in the near future.</div><div align="justify"><blockquote></blockquote><a href="http://freebooks.by.ru/view/OraclePerfTuningOpt/ewtoc.html" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-1168203870651894615?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-59980195455482317032006-12-14T12:09:00.000-08:002008-12-18T12:15:03.944-08:00<div align="center">Publisher: The Coriolis Group </div><div align="center"><blockquote></blockquote>Author(s): Michael R. Ault </div><blockquote></blockquote><div align="justify"><strong>Chapter 1—</strong>Provides an overview of relational and object-oriented terminology and technology. The Practical Guide provides concrete examples of how to apply these to database design. Actual conversion examples are given.<br /></div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 2—</strong>Provides an overview of database structured design methodology. The Practical Guide demonstrates real-world application of the structured design concepts and provides a template for use in object-oriented diagramming.<br /></div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 3—</strong>Discusses Oracle8 and how triggers are used to provide encapsulation and data hiding. Example triggers are shown, and the dreaded mutating table is slain. </div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 4—</strong>Discusses Oracle object/relational structures and insights into the use of the user-defined types. Comparisons to Java are utilized to demonstrate Oracle8’s object-oriented capabilities.<br /></div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 5—</strong>Demonstrates Oracle8 data storage features. Partitioned tables, nested tables, VARRAYs, index-only tables, and LOB storage examples are given.<br /></div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 6—</strong>Examines the new LOB features of Oracle8. Techniques for reading, inserting, and using LOB datatypes in the database are demonstrated including the DBMS_LOB package.<br /></div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 7—</strong>Examines the PL/SQL enhancements specifically dealing with collection data types such as VARRAY and nested tables. The Practical Guide demonstrates the use of collection methods and data types.<br /></div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 8—</strong>Deals with the new parallel and distributed options of Oracle8. Techniques for use of parallel insert, update, and delete are discussed and demonstrated. Advanced queuing is also discussed.<br /></div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 9—</strong>Demonstrates how the Oracle8 data dictionary has been altered for the new features of Oracle8. The book’s companion appendix provides complete definitions of the major sets of data dictionary items such as the dollar ($), GV_$, and DBA_ views and tables. The Practical Guide shows how these tables and views are used to find information about Oracle8 objects.<br /></div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 10—</strong>Provides information on application tuning with practical demonstrations of the use of Oracle provided tuning tools and scripts. All scripts discussed in Chapter 10 are provided on the com-panion CD-ROM, which also includes the Precise/SQL SQL-tuning tool from Precise Software Solutions.<br /></div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 11—</strong>Provides information on tuning Oracle internals. The Practical Guide provides scripts, techniques, and guidelines for Oracle internal tunings. All scripts shown are provided on the companion CD-ROM along with the Q Diagnostic program from Savant Corporation.<br /></div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 12—</strong>Covers the Oracle-supplied tuning and utility scripts, and demonstrates their use.<br /></div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Chapter 13—</strong>Covers Oracle and Java topics. The Practical Guide shows examples of the use of Java with Oracle, including queries against the Oracle database using JDBC and JSQL, and the retrieval and display of objects (such as images) from the database. The companion CD-ROM contains the JDK1.1.4, JDBC, and JSQL development tool sets for use with Oracle8. </div><div align="justify"><strong><blockquote><strong></strong></blockquote>Appendix—</strong>Provides a reference for DBA_ and V$ views and ($) dollar tables. </div><div align="justify"><blockquote></blockquote><a href="http://freebooks.by.ru/view/Oracle8BlackBook/ewtoc.html" target="_blank">Click to Read More</a></div><div align="justify"></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-5998019545548231703?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-49159402316574471032006-12-14T11:58:00.000-08:002008-12-18T12:15:03.949-08:00<div align="center">By David Lockman</div><div align="center"><blockquote></blockquote>Copyright © 1997 by Sams Publishing</div><blockquote></blockquote><p></p><p><a name="Heading9"></a><strong>What This Book Is About</strong></p><p align="justify">This book is about a the version of the Oracle relational database management system (RDBMS) called Personal Oracle7. Personal Oracle7 is a version of the Oracle product that runs on top of Microsoft Windows 95 and Windows 3.11. Even though Personal Oracle7 is a PC-based version of the Oracle RDBMS, Personal Oracle7 provides almost the same features that exist in the versions of the Oracle RDBMS for large computer systems. As a result, Personal Oracle7 is an excellent tool for developers who intend to design applications for the Oracle RDBMS. </p><p align="justify"><a href="http://docs.rinet.ru/Oru7na95/" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-4915940231657447103?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-5823224972885673422006-12-14T11:49:00.000-08:002008-12-18T12:15:03.949-08:00<div align="center">Second Edition</div><div align="center"><blockquote></blockquote>By Stephen Wynkoop</div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Introduction</strong><br />All of data processing is involved with the operations of storing and retrieving data. A database, such as Microsoft SQL Server, is designed as the central repository for all the data of an organization. The crucial nature of data to any organization underlines the importance of the method used to store it and enable its later retrieval.</div><blockquote></blockquote><div align="justify">Microsoft SQL Server uses features similar to those found in other databases and some features that are unique. Most of these additional features are made possible by SQL Server's tight integration with the Windows NT operating system. SQL Server contains the data storage options and the capability to store and process the same volume of data as a mainframe or minicomputer.</div><blockquote></blockquote><div align="justify">Like most mainframe or minicomputer databases, SQL Server is a database that has seen an evolution from its introduction in the mid-1960s until today. Microsoft's SQL Server is founded in the mature and powerful relational model, currently the preferred model for data storage and retrieval.</div><blockquote></blockquote><div align="justify">Unlike mainframe and minicomputer databases, a server database is accessed by users--called clients--from other computer systems rather than from input/output devices, such as terminals. Mechanisms must be in place for SQL Server to solve problems that arise from the access of data from perhaps hundreds of computer systems, each of which can process portions of the database independently from the data on the server. Within the framework of a client/server database, a server database also requires integration with communication components of the server in order to enable connections with client systems. Microsoft SQL Server's client/server connectivity uses the built-in network components of Windows NT.</div><blockquote></blockquote><div align="justify">Unlike a stand-alone PC database or a traditional mainframe or minicomputer database, a server database, such as Microsoft SQL Server, adds service-specific middleware components--such as Open Database Connectivity (ODBC)--on top of the network components. ODBC enables the interconnection of different client applications without requiring changes to the server database or other existing client applications.</div><blockquote></blockquote><div align="justify">SQL Server also contains many of the front-end tools of PC databases that traditionally haven't been available as part of either mainframe or minicomputer databases. In addition to using a dialect of Structured Query Language (SQL), GUI applications can be used for the storage, retrieval, and administration of the database.</div><blockquote></blockquote><div align="justify">Now, with the addition of new database-aware components, you can also use your SQL Server with your Internet-based applications. Tools such as the Internet Database Connector, or IDC, and the Advanced Data Connector, or ADC, are available that will help you integrate SQL Server database information into your Web pages. Depending on the tool or approach you select, you'll have access that ranges from static Web pages to dynamic, Visual Basic-enhanced Web pages. These exciting tools are making Web-based applications a reality..............</div><div align="justify"><blockquote><a href="http://docs.rinet.ru/MSSSSSSQL/" target="_blank"></a><a href="http://docs.rinet.ru/MSSSSSSQL/" target="_blank"></a></blockquote><a href="http://docs.rinet.ru/MSSSSSSQL/" target="_blank">Click to Read More </a></div><div align="justify"></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-582322497288567342?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-21515221510573381092006-12-14T11:44:00.000-08:002008-12-18T12:15:03.950-08:00<div align="center">Authors: : Ryan K. Stephens, Ronald R. Plew, Bryan Morgan, and Jeff Perkins</div><div align="center"><blockquote></blockquote>© Copyright, Macmillan Computer Publishing.</div><strong></strong><blockquote><strong><strong></strong></strong></blockquote><div align="justify"><strong>Overview</strong><br />The first 14 days of this book show you how to use SQL to incorporate the power of modern relational databases into your code. By the end of Week 1, you will be able to use basic SQL commands to retrieve selected data. </div><blockquote></blockquote><div align="justify">NOTE: If you are familiar with the basics and history of SQL, we suggest you skim the first week's chapters and begin in earnest with Day 8, "Manipulating Data." </div><blockquote></blockquote><div align="justify">At the end of Week 2, you will be able to use the more advanced features of SQL, such as stored procedures and triggers, to make your programs more powerful. Week 3 teaches you how to streamline SQL code; use the data dictionary; use SQL to generate more SQL code; work with PL/SQL, Transact-SQL, and SQL*Plus; and handle common SQL mistakes and errors.</div><div align="justify"><blockquote></blockquote>The syntax of SQL is explained and then brought to life in examples using Personal Oracle7, Microsoft Query, and other database tools. You don't need access to any of these products to use this book--it can stand alone as an SQL syntax reference. However, using one of these platforms and walking though the examples will help you understand the nuances. </div><div align="justify"><blockquote><a href="http://docs.rinet.ru/SQL-3w/" target="_blank"></a><a href="http://docs.rinet.ru/SQL-3w/" target="_blank"></a></blockquote><a href="http://docs.rinet.ru/SQL-3w/" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-2151522151057338109?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-75230106336215039012006-12-14T11:39:00.000-08:002008-12-18T12:14:35.941-08:00<blockquote></blockquote><p align="center">sqlzoo.net</p><p><strong>What is Sql?</strong></p><div align="justify">SQL stands for "Structured Query Language". This language allows us to pose complex questions of a database. It also provides a means of creating databases. SQL very widely used. Many database products support SQL, this means that if learn how to use SQL you can apply this knowledge to MS Access or SQL Server or to Oracle or Ingres and countless other databases.</div><div align="justify"><blockquote></blockquote>SQL works with relational databases. A relational database stores data in tables (relations). A database is a collection of tables. A table consists a list of records - each record in a table has the same structure, each has a fixed number of "fields" of a given type.......</div><div align="justify"><blockquote></blockquote><a href="http://sqlzoo.net/" target="_blank">Click to Read More</a></div><div align="justify"></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-7523010633621503901?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-2391827171523257492006-12-14T11:34:00.000-08:002008-12-18T12:14:35.941-08:00<div align="justify"><blockquote></blockquote>Large-scale computer applications require rapid access to large amounts of data. A computerized checkout system in a supermarket must track the entire product line of the market. Airline reservation systems are used at many locations simultaneously to place passengers on numerous flights on different dates. Library computers store millions of entries and access citations from hundreds of publications. Transaction processing systems in banks and brokerage houses keep the accounts that generate international flows of capital. World Wide Web search engines scan thousands of Web pages to produce quantitative responses to queries almost instantly. Thousands of small businesses and organizations use databases to track everything from inventory and personnel to DNA sequences and pottery shards from archaeological digs. </div><div align="justify"><blockquote></blockquote>Thus, databases not only represent significant infrastructure for computer applications, but they also process the transactions and exchanges that drive the U.S. economy..........</div><div align="justify"><blockquote></blockquote><a href="http://kb.cospa-project.org/retrieve/1998/20040116445.pdf" target="_blank">Click to Read More</a></div><div align="justify"></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-239182717152325749?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-31807206647600484842006-12-14T11:30:00.000-08:002008-12-18T12:14:35.942-08:00<div align="center">by Anthony and Hala Awtrey</div><blockquote></blockquote><div align="justify">One of the most powerful tools computers give us is the ability to store and search data. Early applications stored data for programs in files and used indexes to search the files for particular bits of data. These programs didn't fare very well on networks because there are problems with more than one computer trying to update data in a file simultaneously. This fact and the lack of standard database structure and command syntax encouraged the creation of the networked relational database. </div><blockquote></blockquote><div align="justify">When you write a program and want to be able to manipulate and search data you often have to construct the data files and the code to perform the manipulation and searches. This is a time consuming task and if you are developing many different applications you have to reinvent the data handling routines for every job. By removing the database functions such as file management, indexing, searches and simultaneous data access, you speed up development of applications and allow for these specialized database programs to become highly optimized and scalable. </div><div align="justify"><blockquote></blockquote><strong>What is a database</strong><br />A database is simply organized data. A database contains tables which are basically descriptions of types of data. Tables in turn contain records which is the actual data......</div><div align="justify"><blockquote></blockquote><a href="http://www.awtrey.com/tutorials/dbeweb/database.php" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-3180720664760048484?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-50103532593186575662006-12-14T11:20:00.000-08:002008-12-18T12:14:35.942-08:00<div align="center">By <a name="AEN35935">Christopher Browne</a></div><blockquote></blockquote><div align="justify"><strong>Database Classifications</strong></div><div align="justify">There are several ways of classifying the database systems available for Linux:<br /></div><blockquote></blockquote><ul><li><div align="justify">Based on "freeness." - There are commercial packages (sold for a price), and there are free software database systems (that do not cost anything to acquire). This is fairly closely correlated to availability of usable source code, which is another legitimate interpretation of "freeness."</div></li><li><div align="justify"><blockquote></blockquote>Compatibility/Means of Functioning - </div></li></ul><blockquote></blockquote><ol><li><div align="justify">xBASE - This is traditionally a "PC" oriented system, of which the first version was known as Vulcan, and ran under CP/M . It was later renamed dBase, and later versions and competitors have followed.<br /><blockquote></blockquote>The system model generally involves data structured in a dual fashion similar to ISAM databases with "data" files containing data, and "index" files containing index information. Applications access data directly by reading the files. Newer versions have a network locking system to manage contention for files and/or records if multiple users try to access data simultaneously, but there is still contention inherent in that many programs are accessing the same files simultaneously.<br /><blockquote></blockquote>More modern systems use "extent-based" allocation systems to better support the handling of tuples of varying sizes.</div></li><li><div align="justify"><blockquote></blockquote>SQL - Structured Query Language - Ingres was the progenitor of the modern "query language," with its QUEL query language; a similar query language was then designed that we now know as SQL. SQL is arguably inferior to QUEL, as QUEL had a syntax that is simultaneously simpler and more powerful than that of SQL.<br /><blockquote></blockquote>The system model typically involves there being a central database manager "engine" or "process;" application programs do not have direct access to the data. This allows data to be relatively protected from corruption/misuse by rogue processes.</div></li></ol><p align="justify"><a href="http://cbbrowne.com/info/rdbms.html" target="_blank">Click to Read More</a></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-5010353259318657566?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-37082592316325833322006-12-14T11:15:00.000-08:002008-12-18T12:14:35.943-08:00<div align="center">cs.unc.edu</div><blockquote></blockquote><div align="justify"><strong>Lesson Overview</strong></div><div align="justify">As part of the spring 1998 Advanced Java Course at UNC, I am giving the first seminar intended to introduce the audience to relational databases and give a tutorial on Microsoft Access. This lecture precedes one by Wen Zhang and Ganesh Srivinas about connecting to a database from java, and a final database lecture by Will Sexton and Rich Thornett about the "JDBC". </div><div align="justify"><blockquote></blockquote>We start off quickly looking at the notion of "database" and consider the simple relational database model of tables with tuples (rows) and attributes (columns). A popular way to design a database is through ER diagrams, and we look at a sample diagram. I hope that you won't get bogged down when we discuss the relational algebra, set theoretic notions that the relational model is based upon. Though it is important to have some basic understanding of the relational algebra, in practice most users take advantage of a higher level language for retrieving information from a database, and we look at SQL (Structured Query Language) as a common example. Finally, we motivate the use of Microsoft Access, a popular relational database system, and follow-on with a detailed tutorial on how to use Access. </div><div align="justify"><blockquote><a href="http://www.cs.unc.edu/Courses/wwwp-s98/members/barman/databaseLesson/" target="_blank"></a><a href="http://www.cs.unc.edu/Courses/wwwp-s98/members/barman/databaseLesson/" target="_blank"></a></blockquote><a href="http://www.cs.unc.edu/Courses/wwwp-s98/members/barman/databaseLesson/" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-3708259231632583332?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-53531505544434485772006-12-14T11:08:00.000-08:002008-12-18T12:14:35.943-08:00<div align="center">infolab.stanford.edu</div><div align="justify"><blockquote></blockquote>This document was written originally by Yu-May Chang and Jeff Ullman for CS145, Autumn 1997; revised by Jun Yang for Prof. Jennifer Widom's CS145 class in Spring, 1998; additional material by Jeff Ullman, Autumn 1998; further revisions by Jun Yang, Spring 1999; minor revisions by Jennifer Widom, Spring 2000. </div><div align="justify"><strong><blockquote><strong></strong></blockquote>Basic Structure of PL/SQL</strong></div><div align="justify">PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. All PL/SQL programs are made up of blocks, which can be nested within each other. Typically, each block performs a logical action in he program. A block has the following structure: </div><div align="justify"><blockquote></blockquote>DECLARE<br />/* Declarative section: variables, types, and local subprograms. */</div><div align="justify">BEGIN<br />/* Executable section: procedural and SQL statements go here. */<br />/* This is the only section of the block that is required. */</div><div align="justify">EXCEPTION<br />/* Exception handling section: error handling statements go here. */</div><div align="justify">END;</div><div align="justify"><blockquote></blockquote><a href="http://infolab.stanford.edu/%7Eullman/fcdb/oracle/or-plsql.html" target="_blank">Click to Read More</a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-5353150554443448577?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-70325370721796808602006-12-14T11:02:00.000-08:002008-12-18T12:14:35.944-08:00<blockquote></blockquote><blockquote></blockquote><blockquote></blockquote><p align="center">Copyright 1997-2006 MySQL AB </p><p align="justify">This is the Reference Manual for the MySQL Database System, version 5.1, through release 5.1.12-beta. It is not intended for use with older versions of the MySQL software due to the many functional and other differences between MySQL 5.1 and previous versions. If you are using an earlier release of the MySQL software, please refer to the MySQL 5.0 Reference Manual, which covers the 5.0 series of MySQL software releases, or to MySQL 3.23, 4.0, 4.1 Reference Manual, which covers the 3.23, 4.0, and 4.1 series of MySQL software releases. Differences between minor versions of MySQL 5.1 are noted in the present text with reference to release numbers (5.1.x). </p><p align="justify">Because this manual serves as a reference, it does not provide general instruction on SQL or relational database concepts. It also does not teach you how to use your operating system or command-line interpreter. </p><p align="justify">The MySQL Database Software is under constant development, and the Reference Manual is updated frequently as well. The most recent version of the manual is available online in searchable form at http://dev.mysql.com/doc/. Other formats also are available there, including HTML, PDF, and Windows CHM versions.........</p><p align="justify"><a href="http://dev.mysql.com/doc/refman/5.1/en/index.html" target="_blank">Click to Read More</a></p><p align="justify"></p><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-7032537072179680860?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.comtag:blogger.com,1999:blog-6995062383942850038.post-76821799028335293132006-12-14T08:44:00.000-08:002008-12-18T12:14:35.944-08:00<div align="center">© 1995-2006 MySQL AB</div><div align="center"><blockquote></blockquote>dev.mysql.com</div><div align="justify"><blockquote></blockquote>This article is the first in an educational series offered by MySQL AB aimed towards providing the reader with valuable insight into the MySQL database server. Although future articles will delve into some of the more complicated topics surrounding MySQL, including replication, ODBC and optimization, it was thought to be prudent if the first tutorial started, well, at the beginning. Therefore the goal of this article is to thoroughly acquaint the reader with various topics surrounding the basic functioning of MySQL. A synopsis of what is covered is shown in the Table of Contents, listed below. You can go to any topic listed in the Table of Contents simply by clicking on its title. </div><div align="justify"><blockquote></blockquote><a href="http://dev.mysql.com/tech-resources/articles/mysql_intro.html" target="_blank">Click to Read More</a></div><div align="justify"></div><div align="center"></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6995062383942850038-7682179902833529313?l=more-database.blogspot.com' alt='' /></div>Administratornoreply@blogger.com