Tabular Data Stream

Uses your system voice; voice and rate in settings.

Q7673637Snapshot

≈ 3 min read

Names in other languages

  • EnglishTabular Data Stream

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

Tabular Data Stream (TDS) is an application layer protocol used to transfer data between a database server and a client. It was initially designed and developed by Sybase Inc. for their Sybase SQL Server relational database engine in 1984, and later by Microsoft in Microsoft SQL Server.

Tabular Data Stream (TDS) is an application layer protocol used to transfer data between a database server and a client. It was initially designed and developed by Sybase Inc. for their Sybase SQL Server relational database engine in 1984, and later by Microsoft in Microsoft SQL Server.

History

During the early development of Sybase SQL Server, the developers at Sybase perceived the lack of a commonly accepted application level protocol to transfer data between a database server and its client. In order to encourage the use of its products, Sybase promoted the use of a flexible pair of libraries, called netlib and db-lib , to implement standard SQL. A further library was included in order to implement "Bulk Copy" called blk . While netlib 's job is to ferry data between the two computers through the underlying network protocol, db-lib provides an API to the client program, and communicates with the server via netlib . db-lib sends to the server a structured stream of bytes meant for tables of data, hence a Tabular Data Stream. blk provides, like db-lib , an API to the client programs and communicates with the server via netlib . In 1990 Sybase entered into a technology-sharing agreement with Microsoft which resulted in Microsoft marketing its own SQL Server — Microsoft SQL Server — based on Sybase's code. Microsoft kept the db-lib API and added ODBC (Microsoft has since added additional APIs). At about the same time, Sybase introduced a more powerful successor to db-lib , called ct-lib , and called the pair Open Client. db-lib , though officially deprecated, remains in widespread use. The TDS protocol comes in several versions, most of which had not been openly documented. This situation changed when Microsoft published the TDS specification in 20081, as part of the Open Specification Promise. TDS has both client and server implementations beyond Microsoft SQL Server and Sybase. The FreeTDS provides a free native-library client implementation of the TDS protocol, licensed under the GPL-2.0 license . Wireshark has a protocol decoder for TDS. CData and Invantive provide server implementations of the TDS protocol, bridging TDS to other data platforms than SQL Server.

Similar Protocols

Oracle Corporation provides Oracle Net - software analogous to TDS.

See also

Transact-SQL

References

External links

[MS-TDS]: Tabular Data Stream Protocol specification, Microsoft What is TDS?, sybase.com FreeTDS TinyTDS, Ruby bindings to FreeTDS. jTDS, a pure-Java JDBC driver for TDS databases jBCP, an extension of jTDS to include BCP protocols United States Patent 7318075: Enhanced tabular data stream protocol, Microsoft Patent: TRANSPORTING TABLE VALUED PARAMETER OVER TABULAR DATA STREAM PROTOCOL, Microsoft Patent application: COMPRESSING NULL COLUMNS IN ROWS OF THE TABULAR DATA STREAM PROTOCOL, Microsoft WireShark wiki: Protocol tds

Text derived from https://en.wikipedia.org/w/index.php?oldid=1351007744 under CC BY-SA 4.0; modifications have been made.

References

  1. ↩Wikipedia publication date (×1) · confidence 0.95 https://en.wikipedia.org/w/index.php?oldid=1351007744

Provenance

snapshot tabular-data-stream-862619-3b9df2bf6caaae19 · hash 3b9df2bf6caaae19d218330f3e671028b60a98b75cad3ac0f0a384655e3c3431 · captured 1777109512.0 · version history

Cite this page as: encyclopegia.org, “Tabular Data Stream”, snapshot tabular-data-stream-862619-3b9df2bf6caaae19. https://encyclopegia.org/a/tabular-data-stream