Users do not directly connect to SQL Server and its analytics tools, but through the separate client, applications connect to the data. These applications connect to SQL Server using:
Transaction -SQL
This language is a version of Structure Query Language (SQL)It is the main language used by SQL Server.
XML _
This format returns data from queries and stored procedures using URLs and templates over HTTP XML can also be used to insert, delete and update data in databases.
Distributed management of MDX objects
Enables the definition of distributed management modes for objects, queries, and multidimensional data manipulation in OLAP data analysis databases.
OLE DB interfaces and ODBC
Client applications use the Object Linking and Embedding Database (OLE DB) interface. Open Database Connectivity (ODBC), via the communication interfaces of programs and programming languages that enable sending commands to databases using Transaction-SQL.
ActiveX Data Objects (ADO)
Enable ActiveX objects to use OLE DB objects' linking and embedding property programming languages such as Microsoft Visual Basic Active Server Pages (ASP)
Microsoft Internet Explorer Visual Basic Scripts.
Using ADO ActiveX Objects To access OLTP databases uses ActiveX Multidimensional objects to access data analysis services and data cubes.
English Query
They are applications that provide an application interface that enables users to ask questions (verbally) in English instead of writing complex queries to databases that are answered in spoken language. For example, questions such as“ What are the total sales in region 1?”.
Client -Server Component
SQL Server consists of a set of server and client components to store and retrieve data. SQL Server uses communication layers to isolate applications from the network layer and protocols, and they can build from packages and install the same application in different network environments.
Client-Server Architecture
SQL server uses a client-server architecture to separate the workload of tasks on server machines and those on client machines.
- The customer is responsible for the business logic and provides data to the user, and the client's tasks can be simulated on more than one computer and it can also work on a server other than the SQL Server server.
- SQL Server manages databases on the server and there are resources such as memory network bandwidth and disk operations during multiple requests.
The client-server building enables the design, package, and installation of applications in different environments. Programming client interfaces provide the means to enable applications to work on separate client devices connected to the server through the network.