China
Africa
Explore chapters and articles related to this topic
Reading in data locally and from the web
Published in Tiffany Timbers, Trevor Campbell, Melissa Lee, Data Science, 2022
Tiffany Timbers, Trevor Campbell, Melissa Lee
PostgreSQL (also called Postgres) is a very popular and open-source option for relational database software. Unlike SQLite, PostgreSQL uses a client–server database engine, as it was designed to be used and accessed on a network. This means that you have to provide more information to R when connecting to Postgres databases. The additional information that you need to include when you call the dbConnect function is listed below: dbname: the name of the database (a single PostgreSQL instance can host more than one database)host: the URL pointing to where the database is locatedport: the communication endpoint between R and the PostgreSQL database (usually 5432)user: the username for accessing the databasepassword: the password for accessing the database
An ontology-based framework for extracting spatio-temporal influenza data using Twitter
Published in International Journal of Digital Earth, 2019
Udaya K. Jayawardhana, Pece V. Gorsevski
The proposed client-server system shown in Figure 1 has been designed following the three-tier architecture model including: data, logic (application), and presentation tiers (Gorsevski and Torregrosa 2016; Liu et al. 2016; Mekonnen and Gorsevski 2015). The data tier stores unprocessed and processed tweets, which are accessed by the logic tier components. The PostgreSQL database server with PostGIS spatial extension is used to accommodate efficient implementation of spatial data queries that follow the simple features for SQL specification from the Open Geospatial Consortium (OGC). The open source PostgreSQL component is an object-relational database management system that is extensible and widely supported among different programming language libraries. The database server can handle different workloads that support single-machine small applications or large distributed and concurrent applications.