INTEGRATED WEB-BASED WORKSPACE WITH CURATED TREE-STRUCTURE DATABASE SCHEMA

• US 20120096389A1
• Filed: 07/19/2011
• Published: 04/19/2012
• Est. Priority Date: 10/19/2010
• Status: Abandoned Application

• Current Assignee: IQTell.com, LLC
• Original Assignee: IQTell.com, LLC
• Inventors: Kogan, Daniel, Flam, Ran J
• Application Number:
  US13/186,085
• Publication Number:
  US 20120096389A1
• Time in Patent Office: Days
• US Class Current: 715/777
• 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/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking

Abstract

A virtual web-based computing platform combining a particular network database hierarchy, graphical user interface, and integrated suite of computational tools accessible on demand, by which users gain access to an integrated Virtual Workspace for organizing emails, contacts, bookmarks, tasks, documents, notes, and all other relevant information. The network database hierarchy employs unique data structure and methods, allowing the user to centrally store and manage all data, regardless of type, as well as activities (actions taken and documented by the user). Nevertheless, the interface to said database offers a familiar folder/sub-folder “look and feel” using a tree data hierarchy, which gives a common, centralized and unified approach for storing, managing, displaying, and various types of data, regardless of object- and data-types.

Claims

1. A system for web-based data management, the system comprising:

a host computer communicatively coupled to multiple client computers via at least one network;

a database resident on said host computer and storing a plurality of data entries in a workspace comprising a plurality of defined folders and sub-folders, each of said plurality of data entries comprising one or more defined Data Fields (DFs), each DF within said folders and sub-folders storing a particular type of data from among a group of different types of data;

a plurality of pre-defined Data Field Type Indicators, each DF within said folders and sub-folders being tagged by a corresponding Data Field Type Indicator;

a plurality of pre-defined Folder Templates each associated with one of said defined folders and sub-folders, and each defining a plurality of attributes of said associated folder/sub-folder including display characteristics for displaying said folders/sub-folders in a tabular view;

a plurality of pre-defined Data Entry Forms (DEFs) each associated with one of said defined folders and sub-folders, each DEF defining how data is entered in said associated folder/sub-folder, including the display characteristics of DFs associated with said folder/sub-folder; and

a graphical user interface comprising a tree view for displaying said folders and sub-folders in a collapsible/expandable tree array, and a tabular view that displays entries of one or more selected folders/sub-folders in accordance with said associated Folder Template.

2. The system for web-based data management services according to claim 1, wherein said plurality of attributes defined by said Folder Templates include any one or more attributes from among a group including Column Headings, Entry Title, Search Fields, Copy Fields, and Initial Values.

3. The system for web-based data management services according to claim 1, wherein said plurality of pre-defined Data Field types include any from among a group including an encrypted data field for encrypted storage of an entry in the database in an encrypted fashion, a URL for storage of a URL entry in the database, a file attachment for storage of a file in the database, and an Email Reference for storage of a reference to an email address.

4. The system for web-based data management services according to claim 1, wherein said plurality of pre-defined Data Field types include a web search field for archival storage of search keywords in said database and to launch a web search using said keywords.

5. The system for web-based data management services according to claim 2, wherein said plurality of pre-defined Data Field types include “

Single-value Reference DF”

having a single value entry that references another data entry, and “

Multi-value Reference DF”

having one or more value entries that references multiple other data entries.

6. The system for web-based data management services according to claim 1, wherein said graphical user interface comprises a search engine for keywords and phrases searching all of the contents of folders and sub-folders in said tree view.

7. The system for web-based data management services according to claim 6, wherein said search engine identifies all data entries in the folders and sub-folders having data matching said keywords or search phrases, and all Single-value Reference DFs and Multi-value Reference DFs referencing said matching data entries.

8. The system for web-based data management services according to claim 5, wherein folders and sub-folders in said tree view may be related either by referencing a Single-value Reference DF or Multi-value Reference DF in each of said related folders/sub-folders, and wherein adding a data entry in one Reference DF automatically updates and adds a corresponding value entry in a corresponding Reference DF in a related folder/sub-folder.

