An Entity of Type: software, from Named Graph: http://dbpedia.org, within Data Space: dbpedia.org

A database connection is a facility in computer science that allows client software to talk to database server software, whether on the same machine or not. A connection is required to send commands and receive answers, usually in the form of a result set. Connections are a key concept in 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.

Property Value
dbo:abstract
  • A database connection is a facility in computer science that allows client software to talk to database server software, whether on the same machine or not. A connection is required to send commands and receive answers, usually in the form of a result set. Connections are a key concept in 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 driver or with a connection string, which is a way of addressing a specific database or 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 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. Many databases (such as PostgreSQL) only allow one operation to be performed at a time on each connection. If a request for data (a SQL Select statement) is sent to the database and a result set is returned, the connection is open but not available for other operations until the client finishes consuming the result set. Other databases, like SQL Server 2005 (and later), do not impose this limitation. However, databases that provide multiple operations per connection usually incur far more overhead than those that permit only a single operation task at a time. (en)
  • Uma conexão de banco de dados é uma facilidade em ciência da computação que permite que o software cliente comunique-se com o software do servidor de banco de dados, na mesma máquina ou não. Uma conexão é necessária para enviar comandos e receber respostas. Conexões são um conceito chave em programação de centro de dados. (pt)
  • 数据库连接(database connection)是数据库服务器与客户端之间的通信联系。客户通过数据库连接发送命令、接收服务器返回的结果。 IBM DB2, Microsoft SQL Server, Oracle, MySQL, PostgreSQL, 与使用连接池技术来改善性能。 建造连接时,通常要提供一个驱动程序或与一个。例如, <b>Server=</b>sql_box;<b>Database=</b>Common;<b>User ID=</b>uid;<b>Pwd=</b>password;. 一旦连接建立,它可以被打开、关闭、设置性质。 (zh)
dbo:wikiPageExternalLink
dbo:wikiPageID
  • 8423925 (xsd:integer)
dbo:wikiPageLength
  • 4880 (xsd:nonNegativeInteger)
dbo:wikiPageRevisionID
  • 1050156299 (xsd:integer)
dbo:wikiPageWikiLink
dbp:wikiPageUsesTemplate
dcterms:subject
gold:hypernym
rdf:type
rdfs:comment
  • Uma conexão de banco de dados é uma facilidade em ciência da computação que permite que o software cliente comunique-se com o software do servidor de banco de dados, na mesma máquina ou não. Uma conexão é necessária para enviar comandos e receber respostas. Conexões são um conceito chave em programação de centro de dados. (pt)
  • 数据库连接(database connection)是数据库服务器与客户端之间的通信联系。客户通过数据库连接发送命令、接收服务器返回的结果。 IBM DB2, Microsoft SQL Server, Oracle, MySQL, PostgreSQL, 与使用连接池技术来改善性能。 建造连接时,通常要提供一个驱动程序或与一个。例如, <b>Server=</b>sql_box;<b>Database=</b>Common;<b>User ID=</b>uid;<b>Pwd=</b>password;. 一旦连接建立,它可以被打开、关闭、设置性质。 (zh)
  • A database connection is a facility in computer science that allows client software to talk to database server software, whether on the same machine or not. A connection is required to send commands and receive answers, usually in the form of a result set. Connections are a key concept in 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. (en)
rdfs:label
  • Database connection (en)
  • Conexão de banco de dados (pt)
  • 数据库连接 (zh)
owl:sameAs
prov:wasDerivedFrom
foaf:isPrimaryTopicOf
is dbo:wikiPageDisambiguates of
is dbo:wikiPageRedirects of
is dbo:wikiPageWikiLink of
is foaf:primaryTopic of
Powered by OpenLink Virtuoso    This material is Open Knowledge     W3C Semantic Web Technology     This material is Open Knowledge    Valid XHTML + RDFa
This content was extracted from Wikipedia and is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported License