Text-sql relational database

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.

Description

CROSS-REFERENCE TO RELATED APPLICATIONS[0001]This nonprovisional application is a continuation of and claims priority to nonprovisional application Ser. No. 14 / 195,291, entitled “TEXT-SQL RELATIONAL DATABASE,” filed Mar. 3, 2014 by the same inventor.BACKGROUND OF THE INVENTION[0002]1. Field of the Invention[0003]This invention relates, generally, to the field of computing. More specifically, it relates to client-side data storage systems.[0004]2. Brief Description of the Prior Art[0005]Historically, persistent local storage has been one of the key factors in preventing Web applications from achieving an improved user experience typically associated with native client applications. Native applications have had the benefit of using a computer's operating system for storage and retrieval of application-specific data. Whereas, Web applications have traditionally used Cookies for client-side data storage.[0006]There are four current options for client-side storage: Cookies, Web-storage (...

AI Technical Summary

Benefits of technology

This approach significantly improves data storage and retrieval performance, reduces storage needs by 80%, increases storage capacity by five times, and prevents race conditions, while maintaining cross-browser compatibility and supporting asynchronous transactions.

Problems solved by technology

However, cookies contain many critical downsides, including: (1) cookies are included in HTTP requests, resulting in slow Web application performance associated with the unnecessary data transmission; (2) the HTTP requests transmit the data in an unencrypted format; (3) the storage capacity is limited to roughly 4 KB of data; and (4) are designed as very simple key / value persistent storage system having its own set of shortcomings as described below.

All key / value storage systems have the following common shortcomings: (1) they cannot store structured data (only text strings), (2) cannot provide in-order retrieval of keys, (3) cannot efficiently search over-values, (4) cannot store duplicate keys, and (4) lack the ability to relate and correlate the information.

Furthermore, transactional safety is not a standard feature, which is an obvious issue now-a-days.

The problem with the Web SQL Database specification is that it is not fully supported by all database vendors.

This option contains the usual problems associated with flat file database—high level of concurrency and missing features.

Furthermore, IndexedDB is not supported by all vendors.

An additional problem associated with all of the current technologies is the possibility of experiencing a race condition.

A race condition is an undesirable situation that occurs when a device or system attempts to perform two or more operations at the same time, but because of the nature of the device or system, many of the operations must take part in the proper sequence (especially in maintaining state of objects) in order to be completed correctly.

However, synchronous transactions are often the cause of slow computing because of the often-arising need to transfer large amount of data.

Furthermore, where a definition or use of a term in a reference, which is incorporated by reference herein, is inconsistent or contrary to the definition of that term provided herein, the definition of that term provided herein applies and the definition of that term in the reference does not apply.

Images