Abstract: Utilizing change data capture methodology, a computer facilitated historical data warehousing system accepts transactional/operational data having no directly tied dates from a legacy source system and processes that data into a subject-oriented format that is optimized for analytical and query reports via a two step process comprised of pre-processing and transforming. The pre-processing step entails a serial modification of data with only the last modification being recorded. The transforming step involves linking related data by utilizing reusable primary keys and dates obtained from an RDBMS in an operation system of the legacy source system that supplied the transactional/operational data.

Abstract: Telecommunications apparatus and method for detecting any unusual activity in customer behavior. A comprehensive behavior profile of a customer is generated on the basis of customer transactions. The profile includes a short-term customer behavior obtained from all of the customer's transactions, and further includes a long-term customer behavior obtained on the basis of the generated short-term behavior. Any behavior deviation from the profile is detected and identified as fraudulent or unusual.

Abstract: Method and apparatus for database management among linked computers are disclosed. Generally, data elements are selected and retrieved from databases in one or more linked database computers and placed into memory of a linked access computer. Inputs to the access computer are used to generate proposed changes to one or more of the retrieved data elements. Proposed changes are committed to corresponding database elements in the one or more linked database computers. Database elements so manipulated may be sub-elements of objects, objects, or classes of objects.

Abstract: In the present invention, a database structure is defined such that a database table having a plurality of objects each having an associated data is formed. A second table containing the relationship of one of the objects to another of the objects in a parent-child relationship is formed. A summary database table receives the data from the second database table and summarizes the data therefrom. By separating the relationship from the underlying data, and with the definition of each parent and child, execution of retrieval of information from the database structure is extremely efficient and fast.

Abstract: A method and system is provided for distributing and reusing object identifiers in a distributed database system. A first table of object identifiers created by the database is maintained for supplying unallocated object identifiers for each type. A second table of object identifiers is also maintained containing reusable and distributable object identifiers to one or more application server in the database system. The application server obtains a predetermined number of object identifiers from the first and second tables to be stored in each of the application servers for servicing client applications related to the application server.

Abstract: An event database table architecture includes an event table having information such as, for example, date, time, and activity. An event table has a field for identifying one of a plurality of participating tables, and a field for identifying a row within the identified participating table. A participant table has a field for identifying one of a plurality of participating tables, a second field for identifying a row within the identified participating table, a role code, and a row number identifying the event in the event table. Thus, each entry in the participant table relates to a unitary entry in the event table and also relates to a unitary row in one of the participating tables. Each event, participant, and act of participating can be accessed from any other related data item without accessing extraneous or unrelated data items.

Abstract: Telecommunications apparatus and method for detecting any unusual activity in customer behavior. A comprehensive behavior profile of a customer is generated on the basis of customer transactions. The profile includes a short-term customer behavior obtained from all of the customer's transactions, and further includes a long-term customer behavior obtained on the basis of the generated short-term behavior. Any behavior deviation from the profile is detected and identified as fraudulent or unusual.