Property-based deletion of digital data

Patent metadata

Field	Value
Publication number	US-10592485-B1
Application number	US-201916363967-A
Country	US
Kind code	B1
Filing date	Mar 25, 2019
Priority date	Dec 31, 2018
Publication date	Mar 17, 2020
Grant date	Mar 17, 2020

Abstract

In one embodiment, a computer-implemented method comprises receiving, from a second computing device at a first computing device that is communicatively coupled to the second computing device, a request to store a first entity data object, the first entity data object including a first property key-value pair; using the first computing device, storing the first entity data object in one or more digital data repositories in response to the request; receiving, from the second computing device at the first computing device, a delete command that specifies the first property key-value pair to delete by; in response to the delete command that specifies the first property key-value pair to delete by, deleting the first entity data object in the one or more digital data repositories.

First claim

What is claimed is:

1. A computer-implemented data processing method comprising:
receiving, from a second computing device at a first computing device that is communicatively coupled to the second computing device, a request to store a first entity data object, the first entity data object including a first property key-value pair, a second property key-value pair, and entity data;
creating and storing, in one or more digital data repositories, a multi-column table comprising an array type column that is structured as a variable length array;
storing the first property key-value pair and the second property key-value pair as separate elements of an array in the array type column of the multi-column table in the one or more digital data repositories in response to the request;
storing the entity data of the first entity data object in one or more columns other than the array type column of the multi-column table in the one or more digital data repositories in response to the request;
receiving, from the second computing device at the first computing device, a delete command that specifies the first property key-value pair to delete by;
in response to the delete command that specifies the first property key-value pair to delete by, deleting the first entity data object including the first property key-value pair, the second property key-value pair, and the entity data in the one or more digital data repositories.

2. The method of claim 1 , wherein the first computing device comprises a first collaboration platform and wherein the second computing device comprises a second collaboration platform;
wherein the first collaboration platform comprises an issue tracking system and wherein the second collaboration platform comprises a code repository system.

3. The method of claim 1 , wherein storing the first entity data object includes:
generating a first hash value for the first property key-value pair of the first entity data object;
storing the first hash value for the first property key-value pair in the one or more digital data repositories in place of the first property key-value pair.

4. The method of claim 3 , further comprising:
receiving, from the second computing device at the first computing device, a query including a select command that specifies a particular property key-value pair to select by;
generating a particular hash value for the particular property key-value pair included in the query;
in response to determining that the particular hash value matches the first hash value, generating a result set of the query that includes data from the first entity data object;
transmitting the result set of the query to the second computing device.

5. The method of claim 1 , further comprising:
receiving, from a third computing device at the first computing device communicatively coupled to the first computing device, a request to store a second entity data object, the second entity data object including a third property key-value pair;
using the first computing device, storing the second entity data object in the one or more digital data repositories in response to the request.

6. The method of claim 5 , wherein the first property key-value pair represents a first account management grouping of a first collaboration platform and wherein the third property key-value pair represents a second account management grouping of a second collaboration platform that is distinct from the first account management grouping.

7. The method of claim 1 , wherein the delete command comprises a Structured Query Language (SQL) delete command.

8. A computer-implemented data processing method comprising:
creating and storing, in one or more digital data storage repositories, a multi-column table comprising an array type column that is structured as a variable length array;
receiving, from a plurality of different computing devices, each of the different computing devices being associated with a different entity data object among multiple entity data objects, multiple sets of digital key-value pairs of properties of different entity data objects, each of the multiple entity data objects comprising at least one set of digital key-value pairs and entity data, each of the sets comprising at least a first property key-value pair and a second property key-value pair;
for a particular entity data object of the multiple entity data objects that includes a particular set of digital key-value pairs of properties, storing the first property key-value pair and second property key-value pair as separate elements of an array in the array type column of the multi-column table and storing the entity data in one or more columns other than the array type column of the multi-column table;
receiving a delete command that specifies the first property key-value pair of the particular set of digital key-value pairs of properties to delete by;
in response to the delete command, deleting the particular entity data object of the multiple entity data objects that is associated with the first property key-value pair of the particular set of digital key-value pairs of properties in the one or more digital data repositories.

9. The method of claim 8 , wherein storing the first property key-value pair and second property key-value pair for the particular set of digital key-value pairs of properties includes:
generating a first hash value for the first property key-value pair of the particular set of digital key-value pairs of properties;
generating a second hash value for the second property key-value pair of the particular set of digital key-value pairs of properties;
storing the first hash value in the one or more digital data repositories in place of the first property key-value pair of the particular set of digital key-value pairs of properties;
storing the second hash value in the one or more digital data repositories in place of the second property key-value pair of the particular set of digital key-value pairs of properties.

10. The method of claim 9 , further comprising:
receiving, from a particular computing device of the plurality of different computing devices, a query including a select command that specifies a particular property key-value pair to select by;
generating a particular hash value for the particular property key-value pair included in the query;
in response to determining that the particular hash value matches the first hash value, generating a result set of the query that includes data from a data object associated with the first property key-value pair of the particular set of digital key-value pairs of properties;
transmitting the result set of the query to the particular computing device.

11. A computer system comprising:
a first computing device and a second computing device, the first computing device comprising: a networking interface that is communicatively coupled to the second computing device and one or more digital data repositories; one or more non-transitory computer-readable storage media storing one or more sequences of instructions which when executed cause the first computing device to perform:
receiving, from the second computing device, a request to store a first entity data object, the first entity data object including a first property key-value pair, a second property key-value pair, and entity data;
creating and storing, in the one or more digital data repositories, a multi-column table comprising an array type column that is structured as a variable length array;
storing the first property key-value pair and the second property key-value pair as separate elements of an array in the array type column of the multi-column table in the one or more digital data reposi

Assignees

• Atlassian Pty Ltd
• Atlassian Inc

Inventors

• Morgan Benjamin
• Burn Oliver
• Rolf Christian
• Abakumov Konstantin

Classifications

• G06F16/215 Primary

  Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors · CPC title

• G06F16/221

  Column-oriented storage; Management thereof · CPC title

• G06F16/245

  Query processing · CPC title

• G06F16/2379

  Updates performed during online database operations; commit processing · CPC title

• G06F16/162

  Delete operations (erasing in storage systems G06F3/0652) · CPC title