# US 12,222,955 B2 · Method for automated query language expansion and indexing > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 12,222,955 B2 - Document ID: US12222955B2 - Status: Granted - Kind: B2 - Application number: 18/537,362 - Filed: 2023-12-12 - Published: 2024-05-30 - Granted: 2025-02-11 - Earliest claimed: 2019-06-25 - Assignees: Sisense SF, Inc. - Applicants: Sisense SF, Inc. - Inventors: Steven Griffith; Ilge Akkaya; Audrey McGowan; Chris Tice; Jason Freidman; Jeff Watts - Web page: https://patentgrep.com/patent/US12222955B2 ## CPC - G06F 16/258: {Data format conversion from or to a database} - G06F 16/2228: {Indexing structures} - G06F 16/2433: {Query languages} - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract In an embodiment, a query system sends compact code to a database service for expansion of the compact code to partially-expanded code and expanded code. In an embodiment, a hash value is generated based on the partially-expanded code and indexed in memory with the expanded code. In an embodiment, a hash value is received as part of a command and expanded code is identified based on the hash value and sent to a database service. ## Claims ### Claim 1 A method for indexing, comprising: sending a compact code to an expansion system, wherein the expansion system is configured to create a first hash value based on a tokenized code, wherein the tokenized code is created by replacing at least one portion of the compact code with at least one token, wherein the expansion system is further configured to cause the first hash value and a first expanded code to be added to an index, wherein the first expanded code corresponds to the compact code; and causing a second hash value to be sent to the index, wherein the expansion system is configured to look up a second expanded code in the index based on the second hash value. ### Claim 2 (depends on 1) The method of claim 1, wherein causing the second hash value to be sent to the index further comprises sending the second hash value to the index. ### Claim 3 (depends on 1) The method of claim 1, wherein causing the second hash value to be sent to the index further comprises sending the compact code to the expansion system, wherein the expansion system is configured to partially expand the compact code to a partially-expanded code, wherein the partially-expanded code includes at least a first occurrence of a string that is expanded to an expanded string and at least a second occurrence of the string that is not expanded to the expanded string, wherein the expansion system is further configured to generate the second hash value based on the partially-expanded code, wherein the expansion system is further configured to send the second hash value to the index. ### Claim 4 (depends on 1) The method of claim 1 further comprising: sending a request for confirmation that the second hash value was received by the index. ### Claim 5 (depends on 1) The method of claim 1 further comprising: receiving the second expanded code, wherein the second expanded code is returned by the index in response to the second hash value being sent to the index. ### Claim 6 (depends on 1) The method of claim 1, wherein the expansion system is a first system, wherein the second expanded code is transmitted to a second system, wherein the second system executes the second expanded code. ### Claim 7 (depends on 1) The method of claim 1, further comprising: generating the first expanded code based on the tokenized code, wherein the generated first expanded code is added to the index with the first hash value. ### Claim 8 (depends on 7) The method of claim 7, wherein the first expanded code is generated by at least replacing each of the at least one token in the tokenized code with a respective expanded string of at least one expanded string. ### Claim 9 (depends on 8) The method of claim 8, wherein each of the at least one expanded string corresponds to a computer architecture. ### Claim 10 Computer-readable storage media for transferring data from a source repository to a target repository having computer-executable instructions embodied thereon, wherein, when executed by at least one processing circuitry, the computer-executable instructions cause the at least one processing circuitry to: sending a compact code to an expansion system, wherein the expansion system is configured to create a first hash value based on a tokenized code, wherein the tokenized code is created by replacing at least one portion of the compact code with at least one token, wherein the expansion system is further configured to cause the first hash value and a first expanded code to be added to an index, wherein the first expanded code corresponds to the compact code; and causing a second hash value to be sent to the index, wherein the expansion system is configured to look up a second expanded code in the index based on the second hash value. ### Claim 11 A system for indexing, comprising: a processing circuitry; and a memory, the memory containing instructions that, when executed by the processing circuitry, configures the system to: send a compact code to an expansion system, wherein the expansion system is configured to create a first hash value based on a tokenized code, wherein the tokenized code is created by replacing at least one portion of the compact code with at least one token, wherein the expansion system is further configured to cause the first hash value and a first expanded code to be added to an index, wherein the first expanded code corresponds to the compact code; and cause a second hash value to be sent to the index, wherein the expansion system is configured to look up a second expanded code in the index based on the second hash value. ### Claim 12 (depends on 11) The system of claim 11, wherein the system is further configured to send the second hash value to the index. ### Claim 13 (depends on 11) The system of claim 11, wherein the system is further configured to send the compact code to the expansion system, wherein the expansion system is configured to partially expand the compact code to a partially-expanded code, wherein the partially-expanded code includes at least a first occurrence of a string that is expanded to an expanded string and at least a second occurrence of the string that is not expanded to the expanded string, wherein the expansion system is further configured to generate the second hash value based on the partially-expanded code, wherein the expansion system is further configured to send the second hash value to the index. ### Claim 14 (depends on 11) The system of claim 11, wherein the system is further configured to” send a request for confirmation that the second hash value was received by the index. ### Claim 15 (depends on 11) The system of claim 11, wherein the system is further configured to: receive the second expanded code, wherein the second_expanded code is returned by the index in response to the second hash value being sent to the index. ### Claim 16 (depends on 11) The system of claim 11, wherein the expansion system is a first system, wherein the second expanded code is transmitted to a second system, wherein the second system executes the second expanded code. ### Claim 17 (depends on 11) The system of claim 11, wherein the system is further configured to: generate the first expanded code based on the tokenized code, wherein the generated first expanded code is added to the index with the first hash value. ### Claim 18 (depends on 17) The system of claim 17, wherein the first expanded code is generated by at least replacing each of the at least one token in the tokenized code with a respective expanded string of at least one expanded string. ### Claim 19 (depends on 18) The system of claim 18, wherein each of the at least one expanded string corresponds to a computer architecture.