Skip to content

Commit a0e561a

Browse files
committed
SQLML: Updating architecture diagrams and content
1 parent 8c3abf8 commit a0e561a

4 files changed

Lines changed: 3 additions & 28 deletions

File tree

docs/language-extensions/concepts/extensibility-framework.md

Lines changed: 3 additions & 28 deletions
Original file line numberDiff line numberDiff line change
@@ -39,45 +39,24 @@ The architecture is designed such that external code run in a separate process f
3939

4040
***Component architecture in Linux***
4141

42-
Components include a **Launchpad** service used to invoke language-specific launchers (for example, Java), language, and library-specific logic for loading interpreters and libraries. The Launcher loads a language run time, plus any proprietary modules.
42+
Components include a **Launchpad** service used to invoke external runtimes (for example, Java), language, and library-specific logic for loading interpreters and libraries.
4343

4444
<a name="launchpad"></a>
4545

4646
## Launchpad
4747

48-
The [!INCLUDE[rsql_launchpad_md](../../includes/rsql-launchpad-md.md)] is a service that manages and executes external scripts, similar to the way that the full-text indexing and query service launches a separate host for processing full-text queries. The Launchpad service can start only trusted launchers that are published by Microsoft, or that have been certified by Microsoft as meeting requirements for performance and resource management.
48+
The [!INCLUDE[rsql_launchpad_md](../../includes/rsql-launchpad-md.md)] is a service that manages the life-time, resources, and security boundaries of the external process that’s responsible for script execution. This is similar to the way that the full-text indexing and query service launches a separate host for processing full-text queries. The Launchpad service can start only trusted launchers that are published by Microsoft, or that have been certified by Microsoft as meeting requirements for performance and resource management.
4949

5050
| Trusted launchers | Extension | SQL Server versions |
5151
|-------------------|-----------|---------------------|
5252
| JavaLauncher.dll for Java | Java extension | SQL Server 2019 |
5353

54-
The [!INCLUDE[rsql_launchpad_md](../../includes/rsql-launchpad-md.md)] service runs under **SQLRUserGroup**. which uses [AppContainers](https://docs.microsoft.com/windows/desktop/secauthz/appcontainer-isolation) for execution isolation.
54+
The [!INCLUDE[rsql_launchpad_md](../../includes/rsql-launchpad-md.md)] service runs under **SQLRUserGroup** which uses [AppContainers](https://docs.microsoft.com/windows/desktop/secauthz/appcontainer-isolation) for execution isolation.
5555

5656
A separate [!INCLUDE[rsql_launchpad_md](../../includes/rsql-launchpad-md.md)] service is created for each database engine instance to which you have added SQL Server Machine Language Extensions. There is one Launchpad service for each database engine instance, so if you have multiple instances with external script support, you will have a Launchpad service for each one. A database engine instance is bound to the Launchpad service created for it. All invocations of external script in a stored procedure or T-SQL result in the SQL Server service calling the Launchpad service created for the same instance.
5757

5858
To execute tasks in a specific supported language, the Launchpad gets a secured worker account from the pool, and starts a satellite process to manage the external runtime. Each satellite process inherits the user account of the Launchpad and uses that worker account for the duration of script execution. If script uses parallel processes, they are created under the same, single worker account.
5959

60-
## BxlServer and SQL Satellite
61-
62-
**BxlServer** is an executable provided by Microsoft that manages communication between SQL Server and the external language. It creates the Windows job objects that are used to contain external script sessions, provisions secure working folders for each external script job, and uses SQL Satellite to manage data transfer between the external runtime and SQL Server. If you run [Process Explorer](https://technet.microsoft.com/sysinternals/processexplorer.aspx) while a job is running, you might see one or multiple instances of BxlServer.
63-
64-
In effect, BxlServer is a companion to a language run time environment that works with SQL Server to transfer data and manage tasks. BXL stands for Binary Exchange language and refers to the data format used to move data efficiently between SQL Server and external processes.
65-
66-
**SQL Satellite** is an extensibility API, included in the database engine starting with SQL Server 2016, that supports external code or external runtimes implemented using C or C++.
67-
68-
BxlServer uses SQL Satellite for these tasks:
69-
70-
+ Reading input data
71-
+ Writing output data
72-
+ Getting input arguments
73-
+ Writing output arguments
74-
+ Error handling
75-
+ Writing STDOUT and STDERR back to client
76-
77-
SQL Satellite uses a custom data format that is optimized for fast data transfer between SQL Server and external script languages. It performs type conversions and defines the schemas of the input and output datasets during communications between SQL Server and the external script runtime.
78-
79-
The SQL Satellite can be monitored by using windows extended events (xEvents).
80-
8160
## Communication channels between components
8261

8362
Communication protocols among components and data platforms are described in this section.
@@ -86,10 +65,6 @@ Communication protocols among components and data platforms are described in thi
8665

8766
By default, internal communications between SQL Server and the SQL Satellite use TCP/IP.
8867

89-
+ **Named Pipes**
90-
91-
Internal data transport between the BxlServer and SQL Server through SQL Satellite uses a proprietary, compressed data format to enhance performance. Data is exchanged between language run times and BxlServer in BXL format, using Named Pipes.
92-
9368
+ **ODBC**
9469

9570
Communications between external data science clients and a remote SQL Server instance use ODBC. The account that sends the script jobs to SQL Server must have both permissions to connect to the instance and to run external scripts.
-1.76 KB
Loading
-1.07 KB
Loading
-20.9 KB
Binary file not shown.

0 commit comments

Comments
 (0)