Content deleted Content added
→Pooling: capitalization |
Markrmullan (talk | contribs) m grammar |
||
Line 3:
A '''Database connection''' is a facility in [[computer science]] that allows [[Client (computing)|client]] software to talk to [[database server]] software, whether on the same machine or not. A '''connection''' is required to send [[command (computing)|commands]] and receive answers, usually in the form of a result set.
Connections are a key concept in [[data-centric]] programming. Since some DBMS engines require considerable time to connect, [[connection pooling]] was invented to improve performance. No command can be performed against a database without an "open and available" connection to it.
Connections are built by supplying an underlying [[software driver|driver]] or [[data provider|provider]] with a [[connection string]], which is a way of addressing a specific [[database]] or [[server (computing)|server]] and instance as well as user authentication credentials (for example, '''''Server='''sql_box;'''Database='''Common;'''User ID='''uid;'''Pwd='''password;''). Once a connection has been built it can be opened and closed at will, and properties (such as the command time-out length, or [[Database transaction|transaction]], if one exists) can be set. The Connection String is composed of a set of key/value pairs as dictated by the data access interface and data provider being used.
| |||