StratML Query Services StratML Query Service Development Team SQSDT Organization_61ca605a-471e-4d7a-86f3-23f218df8fe4 Naval Sarda Managing Director, EpiComm Technologies StratML Query Service Developer Naval is managing development of a StratML-enabled query service. Owen Ambur AboutThem.info Domain Owner Users can quickly and easily discover goals and objectives of interest to them Vision_a31fc1cc-809a-4d31-a0a0-26c5a980cbfb To develop a basic StratML query service Mission_a31fc1cc-809a-4d31-a0a0-26c5a980cbfb Usability Discoverability Utility Query/Discovery Enable faceted querying and discovery of discrete elements of StratML documents Goal_a404fc34-10af-41b0-89e1-4febfcbdb225 1 unnamed stakeholder [To be named] unnamed stakeholder unnamed stakeholder [To be named] unnamed stakeholder unnamed stakeholder Stakeholders Enable discovery of goals and objectives by stakeholder names and/or descriptions associated with them Objective_2e07a16b-70b7-42f1-ab3c-55d23c8eb2d7 1 unnamed stakeholder 1 Discovery via Stakeholders PerformanceIndicator_a3fbd7de-a7e0-4715-ba04-15e88e23724e 0 Discovery of goals and objectives by stakeholder names and/or descriptions associated with them 2023-03-29 0 Enabled Goals and objectives can be queried and discovered based upon the names of their stakeholders as well as the terms contained in the descriptions of those stakeholders. e4194330-240e-4276-ae9e-f20ddb97a1e9 Goals & Objectives Enable discovery of goals and objectives by their names and/or descriptions Objective_036514f2-00fe-4be0-8db1-acd2a7dc7ece 2 Since the only real distinction between goals and objectives is the timeline for producing the desired results, it may be suitable to query both at once. The goal/objective descriptions should be displayed in the query results listings. unnamed stakeholder 1 Goal/Objective Discovery PerformanceIndicator_fa4beabf-70e4-4473-9b6d-5848ffb63648 0 Discovery of goals and objectives by their names and/or descriptions 2023-03-29 0 Enabled Goals and objectives can be queried and discovered based upon their names as well as the terms contained in their descriptions. 6a57d58d-ba85-47fe-82da-8702680e1c56 Values Enable discovery of plans by the value (principles) names and/or descriptions contained within them Objective_1d532b85-b021-4166-a03c-9ab150c7489f 3 unnamed stakeholder 1 Values Discovery PerformanceIndicator_386322d2-345b-4678-bf31-4ac70a0ef71b 0 Discovery of plans by the value (principles) names and/or descriptions contained within them. 2023-02-06 0 Listing Created Using this feature, on February 6, 2023, Owen compiled a listing of values documented in the StratML collection sorted in order of frequency, at https://www.linkedin.com/pulse/values-goals-partnerships-owen-ambur/ 2023-03-23 0 Enabled Plans and reports can be discovered based upon the names and descriptions of values documented within them. 507d1966-6a5d-40bc-b73b-7b1b5a08fee5 Domains Enable discovery via website domains and subdomains. Objective_82e9aaa2-b3e5-44c1-9cb3-eca4059a2a9b 4 unnamed stakeholder 1 Discovery via Domain/Subdomain PerformanceIndicator_e13731bf-204a-49de-acfa-680444c3614b 0 Enabled Files can be queried based upon the domains and subdomains in which their original sources occur, and the URLs of the source documents are displayed in the query results listings. 0 Enable discovery of plans and reports as well as goals and objectives based upon the domains and subdomains of the organizations issuing them, as documented in the element. 0037cd5d-00aa-4887-b82e-c614725c76d2 False Positives Enable selective discovery of explicit words and phrases, excluding those of which they are only a part. Objective_1d2b9a57-3470-4695-8ddb-f0d3e06ac10c 5 Currently, the query service ignores white space and punctuation and thus delivers many text strings that are false positives. [To be named] 1 False Positives PerformanceIndicator_32085216-b731-455d-a67d-36d9b5bc0379 0 [To be determined] 0 Eliminated Reduce, if not eliminate false positives, e.g., by supporing exactly quoted text. 48c85320-cdc5-4231-98f7-1df3a34c74fe Boolean Operators Enable more precise and explicit queries using boolean operators Objective_c209c541-c9da-49ae-a2b4-9214ac76bfce 6 While this capability may be useful, it is not as important as reducing false positives. [To be named] 1 Boolean Operators PerformanceIndicator_d8b89379-02f2-491a-a9c7-6569de28662b 0 [To be determined] 0 Supported And, Or & Not operators are supported. 3d1d30a5-1974-4a26-b11e-2c056162498e Presentation Display in query results the elements necessary to enable users to identify those more relevant to their interests. Goal_2b567536-93ce-47f4-be08-4938e82cb429 2 Faceted query results should return direct links to the queried elements within the context of the documents in which they occur, wherever they reside on the Web. Besides those links, it may also be appropriate for the results listings to display the names of the relevant plans/reports and/or the names of the organizations issuing them. unnamed stakeholder unnamed stakeholder unnamed stakeholder unnamed stakeholder [To be named] unnamed stakeholder unnamed stakeholder Names & Descriptions Display the names and descriptions of the elements returned by the query Objective_90907520-ff7b-4eb0-a012-4ee9531d2254 1 unnamed stakeholder 1 Element Names & Descriptions PerformanceIndicator_414de993-5247-4216-bce7-056edcb7bd20 0 Display the names and descriptions of the elements returned by the query 2023-03-29 0 Essentially Accomplished For goal/objective queries, the descriptions are displayed, along with the names of the organizations. For stakeholder queries, the descriptions of the relevant goals/objectives are displayed. For values queries, the display is somewhat less predictable because they don't have identifiers that can be explicitly referenced. For full-text queries, the names of the organizations and their mission statements are displayed. 9a8777ff-3384-47e1-a1e2-260590a0ad2b Organizations Display the names of the organizations associated with the plans/reports in which the relevant elements appear Objective_a3512bf0-b699-46f2-b2a4-22b6bab88bbf 2 unnamed stakeholder 1 Organization Names PerformanceIndicator_5b0ef288-336e-4fee-8e4b-f044affc8ae8 0 Display the names of the organizations associated with the plans/reports in which the relevant elements appear 2023-03-29 0 Enabled The organization names appear in the search results listings. b50130a0-69ca-454d-a1ee-a926e1ec59ae Hyperlinks Provide direct links to each of the elements returned in the queries so that users can click to view them in context of the plans/reports in which they occur Objective_f8e3a0fa-275e-4d16-88a6-b0ab6242de20 3 The Identifiers should be leveraged to provide direct links to the queried goals and objectives in the search results listings. unnamed stakeholder 1 Direct Referencing PerformanceIndicator_cf690b2c-3c61-4c67-9d8f-a6d05ca2d448 0 Provide direct links to each of the elements returned in the queries so that users can click to view them in context of the plans/reports in which they occur 2023-03-29 0 Enabled By clicking on link icons in query results listings, users can jump directly to goal and objective statements in the plans and reports in which they occur. a4372839-50bc-429f-ae5c-f58718566744 CSV Enable output of query results in comma separated value (CSV) format for reuse in database applications. Objective_7a7f6aeb-9aa8-419d-86e4-5366597a8c5c 4 unnamed stakeholder 1 CSV Output PerformanceIndicator_e9e02e85-86c2-45a1-9d18-3cce14148a3a 0 [To be determined] 2024-03-23 0 Enabled Query results listings can be exported in CSV format. cddd0145-4300-4aef-9b1c-0e337f8abbb5 Query Results Enable sharing of hyperlinks that re-execute queries and deliver the current search results. Objective_b36eeecc-23eb-4221-9eba-d35e7fe0d622 5 [To be named] 1 Query Results PerformanceIndicator_6e4075f2-897f-4c74-a0b5-93feafbbc88e 0 [To be determined] 0 Enabled Links to query results can be shared. [The Start and End Dates for this result will be determined later.] 1281a8ec-3bf5-46d8-a203-d03b60b73ce0 Statistics Produce statistics from the data in the StratML collection. Objective_81886a33-b490-49de-8f72-d4298345ae4c 6 See, for example, the statistics formerly provided by Andre Cusson's StratML portal: https://web.archive.org/web/20221219063629/http://stratml.hyperbase.com/statistics.html unnamed stakeholder 1 Statistics PerformanceIndicator_a726bff7-df1b-4da8-996a-fb83c12727ff 0 Enabled Display statistics on the number of plans/reports, organizations, goals, objectives, and stakeholders documented in the StratML collection. [The Start and End Dates for this result will be determined later.] 0 Potential Requirement [To be determined] 607765c3-8fb8-4e99-bafd-9693038f741c Ingestion Support importation of StratML files, individually and in bulk. Goal_490b2373-9536-43dd-b5a0-3dac4c926fdf 3 [To be named] [To be named] [To be named] Bulk Upload Import the files currently in the StratML collection. Objective_009cc8de-c488-4dfb-a60f-d281e08d0b01 1 It would be good if the sitemap listing could be used to semi-automatically import the existing collection. https://stratml.us/sitemap.xml [To be named] 1 Files Imported Number PerformanceIndicator_93d96b43-544c-4421-b010-5cef1e40aca1 0 Import all 5,000+ files currently in the StratML collection. 2023-01-11 5544 Essentially Completed Most of the files listed in the sitemap were imported but several dozen seem to have been missed. As of January 11, 2023, 5,544 records were indexed as compared to 5,578 recorded by Joe Carmel's cataloguer on December 11, 2022. fc597979-3bab-4b0c-a921-644f9a1084ff Ad Hoc Importing Enable ad hoc importing of valid StratML files. Objective_85df0bb0-b523-46e3-833d-81ceccb7e248 2 Initially, site administrators must be able to import files for indexing in the query service. Beyond that, at some point it might make sense to provide the capability for unauthenticated users to provide the URLs for files to be imported along with their E-mail addresses for confirmation of their submissions. If the submitted files validate against the StratML schema and the submitter's E-mail addresses match those in the submitted files, they probably should be approved for importation into the query service. However, if submission of inappropriate content proves to be a problem, it may be necessary to take additional measures to vet the submissions. [To be named] 1 Import Capability PerformanceIndicator_e85b16a1-c38e-42a7-b751-9dcc427390c5 0 Potential Requirement Enable importation via a URL submission field on the search.aboutthem.info site. [The Start & End Dates for this potential result will be determined later.] 0 Availability Enable importation of additional files based upon their URLs. 2023-03-17 0 Enabled Initially, files could be imported via FTP, but that process did not capture the URLs. On March 13, 2023, the capability to import files from their URLs listed in sitemap format was successfully tested. 3440526e-dca3-41b5-a2e8-560b374c3497 Technical Requirements Specify the technical objectives and milestones to deliver the desired capabilities Goal_b19945a5-5dda-4bb3-83cc-e3c797f41e47 4 [To be named] MochaHost Website Hosting [To be named] Israel Condon Wire Frame Developer Israel has compiled wire frame views depicting simple query and results screens Naval Sarda Database Selection Naval has proposed using BaseX and has imported StratML files into it. unnamed stakeholder Naval Sarda Wire Frame Developer Naval has compiled wire frame views depicting simple and advanced query and results screens User Interface Clearly depict the layout of the user interface screens Objective_7438f004-73c2-4314-b581-39552114ffc8 1 Israel Condon Wire Frame Developer Israel has compiled wire frame views depicting simple query and results screens Naval Sarda Wire Frame Developer Naval has compiled wire frame views depicting simple and advanced query and results screens 1 Wireframes PerformanceIndicator_7cb5685e-48e7-45cb-b25d-1f11f7a6954f 0 Completed The wireframes were provided. 0 Produce wireframes showing how the query and results screens will be displayed ad1e237f-1026-4426-a59c-bafc813a468d Database Select a database Objective_4774c06a-1ebb-45bf-92a3-cd6d92a9a73b 2 Naval Sarda Database Selection Naval has proposed using BaseX and has imported StratML files into it. 1 Database PerformanceIndicator_bc2cc027-e18f-465b-b2db-c16700c695bd 0 Selected & Implemented BaseX was selected because it is a native XML, NoSQL database. 0 Determine which database may be most appropriate to use and document why. 5e4fc134-f725-4e47-976d-3de6d0c7ef7d Domain Determine whether there may be any reason to use a different domain(s) Objective_032dd759-60a7-4c7d-a7a7-6fd12c55ac92 3 unnamed stakeholder 1 Domain PerformanceIndicator_c0c2aed2-890f-478c-ab13-fcdbc7ab9adb 0 Determine which domain(s) to use. 0 The aboutthem.info and connectedcommunity.net domains are available as sites for the query service 0 New Subdomain Created In order to enable Owen Ambur to continue maintaining the text and graphics on the aboutthem.info site, it was necessary to create a subdomain -- search.aboutthem.info -- for the war/jar file for the query service. 4abd6a5d-946b-46fc-ac8c-102e16ab347d Hosting Hosting Objective_678518ab-8761-4d66-a8fe-c5a5a77c8052 4 MochaHost Website Hosting 1 Hosting PerformanceIndicator_89e808f9-783a-47e4-803c-26d55f2401c2 0 The stratml.us, aboutthem.info and connectedcommunity.net domains are currently hosted by MochaHost. https://www.mochahost.com/ 0 Determine whether the existing hosting service is adequate 2022-11-05 0 VPS Acquired Naval determined that it would be necessary to acquire VPS service to support the query service. On November 11, 2022, Owen acquired it from his hosting service, MochaHost. a23d0674-8657-44db-9c9a-6ca2ffb22e48 Documentation Document the software programming logic and supporting requirements in the event that others may wish to enhance and extend StratML-enabled query services. Objective_62db1c76-1459-4542-a75c-c3b7649c6482 5 [To be named] 1 Documentation PerformanceIndicator_dde2504a-a5d9-4761-8c58-14c8c9086d10 0 Provided Sufficient documentation is provided to enable other developers to reuse the software programming code. [The Start and End Dates for this potential result will be determined later.] 0 Potential Requirement [To be determined] cf3a9e52-4b89-4fd0-aad8-543e995f03db StrategyPlan_a31fc1cc-809a-4d31-a0a0-26c5a980cbfb 2022-09-22 2025-12-24 https://www.stratnavapp.com/StratML/Part2/a31fc1cc-809a-4d31-a0a0-26c5a980cbfb/Styled Submitter_a31fc1cc-809a-4d31-a0a0-26c5a980cbfb Owen Ambur