Abstract: An illumination device used to replace fluorescent light tubes. The illumination device comprises an LED light strip, a diffusion tube surrounding the LED light strip, and an end cap mounted on each end of the tube. Electrical connectors integrated with the end caps and make electrical connection with the LED light strip. The device may be hermetically sealed, use LED's to rectify the current, have a filament simulator with or without a visual indicator, two-sided or multi-sided light strips, light diffusing end caps and be filled with a life-extending gas. The illumination device results in an LED light tube with improved lighting uniformity, reduced energy consumption, improved ease of use and longer operating life.

Abstract: A system, method, apparatus, and computer program code for aggregating and maintaining data in a system having at least a first and a second platform generating data includes receiving initial data from the first and the second platforms. A staging table is generated based on the initial data, and the standardized data is associated with the initial data. In one embodiment, the association is performed by establishing one or more cross-reference tables.