Java Doc for JoinInnerCursor.java in  » Database-DBMS » Quadcap-Embeddable-Database » com » quadcap » sql » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation
1. 6.0 JDK Core
2. 6.0 JDK Modules
3. 6.0 JDK Modules com.sun
4. 6.0 JDK Modules com.sun.java
5. 6.0 JDK Modules sun
6. 6.0 JDK Platform
7. Ajax
8. Apache Harmony Java SE
9. Aspect oriented
10. Authentication Authorization
11. Blogger System
12. Build
13. Byte Code
14. Cache
15. Chart
16. Chat
17. Code Analyzer
18. Collaboration
19. Content Management System
20. Database Client
21. Database DBMS
22. Database JDBC Connection Pool
23. Database ORM
24. Development
25. EJB Server geronimo
26. EJB Server GlassFish
27. EJB Server JBoss 4.2.1
28. EJB Server resin 3.1.5
29. ERP CRM Financial
30. ESB
31. Forum
32. GIS
33. Graphic Library
34. Groupware
35. HTML Parser
36. IDE
37. IDE Eclipse
38. IDE Netbeans
39. Installer
40. Internationalization Localization
41. Inversion of Control
42. Issue Tracking
43. J2EE
44. JBoss
45. JMS
46. JMX
47. Library
48. Mail Clients
49. Net
50. Parser
51. PDF
52. Portal
53. Profiler
54. Project Management
55. Report
56. RSS RDF
57. Rule Engine
58. Science
59. Scripting
60. Search Engine
61. Security
62. Sevlet Container
63. Source Control
64. Swing Library
65. Template Engine
66. Test Coverage
67. Testing
68. UML
69. Web Crawler
70. Web Framework
71. Web Mail
72. Web Server
73. Web Services
74. Web Services apache cxf 2.0.1
75. Web Services AXIS2
76. Wiki Engine
77. Workflow Engines
78. XML
79. XML UI
Java
Java Tutorial
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Java Source Code / Java Documentation » Database DBMS » Quadcap Embeddable Database » com.quadcap.sql 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   com.quadcap.sql.TupleImpl
      com.quadcap.sql.CursorImpl
         com.quadcap.sql.JoinCursor
            com.quadcap.sql.JoinInnerCursor

JoinInnerCursor
public class JoinInnerCursor extends JoinCursor (Code)
Cursor implementing INNER JOIN using nested loops (optimized using the inner index)
author:
   Stan Bailes


Field Summary
 int[]caCols
     The join columns in the outer table.
 byte[]caKey
     The current join key.
 int[]caMap
    
 intcbCnt
     Cache number of columns in inner table.
 int[]cbCols
     The join columns in the inner table.
 IndexConstraintcbIndex
    
 BCursorcbKeys
    
 int[]cbMap
    
 TablecbTable
     If the inner is really a table, or null if it's a view.
 Comparatorcompare
     Used to compare the inner and outer join keys.
 Databasedb
    
 BlockFilefile
    
 Btreeindex
     Either the index from above, or a temporary one we create.
 MapRowmapRow
    
 booleanmustFreeRows
    
 BlockFiletempFile
    
 booleantempIndex
    

Constructor Summary
public  JoinInnerCursor(Session session, Cursor outer, Cursor ca, int[] caCols, Cursor cb, int[] cbCols, Expression where, Tuple tuple, JoinMapRow row, boolean left, boolean inner)
     Constructor takes a whole shitload of parameters.

Method Summary
protected  voidbfirst()
    
final protected  booleanbnext()
    
public  voidclose()
    
final  IndexConstraintfindIndex(Cursor r, int[] cols)
    
public  voidfreeRows(Btree index, BlockFile file)
    
final static  BitSetintArrayToBitSet(int[] a)
    
final  BtreemakeInnerIndex()
    
final  byte[]makeInnerKey(Cursor cursor, Row row, long rowId)
    
final  byte[]makeOuterKey(Cursor cursor, Row row)
    
final  voidmakeTemporaryIndexForTable()
    
final  voidmakeTemporaryIndexForView()
    

Field Detail
caCols
int[] caCols(Code)
The join columns in the outer table.



