The current disclosure generally relates to database management systems. More specifically, the present disclosure is generally directed to systems and methods for database management systems and their applications on mobile, embedded, and other computing devices and applications.
As processing power and memory become more affordable and compact, mobile, embedded, and other computing devices are being designed to include greater functionality. For instance, today's mobile, embedded, and other computing devices such as cellular-enabled computing devices (i.e. Smartphones, etc.) may comprise various applications for the users in addition to the basic telephonic functionality.
On the other hand, database management systems (DBMSs) are often used on conventional systems for storing, managing and/or manipulating structured data by inputting often complicated, complex and lengthy DBMS related instructions to be executed by the DBMS to perform operations on data stored in databases or on databases themselves. As such, operating the DBMS may often be a time consuming task, reserved for expensive and well-trained DBMS operators, thereby also incurring additional cost in order to perform operations on the data.
As DBMSs are traditionally reserved for execution on conventional database servers, personal desktop computers, or other more traditional computing devices, most DBMS management platforms count on the user to be very well versed in DBMS operation and commands in addition to having readily available a keyboard and a mouse for input, a full size display for output, and plentiful processing power with a permanent network connection and a plethora of bandwidth for operation. Such conditions however, should not be assumed for mobile and embedded computing device operations in which a user may not have access to a full size display, mouse or a standard keyboard in order to operate a DBMS. Furthermore, an average user of a mobile device may not be highly-trained in DBMS operation, and yet may need to operate a DBMS or a DBMS application. Therefore, in order to accommodate such a user of a mobile or embedded device to more efficiently and conveniently operate a DBMS via the mobile or embedded device platform, new approaches to DBMS design, functioning, and interfacing are herein introduced, enabling the user to realize the benefits of modern DBMS applications, while utilizing a new advanced DBMS operating functionalities presented below. To that extent, the present disclosure provides solutions to the at least aforementioned issues by providing advanced DBMS application functionalities accessible via mobile, embedded, and other computing devices that allow a user to utilize these functionalities on the go.
Concerning the advanced functionalities, the current disclosure discloses artificial intelligence (i.e. machine learning and/or anticipation functionalities, etc.) to learn the user's use of the DBMS, store this “knowledge” in a knowledgebase, and anticipate the user's future operating intentions with minimal or no user input. With respect to user interfacing, the current disclosure discloses an associative method of constructing DBMS commands, a simplified DBMS command language (SDCL) for associative DBMS command construction, and an artificially intelligent method for associative DBMS command construction. Also, the current disclosure discloses a method for associative DBMS command construction through voice input.
In one aspect, the present disclosure relates to an interface for an artificially intelligent database management system. In some embodiments, an interface of a database management system may be operating on a mobile device. The interface may be configured to receive a sequence of instruction sets. Each instruction set may be for performing an operation on data stored in a database. The sequence of instruction sets may comprise a first instruction set followed by a second instruction set. The interface may disassemble the first instruction set into a first plurality of portions and the second instruction set into a second plurality of portions. The interface may perform one or more database operations corresponding to the first instruction set followed by the operations corresponding to the second instruction set. The interface may receive a new instruction set for performing an operation on data stored in a database. The interface may disassemble the new instruction set into a new plurality of portions for comparing the new plurality of portions with the first plurality of portions and the second plurality of portions. The interface may also select to display on the mobile device the second instruction set, as an option to be selected by a user, responsive to a determination that the portions of the new instruction set substantially match the portions of the first instruction set and that the second instruction set follows in sequence the first instruction set.
In another aspect, the present disclosure relates to a system accessed from a mobile device. The system may include a database management system (DBMS) configured to store a sequence of instruction sets, where each instruction set is for performing an operation on data stored in a database, and the sequence of instruction sets comprises a first instruction set followed by a second instruction set, and the first instruction set comprises a first plurality of portions and the second instruction set comprises the second plurality of portions. The DBMS may also be configured to receive a new instruction set for performing an operation on a database and to disassemble the new instruction set into a new plurality of portions for comparing the new plurality of portions with the first plurality of portions and the second plurality of portions. The DBMS may also be configured to compare one or more of the new plurality of portions of the new instruction set with one or more of the first plurality of portions of the first instruction set. The DBMS may further be configured to transmit to the mobile device a second instruction set, as an option to be selected by a user, responsive to a determination that the portions of the new instruction set substantially match the portions of the first instruction set and that the second instruction set follows in sequence the first instruction set.
In one aspect, the present disclosure relates to an interface for a database management system (DBMS). In some embodiments, an interface of a database management system may be operating on a mobile device. The interface may be configured to receive, from the DBMS, a plurality of collections of instruction set portions for assembling instruction sets for performing operations on a database. The interface may associate each of a plurality of keys of a mobile device with each of a plurality of instruction set portions from a first collection from the plurality of collections. The interface may display on the mobile device, for a selection by a user, the plurality of instruction set portions from the first collection. The interface may receive, from a database management system (DBMS), a first portion of a new instruction set assembled using a first instruction set portion from the plurality of instruction set portions from the first collection, the first instruction set portion selected by the user. The interface may re-associate each of the plurality of keys of the mobile device with each of a plurality of instruction set portions from a second collection from the plurality of collections. The interface may display on the mobile device, for a selection by the user, the plurality of instruction set portions from the second collection. The interface may receive, from the DBMS, a second portion of the new instruction set, the second portion assembled to follow the first portion of the new instruction set, the second portion of the new instruction set assembled using a second instruction set portion from the plurality of instruction set portions from the second collection, the second instruction set portion selected by the user. The interface may re-associate each of the plurality of keys of the mobile device with each of a plurality of instruction set portions from a third collection from the plurality of collections. The interface may display on the mobile device, for a selection by the user, the plurality of instruction set portions from the third collection. The interface may receive, from the DBMS, a third portion of the new instruction set, the third portion assembled to follow the second portion of the new instruction set, the third portion of the new instruction set assembled using a third instruction set portion from the plurality of instruction set portions from the third collection, the third instruction set portion selected by the user.
In another aspect, the present disclosure relates to a system accessed from a mobile device. The system may include a database management system (DBMS) configured to maintain a plurality of collections of instruction set portions for assembling instruction sets for performing operations on a database. The DBMS may also be configured to assemble, by the DBMS, a first portion of a new instruction set using a first instruction set portion from a plurality of instruction set portions from a first collection, the first instruction set portion selected via a mobile device key associated with the first instruction set portion. The DBMS may also be configured to assemble, by the DBMS, a second portion of the new instruction set using a second instruction set portion from a plurality of instruction set portions from a second collection, the second instruction set portion selected via a mobile device key associated with the second instruction set portion, the second portion of the new instruction set following the first portion of the new instruction set. The DBMS may further be configured to assemble, by the DBMS, a third portion of the new instruction set using a third instruction set portion from a plurality of instruction set portions from a third collection, the third instruction set portion selected via a mobile device key associated with the third instruction set portion, the third portion of the new instruction set following the second portion of the new instruction set.
In one aspect, the present disclosure relates to an interface for a database management system. In some embodiments, an interface of a database management system may be operating on a mobile device. The interface may be configured to receive, from the DBMS, a plurality of collections of instruction set portions for assembling instruction sets for performing operations on a database. The interface may associate each of a plurality of user phrases with each of a plurality of instruction set portions from a first collection from the plurality of collections. The interface may display on the mobile device, for a selection by a user, the plurality of instruction set portions from the first collection. The interface may receive, from a database management system (DBMS), a first portion of a new instruction set assembled using a first instruction set portion from the plurality of instruction set portions from the first collection, the first instruction set portion selected by the user. The interface may re-associate each of the plurality of user phrases with each of a plurality of instruction set portions from a second collection from the plurality of collections. The interface may display on the mobile device, for a selection by the user, the plurality of instruction set portions from the second collection. The interface may receive, from the DBMS, a second portion of the new instruction set, the second portion assembled to follow the first portion of the new instruction set, the second portion of the new instruction set assembled using a second instruction set portion from the plurality of instruction set portions from the second collection, the second instruction set portion selected by the user. The interface may re-associate each of the plurality of user phrases with each of a plurality of instruction set portions from a third collection from the plurality of collections. The interface may display on the mobile device, for a selection by the user, the plurality of instruction set portions from the third collection. The interface may receive, from the DBMS, a third portion of the new instruction set, the third portion assembled to follow the second portion of the new instruction set, the third portion of the new instruction set assembled using a third instruction set portion from the plurality of instruction set portions from the third collection, the third instruction set portion selected by the user.
In another aspect, the present disclosure relates to a system accessed from a mobile device. The system may include a database management system (DBMS) configured to maintain a plurality of collections of instruction set portions for assembling instruction sets for performing operations on a database. The DBMS may also be configured to assemble, by the DBMS, a first portion of a new instruction set using a first instruction set portion from a plurality of instruction set portions from a first collection, the first instruction set portion selected on a mobile device via a user phrase associated with the first instruction set portion. The DBMS may also be configured to assemble, by the DBMS, a second portion of the new instruction set using a second instruction set portion from a plurality of instruction set portions from a second collection, the second instruction set portion selected on a mobile device via a user phrase associated with the second instruction set portion, the second portion of the new instruction set following the first portion of the new instruction set. The DBMS may further be configured to assemble, by the DBMS, a third portion of the new instruction set using a third instruction set portion from a plurality of instruction set portions from a third collection, the third instruction set portion selected on a mobile device via a user phrase associated with the third instruction set portion, the third portion of the new instruction set following the second portion of the new instruction set.
In one aspect, the present disclosure relates to an interface for an artificially intelligent database management system. In some embodiments, an interface of a database management system may be operating on a mobile device. The interface may be configured to receive a sequence of instruction set portions of an instruction set for performing an operation on data stored in a database. The sequence of instruction set portions may comprise a first instruction set portion followed by a second instruction set portion. The interface may receive a new instruction set portion of a new instruction set for performing an operation on data stored in a database. The interface may compare the new instruction set portion with the first instruction set portion and the second instruction set portion. The interface may also select to display on the mobile device the second instruction set portion, as an option to be selected by a user, responsive to a determination that the new instruction set portion substantially match the first instruction set portion and that the second instruction set portion follows in sequence the first instruction set portion.
In another aspect, the present disclosure relates to a system accessed from a mobile device. The system may include a database management system (DBMS) configured to store a sequence of instruction set portions of an instruction set for performing an operation on data stored in a database, and the sequence of instruction set portions comprises a first instruction set portion followed by a second instruction set portion. The DBMS may also be configured to receive a new instruction set portion of a new instruction set for performing an operation on a database. The DBMS may also be configured to compare the new instruction set portion with the first instruction set portion and the second instruction set portion. The DBMS may further be configured to transmit to the mobile device the second instruction set portion, as an option to be selected by a user, responsive to a determination that the new instruction set portion substantially matches the first instruction set portion and that the second instruction set portion follows in sequence the first instruction set portion.
In one aspect, the present disclosure relates to an interface for an artificially intelligent database management system. In some embodiments, an interface of a database management system may be operating on a mobile device. The interface may be configured to receive a first portion of a new instruction set for performing an operation on data stored in a database and a second portion of the new instruction set for performing the operation on data stored in the database. The interface may disassemble the first and the second portions of the new instruction set for comparing the first and the second portions with a stored plurality of instruction sets. The interface may also select to display on the mobile device, a third portion of a first instruction set of the stored plurality of instruction sets, responsive to a determination that the first instruction set includes a first portion that substantially matches the first portion of the new instruction set and a second portion that substantially matches the second portion of the new instruction set. The interface may further be configured to select to display on the mobile device, the third portion of a first instruction set, responsive to a further determination that the third portion of the first instruction set follows the first portion of the first instruction set and the second portion of the first instruction set.
In another aspect, the present disclosure relates to a system accessed from a mobile device. The system may include a database management system (DBMS) configured to store one or more instruction sets, each instruction set of the stored one or more instruction sets including instructions for an operation to be performed on data stored in one or more databases. The DBMS may also be configured to receive, from an interface for the DBMS, a first portion of a new instruction set for performing an operation on data stored in a database and a second portion of the new instruction set for performing the operation on data stored in the database. The DBMS may also be configured to compare the first and the second portions of the new instruction set with instruction sets from the one or more stored instruction sets. The DBMS may further be configured to transmit, to the interface, a third portion of a first instruction set of the stored plurality of instruction sets in response to a determination that the first portion of the first instruction set substantially matches the first portion of the new instruction set and that the second portion of the first instruction set substantially matches the second portion of the new instruction set. The DBMS may further be configured to transmit, to the interface, the third portion of a first instruction set, responsive to a further determination that that the third portion of the first instruction set follows the first portion of the first instruction set and the second portion of the first instruction set.
In one aspect, the present disclosure relates to a system for interfacing with a database management system. The system may include an interface of a database management system operating on a mobile device. The interface may be configured to receive a first portion of a new instruction set for performing an operation on data stored in a database and a second portion of the new instruction set for performing the operation on data stored in the database. The interface may also be configured to disassemble the first and the second portions of the new instruction set for comparing the first and the second portions with a stored plurality of instruction sets. The interface may further be configured to select to display on the mobile device, a first instruction set of the stored plurality of instruction sets. The selection to display on the mobile device of the first instruction set may be responsive to a determination that the first instruction set includes portions that substantially match the first and the second portions of the new instruction set.
In some embodiments, the interface is further configured to select to display on the mobile device, a second instruction set of the stored plurality of instruction sets. The second instruction set may be selected to be displayed responsive to a determination that the second instruction set includes portions that substantially match the first and the second portions of the new instruction set. In further embodiments, the interface is also configured to receive a third portion of the new instruction set for performing the operation on data stored in the database. The interface may also be configured to disassemble the third portion of the new instruction set for comparing the first, the second and the third portions with a stored plurality of instruction sets and to select for display on the mobile device, a third instruction set of the stored plurality of instruction sets, responsive to a determination that the third instruction set includes portions that substantially match the first, the second and the third portions of the new instruction set. The interface may also be configured to select to display the third instruction set as a preferred option for a user's selection with respect to the first instruction set and the second instruction set.
In some embodiments, the interface is further configured to select to display on the mobile device, the first instruction set, responsive to receiving the determination from the database management system. In certain embodiments, the interface is further configured to select to display on the mobile device the first instruction set as an option to be selected by a user. In some embodiments, the interface is further configured to transmit the first instruction set for execution by the database management system, responsive to a user's selection of the first instruction set. In yet some embodiments, the interface is further configured to select to display on the mobile device the first instruction set prior to receiving, by the interface, a final portion of the new instruction set, the final portion following at least the first and the second portions of the new instruction set. In certain embodiments, the interface is further configured to receive instructions for the database management system to operate on data in the database. In further embodiment, the interface is further configured to disassemble the new instruction set into a plurality of portions, including the first portion and the second portion, as the new instruction set is being received by the interface.
In some embodiments, each of the stored plurality of instruction sets include a different set of instructions for operating, by the database management system, on data stored in one or more databases. In some embodiments, the stored plurality of instruction sets comprise instruction sets previously entered by one or more users via the interface, the instruction sets for instructing the database management system to perform operations on data stored in one or more databases. In further embodiments, the stored plurality of instruction sets comprise instruction sets previously entered by a plurality of different users via a plurality of interfaces, the instruction sets for instructing the database management system to perform operations on data stored in one or more databases.
In some embodiments, the operation on data stored in a database comprises one of, or a combination of: accessing, modifying, creating or deleting a database. In some embodiments, the operation on data stored in a database comprises one of, or a combination of: accessing, modifying, creating or deleting a table of a database. In some embodiments, the operation on data stored in a database comprises one of, or a combination of: accessing, modifying, creating or deleting of a row, column, or cell within a table of a database. In some embodiments, the operation on data stored in a database comprises one of, or a combination of: accessing, modifying, creating or deleting a report/view, relation, user account, and/or other objects in a DBMS.
In some aspects, the present disclosure relates to a non-transitory computer readable medium storing a program causing a computer to execute an interface for a database management system. The program may comprise an interface for a database management system configured to: receive a first portion of a new instruction set for performing an operation on data stored in a database, receive a second portion of the new instruction set for performing the operation on data stored in the database, disassemble the first and the second portions of the new instruction set for comparing the first and the second portions with a stored plurality of instruction sets, and select to display on the mobile device, a first instruction set of the stored plurality of instruction sets, responsive to a determination that the first instruction set includes portions that substantially match the first and the second portions of the new instruction set.
In some aspects, the present disclosure relates to a non-transitory computer readable medium storing a program causing a computer to execute a database management system. The program may comprise a database management system (DBMS) configured to: store one or more instruction sets, each instruction set of the stored one or more instruction sets including instructions for an operation to be performed on data stored in one or more databases, receive, from an interface for the DBMS, a first portion of a new instruction set for performing an operation on data stored in a database and a second portion of the new instruction set for performing the operation on data stored in the database, compare the first and the second portions of the new instruction set with instruction sets from the one or more stored instruction sets, and transmit, to the interface, a first instruction set of the stored plurality of instruction sets in response to a determination that the first and the second portions of the new instruction set substantially match portions of the first instruction set.
In some aspects, the present disclosure relates to a system accessed from a mobile device. The system may include a database management system (DBMS). The DBMS may be configured to store one or more instruction sets, each instruction set of the stored one or more instruction sets including instructions for an operation to be performed on data stored in one or more databases. The DBMS may be configured to receive, from an interface for the DBMS, a first portion of a new instruction set for performing an operation on data stored in a database and a second portion of the new instruction set for performing the operation on data stored in the database. The DBMS may also be configured to compare the first and the second portions of the new instruction set with instruction sets from the one or more stored instruction sets. The DBMS may further be configured to transmit, to the interface, a first instruction set of the stored plurality of instruction sets in response to a determination that the first and the second portions of the new instruction set substantially match portions of the first instruction set.
In some embodiments, the DBMS is further configured to receive, from the interface, a third portion of the new instruction set for performing the operation on data stored in the database. In further embodiments, the DBMS is also configured to compare the first, the second and the third portions of the new instruction set with instruction sets from the one or more stored instruction sets and to transmit to the interface, a second instruction set of the stored plurality of instruction sets, responsive to a determination that the first, second and third portions of the new instruction set substantially match portions of the second instruction set.
In some embodiments, the DBMS is further configured to store an instruction set previously entered via the interface as an instruction set of the one or more stored instruction sets. In further embodiments, the DBMS is further configured to execute the first instruction set responsive to a selection by the user. In some embodiments, the DBMS is further configured transmit, to the interface, a second instruction set of the one or more stored instruction sets responsive to a determination that the first and the second portions of the new instruction set substantially match portions of the second instruction set.
In some embodiments, the DBMS is further configured to transmit, to the interface, the first instruction set prior to receiving, by the interface, a final portion of the new instruction set, the final portion following at least the first and the second portions of the new instruction set. In some embodiments, the one or more stored instruction sets comprise instruction sets previously entered by one or more users, via the interface, to instruct the DBMS to perform operations on one or more databases. In yet further embodiments, the one or more stored instruction sets comprise instruction sets previously entered by a plurality of different users via a plurality of interfaces to instruct the DBMS to perform operations on one or more databases.
In still some embodiments, the operation on data stored in the database comprises one of or a combination of: accessing, modifying, creating or deleting of an entry within a table of the database. In further embodiments, the operation on data stored in the database comprises one of: accessing, modifying, creating or deleting a table of the database. In still further embodiments, the operation on data stored in the database comprises one of: accessing, modifying, creating or deleting the database.
In certain aspects, the present disclosure relates to systems and methods for using a mobile processing system for anticipating instructions of a user for implementation via a DBMS. The systems and methods may include and utilize an artificially intelligent database management system (AI DBMS), an interface through which a user can input AI DBMS operating instructions, a disassembling unit for disassembling the AI DBMS operating instructions, and a maintained list of the user's past operating instructions that includes various past AI DBMS instructions. The system may structure the user's past AI DBMS operating instructions as knowledge of the user's use of the AI DBMS and store them along with other stored prior AI DBMS operating instructions in a knowledgebase. The system may then anticipate the user's future operating intentions based on the knowledgebase, and assemble the AI DBMS operating instructions based on the anticipating.
In some embodiments, the AI DBMS comprises an underlying DBMS through which the user can perform one or more of accessing, managing and/or manipulating a data. In some embodiments, performing operations on data in a database includes one or more of accessing, managing and/or manipulating data. For example, accessing, managing and/or manipulating data may include one or more of, or a combination of: (1) accessing, creating, altering, and deleting one or more a database within the underlying DBMS; (2) accessing, creating, altering, and deleting one or more a table within the one or more database; (3) accessing, creating, altering, deleting, searching, sorting and rearranging one or more a column, a row, and a data cell within the one or more table; (4) accessing, creating, altering, and deleting one or more a report/view within the one or more the database; (5) accessing, creating, altering, and deleting one or more a relation among the one or more the table and/or the report/view; and (6) accessing, creating, altering, and deleting one or more a user account and its privileges.
In some embodiments, the interface through which a user can input AI DBMS operating instructions includes a means of inputting one or more of alphanumeric, acoustic, tactile, and visual operating instructions. In further embodiments, the AI DBMS operating instructions includes a structured query language (SQL) statement. In some embodiments, the disassembling of the AI DBMS operating instructions includes disassembling a structured query language (SQL) statement into its instruction set portions, which may also be referred to as the instruction set portions. In some embodiments, the maintaining a list of the user's past operating instructions includes a data structure for storing a specific number of the user's past operating instructions. In some embodiments, structuring the user's past AI DBMS operating instructions as knowledge of the user's use of the AI DBMS includes creating a knowledge cell (1) in which some of the user's past AI DBMS operating instructions are copied into the knowledge cell's anticipatory operating instructions, and (2) in which some of the user's past AI DBMS operating instructions are copied into the knowledge cell's comparative operating instructions. In some embodiments, the entries in such knowledge cells may then be used for anticipating instruction sets which the user is intending to implement, by comparing the user's recently implemented instruction sets against the stored prior instruction sets from the knowledge cells in the knowledgebase. In other embodiments, the entries in such knowledge cells may then be used for anticipating the instruction set which the user is intending to input, by comparing the instruction set portions being inputted against the stored prior instruction sets from the knowledge cells in the knowledgebase. In yet other embodiments, the entries in such knowledge cells may then be used for anticipating the instruction set portions which the user is intending to input, by comparing the instruction set portions being inputted against the stored prior instruction set portions from the knowledge cells in the knowledgebase.
In some embodiments, storing the knowledge of the user's use of the AI DBMS instructions in a knowledgebase includes a data structure for storing the knowledge cells. The knowledgebase may include local or remote knowledgebases into which the instruction sets can be stored. In some embodiments, anticipating of the user's operating intentions based on the knowledgebase information includes performing a substantial similarity comparison between the user's recently implemented operating instructions and the operating instructions in the knowledgebase. In other embodiments, anticipating of the user's operating intentions based on the knowledgebase information includes performing a substantial similarity comparison between the user's recently inputted portions of an operating instruction and the operating instructions in the knowledgebase. In yet other embodiments, anticipating of the user's operating intentions based on the knowledgebase information includes performing a substantial similarity comparison between the user's recently inputted portions of an operating instruction and the portions of operating instructions in the knowledgebase. In some embodiments, the assembling AI DBMS operating instructions based on the anticipating includes assembling a structured query language (SQL) statement from its instruction set portions.
In some aspects, the present disclosure relates to a non-transient machine readable medium that stores executable instructions, the executable instructions causing a machine to perform operations comprising: defining an artificially intelligent database management system (AI DBMS), generating an interface through which a user can input AI DBMS operating instructions, disassembling the AI DBMS operating instructions, maintaining a list of the user's past operating instructions, structuring the user's past AI DBMS operating instructions as knowledge of the user's use of the AI DBMS, storing the knowledge of the user's use of the AI DBMS in a knowledgebase, determining the user's intended AI DBMS operating instructions based on comparing the user's recent AI DBMS operating instructions and the data stored in the knowledgebase, and assembling the intended AI DBMS operating instruction set based on the comparison.
Other features and advantages of the current disclosure will become apparent from the following description, including the claims and drawings.
Like reference numerals in different figures indicate like elements. Horizontal or vertical “ . . . ” and other such indicia may be used to indicate additional instances of the same type of element. n, m, n+m, n−m or other such indicia may represent any integers or sequential numbers that follow the sequence where they are indicated. Any of these indicia may be used interchangeably according to the context and space available.
The disclosed systems and methods of using an artificially intelligent DBMS and interfaces for mobile, embedded, and other computing devices (both artificially intelligent DBMS and interfaces herein referred to individually or collectively as AI DBMS 100, AI DBMS or Smart DBMS) includes advanced features and functionalities to enable a user to operate a DBMS (i.e. perform operations on data, databases, tables, reports, relations, user accounts, and/or other objects or elements within a DBMS, etc.) using a mobile, embedded or other computing device.
In some embodiments, AI DBMS may include machine learning functionality enabling the AI DBMS to “learn” the user's uses of the DBMS and store this “knowledge” in a knowledgebase for a future operation. Then, using this stored “knowledge”, AI DBMS may anticipate the user's future operating intentions. These functionalities enable a user to realize the standard DBMS operations on a mobile, embedded, or other computing device as well as greatly extend the standard operations through enabling artificially intelligent DBMS operations that may require minimal or no user input.
Referring now to
Main processor 11 includes any logic circuitry that responds to and processes instructions fetched from the main memory unit 12. Main processor 11 may also include any combination of hardware and software for implementing and executing logic functions or algorithms. Main processor 11 may include a single core or a multi core processor. Main processor 11 may comprise any functionality for loading an operating system 17 and operating any software 18 thereon. In many embodiments, the central processing unit is provided by a microprocessing or a processing unit, such as for example Snapdragon processors produced by Qualcomm Inc., processors by Intel Corporation of Mountain View, California, those manufactured by Motorola Corporation of Schaumburg, Ill.; those manufactured by Transmeta Corporation of Santa Clara, Calif.; the RS/6000 processor, those manufactured by International Business Machines of White Plains, N.Y.; those manufactured by Advanced Micro Devices of Sunnyvale, California, or any computing unit for performing similar functions. The computing device 20 may be based on any of these processors, or any other processor capable of operating as described herein, whether on a mobile or embedded device or a larger more conventional machine.
Main memory unit 12 may include one or more memory chips capable of storing data and allowing any storage location to be directly accessed by the microprocessor 11, such as Static random access memory (SRAM), Flash memory, Burst SRAM or SynchBurst SRAM (BSRAM), Dynamic random access memory (DRAM), Fast Page Mode DRAM (FPM DRAM), Enhanced DRAM (EDRAM), Extended Data Output RAM (EDO RAM), Extended Data Output DRAM (EDO DRAM), Burst Extended Data Output DRAM (BEDO DRAM), Enhanced DRAM (EDRAM), synchronous DRAM (SDRAM), JEDEC SRAM, PC100 SDRAM, Double Data Rate SDRAM (DDR SDRAM), Enhanced SDRAM (ESDRAM), SyncLink DRAM (SLDRAM), Direct Rambus DRAM (DRDRAM), or Ferroelectric RAM (FRAM). The main memory 12 may be based on any of the above described memory chips, or any other available memory chips capable of operating as described herein. In some embodiments, the main processor 11 communicates with main memory 12 via a system bus 5. In some embodiments of a computing device comprising computing device 20, the processor communicates directly with main memory 12 via a memory port 10.
Computing device 20 may further include alternative memory, such as an SD memory slot, a USB memory stick, an optical drive such as a CD-ROM drive, a CD-R/RW drive, a DVD-ROM drive or a BlueRay disc, a hard-drive or any other device that may include non-volatile memory suitable for storing data or installing software and programs. Computing device 20 may further include a storage device 125 which may include any type and form of non-volatile memory for storing an operating system (OS) which may include any type and form of Windows OS, Mac OS, Unix OS, Linux OS, Android OS, iPhone OS, mobile version of Windows OS, or any other OS that may operate on the computing device 20. Computing device 20 may also include software 18 and/or data space 19 for storing additional data or information. In some embodiments, an alternative memory 16 may be used as the storage device 125. Additionally, OS 17 and/or the software 18 may be run from a bootable medium, for example, a flash drive, a bootable CD, such as KNOPPIX®, a bootable CD for GNU/Linux that is available as a GNU/Linux distribution from knoppix.net.
Computing device 20 may include a network interface 25 to interface to a Local Area Network (LAN), Wide Area Network (WAN) or the Internet through a variety of connections including, but not limited to, standard telephone lines, wired or wireless connections, LAN or WAN links (i.e. 802.11, T1, T3, 56 kb, X.25), broadband connections (e.g., ISDN, Frame Relay, ATM), or some combination of any or all of the above. Network interface 25 may include Bluetooth or WiFi capability. The network interface 25 may comprise a built-in network adapter, network interface card, PCMCIA network card, card bus network adapter, wireless network adapter, Bluetooth adapter, USB network adapter, modem or any other device suitable for interfacing the computing device to any type of network capable of communication and performing the operations described herein.
Still referring to
In some embodiments, the computing environment may comprise or be connected to multiple display devices 21. Display devices 21 may each be of the same or different type and/or form. I/O devices 13 and/or the I/O control 22 may comprise any type and/or form of suitable hardware, software, or combination of hardware and software to support, enable or provide for the connection and use of multiple display devices 21 or multiple detection devices.
In one example, computing device includes any type and/or form of video adapter, video card, driver, and/or library to interface, communicate, connect or otherwise use the display devices 21 or any I/O devices 13 such as video camera devices. In one embodiment, a video adapter may comprise multiple connectors to interface to multiple display devices 21. In other embodiments, the computing device may include multiple video adapters, with each video adapter connected to one or more of the display devices 21. In some embodiments, any portion of the operating system of the computing device may be configured for using multiple displays 21. In other embodiments, one or more of the display devices 21 may be provided by one or more other computing devices, such as computing devices connected to a remote computing device via a network.
In further embodiments, an I/O device 13 may be a bridge between the system bus 5 and an external communication bus, such as a USB bus, an Apple Desktop Bus, an RS-232 serial connection, a SCSI bus, a FireWire bus, a FireWire 800 bus, an Ethernet bus, an AppleTalk bus, a Gigabit Ethernet bus, an Asynchronous Transfer Mode bus, a HIPPI bus, a Super HIPPI bus, a SerialPlus bus, a SCI/LAMP bus, a FibreChannel bus, or a Serial Attached small computer system interface bus.
Computing environment on the computing device 20 may operate under the control of operating systems, which may control scheduling of tasks and access to system resources. The computing device may be running any operating system including mobile device or desktop machine operating systems, including Android OS, iPhone OS, Windows 8 OS, or any other version of OS for running a computing device. For example, with respect to operating systems, the computing device 20 may use different releases of the Unix and Linux operating systems, any version of the Mac OS® for Macintosh computers, any embedded operating system, any real-time operating system, any open source operating system, any video gaming operating system, any proprietary operating system, any operating systems for mobile computing devices, or any other operating system capable of running on the computing device and performing the operations described herein. Typical operating systems include: WINDOWS XP, Windows 7, Windows 8 all of which are manufactured by Microsoft Corporation of Redmond, Wash.; MacOS, iPhone OS manufactured by Apple Computer of Cupertino, Calif.; OS/2, manufactured by International Business Machines of Armonk, N.Y.; and Linux a freely-available operating system distributed by Caldera Corp. of Salt Lake City, Utah, or any type and/or form of a Unix operating system, among others. Similarly, any other operating systems by Android or Apple, can be utilized, just as those of the Microsoft.
In other embodiments, the computing device 20 may have any different combination of processors, operating systems, and input/output devices consistent with the device's purpose and structure. For example, in one embodiment the computing device includes a Snapdragon by Qualcomm, Inc., or Tegra processors by nVidia, or any other mobile device processor or a microprocessor for a similar application. In this embodiment, the smartphone device may be operated under the control of the Android, iPhone OS, PalmOS or any other operating system of a similar purpose. The device may then also include a stylus input device as well as a five-way navigator device. In another example, the computing device includes a Wii video game console released by Nintendo Co. operating an es operating system. In this embodiment, the I/O devices may include a video camera or an infrared camera for recording or tracking movements of a player or a participant of a Wii video game. Other I/O devices 13 may include a joystick, a keyboard or an RF wireless remote control device. Similarly, the computing device 20 may be tailored to any workstation, mobile or desktop computer, laptop or notebook computer, Smartphone device or tablet, server, handheld computer, gaming device, embedded device, or any other computer or computing product, or other type and form of computing or telecommunications device and that has sufficient processor power and memory capacity to perform the operations described herein.
Still referring to
Various implementations of the methods, systems and techniques described herein can be realized in digital electronic circuitry, integrated circuitry, specially designed application specific integrated circuits (ASICs), field programmable gate arrays (FPGAs), computer hardware, firmware, software, virtual machines, and/or combinations thereof including their structural, logical, and/or physical equivalents. The various implementations can include implementation in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, coupled to receive data and instructions from, and to transmit data and instructions to, a storage system, at least one input device, and at least one output device.
A computer program (also known as program, software, software application, script or code) includes machine instructions for a programmable processor, and can be implemented in a high-level procedural and/or object-oriented programming language, and/or in a low-level assembly/machine language. Any language used may be a compiled or an interpreted language. A computer program may be deployed in any form, including as a stand-alone program or as a module, component, subroutine, or other unit suitable for use in a computing environment. A computer program does not necessarily correspond to a file in a file system. A program may be stored in a portion of a file that holds other programs or data (i.e. one or more scripts stored in a markup language document, etc.), in a single file dedicated to the program in question, or in multiple coordinated files (i.e. files that store one or more modules, sub programs, or portions of code, etc.). A computer program may be deployed to be executed on one computer or on multiple computers at one site or distributed across multiple sites and interconnected by a communication network.
The methods, systems and techniques described herein may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other.
A computing device may be embedded in another device such as a tablet computer, a mobile telephone, a personal digital assistant (PDA), a media player, an audio or video player, a Global Positioning System (GPS) receiver, a game console, a portable storage device (i.e. a USB flash drive, etc.), gateway, a router, a hub, a digital video recorder, a set-top box, an automobile entertainment system, an automobile navigation system, a television device, a residential gateway, a refrigerator, a washing machine, a factory automation device, an assembly line device, a factory floor monitoring device, to name just a few. The processor and the memory may be supplemented by, or incorporated in, special purpose logic circuitry.
As used herein, the terms machine-readable medium and computer-readable medium refer to any computer program product, apparatus and/or device used to provide machine instructions and/or data to a programmable processor, including a machine-readable medium that receives machine instructions as a machine-readable signal. The term machine-readable signal refers to any signal used to provide machine instructions and/or data to a programmable processor. A machine-readable medium may include both a volatile and non-volatile medium, a removable and non-removable medium, a communication medium, and a storage medium. A communication medium may include computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism, and may include any other form of information delivery medium known in the art.
The methods, systems and techniques described herein can be implemented in a computing system that includes a back end component (i.e. a data server, etc.), or that includes a middleware component (i.e. an application server, etc.), or that includes a front end component (i.e. a client computer having a graphical user interface or a web browser through which a user can interact with an implementation of the methods, systems and techniques described herein, etc.), or any combination of such back end, middleware, or front end components. The components of the system can be interconnected by any form or medium of digital data communication (i.e. a communication network, etc.). Examples of communication networks include the Internet, an intranet, an extranet, a local area network (LAN), a wide area network (WAN), a personal area network (PAN), a home area network (HAN), a campus area network (CAN), a metropolitan area network (MAN), a global area network (GAN), a storage area network (SAN), virtual network, a virtual private network (VPN), Bluetooth network, a wireless network, a wireless LAN, a radio network, a HomePNA, a power line communication network, a G.hn network, an optical fiber network, an Ethernet network, an active networking network, a client-server network, a peer-to-peer network, a bus network, a star network, a ring network, a mesh network, a star-bus network, a tree network, a hierarchical topology network, or any type of network known in the art.
Any of the files shown in the figures or described in the specification may reside in any repository accessible by an implementation of the methods, systems and techniques described herein. In each instance where a specific file or file type is mentioned, other files, file types or formats may be substituted.
Where a reference to a data structure is used herein, it should be understood that any variety of data structures may be used such as, for example, array, list, linked list, doubly linked list, queue, tree, heap, graph, map, grid, matrix, multi-dimensional matrix, table, database, DBMS, file, and/or any other type or form of a data structure.
Where a reference to a storing data, object, item or any element is used herein, it should be understood that any data, object, item or element stored may be a pointer to the data, object, item or any element stored somewhere else.
Referring to
To clarify the context of the embodiment illustrated by
Mobile Device 20 may be any mobile computer, a mobile phone, a Smartphone (i.e. iPhone, Windows Phone, Blackberry, Android phone, etc.), a tablet, a personal digital assistant (PDA), or another similar type of mobile device capable of implementating the functionalities described herein. The main processor 11 of the Mobile Device 20 may include hardware and software for executing instructions and processing data operatively coupled with aforementioned memory for storing the instructions and data. The memory may also include applications such as AI DBMS applications and functions discussed herein. The main processor 11 of the Mobile Device 20 may also access a computer-readable medium including a volatile and nonvolatile medium, a removable and non-removable medium, a communication medium, a storage medium, and other similar type of computer-readable medium. The processor may be operatively coupled with an output device such as a Liquid Crystal Display (LCD) to show information to the user. An input device, such as a key pad, keyboard, and/or touch screen may also be operatively coupled with the processor to enable the user to input instructions. The memory may store software that can provide functionality when executed by the processor. The software may include a user interface that enables a user to interact with the mobile device, and a mobile operating system that provides system functionality. A modern mobile operating system combines the features of a personal computer operating system with high resolution display, touchscreen, cellular network connectivity, bluetooth, WiFi, GPS, mobile navigation, microphone, camera, video camera, voice recorder, speech recognition, music player, near field communication, PDA, and other features and applications. Examples of a mobile operating system include iOS, Android, Windows Mobile, BlackBerry OS, Symbian OS, Palm OS, and other mobile operating systems.
Mobile Device 20 may also be, or include, an embedded device, which may be any device or system with a dedicated function within a larger device or system. Embedded systems may range from the simplest ones dedicated to one task with no user interfaces to complex ones with advanced user interfaces that resemble modern desktop computer systems. Simple embedded devices use buttons, light emitting diodes (LEDs), graphic or character LCDs with a simple menu system. More sophisticated devices may use a graphical screen with touch sensing or screen-edge buttons where the meaning of the buttons may change with the screen. Examples of devices that include an embedded device may include a gaming device, a media player, a digital still or video camera, a pager, a television device, a set-top box, a personal navigation device, a global positioning system (GPS) receiver, a digital watch, a DVD player, a printer, a microwave oven, a washing machine, a dishwasher, a thermostat, a automobile, a factory controller, a telephone, a router, a network bridge, or another similar type of embedded device. The embedded device may include one or more elements described in the Mobile Device 20 above such as the main processor 11, any of the aforementioned memory, the network interface 25, computer-readable medium, the output device, the input device, the user interface, the software, the operating system, etc. Examples of an operating system for the embedded device include MicroC/OS-II, QNX, VxWorks, eCos, TinyOS, Windows Embedded, Embedded Linux, and other embedded operating systems.
Other computing device may be any computing device including a traditional computing device with all of its processing, storage, communication, networking, input and output interfacing, and other functionalities. Examples of the traditional computing device may include a personal desktop computer, a server, a mainframe computer, or another similar type of the traditional computing device. The traditional computing device may include one or more elements described in the Mobile Device 20 above such as the main processor 11, any of the aforementioned memory, the network interface 25, computer-readable medium, the output device, the input device, the user interface, the software, the operating system, etc. Examples of an operating system for a traditional computing device include Windows, MacOS, Linux, Unix, and other similar operating systems.
AI DBMS, included in the Mobile Device 20, may be any software, hardware or a combination of software and hardware for providing machine learning, anticipating, and/or other functionalities described herein. Similarly, AI DBMS may be any hardware, software or a combination of hardware and software for providing an interface with a DBMS. In some embodiments, AI DBMS may include a software application or a function acting as an interface between a user and a DBMS. In further embodiments, AI DBMS may include a software application or a function for an interface with one or more databases, as a part of a general DBMS operating and providing one or more databases. For example, AI DBMS may be executed by the processor that may accept a user's instructions, transmit them to the processor for execution, determine, through processing, that the user's intended instruction set for operating a DBMS is a particular instruction set and transmit results back to the user including the determined particular instruction set to be presented to the user.
In some embodiments, AI DBMS may be implemented as a Java Micro Edition (ME), Java Standard Edition (SE), or other Java Editions application or program. Java ME is specifically designed for mobile and embedded devices and provides a robust and flexible environment for applications with flexible user interfaces, robust security, built-in network protocols, powerful application programming interfaces, DBMS connectivity and interfacing functionality, file manipulation capabilities, and support for networked and offline applications. Applications based on Java ME are portable across many devices, yet leverage each device's native capabilities.
In another embodiment, AI DBMS may be a Java SE application as the traditional computing devices support it, and more mobile and embedded devices continue to support it. Java SE supports the feature sets of most Smartphones and a broad range of high-end connected devices while still fitting within their resource constraints. Java platforms include one or more basic application programming interfaces (APIs) and virtual machine features that comprise a runtime environment for software applications. The use of Java platforms may provide core application functionality for software applications such as AI DBMS that may be executed on mobile, embedded, and other computing devices.
AI DBMS may be a software application that includes a Java program written for a Java platform, and is an example of an application that may execute on a mobile, embedded, and other computing device. A Java program or application may provide a wide range of user-level functionality that may be used in applications such as AI DBMS, including, but not limited to, providing an Internet browser to a user, displaying text and graphics, playing and recording audio media, displaying and recording visual media, communicating with another mobile device, and other functionality. AI DBMS is programming language, platform, and operating system independent. Besides the platforms and operating systems previously described, programming languages additional to Java, may include C, C++, Cobol, Java Script, Tcl, Visual Basic, Pascal, VB Script, Perl, PHP, and other programming languages or functions capable of implementing the functionalities described herein.
In some embodiments, AI DBMS may be implemented as a Xlet within the Java platform. A Xlet is a Java applet or application configured to execute on a mobile, embedded, and other computing device, that may be a part of the Java TV specification, and may use a Personal Basis Profile (“PBP”) of a Connected Device Configuration (“CDC”) for the Java ME platform. A Xlet may be managed by a special-purpose application-management software built into the mobile, embedded, and other computing device.
Core Program 110 may be any hardware, software or a combination of hardware and software directing and controlling the flow of instructions and data among the elements of AI DBMS system. Core Program 110 may be directly or operatively coupled with Underlying DBMS 120, DBMS Artificial Intelligence 130, Input Interface 140, Output Interface 160, and/or other elements of the AI DBMS system to produce desired results. Core Program 110 may be initiated by the User 10 or it may be initiated automatically when the Mobile Device 20 turns on. Core Program 110 may run continuously as a deamon or it may run only as long as the User 10 needs it.
Core program 110, as shown in an embodiment illustrated in
Upon connecting to the Underlying DBMS 120, the Core Program 110 may transmit to the Underlying DBMS 120 an instruction set understood by the Underlying DBMS 120. Subsequently, the Underlying DBMS 120 may perform an operation that corresponds to the instruction set and may transmit results to the Core Program 110 for presentation to the User 10. In the case that the instruction set used is a SQL statement, it would be platform-independent and supported by a vast majority of commercial and open-source DBMSs. It should be clear to one of ordinary skill in the art that the instruction set (i.e. SQL statement, etc.) discussed herein as an example, may be replaced by any type or form of instruction set or statement in any other language or script, as needed to conform to a given DBMS.
Input Interface 140 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for processing input events of the Keyboard 150 or other input devices for use by the Core Program 110 or other elements of the current disclosure. The Input Interface 140 may be Java keyboard listener, keypad listener, touch screen listener, mouse listener, trackball listener, any device driver (i.e. audio, video, keyboard, mouse, or other driver), speech recognizer, video recognizer, or any other input interface. Input Interface 140 may be or comprise any functionality of I/O control 22, keyboard 23, and/or I/O device 13.
Keyboard 150 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for inputting letters, numbers and/or symbols into the Mobile Device 20. Keyboard 150 may be suited or specialized for a mobile device, tablet or a Smartphone. Keyboard 150 may be or comprise any functionality of keyboard 23, I/O device 13 and/or I/O control 22. In one implementation, Keyboard 150 may be an element of the current disclosure through which the User 10 inputs operating instructions by pressing keys or buttons. Other input devices for detecting user input may be utilized in place of the Keyboard 150 such as keypad, touch screen, external keyboard, mouse, trackball, microphone, video or still camera, tactile input device, or any other input device.
Output Interface 160 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for processing output from the Core Program 110 or other elements of the current disclosure for presentation to a user. In some embodiments, Output Interface 160 may include functions and algorithms for processing the results from the Core Program 110 for viewing by the User 10. The Output Interface 160 may be a Java graphical user interface, an acoustical output interface, tactile output interface, any device driver (i.e. audio, video, or other driver), or any other output interface. Output interface 160 may be or comprise any functionality of I/O control 22, display devices 21, and/or I/O device 13.
Display 170 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for displaying information to a user. In some embodiments, Display 170 may comprise functions and algorithms for showing AI DBMS results to the User 10. Other output devices for conveying information may be utilized such as a projector, an external monitor, a speaker, tactile output device, or any other output device. Display 170 may be or comprise any functionality of display devices 21, I/O control 22, and/or I/O device 13.
Memory 180 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for storing data or information in an electronic format. Memory 180 may be, or comprise any functionality of storage 125, cache 14, and/or main memory 12. In some embodiments, memory 180 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for temporarily storing programs and/or data currently running on the Mobile Device 20.
Physical storage medium 180 may also comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for storing data and information in an electronic format. In one implementation, the Physical Storage Medium 181 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for permanently storing the Core Program 110, Underlying DBMS 120 data files and any supporting data structures, and/or other needed items. The Physical Storage Medium 181 may be a hard drive, a microSD card, a flash drive, or any other type of physical storage medium. Physical storage medium 181 may be or comprise any functionality of storage 125.
Referring to
As shown in an embodiment illustrated in
Underlying DBMS 120 may include instruction sets in the form of structured query language (SQL) capabilities. SQL is a computer language used to access, manage, and manipulate data in DBMSs, although other similar languages having similar capabilities may be utilized as needed. An example of a SQL statement is as follows: “SELECT col1, col2, col3, . . . FROM tbl1, tbl2, tbl3, . . . ORDER BY col1*, col2*, col3*, . . . ”. In this SQL statement, “col1, col2, col3, . . . ” represents the Columns 320 to be selected, “tbl1, tbl2, tbl3, . . . ” represents the names of Tables 310 from which to obtain data, and “col1*, col2*, col3*, . . . ” represents the Columns 320 by which to sort the resulting Report/View 350.
In some embodiments, User 10 may not need to input instruction sets such as SQL statements to operate a DBMS. User 10 may utilize software application with a graphical user interface or program that generates instruction sets understood by the Underlying DBMS 120. For example, a report generating program (i.e. Chrystal Reports, etc.) or a visual DBMS application (i.e. Microsoft Access, etc.) may provide input fields, selectable lists, drop-down menus, buttons, or other graphical elements to enable a User 10 to create instruction sets in a point and click manner without ever typing SQL code, for example.
The User 10 may access, manage and/or manipulate the Underlying DBMS 120 and the Underlying DBMS 120 may store, manage and/or manipulate data and/or supporting data structures responsive to the User 10. User's 10 accessing, managing and/or manipulating and/or Underlying DBMS's 120 storing, managing and/or manipulating data and/or supporting data structures may include (1) storing, accessing, creating, altering, and/or deleting one or more Database 300 within the Underlying DBMS 120; (2) storing, accessing, creating, altering, and/or deleting one or more Table 310 within the one or more Database 300; (3) storing, accessing, creating, altering, deleting, searching, sorting and/or rearranging one or more Column 320, Row 330, and/or Data Cell 340 (generally also referred to as data) within the one or more Table 310; (4) storing, accessing, creating, altering, and/or deleting one or more Report/View 350 within the one or more Database 300; (5) storing, accessing, creating, altering, and/or deleting one or more Relation 360 among the one or more Table 310 and/or Report/View 350; (6) storing, accessing, creating, altering, and/or deleting one or more User Account 370 and its privileges; and (7) other operations.
Referring to
Precompiler 410: In some embodiments, Precompiler 410 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for extracting the relevant SQL statement(s) or other DBMS command(s) embedded in the Core Program's 110 instruction set, or for translating the instruction set into corresponding SQL statement(s) or other DBMS command(s). The instruction may come from an API or directly from an application program such as the Core Program 110. The Precompiler 410 may process Core Program's 110 instruction set into SQL statement or any other DBMS command format that the Underlying DBMS 120 understands.
Parser 420: In some embodiments, Parser 420 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for parsing the SQL statement(s) or other DBMS command(s) that were deciphered from the Core Program's 110 instruction set. At this stage, the objective of the Parser 420 may be to create a parse tree structure based on the SQL statement(s) or other DBMS command(s) so that it may be easily understood by the other elements later in the Underlying DBMS 120 execution flow.
Execution Engine 430: In some embodiments, Execution Engine 430 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for executing the SQL statement(s) or other DBMS command(s) that were deciphered from the Core Program's 110 instruction set against a Database 300 and/or any of its components to perform an operation on a Database 300 and/or any of its components. For example, this operation may involve (1) accessing, adding, modifying or deleting a Database 300, (2) accessing, adding, modifying or deleting a Table 310, (3) accessing, adding, modifying or deleting any of the Columns 320, Rows 330 or Data Cells 340 of the Tables 310 in the Database 300, and/or (4) any other similar operation normally implemented by a DBMS. When executing SQL statement(s) or other DBMS command(s), a plurality of lower level operations may generally be performed by the Underlying DBMS 120 in a predetermined order including issuing a read or write request to the Physical Storage Medium 181.
Transaction Manager 450: In some embodiments, Transaction Manager 450 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for ensuring that a transaction is executed properly in accordance with particular rules of the DBMS, SQL and/or any other applicable system rules. The transaction is a single unit of work that has one or more SQL statement(s) or other DBMS command(s) in it. Transaction Manager 450 may also include functionality for resolving any deadlock situations that may occur during the process, such as for example during a situation when two transactions cannot continue because they each have some data that the other needs to proceed.
Log Manager 460: In some embodiments, Log Manager 460 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for logging every operation executed by the Underlying DBMS 120. It may do so by storing a log on the Physical Storage Medium 181.
Buffer Manager 480: In some embodiments, Buffer Manager 480 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for allocating and managing the Memory 180. Buffer Manager 480 may include functionality to allocate resources for accessing, managing and/or manipulating data. Buffer Manager 480 may take in formatted requests and decide how much Memory 180 to allocate per buffer and how many buffers to allocate per request.
Storage Manager 490: In some embodiments, Storage Manager 490 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for retrieving and storing data in memory. For example, Storage Manager 490 may include functionality, at the lowest level, to make requests through the underlying Physical Storage Medium 181 controller (not shown; i.e. hard disk controller, etc.) or the operating system to retrieve data from or store data to the Physical Storage Medium 181. The Physical Storage Medium 181 controller may be a device configured to provide an interface for retrieving and storing data and any supporting data structures in physical files.
Other additional elements such as data definition language (DDL) compiler, query preprocessor, security manager, integration manager, query optimizer, recovery manager, concurrency manager, control manager, resource manager, communications manager, lock manager, page and cache manager, etc. may be included, or some of the disclosed ones may be excluded, or a combination thereof may be utilized in alternate implementations of the Underlying DBMS 120. Also, some features may be included in alternate implementations of the Underlying DBMS 120 such as maintaining the integrity and security of stored data, indices that provide fast access to data items that hold particular values, statistical data that store statistical information about the data, etc.
The current disclosure is independent of the type of Underlying DBMS 120 it uses that may include any DBMS that can be executed on the operating environments previously described such as Advantage Database Server, EffiProz, ElevateDB, Embedded InnoDB, Empress Embedded Database, Extensible Storage Engine, eXtremeDB, Firebird Embedded, HSQLDB, Informix Dynamic Server, InfinityDB, InterBase, ITTIA DB, NexusDB, Raima Database Manager, ScimoreDB, SolidDB, SQLite, SQL Server Compact, Valentina DB, VistaDB, Oracle, Microsoft SQL Server, MySQL, Informix, Sybase, and other DBMSs. Underlying DBMS 120 may also be a single database, multiple databases, a single table, multiple tables, a single file, multiple files, a file system, a single data structure, multiple data structures, a data structure system, a single system, multiple systems, or any other data structure or a combination of the aforementioned data structures for storing, managing and/or manipulating digital data.
Referring to
DBMS Artificial Intelligence 130 may include a Command Disassembler 500, an Operation List 510, a Knowledge Structuring Unit 520, a Knowledgebase 530, a Decision-making Unit 540, a User Confirmation Unit 550, and a Command Assembler 560. Other additional elements may be included as needed, or some of the disclosed ones may be excluded, or a combination thereof may be utilized in alternate embodiments.
Referring to
Instruction Set 600 may be a SQL Statement, any DBMS command, any computer command, any instruction or instruction set used to access, manage, and/or manipulate (i.e. add, delete, change, etc.) data and the supporting data structures (i.e. databases, tables, relations, user accounts, etc.) in the Underlying DBMS 120. Instruction Set 600 may be issued in structured query language (SQL), a language utilized by many standard DBMSs, or in any programming language understood by the Underlying DBMS 120. Instruction Set 600 may comprise a number of commands, keywords, instructions, operators, variables, values, objects, functions and/or other components for performing a particular operation.
When an Instruction Set 600, such as the one in
Instruction Set Portions 620 may comprise particular commands, keywords (i.e. “SELECT”, “FROM”, “INSERT”, etc.), instructions, operators (i.e. =, <, >, etc.), variables, values, objects (i.e. table, database, report/view, etc.), functions (i.e. FIRST( ), MIN( ), MAX( ), etc.) and/or other components (some or all of these components may be used interchangeably herein) for performing or specifying a particular portion of the Instruction Set 600. For example, an Instruction Set Portion 620 may include a keyword “SELECT” to indicate a type of operation to perform. Keywords “FROM” and “WHERE” may also be used to facilitate the operation and identify the data on which a particular command is to be performed. In addition, keywords may include a particular variable, such as a particular Database 300 name, or a particular Row 330 or Column 320 within a particular Table 310, or a particular data stored in a particular location in the Database 300.
Command Disassembler 500 may comprise functions and/or algorithms for identifying and recognizing specific commands, keywords, instructions, operators, variables, values, objects, functions and/or other components included within an Instruction Set 600. In some embodiments, the specific commands, keywords, instructions, operators, variables, values, objects, functions and/or other components may be included in a lexicon stored in a data structure (i.e. a list, array, table, etc.) containing all possible or most used commands, keywords, instructions, operators, variables, values, objects, functions and/or other components that may generally be used in SQL or other DBMS language used, and/or the ones that may specifically be used in the Underlying DBMS 120. This data structure may be predefined and may change as the objects or other elements within the Underlying DBMS 120 change. In one example, in response to changing the name of a table within a database, the data structure would update this table's name in itself, so Command Disassembler 500 may recognize the updated table name as an Instruction Set Portion 620 in its next run. In other embodiments, the data structure containing the lexicon may be created on fly or as needed by the AI DBMS system by (1) reading the Underlying DBMS 120 objects or other elements, meta data, data dictionary, and/or (2) including other typical Instruction Set Portions 620 (i.e. SQL or other language keywords, operators, functions, etc.) used in DBMSs.
Still referring to
Various types of Instruction Sets 600 will have different Instruction Set Portions 620 stored in Operation 610 data fields. For example, INSERT type of Instruction Set 600 would not have “SELECT”, “FROM”, “WHERE”, “ORDER BY”, and “GROUP BY” keywords and their associated objects and operators. Instead, INSERT type of Instruction Set 600 would have different keywords, objects and operators such as “INSERT” and “INTO” keywords and their associated objects and operators.
In addition to Instruction Set's 600 Instruction Set Portions 620, extra information or Extra Info 630 such as a time stamp may also be stored in the data fields within the Operation 610. Time stamp of when the Instruction Set 600 is executed may be useful for anticipation of the User's 10 future operating intentions related to a specific time frame. Other Extra Info 630 may be included in the Operation 610 such as user specific information, group user information, any context information such as the type of business for which the AI DBMS is used, the type of computing device executing the AI DBMS, the type of user (novice, moderate, skilled, expert) and other context information, version of the Underlying DBMS 120, etc. to provide as much information as possible for best anticipation of the User's 10 future operating intentions. Also, Command Disassembler 500 may be more detailed in its disassembling of the Instruction Set 600 in which case every keyword, operator, value and other portions of the Instruction Set 600 may be captured and stored as an Instruction Set Portion 620 in the Operation 610. In general, when the Instruction Set 600 is disassembled into its Instruction Set Portions 620 and stored in the Operation 610 it becomes easier to compare to other Instruction Sets 600 or Operations 610.
Referring to
Operation List 510 may receive Operations 610 or Instruction Sets 600 from the Command Disassembler 500 and store a number of Operations 610 or Instruction Sets 600 that were most recently used or implemented by the system. The number of Operations 610 or Instruction Sets 600 most recently used or implemented may vary depending on the embodiments. For example, in some embodiments anywhere between 1 and 10000 most recently used or implemented Operations 610 or Instruction Sets 600 may be stored. In some embodiments the number of stored Operations 610 or Instruction Sets 600 is between 2 and 10, such as for example 2, 5, 6, or 9. In other embodiments, the number of Operations 610 or Instruction Sets 600 is between 10 and 50, such as for example 12, 15, 20, 30, 40 or 50 Operations 610 or Instruction Sets 600. In further embodiments, the number of Operations 610 or Instruction Sets 600 stored is between 50 and 200, such as for example 50, 70, 80, 100, 130, 180 or 200 Operations 610 or Instruction Sets 600. In further embodiments, the number of Operations 610 or Instruction Sets 600 stored is between 200 and 10000, such as for example 500, 1000, 3000, 5000, 8000 or 10000. The number of Operations 610 or Instruction Sets 600 may be any number, even greater than 1000. The number of most recently used or implemented Operations 610 or Instruction Sets 600 stored may be even greater than 10000, as one of ordinary skill in the art would recognize that the number of stored Operations 610 or Instruction Sets 600 may be any number that may be stored in any memory or storage described herein.
In one embodiment, in which the last nine Operations 610 or Instruction Sets 600 are stored in the Operation List 510, Operations 610 or Instruction Sets 600 may be identified such that the current Operation 610 or Instruction Set 600 is identified as Operation n, the most recent Operation 610 or Instruction Set 600 prior to the current may be identified as Operation n−1, and so on until the least most recent Operation 610 or Instruction Set 600 being stored is labeled as Operation n−8. In such embodiments, each time the Operation List 510 receives another new Operation 610 or Instruction Set 600 from the Command Disassembler 500, it may erase the least recent Operation 610 or Instruction Set 600, such as the Operation n−8, and insert the current Operation 610 or Instruction Set 600 received as Operation n. Naturally, all the most recently used or implemented Operations 610 or Instruction Sets 600 that are stored in this list or queue may be shifted by one count further towards Operation n−8. This way, the system may maintain a queue of stored most recently used or implemented Operations 610 or Instruction Sets 600, where the queue may include any number of stored Operations 610 or Instruction Sets 600 as previously described.
In one example illustrated in
Referring to
In some embodiments, Knowledge Structuring Unit 520 may receive the current Operation List 510 and may create a Knowledge Cell 800 by copying, for example, Operation n from the Operation List 510 into Operation n+4 of the Knowledge Cell 800, by copying Operation n−1 from the Operation List 510 into Operation n+3 of the Knowledge Cell 800, by copying Operation n−2 from the Operation List 510 into Operation n+2 of the Knowledge Cell 800, and so forth. Knowledge Cell 800 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for storing a recorded sequence of the User's 10 operating instructions (i.e. Operations 610 or Instruction Sets 600). In effect, when a Knowledge Cell 800 is created it may include any data structure (i.e. array, list, linked list, table, etc.) that may store a recorded sequence of the User's 10 operating instructions (i.e. Operations 610 or Instruction Sets 600) where, for example, Operation n, Operation n−1, Operation n−2, Operation n−3, and Operation n−4 may later be used for comparison with the then User's 10 current and recent operating instructions, and Operation n+1, Operation n+2, Operation n+3, and Operation n+4 may later be used for anticipation of the User's 10 future operating intentions (i.e. future Operations 610 or Instruction Sets 600). In some embodiments, Operations 610 or Instruction Sets 600 within the Knowledge Cell 800 with an order number greater than n may be anticipatory and the rest of the Operations 610 or Instruction Sets 600 may be comparative, although this particular split may differ in alternate embodiments. Any number of comparative and any number of anticipatory Operations 610 or Instruction Sets 600 may be included in a Knowledge Cell 800 and any number of Knowledge Cells 800 may be used in the AI DBMS system. In one embodiment, one long Knowledge Cell 800 may be used in which case comparisons of Operations 610 or Instruction Sets 600 may be performed in a traversing pattern as explained below. Also, as indicated by the up and down vertical dotted arrows, the copying of Operation n from the Operation List 510 into the Knowledge Cell 800 may start at any Operation n+m through Operation n−m of the Knowledge Cell 800. This way, the number of comparative and anticipatory Operations 610 or Instruction Sets 600 may differ and they can be determined either by the user or the system itself. For example, a Knowledge Cell 800 may include only one anticipatory Operation 610 or Instruction Set 600 in the case where the copying of the Operation List 510 into the Knowledge Cell 800 starts with copying Operation n of the Operation List 510 into Operation n+1 of the Knowledge Cell 800. In another example, a Knowledge Cell 800 may include four anticipatory Operations 610 or Instruction Sets 600 in the case where the copying of the Operation List 510 into the Knowledge Cell 800 starts with copying Operation n of the Operation List 510 into Operation n+4 of the Knowledge Cell 800.
Referring to
As shown in
In some embodiments, Operations 610 or Instruction Sets 600 may be stored directly within the Knowledgebase 530 without using Knowledge Cell 800 as the intermediary data structure. In these embodiments, Operations 610 or Instruction Sets 600 may be stored in one or more sequences (i.e. tables, lists, arrays, etc.) of the Knowledgebase 530. Furthermore, comparisons of Operations 610 or Instruction Sets 600 later described may be performed by traversing the one or more sequences of Operations 610 or Instruction Sets 600 to find a match. In one example, Knowledgebase 530 may include all of User's 10 Operations 610 or Instruction Sets 600 in a single long sequence (i.e. table, list, array, etc.), or it may record User's 10 Operations 610 or Instruction Sets 600 in daily, weekly, monthly, yearly or other periodic sequences (i.e. monthly tables, monthly lists, monthly arrays, etc.) in another example. In the case of a single long sequence, for example, the comparisons of Operations 610 or Instruction Sets 600 later described would compare Operations 610 or Instruction Sets 600 in the current Operation List 510 with subsequences of the single long sequence in incremental or other traversing pattern. The incremental traversing pattern of comparison may start from one of the ends of the single long sequence and move the comparison subsequence up or down the list one incremental Operation 610 or Instruction Set 600 at a time. Other traversing patterns or algorithms may be employed such as starting from the middle of the sequence and subdividing the resulting sub-sequences in a recursive pattern, or any other traversing pattern or algorithm.
Referring to
As shown in
Substantial Similarity Comparison 1010 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for comparing or matching Operations 610 or Instruction Sets 600. Substantial Similarity Comparison 1010 may include functions and algorithms for comparing or matching Operations 610 or Instruction Sets 600 from the Operation List 510 with (1) Operations 610 or Instruction Sets 600 stored in a Knowledgebase 530 or (2) Operations 610 or Instruction Sets 600 from the Knowledge Cells 800 stored in a Knowledgebase 530. In some embodiments, the comparing or matching may include comparing Operations 610 or Instruction Sets 600 from the Operation List 510 with comparative Operations 610 or Instruction Sets 600 from the Knowledge Cells 800 stored in a Knowledgebase 530. Substantial Similarity Comparison 1010 may comprise algorithms, functions and/or logic for performing matching or comparisons and for determining that while a perfect match is not found, a substantially similar match has been found. Substantial Similarity Comparison 1010 may therefore identify an Operation 610 or Instruction Set 600 from an Operation List 510 that is most like an Operation 610 or Instruction Set 600 from a Knowledge Cell 800 in a Knowledgebase 530, even if the Operation 610 or Instruction Set 600 from the Operation List 510 is different from the Operation 610 or Instruction Set 600 in the Knowledge Cell 800.
In some embodiments such as one illustrated in
Still referring to
The appropriately strict rules for substantial similarity may be defined for the current disclosure based on the type of DBMS application, experience, testing logs, inquiry, analysis, synthesis or other techniques in alternate implementations. As such, the strictness rules of the Comparison Strictness Function 1011 may be set by the user or by AI DBMS administrator based on such experience and knowledge. In one implementation, substantial similarity may be achieved when most of the Instruction Set Portions 620 of the User's 10 most recently implemented Operations 610 or Instruction Sets 600, such as for example five Operations 610 or Instruction Sets 600 (i.e. Operation n, Operation n−1, Operation n−2, Operation n−3, and Operation n−4) in the Operations List 510 substantially match the Instruction Set Portions 620 of the corresponding (i.e. comparative) Operations 610 or Instruction Sets 600 from a Knowledge Cell 800. Alternatively, total equivalence may be found when all Instruction Set Portions 620 of the User's 10 most recently implemented Operations 610 or Instruction Sets 600 from the Operation List 510 match the Instruction Set Portions 620 of all corresponding (i.e. comparative) Operations 610 or Instruction Sets 600 from a Knowledge Cell 800 within the Knowledgebase 530. In other embodiments, when a total equivalence match is not found, Substantial Similarity Comparison 1010 may omit values, operators, or other components from the comparison, although values, operators, or other components are captured as sub-segments of Instruction Set Portions 620.
Comparison Strictness Function 1011 may comprise algorithms, functions and logic to automatically adjust its level of strictness for finding a best substantial similarity match between the Operations 610 or Instruction Sets 600 in the Operation List 510 and the corresponding (i.e. comparative) Operations 610 or Instruction Sets 600 in the Knowledgebase 530 (i.e. Knowledge Cells 800 stored in the Knowledgebase 530 or Operations 610 or Instruction Sets 600 stored in the Knowledgebase 530). Depending on the design, various levels of strictness may be used. In some embodiments, Comparison Strictness Function 1011 may set the rules to search for a substantial similarity by finding perfect matches between the Operations 610 or Instruction Sets 600 in the Operation List 510 and the corresponding (i.e. comparative) Operations 610 or Instruction Sets 600 in the Knowledgebase 530. If such a match is not found, Comparison Strictness Function 1011 may decrease the strictness level. In some embodiments, in response to decreasing the strictness level, Comparison Strictness Function 1011 may set the strictness of the rules to search for a substantial similarity in terms of a total equivalence with respect to command portions of the Operation 610 or Instruction Set 600 only, thereby tolerating mismatches in variable names, such as the names of databases or tables. Comparison Strictness Function 1011 may choose to relax the rules in response to determining that no total equivalence match had been found. For example, in such embodiments, a substantial similarity may be achieved when a match is found in terms of a correct operation, but for a different database than the one the user wants to operate on. In such instances, upon presenting the user with the substantial similarity match (i.e. substantially similar Knowledge Cell 800), the AI DBMS may give the user an anticipatory Operation 610 or Instruction Set 600 from the matched Knowledge Cell 800 allowing the user to change the variable names into the ones desired, still saving the user work on inputting the commands. In further embodiments, Comparison Strictness Function 1011 may, upon determining that a perfect match is not found, allow for matching all but one of the Operations 610 or Instruction Sets 600 from the Operation List 510 and the corresponding (i.e. comparative) Operations 610 or Instruction Sets 600 in the Knowledgebase 530. In further embodiments, the Comparison Strictness Function 1011 may set the rules to find a match with all but two or more Operations 610 or Instruction Sets 600 from the Operation List 510 and the corresponding (i.e. comparative) Operations 610 or Instruction Sets 600 in the Knowledgebase 530.
All the aforementioned settings of strictness of the substantial similarity match may be set, or reset, by the Comparison Strictness Function 1011, in response of another strictness level determination. For example, Comparison Strictness Function 1011 may adjust a strictness level for identifying a substantial similarity match for an Operation 610 or Instruction Set 600 whose Instruction Set Portions 620 corresponding to command words are a total match with Instruction Set Portions 620 of an Operation 610 or Instruction Set 600 in a Knowledgebase 530, while tolerating mismatches in table names, database names and similar. Such an adjustment in strictness may be done by the Comparison Strictness Function 1011 in response to determining that a total equivalence match for an entire Operation 610 or Instruction Set 600 is not found in the Knowledgebase 530. Similarly, Comparison Strictness Function 1011 may adjust the strictness level for identifying a substantial similarity match for an Operation 610 or Instruction Set 600 whose Instruction Set Portions 620 match all but one Instruction Set Portion 620 of an Operation 610 or Instruction Set 600 in a Knowledgebase 530. Also, Comparison Strictness Function 1011 may adjust the strictness level for identifying a substantial similarity match for an Operation 610 or Instruction Set 600 whose Instruction Set Portions 620 match all but two or more Instruction Set Portions 620 of an Operation 610 or Instruction Set 600 in a Knowledgebase 530. Such an adjustment in strictness may be done by the Comparison Strictness Function 1011 in response to determining that not a sufficient number of matches had been found using a higher strictness level.
Comparison Strictness Function 1011 may therefore increase and decrease the strictness of the rules for finding a substantial similarity match depending on whether or not perfect matches (i.e. perfect equivalents between the compared Operations 610 or Instruction Sets 600) had been found. As such, Comparison Strictness Function 1011 may utilize two thresholds, the upper and a lower threshold, to determine the strictness of the rules used for determining the substantial similarity match. The upper threshold may correspond to the number of substantial similarity matches that are too high to be presented to the user (i.e. too many matching results, too vague suggestions). Alternatively, the lower threshold may correspond to the strictness level that results in too few results to be presented to the user. Comparison Strictness Function 1011 may make any combination of the aforementioned adjustments to achieve that the number of substantial similarity matches between the Operations 610 or Instruction Sets 600 in the Operation List 510 and the corresponding (i.e. comparative) Operations 610 or Instruction Sets 600 in the Knowledgebase 530 falls between the upper and the lower threshold. As such, Comparison Strictness Function 1011 may keep adjusting the strictness rules for finding the substantially similar match until both thresholds are satisfied, thereby adjusting the results until the best set of results is found.
In one embodiment, Comparison Strictness Function 1011 may adjust the strictness level by choosing the number of Operations 610 or Instruction Sets 600 that it will use to find a substantial similarity match. For example, as a user implements first three Operations 610 or Instruction Sets 600, Comparison Strictness Function 1011 may run these three Operations 610 or Instruction Sets 600 against Knowledge Cells 800 in the Knowledgebase 530. If the Substantial Similarity Comparison 1010 provides a number of matching results (i.e. results that have perfect equivalence) that is above a particular threshold, the Comparison Strictness Function 1011 may decide to increase the strictness of the rules to decrease the number of results. In response, Substantial Similarity Comparison 1010 may then decide to wait for the user to add a fourth Operation 610 or Instruction Set 600, thereby allowing the Substantial Similarity Comparison 1010 to use the fourth Operation 610 or Instruction Set 600 in addition to the earlier three to find a smaller number of matching results. Once the user adds the fourth Operation 610 or Instruction Set 600, the Substantial Similarity Comparison 1010 may use all four Operations 610 or Instruction Sets 600 to find a match. If the number of matching results (i.e. results that perfectly match or total equivalences) is sufficiently small, the system may present the user with these results. If however, the number of matching results is still too high, the Comparison Strictness Function 1011 may determine to further increase the strictness by requiring the user to add additional Operations 610 or Instruction Sets 600 and thereby further narrow the search results before presenting the user with the suggested results. In some embodiments, Operations 610 or Instruction Sets 600 added may include a portion of an Operation 610 or Instruction Set 600 such as a first one or more Instruction Set Portions 620 or one or more letters or one or more keywords, commands, phrases, etc. of such Instruction Set Portions 620.
To increase comparison accuracy, Extra Info 630 (i.e. time stamp, user specific information, group user information, etc.) besides Instruction Set Portions 620 may be recorded at the creation of an Operation 610 by the Command Disassembler 500, as previously described. Substantial Similarity Comparison 1010 may use this additional information for finding the best match between the Operations 610 or Instruction Sets 600 in the Operation List 510 and the corresponding (i.e. comparative) Operations 610 or Instruction Sets 600 in the Knowledgebase 530. Concerning time stamp, User 10 may perform some operations such as data backup periodically, such as for example, during a specific time of day, week, month, year or any other time period. The Substantial Similarity Comparison 1010 may utilize the time stamp in the comparisons to determine the best match in the case of these time-sensitive Operations 610 or Instruction Sets 600.
Another technique for increasing comparison accuracy and/or adjusting strictness level of the Comparison Strictness Function 1011 may be to assign an importance index (i.e. on a scale from 1 to 10) to each Instruction Set Portion 620 and/or Extra Info 630. This way, the Substantial Similarity Comparison 1010 may focus more on the comparison of, for example, command words, keywords and/or objects, and less on operators and time stamps for certain types of Operations 610 or Instruction Sets 600.
Another technique for increasing comparison accuracy and/or adjusting strictness level of the Comparison Strictness Function 1011 may be to include semantic analysis in the Substantial Similarity Comparison 1010. For example, an Operation 610 or Instruction Set 600 from the Operation List 510 may contain a table called Customers. Instead of looking for the exact name match in the corresponding (i.e. comparative) Operation 610 or Instruction Set 600 from the Knowledgebase 530 the Substantial Similarity Comparison 1010 may employ semantic analysis and attempt to match Cust, Cst, Cstm, Cstmr, Cstmrs, or other variations of the table name with a meaning Customers. This semantic analysis method is not limited to the use only with meanings of object names such as database names, table names, column names, etc. This approach may be utilized with any differing field or segment of an Operation 610 or Instruction Set 600 with a potentially same meaning such as various operators with same meanings, various values with same meanings, various keywords with same meanings, etc.
Another technique that may be used is for the Substantial Similarity Comparison 1010 to assign comparison accuracy (not shown) during the comparison process based on how well matched are the Operations 610 or Instruction Sets 600 of the Operation List 500 to the Operations 610 or Instruction Sets 600 of a Knowledge Cell 800 in the Knowledgebase 530. An indicator of comparison accuracy with a scale from 1 to 10 may be utilized, for example. The indicator of comparison accuracy may then be stored in the Operations 610 or Instruction Sets 600 of the Substantially Similar Knowledge Cell 1110. Comparison accuracy information may be useful later in the User Confirmation 1130 process step to help automate the confirmation process.
Referring to
As shown in
The context in which Operations 610 or Instruction Sets 600 from the Operation List 510 were performed may be analyzed by the Context Interpreter 1120. In some embodiments, context may be defined as (1) any segment of the Instruction Set 600 not captured as an Instruction Set Portion 620 in an Operation 610, (2) any sub-segment of an Instruction Set Portion 620 within an Operation 610 that is not used in the Substantial Similarity Comparison 1010, or (3) any information about Operations 610 or Instruction Sets 600 from the Operation List 510 that may be useful in anticipating User's 10 operating intentions (future Operations 610 or Instruction Sets 600). In effect, Context Interpreter 1120 may perform an extra analysis step and it may attempt to capture all information and/or elements that may have been omitted by the Command Disassembler 500, by the Substantial Similarity Comparison 1010, or by other process steps.
An example of Context Interpreter's 1120 usefulness is the fact that values may be omitted from Substantial Similarity Comparisons 1010 in some embodiments, as previously described. It is Context Interpreter's 1120 responsibility to discover the values or ranges of values used in the User's recent Operations 610 or Instruction Sets 600 by extracting the values from their Instruction Set Portions 620. User Confirmation 1130 process steps may then take these values or ranges of values, modify anticipatory Operations 610 or Instruction Sets 600 (such as for example: Operation n+1, Operation n+2, Operation n+3, Operation n+5, etc.) according to these values or ranges of values, and present the modified anticipatory Operations 610 or Instruction Sets 600 to the User 10 for confirmation before executing them.
User Confirmation 1130 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for automating user confirmation if the Substantially Similar Knowledge Cell 1110 contains comparison accuracy information as previously described, such as for example an instance in which one or more comparative Operations 610 or Instruction Sets 600 were found to be a perfect or highly accurate match. In such instances, anticipatory Operations 610 or Instruction Sets 600 from the Substantially Similar Knowledge Cell 1110 may be automatically executed by AI DBMS without asking the user to confirm them. As such, anticipatory Operations 610 or Instruction Sets 600 from the Substantially Similar Knowledge Cell 1110 with complete or high comparison accuracy may be executed without the need to confirm with User 10. Conversely, anticipatory Operations 610 or Instruction Sets 600 from the Substantially Similar Knowledge Cell 1110 with less than high comparison accuracy may be presented to User 10 for confirmation including presenting the comparison accuracy information for User's 10 consideration.
Referring to
As shown in
In some embodiments, when anticipatory Operations 610 or Instruction Sets 600 are known and ready to execute, Command Assembler 560 or any other element of the current disclosure may trigger an external function or process of the system within which AI DBMS may operate. For example, in an embodiment where AI DBMS may be used or embedded within a television device (embodiment later described), AI DBMS may trigger a video recording process in response to anticipating a User's 10 switching (i.e. selecting or performing a SELECT type DBMS operation) to a favorite channel. In another embodiment where AI DBMS may be used or embedded within a cellular telephone, AI DBMS may trigger a calling process in response to anticipating User's 10 input (i.e. inserting or performing an INSERT type DBMS operation) of a new contact in the contact list.
In yet some embodiments, an Instruction Set 600 may be passed directly to the Operation List 510 without being disassembled, in which case Command Disassembler 500 may be omitted from the overall system. In these embodiments, Operation List 510, Knowledge Cells 800, and Knowledgebase 530 may all include original Instruction Sets 600 instead of disassembled Operations 610. Therefore, Substantial Similarity Comparisons 1010 between the Instruction Sets 600 in the Operation List 510 and the corresponding (i.e. comparative) Instruction Sets 600 in the Knowledgebase 530 may be performed either directly (i.e. letter for letter, word for word, etc.) or indirectly by performing extraction or disassembling of Instruction Set Portions 620 in the comparison step.
In further embodiments, AI DBMS may be configured to run automatically (i.e. autonomously, etc.) and/or perform DBMS operations. For example, AI DBMS and/or Artificial Intelligence 130 may periodically (i.e. daily, weekly, monthly, yearly, etc.) automatically run to analyze (i.e. through the Substantial Similarity Comparison 1010 process, etc.) time stamps of all of the Operations 610 or Instruction Sets 600 in the Knowledgebase 530 to determine which Operations 610 or Instruction Sets 600 the User 10 may have implemented in particular time periods. If repetitive Operations 610 or Instruction Sets 600 may have been found, they may be executed automatically with or without User's 10 confirmation depending, for example, on how accurate or confident the substantial similarity match may be. Other patterns in addition to analyzing the time stamp may be analyzed in alternate embodiments.
Referring to
User Specific Information 532, or User Specific Info 532, may comprise hardware, software or a combination of hardware and software for storing information pertaining to a specific user. There may be plurality of User Specific Infos 532 on the system, one for each user. User Specific Info 532 may include the information on the most prevalent Operations 610 or Instruction Sets 600 the user may be using, information on databases on which the user may have most often performed operations, information on types of Operations 610 or Instruction Sets 600 the user most often performs, information on the sequence of Operations 610 or Instruction Sets 600 which the user may perform or have performed most often, and more. User Specific Info 532 may further include the information along with a timestamp for each Operation 610 or Instruction Set 600 which the user has performed in the past, thereby allowing the system to determine which Operations 610 or Instruction Sets 600 the user has most recently been using and which Operations 610 or Instruction Sets 600 the user has not used in a while.
Group Specific Information 534, or Group Specific Info 534, may comprise hardware, software or a combination of hardware and software for storing information pertaining to a group of users. The group of users may be a group having a particular access level to the AI DBMS, such as for example group of administrators, group of general users, group of managers, group of guests, and more. Each group may be given a different access level and different level of control over the system. There may be plurality of or Group Specific Infos 534 on the system, one for each group of users. Group Specific Info 534 may include the information on the most prevalent Operations 610 or Instruction Sets 600 the users of the group may be using, information on databases on which the users of the group may have most often performed operations, information on types of operations the users of the group most often perform, information on the sequence of Operations 610 or Instruction Sets 600 which the users of the group may perform or have perform most often, and more. Group Specific Info 534 may further include the information along with a timestamp for each Operation 610 or Instruction Set 600 which the users of the group have performed in the past, thereby allowing the system to determine which Operations 610 or Instruction Sets 600 the users of the group have most recently been using and which Operations 610 or Instruction Sets 600 the user have not used in a while.
In some embodiments, the Core Program 110 and the Underlying DBMS 120 may be provided as distinct elements executing on the same computing device.
Referring to
Referring to
Referring to
Referring to
In some embodiments, Knowledgebase 530 may be local (i.e. local Knowledgebase 530) and it may reside on the User's 10 Mobile Device 20. Such local Knowledgebase 530 may be stored in a local table, local file, or other local data structure or data repository, and it may include “knowledge” of the use of the Underlying DBMS 120 by the local User 10 (i.e. owner of the mobile device).
Referring to
In some embodiments, AI DBMS may include DBMS Artificial Intelligence 130 (i.e. local DBMS Artificial Intelligence 130) residing and executing on the User's 10 Mobile Device 20.
Referring to
Referring to
In brief overview, at step 1705, a mobile device receives a sequence of instruction sets for performing operations on a database. The sequence may include an order of consecutive instruction sets, such as for example a first instruction set followed by a second instruction set. At step 1710, the first and second instruction sets are processed into instruction set portions. At step 1715, the sequence of the instruction sets is stored, along with their corresponding portions of instruction sets, into a knowledgebase that comprises plurality of instruction set sequences along with their corresponding portions. At step 1720, the mobile device receives a new instruction set for performing an operation on a database. At step 1725, the new instruction set is processed into instruction set portions. At step 1730, one or more portions of the new instruction set is compared with the portions of instruction sets in the knowledgebase. At step 1735, a determination is made that there is a substantial similarity between the one or more portions of the new instruction set and one or more portions of the first instruction set. At step 1737, the new instruction set is executed by performing, on a database, an operation corresponding to the new instruction set. At step 1740, the second instruction set, along with its portions, is displayed on the mobile device as options to be selected by a user. At step 1745, the second instruction set or any of its portions are modified, should the user decide to modify the second instruction set or its portions. At step 1750, the operation defined by the second instruction set (or the modified second instruction set) is performed on the database.
At step 1705, a mobile device receives a sequence of instruction sets. Each instruction set may indicate or identify one or more operations to be performed on some data in some database. The sequence may include a first instruction set, followed by a second instruction set, which may also be followed by a third instruction set, and so on. Any instruction set may be received by the interface for a DMBS. Any instruction set may be received by any component of the AI DBMS. Instruction sets of the sequence may be received by the mobile device, or by any other mobile device or a computing device in general.
At step 1710, the first and the second instruction sets of the sequence of instruction sets are processed into instruction set portions. In some embodiments, each of the instruction sets from the sequence are disassembled or parsed into portions. In other embodiments, the instruction sets are separated into commands, keywords, instructions, operators, variables, values, objects, functions and/or other components, etc. Processing may also include identifying the type of each instruction set, in terms of the commands used. Specifically, determinations may be made to identify if each instruction set is for modifying data, selecting data, accessing data, creating a database, creating a row or a column within a database, making a new entry, etc. Processing may further include creating a timestamp of the time when each instruction set has been received or executed. Processing may further include identifying a user which entered each instruction set or identifying a group to which the user belongs. Processing may include assigning a weight to each of the instruction sets or their portions. Processing may further include creating any extra information pertinent for facilitating AI DBMS functionalities described herein. Processing may include any action or operation by or for a Command Disassembler 500.
At step 1715, the sequence of instruction sets is stored into a knowledgebase, along with the portions of the instruction sets. The knowledgebase may comprise any number of instruction sets, instruction set portions and/or instruction set sequences, each of which may be stored in various arrangements, including tables, databases, DBMSs, memory structures, data structures, etc. In some embodiments, knowledgebase may include sequences of instruction sets, instruction sets and/or instruction set portions from the mobile device via which the sequences of instruction sets, instruction sets and/or instruction set portions are received. In other embodiments, knowledgebase may include sequences of instruction sets, instruction sets and/or instruction set portions from any number of computing devices. Knowledgebase or additional knowledgebases may also be populated to include the user specific and/or group specific informations gathered with respect to the instruction set. Also stored in knowledgebase may be the weight assigned to each instruction set or its portions. Storing may include any action or operation by or for a Knowledgebase 530 or Knowledge Structuring Unit 520.
At step 1720, a new instruction set for performing an operation on a database is received by the mobile device. The new instruction set may identify or indicate any operation to be performed on a database indicated herein. For instance, the new instruction set may include an instruction to select, add, delete, or modify an entry; add, delete, or modify a column; add, delete, or modify a table; add, delete, or modify a database; add, delete, or modify a relation; add, delete, or modify a user account; etc. The one or more portions of the new instruction set may be for performing some operation on some database managed by the AI DBMS. The new instruction set or one or more of its portions may be stored into operation lists.
At step 1725, the new instruction set is processed into instruction set portions. In some embodiments, the new instruction set is disassembled or parsed into portions, which may include commands, keywords, instructions, operators, variables, values, objects, functions and/or other components, etc. Processing may also include identifying the type of the new instruction set, in terms of the commands used. Specifically determinations may be made to identify if the new instruction set is for modifying data, selecting data, accessing data, creating a database, creating a row or a column within a database, making a new entry, etc. Processing may further include creating a timestamp of the time when the new instruction set has been received. Processing may further include identifying a user which entered the new instruction set or identifying a group to which the user belongs. Processing may include assigning a weight to each of the new instruction sets or their portions. Processing may further include creating any extra information pertinent for facilitating AI DBMS functionalities described herein. Processing may include any action or operation by or for a Command Disassembler 500.
At step 1730, one or more portions of the new instruction set is compared with the portions of instruction sets in the knowledgebase. In one embodiment, the one or more portions of the new instruction set are compared as a single string of characters with a plurality of portions of instruction sets in the knowledgebase. In other embodiments, comparison may be implemented by treating each instruction set portion as a separate string to be matched independently. In further embodiments, comparison is implemented by matching all of one or more portions of the new instruction set with one or more portions of an instruction set stored in a knowledgebase. Comparison may be implemented by matching all but one of the one or more portions of the new instruction set with one or more portions of an instruction set stored in a knowledgebase. Comparison may also be implemented by matching all but two of one or more portions of the new instruction set with one or more portions of an instruction set stored in a knowledgebase. In some embodiments, comparison may also be implemented by comparing the one or more portions of the new instruction set with portions of the instruction sets from the knowledgebase, factoring in the weights for each of the instruction set portions from the knowledgebase. As such matching some portions of the instruction set from the knowledgebase may be more important than other portions having smaller weight. In further embodiments, comparison may be implemented by comparing the new instruction set with the instruction sets from the knowledgebase, factoring in the weights for each of the instruction sets from the knowledgebase. As such matching some of the instruction sets from the knowledgebase may be more important than other instruction sets having smaller weight.
At step 1735, a determination is made if there is a substantial similarity between the one or more portions of the new instruction set and one or more portions of the instruction sets stored in the knowledgebase, such as the first instruction set. In one embodiment, during the comparison of the one or more portions of the new instruction set and the portions of the first instruction set a perfect match may be found. In other embodiments, AI DBMS may find a plurality of perfect matches with a plurality of stored instruction sets. If the number of matches exceeds a threshold for maximum number of substantial similarity results, strictness level for determining a substantial match may be modified to include an additional one or more portions of the new instruction set in order to narrow down or reduce the number of the perfect matching results. In some embodiments, if no perfect match is found, or if a number of matches is lower than a threshold for minimum amount of substantially matching results, then strictness level may be reduced to allow for finding a match that is imperfect. In some embodiments, a strictness level may be reduced to allow for a match for more important portions of the one or more portions of the new instruction set to be matched with the instruction sets in the knowledgebase. The more important portions of the one or more portions of the new instruction set may be portions including command words or keywords. For example, a substantial match may be found when SQL keywords from the one or more portions of the new instruction set match SQL keywords, and/or the order of such keywords, in one or more stored instruction sets in the knowledgebase, even if one or more variable names, data names or database names are not matched. Substantial match may also be found when a strictness level is reduced to allow a match to have all but one of the one or more portions of the new instruction set matching an instruction set in the knowledgebase. Similarly, a substantial match may be found when a strictness level is reduced to allow a match to have all but two of the one or more portions of the new instruction set matching an instruction set in the knowledgebase. Likewise, a substantial match may be found when a strictness level is reduced to allow a match to have all but three of the one or more portions of the new instruction set matching an instruction set in the knowledgebase. The one, two, or three non-matched portions of the instruction set may be portions having smaller or smallest weight. For example, the non-matched portions of the instruction set may be variable names, database names or other portions of the instruction set that may be less important than the commands or keywords, for example. Determination of substantial similarity between the one or more portions of the new instruction set and the first instruction set may include any one of, or any combination of, substantial similarity determination techniques or embodiments discussed herein.
At step 1737, the new instruction set is executed by performing, on a database, operation indicated by, or corresponding to, the new instruction set. In some embodiments, the new instruction set may be executed earlier or later in the process or not executed at all. The operation performed may include creating or deleting a database. The operation performed may include adding or deleting an entry within a database. The operation performed may include adding or deleting a row or a column within a database. The operation performed may include selecting an entry within a database. The operation performed may include any DBMS operation described herein.
At step 1740, the mobile device displays the second instruction set or its portions as options to be selected by a user. The second instruction set may be displayed in response to determining that the first instruction set is the most substantial match with the new instruction set and that the second instruction set immediately follows the first instruction set. In some embodiments, AI DBMS may select the second instruction set for display on the mobile device responsive to the determination at step 1735. In further embodiments, the second instruction set may be displayed along with one or more instruction sets that may immediately follow the second instruction set.
At step 1745, the second instruction set may be modified. In one example, the second instruction set may be modified to indicate the same database, as was indicated in the new instruction set. In another example, the second instruction set may be modified to indicate the same table or report/view, as was indicated in the new instruction set. In a further example, the second instruction set may be modified to indicate the same column or entry, as was indicated in the new instruction set, etc.
At step 1750, the operation defined by, or corresponding to, the second instruction set or the modified second instruction set is performed on a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a table of a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting of a row, column, or cell within a table of a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a report/view, relation, user account, and/or other objects in a DBMS. The operation performed may include any DBMS operation described herein.
Referring to
As shown for example in
Referring to
Associative DBMS Command Constructor 190 may include an Associative Control Unit 1900, a Key Association Database 1910, a Key Re-association Unit 1920, an Associative Selection Creator 1930, and a Command Assembler 560. Other additional elements may be included as needed, or some of the disclosed ones may be excluded, or a combination thereof may be utilized in alternate embodiments.
Referring to
In one example, at the initiation of the Associative DBMS Command Constructor 190, User 10 may be offered a Selection 2300 of the type of the Operation 610 or Instruction Set 600 the User 10 wishes to construct based on the LVL1 Association Table 2100 within the Key Association Database 1910. User 10 may press the “1” Key 2110 on the Keyboard 150. The “1” Key 2110 may be associated with the “SELECT” Instruction Set Portion 620 within the LVL1 Association Table 2100. The “SELECT” Instruction Set Portion 620 indicates the type of Operation 610 or Instruction Set 600 as the SELECT type of Operation 610 or Instruction Set 600 (i.e. SELECT type SQL statement), and therefore it may be stored in a data field of the Operation 610 and associated with the LVL1 Level 2000. The next Instruction Set Portion 620 that is at LVL2 Level 2000 may be the “FROM” keyword that has only one association (i.e. “FROM”) for the SELECT type Operation 610 or Instruction Set 600 and no User 10 selection may be needed. The next Selection 2300 the User 10 is offered may be at LVL3 Level 2000 to choose the “Tbl1, Tbl2 . . . ” representing the names of tables from which to obtain data. The next Selection 2300 the User 10 is offered may be at LVL4 Level 2000 to choose the “Col1, Col2 . . . ” representing the columns to be selected. The next Selection 2300 the User 10 is offered may be at LVL5 Level 2000 to choose the “WHERE”, “ORDER BY”, or “GROUP BY” keyword. In the case of “1” Key 2110 being pressed by the User 10 at LVL5 Level 2000 indicating the “WHERE” Instruction Set Portion 620, the next Selection 2300 the User 10 is offered may be at LVL6 Level 2000 to choose the “Col1 Operator1 Val1 AND Col2 Operator2 Val2 . . . ” representing columns, operators and values used in restricting output results. Since the “Col1 Operator1 Val1 AND Col2 Operator2 Val2 . . . ” Instruction Set Portion 620 may contain more than one object, operator and/or value, sub-selections may be offered for each. The next Selection 2300 the User 10 is offered may be at LVL7 Level 2000 to choose the “WHERE”, “ORDER BY”, or “GROUP BY” keyword. In the case of “2” Key 2110 being pressed by the User 10 at LVL7 Level 2000 indicating the “ORDER BY” Instruction Set Portion 620, the next Selection 2300 the User 10 is offered may be at LVL8 Level 2000 to choose the “Col1, Col2 . . . ” representing columns by which to sort the resulting data set. The next Selection 2300 the User 10 is offered may be at LVL9 Level 2000 to choose the “WHERE”, “ORDER BY”, or “GROUP BY” keyword. In the case of “3” Key 2110 being pressed by the User 10 at LVL9 Level 2000 indicating the “GROUP BY” Instruction Set Portion 620, the next Selection 2300 the User 10 is offered may be at LVL10 Level 2000 to choose the “Col1, Col2 . . . ” representing columns by which to group the resulting data set. Other Instruction Set Portions 620 not shown may be utilized in alternate embodiments such as functions including MIN( ), MAX( ), SUM( ), FIRST( ), LAST( ) etc.; operators including OR, LESS THAN, GREATER THAN, etc.; objects including databases, relations, user accounts, privileges, etc.; etc.
In some aspects of the current disclosure, the purpose of Levels 2000 may be to rearrange the inherent SQL (if SQL is used as the instruction set type to perform AI DBMS operations) order of constructing Operations 610 or Instruction Sets 600 in a user friendly order in which the User 10 (i.e. non-technical user) thinks of constructing Operations 610 or Instruction Sets 600. This option to rearrange the order is available where rearrangement is appropriate or where the User 10 chooses. Therefore, as shown in
At each Level 2000 the Associative Control Unit 1900 may interact with (1) the Control Program 110 to receive the User's 10 inputted Key 2110, (2) the Key Association Database 1910 to obtain the Association Table 2100 containing the Instruction Set Portions 620 appropriate for the currently inputted Key 2110 and the currently executing Level 2000, (3) the Key Re-association Unit 1920 that re-associates the Keys 2110 of the Keyboard 150 with the appropriate Instruction Set Portions 620 for the currently executing Level 2000, (4) the Associative Selection Creator 1930 that creates the Selections 2300 appropriate for the currently executing Level 2000, and/or (5) other elements. When all needed Instruction Set Portions 620 at their respective Levels 2000 are inputted the Associative Control Unit 1900 may send the completed Operation 610 to the Command Assembler 560 for assembling the Instruction Set 600 for execution. In some embodiments, Key Re-association Unit 1920 may optionally be omitted. In such embodiments, Associative Control Unit 1900 may receive the User's 10 inputted Key 2110 from the Control Program 110 and look up the associated Instruction Set Portion 620 in the Association Table 2100 containing the Instruction Set Portions 620 appropriate for the currently inputted Key 2110 and the currently executing Level 2000.
Referring to
In some embodiments, an Association Table 2100 may be implemented in any table, a database, linked arrays, linked queues, a hash table, or any data structure that can store associated elements (i.e. column-value pairs, etc.). Any or all Association Tables 2100 within a Key Association Database 1910 may be included in one Association Table 2100 in alternate embodiments. Association Tables 2100 may be pre-defined for every possible operation on each of the objects (i.e. tables, databases, etc.) in the Underlying DBMS 120. If pre-defined, Association Tables 2100 may change as the objects in the Underlying DBMS 120 change. For example, if the name of a database in the Underlying DBMS 120 changes, the Association Tables 2100 used for key associations related to this database may change to reflect the changed database name. Alternatively, Association Tables 2100 may be created on-fly or as needed in anticipation of the upcoming Instruction Set Portion 620 that the User 10 may wish to enter.
Referring to
Referring to
In some embodiments, the associative method of constructing Operations 610 or Instruction Sets 600 may include Command Assembler 560, which Command Assembler 560 may be, directly or operatively, connected to the Associative Control Unit 1900, the Core Program 110 and/or other elements to facilitate the overall system operation and implement the functionalities described herein. Once all the needed Instruction Set Portions 620 are inputted at their respective Levels 2000 as tracked by the Associative Control Unit 1900, the complete Operation 610 may be sent to the Command Assembler 560 for assembling of the Instruction Set 600 for execution. The functioning of the Command Assembler 560 is equivalent of the Command Assembler 560 previously described.
In other embodiments, the associative method of constructing Operations 610 or Instruction Sets 600 may construct an Instruction Set 600 without ever using the Operation 610 as an intermediary data structure to store Instruction Set Portions 620. For example, as the User 10 inputs the required Instruction Set Portions 620 as tracked by the Associative Control Unit 1900 at various Levels 2000, the Associative Control Unit 1900 may append the incoming Instruction Set Portions 620 as strings of characters to arrive at a complete Instruction Set 600. In this implementation without using Operations 610, Command Assembler's 560 functionality may be omitted or not fully utilized.
Referring to
In brief overview, at step 6305, a plurality of collections of instruction set portions to be used to assemble a new instruction set for performing an operation on a database are maintained on a mobile device. At step 6310, the keys of the mobile device are associated with the instruction set portions of the first collection. At step 6315, instruction set portions of the first collection along with their associated keys are displayed on the mobile device for a selection by a user. At step 6320, user selects a first key associated with an instruction set portion of the first collection. At step 6325, a first portion of the new instruction set is assembled using the instruction set portion associated with the selected first key. At step 6330, the keys of the mobile device are re-associated with instruction set portions of the second collection. At step 6335, the instruction set portions of the second collection along with their associated keys are displayed on the mobile device. At step 6340, the user selects a second key associated with an instruction set portion of the second collection. At step 6345, a second portion of the new instruction set is assembled using the instruction set portion associated with the second key. At step 6347, a determination is made if the new instruction set can be determined using method 7400 later described. At step 6350, steps 6330-6347 are repeated for all subsequent portions of the new instruction set until the new instruction set's completion. At step 6355, the operation defined by the new instruction set is performed on the database.
In further detail, at step 6305, a plurality of collections of instruction set portions are maintained on a mobile device. The instruction set portions may be used to assemble a new instruction set for performing an operation on some data in a database. The collections of instruction set portions may be maintained, organized and/or stored in various arrangements including tables, databases, DBMSs, memory structures, data structures, etc. In some embodiments, the collections of instruction set portions may be ordered to include a first collection, followed by a second collection, which may also be followed by a third collection, and so on, to complete the instruction set. The first collection of instruction set portions may include all possible or most likely first instruction set portions where the user may select among the possibilities, the second collection of instruction set portions may include all possible or most likely second instruction set portions where the user may select among the possibilities, and so on. In some embodiments, the collections of instruction set portions may be pre-defined for all possible or most used operations on each of the objects (i.e. tables, databases, reports/views, relations, user accounts, etc.) in the DBMS and the collections of instruction set portions may change as the objects in the DBMS change. In other embodiments, the collections of instruction set portions may be created on-fly or as needed in anticipation of the upcoming instruction set portion that the user may wish to enter.
At step 6310, the keys of the mobile device are associated with the instruction set portions of the first collection. A key may include any press-able key of a keyboard, any push-able button of the mobile device, any touch-able areas of a touch screen, any click-able component of the mobile device, any slide-able component of the mobile device, a text field, selectable list, drop-down menu, or other physical or graphical elements that may enable a user to input instructions or data. Keys of any internal or external input device such as keyboard, mouse, touch screen, control wheel, remote control, etc. may be used and/or associated with the instruction set portions of the first collection. In some embodiments, the first collection of instruction set portions may be included in a data structure such as a table comprising a column for the keys and a column for the associated instruction set portions of the first collection. Therefore, an association may be established between a key and an instruction set portion of the first collection in the same row of the table. Associating may include any action or operation by or for a Key Re-association Unit 1920.
At step 6315, instruction set portions of the first collection along with their associated keys are displayed on the mobile device for a selection by a user. The user may view on the display of the mobile device which keys of the mobile device may be associated with specific instruction set portions of the first collection. In some embodiments, the display may include keys pointing with arrows or other such signs or indicia to their associated instruction set portions of the first collection indicating the associations for user's consideration. Displaying may include any action or operation by or for an Associative Selection Creator 1930.
At step 6320, user selects a first key associated with an instruction set portion of the first collection. The first key may be received by the interface for a DMBS. The first key may be received by the mobile device, or by any other mobile device or a computing device in general. The first key may be received by any component of the AI DBMS. User may select the first key by using a key of the mobile device associated with one of the instruction set portions of the first collection. The associated instruction set portion of the first collection may identify or indicate one or more commands, keywords, instructions, operators, variables, values, objects, functions and/or other components of the new instruction set to be assembled.
At step 6325, a first portion of the new instruction set is assembled using the instruction set portion associated with the selected first key. In some embodiments, assembling may include storing the first instruction set portion in a data structure such as an array, linked list, table, etc. comprising all known instruction set portions of the new instruction set. In other embodiments, assembling may include appending the first instruction set portion to a string of characters (in the case of the first instruction set portion an empty string) containing the known instruction set portions of the new instruction set. Assembling may include any action or operation by or for an Associative Control Unit 1900.
At step 6330, the keys of the mobile device are re-associated with instruction set portions of the second collection. Step 6330 may include any action or operation described in Step 6310 as applicable.
At step 6335, the instruction set portions of the second collection along with their associated keys are displayed on the mobile device. Step 6335 may include any action or operation described in Step 6315 as applicable.
At step 6340, the user selects a second key associated with an instruction set portion of the second collection. Step 6340 may include any action or operation described in Step 6320 as applicable.
At step 6345, a second portion of the new instruction set is assembled using the instruction set portion associated with the second key. Step 6345 may include any action or operation described in Step 6325 as applicable.
At step 6347, a determination is made if the new instruction set can be determined using method 7400 later described. In some embodiments, method 7400 may be used for predicting the new instruction set by comparing its known instruction set portions with instruction set portions of prior stored instructions sets. Therefore, if enough instruction set portions of the new instruction set are known the new instruction set may be identified before the user inputs all needed instruction set portions.
At step 6350, steps 6330-6347 are repeated for all subsequent portions of the new instruction set until the new instruction set's completion. Steps 6330-6347 may be performed repeatedly with subsequent collections of instruction set portions to assemble the new instruction set one instruction set portion at a time. Once all the needed instruction set portions are known the new instruction set may be complete. In embodiments where the intermediary data structure (i.e. array, linked list, table, etc.) is used for storing known instruction set portions of the new instruction set as previously described, the complete new instruction set may be assembled from the instruction set portions in the data structure before being sent to DBMS for execution. Assembling may include any action or operation by or for a Command Assembler 560. In embodiments where appending is performed of known instruction set portions the new instruction set as previously described, the complete new instruction set may be directly sent to DBMS for execution.
At step 6355, the operation defined by the new instruction set is performed on the database. The operation defined by, or corresponding to, the assembled new instruction set is executed on a DBMS. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a table of a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting of a row, column, or cell within a table of a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a report/view, relation, user account, and/or other objects in a DBMS. The operation performed may include any DBMS operation described herein.
Referring to
As shown in
Referring to
Associative SDCL Constructor 2400 may include Associative Control Unit 1900, SDCL Association Database 2500, Phrase Re-association Unit 2510, Associative Selection Creator 2520, and Command Assembler 560. Other additional elements may be included as needed, or some of the disclosed ones may be excluded, or a combination thereof may be utilized in alternate embodiments.
Referring to
In one example, at the initiation of the Associative SDCL Constructor 2400, User 10 may input or select a Phrase 2610 “GET DATA”. The Phrase 2610 “GET DATA” may be associated with the “SELECT” Instruction Set Portion 620 within the LVL1 Association Table 2100. The “SELECT” Instruction Set Portion 620 indicates the type of Operation 610 or Instruction Set 600 as the SELECT type of Operation 610 or Instruction Set 600 (i.e. SELECT type SQL statement), and therefore it may be stored in a data field of the Operation 610 and associated with the LVL1 Level 2000. The next Phrase 2610 the User 10 may be required to input or select is at LVL2 Level 2000 to input or select one of the Phrases 2610 associated with the keyword “FROM”. The next Phrase 2610 the User 10 may be required to input or select is at LVL3 Level 2000 to input or select “Tbl1, Tbl2 . . . ” representing the names of tables from which to obtain data. The next Phrase 2610 the User 10 may be required to input or select is at LVL4 Level 2000 to input or select “Col1, Col2 . . . ” representing the columns to be selected. The next Phrase 2610 the User 10 may be required to input or select is at LVL5 Level 2000 to input or select “WHERE”, “ORDER BY”, or “GROUP BY” keyword. In the case of “FILTER” Phrase 2610 being inputted or selected by the User 10 at LVL5 Level 2000 indicating the “WHERE” Instruction Set Portion 620, the next Phrase 2610 the User 10 may be required to input or select is at LVL6 Level 2000 to input or select “Col1 Operator1 Val1 AND Col2 Operator2 Val2 . . . ” representing columns, operators and values used in restricting output results. Since “Col1 Operator1 Val1 AND Col2 Operator2 Val2 . . . ” may contain more than one object, operator and/or value, sub-inputs may be required for each in one embodiment. The next Phrase 2610 the User 10 may be required to input or select is at LVL7 Level 2000 to input or select “WHERE”, “ORDER BY”, or “GROUP BY” keyword. In the case of “SORT” Phrase 2610 being inputted or selected by the User 10 at LVL7 Level 2000 indicating the “ORDER BY” Instruction Set Portion 620, the next Phrase 2610 the User 10 may be required to input or select is at LVL8 Level 2000 to input or select “Col1, Col2 . . . ” representing columns by which to sort the resulting data set. The next Phrase 2610 the User 10 may be required to input or select is at LVL9 Level 2000 to input or select “WHERE”, “ORDER BY”, or “GROUP BY” keyword. In the case of “SUMMARIZE” Phrase 2610 being inputted or selected by the User 10 at LVL9 Level 2000 indicating the “GROUP BY” Instruction Set Portion 620, the next Phrase 2610 the User 10 may be required to input or select is at LVL10 Level 2000 to input or select “Col1, Col2 . . . ” representing columns by which to group the resulting data set. Other Instruction Set Portions 620 not shown may be utilized in alternate embodiments such as functions including MIN( ), MAX( ), SUM( ), FIRST( ), LAST( ) etc.; operators including OR, LESS THAN, GREATER THAN, etc.; objects including databases, relations, user accounts, privileges, etc.; etc.
At each Level 2000 the Associative Control Unit 1900 may interact with (1) the Control Program 110 to obtain the User's 10 inputted or selected Phrase 2610, (2) the SDCL Association Database 2500 to obtain the Association Table 2100 containing the Instruction Set Portions 620 appropriate for the currently inputted Phrase 2610 and currently executing Level 2000, (3) the Phrase Re-association Unit 2510 that re-associates Phrases 2610 with appropriate Instruction Set Portions 620 for the currently executing Level 2000, (4) the Associative Selection Creator 2520 that creates the Selections 2300 appropriate for the currently executing Level 2000, and/or (5) other elements. When all needed Instruction Set Portions 620 at their respective Levels 2000 are inputted or selected the Associative Control Unit 1900 may send the completed Operation 610 to the Command Assembler 560 for assembling the Instruction Set 600 for execution. In some embodiments, Phrase Re-association Unit 2510 may optionally be omitted. In such embodiments, Associative Control Unit 1900 may receive the User's 10 inputted Phrase 2610 from the Control Program 110 and look up the associated Instruction Set Portion 620 in the Association Table 2100 containing the Instruction Set Portions 620 appropriate for the currently inputted Phrase 2610 and the currently executing Level 2000.
An extended example of the LVL1 Association Table 2100 may be as follows:
Phrase Inst Set Por
It should be understood that Phrases 2610 and their associated Instruction Set Portions 620 included in this LVL1 Association Table 2100 are examples of some possible Phrases 2610 that may be included in this LVL1 Association Table 2100 or any other Association Table 2100. Any Phrases 2610 and their associated Instruction Set Portions 620 included in this LVL1 Association Table 2100 or any other Association Table 2100 may be defined by the User 10 or system administrator, or by AI DBMS itself through a Phrase 2610 recording process (i.e. recording user phrases as the user uses them and asking the user to assign associated Instruction Set Portions 620). Phrases 2610 and their associated Instruction Set Portions 620 may also be defined based on the type of DBMS application, experience, testing, logs, inquiry, analysis, synthesis or other techniques in alternate implementations. In general, other additional Phrases 2610 and their associated Instruction Set Portions 620 may be included as needed, or some of the disclosed ones may be excluded, or a combination thereof may be utilized in alternate embodiments.
Phrase Re-association Unit 2510 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for associating or re-associating Phrases 2610 with Instruction Set Portions 620 of an Operation 610 or Instruction Set 600. Phrase Re-association Unit 2510 may include functions and algorithms for associating or re-associating Phrases 2610 with Instruction Set Portions 620 of an Operation 610 or Instruction Set 600 appropriate for the currently executing Level 2000. For example, at LVL7 Level 2000 the Phrase Re-association Unit 2510 may associate Phrases 2610 with Instruction Set Portions 620 using the LVL7 Association Table 2100 containing Instruction Set Portions 620 “WHERE”, “ORDER BY”, and “GROUP BY” and their associated Phrases 2610. Once User 10 inputs a Phrase 2610 “SORT” for example indicating “ORDER BY” Instruction Set Portions 620, Phrase Re-association Unit 2510 may re-associate Phrases 2610 using the LVL8 Association Table 2100 containing Instruction Set Portions 620 “Col1”, “Col2”, etc. and their associated Phrases 2610 indicating the columns by which to sort the resulting data set. Phrase Re-association Unit 2510 may be, directly or operatively, connected to the Associative Control Unit 1900, the Core Program 110 and/or other elements to facilitate the overall system operation and implement the functionalities described herein. Phrase Re-association Unit 2510 may include some or all the features and embodiments of the previously described Key Re-association Unit 1920.
Associative Selection Creator 2520 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for creating or re-creating Selections 2300 for consideration by the user. Associative Selection Creator 2520 may include functions and algorithms for creating or re-creating Selections 2300 for consideration by the user appropriate for the currently executing Level 2000. For example, at LVL7 Level 2000 the Display 170 may include a Selection 2300 that may show entries of the LVL7 Association Table 2100 containing Instruction Set Portions 620 “WHERE”, “ORDER BY”, and “GROUP BY” and their associated Phrases 2610. Once User 10 inputs a Phrase 2610 “SORT” for example indicating “ORDER BY” Instruction Set Portions 620, Associative Selection Creator 2520 may create a Selection 2300 using the LVL8 Association Table 2100 containing Instruction Set Portions 620 “Col1”, “Col2”, etc. and their associated Phrases 2610 indicating the columns by which to sort the resulting data set. Associative Selection Creator 2520 may be, directly or operatively, connected to the Associative Control Unit 1900, the Core Program 110 and/or other elements to facilitate the overall system operation and implement the functionalities described herein. Associative Selection Creator 2520 may include some or all the features and embodiments of the previously described Associative Selection Creator 1930.
In some embodiments, User 10 may input an entire sentence that may then be matched against Association Tables 2100 to decipher the Phrases 2610 and/or their associated Instruction Set Portions 620. For example, User 10 may input a sentence “SHOW DATA IN Tbl4”. The words in this sentence may then be matched with the Phrases 2610 in LVL1 Association Table 2100 and it is found that “SHOW DATA” is a Phrase 2610 within the LVL1 Association Table 2100. The Phrase 2610 “SHOW DATA” may be associated with the “SELECT” Instruction Set Portion 620, it may indicate the type of Operation 610 or Instruction Set 600 as the SELECT type of Operation 610 or Instruction Set 600 (i.e. SELECT type SQL statement), and therefore it may be stored in a data field of the Operation 610 and associated with LVL1 Level 2000. The words in the rest of the sentence (“IN Tbl4”) may then be matched with the Phrases 2610 in LVL2 Association Table 2100 and it is found that “IN” is a Phrase 2610 within the LVL2 Association Table 2100. The Phrase 2610 “IN” may be associated with the “FROM” Instruction Set Portion 620 and therefore it may be stored in a data field of the Operation 610 and associated with LVL2 Level 2000. The words in the rest of the sentence (“Tbl4”) may then be matched with the Phrases 2610 in LVL3 Association Table 2100 and it is found that “Tbl4” is a Phrase 2610 within the LVL3 Association Table 2100. The Phrase 2610 “Tbl4” may be associated with the “Tbl4” Instruction Set Portion 620 and therefore it may be stored in a data field of the Operation 610 and associated with LVL3 Level 2000. The described matching process may continue for any number of words or phrases in the sentence and for any number of Association Tables 2100. If User 10 wishes to construct a longer or more detailed Operation 610 or Instruction Set 600 that may include filtered, sorted, and/or summarized results, etc. additional Phrases 2610 and/or their Instruction Set Portions 620 may then be obtained from the User 10 in the associative process previously described.
Referring to
In brief overview, at step 2605, a plurality of collections of instruction set portions to be used to assemble a new instruction set for performing an operation on a database are maintained on a mobile device. At step 2610, user preferred phrases are associated with the instruction set portions of the first collection. At step 2615, instruction set portions of the first collection along with their associated phrases are displayed on the mobile device for a selection by a user. At step 2620, user inputs or selects a first phrase associated with an instruction set portion of the first collection. At step 2625, a first portion of the new instruction set is assembled using the instruction set portion associated with the selected first phrase. At step 2630, the phrases are re-associated with instruction set portions of the second collection. At step 2635, the instruction set portions of the second collection along with their associated phrases are displayed on the mobile device. At step 2640, the user inputs or selects a second phrase associated with an instruction set portion of the second collection. At step 2645, a second portion of the new instruction set is assembled using the instruction set portion associated with the second phrase. At step 2647, a determination is made if the new instruction set can be determined using method 7400 later described. At step 2650, steps 2630-2647 are repeated for all subsequent portions of the new instruction set until the new instruction set's completion. At step 2655, the operation defined by the new instruction set is performed on the database.
In further detail, at step 2605, a plurality of collections of instruction set portions are maintained on a mobile device. The instruction set portions may be used to assemble a new instruction set for performing an operation on some data in a database. The collections of instruction set portions may be maintained, organized and/or stored in various arrangements including tables, databases, DBMSs, memory structures, data structures, etc. In some embodiments, the collections of instruction set portions may be ordered to include a first collection, followed by a second collection, which may also be followed by a third collection, and so on, to complete the instruction set. The first collection of instruction set portions may include all possible or most likely first instruction set portions where the user may select among the possibilities, the second collection of instruction set portions may include all possible or most likely second instruction set portions where the user may select among the possibilities, and so on. In some embodiments, the collections of instruction set portions may be pre-defined for all possible or most used operations on each of the objects (i.e. tables, databases, reports/views, relations, user accounts, etc.) in the DBMS and the collections of instruction set portions may change as the objects in the DBMS change. In other embodiments, the collections of instruction set portions may be created on-fly or as needed in anticipation of the upcoming instruction set portion that the user may wish to enter.
At step 2610, user preferred phrases are associated with the instruction set portions of the first collection. In some embodiments, a phrase may include one or more letters, one or more numbers, one or more symbols, one or more alphanumeric or any other characters, a word, an acronym, a group of words or acronyms, or a sentence each including all of its semantic variations. In some embodiments, user preferred phrases may include phrases that a non-technical user may typically associate with instruction set portions of an instruction set such as the new instruction set. Phrases may be inputted through any internal or external input device such as keyboard, mouse, touch screen, control wheel, remote control, microphone, etc. In some embodiments, the first collection of instruction set portions may be included in a data structure such as a table comprising a column for the phrases and a column for the associated instruction set portions of the first collection. Therefore, an association may be established between a phrase and an instruction set portion of the first collection in the same row of the table. Associating may include any action or operation by or for a Phrase Re-association Unit 2510.
At step 2615, instruction set portions of the first collection along with their associated phrases are displayed on the mobile device for a selection by a user. The user may view on the display of the mobile device which phrases may be associated with specific instruction set portions of the first collection. In some embodiments, the display may include phrases pointing with arrows or other such signs or indicia to their associated instruction set portions of the first collection indicating the associations for user's consideration. Displaying may include any action or operation by or for an Associative Selection Creator 2520.
At step 2620, user inputs or selects a first phrase associated with an instruction set portion of the first collection. The first phrase may be received by the interface for a DMBS. The first phrase may be received by the mobile device, or by any other mobile device or a computing device in general. The first phrase may be received by any component of the AI DBMS. User may input or select the first phrase by using the keyboard of the mobile device for example, and the first phrase may be associated with one of the instruction set portions of the first collection. The associated instruction set portion of the first collection may identify or indicate one or more commands, keywords, instructions, operators, variables, values, objects, functions and/or other components of the new instruction set to be assembled.
At step 2625, a first portion of the new instruction set is assembled using the instruction set portion associated with the selected first phrase. In some embodiments, assembling may include storing the first instruction set portion in a data structure such as an array, linked list, table, etc. comprising all known instruction set portions of the new instruction set. In other embodiments, assembling may include appending the first instruction set portion to a string of characters (in the case of the first instruction set portion an empty string) containing the known instruction set portions of the new instruction set. Assembling may include any action or operation by or for an Associative Control Unit 1900.
At step 2630, the phrases are re-associated with instruction set portions of the second collection. Step 2630 may include any action or operation described in Step 2610 as applicable.
At step 2635, the instruction set portions of the second collection along with their associated phrases are displayed on the mobile device. Step 2635 may include any action or operation described in Step 2615 as applicable.
At step 2640, the user inputs or selects a second phrase associated with an instruction set portion of the second collection. Step 2640 may include any action or operation described in Step 2620 as applicable.
At step 2645, a second portion of the new instruction set is assembled using the instruction set portion associated with the second phrase. Step 2645 may include any action or operation described in Step 2625 as applicable.
At step 2647, a determination is made if the new instruction set can be determined using method 7400 later described. In some embodiments, method 7400 may be used for predicting the new instruction set by comparing its known instruction set portions with instruction set portions of prior stored instructions sets. Therefore, if enough instruction set portions of the new instruction set are known the new instruction set may be identified before the user inputs all needed instruction set portions.
At step 2650, steps 2630-2647 are repeated for all subsequent portions of the new instruction set until the new instruction set's completion. Steps 2630-2647 may be performed repeatedly with subsequent collections of instruction set portions to assemble the new instruction set one instruction set portion at a time. Once all the needed instruction set portions are known the new instruction set may be complete. In embodiments where the intermediary data structure (i.e. array, linked list, table, etc.) is used for storing known instruction set portions of the new instruction set as previously described, the complete new instruction set may be assembled from the instruction set portions in the data structure before being sent to DBMS for execution. Assembling may include any action or operation by or for a Command Assembler 560. In embodiments where appending is performed of known instruction set portions the new instruction set as previously described, the complete new instruction set may be directly sent to DBMS for execution.
At step 2655, the operation defined by the new instruction set is performed on the database. The operation defined by, or corresponding to, the assembled new instruction set is executed on a DBMS. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a table of a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting of a row, column, or cell within a table of a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a report/view, relation, user account, and/or other objects in a DBMS. The operation performed may include any DBMS operation described herein.
Referring to
As shown in
In some embodiments, Speech Recognizer 2700 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for processing input events of the Microphone 2710 for use by the Core Program 110 or other elements of the current disclosure. Speech Recognizer 2700 may include functions and algorithms for “listening” to voice events on the Microphone 2710, interpreting the voice events as User's 10 voice commands, and transmitting the voice commands for use by the Core Program 110. Speech Recognizer 2700 may fall under the general description of the previously described Input Interface 140, and while it includes all the aforementioned embodiments, it is described separately in this embodiment to offer additional detail on its functioning. Speech Recognizer 2700 may be implemented by utilizing (1) a Mobile Device 20 operating system's speech recognition functionality such as iOS's Voice Services, Siri, etc. which may come inherently as the part of the mobile device package; (2) a Java Speech API (JSAPI) or any of its implementations such as The Cloud Garden, Sphinx, etc.; or (3) applications or engines providing speech recognition functionality such as OpenEars, Dragon Mobile, iSpeech, CeedVocal, Flite, Julius, etc. AI DBMS with Speech Recognizer 2700 may enable User 10 to construct Operations 610 or Instruction Sets 600 (1) by issuing voice commands (i.e. phrases, etc.) combined with the associative SDCL constructing process previously described, (2) by issuing voice commands combined with the key associative DBMS command constructing process previously described, or (3) by issuing voice commands only.
In some embodiments, AI DBMS may use the Mobile Device 20 operating system's speech recognition functionality as the Speech Recognizer 2700. The Core Program 110 may use the operating system's native speech recognition API such as the iOS Voice Services to obtain User's 10 voice commands. This way, Microphone 2710 may detect User's 10 voice event; the iOS Voice Services may interpret the voice event as User's 20 voice command and make the voice event available as data (i.e. text, instruction, instruction set, command, object, data structure, etc.) to the Core Program 110; and the Core Program 110 may pass the data to the Associative SDCL Constructor 2400 as a Phrase 2610 for associating with Instruction Set Portions 620.
In other embodiments, AI DBMS may use a Java Speech API (JSAPI) implementation as the Speech Recognizer 2700. The Core Program 110 may use a JSAPI implementation such as The Cloud Garden to obtain User's voice commands. This way, Microphone 2710 may detect User's 10 voice event; the Cloud Garden JSAPI may interpret the voice event as User's 20 voice command and make the voice event available as data (i.e. text, instruction, instruction set, command, object, data structure, etc.) to the Core Program 110; and the Core Program 110 may pass the data to the Associative SDCL Constructor 2400 as a Phrase 2610 for associating with Instruction Set Portions 620.
In further embodiments, AI DBMS may use applications or engines providing speech recognition functionality as the Speech Recognizer 2700. The Core Program 110 may use an application or engine such as the OpenEars Software Development Kit (SDK) to obtain User's voice commands. This way, Microphone 2710 may detect User's 10 voice event; the OpenEars SDK may interpret the voice event as User's 20 voice command and make the voice event available as data (i.e. text, instruction, instruction set, command, object, data structure, etc.) to the Core Program 110; and the Core Program 110 may pass the data to the Associative SDCL Constructor 2400 as a Phrase 2610 for associating with Instruction Set Portions 620.
Depending on resource availability Speech Recognizer 2700 may be implemented as keyword spotting or as full speech recognition. Keyword spotting may attempt to find only a select group of words and/or phrases, and because of this limited lexicon it consumes fewer resources. In the case of keyword spotting implementation, Phrases 2610 within Association Tables 2100 may define the select group of words and/or phrases to be searched. Full speech recognition may attempt to find all the words and/or phrases that have been spoken, and because of this broader lexicon it consumes significant resources. In the case of full speech recognition implementation, the broadness of words and/or phrases would by definition include all the Phrases 2610 within the Association Tables 2100. In some embodiments, both keyword spotting and full speech recognition implementations may include a database of words and/or phrases located locally on the Mobile Device 20 or remotely on a remote Computing Device 1310 accessible over the Network 1300.
Microphone 2710 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for receiving and/or detecting User's voice events or inputs. Most modern mobile devices include Microphone 2710 as one of the input devices.
Referring to
An embodiment is illustrated in
Associative SDCL Constructor 2400 may include the Associative Control Unit 1900, the SDCL Association Database 2500, the Phrase Re-association Unit 2510, the Associative Selection Creator 2520, the Command Assembler 560, and the Associative SDCL Artificial Intelligence 2800. Other additional elements may be included as needed, or some of the disclosed ones may be excluded, or a combination thereof may be utilized in alternate embodiments.
Referring to
Associative SDCL Artificial Intelligence 2800 may include a Phrase List 2910, a Knowledge Structuring Unit 2920, a Knowledgebase 2930, a Decision-making Unit 2940, and a User Confirmation Unit 2950. Other additional elements may be included as needed, or some of the disclosed ones may be excluded, or a combination thereof may be utilized in alternate embodiments.
Referring to
Phrase List 2910 may receive a Phrase 2610 or Instruction Set Portion 620 from the Associative Control Unit 1900 and store any number of Phrases 2610 or Instruction Set Portions 620 that were recently used or implemented by the system. The number of Phrases 2610 or Instruction Set Portions 620 recently used or implemented may vary depending on the embodiments and one of ordinary skill in the art would recognize that the number of stored Phrases 2610 or Instruction Set Portions 620 may be any number that may be stored in any memory or storage described herein as previously described.
In one embodiment, in which the last five Phrases 2610 or Instruction Set Portions 620 may be stored in the Phrase List 2910, Phrases 2610 or Instruction Set Portions 620 may be identified such that the current Phrase 2610 or Instruction Set Portion 620 is identified as Phrase n, the most recent Phrase 2610 or Instruction Set Portion 620 prior to the current may be identified as Phrase n−1, and so on until the least most recent Phrase 2610 or Instruction Set Portion 620 being stored is labeled as Phrase n−4. In such embodiments, each time the Phrase List 2910 receives another new Phrase 2610 or Instruction Set Portion 620 from the Associative Control Unit 1900, it may erase the least recent Phrase 2610 or Instruction Set Portion 620, such as Phrase n−4, and insert the new Phrase 2610 or Instruction Set Portion 620 received as Phrase n. Naturally, all the most recently used or implemented Phrases 2610 or Instruction Set Portions 620 that are stored in this list or queue may be shifted by one count further towards Phrase n−4. This way, the system may maintain a queue of stored recently used or implemented Phrases 2610 or Instruction Set Portions 620, where the queue may include any number of stored Phrases 2610 or Instruction Set Portions 620 as previously described.
Still referring to
Referring to
In one example, Knowledge Structuring Unit 2920 may receive the current Phrase List 2910 and may create a Knowledge Cell 801 by copying Phrase n from the Phrase List 2910 into Phrase n+2 of the Knowledge Cell 801, by copying Phrase n−1 from the Phrase List 2910 into Phrase n+1 of the Knowledge Cell 801, by copying Phrase n−2 from the Phrase List 2910 into Phrase n of the Knowledge Cell 801, and so forth. Knowledge Cell 801 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for storing a recorded sequence of the User's 10 Phrases 2610 or Instruction Set Portions 620. In effect, when a Knowledge Cell 801 is created it may include any data structure (i.e. array, list, linked list, table, etc.) that may store a recorded sequence of the User's 10 Phrases 2610 or Instruction Set Portions 620 where, for example, Phrase n, Phrase n−1, and Phrase n−2 may later be used for comparison with the then User's 10 current and recent Phrases 2610 or Instruction Set Portions 620, and Phrase n+1 and Phrase n+2 may later be used for anticipation of the User's 10 future Phrases 2610 or Instruction Set Portions 620. Knowledge Cell 801 may include some or all the features and embodiments of the previously described Knowledge Cell 800.
Referring to
As shown in
Referring to
In some embodiments, AI DBMS may anticipate one or more Phrases 2610 or Instruction Set Portions 620 the user may intend to enter while the User 10 is entering initial Phrases 2610 or Instruction Set Portions 620 of an Operation 610 or Instruction Set 600. In other embodiments, AI DBMS may anticipate a full Operation 610 or Instruction Set 600 while the User 10 is entering initial Phrases 2610 or Instruction Set Portions 620.
Decision-making Unit 2940 may anticipate the User's 10 future Phrases 2610 or Instruction Set Portions 620 by performing Substantial Similarity Comparisons 1020 between the current Phrase List 2910 and the Knowledge Cells 801 stored in the Knowledgebase 2930. Substantial Similarity Comparison 1020 and the included Comparison Strictness Function 1021 may include some or all the features and embodiments of the previously described Substantial Similarity Comparison 1010 and Comparison Strictness Function 1011 respectively.
As previously described, Substantial Similarity Comparison 1020 may comprise algorithms, functions and/or logic for performing matching or comparisons and for determining that while a perfect match is not found, a substantially similar match has been found. Substantial Similarity Comparison 1020 may therefore identify a sequence of Phrases 2610 or Instruction Set Portions 620 from a Phrase List 2910 that is most like a sequence of Phrases 2610 or Instruction Set Portions 620 from a Knowledge Cell 801 in a Knowledgebase 2930, even if the sequence of Phrases 2610 or Instruction Set Portions 620 from the Phrase List 2910 is different from the sequence of Phrases 2610 or Instruction Set Portions 620 in the Knowledge Cell 801. Furthermore, Substantial Similarity Comparison 1020 may also identify a Phrase 2610 or Instruction Set Portion 620 from a Phrase List 2910 that is most like a Phrase 2610 or Instruction Set Portion 620 from a Knowledge Cell 801 in a Knowledgebase 2930, even if the Phrase 2610 or Instruction Set Portion 620 from the Phrase List 2910 is different from the Phrase 2610 or Instruction Set Portion 620 in the Knowledge Cell 801.
As previously described, Comparison Strictness Function 1021 may also adjust the strictness level by choosing the number of Phrases 2610 or Instruction Set Portions 620 that it will use to find a substantial similarity match between the Phrases 2610 or Instruction Set Portions 620 in the Phrase List 2910 and the corresponding (i.e. comparative) Phrases 2610 or Instruction Set Portions 620 in the Knowledgebase 2930. For example, as a User 10 is inputting first three Phrases 2610 or Instruction Set Portions 620 of an Operation 610 or Instruction Set 600 the User 10 may intend to implement, Comparison Strictness Function 1021 may run these three Phrases 2610 or Instruction Set Portions 620 against Phrases 2610 or Instruction Set Portions 620 in the Knowledgebase 2930. If the Substantial Similarity Comparison 1020 provides a number of matching results (results that have perfect equivalence) that is above a particular threshold, the Comparison Strictness Function 1021 may decide to increase the strictness of the rules to decrease the number of results. AI DBMS may then decide to wait for the User 10 to add the fourth Phrase 2610 or Instruction Set Portion 620, thereby allowing the Substantial Similarity Comparison 1020 to use the fourth Phrase 2610 or Instruction Set Portion 620 in addition to the earlier three to find a smaller number of matching results. Once the user adds the fourth Phrase 2610 or Instruction Set Portion 620, the Substantial Similarity Comparison 1020 may use all four Phrases 2610 or Instruction Set Portions 620 to find a match. If the number of matching results (results that perfectly match, i.e. total equivalence) is sufficiently small, the system may present the User 10 with these results. If however, the number of matching results is still too high, the Comparison Strictness Function 1021 may determine to further increase the strictness by requiring the user to add additional Phrases 2610 or Instruction Set Portions 620 and thereby further narrow the search results before presenting the user with the suggested results. In some embodiments, Phrases 2610 or Instruction Set Portions 620 added may include a portion of a command or a keyword, such as a first one or more letters of a Phrase 2610 or Instruction Set Portion 620.
Comparison Strictness Function 1021 may therefore increase and decrease the strictness of the rules for finding a substantial similarity match depending on the number of Phrases 2610 or Instruction Set Portions 620 the user has already entered and/or whether or not perfect matches had been found. As such, Comparison Strictness Function 1021 may utilize two thresholds, the upper and a lower threshold, to determine the strictness of the rules used for determining the substantial similarity match. The upper threshold may correspond to the number of substantial similarity matches that are too high to be presented to the user (i.e. too many matching results, too vague suggestions). Alternatively, the lower threshold may correspond to the strictness level that results in too few results to be presented to the user. Comparison Strictness Function 1021 may make any combination of the aforementioned adjustments to achieve that the number of substantial similarity matches falls between the upper and the lower threshold. As such, Comparison Strictness Function 1021 may keep adjusting the strictness rules for finding the substantially similar match until both thresholds are satisfied, thereby adjusting the results until the best set of results is found.
Referring to
As shown in
The context in which the Phrases 2610 or Instruction Set Portions 620 from the Phrase List 2910 were performed may be analyzed by the Context Interpreter 1121. In one embodiment, context may be defined as any sub-segment of a Phrase 2610 or Instruction Set Portion 620 that is not used in the Substantial Similarity Comparison 1020, or any information about the Phrases 2610 or Instruction Set Portions 620 from the Phrase List 2910 that may be useful in anticipating User's 10 future Phrases 2610 or Instruction Set Portions 620, or Operations 610 or Instruction Sets 600. In effect, Context Interpreter 1121 may represent an extra analysis step and it may attempt to capture all information and/or elements that may have been omitted by the Substantial Similarity Comparison 1020, and/or by the other process steps or elements.
As previously described, an example of Context Interpreter's 1121 usefulness is the fact that values may be omitted from Substantial Similarity Comparisons 1020 in some embodiments. It is Context Interpreter's 1121 responsibility to discover the values or the ranges of values used in the User's recent Phrases 2610 or Instruction Set Portions 620 by extracting the values from the Phrases 2610 or Instruction Set Portions 620.
Referring to
In brief overview, at step 3405, a mobile device receives a sequence of first and second instruction set portions of an instruction set for performing an operation on a database. The sequence may include an order of consecutive instruction set portions, such as for example a first instruction set portion followed by a second instruction set portion. At step 3410, the sequence of the instruction set portions is stored into a knowledgebase that comprises plurality sequences of instruction set portions. At step 3415, the mobile device receives a new instruction set portion of a new instruction set for performing an operation on a database. At step 3420, the new instruction set portion is compared with instruction set portions in the knowledgebase. At step 3425, a determination is made that there is a substantial similarity between the new instruction set portion and the first instruction set portion. At step 3430, the second instruction set portion is displayed on the mobile device as an option to be selected by a user. At step 3435, the second instruction set portion is modified in response to edits by the user, should the user decide to modify the second instruction set portion. At step 3440, a portion of the new instruction set is assembled using the new instruction set portion and a different portion of the new instruction set is assembled using the second instruction set portion or the modified second instruction set portion. At step 3445, steps 3415-3440 are repeated for all subsequent portions of the new instruction set until the new instruction set's completion. At step 3450, the operation defined by the new instruction set is performed on the database.
In further detail, at step 3405, a mobile device receives a sequence of first and second instruction set portions of an instruction set for performing an operation on a database. Each instruction set portion may indicate or identify one or more commands, keywords, instructions, operators, variables, values, objects, functions and/or other components of an instruction set for performing an operation on some data in some database. The sequence may include a first instruction set portion, followed by a second instruction set portion, which may also be followed by a third instruction set portion, and so on. Instruction set portions of the sequence may be received by the interface for a DMBS. Instruction set portions of the sequence may be received by any component of the AI DBMS. Instruction set portions of the sequence may be received by the mobile device, or by any other mobile device or a computing device in general.
At step 3410, the sequence of the instruction set portions is stored into a knowledgebase that comprises plurality sequences of instruction set portions. The knowledgebase may comprise any number of instruction set portions and/or sequences of instruction set portions, each of which may be stored in various arrangements, including tables, database, memory structures, data structures, etc. In some embodiments, knowledgebase may include instruction set portions and/or sequences of instruction set portions from the mobile device via which the instruction set portions and/or sequences are received. In other embodiments, knowledgebase may include instruction set portions and/or sequences of instruction set portions from any number of computing devices. Knowledgebase or additional knowledgebases may also be populated to include the user specific and/or group specific informations gathered with respect to the instruction set portions and/or sequences of instruction set portions. Also stored in knowledgebase may be the weight assigned to each instruction set portion.
At step 3415, the mobile device receives a new instruction set portion of a new instruction set for performing an operation on a database. The new instruction set portion may identify or indicate any commands, keywords, instructions, operators, variables, values, objects, functions and/or other components of an instruction set for performing an operation on a database indicated herein. For instance, the new instruction set portion may include a keyword “DELETE” indicating an operation to delete an entry in a database. In another example, the new instruction set portion may include keyword(s) “CREATE TABLE” indicating an operation to create a table in a database. The new instruction set portion may include any keyword(s) to indicate any other operations such as for example to select, add, delete, or modify an entry; add, delete, or modify a column; add, delete, or modify a table; add, delete, or modify a database; add, delete, or modify a relation; add, delete, or modify a user account; etc. The new instruction set portion of the new instruction set may be for performing some operation on some database managed by the AI DBMS. The new instruction set portion may be stored into instruction set portion lists.
At step 3420, the new instruction set portion is compared with instruction set portions in the knowledgebase. In one embodiment, the new instruction set portion may be compared as a single string of characters with a plurality of instruction set portions in the knowledgebase. In other embodiments, comparison may be implemented by treating each of one or more components (i.e. words, etc.) of an instruction set portion as a separate string to be matched independently. In further embodiments, comparison may be implemented by matching one or more components of the new instruction set portion with one or more components of the instruction set portions stored in a knowledgebase. In yet further embodiments, comparison may also be implemented by matching all but one of one or more components of the new instruction set portion with one or more components of an instruction set portion stored in a knowledgebase. Comparison may also be implemented by matching all but two of one or more components of the new instruction set portion with one or more components of an instruction set portion stored in a knowledgebase. Comparison may also be implemented by matching one or more components of the new instruction set portion with one or more components of the instruction set portions from the knowledgebase, factoring in the weights for each of the components of instruction set portions from the knowledgebase. As such matching some components of the instruction set portions from the knowledgebase may be more important than other components having smaller weight.
At step 3425, a determination is made that there is a substantial similarity between the new instruction set portion and instruction set portions in the knowledgebase such as the first instruction set portion. In one embodiment, during the comparison of the one or more components of the new instruction set portion and the one or more components of the first instruction set portion a perfect match may be found. In other embodiments, AI DBMS may find a plurality of perfect matches with a plurality of instruction set portions stored in a knowledgebase. If the number of matches exceeds a threshold for maximum number of substantial similarity results, strictness level for determining a substantial similarity match may be modified to include an additional one or more components of the new instruction set portion in order to narrow down or reduce the number of the perfect matching results. In some embodiments, if no perfect match is found, or if a number of matches is lower than a threshold for minimum amount of substantially matching results, then strictness level may be reduced to allow for finding a match that is imperfect. In some embodiments, a strictness level may be reduced to allow for a match for more important components of the one or more components of the new instruction set portion to be matched with the components of instruction set portions in the knowledgebase. The more important components (i.e. words, etc.) of the one or more components of the new instruction set portion may be components including command words or keywords. For example, a substantial match may be found when SQL keywords from the one or more components of the new instruction set portion match SQL keywords, and/or the order of such keywords, from one or more components of instruction set portions in the knowledgebase, even if one or more variable names, data names or database names are not matched. Substantial match may also be found when a strictness level is reduced to allow a match to have all but one of the one or more components of the new instruction set portion matching an instruction set portion in the knowledgebase. Similarly, a substantial match may be found when a strictness level is reduced to allow a match to have all but two of the one or more components of the new instruction set portion matching an instruction set portion in the knowledgebase. Likewise, a substantial match may be found when a strictness level is reduced to allow a match to have all but three of the one or more components of the new instruction set portion matching an instruction set portion in the knowledgebase. The one, two, or three non-matched components of the new instruction set portion may be components having smaller or smallest weight. For example, the non-matched components of the new instruction set portion may be variable names, database names or other components of the instruction set portion that may be less important than the commands or keywords, for example. Determination of substantial similarity between the one or more components of the new instruction set portion and the first instruction set portion may include any one of, or any combination of, substantial similarity determination techniques or embodiments discussed herein.
At step 3430, the second instruction set portion is displayed on the mobile device as an option to be selected by a user. The second instruction set portion may be displayed in response to determining that the first instruction set portion may be the most substantial match with the new instruction set portion and that the second instruction set portion immediately follows the first instruction set portion. In some embodiments, AI DBMS may select the second instruction set portion for display on the mobile device responsive to the determination at step 3425. In further embodiments, the second instruction set portion may be displayed along with one or more instruction set portions that may immediately follow the second instruction set portion.
At step 3435, the second instruction set portion is modified in response to edits by the user, should the user decide to modify the second instruction set portion. In one example, the second instruction set portion may be modified to indicate the same column, as was indicated in previously used instruction set portions of the new instruction set. In another example, the second instruction set portion may be modified to indicate an appropriate value to be used in the new instruction set.
At step 3440, a portion of the new instruction set is assembled using the new instruction set portion and a different portion of the new instruction set is assembled using the second instruction set portion or the modified second instruction set portion. In some embodiments, assembling may include storing the new instruction set portion and the second instruction set portion or the modified second instruction set portion in a data structure such as an array, linked list, table, etc. comprising all known instruction set portions of the new instruction set. In other embodiments, assembling may include appending the new instruction set portion and the second instruction set portion or the modified second instruction set portion to a string of characters containing the known instruction set portions of the new instruction set. Assembling may include any action or operation by or for an Associative Control Unit 1900.
At step 3445, steps 3415-3440 are repeated for all subsequent portions of the new instruction set until the new instruction set's completion. Once all the needed instruction set portions are known the instruction set may be complete. In embodiments where the intermediary data structure (i.e. array, linked list, table, etc.) is used for storing known instruction set portions as previously described, the new instruction set may be assembled from the instruction set portions in the data structure before being sent to DBMS for execution. Assembling may include any action or operation by or for a Command Assembler 560. In embodiments where appending is performed of known instruction set portions as previously described, the new instruction set may be directly sent to DBMS for execution.
At step 3450, the operation defined by the new instruction set is performed on the database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a table of a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting of a row, column, or cell within a table of a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a report/view, relation, user account, and/or other objects in a DBMS. The operation performed may include any DBMS operation described herein.
Referring to
In further detail, at step 7405 an interface for the AI DBMS receives a first instruction set for performing an operation on a database. The first instruction set may include commands and instructions, along with data names and variable names identifying the specific operation to be taken on a specific database. The first instruction set may be received by the interface for a DBMS. The first instruction set may be received by any component of the AI DBMS.
At step 7410, the first instruction set is processed into instruction set portions. In some embodiment, the first instruction set is disassembled into a plurality of portions. Each of the portions may be further processed. Processing may also include identifying the type of the first instruction set, in terms of the commands used. Specifically determinations may be made to identify if the first instruction set is for modifying data, selecting data, accessing data, creating a database, creating a row or a column within a database, making a new entry or similar nature or type of the first instruction set. Processing may further include creating a timestamp of the time when the first instruction set has been received. Processing may further include identifying a user which entered the first instruction set or identifying a group to which the user belongs. Processing may include assigning a weight to each of the portions of the first instruction set. Processing may include any action or operation by or for a Command Disassembler 500.
At step 7415, instruction set, along with its disassembled instruction set portions, may be stored in a knowledgebase that comprises a plurality of instruction sets, each of which includes a plurality of portions of its own. In some embodiments, instruction sets may be stored in a data structure for storing instruction sets, such as a table of the knowledgebase. Instruction set portions may be stored in knowledge cells, where each group of instruction sets forms a knowledge cell. Knowledgebase or additional knowledgebases may also be populated to include the user specific and/or group specific informations gathered with respect to the first instruction set. Also stored in knowledgebase may be the weight assigned to each of the portions of the first instruction set.
At step 7420, one or more portions of a new instruction set entered by a user on the mobile device is received. The one or more portions of the new instruction set may be for performing some operation on some database managed by the AI DBMS. In some embodiments, the user enters in sequence one, two or three portions of a new instruction set which the user intends to enter into the mobile device to perform an operation defined by that new instruction set on a particular data in a database. As the user enters the one or more portions of the new instruction set, and before the user completes entering the entire new instruction set, the one or more portions of the new instruction set may be received by a component of the AI DBMS, such as the Associative SDCL Artificial Intelligence 2800 or DBMS Artificial Intelligence 130. One or more portions of the new instruction set may be stored into operations lists.
At step 7425, the received one or more portions of the new instruction set are compared with the portions of the instruction sets in the knowledgebase. The one or more portions of the new instruction set may be compared with any of the portions of the instruction sets in the knowledgebase. In one embodiment, the one or more portions of the new instruction set are compared as a single string of characters with a plurality of portions of instruction sets in the knowledgebase. In other embodiments, comparison may be implemented by treating each instruction set portion as a separate string to be matched independently. In further embodiments, comparison is implemented by matching all of one or more portions of the new instruction set with one or more portions of an instruction set stored in a knowledgebase. Comparison may be implemented by matching all but one of the one or more portions of the new instruction set with one or more portions of an instruction set stored in a knowledgebase. Comparison may also be implemented by matching all but two of one or more portions of the new instruction set with one or more portions of an instruction set stored in a knowledgebase. Comparison may also be implemented by comparing the one or more portions of the new instruction set with portions of the instruction sets from the knowledgebase, factoring in the weights for each of the instruction set portions from the knowledgebase. As such matching some portions of the instruction sets from the knowledgebase may be more important than other portions having smaller weight.
At step 7430, AI DBMS determines that there is a substantial similarity between the one or more portions of the new instruction set and the first instruction set stored in the knowledgebase. In one embodiment, during the comparison of the one or more portions of the new instruction set and the portions of the first instruction set a perfect match may be found. In other embodiments, AI DBMS may find a plurality of perfect matches with a plurality of stored instruction sets. If the number of matches exceeds a threshold for maximum number of substantial similarity results, strictness level for determining a substantial match may be modified to include an additional one or more portions of the new instruction set in order to narrow down or reduce the number of the perfect matching results.
Still at 7430, in some embodiments, if no perfect match is found, or if a number of matches is lower than a threshold for minimum amount of substantially matching results, then strictness level may be reduced to allow for finding a match that is imperfect. In some embodiments, a strictness level may be reduced to allow for a match for more important portions of the one or more portions of the new instruction set to be matched with the instruction sets in the knowledgebase. The more important portions of the one or more portions of the new instruction set may be portions including command words or keywords. For example, a substantial match may be found when SQL keywords from the one or more portions of the new instruction set match SQL keywords, and the order of such keywords, in one or more stored instruction sets in the knowledgebase, even if one or more variable names, data names or database names are not matched. Substantial match may also be found when a strictness level is reduced to allow a match to have all but one portion of the one or more portions of the new instruction set matching an instruction set in the knowledgebase. Similarly, a substantial match may be found when a strictness level is reduced to allow a match to have all but two portions of the one or more portions of the new instruction set matching an instruction set in the knowledgebase. Likewise, a substantial match may be found when a strictness level is reduced to allow a match to have all but three portions of the one or more portions of the new instruction set matching an instruction set in the knowledgebase. The one, two, or three non-matched portions of the instruction set may be portions having smaller or smallest weight. For example, the non-matched portions of the instruction set may be variable names, database names or other portions of the instruction set that may be less important than the command keywords, for example. Determination of substantial similarity between the one or more portions of the new instruction set and the first instruction set may include any one of, or any combination of, substantial similarity determination techniques or embodiments discussed herein.
At step 7435, mobile device may display the first instruction set as an option to be selected by a user. The first instruction set may be displayed in response to determining that the first instruction set is the most substantial match with the one or more portions of the new instruction set. In some embodiments, AI DBMS may select the first instruction set for display on the mobile device responsive to the determination at step 7430. In further embodiments, the first instruction set may be displayed along with one or more instruction sets that are also identified as substantially similar or substantially matching the one or more portions of the new instruction set at step 7430.
At step 7440, the first instruction set may be modified in response to edits by the user. If a user decides that the first instruction set is very similar to the instruction set the user wanted to enter, aside for a few changes for example, the user may modify the first instruction set. In some embodiments, interface for the AI DBMS may provide the means for the user to modify the first instruction set upon the selection of the first instruction set on the display of the mobile device by the user.
At step 7445, AI DBMS performs the operation defined by the first instruction set (or the modified first instruction set if the first instruction set has been modified at step 7440) on the DBMS. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a table of a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting of a row, column, or cell within a table of a database. The operation performed may include one of, or a combination of: accessing, modifying, creating or deleting a report/view, relation, user account, and/or other objects in a DBMS. The operation performed may include any DBMS operation described herein.
Referring to
AI DBMS may be used by the User 10 on a Media Player 3500, and the Media Player 3500 may further include Core Program 110, DBMS Artificial Intelligence 130, Input Interface 140, Output Interface 160, Display 170, Memory 180, Physical Storage Medium 181, Associative DBMS Command Constructor 190, Associative SDCL Constructor 2400, Speech Recognizer 2700, Microphone 2710, Underlying Media DBMS 3510, Sound Interface 3520, Speaker 3530, and Media Player Controls 3540. Other additional elements may be included as needed, or some of the disclosed ones may be excluded, or a combination thereof may be utilized in alternate embodiments.
Media Player 3500 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for playing media. Examples of Media Player 3500 include a music player such as an iPod, a video player such as a DVD player, a picture player, a television device, a media capable computer, a media capable cellular phone such as a Smartphone, a media capable tablet, and other media players.
In some embodiments, Underlying Media DBMS 3510 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for storing, managing and/or manipulating various types of media or references thereto. The media may include music, video, pictures, and other media generally included in digital files. In one example, the media files or references thereto may be stored as Rows 330 in a single Table 310 within a single Database 300. In another example, the media files or references thereto may be stored as Rows 330 in multiple Tables 310 within multiple Databases 300 based on the type of content the media files contain (i.e. tables for specific authors and databases for specific genres of music or video, etc.). Columns 320 may be provided to include additional information such as author, authorship date, copyright information, and other additional information pertinent to the media file. Underlying Media DBMS 3510 may reside on the User's 10 Media Player 3500 or it may reside on a remote Computing Device 1310 accessible over a Network 1300, and if on a remote Computing Device 1310, the Underlying Media DBMS 3510 may be available as a network service (i.e. music or video streaming service, etc.) as previously described. User 10 may access, manage and/or manipulate the Underlying Media DBMS 3510 by using a control means and/or an associated interface of the Media Player 3500, and/or by using the previously described associative methods of constructing Operations 610 or Instruction Sets 600 via key, phrase, and/or voice inputs, or a combination thereof.
In one example, each time User 10 wishes to play a media file on the Media Player 3500, User 10 may issue an operating instruction (i.e. Instruction Set 600 or Operation 610, etc.) to the Underlying Media DBMS 3510 to retrieve the media file or a reference thereto to be played. Responsive to the User's 10 operating instruction to retrieve the media file or a reference thereto, Underlying Media DBMS 3510 may perform a SELECT type of Instruction Set 600 or Operation 610 (i.e. SELECT type of SQL statement, or any other SELECT type of DBMS command, etc.). In another example, each time User 10 wishes to delete a media file or a reference thereto on the Media Player 3500, User 10 may issue an operating instruction (i.e. Instruction Set 600 or Operation 610, etc.) to the Underlying Media DBMS 3510 to delete the media file or a reference thereto. Responsive to the User's 10 operating instruction to delete the media file or a reference thereto, Underlying Media DBMS 3510 may perform a DELETE type of Instruction Set 600 or Operation 610 (i.e. DELETE type of SQL statement, or any other DELETE type of DBMS command, etc.). Furthermore, AI DBMS may learn the User's 10 operating instructions such as the media file or a reference thereto retrieving or deleting instructions, store them for future use, and anticipate them in the future as previously described.
In some embodiments, Media Player 3500 may include the associative method of constructing Operations 610 or Instruction Sets 600 via key input as previously described. In one example, Keys 2110 of the Media Player Controls 3540 or other input device may be associated with Instruction Set Portions 620 of an Instruction Set 600 or Operation 610 for retrieving a media file to be played from the Underlying Media DBMS 3510. As such, User 10 may initially be offered a Selection 2300 on the Media Player's 3500 Display 170 to input a Key 2110 indicating that the User 10 wishes to play a media file. The next Selection 2300 the User 10 may be offered may be to input a Key 2110 indicating in which play list (i.e. table in a database) is the media file the User 10 wishes to play. The next Selection 2300 the User 10 may be offered may be to input a Key 2110 indicating which specific media file (i.e. row in a table) the User 10 wishes to play. AI DBMS may assemble Instruction Set 600 or Operation 610 from the inputted Keys 2110 and their associated Instruction Set Portions 620 to facilitate the User's operating instructions on the Underlying Media DBMS 3510 as previously described.
In other embodiments, Media Player 3500 may include the SDCL for associative construction of Operations 610 or Instruction Sets 600 via phrase or voice input as previously described. In one example, Phrases 2610 (i.e. user preferred phrases, etc.) may be associated with Instruction Set Portions 620 of an Instruction Set 600 or Operation 610 for retrieving a media file to be played from the Underlying Media DBMS 3510. As such, User 10 may initially be offered a Selection 2300 on the Media Player's 3500 Display 170 to input a Phrase 2610 (i.e. “PLAY”, etc.) indicating that the User 10 wishes to play a media file. The next Selection 2300 the User 10 may be offered may be to input a Phrase 2610 (i.e. “MY FAVORITE LIST”, etc.) indicating in which play list (i.e. table in a database) is the media file the User 10 wishes to play. The next Selection 2300 the User 10 may be offered may be to input a Phrase 2610 (i.e. “LOVE SONG”, etc.) indicating which specific media file (i.e. row in a table) the User 10 wishes to play. AI DBMS may assemble Instruction Set 600 or Operation 610 from the inputted Phrases 2610 and their associated Instruction Set Portions 620 to facilitate the User's operating instructions on the Underlying Media DBMS 3510 as previously described.
In one exemplary embodiment, Media Player 3500 may be a music player such as an iPod. Underlying Media DBMS 3510 may include music files or references to music files with either or both the Underlying Media DBMS 3510 and the music files stored in the Media Player's 3500 Memory 180 and/or Physical Storage Medium 181. As the User 10 selects music files to play, DBMS Artificial Intelligence 130 may learn the User's 10 music playing selections (i.e. Instruction Sets 600 or Operations 610); store this “knowledge” (i.e. Knowledge Cells, etc.) in the Knowledgebase 530; and anticipate the User's 10 future music playing intentions (i.e. future/anticipatory Instruction Sets 600 or Operations 610) as previously described. User 10 may input his/her music playing instructions (1) by using the music player's native control means such as iPod's control wheel and the associated control program (i.e. interface, etc.) that interprets the control wheel's input events and generates requests to access, manage, and/or manipulate the Underlying Media DBMS 3510, and/or (2) by using the previously described associative methods of constructing Instruction Sets 600 or Operations 610 via key, phrase, and voice inputs, or a combination thereof.
In another exemplary embodiment, Media Player 3500 may be a network connected television device with network browsing capabilities. Underlying Media DBMS 3510 may include video files or references to video files with either or both the Underlying Media DBMS 3510 and the video files stored or on a remote Computing Device 1310 accessible over a Network 1300 as a network service. As the User 10 selects video files to play, DBMS Artificial Intelligence 130 may learn the User's 10 video playing selections (i.e. Instruction Sets 600 or Operations 610); store this “knowledge” (i.e. Knowledge Cells, etc.) in the Knowledgebase 530; and anticipate the User's 10 future video playing intentions (i.e. future/anticipatory Instruction Sets 600 or Operations 610) as previously described. Additionally, as previously described, a global Knowledgebase 530 including video playing “knowledge” (i.e. Knowledge Cells, etc.) of other users may be available to User 10 to guide his/her future video playing intentions. User 10 may input his/her video playing instructions (1) by using the television device's native control means such as a remote control and the associated control program (i.e. interface, etc.) that interprets the remote control's input events and generates requests to access, manage, and/or manipulate the Underlying Media DBMS 3510, and/or (2) by using the previously described associative methods of constructing Instruction Sets 600 or Operations 610 via key, phrase, and voice inputs, or a combination thereof.
In yet another exemplary embodiment, Media Player 3500 may be a standard television device without network browsing capabilities. Underlying Media DBMS 3510 may include cable, satellite, on-the-air or other video channels or references thereto. Underlying Media DBMS 3510 may also include information on the User's 10 preferred settings such as volume, color, contrast, brightness, and other settings for various types of channels and video content. As the User 10 selects video channels to watch, DBMS Artificial Intelligence 130 may learn the User's 10 channel watching selections (i.e. Instruction Sets 600 or Operations 610), the timing of the channel watching selections, and the User's 10 preferred settings for the various types of channels and video content; store this “knowledge” (i.e. Knowledge Cells, etc.) in the Knowledgebase 530; and anticipate the User's 10 future channel watching intentions (i.e. future/anticipatory Instruction Sets 600 or Operations 610) as previously described. In one example, User 10 may watch specific channels at specific times (as many television watchers do when they watch daily or weekly scheduled shows) and AI DBMS may learn the channels and the times (i.e. using the time stamp, etc.) and automatically switch to these channels at their specific times, and if the User 10 is not at home, AI DBMS may trigger a recording process for later recorded channel watching. In another example, while watching his/her favorite show, User 10 may switch to other channels during commercials in specific time intervals, and AI DBMS may learn the channels and the time intervals (i.e. using time stamp, etc.) and automatically switch the channels to avoid commercials. In yet another example, User 10 may change volume, color, contrast, brightness, and other settings based on the User's 10 preferences for various types of channels and content, and AI DBMS may learn the User's 10 preferred settings (i.e. using Extra Infos 630, etc.) for the specific channels and content and adjust the settings automatically. User 10 may input his/her video playing instructions (1) by using the television device's native control means such as a remote control and the associated control program (i.e. interface, etc.) that interprets the remote control's input events and generates requests to access, manage, and/or manipulate the Underlying Media DBMS 3510, and/or (2) by using the previously described associative methods of constructing Instruction Sets 600 or Operations 610 via key, phrase, and voice inputs, or a combination thereof.
Sound Interface 3520 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for processing output from the Core Program 110 or other elements of the current disclosure for listening by the User 10. Sound Interface 3520 falls under the general description of the previously described Output Interface 160, and it is described separately in this embodiment to offer additional detail on its functioning. Sound Interface 3520 may be or include a sound driver, a Java sound API, a built-in sound interface, or any other sound interface.
Speaker 3530 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for providing sound to the User 10. Speaker 3530 may be a built-in or an external speaker, headphone, or any other sound producing device.
Media Player Controls 3540 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for inputting operating instructions or data. Media Player Controls 3540 may include a means of inputting operating instructions or data by pressing keys or buttons, touching keys or buttons, clicking keys or buttons, sliding physical components, or manipulating other physical or other elements. Examples of Media Player Controls 3540 include a control wheel (i.e. iPod's control wheel, etc.), a keypad, a touch screen, a keyboard, or any other input or control device.
Referring to
AI DBMS may be used by the User 10 on a GPS Receiver 3600, and the GPS Receiver 3600 may further include Core Program 110, DBMS Artificial Intelligence 130, Input Interface 140, Output Interface 160, Display 170, Memory 180, Physical Storage Medium 181, Associative DBMS Command Constructor 190, Associative SDCL Constructor 2400, Speech Recognizer 2700, Microphone 2710, Sound Interface 3520, Speaker 3530, Underlying Locations DBMS 3610, and Touch Screen 3620. Other additional elements may be included as needed, or some of the disclosed ones may be excluded, or a combination thereof may be utilized in alternate embodiments.
GPS Receiver 3600 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for GPS functionalities. Examples of the GPS Receiver 3600 include a hand-held GPS receiver, a built-in GPS receiver (i.e. built-in a car or boat, etc.), GPS capable cellular telephone (i.e. Smartphone, etc.), and other GPS receivers.
In some embodiments, Underlying Locations DBMS 3610 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for storing, managing and/or manipulating location references. Location references may include latitude/longitude/altitude coordinates, street addresses, distances from a fixed point, and other location references. In one example, location references may be stored as Rows 330 in a single Table 310 within a single Database 300. In another example, location references may be stored as Rows 330 in multiple Tables 310 within multiple Databases 300 based on the geographic groupings (i.e. tables for specific cities and databases for specific countries, etc.). Columns 320 may be provided to include additional information such as population, historic facts, general climate facts, and other additional information pertinent to a specific location reference. Underlying Locations DBMS 3610 may reside on the User's 10 GPS Receiver 3600 or it may reside on a remote Computing Device 1310 accessible over a Network 1300, and if on a remote Computing Device 1310, the Underlying Locations DBMS 3610 may be available as a network service (i.e. service for updating location references, etc.) as previously described. User 10 may access, manage and/or manipulate the Underlying Locations DBMS 3610 by using a control means and/or an associated interface of the GPS Receiver 3600, and/or by using the previously described associative methods of constructing Operations 610 or Instruction Sets 600 via key, phrase, and/or voice inputs, or a combination thereof.
In one example, each time User 10 wishes to visit a location stored on the GPS Receiver 3600, User 10 may issue an operating instruction (i.e. Instruction Set 600 or Operation 610, etc.) to the Underlying Locations DBMS 3610 to retrieve the location reference (i.e. latitude/longitude/altitude coordinates, address, etc.) to be visited. Responsive to the User's 10 operating instruction to retrieve the location reference, Underlying Locations DBMS 3610 may perform a SELECT type of Instruction Set 600 or Operation 610 (i.e. SELECT type of SQL statement, or any other SELECT type of DBMS command, etc.). In another example, each time User 10 wishes to delete a location reference on the GPS Receiver 3600, User 10 may issue an operating instruction (i.e. Instruction Set 600 or Operation 610, etc.) to the Underlying Locations DBMS 3610 to delete the location reference. Responsive to the User's 10 operating instruction to delete the location reference, Underlying Locations DBMS 3610 may perform a DELETE type of Instruction Set 600 or Operation 610 (i.e. DELETE type of SQL statement, or any other DELETE type of DBMS command, etc.). Furthermore, AI DBMS may learn the User's 10 operating instructions such as the location reference retrieving or deleting instructions, store them for future use, and anticipate them in the future as previously described.
In some embodiments, GPS Receiver 3600 may include the associative method of constructing Operations 610 or Instruction Sets 600 via key input as previously described. For example, Keys 2110 of the Touch Screen 3620 or other input device may be associated with Instruction Set Portions 620 of an Instruction Set 600 or Operation 610 for retrieving a location reference of a location to be visited from the Underlying Locations DBMS 3610. As such, User 10 may initially be offered a Selection 2300 on the GPS Receiver's 3600 Display 170 to input a Key 2110 indicating that the User 10 wishes to visit a location. The next Selection 2300 the User 10 may be offered may be to input a Key 2110 indicating in which city (i.e. table in a database) is the location the User 10 wishes to visit. The next Selection 2300 the User 10 may be offered may be to input a Key 2110 indicating which specific location (i.e. row in a table) the User 10 wishes to visit. AI DBMS may assemble Instruction Set 600 or Operation 610 from the inputted Keys 2110 and their associated Instruction Set Portions 620 to facilitate the User's operating instructions on the Underlying Locations DBMS 3610 as previously described.
In other embodiments, GPS Receiver 3600 may include the SDCL for associative construction of Operations 610 or Instruction Sets 600 via phrase or voice input as previously described. For example, Phrases 2610 (i.e. user preferred phrases, etc.) may be associated with Instruction Set Portions 620 of an Instruction Set 600 or Operation 610 for retrieving a location reference of a location to be visited from the Underlying Locations DBMS 3610. As such, User 10 may initially be offered a Selection 2300 on the GPS Receiver's 3600 Display 170 to input a Phrase 2610 (i.e. “GO TO”, etc.) indicating that the User 10 wishes to visit a location. The next Selection 2300 the User 10 may be offered may be to input a Phrase 2610 (i.e. “LOS ANGELES”, etc.) indicating in which city (i.e. table in a database) is the location the User 10 wishes to visit. The next Selection 2300 the User 10 may be offered may be to input a Phrase 2610 (i.e. “SCIENCE MUSEUM”, etc.) indicating which specific location (i.e. row in a table) the User 10 wishes to visit. AI DBMS may assemble Instruction Set 600 or Operation 610 from the inputted Phrases 2610 and their associated Instruction Set Portions 620 to facilitate the User's operating instructions on the Underlying Locations DBMS 3610 as previously described.
In one exemplary embodiment, GPS Receiver 3600 may be a network connected GPS receiver. Underlying Locations DBMS 3610 may include location references stored in the GPS Receiver's 3600 Memory 180 and/or Physical Storage Medium 181. As the User 10 selects location references to visit, DBMS Artificial Intelligence 130 may learn the User's 10 selections (i.e. Instruction Sets 600 or Operations 610) of location references; store this “knowledge” (i.e. Knowledge Cells, etc.) in the Knowledgebase 530; and anticipate the User's 10 future location visiting intentions (i.e. future/anticipatory Instruction Sets 600 or Operations 610) as previously described. Additionally, as previously described, a global Knowledgebase 530 including location visiting “knowledge” (i.e. Knowledge Cells, etc.) of other users may be available to User 10 to guide his/her future location visiting intentions. In one example, User 10 may come to a city for the first time and look for places of interest to visit. After User 10 discovers and visits a great restaurant and/or an interesting museum, AI DBMS may anticipate the User's 10 future location references based on the sequence of location visits of other users in the global Knowledgebase 530 who visited the same restaurant and/or the museum. User 10 may input his/her location visiting instructions (1) by using GPS Receiver's 3600 native control means such as the Touch Screen 3620 and the associated control program (i.e. interface, etc.) that interprets the touch screen's input events and generates requests to access, manage, and/or manipulate the Underlying Locations DBMS 3610, and/or (2) by using the previously described associative methods of constructing Instruction Sets 600 or Operations 610 via key, phrase, and voice inputs, or a combination thereof.
Touch Screen 3620 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for inputting operating instructions or data. Touch Screen 3620 may include a means of inputting operating instructions or data by touching areas of the Touch Screen 3620 representing keys or buttons, sliding Touch Screen's 3620 slider components, or manipulating other Touch Screen 3620 elements.
Referring to
AI DBMS may be used by the User 10 on a Personal Computer 3700, and the Personal Computer 3700 may further include Core Program 110, DBMS Artificial Intelligence 130, Input Interface 140, Keyboard 150, Output Interface 160, Display 170, Memory 180, Physical Storage Medium 181, Associative DBMS Command Constructor 190, Associative SDCL Constructor 2400, Speech Recognizer 2700, Microphone 2710, Sound Interface 3520, Speaker 3530, and Underlying Business Operation DBMS 3710. Other additional elements may be included as needed, or some of the disclosed ones may be excluded, or a combination thereof may be utilized in alternate embodiments.
Personal Computer 3700 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for computing functionalities. Examples of the Personal Computer 3700 include a desktop computer, a mobile computer such as a laptop or tablet computer, computing capable cellular telephone (i.e. Smartphone, etc.), and other personal computers.
In some embodiments, Underlying Business Operation DBMS 3710 may comprise any hardware, software or a combination of hardware and software, and/or it may include functions and algorithms for storing, managing and/or manipulating various business operation data. Business operation data may include sales, inventory, payroll, employee benefits, financial, and other business operation data. In a small business example, business operation data may be stored as Rows 330 in a single or multiple Tables 310 within a single Database 300. In an enterprise organization example, business operation data may be stored as Rows 330 in multiple Tables 310 within multiple Databases 300 based on the organizational departments (i.e. tables for specific functions within a department and databases for specific departments, etc.). Underlying Business Operation DBMS 3710 may reside on the User's 10 Personal Computer 3700 or it may reside on a remote Computing Device 1310 accessible over a Network 1300, and if on a remote Computing Device 1310, the Underlying Business Operation DBMS 3710 may be available as a network service (i.e. database service for multiple users to connect and use, etc.) as previously described. User 10 may access, manage and/or manipulate the Underlying Business Operation DBMS 3710 by using a control means and/or an associated interface of the Personal Computer 3700, and/or by using the previously described associative methods of constructing Operations 610 or Instruction Sets 600 via key, phrase, and/or voice inputs, or a combination thereof.
In one example, each time User 10 wishes to view a business operation data on the Personal Computer 3700, User 10 may issue an operating instruction (i.e. Instruction Set 600 or Operation 610, etc.) to the Underlying Business Operation DBMS 3710 to retrieve the business operation data to be viewed. Responsive to the User's 10 operating instruction to retrieve the business operation data, Underlying Business Operation DBMS 3710 may perform a SELECT type of Instruction Set 600 or Operation 610 (i.e. SELECT type of SQL statement, or any other SELECT type of DBMS command, etc.). In another example, each time User 10 wishes to delete a business operation data on the Personal Computer 3700, User 10 may issue an operating instruction (i.e. Instruction Set 600 or Operation 610, etc.) to the Underlying Business Operation DBMS 3710 to delete the business operation data. Responsive to the User's 10 operating instruction to delete the business operation data, Underlying Business Operation DBMS 3710 may perform a DELETE type of Instruction Set 600 or Operation 610 (i.e. DELETE type of SQL statement, or any other DELETE type of DBMS command, etc.). Furthermore, AI DBMS may learn the User's 10 operating instructions such as the business operation data retrieving or deleting instructions, store them for future use, and anticipate them in the future as previously described.
In some embodiments, Personal Computer 3700 may include the associative method of constructing Operations 610 or Instruction Sets 600 via key input as previously described. In one example, Keys 2110 of the Keyboard 150 or other input device may be associated with Instruction Set Portions 620 of an Instruction Set 600 or Operation 610 for retrieving a business operation data to be viewed from the Underlying Business Operation DBMS 3710. As such, User 10 may initially be offered a Selection 2300 on the Personal Computer's 3700 Display 170 to input a Key 2110 indicating that the User 10 wishes to view a business operation data. The next Selection 2300 the User 10 may be offered may be to input a Key 2110 indicating in which table (i.e. table in a database) is the business operation data the User 10 wishes to view. The next Selection 2300 the User 10 may be offered may be to input a Key 2110 indicating which specific business operation data (i.e. row in a table) the User 10 wishes to view. AI DBMS may assemble Instruction Set 600 or Operation 610 from the inputted Keys 2110 and their associated Instruction Set Portions 620 to facilitate the User's operating instructions on the Underlying Business Operation DBMS 3710 as previously described.
In other embodiments, Personal Computer 3700 may include the SDCL for associative construction of Operations 610 or Instruction Sets 600 via phrase or voice input as previously described. In one example, Phrases 2610 (i.e. user preferred phrases, etc.) may be associated with Instruction Set Portions 620 of an Instruction Set 600 or Operation 610 for retrieving a business operation data to be viewed from the Underlying Business Operation DBMS 3710. As such, User 10 may initially be offered a Selection 2300 on the Personal Computer's 3700 Display 170 to input a Phrase 2610 (i.e. “GET DATA”, etc.) indicating that the User 10 wishes to view a business operation data. The next Selection 2300 the User 10 may be offered may be to input a Phrase 2610 (i.e. “SALES”, etc.) indicating in which table (i.e. table in a database) is the business operation data the User 10 wishes to view. The next Selection 2300 the User 10 may be offered may be to input a Phrase 2610 (i.e. “2013 FORD FOCUS”, etc.) indicating which specific business operation data (i.e. row in a table) the User 10 wishes to view. AI DBMS may assemble Instruction Set 600 or Operation 610 from the inputted Phrases 2610 and their associated Instruction Set Portions 620 to facilitate the User's operating instructions on the Underlying Business Operation DBMS 3710 as previously described.
In one exemplary embodiment, Personal Computer 3700 may be a network connected desktop computer. Underlying Business Operation DBMS 3710 may reside on a remote Computing Device 1310 accessible over a Network 1300 (i.e. enterprise network, or virtual private network over the Internet, etc.). As the User 10 performs select, insert, update, delete and other operations on the business operation data, DBMS Artificial Intelligence 130 may learn User's 10 operations (i.e. Instruction Sets 600 or Operations 610); store this “knowledge” (i.e. Knowledge Cells, etc.) in the Knowledgebase 530; and anticipate the User's 10 future operating intentions (i.e. future/anticipatory Instruction Sets 600 or Operations 610) as previously described. In one example, User 10 may be responsible for maintaining sales and inventory Tables 310 within one or multiple Databases 300. When a sale is made, User 10 may need to perform several insert, update, and/or other operations such as inserting a Row 330 into the sales Table 310 and updating a Row 330 in the inventory Table 310 for each product sold. Each product may have its separate sales and inventory Tables 310 and User 10 may need to perform update operations on multiple sales and inventory Tables 310. After performing insert and update operations for one or more initial sale transactions, AI DBMS may learn the User's 10 sequence of operations for each sale transaction and perform the corresponding operations automatically. In another example, User 10 may be responsible for financial reporting. This type of reporting is often a daily, weekly, monthly and/or yearly scheduled process of creating same or similar reports with updated times, dates or other filtering information. After creating one or more scheduled Reports/Views 350, AI DBMS may learn the timing (i.e. using time stamp, etc.) of the User's 10 Reports/Views 350 creation and create future Reports/Views 350 automatically. User 10 may input his/her business operation DBMS instructions (1) by using the previously described Keyboard 150 and Input Interface 140 to access, manage and/or manipulate the Underlying Business Operation DBMS 3710, and/or (2) by using the previously described associative methods of constructing Instruction Sets 600 or Operations 610 via key, phrase, and voice inputs, or a combination thereof.
In another exemplary embodiment, Personal Computer 3700 may be a network connected mobile computer. Underlying Business Operation DBMS 3710 may be stored in the Personal Computer's 3700 Memory 180 or Physical Storage Medium 181. Also, User 10 may be a non-technical small business user attempting to create a Database 300 with several business operation Tables 310 (i.e. sales, inventory, etc.). As previously described, a global Knowledgebase 530 including Database 300 and Table 310 creation “knowledge” (i.e. Knowledge Cells, etc.) of other users may be available to User 10 to guide his/her Database 300 and Table 310 creation intentions. In one example, User 10 may be a professional painter and wish to create a database for a business that sells paintings. User 10 may wish to organize his/her paintings for sale into several Tables 310 based on the topic of the paintings (i.e. a Table 310 for paintings of nature, a Table 310 for paintings of animals, etc.). After User 10 creates an initial empty Database 300 titled “paintings for sale,” AI DBMS may anticipate the user's table creation intentions (i.e. future/anticipatory Instruction Sets 600 or Operations 610) based on the sequence of table creations of other users in the global Knowledgebase 530 who created a “paintings for sale” (or its semantic variations) Database 300 in a similar small business context. User 10 may input his/her business operation DBMS instructions (1) by using the previously described Keyboard 150 and Input Interface 140 to access, manage and/or manipulate the Underlying Business Operation DBMS 3710, and/or (2) by using the previously described associative methods of constructing Instruction Sets 600 or Operations 610 via key, phrase, and voice inputs, or a combination thereof.
A number of embodiments have been described herein. While this specification contains many specific implementation details, these should not be construed as limitations on the scope of any inventions or of what may be claimed, but rather as descriptions of features specific to particular embodiments. It will be understood that various modifications may be made without departing from the spirit and scope of the invention. The logic flows depicted in the figures do not require the particular order shown, or sequential order, to achieve desirable results. In addition, other or additional steps may be provided, or some of the steps may be eliminated, from the described flows, and/or other components may be added to, or removed from, the described methods, systems and techniques. Further, the various aspects and disclosed methods, systems and techniques can be combined in whole or in part with each other to produce additional implementations. Moreover, the separation of various components in the embodiments described herein should not be understood as requiring such separation in all embodiments, and it should be understood that the described components may generally be integrated together in a single software product or packaged into multiple software products. Accordingly, other embodiments are within the scope of the following claims.
This application is a continuation of, and claims priority under 35 U.S.C. § 120 from, nonprovisional U.S. patent application Ser. No. 17/851,558 entitled “SYSTEMS AND METHODS OF USING AN ARTIFICIALLY INTELLIGENT DATABASE MANAGEMENT SYSTEM AND INTERFACES FOR MOBILE, EMBEDDED, AND OTHER COMPUTING DEVICES”, filed on Jun. 28, 2022, which is a continuation of, and claims priority under 35 U.S.C. § 120 from, nonprovisional U.S. patent application Ser. No. 16/686,191 entitled “SYSTEMS AND METHODS OF USING AN ARTIFICIALLY INTELLIGENT DATABASE MANAGEMENT SYSTEM AND INTERFACES FOR MOBILE, EMBEDDED, AND OTHER COMPUTING DEVICES”, filed on Nov. 17, 2019, which is a continuation of, and claims priority under 35 U.S.C. § 120 from, nonprovisional U.S. patent application Ser. No. 15/144,714 entitled “SYSTEMS AND METHODS OF USING AN ARTIFICIALLY INTELLIGENT DATABASE MANAGEMENT SYSTEM AND INTERFACES FOR MOBILE, EMBEDDED, AND OTHER COMPUTING DEVICES”, issued as U.S. Pat. No. 10,534,779, filed on May 2, 2016, which is a continuation of, and claims priority under 35 U.S.C. § 120 from, nonprovisional U.S. patent application Ser. No. 13/962,948 entitled “SYSTEMS AND METHODS OF USING AN ARTIFICIALLY INTELLIGENT DATABASE MANAGEMENT SYSTEM AND INTERFACES FOR MOBILE, EMBEDDED, AND OTHER COMPUTING DEVICES”, issued as U.S. Pat. No. 9,367,806, filed on Aug. 8, 2013. The disclosures of the foregoing documents are incorporated herein by reference.
Number | Name | Date | Kind |
---|---|---|---|
4862390 | Weiner | Aug 1989 | A |
5121470 | Trautman | Jun 1992 | A |
5185857 | Rozmanith et al. | Feb 1993 | A |
5533029 | Gardner | Jul 1996 | A |
5544222 | Robinson et al. | Aug 1996 | A |
5598534 | Haas | Jan 1997 | A |
5812117 | Moon | Sep 1998 | A |
5956637 | Ericsson et al. | Sep 1999 | A |
6087952 | Prabhakaran | Jul 2000 | A |
6122527 | Robinson et al. | Sep 2000 | A |
6128012 | Seidensticker, Jr. et al. | Oct 2000 | A |
6202060 | Tran | Mar 2001 | B1 |
6226665 | Deo et al. | May 2001 | B1 |
6493717 | Junkin | Dec 2002 | B1 |
6549625 | Rautila et al. | Apr 2003 | B1 |
6636873 | Carini et al. | Oct 2003 | B1 |
6654762 | Cheng et al. | Nov 2003 | B2 |
6795706 | Cheng | Sep 2004 | B1 |
6832084 | Deo | Dec 2004 | B1 |
6871068 | O'Neil | Mar 2005 | B1 |
6879989 | Cheng et al. | Apr 2005 | B2 |
6889139 | Prabhakaran | May 2005 | B2 |
6895234 | Laursen et al. | May 2005 | B1 |
6959436 | Peng | Oct 2005 | B2 |
7113946 | Cosic | Sep 2006 | B2 |
7117225 | Cosic | Oct 2006 | B2 |
7328030 | Laursen et al. | Feb 2008 | B2 |
7444143 | Deo | Oct 2008 | B2 |
7450962 | Kim | Nov 2008 | B2 |
7483905 | Gauweiler | Jan 2009 | B2 |
7523112 | Hassan et al. | Apr 2009 | B2 |
7685127 | Gauweiler | Mar 2010 | B2 |
7756525 | Thomas et al. | Jul 2010 | B1 |
7756829 | Bhanote | Jul 2010 | B2 |
7779029 | Neil | Aug 2010 | B2 |
7805397 | Kurian et al. | Sep 2010 | B2 |
7813714 | Laursen et al. | Oct 2010 | B2 |
7831554 | Schreter et al. | Nov 2010 | B2 |
7865924 | Teegan et al. | Jan 2011 | B2 |
7885635 | Laursen et al. | Feb 2011 | B2 |
7945687 | Kim | May 2011 | B2 |
7958270 | Sidon | Jun 2011 | B2 |
8031694 | Gidron et al. | Oct 2011 | B2 |
8041372 | Minns et al. | Oct 2011 | B1 |
8099332 | Lemay et al. | Jan 2012 | B2 |
8103272 | Williamson | Jan 2012 | B2 |
8145663 | Meng | Mar 2012 | B2 |
8190645 | Bashaw et al. | May 2012 | B1 |
8204911 | Neil | Jun 2012 | B2 |
8214409 | O'Farrell et al. | Jul 2012 | B2 |
8266187 | Mercer et al. | Sep 2012 | B2 |
8290898 | Bowlus et al. | Oct 2012 | B2 |
8291408 | Czymontek | Oct 2012 | B1 |
8335805 | Cosic | Dec 2012 | B2 |
8356026 | Jeimendinger | Jan 2013 | B2 |
8359223 | Chi et al. | Jan 2013 | B2 |
8401539 | Beenau et al. | Mar 2013 | B2 |
8412150 | Louch et al. | Apr 2013 | B2 |
8417740 | Cosic | Apr 2013 | B2 |
9158813 | Ntoulas | Oct 2015 | B2 |
9318108 | Gruber et al. | Apr 2016 | B2 |
9330165 | Jiang et al. | May 2016 | B2 |
20010044732 | Maus et al. | Nov 2001 | A1 |
20020078209 | Peng | Jan 2002 | A1 |
20020161735 | Cheng et al. | Oct 2002 | A1 |
20020174189 | Peng | Nov 2002 | A1 |
20030046451 | Prabhakaran | Mar 2003 | A1 |
20030065662 | Cosic | Apr 2003 | A1 |
20040010699 | Shao et al. | Jan 2004 | A1 |
20040049476 | Sai et al. | Mar 2004 | A1 |
20040098394 | Merritt et al. | May 2004 | A1 |
20040128327 | Shi et al. | Jul 2004 | A1 |
20040203845 | Lal | Oct 2004 | A1 |
20040224675 | Puskoor et al. | Nov 2004 | A1 |
20040229595 | Laursen et al. | Nov 2004 | A1 |
20040249785 | Gauweiler | Dec 2004 | A1 |
20040249857 | Gauweiler | Dec 2004 | A1 |
20050044165 | O'Farrell et al. | Feb 2005 | A1 |
20050076069 | Deo et al. | Apr 2005 | A1 |
20050086203 | Gauweiler | Apr 2005 | A1 |
20050149517 | Cosic | Jul 2005 | A1 |
20050149542 | Cosic | Jul 2005 | A1 |
20050243604 | Harken | Nov 2005 | A1 |
20050289105 | Cosic | Dec 2005 | A1 |
20060136454 | Tchouati et al. | Jun 2006 | A1 |
20060212846 | O'Farrell et al. | Sep 2006 | A1 |
20070136264 | Tran | Jan 2007 | A1 |
20070049246 | Schreter et al. | Mar 2007 | A1 |
20070291757 | Dobson et al. | Dec 2007 | A1 |
20080005054 | Kurian et al. | Jan 2008 | A1 |
20080039062 | Laursen et al. | Feb 2008 | A1 |
20080040782 | Laursen et al. | Feb 2008 | A1 |
20080045205 | Park et al. | Feb 2008 | A1 |
20080086481 | Kim | Apr 2008 | A1 |
20080091763 | Devonshire et al. | Apr 2008 | A1 |
20080126403 | Moon | May 2008 | A1 |
20080172274 | Hurowitz et al. | Jul 2008 | A1 |
20080189250 | Cha et al. | Aug 2008 | A1 |
20080281825 | Meng | Nov 2008 | A1 |
20090070149 | Kurian et al. | Mar 2009 | A1 |
20090106360 | Peng et al. | Apr 2009 | A1 |
20090176529 | Warren et al. | Jul 2009 | A1 |
20090201908 | Gidron et al. | Aug 2009 | A1 |
20090217375 | Joosten et al. | Aug 2009 | A1 |
20090254594 | Burchall | Oct 2009 | A1 |
20090275331 | Maitreya et al. | Nov 2009 | A1 |
20100023531 | Brisebois et al. | Jan 2010 | A1 |
20100023541 | Cosic | Jan 2010 | A1 |
20100077468 | Pragides et al. | Mar 2010 | A1 |
20100082536 | Cosic | Apr 2010 | A1 |
20100088316 | Robinson et al. | Apr 2010 | A1 |
20100159903 | Goldman-Shenhar | Jun 2010 | A1 |
20100223228 | Logan et al. | Sep 2010 | A1 |
20100257376 | Little et al. | Oct 2010 | A1 |
20100278162 | Groux et al. | Nov 2010 | A1 |
20110010344 | Sjogren | Jan 2011 | A1 |
20110016089 | Freedman et al. | Jan 2011 | A1 |
20110106448 | Widmann et al. | May 2011 | A1 |
20110119281 | Cliff | May 2011 | A1 |
20110119758 | Uterhardt et al. | May 2011 | A1 |
20110145210 | Rathinam et al. | Jun 2011 | A1 |
20110145242 | Mehrotra et al. | Jun 2011 | A1 |
20110161290 | Waterman et al. | Jun 2011 | A1 |
20110258345 | Bhanote | Oct 2011 | A1 |
20110314482 | Cupala et al. | Dec 2011 | A1 |
20120016901 | Agarwal et al. | Jan 2012 | A1 |
20120101993 | Wong | Apr 2012 | A1 |
20120131036 | Averbuch | May 2012 | A1 |
20120131116 | Tu et al. | May 2012 | A1 |
20120159393 | Sethi | Jun 2012 | A1 |
20120173485 | Kothule et al. | Jul 2012 | A1 |
20120183221 | Alasry et al. | Jul 2012 | A1 |
20120192096 | Bowman | Jul 2012 | A1 |
20120209925 | Lee et al. | Aug 2012 | A1 |
20120209948 | Tenenblat et al. | Aug 2012 | A1 |
20130036089 | Lucas | Feb 2013 | A1 |
20130198171 | Shah | Aug 2013 | A1 |
20130311525 | Neerincx | Nov 2013 | A1 |
20140278754 | Cronin | Sep 2014 | A1 |
20150269156 | Awadallah | Sep 2015 | A1 |
20160063118 | Campbell | Mar 2016 | A1 |
Entry |
---|
Mittal et al., QueRIE: A Query Recommender System supporting Interactive Database Exploration, 2010, 4 pages. |
Tim Paek, Bongshin Lee, Bo Thiesson, Designing Phrase Builder: A Mobile Real-Time Query Expansion Interface, 2009, 10 pages, Microsoft Research. |
Number | Date | Country | |
---|---|---|---|
Parent | 17851558 | Jun 2022 | US |
Child | 18387749 | US | |
Parent | 16686191 | Nov 2019 | US |
Child | 17851558 | US | |
Parent | 15144714 | May 2016 | US |
Child | 16686191 | US | |
Parent | 13962948 | Aug 2013 | US |
Child | 15144714 | US |