HTS Resources Patent Informatics

	PatGenDB PatGenDB BLAST Instrumentation Services Home Contact					PatGenDB Search Engine This is a MySQL front end to the PatGenDB database. You need to be familiar with SQL to run it but its pretty easy. Listed below are some common searches. If you need any help with running this system (or if there are problems), feel free to contact info@htsresources.com. Attention: PatGenDB needs a home. Disc space if full and too busy right now to accomidate the problem. The scripts used for updating the DB have been set up to run pretty automated. Its a good way to learn techniques to process patent information so that you can bypass using expensive database providers. PatGenDB Table Schema This lists the tables in the database. Click on a table to identify its field structure. aa aaseq bibops na naseq Enter Search (or Searches) Reference on MySQL full text searching Basic Select Syntax SELECT patent from bibops where titleti like '%retrovirus%' limit 0,5; Natural Language SELECT opsid, patent, titleti FROM bibops WHERE MATCH (abstract) AGAINST ('glycoprotein virus attachment') limit 0,100; Boolean SELECT opsid, patent, titleti FROM bibops WHERE MATCH (abstract) AGAINST ('glycoprotein +virus +attachment' IN BOOLEAN MODE) limit 0,5; Scoring SELECT opsid, patent, titleti, MATCH (abstract) AGAINST ('glycoprotein virus attachment') AS score FROM bibops WHERE MATCH (abstract) AGAINST ('glycoprotein virus attachment') limit 100,100; HTS Resources, LLC 325 W. Washington St #2-150, San Diego, CA 92103 USA