Service Broker
E56724
Service Broker is a SQL Server feature that provides native support for reliable, asynchronous messaging and queuing within database applications.
All labels observed (1)
| Label | Occurrences |
|---|---|
| Service Broker canonical | 2 |
How this entity was disambiguated
This entity first appeared as the object of triple T452338 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: Service Broker Context triple: [SQL Server, supportsFeature, Service Broker]
-
A.
Support Services Bureau
The Support Services Bureau is a division of the New York City Police Department responsible for providing logistical, technical, and administrative support that enables the agency’s operational and investigative functions.
-
B.
Provider Bridging
Provider Bridging is an IEEE 802.1 network technology that extends Ethernet to support scalable, VLAN-based traffic separation and forwarding across large carrier or provider networks.
-
C.
Service Committee
The Service Committee is a key administrative body within Jehovah’s Witnesses responsible for coordinating and directing various aspects of the religion’s organizational and evangelizing activities.
-
D.
Enterprise Hub
Enterprise Hub is a Royal Academy of Engineering initiative that supports and accelerates UK engineering and technology entrepreneurs through funding, mentoring, and business development resources.
-
E.
Support Services Division
The Support Services Division is a unit within the Multnomah County Sheriff’s Office that provides administrative, logistical, and technical support to enable the agency’s law enforcement and public safety operations.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: Service Broker Target entity description: Service Broker is a SQL Server feature that provides native support for reliable, asynchronous messaging and queuing within database applications.
-
A.
Support Services Bureau
The Support Services Bureau is a division of the New York City Police Department responsible for providing logistical, technical, and administrative support that enables the agency’s operational and investigative functions.
-
B.
Provider Bridging
Provider Bridging is an IEEE 802.1 network technology that extends Ethernet to support scalable, VLAN-based traffic separation and forwarding across large carrier or provider networks.
-
C.
Service Committee
The Service Committee is a key administrative body within Jehovah’s Witnesses responsible for coordinating and directing various aspects of the religion’s organizational and evangelizing activities.
-
D.
Enterprise Hub
Enterprise Hub is a Royal Academy of Engineering initiative that supports and accelerates UK engineering and technology entrepreneurs through funding, mentoring, and business development resources.
-
E.
Support Services Division
The Support Services Division is a unit within the Multnomah County Sheriff’s Office that provides administrative, logistical, and technical support to enable the agency’s law enforcement and public safety operations.
- F. None of above. chosen
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server feature
ⓘ
messaging framework ⓘ |
| benefit |
decouples application components
ⓘ
improves scalability of database applications ⓘ reduces need for custom messaging infrastructure ⓘ supports long-running workflows ⓘ |
| componentOf |
SQL Server Database Engine
ⓘ
linked to:
SQL Server
|
| configuredBy |
ALTER DATABASE SET ENABLE_BROKER
ⓘ
CREATE CONTRACT statement ⓘ CREATE MESSAGE TYPE statement ⓘ CREATE QUEUE statement ⓘ CREATE ROUTE statement ⓘ CREATE SERVICE statement ⓘ |
| domain | database applications ⓘ |
| implementedAs |
T-SQL DDL and DML statements
ⓘ
database objects ⓘ |
| introducedIn |
SQL Server 2005
ⓘ
linked to:
SQL Server
|
| providedBy |
Microsoft SQL Server
ⓘ
linked to:
SQL Server
|
| purpose | enable reliable, asynchronous messaging within SQL Server databases ⓘ |
| requires |
Service Broker endpoint for cross-instance communication
ⓘ
database master key for dialog security ⓘ |
| supports |
asynchronous messaging
ⓘ
message queuing ⓘ reliable messaging ⓘ |
| supportsFeature |
activation of stored procedures
ⓘ
conversation groups ⓘ dialog security ⓘ distributed applications ⓘ exactly-once-in-order message delivery ⓘ internal and external activation ⓘ message retention in queues ⓘ poison message handling ⓘ routing between SQL Server instances ⓘ routing between databases ⓘ service-oriented database applications ⓘ transactional messaging ⓘ |
| typicalUseCase |
background processing and batch workloads
ⓘ
event-driven database applications ⓘ order processing systems ⓘ |
| uses |
sys.conversation_endpoints system view
ⓘ
sys.service_queues system view ⓘ sys.transmission_queue system view ⓘ |
| usesConcept |
contracts
ⓘ
conversations ⓘ endpoints ⓘ message queues ⓘ message types ⓘ routes ⓘ services ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: Service Broker Description of subject: Service Broker is a SQL Server feature that provides native support for reliable, asynchronous messaging and queuing within database applications.
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.