Modified: db/derby/site/trunk/build/site/papers/ApacheCon.html URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/ApacheCon.html?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== --- db/derby/site/trunk/build/site/papers/ApacheCon.html (original) +++ db/derby/site/trunk/build/site/papers/ApacheCon.html Fri Dec 21 14:30:38 2007 @@ -1,9 +1,9 @@ - + - + ApacheCon @@ -16,49 +16,88 @@
+
apache > db
+
+ + +
Apache DB Project
+ + +
+
+
+
- +  
+ +
+ +
+
+ +
-
-Font size: +
Font size:       @@ -554,21 +607,30 @@
+
 
Send feedback about the website to: derby-user@db.apache.org
+
Modified: db/derby/site/trunk/build/site/papers/DerbyClientSpec.html URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyClientSpec.html?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== --- db/derby/site/trunk/build/site/papers/DerbyClientSpec.html (original) +++ db/derby/site/trunk/build/site/papers/DerbyClientSpec.html Fri Dec 21 14:30:38 2007 @@ -1,9 +1,9 @@ - + - + @@ -19,49 +19,88 @@
+
apache > db
+
+ + +
Apache DB Project
+ + +
+
+
+
- +  
+ +
+ +
+
+ +
-
-Font size: +
Font size:       @@ -269,13 +322,13 @@ Derby Network Client
  • -Overview +Overview
  • -Functionality +Functionality
  • -JDBC Driver and DataSource names +JDBC Driver and DataSource names
  • -Data Source properties +Data Source properties
  • -Security +Security
  • -Packaging, Distribution and Versioning +Packaging, Distribution and Versioning
  • -Comparision and/or differences with the Derby Embedded Driver +Comparision and/or differences with the Derby Embedded Driver
  • -Effects to existing documentation +Effects to existing documentation
  • -Miscellaneous +Miscellaneous
    • Tools @@ -346,12 +399,12 @@

      Created: 4/11/05
      Last update: 10/25/05 -- changed h4 tags to h3 (forrest hid data), and removed manual table of contents


      - +

      Overview

      The Derby network client provides network connectivity to the Derby Network Server. It is distributed as an additional jar file, derbyclient.jar, with an entirely independent code base from the embedded driver.

      The Derby network client is a type 4, JDBC compliant Driver, which attempts to match the Derby Embedded JDBC driver as much as possible. Initially, it will have some differences from the embedded driver, for example, some SQL States will remain null and error messages will not be localized in the initial offering. Hopefully, over time the functionality of the two drivers will converge.


      - +

      Functionality



      @@ -360,7 +413,7 @@

      Tools support for ij and dblook as well as test harness support is provided.

      The sections that follow will describe the functionality and provide examples of using each characteristic mentioned here.


      - +

      JDBC Driver and DataSource names

      The Derby network client classes and JDBC interfaces they implement are listed below.

      @@ -382,7 +435,7 @@
      - +

      Connection URL Format

      The protocol for the client URL is jdbc:derby://. The embedded and client attributes are specified the same way. The embedded driver has been changed to reject URL's with a // following derby:

      @@ -392,9 +445,9 @@

      An example of using this URL to connect to the Derby network server running on the localhost at port 1527 in ij is:

      ij> connect `jdbc:derby://localhost:1527/sample;create=true;user=user1;password=secret4me';


      - +

      Ways to Connect using the Derby Client Driver

      - +

      Client CLASSPATH

      Prior to using the Derby network client, the derbyclient.jar file needs to be added to the classpath on the client. On Windows, to add the derbyclient.jar file to your classpath, use the following command:

      set CLASSPATH=%CLASSPATH%;%DERBY_INSTALL%\lib\derbyclient.jar;

      @@ -427,7 +480,7 @@
       
       
      - +

      Data Source properties

       
      The following data source properties are available on the ClientDataSource, @@ -436,7 +489,7 @@
      
       
      
      -
      +
      @@ -508,7 +561,7 @@
       
       
      - +

      Tracing

       
      The Derby network client provides a tracing facility to collect JDBC trace @@ -521,7 +574,7 @@
       
       
       
      - +

      ClientDataSource Tracing

       
      Three methods can be used to collect tracing data if obtaining connections @@ -533,7 +586,7 @@
    • Use the setTraceDirectory(String dirname) method of ClientDataSource to trace each connection flow in its own file for programs that have multiple connections.
    • 
      -
      +
       

      DriverManager Tracing

       
      If the DriverManager is used to obtain connections, two ways are available to @@ -544,7 +597,7 @@
    • Use the URL attributes traceFile or traceDirectory to set these properties prior to creating the connection with the DriverManager.getConnection() method.
    • 
      -
      +
       

      ClientDataSource Tracing Examples

       
      Shown below are examples of each tracing type for the ClientDataSource @@ -775,7 +828,7 @@
       
       
      - +

      DriverManager Tracing Examples

       
      Shown below is an example of enabling tracing when obtaining connections @@ -881,7 +934,7 @@
       
       
      - +

      Changing the Default Trace Level

       
      The trace level defaults to ClientDataSource.TRACE_ALL. The tracing can be @@ -899,7 +952,7 @@
       
      This table lists the available tracing levels and values.
      -
      Standard JDBC Data Source Properties
      +
      @@ -958,7 +1011,7 @@
       
       
      - +

      Security

       
      Derby network client allows you to select a security mechanism by specifying @@ -976,7 +1029,7 @@ The default user, if none is specified is APP.
      
      -
      Trace LevelValue
      +
      @@ -1003,7 +1056,7 @@
       
       
      - +

      Packaging, Distribution and Versioning

       
      The Derby network client will assume the version of the Derby release in @@ -1017,7 +1070,7 @@
       
       
      - +

      Comparision and/or differences with the Derby Embedded Driver

       
      The following known differences exist between the embedded driver and the @@ -1041,7 +1094,7 @@
       
       
      - +

      Effects to existing documentation

       
      The following Derby Manuals should be updated to include the new client @@ -1051,7 +1104,7 @@ new driver except for the items listed below.
      
      -
      Security mechanisms supported by the Derby network client
      +
      @@ -1066,7 +1119,7 @@
      URL
      
       
      
      -
      +
      @@ -1090,7 +1143,7 @@
      Driver and DataSource Names
      
       
      
      -
      +
      @@ -1119,16 +1172,16 @@
       
       
      - +

      Miscellaneous

      
      -
      +

      Tools

       
      ij will recognize the new URL and load the driver automatically. dblook will accept the client URL. sysinfo has been changed to locate the new jar file.
      - +

      Testing

       
      You can run the client regression tests by running the suite @@ -1148,21 +1201,30 @@
      +
       
      Send feedback about the website to: derby-user@db.apache.org
      + Modified: db/derby/site/trunk/build/site/papers/DerbyTut/embedded.png URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyTut/embedded.png?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== Binary files - no diff available. Modified: db/derby/site/trunk/build/site/papers/DerbyTut/embedded_intro.html URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyTut/embedded_intro.html?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== --- db/derby/site/trunk/build/site/papers/DerbyTut/embedded_intro.html (original) +++ db/derby/site/trunk/build/site/papers/DerbyTut/embedded_intro.html Fri Dec 21 14:30:38 2007 @@ -1,9 +1,9 @@ - + - +Step 3: Embedded Derby @@ -16,49 +16,88 @@
      +
      +
      +
      - +  
      + +
      + +
      +
      + +
      -
      -Font size: +
      Font size:       @@ -569,21 +622,30 @@
      +
       
      Send feedback about the website to: derby-user@db.apache.org
      +
      Modified: db/derby/site/trunk/build/site/papers/DerbyTut/embedded_server.png URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyTut/embedded_server.png?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== Binary files - no diff available. Modified: db/derby/site/trunk/build/site/papers/DerbyTut/ij_intro.html URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyTut/ij_intro.html?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== --- db/derby/site/trunk/build/site/papers/DerbyTut/ij_intro.html (original) +++ db/derby/site/trunk/build/site/papers/DerbyTut/ij_intro.html Fri Dec 21 14:30:38 2007 @@ -1,9 +1,9 @@ - + - +Step 2: ij Basics @@ -16,49 +16,88 @@
      +
      +
      +
      - +  
      + +
      + +
      +
      + +
      -
      -Font size: +
      Font size:       @@ -534,21 +587,30 @@
      +
       
      Send feedback about the website to: derby-user@db.apache.org
      +
      Modified: db/derby/site/trunk/build/site/papers/DerbyTut/index.html URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyTut/index.html?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== --- db/derby/site/trunk/build/site/papers/DerbyTut/index.html (original) +++ db/derby/site/trunk/build/site/papers/DerbyTut/index.html Fri Dec 21 14:30:38 2007 @@ -1,9 +1,9 @@ - + - +Apache Derby Tutorial @@ -16,49 +16,88 @@
      +
      +
      +
      - +  
      + +
      + +

      Built with Apache Forrest - logo
      +
      + +
      -
      -Font size: +
      Font size:       @@ -480,17 +533,23 @@

      +
       
      Valid HTML 4.01!Valid CSS!
      @@ -498,6 +557,9 @@ Send feedback about the website to: derby-user@db.apache.org
      + Modified: db/derby/site/trunk/build/site/papers/DerbyTut/install_software.html URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyTut/install_software.html?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== --- db/derby/site/trunk/build/site/papers/DerbyTut/install_software.html (original) +++ db/derby/site/trunk/build/site/papers/DerbyTut/install_software.html Fri Dec 21 14:30:38 2007 @@ -1,9 +1,9 @@ - + - +Step 1: Install Software @@ -16,49 +16,88 @@
      +
      +
      +
      - +  
      + +
      + +
      +
      + +
      -
      -Font size: +
      Font size:       @@ -590,21 +643,30 @@
      +
       
      Send feedback about the website to: derby-user@db.apache.org
      +
      Modified: db/derby/site/trunk/build/site/papers/DerbyTut/network_server.png URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyTut/network_server.png?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== Binary files - no diff available. Modified: db/derby/site/trunk/build/site/papers/DerbyTut/ns_intro.html URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyTut/ns_intro.html?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== --- db/derby/site/trunk/build/site/papers/DerbyTut/ns_intro.html (original) +++ db/derby/site/trunk/build/site/papers/DerbyTut/ns_intro.html Fri Dec 21 14:30:38 2007 @@ -1,9 +1,9 @@ - + - +Step 4: Derby Network Server @@ -16,49 +16,88 @@
      +
      +
      +
      - +  
      + +
      + +
      +
      + +
      -
      -Font size: +
      Font size:       @@ -754,21 +807,30 @@
      +
       
      Send feedback about the website to: derby-user@db.apache.org
      +
      Modified: db/derby/site/trunk/build/site/papers/Intersect-design.html URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/Intersect-design.html?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== --- db/derby/site/trunk/build/site/papers/Intersect-design.html (original) +++ db/derby/site/trunk/build/site/papers/Intersect-design.html Fri Dec 21 14:30:38 2007 @@ -1,9 +1,9 @@ - + - + @@ -18,49 +18,88 @@
      +
      +
      +
      - +  
      + +
      + +
      +
      + +
      -
      -Font size: +
      Font size:       @@ -283,7 +336,9 @@
      - +
      +
      +

      Introduction

      Intersect & Except Design
      Jack Klebanoff
      Feb. 22 2005
      @@ -306,11 +361,11 @@ the parser.

      - +

      Execution

      If the left and right inputs have N and M rows respectively the sorts take time O(N*log(N) + M*log(M)). The final scan takes time O(N + M). So the time for the whole operation is O(N*log(N) + M*log(M)).

      - +

      Alternative Execution Plans

      Other implementations are possible.

        @@ -321,7 +376,7 @@

        The current implementation was chosen because it always provides at least decent speed and memory utilization, and in many, though certainly not all cases, it is the best implementation.

        We could have provided several implementations and let the optimizer choose the best, but this does not seem worthwhile for operations that are seldom used.

      - +

      Binding, Optimization, and Code Generation

      The INTERSECT and EXCEPT operators are bound much like the UNION operator. The bind methods are all found in super class SetOperatorNode, which is shared with UnionNode.

      @@ -329,7 +384,7 @@

      The architecture of the Derby optimizer makes it difficult to do further optimizations. SelectNode processing requires that order by lists be pushed down to them at the start of preprocessing. If an input to INTERSECT or EXCEPT is a SELECT (a common case) then IntersectOrExceptNode has to decide whether it needs its inputs ordered before it calls the preprocess method of its inputs. That means that it must chose its execution plan at the start of the optimization process, not as the result of the optimization process.

      Code generation is straighforward. It generates code that invokes the ResultSetFactory.getSetOpResultSet method.

      - +

      Parser

      The UNION and EXCEPT operators have the same precedence. The INTERSECT operator has higher precedence, so

      @@ -391,21 +446,30 @@

      [Back to Derby Papers]

      +
       
      Send feedback about the website to: derby-user@db.apache.org
      + Modified: db/derby/site/trunk/build/site/papers/JDBCImplementation.html URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/JDBCImplementation.html?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== --- db/derby/site/trunk/build/site/papers/JDBCImplementation.html (original) +++ db/derby/site/trunk/build/site/papers/JDBCImplementation.html Fri Dec 21 14:30:38 2007 @@ -1,9 +1,9 @@ - + - + @@ -23,49 +23,88 @@
      +
      +
      +
      - +  
      + +
      + +
      +
      + +
      -
      -Font size: +
      Font size:       @@ -801,21 +854,30 @@

      +
       
      Send feedback about the website to: derby-user@db.apache.org
      + Modified: db/derby/site/trunk/build/site/papers/MiscPresentations.html URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/MiscPresentations.html?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== --- db/derby/site/trunk/build/site/papers/MiscPresentations.html (original) +++ db/derby/site/trunk/build/site/papers/MiscPresentations.html Fri Dec 21 14:30:38 2007 @@ -1,9 +1,9 @@ - + - +Miscellaneous Derby Presentations @@ -16,49 +16,88 @@
      +
      +
      +
      - +  
      + +
      + +
      +
      + +
      -
      -Font size: +
      Font size:       @@ -315,21 +368,30 @@
      +
       
      Send feedback about the website to: derby-user@db.apache.org
      +
      Modified: db/derby/site/trunk/build/site/papers/alloc-page.png URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/alloc-page.png?rev=606336&r1=606335&r2=606336&view=diff ============================================================================== Binary files - no diff available.
      Miscellaneous Changes