Fasten Your Seatbelts: Database Productions in a Searchable Format

Producing databases is not as easy as fastening your seatbelt and enjoying the flight…

A former airline employee sued his union claiming the union “failed to properly process his grievances arising out of his discharge from Northwest Airlines.” Lynch v. Air Transp., 2010 U.S. Dist. LEXIS 138143 (E.D. Wis. Dec. 17, 2010).

The Plaintiff requested the production of a “grievance database” by both interrogatory and request for production that “related to other union members who retired or quit while they had a grievance pending.”   Lynch, at *4.

The Defendant objected on over broad, unduly burdensome and privacy grounds.  However, the Defendant ultimately produced a 300-page Word document in Rich Text Format.  Lynch, at *4-5.   The Word document included all the filed grievances for over a decade that were withdrawn after a grievant left the airline’s employment.  Lynch, at *5.      

However, the Plaintiff’s request was for information on “every grievance that the IAM has taken forward despite the grieving employee’s decision to quit or retire.” Lynch, at *4.      

The Defendant maintained the “grievance records” as 1) a hard copy file on each grievance and 2) a searchable database which could be exported to a Word document.  Lynch, at *5. 

The Defendant had 60,000 grievance files.   Id.

The Defendant claimed because of how the data was stored, they could not respond to the Plaintiff’s request.  Id.

The Plaintiff argued the Defendant should produce the database as an Excel file or simply give him access to the entire database.  Lynch, at *5-6. 

The Court took several issues with the Plaintiff’s request.  First, the requested electronically stored information possible was not relevant to the lawsuit, because any responsive ESI would have to be factually similar (both with an individual who was no longer an employee and had a similar grievance).  Lynch, at *7-8. 

The second problem was that the information the Plaintiff wanted was not retrievable from the Defendant’s database.  Lynch, at *8.   The computer system did not either 1) record the rationale for arbitration decisions or 2) list the employment status of a greivant.  Lynch, at *8.  As the Court explained:

[T]here is no searchable notation for those grievances that IAM decides to pursue despite the grievant no longer being employed. Requiring IAM to nevertheless attempt to retrieve such information from its files and computer database would force it to incur substantial costs. There is nothing before me to suggest that IAM can, with the click of a mouse, perform a simple computer search.

Lynch, at *9. 

The Court explained that to comply with the Plaintiff’s request, the Defendant would need to review 60,000 physical files and then cross-reference them with the date of each step of the arbitration process and the individual’s employment status.  Lynch, at *9. 

The Court said “no” to such a production burden on the responding party.  Lynch, at *9. 

The Court also refused to order the Defendants turn over the entire database to the Plaintiff.  Lynch, at *9.   As the Court explained:

The fact that much information today is electronically stored has not rendered obsolete the rules limiting the scope of discovery; nor does counsel’s willingness to stipulate to a protective order provide a license to scavenge through any and all records maintained by the other party.

Lynch, at *9.

The Court finally addressed the form of production: Word vs Excel. 

The Court explained that the Plaintiff did not specify Excel in his request.  Lynch, at *10-11.  While the Plaintiff did later tell the Defendant orally that it wanted the database in an Excel format, the Defendant had already started its production in Word format (the file format the Defendant ordinarily produced in).  Lynch, at *11. 

The Court found that the Defendants did not “convert” the database to remove functionality, especially since the Word document itself was searchable.  Lynch, at *11.

Bow Tie Thoughts

The production of databases in a searchable format has been litigated before and will be litigated again.  In this case, it makes sense the production was in Word, because it was the standard way the Defendant had maintained/produced the database before.  However, it might have turned out differently if the searchable features were truly degraded or the Plaintiff had specifically requested Excel format in their original request.

However, there is a bigger issue: A database contains only what data it has in it, not necessarily the data a requesting party wants.  In this case, it appeared the information sought simply was not in the database without the responding party doing significant document review and then analysis of other data to generate a specific report for the Plaintiff.  The Court put the breaks on forcing the Defendant to review 60,000 records and do extensive cross-referencing of other union members.  In other situations, such a report might be warranted.

4 thoughts on “Fasten Your Seatbelts: Database Productions in a Searchable Format

  1. Pingback: Magic Databases | The Many Faces of Mike McBride

  2. Pingback: Unfiltered Orange | Weekly eDiscovery News Update - January 19, 2011 | Orange Legal Technologies

  3. Pingback: Weekly Top Story Digest - January 19, 2011 | ComplexDiscovery

  4. Pingback: January 21st weekend “Top 20 … plus more” – a compendium of e-discovery articles and upcoming events | The Electronic Discovery Reading Room

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s