Trendium, Inc.

Nettraffic, Inc.

Lin Yu

Sameh Yamany

Henry Scanzano

Jianrong Hong

Alaaeldin A Aly

Database systems, methods and/or computer program products provide for multiple but exclusive relationships between tables in a relational database. The multiple but exclusive relationship may be enforced based on a type associated with a record in a relating table. The multiple but exclusive relationship may be a one-to-many or a many-to-many relationship. A foreign key value of a record in a relating table may be selectively associated with a specific one of a plurality of related tables based on at least one attribute of the record containing the foreign key in the relating table. In particular embodiments of the present invention, the foreign key values of a record in the relating table are selectively associated with one of the plurality of related tables by defining a foreign key of records of the relating table and defining a plurality of types of foreign key associations, each of the types corresponding to a respective one of the plurality of related tables. One of the related tables having a type corresponding to a type value associated with a record of the relating table is selected and a record in the selected related table identified based on a foreign key value of the foreign key of the record in the relating table.

Database systems, methods and computer program products using type based selective foreign key association to represent multiple but exclusive relationships in relational databases

Systems, methods and computer program products for storing data from multiple clients in a database include a Multi-thread Shared Memory message Queue Buffer (MSMQB) that includes multiple First-In First-Out (FIFO) queues, a respective one of which is associated with a respective one of the clients. The MSMQB is configured to store sequential bursts of data records that are received from the clients in the associated FIFO queues. A Semi-Merge Sort Module (SMSM) is configured to sort the sequential bursts in the FIFO queues based on the primary key of at least one selected record but not every record, to produce a semi-sorted record stream for serially stored in the database.

Saving burst data by using semi-merge sorting module

Database systems, methods and/or computer program products that include a database management system and a database having partitioned tables. The partitioned tables include at least two entity tables and a relationship table where the relationship table has a child-to-parent relationship to each of the entity tables. Keys and indices are defined for the entity tables and the relationship table so that the database management system maintains referential integrity between the relationship table and the entity tables to thereby enforce the child-parent relationship. The keys and indices include a primary key which includes one or more columns of a corresponding entity table. The columns of the primary key, however, does not include columns which are used only for partitioning the entity table. A super key includes the columns of the primary key of a corresponding entity table and one or more columns of the entity table which are used only for partitioning the entity table A super key index of the corresponding entity table is based on the super key. Foreign keys are defined for the relationship table corresponding to the primary keys of the entity tables which are related by the relationship table.

Growing community of inventors

Fort Lauderdale, FL, United States of America

Lin Yu