Efficient text searching in PATSTAT Online

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

EPO / PATSTAT Support
Posts: 124
Joined: Thu Feb 22, 2007 5:33 pm

Efficient text searching in PATSTAT Online

Post by EPO / PATSTAT Support » Wed Jul 10, 2019 3:04 pm

Since the latest version PATSTAT Online allows text searching with the T-SQL features CONTAINS and FREETEXT. A keyword search in the title or the abstract now takes only seconds instead of (many) minutes.

More details can be found in section 6.3.2 of the "PATSTAT Online user manual" in the documentation tab of www.epo.org/patstat or in the attached short introduction:
Attachments
EfficientTextSearch_PatstatOnline.pdf
(240.92 KiB) Downloaded 1 time
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply