1.1 --- a/data/dictionary.xml Mon Jun 22 23:11:14 2020 +0200
1.2 +++ b/data/dictionary.xml Wed Jun 24 22:00:50 2020 +0200
1.3 @@ -31,6 +31,7 @@
1.4
1.5 <tag id="java" name="Java" description="Java and other JVM languages"/>
1.6 <tag id="xml" name="XML" description="eXtensible Markup Language"/>
1.7 + <tag id="database" name="Database" description="SQL/Relational and other DBMS"/>
1.8 <tag id="security" name="Security" description="security and cryptography"/>
1.9 <tag id="protocol" name="Protocol" description="communication protocol"/>
1.10 </tags>
1.11 @@ -2038,6 +2039,7 @@
1.12 </explanation>
1.13 <tag>computer</tag>
1.14 <tag>protocol</tag>
1.15 + <tag>database</tag>
1.16 </concept>
1.17 <concept>
1.18 <term abbreviation="GAL" completeForm="global address list" language="en"/>
1.19 @@ -2090,22 +2092,35 @@
1.20 </text>
1.21 </explanation>
1.22 <tag>computer</tag>
1.23 + <tag>database</tag>
1.24 </concept>
1.25 <concept>
1.26 <term abbreviation="noSQL" completeForm="Not SQL" language="en"/>
1.27 <explanation language="en"><text></text></explanation>
1.28 <tag>computer</tag>
1.29 + <tag>database</tag>
1.30 </concept>
1.31 <concept>
1.32 <term abbreviation="RDBMS" completeForm="relational database management system" language="en"/>
1.33 + <term abbreviation="DBMS" completeForm="database management system" language="en"/>
1.34 <term abbreviation="SŘDB" completeForm="systém řízení báze dat" language="cs"/>
1.35 <explanation language="en"><text></text></explanation>
1.36 <tag>computer</tag>
1.37 + <tag>database</tag>
1.38 </concept>
1.39 <concept>
1.40 <term abbreviation="ODBC" completeForm="open database connectivity" language="en"/>
1.41 - <explanation language="en"><text></text></explanation>
1.42 + <explanation language="en">
1.43 + <text>
1.44 + an industry standard that provides API for accessing a DBMS;
1.45 + in late 80s several vendors (mostly from the Unix and database communities) established the SQL Access Group (SAG)
1.46 + and then specified the Call Level Interface (CLI). ODBC, which is based on CLI, was published in early 90s;
1.47 + ODBC is available on many operating systems and there are at least two free software implementations: unixODBC and iODBC;
1.48 + in particular, it is an API consisting of C functions (see the files sql.h and sqlext.h e.g. in unixODBC or iODBC)
1.49 + </text>
1.50 + </explanation>
1.51 <tag>computer</tag>
1.52 + <tag>database</tag>
1.53 </concept>
1.54 <concept>
1.55 <term abbreviation="JDBC" completeForm="java database connectivity" language="en"/>
1.56 @@ -2115,9 +2130,48 @@
1.57 </text>
1.58 </explanation>
1.59 <tag>computer</tag>
1.60 + <tag>database</tag>
1.61 <tag>java</tag>
1.62 </concept>
1.63 <concept>
1.64 + <term abbreviation="" completeForm="data source" language="en"/>
1.65 + <explanation language="en">
1.66 + <text>
1.67 + a set of parameters (like server name, user name, password etc.) needed for connecting to a database;
1.68 + a configuration (e.g. in a file) or then its instantiation (an object) in a running program from which particular database connections can be obtained;
1.69 + see also DSN, connection string
1.70 + </text>
1.71 + </explanation>
1.72 + <tag>computer</tag>
1.73 + <tag>database</tag>
1.74 + </concept>
1.75 + <concept>
1.76 + <term abbreviation="DSN" completeForm="data source name" language="en"/>
1.77 + <explanation language="en">
1.78 + <text>
1.79 + the name of a preconfigured data source
1.80 + – when connecting, we need to know only the DSN –
1.81 + all parameters (like server name, user name, password etc.) can be then looked-up in the configuration;
1.82 + see also data source, connection string
1.83 + </text>
1.84 + </explanation>
1.85 + <tag>computer</tag>
1.86 + <tag>database</tag>
1.87 + </concept>
1.88 + <concept>
1.89 + <term abbreviation="" completeForm="connection string" language="en"/>
1.90 + <explanation language="en">
1.91 + <text>
1.92 + a text string consisting of serialized parameters needed for connecting
1.93 + – we can specify all parameters ad-hoc in the connection string without creating any permanent configuration;
1.94 + a connection string can also refer to an already defined DSN and add or override its parameters
1.95 + see also DSN, data source
1.96 + </text>
1.97 + </explanation>
1.98 + <tag>computer</tag>
1.99 + <tag>database</tag>
1.100 + </concept>
1.101 + <concept>
1.102 <term abbreviation="AS" completeForm="application server" language="en"/>
1.103 <explanation language="en"><text></text></explanation>
1.104 <tag>computer</tag>