The 10 Largest Databases in the World

-

The 10 Largest Databases in the World

No 10. Library of Congress

With over 130 million items including 29 million books, photographs and maps, 10,000 new items added each day and nearly 530 miles of shelves, the Library of Congress is a wonder to behold in itself. Only the text portion of the library would take up 20 terabytes of space. If internet isn’t helping you out in your research, head to the oldest federal cultural institution in the United States in DC.

No 9. Central Intelligence Agency

With exact size understandably not made public, the CIA has comprehensive statistics on more than 250 countries of the world and also collects and distributes information on people, places and things. Although, the database is not open to public, portions of it are made available. Freedom of Information Act (FOIA) Electronic Reading Room is one such example where 100s of items are added from the database monthly.

No 8. Amazon

Containing records of more than 60 million active users, Amazon also has more than 250,000 full text books available online and allows users to comment and interact on virtually every page of the website. Overall, the Amazon database is over 42 terabytes in size.

No 7. YouTube

With over 60 hours of video uploaded per minute, yes, per minute, YouTube has a video database of around 45 terabytes. It has over 100 million videos being watched every day.

No 6. LexisNexis

LexisNexis is a company providing computer-assisted legal research services which bought Choicepoint in 2008, and Choicepoint was in the business of acquiring information about the American population including everything from phone numbers to criminal histories. It had over 250 terabytes of data on the American population until it was bought by LexisNexis. Just imagine what LexisNexis would be holding on to.

No 5. Sprint

The third largest wireless telecommunications network in the US has a database of over 55 million users. Sprint processes over 365 million call detail records per day. Making up its huge database are 2.85 trillion rows of information.

No 4. Google

The list wouldn’t be complete without Google. Subjected to around 100 million searches per day, Google is one of the largest databases in the world that has over 33 trillion database entries. After all, Google stores each and every search of every user into its database; creepy? Well…

No 3. AT&T

Bigger than sprint, AT&T boasts 1.9 trillion calling records which contribute to 323 terabytes worth of information. One factor behind the massiveness of its database is the fact that AT&T has been maintaining databases from the time when the technology to store terabytes wasn’t even available.

No 2. National Energy Research Scientific Computing Center (NERCS) 

Based in Oakland, California, National Energy Research Scientific Computing Center or NERSC is owned and operated by the Lawrence and the U.S. Department of Energy. Included in its database of 2.8 petabytes is information on atomic energy research, high energy physics experiments and simulations of the early universe. 

No 1. The World Data Centre for Climate

Operated by the Max Planck Institute for Meteorology and German Climate Computing Centre, The World Data Centre for Climate is the largest database in the world with 220 terabytes of data that is readily available on the internet. Add to that 110 terabytes of climate simulation data and 6 petabytes of data stored on magnetic tapes. Try to compete with that.

 Learn SQLite with us at PCWorkshops!

pcworkshopslondon.co.uk


Comments

Post a Comment

Popular posts from this blog

Delete vs Truncate in MySQL and MS SQL Server

-
Delete vs Truncate in MySQL and MS SQL Server DELETE DELETE is a DML Command. DELETE statement is executed using a row lock, each row in the table is locked for deletion. We can specify filters in where clause It deletes specified data if where condition exists. Delete activates a trigger because the operation are logged individually. Slower than truncate because, it keeps logs. Rollback is possible. TRUNCATE TRUNCATE is a DDL command. TRUNCATE TABLE always locks the table and page but not each row. Cannot use Where Condition. It Removes all the data. TRUNCATE TABLE cannot activate a trigger because the operation does not log individual row deletions. Faster in performance wise, because it doesn't keep any logs. Rollback is possible. DELETE and TRUNCATE both can be rolled back when used with TRANSACTION (TRUNCATE can be rolled back in SQL Server, but not in MySQL ). if there is a PK with auto increment, truncate will reset the counter Learn SQL with us a PCWorkshops ! 
Read more

What Is SQLite?

-
Image
  What Is SQLite? SQLite is a C-language library designed to implement a compact, high-speed, self-contained, and robust SQL database engine . It stands as the most widely employed database engine globally, integral to the operating systems of virtually all mobile phones and the majority of computers. Additionally, it is packaged within numerous everyday applications. The SQLite file format boasts stability, cross-platform compatibility, and backward compatibility. Developers commit to maintaining this stability until the year 2050. SQLite database files serve as prevalent containers for the exchange of rich content across systems and as a long-term archival format for data . The active usage of SQLite databases exceeds a staggering 1 trillion (1e12) instances [5]. It is noteworthy that the SQLite source code is in the public domain, making it freely accessible for use by anyone, without restrictions on purpose. Learn SQLite with us at PCWorkshops.     ...
Read more

SQL Project Ideas

-
Image
SQL Project Ideas Have you recently attended a data analytics or similar interview, and they asked  how you could prove your skills? Here are some ideas for databases to create and upload to GitHub to showcase your skills if you are looking to change jobs. :
Read more