Enterprises in a collaborative supply chain share information for quick and intelligent decision making. Collaborative Planning, Forecasting and Replenishment (CPFR), a business model developed by an organization called Voluntary Inter-industry Commerce Standards, defines a set of business processes to collaborate on planning, forecasting and replenishment activities to arrive at a common order. This involves sharing sales forecast, order forecast and promotion information among business partners. The Internet has paved the way for using Web Services to share this information as XML data in real time and to make it available across enterprises. Enterprises need to access this information and integrate it with the information available in their databases, Excel sheets and XML applications. This thesis discusses the development of an information architecture using XQuery (a declarative query language by W3C) for aggregating data from disparate data, and evaluates XQuery as a tool to enable information integration for supply chain collaboration. For this purpose, several CPFR scenarios are identified where two retailers share their sales forecast, order forecast and promotion forecast information with the manufacturer. A prototype application is developed which can fetch data from disparate data sources such as Web Service, XML databases and CSV files, aggregate it, and use it to identify exceptions in forecasts and calculate the key performance indicators (KPI). These KPIs are then presented as an executive dashboard using Visual FoxPro. This Dashboard presents information graphically and enables executives to track the performance of the supply chain, and hence enables them to make quick and intelligent decisions.
Library of Congress Subject Headings
Business logistics--Data processing
Department, Program, or Center
Industrial and Systems Engineering (KGCOE)
Govindasamy, Bharani, "A supply chain collaboration solution using XQuery" (2006). Thesis. Rochester Institute of Technology. Accessed from
RIT – Main Campus