He also has a file of maps to bad guy labs.
: I need a report on all the walls ever made ever
. Tech Guy:
I'm on it... According to this, this particular model of wall is of an excellent quality. It doesn't creak. Unless... there's a body behind it
No matter what sort of clue the Crime Scene lab has found (blood, wire, rope, oil, perfume, etc), somebody
has manufactured a database designed to search through them all. Not only that, our heroes at the crime lab have purchased a copy of this software, the interface devices to input the data in question and have acquired the expertise to use this software (which has so far never been used in another one of their cases) with 100% accuracy on the first attempt.
It should be noted that some of these "Omniscient Databases" actually exist, and are
in use by various agencies, though they aren't quite as stunningly accurate or omniscient as the Police Procedural
suggests. In real life, "Data Mining" is a time-consuming task that has to be practiced. Does each agency host a different server? Which ones pull from each other? Are all servers identical? Are there delays in updating the databases? These are all questions the searcher needs to be aware of, and there is no single database that stores 100% of the information.
A key aspect of this trope is that there must be a pre-existing compendium of all possible samples of whatever is being identified. In Real Life
, forensics can indeed match samples of, say, paint or glass not only down to manufacturer but even to a specific batch, but this requires two samples: one sample from evidence, and another sample to compare against. This also means that in real forensics, the implications of this evidence are different; while crime dramas typically use the Omniscient Database
to find a new lead from trace evidence, real forensics usually confirms identity after the police have already gotten a lead (i.e. the police already suspect the glass came from the suspect's house or workplace and can prove it by comparing them, as opposed to identifying where the suspect lives with no prior knowledge just from the glass sample).
Even in cases where there are well established databases, like criminal records, there are computer scientists who have dedicated entire careers just figuring out how to combine
databases from various departments and institutions. When computers first started to be used for keeping criminal records, standardization was rarely considered, as they were for the use of that department alone, unless they were in a particularly forward-thinking county or large city where they shared records among local departments. It rapidly became apparent that this was a problem when departments began sharing records over the internet. One database may describe a criminal's eyes as "Light blue", another as "BL" and a third as "Lb". The same departments would describe another criminal's eyes as "Dark Brown", "BrD", and "B". This is after you manage to figure out which column denotes eye color, mind you. Even after the problem was discovered, change was slow because in some cases, such as New York and London, the same basic forms had been used for over 100 years, and had simply been transferred from index card to hard drive.
Forensics labs also have an out
for many of these Omniscient Databases, since it's generally believable that they would have a database of common murder weapons or components of weapons.
Omniscient Databases almost always have a Viewer-Friendly Interface
. If it's on paper or supernatural, it's a Great Big Book of Everything
. See Akashic Records
for a related but older
trope. These are a special Applied Phlebotinum
used primarily in Police Procedural
dramas, sometimes ones with a supernatural element.
open/close all folders
Anime and Manga
- In Lupin III: Dead or Alive, Lupin's computer is capable of analyzing "sand", and determining the atomic composition of Nanomachines.
- Inspector Runge from Monster keeps an absurdly expansive encyclopedia on practically everything in his head by constantly making a typing motion and saying that he's just calling up the memories as he needs them, or something along those lines.
- Almost every depiction of Batman has this, whether it's his own vast knowledge (a la Sherlock Holmes), the Batcave computer, or a combination of both. In one Justice League of America issue, it is shown that Batman's database of fingerprints looks at the magical databases of the Batcave, the GCPD, AFIS, JLA Headquarters and Superman's fortress of solitude. This allows him to determine the identity of a 31st century superhero because Superman had been friends with him in the past... err... future...
- Oracle has taken on the role of database for the hero community at large. She serves as information retriever and disseminator, as well as offering mission-specific hacking and guidance.
- In an issue of Gotham Central, which focused on the members of the Major Crimes Unit of the Gotham City Police Department, Renee Montoya was attempting to track down the history of a sniper rifle that had been used in several high-profile assassinations. She is seen accessing numerous government databases, including the FBI and ATF, but none of them can give her any useful information. When she mysteriously gains access to a system named "Oracle," which neither she nor her partner can identify, she is shocked (but happy) when it suddenly gives her the complete history of the gun, including the gun shop where it was sold.
- The Flash: Impulse is the only Flash able to permanently remember what he reads at super-speed. Once, he read an entire San Francisco public library. It came in less handy than you'd think.
- In The Sandman, Dream has a library of all the books that were never written. Including some famous real-world classics whose authors died before they could finish writing them. It also has the books that you might dream of writing some day. Trippy.
- Subverted in Queen And Country - when trying to identify a man on a video being used to blackmail a well-known telecom industrialist, the technicians mention to Crocker that they ran his face through a visual database to match him to someone on file. Crocker asks if that actually worked, and one of the techs says it never does, mentioning that the database always wants to match the subject to the late Queen Mother.
- Subverted in Mr. & Mrs. Smith: When the eponymous female character commands her subordinates to "search the database!", she gets rebutted with a snarky "For what? John Smith?"
- Sherlock Holmes:
- Holmes kept such databases in his head, being able to identify, for example, varieties of tobacco after examination of the ash (he had "written a monograph" on the subject). He also had a substantial collection of home-made biographies, which were usually spoken aloud by Watson for the reader's benefit. So, despite its modern-tech dressing, this is a pretty old detective-story trope.
- Sherlock's older brother Mycroft actually made a living out of this, being a living database for the British Government.
- Lord Peter Wimsey series: Wimsey is a living magical database. He also had a home-made "Who's Who" of the underworld, and once managed to identify the maker of a hat which had had its label removed, purely from the style. (Parker remarks that if he hadn't got the hatter, they'd have tried him on the man's dress suit, similarly de-labelled.)
- The Dresden Files
- The Archive in is a being that holds the knowledge of everything ever written down, ever, in the history of mankind. Her information is updated in real-time, a fact which Harry puts to good use in Small Favor.
- There's also Bob, Harry's knowledge spirit in a skull. Bob doesn't have the extensive knowledge of the Archive, but he is Dresden's go-to guy for magical knowledge, and he instinctively knows the current rules of magic.
- Secret Histories: The Karma Catechist is a living database of every spell, ritual and magical concept conceivable in his universe.
- In "Under A Velvet Cloak", we find that Nox, the Mistress of Secrets, received a highly advanced database, which she always has with her. Since her Office receives all secrets, her database becomes this. In fact, it forms the basis for the all-knowing computer system seen in Purgatory.
- In Aristoi, all human knowledge is contained within the Hyperlogos. The database is so big, in fact, that the Moon has been entirely converted into a dedicated server farm, and it's only one of many such farms throughout the known galaxy.
- This is more or less how the wizard's manual works in the Young Wizards series. It's a constantly-updating collection of knowledge spanning most of the known universe and several others besides. Every wizard has a copy, in formats ranging from Spell Book to laptop to disembodied voice, and the contents rearrange themselves according to the wizard's needs and talents.
Live Action TV
- In Grand Theft Auto IV, the criminal dispatching minigame starts by looking up a perp from a stolen cop car's laptop. This gives an exact, updating location of the criminal for you to chase down.
- ARI in Heavy Rain is connected in some way to the FBI database.
- In Kingdom Hearts II, Sora seems to think that Ansem's computer is one of these. Because the computer belonging to the guy you killed last year will have info on where your friends are right now, right?
- Patchouli Knowledge (It's in her name, duh!) of Touhou fame is an effective Human(oid) Magical Database, thanks to her centuries of study and self-made Great Big Library of Everything. In Subterranean Animism, she is capable of spilling out the histories and powers of every youkai Marisa meets in her adventure... with the slight problem of taking until after the yokai was defeated to look up any relevant information.
- She also applied her knowledge to other tasks, such as constructing a spaceship from plywood, duct tape, and a whole lot of Functional Magic.
- To push the point home, the only character who probably trumps her in intelligence might be Eirin Yagokoro, the Brain of the Moon. Very few humans know anything significant about the advanced Lunarian society and their technology (for their own protection, to some extent). In Silent Sinner In Blue, Patchouli not only makes remarkably accurate predictions regarding the timing of their rocket's flight to get to the Lunar Capital but she also immediately identifies the Lunar Veil, a Lunarian device that allows flawless travel between the Earth and Moon, that Eirin had covertly attached to the rocket. The ever-collected Eirin's first thought is stab this person now.
- Uplink is a game basically built in databases, it features a Social Security Database, a Criminal Database and an Academic Database which store all the important people in the game and every life you'll ever need to ruin (including yours). And the Inter NIC, a database containing every public website in the world, which is to say a few hundred in the actual game.
- From the Jem episode, "In Search of the Stolen Album": Synergy, Jem's super-computer, is able to scan clues that "Misfits"'s treasure hunt joke on the Holograms in a matter of moments—and even the reasons behind the places.
- Wade from Kim Possible has more or less everything in the database, which of course comes in handy very often. Somewhat justified that he is a highly skilled hacker using Rapid-Fire Typing with his Magical Computer.
- The FBI keeps records on all typewriter keys (Type that ransom note? They can tell what make and model), fingerprints (been arrested or served in the military?), paper (ransom note, etc.), bullets, mug shots, and many more things.
- The National Crime Information Center (NCIC) is the United States' central database for tracking crime-related information. Since 1967, the NCIC has been maintained by the Federal Bureau of Investigation's Criminal Justice Information Services Division, and is interlinked with similar systems that each state maintains. Data is received from federal law enforcement agencies, state and local law enforcement agencies, as well as tribal law enforcement agencies, railroad police, and other agencies, such as state and federal motor vehicle registration and licensing authorities.
- The United States Secret Service keeps records of every counterfeit US currency bill ever discovered, so they can match ones they find to see if it is a "new batch". Every written threat to the President (and other officials) is kept to see if the person has made a threat in the past.