data: DSN, ODBC, connection string, data source + database tag
authorFrantišek Kučera <franta-hg@frantovo.cz>
Wed, 24 Jun 2020 22:00:50 +0200
changeset 15366e05b1bbda2
parent 152 5c878a53d3ed
child 154 802f32be53bf
data: DSN, ODBC, connection string, data source + database tag
data/dictionary.xml
     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>