Browse Prior Art Database

DYNAMIC DATABASE

IP.com Disclosure Number: IPCOM000040196D
Original Publication Date: 1987-Oct-01
Included in the Prior Art Database: 2005-Feb-02
Document File: 4 page(s) / 48K

Publishing Venue

IBM

Related People

Caraballo, JF: AUTHOR [+5]

Abstract

This article describes a dynamic database to manage data flow throughout an automatic packaging and palletizing system (APPS) wherein data needs to be accessed at a high rate of speed due to the high throughput of the system. Control of the line is decentralized, thereby allowing certain parts of the system to continue operating during a failure. The failure of one controller does not shut down the entire line. (Image Omitted) The personal computer (PC) APPS is a serial process whereby a PC is prepped, packaged and then palletized. The entire operation is under the supervision of a cluster of PCs that control and monitor the entire operation, as illustrated in Fig. 1. The line is partitioned into six zones with one personal computer overseeing each zone, as shown in Fig. 2.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 41% of the total text.

Page 1 of 4

DYNAMIC DATABASE

This article describes a dynamic database to manage data flow throughout an automatic packaging and palletizing system (APPS) wherein data needs to be accessed at a high rate of speed due to the high throughput of the system. Control of the line is decentralized, thereby allowing certain parts of the system to continue operating during a failure. The failure of one controller does not shut down the entire line.

(Image Omitted)

The personal computer (PC) APPS is a serial process whereby a PC is prepped, packaged and then palletized. The entire operation is under the supervision of a cluster of PCs that control and monitor the entire operation, as illustrated in Fig. 1. The line is partitioned into six zones with one personal computer overseeing each zone, as shown in Fig. 2. This distributed organization allows computers that have passed a failure point to continue. In a centralized control environment a system failure would shutdown the entire operation. The so-called database for this operation is composed of PC/box records which are created every time a computer enters the packaging area. This is accomplished by using three sources to generate the required records as follows: 1 - The kitting database which contains the item number for each serial number/machine type.

(Image Omitted)

2 - The data record in the APPS area

controller that tags the publications and the title

that is printed on the outside of the box to an item

number. 3 - The serial number/machine type that is read from the

bar code on the product itself. A detailed description of how the PC/box record is created, used and transferred from controller to controller is set forth below. Prior to the computer entering the depalletizing station within Zone l, the serial number/machine type is read by a bar code reader. This information that is received by Zone 1 is then relayed through the APPS area controller to the kitting database. The kitting database uses the serial number/machine type to determine the model of the computer (item number). After this occurs, the data is then sent back to the APPS area controller which then uses the item number to determine what publication will go inside of the box and what title will be printed on the outside of the box. At this point all the information is grouped together to form a PC record.

(Image Omitted)

1

Page 2 of 4

Example:

PC Record:

- Serial Number

- Item Number (type of machine)

- Publication #1

- Publication #2

- Advertising title printed on outside of box This record is then sent by the APPS area controller to Zone 1. The computer, in the meantime, is automatically tested to verify removal of the diagnostic test plug and the installation of the power cord. The computer will be rejected if either test fails. Zone 1 will then release the computer from the test area to the depalletizer upon receiving the PC record from the APPS area controller. If for some reason the computer could not be identified by the...