Appian has been granted a patent for methods, systems, and computer-readable storage media that enable automatic and efficient updating of databases and database schemas. The techniques involve using machine learning to identify tasks of an application accessing data in a database, observing patterns of data access, and updating the database schema based on changes in the application’s access to data. GlobalData’s report on Appian gives a 360-degree view of the company including its patenting strategy. Buy the report here.
Smarter leaders trust GlobalData
According to GlobalData’s company profile on Appian, decentralized data stores was a key innovation area identified from patents. Appian's grant share as of June 2023 was 1%. Grant share is based on the ratio of number of grants to total number of patents.
Automatic and efficient updating of databases and database schemas
A recently granted patent (Publication Number: US11687520B1) describes a computer-readable medium that includes instructions for automatic and efficient updating of a database. The operations performed by the processor include generating an identification of a task of an application accessing data stored in the database through a machine learning process. This process involves monitoring the activity of the application accessing the data. The processor also determines patterns of the application's access to the data and provides the identified task and determined patterns to a feedback loop. Based on the identified characteristics of the determined patterns, the schema of the database is automatically updated.
The patent further specifies that the identified characteristics of the determined patterns may include a change in the patterns, which could be due to the creation of a new application or the detection of a set of data associated with a type of user device. Changes in the application's access to the data stored in the database, such as a new way of accessing the data or an increased frequency of access, can also trigger updates to the schema. The updates may involve updating access to the data at an individual data field level, granting a user device request for data access, or sharing the application's access to the data with another application.
The automatic updating of the schema of the database can include various actions, such as partitioning a physical table across machines, moving data to a specific location, or migrating data from one application data model to another. These updates can be conducted in the background of the application, without locks, and may also involve replicating the database and the application accessing the data. Additionally, the schema updates can include updating one or more schemas associated with a set of queries for accessing the data stored in the database.
Another aspect of the patent describes a computer-implemented method for automatic and efficient updating of a database. This method involves generating an identification of a task of an application accessing the data, determining patterns of the application's access, providing the identified task and determined patterns to a feedback loop, and automatically updating the schema of the database based on the identified characteristics of the determined patterns.
In summary, the granted patent outlines a computer-readable medium and a method for automatic and efficient updating of a database. The system utilizes machine learning to identify tasks and patterns of application access to the data stored in the database, and based on these patterns, the schema of the database is automatically updated. The patent also covers various scenarios and actions that can trigger updates to the schema, as well as the specific operations involved in the updating process.
To know more about GlobalData’s detailed insights on Appian, buy the report here.
Data Insights
From
The gold standard of business intelligence.
Blending expert knowledge with cutting-edge technology, GlobalData’s unrivalled proprietary data will enable you to decode what’s happening in your market. You can make better informed decisions and gain a future-proof advantage over your competitors.
GlobalData, the leading provider of industry intelligence, provided the underlying data, research, and analysis used to produce this article.
GlobalData Patent Analytics tracks bibliographic data, legal events data, point in time patent ownerships, and backward and forward citations from global patenting offices. Textual analysis and official patent classifications are used to group patents into key thematic areas and link them to specific companies across the world’s largest industries.
