Abstract: A subscriber management system includes at least one Data Directory Server (DDS) located between one or more transaction generators and one or more data servers. The DDS efficiently routes transactions and provides data location functions. The DDS provides high data availability, high on-line transaction rates, batch capabilities, scalability and maintainability. In particular, based upon internal rules within the DDS and the particular transaction type, the DDS routes transactions to the appropriate server(s). Transactions are classified according to where they may be executed. Specifically, transactions may be classified as SPECIFIC, ANY or ALL. A SPECIFIC transaction must be processed at one or more specific servers irrespective of the accompanying arguments. An ANY transaction may be processed at any of the enterprise servers and selection is made randomly. Finally, an ALL transaction requires sequencing through each of the data servers within the enterprise and repetitively performing the transaction.

Abstract: A system and method for ensuring the security and integrity of applications and databases. The present invention provides a user management system which allows permissive access to applications and stored procedures using a directed acyclic graph structure which allows users or groups of users to have the capability to access the desired applications and stored procedures. Also provided is a version control management system which ensures a user is using the desired or current version of an application and also provides a framework for a developer to develop an application and install it on the system.

Abstract: A bill editor, generator, messaging and insert system and method comprises a portion of a bill production processor designed to create monthly billing statements which are sent to customers and which detail charges incurred over the course of a billing cycle. The bill editor and generator allows billing personnel to design a bill using static text, dynamic text and paragraph areas. Once the report/bill is defined, the report definition is stored in temporary memory for later use. The report definition file defines how the report is to appear and where the data used in the report is stored. The report generator, when subsequently run, uses the predefined report definition to retrieve data from the database and generates the report as defined by the report definition file. The bill messaging and insert system determines, based on assigned priority, criteria and weight and space limitations, the messages and notices to be included in a customer billing statement.

Abstract: A system for accessing data distributed on databases in an integrated computer system includes a distributed data port, which initiates a XRef server query, generates a virtual table having a first result set including at least one data row responsive to the XRef server query, initiates Populate queries each having one of the data rows as an argument, and updates the virtual table with data responsive to the Populate queries. The system also includes a XRef server, which receives the XRef server query from the distributed data port and identifies at least one of the databases having a data row responsive to the XRef server query. A temporary virtual table relays each Populate query to a data directory server, and the data directory server is linked to each of the databases.