9. The system for web-based data management services according to claim 1, wherein said a graphical user interface comprises a plurality of selectable columnar tabs where the selection of each columnar tab engenders a display of data entries of a corresponding folder/sub-folder using the tabular view and the Folder Template associated with said folder/sub-folder or a selected data entry displayed using the DEF associated with the folder/sub-folder that said data entry is part of.

10. The system for web-based data management services according to claim 1, wherein a different user-programmable Folder Template may be assigned to each folder and sub-folder said collapsible/expandable tree array.

11. The system for web-based data management services according to claim 2, wherein said plurality of attributes defined by said user-programmable Folder Templates include Copy Fields Next, which automatically copies predetermined DFs from a given data entry when creating a new data entry in the associated folder/sub-folder based on said data entry.

12. The system for web-based data management services according to claim 11 wherein said plurality of attributes of defined by said user-programmable Folder Templates include Copy Fields Other, which automatically copies predetermined DFs from an existing data entry when creating a new data entry in a different folder/sub-folder based on said entry.

13. The system for web-based data management services according to claim 11, wherein a user can create a sub-folder to a parent folder and the created sub-folder is automatically assigned the Folder Template and the DEF that are associated with the parent folder

14. The system for web-based data management services according to claim 1, wherein said a graphical user interface includes a folder configuration editor for defining said user-programmable Folder Templates.

15. The system for web-based data management services according to claim 1, wherein said a graphical user interface includes a Data Entry Form editor for allowing user-definition of said DEFs.

16. The system for web-based data management services according to claim 15, wherein each time that a user creates a folder/sub-folder an associated DEF and a Folder Template must also be defined.

17. The system for web-based data management services according to claim 1, wherein said graphical user interface tree view displays said folders and sub-folders in a collapsible/expandable and selectable tree array, each said folder/sub-folder can be selected to be displayed using the tabular view and an associated Folder Template, and said graphical user interface further comprises a Preview Pane for displaying contents of a selected data entry from said tabular view, all of said tree view, tabular view and Preview pane being concurrently displayed.

18. The system for web-based data management services according to claim 2, wherein said plurality of attributes of defined by said Folder Templates include a Task Folder attribute that automatically appends a workflow of defined status Data Fields to entries in the corresponding folder/subfolder, said status Data Fields further having attributes of “

Closed” and

“

Completed”

where the first denotes a task closed for any reason and the latter denotes a task closed with a status indicating that the goals of the task were accomplished.

19. The system for web-based data management services according to claim 18, wherein said user can selectively display said status Data Fields in said tabular view.

20. The system for web-based data management services according to claim 19, wherein said user can selectively set a status to be assigned to said Status Data Field of any given data entries in a Task Folder.

21. The system for web-based data management services according to claim 1, wherein a user may selectively allow access to any defined folder, sub-folder, selected data entries therein, or an entire Workspace by another guest user in accordance with a predefined set of permissions specifying permitted guest users, defined folders, sub-folders, or selected data entries therein to be shared with each said permitted guest user, and where said permissions include but are not limited to creating data entries, modifying existing data entries, and deleting data entries.

22. The system for web-based data management services according to claim 1, wherein a user may selectively request to publish any defined folder or sub-folder.

23. The system for web-based data management services according to claim 22, wherein a user may selectively issue a request to publish any defined folder or sub-folder, an administrative user may selectively grant said request and publish a defined folder or sub-folder, and all users may view published folders or sub-folders.

24. The system for web-based data management services according to claim 22, wherein other users may elect to view any published folder or sub-folder within their personal Workspace within the tree view of their folders/sub-folders, and said other users may rank said published folders or sub-folders.

25. The system for web-based data management services according to claim 1, wherein a user may selectively export one or more defined folders, sub-folders, or selected data entries within their Workspace , whereby a copy of said folders, sub-folders, or data entries are operational in another user'"'"'s Workspace, said copy including the associated Folder Templates, DEFs and, optionally, the data entries included in said folders and sub-folders.

