Text-SQL relational database

• US 9,015,165 B1
• Filed: 03/03/2014
• Issued: 04/21/2015
• Est. Priority Date: 03/03/2014
• Status: Active Grant

• Current Assignee: Michael Lee Hamm
• Original Assignee: Michael L. Hamm
• Inventors: Hamm, Michael L.
• Primary Examiner(s): SYED, FARHAN M
• Application Number:
  US14/195,291
• Time in Patent Office: 414 Days
• US Class Current: 707/737
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/285 Clustering or classification
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]

Abstract

The present invention is a method and system for storing, retrieving, and updating data stored in a persistent Name/Value storage container. The system and method combine similar data into data strings using a programming language referred to as Text-SQL that separates and relates the data using delimiters. The data strings are further combined into groups of like data strings that are also organized using delimiters. These groups of data strings are assigned a name and stored in a Name/Value storage container with the value being the grouped data string. The present invention uses simple dot-notation to parse the data strings into specific detailed information, which may be accomplished through an application programming interface (Text-SQL API) that provides functions for updating, deleting, retrieving, and storing data. The API utilizes a standard syntax for use with Cookies, HTML5 sessionStorage, and HTML5 localStorage providing cross-browser functionality and simplified programming.

Claims

1. A non-transitory computer readable storage media having computer-executable instructions, when executed by a processor, performing a method for storing, retrieving, and updating data of a visual graphic user interface on a web browser, the instructions comprising:

establishing a data connection between a web browser client and a remote web server;

receiving default data from the remote web server, by the web browser client;

monitoring properties of one or more windows as modified by an end user accessing the web browser client;

combining data, representing similar properties of the one or more windows, into data strings using a programming language, where the similar properties are predetermined and separated using delimiters;

combining the data strings into groups, wherein the groups are a predetermined set of related data strings;

maintaining, using group delimiters, an organized structure of the combined related data strings to keep the plurality of data strings individually accessible;

saving the groups of data strings as a single concatenated string;

storing the concatenated string in a persistent Name/Value storage container, where the name is a predetermined key representing the concatenated string and the value is the concatenated string; and

generating an event by an end user wherein the event comprises of a data updating action, a data inserting action, a data deleting action, and a data selecting action;

responsive to the data updating action;

accessing the Name/Value storage container containing some data to be updated;

selecting the data from the concatenated string using simple dot-notation to parse the concatenated string;

updating the data;

saving the concatenated string with the updated data;

storing the saved concatenated string in the Name/Value storage container;

responsive to the data inserting action;

accessing the Name/Value storage container where some data is to be inserted;

parsing the concatenated string using simple dot-notation;

inserting the data;

saving the concatenated string with the inserted data;

storing the saved concatenated string in the Name/Value storage container;

responsive to the data deleting action;

accessing the specified Name/Value storage container containing some data to be deleted;

selecting the data from the concatenated string using simple dot-notation to parse the concatenated string;

deleting the data;

saving the concatenated string without the deleted data;

storing the saved concatenated string in the Name/Value storage container;

responsive to the data selecting action;

accessing the specified Name/Value storage container containing some data to be retrieved;

parsing the concatenated string using simple dot-notation;

selecting the data from the concatenated string; and

returning the specific data.

2. The non-transitory computer readable storage media as in claim 1, further comprising:

responsive to a predetermined event, uploading the data to the web server, where the data is associated with an account authenticated by the end user.

3. The non-transitory computer readable storage media as in claim 1, further comprising:

using an application programming interface to encapsulate the programming language with functions using simple dot-notation declarative statements for performing particular operations.

4. The non-transitory computer readable storage media as in claim 3, further comprising:

the functions of the application programming interface including a select function, an insert function, an update function, and a delete function, where each function has the same syntax for any Name/Value storage container.

5. The non-transitory computer readable storage media as in claim 1, further comprising:

the programming language further including;

an attribute delimited text string with an assigned field name to relate the attribute delimited text string;

a field text string using delimiters separating the field values and field names;

a field delimited text string referred to as a row;

a single row delimited text string referred to as a table; and

an assigned name to relate the table string.

6. A computer-implemented method of storing, retrieving, and updating data of a visual graphic user interface on a web browser, the method comprising the steps of:

establishing a data connection between a web browser client and a remote web server, wherein the web browser client is a computer application on a computer device;

receiving default data from the remote web server, by the web browser client;

monitoring properties of one or more windows as modified by an end user accessing the web browser client;

combining data, representing similar properties of the one or more windows, into data strings using a programming language, where the similar properties are predetermined and separated using delimiters;

