Sample Database

Texis comes with a small sample solar power patent database in /usr/local/morph3/texis/testdb. The patent table contains the fields:

id:

A unique record id.

pdate:

The date of the patent.

pcountry:

The country of origin of the patent.

pnumber:

The patent number.

pabstract:

The patent text abstract.

Try it out by issuing the following command from the shell prompt:

   tsql -d /usr/local/morph3/texis/testdb

   select * from patent where pabstract like 'magnetic ~coil';

You will get one result row (or ``hit''). There are 86 records in the patent table. See Chapters and for more query syntax.