Abstract: The present invention relates to a system and methodology for modeling subscription information and/or subscriber information as data. An interface provides for developers of subscription applications to enter subscription queries and subscriber information. The interface includes an application definition file (ADF) by which the developers can specify subscription application specific information; and an execution engine that processes the ADF by reading contents thereof and building application specific databases from schema information corresponding to the processed ADF.

Abstract: A computer implemented method for generating a response to a join. Two tables are divided into fragments. A join fragment map identifies, for each respective fragment from the first table, the fragments from the second table which contain a record that satisfies the join predicate with a record from the respective fragment from the first table. The map is used to eliminate fragments which cannot satisfy the join predicate.

Abstract: Generalized key indexes enable a first table of a relational database to be indexed using an index key and index conditions, wherein either or both of the index key and index conditions may reference multiple tables of the database or may be an expression using fields of one or more tables other than the first table. The generalized key indexes directly associate generalized index key values with record identifiers of records of the first table, thus enabling efficient storage and data retrieval.