© Jay M. Patel 2020
J. M. PatelGetting Structured Data from the Internethttps://doi.org/10.1007/978-1-4842-6576-5_5

5. Relational Databases and SQL Language

Jay M. Patel1 
(1)
Specrom Analytics, Ahmedabad, India
 

Relational databases organize data in rows and tables like a printed mail order catalog or a train schedule list and are indispensable for storing structured information from scraped websites.

They are specifically optimized for indexing large amounts of data for quick retrieval. Most relational databases are handled by a database server, an application designed specifically for managing databases and which is responsible for abstracting low-level details of accessing the underlying data.

A relational database management system (RDBMS) is based ...

Get Getting Structured Data from the Internet: Running Web Crawlers/Scrapers on a Big Data Production Scale now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.