Database Querying

Author: Kristian Hansen

Definition

Database querying is a mechanism used for retrieving specific information from a database quickly.



Description

Database querying is a method in which specific data can be retrieved through the application of specific filters and parameters.
This can be done through a variety of methods and applications, including MySQL. Database querying is the primary mechanism for retrieving and pushing information for a database. Without it, databases would be useless as one could not read from or write to the database, when then nullifies its purpose.

Explanation and application

There are many forms of database query software, but they all follow the Structured Query Language (SQL) syntax. An example of a request to retrieve a value from a database is below.

SELECT names FROM contact_list

As you can see, the syntax is rather straightforward and basic, but the opportunities that the language opens up are enormous. Database queries usually need to be done server-side as the database is stored online. Therefore queries are supported in PHP and other like-minded languages that are executed server-side.

Links to Social and Ethical Issues


Please note that not all issues need to be addressed. Please add the URL or source of any examples to support your suggestion. It may be helpful to RANK the issues in the THIRD column.

Social & Ethical Issue
Examples that specifically link to the concept and/or definition in the Case Study
Ranking
1.1 Reliability and integrity

1
1.2 Security


1.3 Privacy and anonymity


1.4 Intellectual property


1.5 Authenticity


1.6 The digital divide and equality of access


1.7 Surveillance


1.8 Globalization and cultural diversity


1.9 Policies


1.10 Standards and protocols


1.11 People and machines


1.12 Digital citizenship





References and resources