I would like to understand what might be the highest-level groupings of how query languages can be broken up into, and why one grouping might be fundamentally different than another. For example, the groupings that I have come up with now (for general-purpose usage) are:
What might be the best high-level grouping to describe various query languages?
A GROUP BY statement in SQL specifies that a SQL SELECT statement partitions result rows into groups, based on their values in one or several columns. Typically, grouping is used to apply some sort of aggregate function for each group. The result of a query using a GROUP BY statement contains one row for each group.
They are: Select queries • Action queries • Parameter queries • Crosstab queries • SQL queries.
In Microsoft Access, GROUP BY is a clause you can use to combine records with identical values in a specific field in one record. If you include an SQL aggregate function in the SELECT statement, such as AVG, COUNT, or SUM, Access creates a summary value for each record.
One variant is to group the query language depending on the database categories.
So far, so good, but in reality the border line between the categories become thinner and thinner.
For example, we have graph support in Microsoft SQL Server and T-SQL we have syntax like the following:
-- Find Restaurants that John's friends like
SELECT Restaurant.name
FROM Person person1, Person person2, likes, friendOf, Restaurant
WHERE MATCH(person1-(friendOf)->person2-(likes)->Restaurant)
AND person1.name='John';
In MongoDB, we have graph,too using graph lookup:
{
$graphLookup: {
from: <collection>,
startWith: <expression>,
connectFromField: <string>,
connectToField: <string>,
as: <string>,
maxDepth: <number>,
depthField: <string>,
restrictSearchWithMatch: <document>
}
}
So, maybe the the highest-level grouping is just a group of database management system following the American National Standards Institute (ANSI) standards (relational and object-relational) and the others.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With