Method and system for searching binary files
View Patent ↗In the past, it has not been possible to perform searches within documents stored in a proprietary, binary format, such as Microsoft Word documents and Adobe Acrobat documents. The present invention solves the problem by storing the binary file as a field in a record of the database. Then, the binary file is translated into a text format, which is searchable within the database. Thereafter, a user of the database is able to search within binary files by performing a search of the translated file.
1. A method for facilitating a search of a database for binary content corresponding to a text string, said method comprising:
creating a record in said database;
storing said binary content within a binary large object field of said record, wherein said binary content does not contain searchable text and, wherein said binary content was created from text saved to a file of at least one of: a word processing program, a spreadsheet program, a presentation program, and a document layout program;
converting each binary set of said binary content directly into each corresponding ASCII value to form text content;
storing said text content within a character large object field of said record;
searching for said text string within said character large object field; and,
downloading, from said database, said binary content to a computer based on said searching step.
2. The method of claim 1 , wherein said converting step comprises:
determining a file format of said binary content; and,
converting said binary content to said text content based on said file format.
3. The method of claim 1 , wherein said converting step comprises:
determining a file format of said binary content; and,
converting said binary content to said text content based on said file format by applying an algorithm according to said file format.
4. The method of claim 1 , wherein said searching step comprises:
receiving search criteria, wherein said search criteria comprises said text string;
constructing a query based on said search criteria;
executing said query to locate data within said character large object field;
matching said search criteria to produce search results; and,
retrieving said binary content from said binary large object field corresponding to said character large object field based on said search results.
5. The method of claim 4 , further comprising parsing said binary content according to said search criteria.
6. The method of claim 1 , wherein said searching step comprises searching for said text string via a browser application.
7. The method of claim 1 , wherein said downloading step comprises:
saving said binary content to a file; and,
providing a hyperlink to said file.
8. The method of claim 1 , wherein said downloading step comprises downloading said binary content to said computer which is remote from said database.