SQL Server Platforms Definitions
-
A
application server
An application server is a server program in a computer in a distributed network that provides the business logic for an application program.
-
C
comma-separated values file (CSV)
In computers, a CSV (comma-separated values) file contains the values in a table as a series of ASCII text lines organized so that each column value is separated by a comma from the next column's value and each row starts a new line.
-
D
database management system (DBMS)
If the database is a file of information, then the DBMS is the file folders, the file labels and the file cabinet.
-
DDBMS (distributed database management system)
A DDBMS (distributed database management system) is a centralized application that manages a distributed database as if it were all stored on the same computer.
-
E
entity-relationship model (ERM or ER model)
The entity-relationship model (or ER model) is a way of graphically representing the logical relationships of entities (or objects) in order to create a database.
-
F
Fast Guide: SQL Server 2000 commands
Here are ten commands you need to know!
-
flat file
A flat file contains records that have no structured interrelationship. A flat file typically consists of a text file, from which all word processing or other structure characters or markup have been removed.
-
full-text database
A full-text database is a compilation of documents or other information in the form of a database in which the complete text of each referenced document is available for online viewing, printing, or downloading. In addition to text documents, images are often included, such as graphs, maps, photos, and diagrams. A full-text database is searchable by keyword, phrase, or both.
-
I
information
Information is stimuli that has meaning in some context for its receiver.
-
intelligent database
An intelligent database is a full-text database that employs artficial intelligence (AI), interacting with users to ensure that returned items (hits) contain the most relevant information possible. This is in contrast to a traditional database, which is searchable only by keywords and verbatim phrases connected by Boolean operations such as AND, OR, and NOT. Intelligent database technology is in its infancy, and is evolving as AI becomes more advanced.
-
M
Microsoft Azure Cosmos DB
Azure Cosmos DB is a Microsoft cloud database that supports multiple ways of storing and processing data. As such, it is classified as a multimodel database.
-
Microsoft SQL Server Management Studio (SSMS)
Microsoft SQL Server Management Studio (SSMS) is an integrated environment to manage a SQL Server infrastructure.
-
O
OLE DB (OLEDB or Object Linking and Embedding Database)
OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources.
-
S
Microsoft SQL Server
Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments
-
Y
Yukon
Yukon is the code name used for the beta version of Microsoft's SQL Server 2005. SQL Server 2005 is said to provide enhanced flexibility, scalability, reliability, and security to database applications, and to make them easier to create and deploy, thus reducing the complexity and tedium involved in database management.