data mining

Building a USPTO MySQL Database from Scratch

Patent applications and grants are all public domain and searchable using a variety of sources (Google Patent Search, USPTO, NBER, & several proprietary sites). The problem with these sources is that they are unusable for conducting detailed patent research. Although they can help you find and read patents, and offer full-text and abstract search, they cannot compile patent statistics, or calculate indicators. It’s even impossible to generate and export a list of patent numbers based on your search criteria. In order to calculate these types of data required for meaningful research and patent management, a complete database is needed in an SQL server (MS-SQL server or MySQL for example). And while the USPTO data is available for download in a few formats, it’s no small task to download these files, parse them according to their changing format and then assemble a database. Luckily, someone has done the saintly task of…

Read more