26. The system for web-based data management services according to claim 1, wherein a user may selectively specify one or more Reminders for any data entry in their Workspace.

27. The system for web-based data management services according to claim 26, wherein said Reminders can specify a Date or a Date/Time DF used by said data entry to be used as the basis for said Reminder.

28. The system for web-based data management services according to claim 1, whereby a user can create a new entry based on any existing entry in said workspace.

29. The system for web-based data management services according to claim 28, wherein said a graphical user interface includes a consolidated display of all subsequent entries in the Workspace that were created based on an existing entry.

30. The system for web-based data management services according to claim 29, wherein said consolidated display of all subsequent entries in the Workspace indicates the existing entry upon which said subsequent entries were based.

31. A method of controlling processing of data in a distributed computer system including a web-enabled computer server and a plurality of remote workstations in communication with said web-enabled computer server, comprising the steps of:

defining a workspace comprising a plurality of defined folders and sub-folders resident in a database on said host computer;

defining a plurality of Folder Templates each associated with one of said defined folders and sub-folders, and each defining a plurality of attributes of said associated folder/sub-folder including display characteristics for displaying said folders/sub-folders in a tabular view;

defining a plurality of Data Entry Forms (DEFs) each associated with one of said defined folders and sub-folders, each DEF defining how data is entered in said associated folder/sub-folder, including the display characteristics of DFs associated with said folder/sub-folder;

storing a plurality of data entries within said folders and sub-folders, each of said plurality of data entries comprising one or more defined Data Fields (DFs), each DF storing a corresponding type of data from among a group of different types of data;

tagging each DF with a corresponding Data Field Type Indicator indicating the corresponding type of data entered in each said DF; and

providing a graphical user interface comprising a tree view for displaying said folders and sub-folders in a collapsible/expandable tree array, and a tabular view that displays entries of one or more selected folders/sub-folders in accordance with said associated Folder Template.

32. The method of controlling processing of data in a distributed computer system according to claim 31, wherein said plurality of attributes defined by said Folder Templates include any one or more attributes from among a group including Column Headings, Entry Title, Search Fields, Copy Fields, and Initial Values.

33. The method of controlling processing of data in a distributed computer system according to claim 31, wherein said plurality of pre-defined Data Field types include any from among a group including an encrypted data field for encrypted storage of an entry in the database in an encrypted fashion, a URL for storage of a URL entry in the database, a file attachment for storage of a file in the database, and an Email Reference for storage of a reference to an email address.

34. The method of controlling processing of data in a distributed computer system according to claim 31, wherein said plurality of pre-defined Data Field types include a web search field for archival storage of search keywords in said database and to launch a web search using said keywords.

35. The method of controlling processing of data in a distributed computer system according to claim 32, wherein said plurality of pre-defined Data Field types include “

Single-value Reference DF”

having a single value entry that references another data entry, and “

Multi-value Reference DF”

having one or more value entries that references multiple other data entries.

36. The method of controlling processing of data in a distributed computer system according to claim 31, wherein said step of providing said graphical user interface comprises providing a search engine for keywords and phrases searching all of the contents of folders and sub-folders in said tree view.

37. The method of controlling processing of data in a distributed computer system according to claim 36, further comprising a step of using search engine to identify all data entries in the folders and sub-folders having data matching said keywords or search phrases, and all Single-value Reference DFs and Multi-value Reference DFs referencing said matching data entries.

38. The method of controlling processing of data in a distributed computer system according to claim 35, further comprising a step of relating folders and sub-folders in said tree view either by referencing a Single-value Reference DF or Multi-value Reference DF in each of said related folders/sub-folders, whereby adding a data entry in one Reference DF automatically updates and adds a corresponding value entry in a corresponding Reference DF in a related folder/sub-folder.

39. The method of controlling processing of data in a distributed computer system according to claim 31, wherein said step of providing a graphical user interface comprises providing a plurality of selectable columnar tabs where the selection of each columnar tab engenders a display of data entries of a corresponding folder/sub-folder using the tabular view and the Folder Template associated with said folder/sub-folder or a selected data entry displayed using the DEF associated with the folder/sub-folder that said data entry is part of.

