Database Search
Free TrialThere are many ways to search for data in Sentinel Visualizer.
From the Home Page
- Search for Entities
- Search for Relationships
- Search for Entities and Relationships based on their connections or lack of connections to each other (Dataset Builder and Advanced Dataset Builder)
Home Page Panel
Search Menu
You can then view the list of results, open the details on individual ones, export the list to Excel, and send them to the Visualizer to see them on the link analysis diagram for further analysis.
From the Visualizer Diagram
Once you send data to the Visualizer Diagram, you can perform additional searches and filters:
- Add Entities by searching for them
- Find an entity (Ctrl+F) based on its name
- Data Refinement to select or keep entities and relationships
- Get Links to add new Entities limited by the Data Refinement criteria
Visualizer Toolbar
Entity and Relationship Data Refinement
Visualizer Toolbar: Get Links to Add Entities
Entity Search displays the recent list of entities with options to send them to the Visualizer, view their details, generate reports, and export to Excel. The Name search is quick and easy on the main form. The Advanced button offers more detailed options.
Entity Search: Most Recently Used Entities
The Entity Search form opens with your most recent ones so you can select them immediately.
The bottom toolbar offers options for the selected entities.
Entity Name Search
Enter a search term to list the Entities with that name.
The search also finds aliases and other metadata values.
Entity Advanced Search: General Tab
The Advanced button offers more detailed search options.
Search text and blank/non-blank values, select entity types, specify numeric and date ranges, and more.
Entity Advanced Search: Metadata/Lookups Tab
The Metadata/Lookups Tab lets you select Metadata and Lookup values.
Metadata values can be limited to a specific entity type. Up to 3 metadata values using AND or OR.
On the Visualizer, Add Entities uses the same process for finding the entities to add to your diagram.
Entity Refinement uses the same Advanced features to limit the entities on the Diagram and Get Links.
Relationship Search displays the recent list of relationships with options to send them to the Visualizer, view their details, generate reports, and export to Excel. Searching based on an entity is on the main form. The Advanced button offers more detailed options.
Relationship Search: Most Recently Used Relationships
The Relationship Search form opens with your most recent ones so you can select them immediately.
The bottom toolbar offers options for the selected relationships.
Relationship Search by Entity
Select an Entity and find all the Relationships with it.
A relationship has two entities with a relationship type between them.
Relationship Advanced Search: General Tab
The Advanced button offers more search options. Find an entity for either or both sides of relationships. Search for blank/non-blank values, relationship types, numeric and date ranges, and more.
Relationship Advanced Search: Metadata/Lookups Tab
The Metadata/Lookups Tab lets you select Metadata and Lookup values. Metadata values can be limited to a specific relationship type. Up to 3 metadata values using AND or OR.
On the Visualizer, Relationship Refinement uses the same Advanced features to limit the entities on the Diagram and Get Links.
The Dataset Builder lets you select entities and relationships based on their relationships to each other.
The Dataset Builder Form displays options with increasing refinement.
Dataset Builder Form
The number of entities and relationships for each option are shown in parenthesis. Selecting any of the first 4 options sends the data to the Visualizer diagram.
Easily select the entities and relationships by type, and how they are linked or not linked to each other. You can choose one or more Entity Types and Relationship Types:
Filter by Entity and Relationship Types Form
The last option, Advanced, launches the Advanced Dataset Builder Wizard which offers more options for selecting entities and relationships. It includes the Advanced features of Entity Search and Relationship Search to find names, numeric and date range values, and document text content.
Select the Options
Decide if entities and relationships are filtered, how they are linked, and result options.
Selections here determine the following pages in the Wizard.
Filter Entities
Specify entity name, types, values, and ranges for numeric and date fields. Autofill with [Retrieve Ranges]. A second tab filters on metadata and lookup values.
Filter Relationships
Specify entities, relationship types, values, and ranges for numeric and date fields. Autofill with [Retrieve Ranges]. A second tab filters on metadata and lookup values.
Dataset Builder Results
See the lists of entities and relationships that passed the Wizard with options to send them to Visualizer, view them in detail, export to Excel, and more.
Display in Visualizer Diagram
See the results on the Visualizer Diagram with options to calculate Social Network Analysis (SNA) metrics, filter the data, examine networks and cliques, find shortest paths, apply color gradients, sizes and other analytics.
Searches for entities and relationships can be saved. Under Search, [Combine Multiple Searches] lets you select and perform analysis among them.
Unlike saved Visualizer Diagrams which save specific items, saved searches are applied against your current database, so its results change with your data. Combine multiple filters to show their Entities and Relationships.
For instance, you may have saved a search for each crime scene selecting entities around a particular location and time. As your database is updated, each search retrieves new results. Wouldn’t it be interesting to find entities that appeared at all or most of the crime scenes?
After selecting the saved searches, choose the Common Data options:
- Every Search: Find Entities and Relationships that are in every selected search. These are the highest value targets.
- Two or More Searches: Entities that are in at least two of the searches.
- Most Searches: Determine the maximum number of selected filters that an entity is found and show those. For instance, 10 filters are selected, but no Entities are in all 10. Sentinel Visualizer finds that the most filters an entity is in is 7, so it shows the entities (and relationships) that are in 7.
The Query Builder is another feature to find entities and relationships in your database. Visually "draw" a query and specify entity and relationship criteria including metadata. View the results and send them to the Visualizer, reports, Excel, etc.
Example of finding Female Blondes who Made Returns at Stores in 2023 or later
Your selections can be saved for future use and optionally shared with others in your database.
Microsoft Certified Partner
Partners Welcome
Do you provide services to government and commercial customers seeking analytic solutions?
Contact us
In-Q-Tel Portfolio Company
Discover
Sentinel Visualizer Comparison to Harris/IBM's i2 Analyst's Notebook