caKey
byte[] caKey(Code)
The current join key.



caMap
int[] caMap(Code)
Map outer columns from join cursor to outer cursor pos



cbCnt
int cbCnt(Code)
Cache number of columns in inner table.



cbCols
int[] cbCols(Code)
The join columns in the inner table.



cbIndex
IndexConstraint cbIndex(Code)
If there's an index on the join columns of the inner table



cbKeys
BCursor cbKeys(Code)



cbMap
int[] cbMap(Code)
Map inner, non-join-key columns from join cursor to inner cursor pos



cbTable
Table cbTable(Code)
If the inner is really a table, or null if it's a view.



compare
Comparator compare(Code)
Used to compare the inner and outer join keys.



db
Database db(Code)



file
BlockFile file(Code)



index
Btree index(Code)
Either the index from above, or a temporary one we create.



mapRow
MapRow mapRow(Code)
Temporary used to build keys for inner table index



mustFreeRows
boolean mustFreeRows(Code)
Did we make create new (temporary) rows for the inner index?



tempFile
BlockFile tempFile(Code)



tempIndex
boolean tempIndex(Code)
Did we make 'index', or were the columns already indexed?




Constructor Detail
JoinInnerCursor
public JoinInnerCursor(Session session, Cursor outer, Cursor ca, int[] caCols, Cursor cb, int[] cbCols, Expression where, Tuple tuple, JoinMapRow row, boolean left, boolean inner) throws SQLException(Code)
Constructor takes a whole shitload of parameters.
Parameters:
  session - my execution session context (transaction, etc)
Parameters:
  ca - the outer join cursor
Parameters:
  caCols - the join columns in the outer cursor
Parameters:
  cb - the inner join cursor
Parameters:
  cbCols - the join columns in the inner cursor
Parameters:
  where - the ON/WHERE predicate expression
Parameters:
  tuple - the format we're supposed to return
Parameters:
  row - A mapping between the inner/outer rows and the join row
Parameters:
  left - Include non-matching outer rows with nulls for inner
Parameters:
  inner - Include matching rows
Parameters:
  flip - Left is Right, Right is Left




Method Detail
bfirst
protected void bfirst() throws SQLException(Code)



bnext
final protected boolean bnext() throws SQLException(Code)



close
public void close() throws SQLException(Code)



findIndex
final IndexConstraint findIndex(Cursor r, int[] cols) throws SQLException(Code)



freeRows
public void freeRows(Btree index, BlockFile file) throws IOException(Code)



intArrayToBitSet
final static BitSet intArrayToBitSet(int[] a)(Code)



makeInnerIndex
final Btree makeInnerIndex() throws IOException, SQLException(Code)



makeInnerKey
final byte[] makeInnerKey(Cursor cursor, Row row, long rowId) throws IOException, SQLException(Code)



makeOuterKey
final byte[] makeOuterKey(Cursor cursor, Row row) throws IOException, SQLException(Code)



makeTemporaryIndexForTable
final void makeTemporaryIndexForTable() throws IOException, SQLException(Code)



makeTemporaryIndexForView
final void makeTemporaryIndexForView() throws IOException, SQLException(Code)



Fields inherited from com.quadcap.sql.JoinCursor
Expression aWhere(Code)(Java Doc)
Cursor ca(Code)(Java Doc)
Cursor cb(Code)(Java Doc)
boolean inner(Code)(Java Doc)
boolean left(Code)(Java Doc)
Row ra(Code)(Java Doc)
Row rb(Code)(Java Doc)
JoinMapRow row(Code)(Java Doc)
Expression where(Code)(Java Doc)

Methods inherited from com.quadcap.sql.JoinCursor
public void afterLast() throws SQLException(Code)(Java Doc)
protected boolean anext() throws SQLException(Code)(Java Doc)
public void beforeFirst() throws SQLException(Code)(Java Doc)
protected void bfirst() throws SQLException(Code)(Java Doc)
protected boolean bnext() throws SQLException(Code)(Java Doc)
public void close() throws SQLException(Code)(Java Doc)
public void deleteRow() throws SQLException(Code)(Java Doc)
public Row getRow()(Code)(Java Doc)
public boolean isWritable(int column)(Code)(Java Doc)
public boolean next() throws SQLException(Code)(Java Doc)
final boolean passRow(Cursor c, Expression w) throws SQLException(Code)(Java Doc)
public long size() throws SQLException(Code)(Java Doc)
public void updateRow(Row row) throws SQLException(Code)(Java Doc)

