full-text searches

Post Reply
User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

full-text searches

Post by Thunderstone »



I downloaded Webinator just to poke in a database to see what
it can do (using gw -st "....."). I am especially interested to
see what it does with full text.

"Full text" is what others might call a "memo" field or a "blob" -
something which may well contain many thousands of words.

I noticed, tho', that the "Body" column of the "html" table is
a "varchar" type. Is the varchar type typically used for full text
in a Texis db? If not, how may I do - or see - demos of full text
searches?


Secondly: does the Texis User's Guide come in a printed form or, say,
PDF format?

-John Koch - - - __o
Knowledge Systems, Inc. - - - - _ \<,_
<John.ksi@webplus.net> - - (_)/ (_)
(A NET-FRIENDLY SIG. http://www.ncsa.uiuc.edu/Edu/ICG/pt1.ch2.Etiquette.html )



User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

full-text searches

Post by Thunderstone »



John.ksi@webplus.net said:

The varchar type is used for full-text in Texis. Texis was designed from
the outset to handle full-text, and the addition of a separate type just
for full-text would only serve to complicate matters.


The Texis User's Guide does come in printed form when you purchase the
Texis product.



User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

full-text searches

Post by Thunderstone »




Full text indexes may be created on fields within Texis that are
of the data-types CHAR, BYTE, VARCHAR, VARBYTE, or INDIRECT. Any
VARxxxx datatype field may contain up to 1 Gig per record, so
in that sense they are similar to "blob" fields. They are dissimilar
in the sense that we can always do relational operations against them
and most other RDBMS's have severe restrictions on the operations that
may be performed against a BLOB.

The INDIRECT data type within Texis allows you to treat the contents of
a file as if it were an actual field. These are typically used to hold
big documents or multimedia data.


See all the demonstrations at our site. Also have a look at WWW.ZDNET.COM
WWW.DBMSMAG.COM and WWW.UPSIDE.COM. These sites use Texis for both content
delivery, relational data management, and (of course) searching.


Nope. We dont make that manual available in send printable form for
a variety of reasons, but we'll send you a copy for $55.

Thanks,
Thunderstone




User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

full-text searches

Post by Thunderstone »





What I'd like to be able to do is load many urls into a database and then
index the text from those web sites.

Then, when someone does a search, the results would appear and, instead of
directing the user to web site where the information resides, it would
direct them to our own web site's summary about the company.

Will webinator perform this capability?


User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

full-text searches

Post by Thunderstone »




That is what Webinator does.


It might be able to if you can directly generate the url for your summary
page based on the url of the site. Doing more intricate relations among
data tables not in the standard webinator schema would require a full texis
(T1000) license.


Post Reply