40. The method of controlling processing of data in a distributed computer system according to claim 31, further comprising a step of assigning a different user-programmable Folder Template to each folder and sub-folder said collapsible/expandable tree array.

41. The method of controlling processing of data in a distributed computer system according to claim 32, wherein said plurality of attributes defined by said user-programmable Folder Templates include Copy Fields Next, which automatically copies predetermined DFs from a given data entry when creating a new data entry in the associated folder/sub-folder based on said data entry.

42. The method of controlling processing of data in a distributed computer system according to claim 41 wherein said plurality of attributes of defined by said user-programmable Folder Templates include Copy Fields Other, which automatically copies predetermined DFs from an existing data entry when creating a new data entry in a different folder/sub-folder based on said entry.

43. The method of controlling processing of data in a distributed computer system according to claim 41, further comprising a step of creating a sub-folder to a parent folder and automatically assigning the Folder Template and the DEF that associated with the parent folder to the created sub-folder.

44. The method of controlling processing of data in a distributed computer system according to claim 31, wherein said step of providing a graphical user interface includes providing a folder configuration editor for defining said user-programmable Folder Templates.

45. The method of controlling processing of data in a distributed computer system according to claim 31, wherein said step of providing a graphical user interface includes providing a Data Entry Form editor for allowing user-definition of said DEFs.

46. The method of controlling processing of data in a distributed computer system according to claim 45, further comprising a step of associated a DEF and a Folder Template to each folder/sub-folder created by a user.

47. The method of controlling processing of data in a distributed computer system according to claim 31, wherein said step of providing a graphical user interface includes displaying said folders and sub-folders in said tree view in a collapsible/expandable and selectable tree array wherein each said folder/sub-folder can be selected to be displayed using the tabular view and an associated Folder Template, and providing a Preview Pane for displaying contents of a selected data entry from said tabular view, all of said tree view, tabular view and Preview pane being concurrently displayed.

48. The method of controlling processing of data in a distributed computer system according to claim 32, wherein said plurality of attributes of defined by said Folder Templates include a Task Folder attribute that automatically appends a workflow of defined status Data Fields to entries in the corresponding folder/subfolder, said status Data Fields further having attributes of “

Closed” and

“

Completed”

where the first denotes a task closed for any reason and the latter denotes a task closed with a status indicating that the goals of the task were accomplished.

49. The method of controlling processing of data in a distributed computer system according to claim 48, further comprising a step of selectively displaying said status Data Fields in said tabular view.

50. The method of controlling processing of data in a distributed computer system according to claim 49, further comprising a step of selectively setting a status to be assigned to said Status Data Field of any given data entries in a Task Folder.

51. The method of controlling processing of data in a distributed computer system according to claim 31, further comprising a step of said user selectively providing access to any defined folder, sub-folder, selected data entries therein, or an entire workspace by another guest user in accordance with a predefined set of permissions specifying permitted guest users, defined folders, sub-folders, or selected data entries therein to be shared with each said permitted guest user, and where said permissions include but are not limited to creating data entries, modifying existing data entries, and deleting data entries.

52. The method of controlling processing of data in a distributed computer system according to claim 31, further comprising a step of said user selectively requesting to publish any defined folder or sub-folder.

53. The method of controlling processing of data in a distributed computer system according to claim 52, further comprising a step of an administrative user selectively granting said request to publish and publishing a defined folder or sub-folder, whereby all users may view published folders or sub-folders.

54. The method of controlling processing of data in a distributed computer system according to claim 52, further comprising a step of other users viewing any published folder or sub-folder within their personal Workspace within the tree view of their folders/sub-folders, and said other users ranking said published folders or sub-folders.

55. The method of controlling processing of data in a distributed computer system according to claim 31, further comprising a step of a user selectively exporting one or more defined folders, sub-folders, or selected data entries within their Workspace , whereby a copy of said folders, sub-folders, or data entries become operational in another user'"'"'s Workspace, said copy including the associated Folder Templates, DEFs and, optionally, the data entries included in said folders and sub-folders.

