Patent ID: 7650346

Claim:
A system that checks consistency of data values comprising a computer processor for executing the following software components, the system comprising the following computer executable components: a first component that receives incoming data values, wherein the incoming data values are received from at least one of a remote procedure call, conversion from a disparate type, a distributed query and a database consistency checking tool, and a type definition that is persisted in a metadata catalog, wherein the type definition defines declared types of the incoming data values; a second component that generates a type-specific state machine based at least in part on the received type definition such that input streams of data are continuously monitored and scanned thereby determining if the input data is a user-defined type (UDT) and upon identification of an embedded UDT value in an input data stream, the second component suspends and saves the state machine; and a third component that uses generated intermediate code to check the consistency of the embedded UDT value with its declared type based at least on the type definition as determined from the metadata before the system proceeds such that consistency check occurs using a memory space that is proportional to the number of levels in the embedded UDT and without making a contiguous copy of the UDT value.