Abstract:
Full text index-ability, indexing, and container extraction status of files in a collection repository is displayed to a user in connection with content management in EDiscovery. Thus, the user knows which files failed to index and explode and which files that are not indexable. The user also knows which files have not been indexed yet, so they are not omitted from an analysis. Accordingly, users can start working on collected files without waiting for the maximum possible indexing period. Further, users can start working immediately on the collected content, thus avoiding slowing down the work during frequent updates to the content repository. Only indexing and extraction status information that is relevant to the search query is displayed, thus minimizing the time needed to analyze the files that are not indexed or not exploded manually. Automatic and manual update of a list of un-indexable file types is provided, based on historical information collected during collection repository operation, thus enhancing the user experience with time and adapting the EMA to new file types. Further, both the person who performed the collection and the person who manages the EDiscovery effort are kept informed about the processing status of the collection by sending notifications, displaying alerts, and by providing appropriate views.

Description:
BACKGROUND OF THE INVENTION 
       [0001]    1. Technical Field 
         [0002]    The invention relates to electronic data discovery. More particularly, the invention relates to software technology for evaluation of the processing, i.e. full text indexing and archive extraction status of digital content collected for electronic data discovery purposes. Still more particularly, the invention relates to a method and apparatus for providing collection transparency information to an end user to achieve a guaranteed quality document search and production in electronic data. 
         [0003]    2. Description of the Prior Art 
         [0004]    Electronic discovery, also referred to as e-discovery or EDiscovery, concerns discovery in civil litigation, as well as Tax, Government Investigation, and Criminal Proceedings which deals with information in electronic form. In this context, electronic form is the representation of information as binary numbers. Electronic information is different from paper information because of its intangible form, volume, transience, and persistence. Such information is typically stored in a content repository. Also, electronic information is usually accompanied by metadata, which is rarely present in paper information. Electronic discovery poses new challenges and opportunities for attorneys, their clients, technical advisors, and the courts, as electronic information is collected, reviewed, and produced. Electronic discovery is the subject of amendments to the Federal Rules of Civil Procedure which are effective Dec. 1, 2006. In particular Rules 16 and 26 are of interest to electronic discovery. 
         [0005]    Examples of the types of data included in e-discovery include e-mail, instant messaging chats, Microsoft Office files, accounting databases, CAD/CAM files, Web sites, and any other electronically-stored information which could be relevant evidence in a law suit. Also included in e-discovery is raw data which forensic investigators can review for hidden evidence. The original file format is known as the native format. Litigators may review material from e-discovery in one of several formats: printed paper, native file, or as TIFF images. 
         [0000]    Content Repository Uncertainty with File Indexing Status 
         [0006]    A typical content repository, i.e. content storage, has certain problems that impair search results and that may cause problems in EDiscovery 
         [0000]    Uncertainty with File Indexing Status 
         [0007]    Usually, indexing status of a content repository is estimated in the following ways:
       Optimistic—The system ignores the fact that some files may not be available in the search results. Even high-end content management systems, such as Documentum (see, for example, http://software.emc.com/), use this approach.   Pessimistic—The content is considered non-indexed and the system does not allow user to search it until a certain long period of time passes after content insertion or update to make sure there is enough time for indexing engine to index the content.       
 
         [0010]    Some systems try to go beyond these two approaches by warning the user what files are still in the indexing queue. 
         [0011]    The optimistic approach is entirely unsafe when it comes to importing or indexing very large files. For example, in Oracle 9i it takes up to several minutes to index a very large document, and it takes several seconds to put large files into indexing queue. This makes the optimistic approach undesirable for EDiscovery. Failure to index files causes incorrect search results for both approaches. 
         [0012]    None of the applications on the market implement a comprehensive processing status information solution that combines index-ability, indexing status, and container extraction, e.g. opening of such files as zip files, status information. 
         [0013]    An EDiscovery Management Application (EMA) is a software program responsible for managing collections and holds, which communicates collection and hold requests to data sources, and which collects content from data sources and stores it in its content repository (see related U.S. patent application Ser. No. 11/963,383, filed on Dec. 21, 2007, Attorney Docket No. PSYS0001, the entirety of which is incorporated herein by this reference thereto). Some files collected into an EMA content repository during the EDiscovery process must undergo full text indexing to allow their contents to become searchable by the end user. However, the following limitations of a typical indexing process should be noted: 
         [0000]    AP: I changed the last sentence because otherwise it sounds like we are criticizing some approach, which we are going to reject. Whereas, these are natural limitation of every indexing process.
       It takes time to perform indexing. During this time files that have not been indexed yet cannot be found through a full-text search.   Indexing may fail for some files. As a result, the user may not be able to find these files through full text search.   Some files may not be indexable because they do not contain text information or because the indexing engine is unable to index these files.
 
Uncertainty with Container Extraction Status
       
 
         [0017]    Extracting files from container files, such as ZIP, CAB, WAR, RAR, EAR file archives, PST, NSF email archives, email message MSG files, and others, collected into an EMA content repository during the collection process creates even more uncertainty when it comes to understanding the processing status of files in the content repository. For example, the following limitations should be noted:
       First, it takes time for an EMA to explode the container, i.e. extract files from a container into the content repository. Until the container is exploded, the files cannot be found through any type of search because the content repository does not know about their existence.   Secondly, the extraction may fail for a multitude of reasons, such as an inability to extract files from a password protected or corrupt archive. A user should be able to distinguish between a container that does not contain files and that, therefore does not present any interest from an eDiscovery perspective, and a container that failed to explode but that may contain files that are of interest for eDiscovery.   Finally, files inside a container might become indexable only after they have been extracted from a container. This generates additional delay in file indexing and may result in a user being unable to perform a full text search against files uploaded inside the container.       
 
         [0021]    In EDiscovery, failing to find and produce files may result in substantial litigation risks and penalties. This is why it is very important to understand the indexing and extraction status of content collection in EDiscovery precisely. For example, the failure of a defendant to locate an email message that was saved by the plaintiff may be treated by the court as negligent misconduct or an attempt to hide evidence, and may result in heavy penalties. 
       Users Need to Access Processing Status Information in a User-Friendly Form 
       [0022]    Both file indexing and container extraction status information should be available to a user performing the file search to allow the user to understand the processing status of the collected content and make decisions on completeness of file search results. Also, because the overall size of the collection may be huge, processing status information must be tailored for the subset of data the user tries to query when a search is performed. Finally, the user should know which files may contain the information specified in the query criteria, although the collection repository cannot search these files; and there should be a way for a user to browse and view files that failed to index, not indexable, or have not been indexed yet and containers that failed to explode or have not been exploded yet manually by viewing the files. 
         [0023]    In this context, it would be advantageous to provide collection transparency information to an end user to achieve a guaranteed quality document search and production in electronic data. 
       SUMMARY OF THE INVENTION 
       [0024]    An embodiment of the invention displays full text index-ability, indexing, and container extraction status of files in a collection repository in connection with content management in EDiscovery. 
         [0025]    As opposed to the optimistic and pessimistic approaches the inventive technique disclosed herein guarantees that the user knows which files failed to index and explode and which files that are not indexable. 
         [0026]    As opposed to the optimistic approach, the invention provides a technique that tells the user which files have not been indexed yet, so they are not omitted from the analysis. 
         [0027]    As opposed to the pessimistic approach, the invention provides a technique that allows users to start working on the collected files without waiting for the maximum possible indexing period. Further, as opposed to the pessimistic approach, the invention provides a technique that allows users to start working immediately on the collected content, thus avoiding slowing down the work during frequent updates to the content repository. 
         [0028]    An embodiment of the invention allows for displaying indexing and extraction status information that is relevant only to the search query, thus minimizing the time needed to analyze the files that are not indexed or not exploded manually. 
         [0029]    An embodiment of the invention also allows for automatic and manual update of a list of un-indexable file types based on historical information collected during collection repository operation, thus enhancing the user experience with time and adapting the EMA to new file types. 
         [0030]    Finally, an embodiment of the invention allows for keeping both the person who performed the collection and the person who manages the EDiscovery effort informed about the processing status of the collection by sending notifications, displaying alerts, and by providing appropriate views. 
     
    
     
       BRIEF DESCRIPTION OF THE DRAWINGS 
         [0031]      FIG. 1  is a screen shot that displays a processing area displaying warnings on files that have not been indexed yet, and files that are not indexable according to the invention; 
           [0032]      FIG. 2  is a screen shot that displays container extraction status in a processing status area according to the invention; 
           [0033]      FIG. 3  is a screen shot that displays processing status for the results of content search query according to the invention; 
           [0034]      FIG. 4  is a screen shot that displays an import log containing the list of files imported to an EMA and processing status warnings next to a file according to the invention; 
           [0035]      FIG. 5  is a screen shot that displays an alert at an EDiscovery coordinator alert page according to the invention; 
           [0036]      FIG. 6  is a screen shot that displays processing status warnings on a search result page according to the invention; 
           [0037]      FIG. 7  is a screen shot that displays processing status warnings on a file detail page according to the invention; and 
           [0038]      FIG. 8  is a screen shot that displays an affected files page, presumably accessed through a link inside the error message in a processing status area of the search results page according to the invention. 
       
    
    
     DETAILED DESCRIPTION OF THE INVENTION 
     Terms 
       [0039]    For purposes of the discussion herein, the following terms have the meaning associated therewith: 
         [0040]    Electronic Data Discovery (e-discovery or EDiscovery) is discovery of electronically stored evidence in civil litigation, as well as tax, government investigation, and criminal proceedings. 
         [0041]    EDiscovery Management Application (EMA). A software program responsible for managing the electronic discovery process and storing the collected content in the content repository. 
       Discussion of Preferred Embodiments 
       [0042]    Documents collected for EDiscovery undergo a certain transformation inside the collection repository. Namely:
       Content of container files may be extracted into the content repository. Note that container files may contain other container files whose content must also be extracted into the content repository.   Certain files can undergo full text indexing for future full text search.       
 
         [0045]    Sometimes these transformations may fail. For example, when an indexing engine times out and fails to index a file, or when an archive is password protected. Also, these transformations cannot be performed instantly. As a result, after a file import, some of the files that are supposed to be indexed may stay un-indexed, and some containers that are supposed to be exploded may stay un-exploded for a certain period of time. This can create a situation when a user failed to find or view a file that is supposed to be found for the purposes of litigation. For example, a file containing a certain word combination is not displayed in the full text search results because it has not been indexed properly, or even because it has not been extracted from a container. This may cause significant legal consequences, for example, in the situation when a defendant has an obligation to produce a document. 
         [0046]    In an embodiment of the invention, the EMA displays the indexing status of files pertaining to a given matter or legal request in the content repository. This display is provided in a processing status area of the search results page. Files in the content repository can be classified, for example, the following way when it comes to full text index-ability and indexing state:
   1. Not indexable: The EMA knows that certain types of files are not indexable and does not try to perform full-text indexing on them. For example, JPEG files are known not to be indexable.   2. Indexable, but not indexed yet: The EMA tries to index these files but, for some reason, they have not been indexed yet by the EMA.   3. Failed to index: The EMA considered these files indexable but, for some reason, the indexing attempt failed. Note that this category can be further subdivided into the following sub-categories:
       Files that failed to index because they were corrupted;   Files that are failed to index because of indexing engine limitations, e.g. too large; and   Files that are mistakenly considered indexable because, for example, multiple file formats use the same file extension or because of a setup error in the indexing engine.   
       4. Indexable and Indexed: The EMA Successfully Indexed these Files   
 
         [0054]    The EMA can extract indexing state and index-ability information from the content repository. For example, in Oracle, index-ability information is stored in a specially defined “IGNORE” field, and indexing status information can be extracted from Oracle Context Views. Note that each database product usually exposes some data that allows a programmer to derive full text indexing status. If some data are unavailable, there are ways to approximate this information. 
         [0055]      FIG. 1  is a screen shot that displays a processing area displaying warnings on files that have not been indexed yet, and files that are not indexable according to the invention. When user tries to search for files in the EMA content repository, the repository UI determines whether there are files and/or how many files reside in the above defined indexing states  1 ,  2 , and  3 . The UI then displays appropriate warning and error messages to the user, as well as hyperlinks to affected files. 
         [0056]    In another embodiment, the EMA displays the container extraction status of container files pertaining to a given matter or legal request residing in the EMA content repository. This display is provided in a processing status area of the search results page. More generally, summary information is provided on a search results page. Thus, the EMA can read container extraction status from the content repository and display this information as error or warning messages in the processing status area of the content repository view page.  FIG. 2  is a screen shot that displays container extraction status in a processing status area according to the invention. 
         [0057]    Extraction status can be stored in the EMA content repository in many ways. For example, the Atlas LCC has a status field that is originally set to “N” (not extracted). Once files are extracted from the container, the container extraction status is changed to “Y.” If the extraction failed, then the value is changed to “X.” 
         [0058]    In another embodiment, the EMA displays the indexing status and/or container extraction status warnings and errors only for the files that may affect search results. This display is provided in the processing status area of the search results page. In the above described embodiments, the EMA displayed indexing and extraction information against all the files collected for a given legal matter or document discovery request. This information becomes overwhelming when where are many files collected for a given matter and request. Therefore, the EMA can display indexing and extraction status information only for the files that may have affected a current search query. These files include, for example, the files for which the EMA could not evaluate whether the file match certain parts of the search criteria. 
         [0059]      FIG. 3  is a screen shot that displays processing status for the results of content search query according to the invention. For example, a user searches for a phrase “John Smith” in the content repository that stores collected documents for Case “John Smith vs. XYZ, Inc” and Discovery Request “Request 1.” There are one million files collected for this discovery request. The search page allows the user to specify modified-date range of the file, i.e. Jan. 1, 2005-Jan. 1, 2006. If a file is not indexed, it may contain the keywords that the user is looking for, but the EMA cannot check it. If the container has not been exploded, it may contain files that include the keywords user is looking for, but the EMA cannot check it. Even if the user is searching file modification dates or file names, the container can contain the files that match the search criteria, but the EMA has no way to check that. 
         [0060]    To produce guaranteed search results, EMA must display the files that meet all the search parameters, except those that the EMA cannot check because of the file&#39;s bad processing status. In the example above, the EMA displays indexing warnings and errors to the end user for all files that failed to index, not indexed yet, and optionally the files that are known as un-indexable that belong to case “John Smith vs. XYZ, Inc”, discovery request “Request 1,” and that were created between Jan. 1, 2005 and Jan. 1, 2006, assuming that these files may contain the information about “John Smith.” 
         [0061]    Displaying warnings on un-indexable files is optional because the user may understand that certain files are not subject to a full text search, e.g. JPEG files. Thus, such a warning may not be useful. 
         [0062]    The system also displays warnings and errors to the end user for all containers that failed to explode or that have not been exploded yet for the case “John Smith vs. XYZ, Inc” and Discovery Request “Request 1” because these containers may contain files the user tries to search for, i.e. files modified between Jan. 1, 2005 and Jan. 1, 2006 and containing keywords “John Smith,” but there is no way for the EMA to figure that out. 
         [0063]    To summarize this, the set of files returned to the end user comprises:
       Files that meet all the search criteria; and   Not indexed files that meet all search criteria except for keyword search criteria applied to the body of the file; and   Containers that are not exploded that meet all search criteria, except for keyword search criteria applied to the body of the files inside the container and file metadata search criteria applied to the files inside the container.       
 
         [0067]    For purposes of the discussion herein, the term file metadata search criteria refers to file properties of the contained files, such as name, extension, size, location, modified date, created date, last accessed date, and the criteria that can be derived during file extraction, such as hash value and digital signature. 
         [0068]    In another embodiment of the invention, the EMA displays the list of containers which failed to explode to the user who uploaded the containers into the EMA. Users who performed the collection, i.e. uploaded files to the EMA, can view the processing status of the files they have uploaded to the EMA content repository so they can promptly resolve the issues. For example, they can re-upload zip archives that failed to be exploded because of password protection, or they can provide the password as a note in the collection log.  FIG. 4  is a screen shot that displays an import log containing the list of files imported to an EMA and processing status warnings next to a file according to the invention 
         [0069]    In another embodiment of the invention, the EMA notifies the user who uploaded containers to the EMA and users responsible for coordinating the EDiscovery effort of the fact that some containers failed to explode.  FIG. 5  is a screen shot that displays an alert at an EDiscovery coordinator alert page according to the invention. In this embodiment, the EMA sends email notifications and displays alerts on an EMA alert page when certain containers failed to explode so that users who uploaded the files and users who coordinate the EDiscovery effort are notified of these events and can act accordingly. 
         [0070]    In another embodiment of the invention, the EMA displays a processing status warning next to a file entry so the user can see what processing problems occurred with each file. This can be done both on a search results page and on a file detail information page.  FIG. 6  is a screen shot that displays processing status warnings on a search result page according to the invention; and  FIG. 7  is a screen shot that displays processing status warnings on a file detail page according to the invention. 
         [0071]    In another embodiment of the invention, the EMA collects and presents information on what file types are not indexable by collecting the statistics of indexing failure per file type. Indexing failure may happen, for example, for any of the following reasons:
       The file was of an indexable type but was corrupt;   The file was of an indexable type but the indexing engine failed, e.g. indexing expired because file was too long;   Files of different types, e.g. A-indexable and B-un-indexable, use the same file extension. As a result, the indexing engine treats a file of type B as type A, tries to index it, and fails;   The file was treated by the EMA as indexable but, in reality, this was not an indexable file type. For example, an administrator forgot to include a file extension for a new image format into “do not index” list.       
 
         [0076]    When indexing fails, it is hard to determine the reason. However, there is a need to improve indexing capabilities gradually and minimize false positives by making sure that the EMA does not attempt to index un-indexable files. Usually, the EMA maintains a list of file types that are not supposed to be indexed. However, new file types may arrive and the EMA administrator needs to receive information on whether these file types are indexable or not. This can be done by observing indexing failure statistics. Over time, the EMA collects, for example, the following information per file type:
       How many files of each type were indexed successfully;   How many files of each type failed to index; and   How many files of each type have been uploaded.       
 
         [0080]    Based on this information, the system calculates the ratio of indexing failure, which can be described by the following formula: 
         [0000]      Ratio of failure of a given type=number of failed files of a given type/number of files of a given type uploaded and attempted to index 
         [0081]    This information can be reported to the administrator so that file types having a high ratio can be added to a “do not index” list. For example, if the ratio is close to 1, this is definitely not an indexable file type. If the ratio is between 0.2 and 0.8, here the numbers are arbitrary, indexable and un-indexable file types may have the same file extension. If the ratio is low but not 0, a majority of files of this type are getting indexed, but there may be problems with indexing engine timeout or some files may be corrupt. 
         [0082]    Another Formula that may be Used for this Purpose is as Follows: 
         [0000]      Ratio of failure of a given type=number of failed files of a given type/number of files of a given type successfully indexed 
         [0083]    This formula can be derived from the previous formula. The decision points equivalent to those described above are, for example:
       Infinity—file type is not indexable   0.25-4—files of multiple types have the same extension   1—files type is indexable       
 
         [0087]    The EMA can automatically (or semi automatically, by presenting the information to the administrator and letting the administrator decide) update the “do not index list” with file types that proved to have high ratio of failure. A high ratio of failure can be determined through comparison against a threshold value. The EMA may also postpone the decision until it achieves a representative sample, i.e. a large enough number files of the same type being uploaded and attempted to index. This makes the statistics credible. 
         [0088]    In another embodiment of the invention, the EMA provides a separate view containing the list of files that have questionable status.  FIG. 8  is a screen shot that displays an affected files page, presumably accessed through a link inside the error message in a processing status area of the search results page according to the invention. A warning or error message in the processing status area leads to an “effected files” page, which displays the list of files affected by this warning or error condition. 
         [0089]    Although the invention is described herein with reference to the preferred embodiment, one skilled in the art will readily appreciate that other applications may be substituted for those set forth herein without departing from the spirit and scope of the present invention. Accordingly, the invention should only be limited by the Claims included below.