56. The method of controlling processing of data in a distributed computer system according to claim 31, further comprising a step of a user selectively specifying one or more Reminders for any data entry in their Workspace.

57. The method of controlling processing of data in a distributed computer system according to claim 56, wherein said Reminders can specify a Date or a Date/Time DF used by said data entry to be used as the basis for said Reminder.

58. The method of controlling processing of data in a distributed computer system according to claim 31, further comprising a step of a user creating a new entry based on any existing entry in said workspace.

59. The method of controlling processing of data in a distributed computer system according to claim 58, wherein said step of providing a graphical user interface includes providing a consolidated display of all subsequent entries in the Workspace that were created based on an existing entry.

60. The method of controlling processing of data in a distributed computer system according to claim 59, wherein said consolidated display of all subsequent entries in the Workspace indicates the existing entry upon which said subsequent entries were based.

61. A computer program stored on computer readable media at web-enabled computer for instructing said web-enabled computer to implement a method of controlling the processing of data and communicating to a plurality of remote workstations in communication with said web-enabled computer server in accordance with the steps of:

storing a plurality of data entries in a database resident on said web-enabled computer within a workspace comprising a plurality of defined folders and sub-folders, each of said plurality of data entries comprising one or more defined Data Fields (DFs), each DF within said folders and sub-folders storing one of a plurality of different types of data;

assigning a defined Folder Template to each of said folders and sub-folders, each defined Folder Template defining a plurality of attributes of said associated folder/sub-folder including display characteristics for displaying said folders/sub-folders;

displaying said plurality of defined folders and sub-folders in a graphical user interface comprising a hierarchal tree view in a collapsible/expandable array;

selecting one of said defined folders or sub-folders using said graphical user interface;

displaying the plurality of data entries stored in the selected folder or sub-folders in said graphical user in a separate tabular view in accordance with the assigned Folder Template.

62. The computer program according to claim 61, wherein said step of storing said plurality of data entries comprises tagging each DF with a corresponding Data Field Type Indicator indicating the corresponding type of data entered in each said DF.

63. The computer program according to claim 61, wherein said plurality of attributes defined by said Folder Templates include any one or more attributes from among a group including Column Headings, Entry Title, Search Fields, Copy Fields, and Initial Values.

64. The computer program according to claim 62, wherein said plurality of pre-defined Data Field types include any from among a group including an encrypted data field for encrypted storage of an entry in the database in an encrypted fashion, a URL for storage of a URL entry in the database, a file attachment for storage of a file in the database, and an Email Reference for storage of a reference to an email address.

65. The computer program according to claim 62, wherein said plurality of pre-defined Data Field types include a web search field for archival storage of search keywords in said database and to launch a web search using said keywords.

66. The computer program according to claim 62, wherein said plurality of pre-defined Data Field types include “

Single-value Reference DF”

having a single value entry that references another data entry, and “

Multi-value Reference DF”

having one or more value entries that references multiple other data entries.

67. The computer program according to claim 61, wherein said graphical user interface comprises a search engine for keywords and phrases searching all of the contents of folders and sub-folders in said tree view.

68. The computer program according to claim 67, wherein said search engine identifies all data entries in the folders and sub-folders having data matching said keywords or search phrases, and all Single-value Reference DFs and Multi-value Reference DFs referencing said matching data entries.

69. The computer program according to claim 65, wherein folders and sub-folders in said tree view may be related either by referencing a Single-value Reference DF or Multi-value Reference DF in each of said related folders/sub-folders, and wherein adding a data entry in one Reference DF automatically updates and adds a corresponding value entry in a corresponding Reference DF in a related folder/sub-folder.

70. The computer program according to claim 61, wherein said a graphical user interface comprises a plurality of selectable columnar tabs where the selection of each columnar tab engenders a display of data entries of a corresponding folder/sub-folder using the tabular view and the Folder Template associated with said folder/sub-folder or a selected data entry displayed using the DEF associated with the folder/sub-folder that said data entry is part of

