X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=doc%2Fglossary.xml;h=fd73384528c1eec3412e4462f4e85ca7cdae591b;hp=a8bc814c5ea30b0042bdde04e55e1412cea3a9b7;hb=0817beb5857835cfe68867e7026161f356869bdf;hpb=8d948bb37d6a4cc9cbdbc0ed3173b1284e00d552 diff --git a/doc/glossary.xml b/doc/glossary.xml index a8bc814..fd73384 100644 --- a/doc/glossary.xml +++ b/doc/glossary.xml @@ -13,6 +13,15 @@ future revisions. + + Attribute + + + A property of objects stored in a database table. Attributes are + represented as columns (or fields) in a table. + + + Active database @@ -21,7 +30,7 @@ Connection - + + + Column + + + + Data Definition Language (DDL) + + + + The subset of SQL used for defining and examining the + structure of a database. + + + + + Data Manipulation Language (DML) + + + + The subset of SQL used for inserting, deleting, updating and + fetching data in a database. + + database + + Database Object + + An object of type database. + + + + Field + + + + Field Types Specifier + + A value that specifies the type of each field in a query. + + Foreign Function Interface (FFI) @@ -49,26 +98,45 @@ - - Database Object + + Query - An object of type database. + + An SQL statement which returns a set of results. + - - Field Types Specifier + + RDBMS - A value that specifies the type of each field in a query. + + A Relational DataBase Management System + (RDBMS) is a software package for managing + a database in which the data is defined, organised and + accessed as rows and columns of a table. + + + + + Record + + + A sequence of attribute values stored in a database table. + + + Row + + Structured Query Language (SQL) - An ANSI standard language for storing and retrieving data - in a relational database. + An ANSI standard language for storing and retrieving data + in a relational database. @@ -77,11 +145,51 @@ Either a string containing a valid SQL statement, or an object of type sql-expression. - + + + + + + Table + + + A collection of data which is defined, stored and accessed as + tuples of attribute values (i.e., rows and columns). + + + + + Transaction + + + An atomic unit of one or more SQL statements of which all or none are + successfully executed. + + + + + Tuple + + + + View + + + A table display whose structure and content are derived from an + existing table via a query. + + + + + View Class + + + The class standard-db-object or one of + its subclasses.