REAL-TIME DOCUMENT FILTERING SYSTEMS AND METHODS

• US 20180067932A1
• Filed: 08/30/2017
• Published: 03/08/2018
• Est. Priority Date: 09/02/2016
• Status: Active Grant

• Current Assignee: FutureVault, Inc.
• Original Assignee: FutureVault, Inc.
• Inventors: Paterson, Gordon Scott, Bradley, Michael, Rosenberg, Brad, Ko, Ka Fu
• Granted Patent: US 11,475,074 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/156 Query results presentation
• CPC Class Codes: G06F 16/168 Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs query results presentation G06F16/156
• CPC Class Codes: G06F 16/287 Visualization; Browsing
• CPC Class Codes: G06F 16/9024 Graphs; Linked lists G06F16/9027 takes precedence
• CPC Class Codes: G06F 16/904 Browsing; Visualisation therefor for navigating the web G06F16/954; browsing optimisation for the web G06F16/957
• CPC Class Codes: G06F 16/93 Document management systems
• CPC Class Codes: G06F 3/04817 using icons graphical or visual programming using iconic symbols G06F8/34
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus

Abstract

Methods, systems and computer program products for organizing and displaying in real-time data related to a plurality of documents. A plurality of documents and a plurality of entity identifiers are stored in a relational database storage. Each entity identifier has an entity type selected from a plurality of entity types. A plurality of entity associations between the plurality of entity identifiers and the plurality of documents are stored in a non-relational database storage. Each entity association defines a relationship between one or more entity identifiers and a selected document in the plurality of documents. A plurality of file icons are displayed in a display interface. The plurality of file icons includes active icons corresponding to a selection of the plurality of documents where the selection is determined by querying the non-relational database storage using at least one currently-selected entity identifier.

Claims

1. A method for organizing and displaying in real-time data related to a plurality of documents, the method comprising:

storing a plurality of documents in a relational database storage;

storing a plurality of entity identifiers in the relational database storage, each of the plurality of entity identifiers having an entity type selected from a plurality of entity types;

recording in a non-relational database storage a plurality of entity associations between the plurality of entity identifiers and the plurality of documents, wherein each entity association comprises a relationship between one or more entity identifier from the plurality of entity identifiers and a selected document in the plurality of documents; and

displaying a plurality of file icons in a display interface, the plurality of file icons including active icons corresponding to a selection of the plurality of documents, wherein the selection is determined by querying the non-relational database storage using at least one currently-selected entity identifier.

2. The method of claim 1, further comprising:

storing a plurality of document categories in the relational database storage;

assigning each document in the plurality of documents to at least one of the document categories;

recording in the non-relational database storage a plurality of category associations between the plurality of entity identifiers and the plurality of document categories, wherein each category association comprises a category relationship between a selected category in the plurality of document categories and one or more entity identifiers; and

displaying the plurality of file icons by

determining a selected plurality of document categories by querying the plurality of category associations in the non-relational database storage using the at least one currently-selected entity identifier;

determining the plurality of file icons to include a plurality of category icons corresponding to the selected plurality of document categories; and

displaying the plurality of file icons.

3. The method of claim 2, wherein:

the plurality of document categories are recorded in the non-relational database storage as a category hierarchy including at least one parent category and at least one sub-category nested within each parent category; and

the category associations for each parent category inherit the category associations for each of the at least one sub-category nested within that parent category.

4. The method of claim 2, wherein the plurality of category associations are determined by:

defining default category associations for each entity type; and

determining the plurality of category associations to include the default category associations for the entity type of each entity identifier.

5. The method of any one of claims 3 and 4, further comprising:

storing an additional document in the relational database storage associated with a first document sub-category;

updating the entity associations by defining in the non-relational database storage a relationship between the additional document and a particular entity identifier, wherein the particular entity identifier is not associated with the first document sub-category; and

updating the category associations in the non-relational database storage for the first document sub-category to include the particular entity identifier.

6. The method of claim 5, further comprising automatically updating the category associations in the non-relational database storage for each parent category the first document sub-category is nested within.

7. The method of claim 2, further comprising:

determining the selected plurality of document categories to include all of the document categories associated with the entity type of each of the at least one currently-selected entity identifier.

8. The method of claim 2, further comprising:

recording in the non-relational database storage an icon status for each of the document categories in the plurality of document categories, wherein the icon status for each document category is an active icon status indicating that the corresponding category icon is an active icon when at least one of the documents in the selection of the plurality of documents is assigned to that document category and is an inactive icon status otherwise.

9. The method of claim 8, wherein the plurality of document categories are recorded in the non-relational database storage as a category hierarchy including at least one parent category and at least one sub-category nested within each parent category, wherein the category associations for each parent category inherit the category associations for each of the at least one sub-category nested within that parent category, wherein the icon status in the non-relational database storage for each parent category is determined by inheriting the icon status of each sub-category nested within that parent category, and the icon status for the parent category is an active icon status when at least one inherited icon status is active.

10. The method of claim 1, wherein the plurality of file icons displayed include only the active document icons corresponding to the determined selection of the plurality of documents.

11. The method of claim 2, further comprising:

recording in the non-relational database storage a document count for each of the document categories in the plurality of document categories, the document count for each document category indicating a number of documents in the selection of the plurality of documents associated with that document category.