Fields inherited from com.quadcap.sql.CursorImpl
protected Cursor outer(Code)(Java Doc)
protected Session session(Code)(Java Doc)

Methods inherited from com.quadcap.sql.CursorImpl
public boolean absolute(int row) throws SQLException(Code)(Java Doc)
abstract public void afterLast() throws SQLException(Code)(Java Doc)
abstract public void beforeFirst() throws SQLException(Code)(Java Doc)
abstract public void close() throws SQLException(Code)(Java Doc)
abstract public void deleteRow() throws SQLException(Code)(Java Doc)
static void dumpCursor(String label, Cursor c) throws SQLException(Code)(Java Doc)
public void finalize() throws Throwable(Code)(Java Doc)
public Column getColumn(String columnName) throws SQLException(Code)(Java Doc)
public Cursor getOuterCursor()(Code)(Java Doc)
abstract public Row getRow() throws SQLException(Code)(Java Doc)
public long getRowId()(Code)(Java Doc)
public Session getSession()(Code)(Java Doc)
public Table getTable()(Code)(Java Doc)
public void insertRow(Row row) throws SQLException(Code)(Java Doc)
abstract public boolean isWritable(int column) throws SQLException(Code)(Java Doc)
abstract public boolean next() throws SQLException(Code)(Java Doc)
public boolean prev() throws SQLException(Code)(Java Doc)
public void reset(Expression expr, Cursor outer) throws SQLException(Code)(Java Doc)
public void setOuterCursor(Cursor c)(Code)(Java Doc)
public String toString()(Code)(Java Doc)
abstract public void updateRow(Row row) throws SQLException(Code)(Java Doc)

Fields inherited from com.quadcap.sql.TupleImpl
protected Vector columns(Code)(Java Doc)
protected HashMap names(Code)(Java Doc)
protected String qual(Code)(Java Doc)
protected String qualifier(Code)(Java Doc)

Methods inherited from com.quadcap.sql.TupleImpl
public void addColumn(Column col) throws SQLException(Code)(Java Doc)
public void addColumn(Column col, int pos) throws SQLException(Code)(Java Doc)
public void addColumn(String name, Type type) throws SQLException(Code)(Java Doc)
public void addColumns(Session session, Tuple t) throws SQLException(Code)(Java Doc)
public void addColumns(Session session, Tuple t, boolean resolve) throws SQLException(Code)(Java Doc)
public void deleteColumn(int col) throws SQLException, IOException(Code)(Java Doc)
public Column getColumn(int i) throws SQLException(Code)(Java Doc)
public Column getColumn(String name) throws SQLException(Code)(Java Doc)
public int getColumnCount() throws SQLException(Code)(Java Doc)
public int getColumnIndex(String name) throws SQLException(Code)(Java Doc)
public String getName()(Code)(Java Doc)
public int[] mapColumns(Vector names) throws SQLException(Code)(Java Doc)
static int nextUnquotedPeriod(String s)(Code)(Java Doc)
public void readExternal(ObjectInput in) throws IOException, ClassNotFoundException(Code)(Java Doc)
public void resolveColumns() throws SQLException(Code)(Java Doc)
public void setName(String name)(Code)(Java Doc)
public String toString()(Code)(Java Doc)
public void writeExternal(ObjectOutput out) throws IOException(Code)(Java Doc)

Methods inherited from java.lang.Object
native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc)
public boolean equals(Object obj)(Code)(Java Doc)
protected void finalize() throws Throwable(Code)(Java Doc)
final native public Class getClass()(Code)(Java Doc)
native public int hashCode()(Code)(Java Doc)
final native public void notify()(Code)(Java Doc)
final native public void notifyAll()(Code)(Java Doc)
public String toString()(Code)(Java Doc)
final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc)
final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc)
final public void wait() throws InterruptedException(Code)(Java Doc)

www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.