combining the data strings into groups, wherein the groups are a predetermined set of related data strings;

maintaining, using group delimiters, an organized structure of the combined related data strings to keep the plurality of data strings individually accessible;

saving the groups of data strings as a single concatenated string;

storing the concatenated string in a persistent Name/Value storage container, where the name is a predetermined key representing the concatenated string and the value is the concatenated string; and

generating an event by an end user wherein the event comprises of a data updating action, a data inserting action, a data deleting action, and a data selecting action;

responsive to the data updating action;

accessing the Name/Value storage container containing some data to be updated;

selecting the data from the concatenated string using simple dot-notation to parse the concatenated string;

updating the data;

saving the concatenated string with the updated data;

storing the saved concatenated string in the Name/Value storage container;

responsive to the data inserting action;

accessing the Name/Value storage container where some data is to be inserted;

parsing the concatenated string using simple dot-notation;

inserting the data;

saving the concatenated string with the inserted data;

storing the saved concatenated string in the Name/Value storage container;

responsive to the data deleting action;

accessing the specified Name/Value storage container containing some data to be deleted;

selecting the data from the concatenated string using simple dot-notation to parse the concatenated string;

deleting the data;

saving the concatenated string without the deleted data;

storing the saved concatenated string in the Name/Value storage container;

responsive to the data selecting action;

accessing the specified Name/Value storage container containing some data to be retrieved;

parsing the concatenated string using simple dot-notation;

selecting the data from the concatenated string; and

returning the specific data.

7. The computer-implemented method as in claim 6, further comprising:

responsive to a predetermined event, uploading the data to the web server, where the data is associated with an account authenticated by the end user.

8. The computer-implemented method as in claim 6, further comprising:

using an application programming interface to encapsulate the programming language with functions using simple dot-notation declarative statements for performing particular operations.

9. The computer-implemented method as in claim 8, further comprising:

the functions of the application programming interface including a select function, an insert function, an update function, and a delete function, where each function has the same syntax for any Name/Value storage container.

10. The computer-implemented method as in claim 6, further comprising:

the programming language further including;

an attribute delimited text string with an assigned field name to relate the attribute delimited text string;

a field text string using delimiters separating the field values and field names;

a field delimited text string referred to as a row;

a single row delimited text string referred to as a table; and

an assigned name to relate the table string.

11. A non-transitory computer readable storage media having computer-executable instructions, when executed by a processor, performing a method for storing, retrieving, and updating data of a graphic user interface on a web browser, the instructions comprising

establishing a data connection between a web browser client and a remote web server;

receiving one or more graphic user interfaces from the remote web server, by the web browser client;

monitoring properties of the one or more graphic user interfaces as modified by an end user accessing the web browser client;

combining data, representing similar properties of the one more graphic user interfaces, into data strings using a programming language, where the similar properties are predetermined and separated using delimiters;

combining the data strings into groups, wherein the groups are a predetermined set of related data strings;

maintaining, using group delimiters, an organized structure of the combined related data strings to keep the plurality of data strings individually accessible;

saving the groups of data strings as a single concatenated string;

storing the concatenated string in a persistent Name/Value storage container, where the name is a predetermined key representing the concatenated string and the value is the concatenated string;

generating an event by an end user wherein the event comprises of a data updating action, a data inserting action, a data deleting action, and a data selecting action;

responsive to the data updating action;

accessing the Name/Value storage container containing the properties to be updated;

selecting the properties from the concatenated string, using simple dot-notation to parse the concatenated string;

updating the properties;

saving the concatenated string with the updated properties; and

storing the saved concatenated string in the Name/Value storage container;

responsive to the data deleting action;

accessing the specified Name/Value storage container containing the properties to be deleted;

selecting the properties from the concatenated string, using simple dot-notation to parse the concatenated string;

deleting the properties;

saving the concatenated string without the deleted properties;

storing the saved concatenated string in the Name/Value storage container;

responsive to the data retrieving action;

accessing the specified Name/Value storage container containing the properties to be retrieved;

selecting the properties from the concatenated string, using simple dot-notation to parse the concatenated string;

returning the specific properties; and

responsive to a predetermined event, uploading the properties to the web server, where the properties are associated with an account authenticated by the end user.

12. The non-transitory computer readable storage media of claim 11, further comprising an application programming interface to encapsulate the programming language with functions using simple dot-notation declarative statements for performing particular operations, the functions of the application programming interface further including a select function, an insert function, an update function, and a delete function, where each function has the same syntax for any Name/Value storage container.