System and method for collaborative data sharing and analysis
First Claim
Patent Images
1. A database comprising:
- a reports table maintaining a reportID field;
a files table maintaining a fileID field;
a users table;
a folders table maintaining a folderID field, wherein said folders table is self-referential;
a parentgroups table maintaining a groupID field and a parent groupID field;
a groups table; and
a permissions table maintaining permissions associated with each said folder in said folders table;
wherein said folders table is related to said files table, said reports table, said users table, said groups table, and said permissions table by said folder ID field.
0 Assignments
0 Petitions
Accused Products
Abstract
A collaborative data sharing and analysis system comprises a primary database utilizing a plurality of tables, and a user client that provides an interface that displays a retail and supplier data perspective. The primary database utilizes a recursive load function to load data recursively from the database tables so that a hierarchical organization of the data is presented via the interface. Once the data has been loaded, the user interface allows a user to manipulate the stored data according to one or more permissions, thus allowing a retailer and a supplier to collaborate with each other in real-time.
62 Citations
18 Claims
-
1. A database comprising:
-
a reports table maintaining a reportID field; a files table maintaining a fileID field; a users table; a folders table maintaining a folderID field, wherein said folders table is self-referential; a parentgroups table maintaining a groupID field and a parent groupID field; a groups table; and a permissions table maintaining permissions associated with each said folder in said folders table; wherein said folders table is related to said files table, said reports table, said users table, said groups table, and said permissions table by said folder ID field. - View Dependent Claims (2, 3)
-
-
4. A method for organizing data retrieved from a database for presentation as a user interface for user interaction comprising:
-
loading a group associated with a user, wherein said user group has at least one parent subfolder and at least one child subfolder which are also loaded; loading a group root folder associated with said user group, and loading any user group subfolders contained therein; and loading a user root folder associated with the user, and loading any user group subfolders contained therein. - View Dependent Claims (5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A computer-readable medium having computer-executable instructions for performing a method comprising:
creating a database structure comprising; a reports table to store one or more reports; a files table to store one or more files; a users table to identify individual users; a folders table to identify where each said report and said file is located, wherein said folders table is self-referential; a parentgroups table; a groups table; and a permissions table, wherein said folders table is related to said files table, said reports table, said users table, said groups table, and said permissions table, and wherein said users table is related to said reports table, said files table, said folders table, and said permissions table, and wherein said groups table is related to said parentgroups table, said users table, and said permissions table; loading a user-client on a computer, said-user client providing an interactive interface to a user; executing a recursive load function to organize the folders and subfolders of said database in a hierarchical manner, said recursive load function also loading the contents of each said folder; and displaying said hierarchically organized folders via said user client, such that the user of said user client is able to navigate said folders with an input device. - View Dependent Claims (17)
-
18. A database comprising:
-
a first table maintaining a first username field, said first table being self-referential; a second table maintaining a second username field, and first groupID field; a third table maintaining a second groupID field; wherein said first and said second tables are related to each other by said first and second username fields, and said second and third tables are related to each other by said first and second group ID fields.
-
Specification