12. The method of claim 11, wherein the plurality of document categories are recorded in the non-relational database storage as a category hierarchy including at least one parent category and at least one sub-category nested within each parent category, wherein the category associations for each parent category inherit the category associations for each of the at least one sub-category nested within that parent category, wherein the document count in the non-relational database storage for each parent category is determined by inheriting the document count from each sub-category nested within that parent category.

13. The method of claim 2, further comprising:

modifying the entity associations for a second selected document in the plurality of documents; and

automatically triggering an update to the category associations for each of the document categories associated with the second selected document using the modified entity association for that second selected document.

14. A non-transitory computer program product for organizing and displaying in real-time data related to a plurality of documents, the computer program product comprising a non-transitory computer readable storage medium and computer-executable instructions stored on the computer readable storage medium, the instructions for configuring a processor to:

store a plurality of documents in a relational database storage;

store a plurality of entity identifiers in the relational database storage, each of the plurality of entity identifiers having an entity type selected from a plurality of entity types;

record in a non-relational database storage a plurality of entity associations between the plurality of entity identifiers and the plurality of documents, wherein each entity association comprises a relationship between one or more entity identifier from the plurality of entity identifiers and a selected document in the plurality of documents; and

display a plurality of file icons in a display interface, the plurality of file icons including active icons corresponding to a selection of the plurality of documents, wherein the selection is determined by querying the non-relational database storage using at least one currently-selected entity identifier.

15. A system for organizing and displaying in real-time data related to a plurality of documents, the system comprising:

a relational database storage;

a non-relational database storage coupled to the relational database storage; and

a server in communication with the relational database storage and the non-relational database storage, the server configured to

store a plurality of documents in the relational database storage;

store a plurality of entity identifiers in the relational database storage, each of the plurality of entity identifiers having an entity type selected from a plurality of entity types;

record in the non-relational database storage a plurality of entity associations between the plurality of entity identifiers and the plurality of documents, wherein each entity association comprises a relationship between one or more entity identifier from the plurality of entity identifiers and a selected document in the plurality of documents; and

determine a plurality of file icons to be displayed in a display interface of a device in communication with the server, the plurality of file icons including active icons corresponding to a selection of the plurality of documents, wherein the selection is determined by querying the non-relational database storage using at least one currently-selected entity identifier.

16. The system of claim 15, wherein the server is further configured to

store a plurality of document categories in the relational database storage;

assign each document in the plurality of documents to at least one of the document categories;

record in the non-relational database storage a plurality of category associations between the plurality of entity identifiers and the plurality of document categories, wherein each category association comprises a category relationship between a selected category in the plurality of document categories and one or more entity identifiers; and

determine the plurality of file icons by

determining a selected plurality of document categories by querying the plurality of category associations in the non-relational database storage using the at least one currently-selected entity identifier; and

determining the plurality of file icons to include a plurality of category icons corresponding to the selected plurality of document categories.

17. The system of claim 16, wherein:

the plurality of document categories are stored in the non-relational database as a category hierarchy including at least one parent category and at least one sub-category nested within each parent category; and

the category associations for each parent category inherit the category associations for each of the at least one sub-category nested within that parent category.

18. The system of claim 16, wherein the server is configured to determine the plurality of category associations by:

defining default category associations for each entity type; and

determining the plurality of category associations to include the default category associations for the entity type of each entity identifier.

19. The system of claim 17, wherein the server is further configured to:

store an additional document in the relational database storage associated with a first document sub-category;

update the entity associations by defining in the non-relational database storage a relationship between the additional document and a particular entity identifier, wherein the particular entity identifier is not associated with the first document sub-category; and

update the category associations in the non-relational database storage for the first document sub-category to include the particular entity identifier.

20. The system of claim 19 wherein the server is further configured to trigger an automatic update of the category associations in the non-relational database storage for each parent category the first document sub-category is nested within.

21. The system of claim 16, wherein the server is further configured to:

determine the selected plurality of document categories to include all of the document categories associated with the entity type of each of the at least one currently-selected entity identifier.

22. The system of claim 16, the server is further configured to:

record in the non-relational database storage an icon status for each of the document categories in the plurality of document categories, wherein the icon status for each document category is an active icon status indicating that the corresponding category icon is an active icon when at least one of the documents in the selection of the plurality of documents is assigned to that document category and is an inactive icon status otherwise.

23. The system of claim 22, wherein the plurality of document categories are stored in the non-relational database as a category hierarchy including at least one parent category and at least one sub-category nested within each parent category, wherein the category associations for each parent category inherit the category associations for each of the at least one sub-category nested within that parent category, wherein the server is configured to determine the icon status in the non-relational database storage for each parent category by inheriting the icon status of each sub-category nested within that parent category, and the icon status for the parent category is an active icon status when at least one inherited icon status is active.

24. The system of claim 15, wherein the server is configured to determine the plurality of file icons to be displayed to include only the active document icons corresponding to the determined selection of the plurality of documents.

25. The system of claim 16, wherein the server is further configured to:

record in the non-relational database storage a document count for each of the document categories in the plurality of document categories, the document count for each document category indicating a number of documents in the selection of the plurality of documents associated with that document category.

26. The system of claim 25, wherein the document count in the non-relational database storage for each parent category is determined by inheriting the document count from each sub-category nested within that parent category.

27. The system of claim 16, wherein the server is further configured to:

modify the entity association for a second selected document in the plurality of documents; and

automatically trigger an update to the category associations for each of the document categories associated with the second selected document using the modified entity association for that second selected document.