Abstract: For a data processing system having memory for storing a database, a method, a system and a computer program product for directing the data processing system to process a record to be inserted into the database is disclosed. The database includes a plurality of base tables.

Abstract: Architecture that provides a data profile computation technique which employs key profile computation and data pattern profile computation. Key profile computation in a data table includes both exact keys as well as approximate keys, and is based on key strengths. A key strength of 100% is an exact key, and any other percentage in an approximate key. The key strength is estimated based on the number of table rows that have duplicated attribute values. Only column sets that exceed a threshold value are returned. Pattern profiling identifies a small set of regular expression patterns which best describe the patterns within a given set of attribute values. Pattern profiling includes three phases: a first phases for determining token regular expressions, a second phase for determining candidate regular expressions, and a third phase for identifying the best regular expressions of the candidates that match the attribute values.

Abstract: A method for recognizing LMI type automatically by a DTE includes: while communicating with a DCE for a first time or when a LMI protocol type at the DCE is changed during a communication process, the DTE generating different status enquiry messages with the frame formats of all LMI protocol types supported by the DTE, and sending the different status enquiry messages to the DCE simultaneously; after receiving the first status response message from the DCE, the DTE recognizing and recording LMI protocol type of the current response message, and then communicating with the DCE through the messages generated with the frame format of the LMI protocol type. With this method, the DTE can automatically recognize and match the LMI protocol type currently used at DCE. Therefore, normal communication between DTE and DCE is ensured, system reliability and stability is improved, meanwhile operation and management of the system is facilitated.

Abstract: Architecture that provides a data profile computation technique which employs key profile computation and data pattern profile computation. Key profile computation in a data table includes both exact keys as well as approximate keys, and is based on key strengths. A key strength of 100% is an exact key, and any other percentage in an approximate key. The key strength is estimated based on the number of table rows that have duplicated attribute values. Only column sets that exceed a threshold value are returned. Pattern profiling identifies a small set of regular expression patterns which best describe the patterns within a given set of attribute values. Pattern profiling includes three phases: a first phases for determining token regular expressions, a second phase for determining candidate regular expressions, and a third phase for identifying the best regular expressions of the candidates that match the attribute values.

Abstract: For a data processing system having memory for storing a database, a method, a system and a computer program product for directing the data processing system to process a record to be inserted into the database is disclosed. The database includes a plurality of base tables.

Abstract: For a data processing system having memory for storing a database, a method, a system and a computer program product for directing the data processing system to process a record to be inserted into the database is disclosed. The database includes a plurality of base tables.

Abstract: For a data processing system having memory for storing a database, a method, a system and a computer program product for directing the data processing system to process a record to be inserted into the database is disclosed. The database includes a plurality of base tables.

Abstract: A method and system for facilitating the offering, marketing and sale of one or more products and services which receives at least one identifier of a first product associated with a first vendor; receives preference data associated with said at least one identifier from at least one consumer; presents data related to said at least one identifier to at least one additional vendor; receives at least one message related to said at least one identifier from said a first vendor or said at least one additional vendor, and responds to said at least one consumer according to said at least one identifier using said at least one message.

Abstract: Systems and methodologies for computation of multiple group by queries via an optimizer that examines the space of plans in a systematic and cost based manner. The optimizer includes a merging component to merge pairs of sub plans to facilitate a plan choice with a lowest cost. The merging component can take as input two sub plans (e.g., sub plan P1 with root node V1 and sub plan P2 with root node V2, wherein each sub plan is a sub-tree of a logical plan whose root node is directly pointed to a Relation “R”), to return a set of sub-plans as out put with a root node V1?V2 that is the smallest relation from which both V1 and V2 can be computed.

Abstract: A method and computer-readable medium for analyzing a set of two or more data ranges comprising the steps of selecting a first data range from the set, selecting at least one additional data range from the set, analyzing the relationship between the first data range and the at least one additional data range and ranking the first data range and at least one additional data range. In one aspect of the invention, a representative data range and an optimal data point are generated based on the ranking of the first data range and the at least one additional data range.

Abstract: A method and an apparatus for gathering and analyzing consumer preference is disclosed. The method includes steps of providing offers; collecting consumer preference for the offers and analyzing the consumer preference by ranking the preference and applying pre-defined policy functions to obtain the most preferable specification with respect to the consumer preference; proposing new offers or updating offers according to the analysis result if appropriate and contacting relevant consumers; or collecting preference for the new offers, or updated offers.

Abstract: For a data processing system having memory for storing a database, a method, a system and a computer program product for directing the data processing system to process a record to be inserted into the database is disclosed. The database includes a plurality of base tables.

Abstract: The present invention discloses a method for recognizing Local Management Interface (LMI) type automatically by a Data Terminal Equipment (DTE), comprising: while sending the first status enquiry message to a Data Circuit Equipment (DCE), the DTE generating different status enquiry messages with the frame formats of all LMI protocol types supported by the DTE, and then sending said different status enquiry messages to the DCE simultaneously; after receiving the first status response message from the DCE, the DTE recognizing and recording LMI protocol type of the current response message, and then communicating with the DCE through the messages generated with the frame format of said LMI protocol type. With this method, the DTE can automatically recognize and match the LMI protocol type currently used at DCE. Therefore, normal communication between DTE and DCE is ensured, system reliability and stability is improved, meanwhile operation and management of the system is facilitated.