Page 1 of 1

full-text searches

Posted: Tue Mar 17, 1998 3:12 pm
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 )




full-text searches

Posted: Tue Mar 17, 1998 4:03 pm
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.




full-text searches

Posted: Tue Mar 17, 1998 4:12 pm
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





full-text searches

Posted: Tue Mar 17, 1998 4:33 pm
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?



full-text searches

Posted: Wed Mar 18, 1998 11:36 am
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.