Apparatuses, methods and systems for a descriptive business grammar syntax querier
View Patent ↗The APPARATUSES, METHODS AND SYSTEMS FOR A DESCRIPTIVE BUSINESS GRAMMAR SYNTAX QUERIER (“QUERIER”) implement efficient and scalable monitoring, regulation, and allocation of computational processing, data, labor, and/or the like resources within an enterprise. The Querier may include facilities for basal tagging to associate entities, employees, transactions, projects and/or assignments, and/or the like business data with various tables in an enterprise database, and the implementation of a descriptive business grammar to access, search, store, manipulate, modify and/or the like stored business data. The Querier allows for engagement of descriptive business grammar phraseology for accessing, querying, viewing and/or creating associations for data in a database, tailoring rules, managing and/or allocating enterprise resources, and/or the like.
1. A database interfacing processor-implemented method, comprising:
receiving an input string having a plurality of syntax tokens arranged in accordance with a syntax grammar format and following business grammar rules for the arrangement of a plurality of data and application identifying items in at least one database, wherein each of said plurality of syntax tokens in the input string relates to at least one of a plurality of inter-linked table objects in a database, each inter-linked table object containing a table object identifier and an additional business grammar information related to said table object, wherein said plurality of inter-linked table objects are interconnected based on the business grammar rules for the plurality of data and application identifying items in at least one database;
determining whether a dynamic or static string token parsing of the input string should be utilized;
determining syntax grammar format based on the context in which the input string was received and whether the dynamic or static token parsing is required;
parsing the input string for each syntax token based on the syntax grammar;
generating a database command from a composite of the parsed syntax tokens; and
transacting command-specified data retrieval from the database using the database command.
2. The method of claim 1 , further comprising:
generating the plurality of inter-linked table objects in the database.
3. The method of claim 1 , wherein the database command comprises a database selection command, and wherein transacting further comprises:
querying the database system with the selection command; and
retrieving command-specified data based on the querying.
4. The method of claim 3 , further comprising: providing the command-specific data to at least one target.
5. The method of claim 4 , wherein the at least one target comprises a receiving application.
6. The method of claim 4 , wherein the input string is received from the target.
7. The method of claim 3 , wherein the database selection command comprises a structured query language select command.
8. The method of claim 1 , wherein the database command comprises a database insertion command, and further comprising:
receiving insertable data values in association with the input string;
wherein transacting further comprises:
submitting the insertion command including the insertable data values to the database system to store the data values in tables of the database system.
9. The method of claim 8 , wherein the database insertion command comprises a structured query language insert command.
10. The method of claim 1 , wherein the syntax grammar format comprises a string of delimited syntax tokens, and wherein each syntax token of the input string corresponds to a table identifier for at least one of the plurality of inter-linked table objects, wherein a plurality of said inter-linked table objects are interconnected based on the hierarchically-structured business grammar arrangement for the plurality of data and application identifying items in at least one database.
11. The method of claim 10 , wherein parsing the input string for each syntax token further comprises parsing table identifiers corresponding to syntax tokens in the input string based on delimiters in the input string.
12. The method of claim 1 , wherein syntax tokens of the input string include:
a client identifier;
a country identifier;
a vertical market identifier;
a business type identifier; and
a description.
13. The method of claim 1 , wherein syntax tokens are selected from the group consisting of:
a function;
a sub-function;
a country identifier;
a location identifier;
a vertical market identifier;
a business type identifier;
a client name; and
a team name.
14. The method of claim 1 , wherein the input string is generated in response to selection of string tokens in a graphical user interface.
15. The method of claim 14 , wherein the string tokens are placed in a hierarchical arrangement in the graphical user interface, and the string token is configured in accordance with the hierarchical arrangement.
16. A database interfacing-processor-implemented method, comprising:
generating a plurality of inter-linked table objects in a database, wherein each inter-linked table object contains a table object identifier and an additional business grammar information related to the table object, wherein said inter-linked table objects are interconnected based on business grammar rules for the plurality of data and application identifying items in at least one database;
receiving an input string having a plurality of syntax tokens arranged in accordance with a syntax grammar format and following business grammar rules for the arrangement of a plurality of data and application identifying items in at least one database, wherein each of said plurality of syntax tokens in the input string relates to at least one of a plurality of inter-linked table objects in a database, each inter-linked table object containing a table object identifier and an additional business grammar information related to said table object;
determining whether a dynamic or static string token parsing of the input string should be utilized;
determining syntax grammar format based on the context in which the input string was received and whether the dynamic or static token parsing is required;
parsing the input string for each syntax token based on the syntax grammar;
generating a database selection command from a composite of the parsed syntax tokens and business grammar information;
querying the database with the selection command;
retrieving grammar responsive data based on the querying; and
providing the grammar responsive data to at least one receiving application.
17. The method of claim 16 , wherein the input string is received from the at least one receiving application.
18. The method of claim 16 , wherein the syntax grammar format comprises a string of delimited syntax tokens, and wherein each syntax token corresponds to a table identifier for at least one each of the plurality of inter-linked table objects.
19. The method of claim 18 , wherein parsing the input string for each syntax token further comprises parsing table identifiers corresponding to syntax tokens in the input string based on delimiters in the input string.
20. A database interfacing-processor implemented method, comprising:
generating an input string having a plurality of syntax tokens arranged in accordance with a syntax grammar format and following business grammar rules for the arrangement of a plurality of data and application identifying items in at least one database, wherein each of said plurality of syntax tokens in the input string relates to at least one of a plurality of inter-linked table objects in a database, each inter-linked table object containing a table object identifier and an additional business grammar information related to said table object, wherein said inter-linked table objects are interconnected based on the business grammar rules for the plurality of data and application identifying items in the at least one database;
determining whether a dynamic or static string token parsing of the input string should be utilized;
determining syntax grammar format based on the context in which the input string was received and whether the dynamic or static token parsing is required;
parsing the input string for each syntax token based on the syntax grammar;
providing the data and application identifying items to a database management system associated with at least one the database; and
transacting data with the database based on the provided data and application identifying items.
21. The method of claim 20 , wherein transacting further comprises:
receiving the data stored in the database from the database management system.
22. The method of claim 20 , wherein transacting further comprises:
instructing provision of the data stored in the database to a third party system.
23. The method of claim 20 , further comprising:
providing a database command instruction to the database management system in association with the input string.
24. The method of claim 23 , wherein the database command instruction comprises a database query instruction.
25. The method of claim 23 , wherein the database command instruction comprises a database insertion instruction, and wherein transacting further comprises:
providing at least one data value to the database management system in association with the input string for storage in the database.
26. A database interfacing apparatus, comprising:
a memory;
a hardware processor disposed in communication with said memory and configured to issue a plurality of processing instructions stored in the memory, wherein the processor issues instructions to:
receive an input string having a plurality of syntax tokens arranged in accordance with a syntax grammar format and following business grammar rules for the arrangement of a plurality of data and application identifying items in at least one database, wherein each of said plurality of syntax tokens in the input string relates to at least one of a plurality of inter-linked table objects in a database, each inter-linked table object containing a table object identifier and an additional business grammar information related to said table object;
generate a plurality of inter-linked table objects in a database, wherein each inter-linked table object contains a table object identifier and an additional business grammar information related to the table object, wherein said inter-linked table objects are interconnected based on the business grammar rules for the plurality of data and application identifying items in the at least one database;
generate a database command from a composite of the parsed syntax tokens from the input string; and
transact command-specified data with the at least one database using the database access command.
27. A database interfacing apparatus, comprising:
a memory;
a hardware processor disposed in communication with said memory, and configured to issue a plurality of processing instructions stored in the memory, wherein the processor issues instructions to:
generate a plurality of inter-linked table objects in a database, wherein each inter-linked table object contains a table object identifier and an additional business grammar information related to the table object, wherein said inter-linked table objects are interconnected based on business grammar rules for the plurality of data and application identifying items in at least one database;
receive an input string having a plurality of syntax tokens arranged in accordance with a syntax grammar format and following business grammar rules for the arrangement of a plurality of data and application identifying items in at least one database, wherein each of said plurality of syntax tokens in the input string relates to at least one of a plurality of inter-linked table objects in a database, each said inter-linked table object containing a table object identifier and an additional business grammar information related to said table object;
determine whether a dynamic or static string token parsing of the input string should be utilized;
determine syntax grammar format based on the context in which the input string was received and whether the dynamic or static token parsing is required;
parse the input string for each syntax token based on the syntax grammar;
generate a database selection command from a composite of the parsed syntax tokens;
query the database with the selection command;
retrieve grammar responsive data based on the querying; and
provide the grammar responsive data to at least one receiving application.
28. A database interfacing apparatus, comprising:
a memory;
a hardware processor disposed in communication with said memory, and configured to issue a plurality of processing instructions stored in the memory, wherein the processor issues instructions to:
generate an input string having a plurality of syntax tokens arranged in accordance with a syntax grammar format and following business grammar rules for the arrangement of a plurality of data and application identifying items in at least one database, wherein each of said plurality of syntax tokens in the input string relates to at least one of a plurality of inter-linked table objects in a database, each inter-linked table object containing a table object identifier and an additional business grammar information related to said table object;
provide the data and application identifying items to a database management system associated with at least one database; and
transact data with the database based on the provided data and application identifying items.
29. A database access system having a processor-readable medium, comprising:
a hardware processor accessing the processor-readable medium;
a plurality of processing instructions stored in the medium and issuable by a processor to:
receive an input string having a plurality of syntax tokens arranged in accordance with a syntax grammar format and following business grammar rules for the arrangement of a plurality of data and application identifying items in at least one database, wherein each of said plurality of syntax tokens in the input string relates to at least one of a plurality of inter-linked table objects in a database, each inter-linked table object containing a table object identifier and an additional business grammar information related to said table object;
determine whether a dynamic or static string token parsing of the input string should be utilized;
determine syntax grammar format based on the context in which the input string was received and whether the dynamic or static token parsing is required;
parse the input string for each syntax token based on the syntax grammar;
generate a database command from a composite of the parsed syntax tokens; and
transact command-specified data with the database using the database command.
30. A database access system having a processor-readable medium, comprising:
a hardware processor accessing the processor-readable medium;
a plurality of processing instructions stored in the medium and issuable by a processor to:
generate a plurality of inter-linked table objects in a database, wherein each inter-linked table object contains a table object identifier and an additional business grammar information related to the table object, wherein said inter-linked table objects are interconnected based on the business grammar rules for the plurality of data and application identifying items in at least one database;
receive an input string having a plurality of syntax tokens arranged in accordance with a syntax grammar format and following business grammar rules for the arrangement of a plurality of data and application identifying items in at least one database, wherein each of said plurality of syntax tokens in the input string relates to at least one of a plurality of inter-linked table objects in a database, each said inter-linked table object containing a table object identifier and an additional business grammar information related to said table object;
determine whether a dynamic or static string token parsing of the input string should be utilized;
determine syntax grammar format based on the context in which the input string was received and whether the dynamic or static token parsing is required;
parse the input string for each syntax token based on the syntax grammar;
generate a database selection command from a composite of the parsed syntax tokens;
query the database with the selection command;
retrieve grammar responsive data based on the querying; and
provide the grammar responsive data to at least one receiving application.
31. A database interfacing system, comprising:
means to receive an input string having a plurality of syntax tokens arranged in accordance with a syntax grammar format and following business grammar rules for the arrangement of a plurality of data and application identifying items in at least one database, wherein each of said plurality of syntax tokens in the input string relates to at least one of a plurality of inter-linked table objects in a database, each inter-linked table object containing a table object identifier and an additional business grammar information related to said table object;
means to determine whether a dynamic or static string token parsing of the input string should be utilized;
means to determine syntax grammar format based on the context in which the input string was received and whether the dynamic or static token parsing is required;
means to parse the input string for each syntax token based on the syntax grammar;
means to generate a database command from a composite of the parsed syntax tokens; and
means to transact command-specified data with the database using the database command.
32. A database interfacing system, comprising:
means to generate a plurality of inter-linked table objects in a database, wherein each said inter-linked table object contains a table object identifier and an additional business grammar information related to the table object, wherein said inter-linked table objects are interconnected based on the business grammar rules for the plurality of data and application identifying items in at least one database;
means to receive an input string having a plurality of syntax tokens arranged in accordance with a syntax grammar format and following business grammar rules for the arrangement of a plurality of data and application identifying items in at least one database, wherein each of said plurality of syntax tokens in the input string relates to at least one of a plurality of inter-linked table objects in a database, each inter-linked table object containing a table object identifier and an additional business grammar information related to said table object;
means to determine whether a dynamic or static string token parsing of the input string should be utilized;
means to determine syntax grammar format based on the context in which the input string was received and whether the dynamic or static token parsing is required;
means to parse the input string for each syntax token based on the syntax grammar;
means to generate a database selection command from a composite of the parsed syntax tokens;
means to query the database with the selection command;
means to retrieve grammar responsive data based on the querying; and
means to provide the grammar responsive data to at least one receiving application.