71. The computer program according to claim 61, wherein said plurality of attributes defined by said user-programmable Folder Templates include Copy Fields Next, which automatically copies predetermined DFs from a given data entry when creating a new data entry in the associated folder/sub-folder based on said data entry.

72. The computer program according to claim 71 wherein said plurality of attributes of defined by said user-programmable Folder Templates include Copy Fields Other, which automatically copies predetermined DFs from an existing data entry when creating a new data entry in a different folder/sub-folder based on said entry.

73. The computer program according to claim 61, wherein a user can create a sub-folder to a parent folder and the created sub-folder is automatically assigned the Folder Template and the DEF that are associated with the parent folder

74. The computer program according to claim 61, wherein said a graphical user interface includes a folder configuration editor for defining said user-programmable Folder Templates.

75. The computer program according to claim 61, wherein said a graphical user interface includes a Data Entry Form editor for allowing user-definition of said DEFs.

76. The computer program according to claim 75, wherein each time that a user creates a folder/sub-folder an associated DEF and a Folder Template must also be defined.

77. The computer program according to claim 61, wherein said graphical user interface tree view displays said folders and sub-folders in a collapsible/expandable and selectable tree array, each said folder/sub-folder can be selected to be displayed using the tabular view and an associated Folder Template, and said graphical user interface further comprises a Preview Pane for displaying contents of a selected data entry from said tabular view, all of said tree view, tabular view and Preview pane being concurrently displayed.

78. The computer program according to claim 62, wherein said plurality of attributes of defined by said Folder Templates include a Task Folder attribute that automatically appends a workflow of defined status Data Fields to entries in the corresponding folder/subfolder, said status Data Fields further having attributes of “

Closed” and

“

Completed”

where the first denotes a task closed for any reason and the latter denotes a task closed with a status indicating that the goals of the task were accomplished.

79. The computer program according to claim 78, wherein said user can selectively display said status Data Fields in said tabular view.

80. The computer program according to claim 79, wherein said user can selectively set a status to be assigned to said Status Data Field of any given data entries in a Task Folder.

81. The computer program according to claim 61, wherein a user may selectively allow access to any defined folder, sub-folder, selected data entries therein, or an entire Workspace by another guest user in accordance with a predefined set of permissions specifying permitted guest users, defined folders, sub-folders, or selected data entries therein to be shared with each said permitted guest user, and where said permissions include but are not limited to creating data entries, modifying existing data entries, and deleting data entries.

82. The computer program according to claim 61, wherein a user may selectively request to publish any defined folder or sub-folder.

83. The computer program according to claim 82, wherein a user may selectively issue a request to publish any defined folder or sub-folder, an administrative user may selectively grant said request and publish a defined folder or sub-folder, and all users may view published folders or sub-folders.

84. The computer program according to claim 82, wherein other users may elect to view any published folder or sub-folder within their personal Workspace within the tree view of their folders/sub-folders, and said other users may rank said published folders or sub-folders.

85. The computer program according to claim 81, wherein a user may selectively export one or more defined folders, sub-folders, or selected data entries within their Workspace , whereby a copy of said folders, sub-folders, or data entries are operational in another user'"'"'s Workspace, said copy including the associated Folder Templates, DEFs and, optionally, the data entries included in said folders and sub-folders.

86. The computer program according to claim 61, wherein a user may selectively specify one or more Reminders for any data entry in their Workspace.

87. The computer program according to claim 86, wherein said Reminders can specify a Date or a Date/Time DF used by said data entry to be used as the basis for said Reminder.

88. The computer program according to claim 61, whereby a user can create a new entry based on any existing entry in said Workspace.

89. The computer program according to claim 88, wherein said a graphical user interface includes a consolidated display of all subsequent entries in the Workspace that were created based on an existing entry.

90. The computer program according to claim 89, wherein said consolidated display of all subsequent entries in the Workspace indicates the existing entry upon which said subsequent entries were based.