-->''Horatio: 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'''."''
->- '''The webcomic [[http://theslackerz.com/index.php?nav=Comic&Page=26#content Slackerz]] making fun of {{CSI}}'''
A special AppliedPhlebotinum used primarily in PoliceProcedural dramas.
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 "{{magical database}}s" actually exist, and ''are'' in use by forensics labs, though they aren't quite as stunningly accurate or omniscient as the PoliceProcedural suggests.
Forensics labs also have an [[HandWave out]] for many of these {{magical database}}s, since it's generally believable that they would have a database of common murder weapons or components of weapons.
Magical Databases almost always have a ViewerFriendlyInterface.
----
!!Examples:
* ''{{CSI}}'' is the king of the MagicalDatabase. They have demonstrated databases on blood, hair, rope, wire, shoe prints, tire treads, tire rubber compositions, and even clown makeup patterns. There was a LampshadeHanging in a sixth season episode, in which a character sarcastically suggested searching a database to discover the brand of a hot dog.
** And yes, there is a national clown registry to prevent identical makeup.
** Amusingly subverted in one episode where Greg is dissapointed to learn that there is no hotdog database & winds up spending his entire year's food budget on various brands of hotdogs in an attempt to find a match to one found in a vic's stomach (He thought the department would re-imburse him. [[ButtMonkey They didn't]]).
** Don't forget the software/database that allows one to find where a picture in New York was taken by measuring the skyline in comparison to a reference height (while the technique is sound, there is no such software).
** However, one episode shows them using [[http://livelabs.com/photosynth/ Photosynth]].
** In fact, it's when CSI avoids the trope that it can be jarring. A reoccurring scene is the local trace evidence guy naming a compound, and the CSI identifying the compound's common name, and its uses, including the more arcane (say, Jeweller grinder lubricant) on the top of their head. Said arcane use are always the key to cracking the case. This gets jarring because there ARE databases to identify the most common uses of chemicals.
** There actually are multiple shoe-print databases available to police. An episode of [[TrueCrime Cold Case Files]] discussed a murder case that was solved, thanks to a partial shoe-print on a piece of glass that matched the shoes of a person in the neighborhood, who was found to be the killer.
** The characters in CSI are also lucky that whatever sample of fabric or metal they find, there is always some unique element or polymer in it which is used by a single company in the world, and is located a short car drive away. Did we forget to mention that the magical database knows the exact 100% correct composition of everything you can buy?
* ''StarTrek'' must hold the freakin' copyright on the MagicalDatabase cause there are like 1500 of them in the series and movies.
--> '''Data''' - can calculate the probability of a successful saucer section separation at high-warp in mere seconds, even though it's never been attempted before.\\
'''Spock''' - can calculate the equations for time travel '''and''' memorize Hamlet ''in the same movie''.
'''The holodeck''' - can recreate any setting or fictional story known to Man and several other species. (In one of the books, the holodeck can even replay every Opera performance from 1400 to the year 2356. How they managed to record pre-Renaissance operas ... best not to ask.)
And of course, '''The Enterprise Main Computer''' - carries all kinds of info like the launch codes to the Voyager probe built over 200 years earlier, or the command codes to every other Federation ship (why you'd keep something like that on a starship that can be accessed by an enemy is beyond this troper)
** And yet, when it would actually be useful for the computer to find a piece of obscure information, such as in 'The Naked Now' or 'Darmok', it takes hours.
** As far as the operas go, they quite often program in the parameters themselves, rather than relying on holorecordings. It's not inconceivable that they programmed in all of the operas that they had decent descriptions of at some point.
*** They could have easily recorded a 24th century production of a 15th century opera.
* In an episode of ''{{NCIS}}'', Abby, the forensic scientist, tells us that her ex-boyfriend has made a database of databases after using a magic database of the measures of car fronts.
* It might be observed that SherlockHolmes 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 [[OlderThanRadio pretty old detective-story trope]].
** LordPeterWimsey also did this - he 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.)
** Holmes also kept paper files on crime and stuff he felt was important.
* Almost every depiction of {{Comicbook/Batman}} has this, whether it's his own vast knowledge (a la SherlockHolmes), the Batcave computer, or a combination of both.
**In one JusticeLeagueOfAmerica 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 the past... err... future...''
** In recent Batman continuity, [[VoiceWithAnInternetConnection Oracle]] has taken on this role, in part. This raises the question of whether it's more work to draw panels with Oracle and her speech bubbles in, or to draw a computer screen displaying the same information.
*''{{Torchwood}}'''s main characters are a secret organization with nationwide database records sorted by an ancient alien computer system. The team is capable of literally [[RetCon retconning]] anything by changing the database.
**
--->'''Gwen:''' Is this CRIMINT? This is the Police computer system – you shouldn't have this.\\
'''Jack:''' You might wanna stop saying "you" and start saying "we"?
**''{{Torchwood}}'' also subverted it once - just as Jack and Toshiko are getting ready to search every database they have, Owen announces that he's already found the man they're looking for. He was listed in the phone book.
* On ''{{Angel}}'', Wolfram & Hart has access to several databases which actually ''are'' magical.
** Before Angel's team got access to these they used "Demons, Demons, Demons, The Demon Database".
*This is almost the entire purpose of Riley's character in ''Painkiller Jane''--to run the computers that have access to these things.
*''Bourne Identity'': The US government can identify a German citizen and everything she's done her entire life and her family history within moments from a blurry picture.
** While her every place of residence and every phone call is a little far fetched, finding the identity of a person who tried to apply for an American citizenship in the US embassy Bourne escaped from isn't too hard to believe.
** You can do a search for matching faces but it takes a lot of time and computer power, unless you are searching through a very small base.
*''JohnDoe'' features a hero that displays ability of knowing everything that can be known about on earth. He's basically a walking and talking magical database.
**Actually, he knows everything about everything ''except'' himself.
* And similar to John Doe, there's Kyle, from {{Kyle XY}}, who didn't know ''every'' trivial fact, only things like mathematical formulas. Well, until he spent a single day reading the World Book.
* Very similar to the Sherlock Holmes example above, Inspector Lunge 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.
* Film variant: in the 2008 film ''IronMan'', Tony Stark, having been frozen out of his company by villain Obidiah Stane, asks his assistant Pepper Potts to hack into Stark's office computer to retrieve some critical files from the company mainframe. Not very magical until Potts stumbles across a video file of Stark's earlier having been taken hostage by a terrorist group. In the video the terrorists are making their demands in some foreign, Arabic-like language. Potts simply clicks a "Translate" button on the video viewer interface, and the video soundtrack is translated into perfect (and appropriately accented) English.
** This increases in Magic when you realise that the only justification for this would be that Stane somehow already had it translated, a process which likely took some time - a believable handwave, given the level of technology Stark surrounds himself with. But, as an earlier scene showed, ''Stane is fluent in generic-Middle-Eastern.''
*** [[FanWank Perhaps he had it translated in case he ever needed to show it to anyone else who wasn't fluent - after all, he might, at some point, have needed to actually take some action on it had Tony not built the Iron Man armour.]]
*** Or it could be a different Middle Eastern language than the one that he was shown to be fluent in. This troper can think of three (Arabic, Farsi, and Urdu) of the top of his head.
* From a Western Animation: From 'Jem' episode, "In Search of the Stolen Album" in which 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.
* Blakes 7 - Orac, the super computer, who can read any computer with "tarial cells" and is therefore able to find any data the characters can possibly want. Whether he then tells them what he finds out is another story.....
* Impulse is the only [[TheFlash 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.
* ''[[DoctorWho The Doctor]]'' is a living MagicalDatabase. This troper can't remember a single episode in the new or old series where he met an alien, visited a planet, or saw a piece of technology he hadn't seen, invented, or met previously. In the new series, when a bunch of alien cops threaten him and Donna in a language not even the mighty TARDIS can translate he easily understands and berates them in the same language. The man is awesome. But then who knows what anybody might know after traveling the universe for a thousand years...
** And then there's [[spoiler: CAL]], which contains every book ever written ''in any language, '''by any species''','' '''since the beginning of time'''. Including lost works. In both hard copy and digital.
**The episode of the new series ''Midnight'' averts this somewhat. The 10th Doctor had no idea what the enemy was or how to fight it.
* {{Primeval}} Within less than 15 minutes into the pilot, we've seen that a college student has put together an entire database on every known prehistoric animal.
** That doesn't seem too bad unless it was done ''in'' 15 minutes. It's not as though prehistoric animals are secret information or something.
* Subverted in MrAndMrsSmith : When the female titular character commands her subordinates to "search the database!", she gets rebutted with a snarky "For what? ''John Smith''?"
* [[TeenGenius Wade]] from ''KimPossible'' 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 RapidTyping with his MagicalComputer.
* {{Chuck}} is a walking-talking database, able to identify terrorists on sight, however there is also such a database under the Orange Orange used by Sarah and Casey. In Chuck vs. Santa Claus we see it pulls up the record of "Ned" who has no criminal record, and is listed as [[{{Viewer Friendly Interface}} having never been married or divorced.]] You know how powerful a computer is when it categorizes you by things you haven't done rather than by what you have done. Then again, it is a [[{{TakeThat}} U.S. government computer...]]
** It doesn't seem too farfetched since getting married in a legal sense requires a marriage license. And since in the US, being married grants several benefits in things like taxes, martial status is generally a standard appearance on many forms.
* TropeBot is.
* The titular character of ToAruMajutsuNoIndex is quite literally one of these considering the database itself ''is about magic''.
* Ziggy from ''QuantumLeap'' not only apparently has records of the minutiae of decades' worth of the day-to-day activities of pretty much everyone who was alive at the same time as Sam Beckett, but can also calculate the probability that Sam's interference in history will have the desired effect.
** And regardless of the percentage calculated, Ziggy is always right. Except for a couple episodes where despite an abnormally high percentage, Sam just "knows" he has to do something else.
* [[TVTropes This very wiki!]] Theoretically, you could write any genre of fiction story for any medium if all you had was this trope and some time to spare.
* The titular book of ''TheHitchhikersGuideToTheGalaxy'' may be a subversion of this, as it contains data on almost everything in existance but a good deal of that data is either made up on a whim or wildly inaccurate.
* In ''KingdomHearts 2'', 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?
* In ''TheSandman'', Dream has a library of all the books that were never written. Including some famous real-world classics whose authors [[AuthorExistenceFailure died before they could finish writing them.]]
* Death's library in {{Discworld}} sometimes functions like a MagicalDatabase, instantly delivering books on very obscure subjects when he requests them, or writing out fresh text if his query doesn't require a long answer (the "some of the sheep" response from ''The Last Continent'').
* ''[[ERing E-Ring]]'' had a [[WallBanger really stupid example]] in the episode ''The General''. Said general is kidnapped in Spain. In order to identify his kidnapper, the main character asks to consult the ''Voice'' Database of the Spanish Government (which apparently includes voice samples of each of the [[NineteenEightyFour 40 million citizens of the country]] and is [[FridgeLogic regularly updated]] to match voice changes due to aging, disease or plain mood swings), and then uses an experimental, [[AmericaSavesTheDay American exclusive application]] to compare its files with the record of the kidnapper's voice he has. This leads to the obvious question of why on Earth would a government keep a voice database of all its citizens if it had no way of consulting it, adding to the Wall Banging experience. Of course none has in RealLife, but TheyJustDidntCare.
* In an episode of ''JudgingAmy'', the DNA identifying computer with a database of known criminals returned a result of... ''cat DNA''!!!
* An episode of ''Dexter'' had Dexter identifying an STD in some bloodwork, then going into the Florida STD Database (!?) to find the names of people afflicted with that particular--and, of course, extremely rare--strain. It is implied that he never leaves the building during all of this, so Dexter's miraculous set of databases even cover what you might be doing with your genitals.
* Patchouli Knowledge (It's ''[[MeaningfulName in her name]]'', duh!) of ''{{Touhou}}'' fame is an effective Human([[WitchSpecies oid]]) Magical Database, thanks to her centuries of study and self-made LibraryOfBabel. 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, DuctTape, and a whole lot of FunctionalMagic.
----
<<|OlderThanRadio|>>
<<|MagicalComputer|>>