Leo Zhang
Back to Projects

Patent Search System

Chunxiao Technology · 2014

Role: Full-stack Developer

Cover

Cover

Enterprise patent document management: .NET Framework 2.0 Windows desktop app with Lucene.NET 2.9 full-text search. 10,000+ patent records, Excel batch processing, sub-2s search response for 50+ daily research users.

10,000+ patents managed, <2s search response, 50+ daily users

Problem

Research teams need efficient patent document management with fast full-text search across large collections.

Solution

.NET desktop application: Windows Forms UI, SQL Server 2008 backend, Lucene.NET 2.9 for full-text search, EPPlus for Excel batch import/export, ADO.NET 2.0 data access with connection pooling.

Key Highlights

  • Built enterprise desktop app on .NET Framework 2.0 with C# 3.0
  • Integrated Lucene.NET 2.9 for sub-2s full-text search
  • Excel batch import/export with data validation
  • Multi-criteria advanced search with date range, inventor, category filters

Tech Stack

C#.NET Framework 2.0Windows FormsSQL Server 2008Lucene.NET 2.9EPPlusADO.NETSQLite

What I Learned

Full-text search engines like Lucene dramatically improve document retrieval; Excel batch processing is essential for enterprise data workflows; proper indexing strategy matters for growing datasets.