McGraw-Hill - Delivering Business Intelligence with Microsoft SQL Server 2008 (2009)02

McGraw-Hill - Delivering Business Intelligence with Microsoft SQL Server 2008 (2009)02 | 22 Delivering Business Intelligence with Microsoft SQL Server 2008 Manufacturing Automation The manufacturing automation system tracks the materials used to make each product. It also stores which products are manufactured on which production lines. Finally this system tracks the number of items manufactured during each shift. The manufacturing automation system uses a proprietary data-storage format. Data can be exported from the manufacturing automation system to a comma-delimited text file. This text file serves as the source for loading the manufacturing data into the business intelligence systems. Order Processing The order processing system manages the inventory amounts for all products. It tracks wholesale orders placed by non-Max Min retailers. The system also records product amounts sold through the Max Min retail stores and the Max Min online store to maintain inventory amounts. The order processing system tracks order fulfillment including product shipping. It also generates invoices and handles the payment of those invoices. In addition this system records any products returned from the retailer. The order processing system uses a Microsoft SQL Server database as its backend. Point of Sale The point of sale POS system manages the cash registers at each of the five Max Min-owned retail stores. This system also tracks the inventory at each retail store using Universal Product Code UPC barcode stickers placed on each item. The POS system handles both cash and credit card transactions. It also tracks information on any products returned by the customer. Information from each of the five POS systems is exported to an XML file. This XML file is transferred nightly using File Transfer Protocol FTP to a central location. These XML files serve as the source for loading the POS data into the business intelligence systems. The online store is an application. It uses SQL Server as its backend database. All sales through the online .

Không thể tạo bản xem trước, hãy bấm tải xuống
TỪ KHÓA LIÊN QUAN
TÀI LIỆU MỚI ĐĂNG
247    53    6    29-03-2024
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.