Conference orarep::nomahs::rdb_60

~~                  <<< Note 4995.0 by ORAREP::JRFVAX::HODGES >>>
~~                      -< Ranked Sorted Index is what??? >-

~~    	What does "rank" mean in the context of a sorted index?  I've looked
~~    in multiple V7 manuals and haven't really found a definition!

This is how I understand it :)

Ranked and pseudo-ranked are different methods of maintaining row 
cardinality in the index.  Ranked indexes maintain precise cardinalities.  
Pseudo-ranked indexes maintain approximate cardinalities.  For the vast 
majority of cases, the cardinalities maintained by pseudo-ranking are 
sufficient enough to provide the optimizer with the additional information 
required to make more educated retrieval strategies.

    in particular, a ranked index contains cardinality information in each
    index node.  this allows for the optimizer to know 'more' about the
    expected row count(s) as it traverses down the index (the closer to the
    leaf nodes, the more relevant the information becomes).  rdb's use of
    'pseduo' means that the cardinality information within the nodes of the
    index isn't exact; it is just 'close'; similar to how table
    cardinalities in rdb are not 100% accurate, just close.

    Thanks!!!  My guesses were WAY off base!  So I'm really glad I asked!
    
    Now, what about the Master Index to the doc set?
    
    B-)

~~                  <<< Note 4995.3 by ORAREP::JRFVAX::HODGES >>>
~~                   -< where's the rest of the story. . . .  >-

~~    Now, what about the Master Index to the doc set?
    
Have to leave that for the writers :)

    
    Perhaps the master index to the doc set is also pseudo ranked ;-)

	We decided not to produce a master index book for Rdb7, for two
	reasons:

	1) Producing a master index is labor intensive. We had to make the
	tradeoff between producing the index book and documenting new
	functionality. New functionality won.

	2) We provided the entire Rdb7 doc set in PDF (Adobe Acrobat)
	format, on the client CD-ROM. Included with this set of PDF books is
	a great index built with Adobe Acrobat Catalog. FOr those unfamiliar
	with the Acrobat Catalog product, it creates a master index for a
	set of books, and provides search capability based on single words,
	phrases, and all that good stuff that you can do with computers.

	The downside to the Acrobat Catalog master index is that you will
	need Adobe ACrobat Exchange to use it. Exchange costs money (not
	alot, but more than the free Acrobat Viewer), but if you are
	interested in using the master index capability, this is the product
	to use. This is one way in which we're trying to provide more "value
	added" in our online documentation.

	Roy

    Now if only I could plug that CD into the coffee maker in my hotel
    room, I could use the Master Index.
    
    Thanks for the explanation, anyway.

    Ah, then you need a laptop PC with a CDROM drive.
    
    I saw an article somewhere about the "return of the luggable", now that
    a useable "laptop" has to have so much stuff with it.

    
    re: .6
    
    	; We provided the entire Rdb7 doc set in PDF...
    
    What is the part number of that CD ?  That wasn't true on A48650.
    
    	; ...you will need need Adobe ACrobat Exchange to use it...
    
    Does that come as part of Adobe Acrobat professional, or what ?
    
    Regards,
    rcs
    	
    

    
>    	; We provided the entire Rdb7 doc set in PDF...
>    
>    What is the part number of that CD ?  That wasn't true on A48650.

mine says Oracle RDB7 Client for WIN3.1/WIN NT/WIN95....

A48650-1 on the CD.

>    	; ...you will need need Adobe ACrobat Exchange to use it...
>    
>    Does that come as part of Adobe Acrobat professional, or what ?

The CD contains Acrobat something or another you can pull off.
    	
    

    
    	A48650-1 does NOT include the complete Rdb documentation set,
    	just major parts of it (which is welcomed with open arms, I
    	was just wondering if the rest of it was available yet).  You
    	can however install a complete Oracle7 7.3 doc set from the
    	Rdb client CD ;-)
    
    	Will Rdb get a "bookshelf" type index in a future release
    	like we provide for the Oracle7 doc set on the same CD ?
    	It is not a master index, but it is an improvement over
    	nothing.
    
    	What about bundleing a personal Alta Vista for use with the
    	Rdb doc set (which is how I was hoping to get around this
    	when I get the time) ?
    
    	Regards,
    	rcs
    

    
    What Rdb books are missing?  We didn't ship the Release
    Notes (for Rdb and SQL/Services) and the Before You Install letter, but
    I thought we shipped the rest of the docs in a self-extracting archive file.
    
    Let me know what docs are missing.
    
    
    
    Helen
    
    

    
    	The CD does not include the SQL Reference Manual, Volume 2
    	(A42813-1) and Volume 3 (A42812-1).  Since other multivolume
    	documents like the Performance and Tuning Guide were
    	combined into one volume for the PDF version, I assume this
    	was an oversight and the wrong file got put on the CD
    	because what made it on to the client CD (A48650-1) was
    	only the first part.  Pointers to the complete set of
    	SQL Reference Manuals in PDF would be appreciated. 
    
    	One nit about the printed SQL manuals while I'm at it:
    	the spine of the SQL Reference Manual, Volume 1 doesn't
    	say "SQL" in it, although the cover does.  It simply
    	says "Oracle Rdb7 Reference Manual Volume 1."
    
    	When it comes to what is BETWEEN the covers though 
    	(which is what is really important) it seems to be our 
    	usual, world-class documentation that customers use to 
    	judge the rest of the industry (and Oracle) ;-)
    
    	Regards,
    	rcs
    

    
>    	The CD does not include the SQL Reference Manual, Volume 2
>    	(A42813-1) and Volume 3 (A42812-1).  Since other multivolume

mine does. all three in the same file.

    
    	Whoops !  My mistake !  Helen just pointed out to me offline
    	that Volume 2 starts on page 513 and Volume 3 on page 1109.
    	I guess I was so used to using the Performance manual that
    	was clearly labelled volumes 1 AND 2 that I didn't look
    	hard enough... not to mention why I couldn't get the index
    	to work right ;-)
    
    	Apologies to Helen, Jay, etal.  Please increment your
    	BREWS_OWED counter with my thanks...
    
    	Regards,
    	rcs