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.