US20020062315A1 - Agent-based data mining and warehousing - Google Patents
Agent-based data mining and warehousing Download PDFInfo
- Publication number
- US20020062315A1 US20020062315A1 US09/241,304 US24130499A US2002062315A1 US 20020062315 A1 US20020062315 A1 US 20020062315A1 US 24130499 A US24130499 A US 24130499A US 2002062315 A1 US2002062315 A1 US 2002062315A1
- Authority
- US
- United States
- Prior art keywords
- agent
- agents
- based system
- databases
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99944—Object-oriented database structure
- Y10S707/99945—Object-oriented database structure processing
Definitions
- This invention relates to data storage and retrieval and more particularly to an agent-based networking system for creating a data warehouse and to a method of accessing the same for real time retrieval of application specific data.
- the typical approach to data mining is to start with data warehousing, that is, with creating an inventory of data, the data warehouse, and removing ambiguous information.
- the creation of a data warehouse is concerned with schemes and methods of integrating legacy databases so that they can be accessed in a uniform and manageable framework. This involves data storage, data selection, data cleaning and an infrastructure for updating databases once new knowledge or representations are developed.
- the data warehouse is then used to extract knowledge about hidden relationships in the data (data mining).
- data mining can only be performed after the warehouse has been created, a process which can take up to several years.
- the reasons that data warehousing is so time-consuming are ambiguity and distribution.
- Management of multiple databases on an organization-wide basis is commonly performed by a network management system.
- an agent may be located in a workstation or other management device to collect information locally and provide that information to requesting devices when required.
- the present invention relies on a network of agents to access data in distributed databases and provide to a network management device near real-time application specific information.
- an agent-based system for creating and accessing a data warehouse comprising:
- a user agent connected to the network for initiating an application specific request for data
- a plurality of resource agents each associated with one of the distributed databases, for receiving and storing goals from the functional agents and obtaining application specific data from appropriate databases for use by the user agent.
- FIG. 1 is a flow diagram of one implementation of the present invention
- FIG. 2 is a high level block diagram of a specific physical embodiment of the invention.
- FIG. 3 illustrates the internal structure of an agent
- FIG. 4 is a diagram of the information flow resulting from a set of similar database entries, i.e. similar names.
- the invention is based on four key components:
- agents managing the workflows for the storage, selection, cleaning, updating and extracting of data and controlling the work of other agents
- process agents are referred to as functional agents, devices as resources, device agents as resource agents, and device group agents as abstract resource agents.
- Distribution is handled by mirroring the physical distribution of data in the organization in a network of agents, comprising functional agents that execute the workflows required for the storage, selection, cleaning and an updating of data; user agents to represent the human workers that initiate and participate in the workflow; and resource agents that interact with the databases through the database-specific Application Programming Interfaces (APIs) and may also enhance the functionality of the database.
- APIs Application Programming Interfaces
- Ambiguity is handled by employing multiple strategies in one agent for identifying and resolving ambiguities. These are strategies such as “compare names for similar spelling”, “cluster persons with the same address” for the identification of ambiguities and strategies such as “if two people have similar spelling and the same address they are very likely identical” for the resolution of ambiguities.
- the strategies for identifying and resolving ambiguities are executed in knowledge sources which communicate using a blackboard system.
- Blackboard systems and the concept of knowledge sources have been described by Corkill in AI Expert, 41-47 September 1991, and by H. P. Nii “Blackboard Systems: The Blackboard Model of Problem Solving and the Evolution of Blackboard Architectures” 1986.
- the agents interact with the following resources:
- This scenario shows the interactions between the agents and/or the resources involved in verifying the identity of a client, as shown in FIG. 1.
- the ISSUE CREDIT CARD FUNCTIONAL AGENT issues the goals “verifyClientIdentity: aClientApplication” and “checkCreditHistory: aClientApplication”.
- goals are specified by a keyword that identifies the goal (for example, “verifyClientIdentity:”) and a set of associated parameters (“aClientApplication”). Multiple parameters are separated by further keywords as in the goal “performSearchFor: aKey withSearchParams: params”.
- the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT Upon receiving a goal an agent then uses it to lookup the appropriate process by which it can satisfy the goal. For example, the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT first sends a goal to find existing information on the client to the CLIENT DATABASE ABSTRACT RESOURCE AGENT. If multiple database entries related to the client can be found, but the agent cannot identify the ambiguities given its current strategies, the CLIENT IDENTITY FUNCTIONAL AGENT sends a goal to the OPERATOR USER AGENT to ask the human Operator for help.
- an agent that requires services from another agent or a resource to accomplish its goals needs usage rights over that agent or resource.
- the direction of the arrows in FIG. 1 indicates both the primary flow of the control through the application as well as the usage rights.
- a usage right defines which operations an agent may perform on another together with capacity and quality of service constraints.
- Usage rights may be distributed in accordance with the priorities of the organization. In this case, the priority would equate to which data mining tasks are more important than others.
- the Issue credit officer enters information on a credit card applicant into a terminal where it is received by the ISSUE CREDIT OFFICER USER AGENT.
- the ISSUE CREDIT OFFICER USER AGENT asks the ISSUE CREDIT CARD FUNCTIONAL AGENT to issue a client card for the client application.
- the record of the client application (aClientApplication) is passed as a parameter.
- the ISSUE CREDIT CARD FUNCTIONAL AGENT orders the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT to verify the client identity for the client application (aClientApplication).
- the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT queries the CREDIT DATABASE ABSTRACT RESOURCE AGENT to find relevant information for the client application (aClientApplication).
- the CREDIT DATABASE ABSTRACT RESOURCE AGENT performs a fuzzy search on each database that holds information about keys (aKey) in the client application.
- the fuzzy search retrieves similar entries from the database. Similarity is defined by an appropriate distance measure. For example, the names “Mankovski”, “Mankovskii” and “Mankowski” would be considered similar, because they can be derived from each other through simple permutations.
- One way of performing the fuzzy search is to translate the original query into a number of queries for different permutations on a search key such as the name. Another is to retrieve a range of subsequent database entries and computing relative distances.
- the fuzzy search is used by one of the strategies employed by the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT to find ambiguities.
- Each database resource agent performs a search for each requested key (aKey) using the specified search parameters (params) and returns the result to the CREDIT DATABASE ABSTRACT RESOURCE AGENT.
- the fuzzy search might involve multiple requests to the database resource agent.
- the CREDIT DATABASE ABSTRACT RESOURCE AGENT consolidates the information retrieved from its database resource agents a list of database entries that match the query to the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT.
- the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT uses its strategy to find ambiguities in the information returned by the CREDIT DATABASE ABSTRACT RESOURCE AGENT. Examples of strategies are to look for apparent misspellings, for previous, failed credit applications by the client, or for records on credits applied for by the client's spouse.
- the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT resolves ambiguities identified in the previous step. This may include interaction with a human operator, if the agent could not resolve an ambiguity with sufficient certainty. In this case it asks the Operator to verify the information.
- the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT consolidates the verified information and, if there is any evidence of the client already being in the database, returns it to the ISSUE CREDIT CARD FUNCTIONAL AGENT.
- the Credit identify verification workflow can continue, for example, with checking the client's credit history.
- the ISSUE CREDIT CARD FUNCTIONAL AGENT proceeds by sending a goal to the CREDIT BUREAU FUNCTIONAL AGENT to check the credit history of the client. The remainder of that workflow is not shown.
- FIG. 2 shows a specific physical embodiment of the invention.
- the system components are connected by a LAN.
- the computers PC 1 and PC 2 are connected to the LAN.
- PC 1 is used to enter client information and to trigger a client identify verification.
- PC 2 is used to interact with the Operator when the application requires the Operator's intervention.
- the computers Host 1 to Host 7 are also connected to the LAN.
- the agents and database resources run in programs on these computers.
- Host I hosts Functional Agent 1 and Functional Agent 2 .
- Functional Agent 1 is a program that executes the logic of the ISSUE CREDIT CARD FUNCTIONAL AGENT.
- Functional Agent 2 executes the CREDIT IDENTITY VERIFICATION FUNCTIONAL AGENT.
- Host 2 hosts the user agents for the Issue credit officer and the Operator.
- User Agent I executes the ISSUE CREDIT OFFICER USER AGENT, User Agent 2 the OPERATOR USER AGENT.
- Host 3 hosts the CREDIT BUREAU FUNCTIONAL AGENT.
- the CREDIT DATABASE ABSTRACT RESOURCE AGENT executes on host 4 .
- the database resource agents for the Paradox, Oracle and Ingres databases run on hosts 5 , 6 and 7 , on the same hosts as the actual databases.
- FIG. 3 shows the internal structure of an agent.
- each agent has a head-body architecture found in many agent-based systems.
- a head-body agent has two subsystems: a control subsystem (head) and an action subsystem (body).
- the head processes external goals, which have been sent by other agents, as well as internal goals, which result from the decomposition of an external goal, or to internal triggers generated in the body.
- the body interacts with external resources and provides the mechanisms for sending goals to other agents. Head and body communicate through a common blackboard.
- the head comprises a goal resolution area, and a set of process and strategy knowledge sources (KS).
- the goal resolution area receives incoming goals and posts them to the appropriate process KS.
- Each process KS implements a workflow or subworkflow. It operates by decomposing goals into subgoals and tasks. For further details refer to aforementioned U.S. Pat. No. 5,638,494. Subgoals are posted back to the goal resolution area, and tasks are processed by knowledge sources in the body. Each subgoal is then posted to another process KS or a strategy KS.
- the process KS for handling “verify the client identity” service requests activates the “similar names” strategy by posting a subgoal to it upon receiving such a service request.
- a process KS can post data to the blackboard and read hypotheses from the blackboard, which were posted by a strategy KS. This is another way process and strategy KSs communicate.
- Each strategy KS implements a strategy for detecting and resolving ambiguities in the data posted to the blackboard by a knowledge source in the body. It employs a mixture of algorithms (for example, for computing the similarity between two database entries), and if-then rules, as they are found in expert systems, and produces hypotheses which are posted to the blackboard where they become visible to process KSs and other strategy KSs. During its execution, a strategy KS also reads data from the blackboard previously posted by a process KS.
- the “similar names” strategy KS would post a hypothesis that different database entries actually represent the same client. This hypothesis would then trigger if-then else rules in the KS, which may result in the conclusion that the client should not be issued a card. This conclusion is again posted to the blackboard as a hypothesis. This hypothesis is then interpreted by the process KS which activated the “similar names” strategy KS as a result to the service request to verify the client identity.
- FIG. 4 shows the trace of the resulting flow of information.
- the body contains a set of agent adapter and resource adapter KSs.
- Each agent adapter KS provides a mechanism to send a goal to another agent over which this agent has a usage right. It triggers when an outgoing goal is posted to the blackboard by one of the process KSs.
- Each resource adapter KS provides an interface to an attached resource, for example, a database. It can interpret tasks posted to the blackboard and translates them into appropriate API calls on the resource. It also interprets callbacks from the resource as triggers to knowledge sources in the head. In particular the callback can be used to pass back a result to a service request (for example, a database query).
- a service request for example, a database query
- the invention can be applied to improve call center routing.
- a call center application maintains a database of customers and information on previous calls by these customers (such as a trouble-ticket number).
- information that can be used to match a caller to a human agent is limited to “hard” information such as the caller id or a trouble-ticket number. Such hard information is not always available, for example, the caller might be calling from a hotel (not from his home) phone.
- the name of the customer is already a piece of “soft” information, because of the different ways a name could be entered by the attendant taking the call when it first arrives at the call center. In the described scenario of a caller calling from a hotel phone, other information must be taken into account to route the call.
- One application of the invention would be to ask the caller a series of questions (name, trouble ticket number, contact, etc.), making use of speech recognition or based on the information entered by the attendant, to identify whether the caller has called the center before, whether it is an important customer etc. so as to allow routing to the appropriate human agent.
Abstract
Description
- This invention relates to data storage and retrieval and more particularly to an agent-based networking system for creating a data warehouse and to a method of accessing the same for real time retrieval of application specific data.
- The typical approach to data mining is to start with data warehousing, that is, with creating an inventory of data, the data warehouse, and removing ambiguous information. The creation of a data warehouse is concerned with schemes and methods of integrating legacy databases so that they can be accessed in a uniform and manageable framework. This involves data storage, data selection, data cleaning and an infrastructure for updating databases once new knowledge or representations are developed.
- The data warehouse is then used to extract knowledge about hidden relationships in the data (data mining). The problem with this approach is that data mining can only be performed after the warehouse has been created, a process which can take up to several years. The reasons that data warehousing is so time-consuming are ambiguity and distribution.
- The ambiguity results from differences in the query languages and data formats of different databases, and may also be inherent in the information, for example, misspelling of names, or different names for the same street. This becomes all the more significant as the number of data sources proliferates. Consider, for example, the information reaching a television set as a stream of signals that need to be cataloged, indexed, and perhaps searched for interesting content at a higher level such as channel, programs, genre, or mood. Or consider the information that could be tracked about callers into a call center (for example, names, company, product or service they are calling about).
- Distribution as in the way an organization's data is spread across multiple databases creates a situation where it is difficult to obtain an organization-wide view on the data. Many relationships between the data which are crucial to organizational decision-making remain unknown or incomprehensible. To derive them it is necessary to integrate the data from various databases.
- Management of multiple databases on an organization-wide basis is commonly performed by a network management system. Within a network management system an agent may be located in a workstation or other management device to collect information locally and provide that information to requesting devices when required.
- The present invention relies on a network of agents to access data in distributed databases and provide to a network management device near real-time application specific information.
- According to a first aspect of the present invention there is provided an agent-based system for creating and accessing a data warehouse comprising:
- a network of interconnected distributed databases;
- a user agent connected to the network for initiating an application specific request for data;
- a plurality of functional agents for receiving goals from the user agent and for invoking processes for completing the goals; and
- a plurality of resource agents, each associated with one of the distributed databases, for receiving and storing goals from the functional agents and obtaining application specific data from appropriate databases for use by the user agent.
- According to a second aspect of the invention there is provided a method of generating an application specific data warehouse comprising:
- providing a network of interconnected distributed databases; providing a user agent connected to the network for entering a request for application specific data;
- providing a plurality of functional agents for receiving goals from the user agent and for invoking processes for completing the goals; and
- providing a plurality of resource agents associated with the databases for receiving and storing goals from the functional agents and obtaining application specific data from appropriated databases.
- The invention will now be described in greater detail with reference to the attached drawings wherein:
- FIG. 1 is a flow diagram of one implementation of the present invention;
- FIG. 2 is a high level block diagram of a specific physical embodiment of the invention;
- FIG. 3 illustrates the internal structure of an agent; and
- FIG. 4 is a diagram of the information flow resulting from a set of similar database entries, i.e. similar names.
- The invention is based on four key components:
- distributed data integration by a network of functional agents that process goals and resource agents that communicate with databases;
- agents pursuing different strategies for identifying and resolving data ambiguities (conflicts between data items) in multiple databases;
- encapsulation of database-specific APIs and extension of the functionality of databases through agents; and
- agents managing the workflows for the storage, selection, cleaning, updating and extracting of data and controlling the work of other agents
- The concept of agents used is that described in U.S. Pat. No. 5,638,494 which issued Jun. 10, 1997 to Pinard et al and assigned to the assignee of the present application. Reference should be made to the subject US Patent for greater details concerning agent based networking. The patent describes a method of operating a communication system that contains multiple functional agents for receiving goals and for invoking a process to achieve the goals, and multiple resource agents, each communicating with its own resource, for receiving and storing goals from a functional agent, and for operating its corresponding resource in response to receiving the goals from a functional agent. The agents are interconnected into a network of agents which provides the infrastructure for passing goals between the agents.
- The terminology used in the present application differs slightly from terminology used in the U.S. Pat. No. 5,638,494. In this application, process agents are referred to as functional agents, devices as resources, device agents as resource agents, and device group agents as abstract resource agents.
- As stated above, data mining currently can only be performed after the warehouse is created, a time-consuming process. In an agent-based approach to data mining, required portions of the data warehouse can be created on demand, and can be used for data mining immediately. The agent approach allows this because it deals with distribution and ambiguity as follows.
- Distribution is handled by mirroring the physical distribution of data in the organization in a network of agents, comprising functional agents that execute the workflows required for the storage, selection, cleaning and an updating of data; user agents to represent the human workers that initiate and participate in the workflow; and resource agents that interact with the databases through the database-specific Application Programming Interfaces (APIs) and may also enhance the functionality of the database.
- Ambiguity is handled by employing multiple strategies in one agent for identifying and resolving ambiguities. These are strategies such as “compare names for similar spelling”, “cluster persons with the same address” for the identification of ambiguities and strategies such as “if two people have similar spelling and the same address they are very likely identical” for the resolution of ambiguities.
- The state of the art in data mining is surveyed in a special issue of IEEE Intelligent Systems (October 1996). The semantic integration of data for information retrieval in heterogeneous environments is reviewed in an article by R. Bayardo et al “Infosleuth: Semantic Integration of Information in Open and Dynamic Environments” MCC, 1997.
- In the preferred embodiment of an agent, the strategies for identifying and resolving ambiguities are executed in knowledge sources which communicate using a blackboard system. Blackboard systems and the concept of knowledge sources have been described by Corkill in AI Expert, 41-47 September 1991, and by H. P. Nii “Blackboard Systems: The Blackboard Model of Problem Solving and the Evolution of Blackboard Architectures” 1986.
- For the purpose of illustration the invention will be described using the specific example of processing a client application for a credit card (client identity verification). We describe a possible set of agents that can perform this task and illustrate their interactions through a detailed scenario.
- These agents are used in the client identity verification application:
- Issue credit officer user agent;
- Issue credit card functional agent;
- Credit bureau functional agent;
- Client identity verification functional agent;
- Operator user agent;
- Credit database abstract resource agent; and
- Resource agents for each database.
- The agents interact with the following resources:
- Paradox, Oracle, Ingres database
- Issue credit officer
- Operator
- This scenario shows the interactions between the agents and/or the resources involved in verifying the identity of a client, as shown in FIG. 1.
- The rationale for this workflow is that if the client is already in some database then don't issue the card. This rationale is decomposed into a number of processes which are then distributed on a network of interacting agents. As described in the aforementioned U.S. Pat. No. (5,638,494) each process defines a sequence of steps which is executed when a specific goal is received by an agent. Agents trigger the execution of processes in other agents by exchanging goals.
- For example, in order to meet the above rationale, the ISSUE CREDIT CARD FUNCTIONAL AGENT issues the goals “verifyClientIdentity: aClientApplication” and “checkCreditHistory: aClientApplication”. In this particular embodiment, goals are specified by a keyword that identifies the goal (for example, “verifyClientIdentity:”) and a set of associated parameters (“aClientApplication”). Multiple parameters are separated by further keywords as in the goal “performSearchFor: aKey withSearchParams: params”.
- Upon receiving a goal an agent then uses it to lookup the appropriate process by which it can satisfy the goal. For example, the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT first sends a goal to find existing information on the client to the CLIENT DATABASE ABSTRACT RESOURCE AGENT. If multiple database entries related to the client can be found, but the agent cannot identify the ambiguities given its current strategies, the CLIENT IDENTITY FUNCTIONAL AGENT sends a goal to the OPERATOR USER AGENT to ask the human Operator for help.
- As described in the U.S. Pat. No. 5,638,494 an agent that requires services from another agent or a resource to accomplish its goals needs usage rights over that agent or resource. The direction of the arrows in FIG. 1 indicates both the primary flow of the control through the application as well as the usage rights. A usage right defines which operations an agent may perform on another together with capacity and quality of service constraints. Usage rights may be distributed in accordance with the priorities of the organization. In this case, the priority would equate to which data mining tasks are more important than others.
- The following is a step by step description of the processes involved in a client application for a credit card.
- 1. The Issue credit officer enters information on a credit card applicant into a terminal where it is received by the ISSUE CREDIT OFFICER USER AGENT.
- 2. The ISSUE CREDIT OFFICER USER AGENT asks the ISSUE CREDIT CARD FUNCTIONAL AGENT to issue a client card for the client application. In the goal the record of the client application (aClientApplication) is passed as a parameter.
- 3. The ISSUE CREDIT CARD FUNCTIONAL AGENT orders the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT to verify the client identity for the client application (aClientApplication).
- 4. The CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT queries the CREDIT DATABASE ABSTRACT RESOURCE AGENT to find relevant information for the client application (aClientApplication).
- 5. The CREDIT DATABASE ABSTRACT RESOURCE AGENT performs a fuzzy search on each database that holds information about keys (aKey) in the client application. The fuzzy search retrieves similar entries from the database. Similarity is defined by an appropriate distance measure. For example, the names “Mankovski”, “Mankovskii” and “Mankowski” would be considered similar, because they can be derived from each other through simple permutations. One way of performing the fuzzy search is to translate the original query into a number of queries for different permutations on a search key such as the name. Another is to retrieve a range of subsequent database entries and computing relative distances. The fuzzy search is used by one of the strategies employed by the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT to find ambiguities.
- 6. Each database resource agent performs a search for each requested key (aKey) using the specified search parameters (params) and returns the result to the CREDIT DATABASE ABSTRACT RESOURCE AGENT. The fuzzy search might involve multiple requests to the database resource agent.
- 7. The CREDIT DATABASE ABSTRACT RESOURCE AGENT consolidates the information retrieved from its database resource agents a list of database entries that match the query to the CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT.
- 8. The CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT uses its strategy to find ambiguities in the information returned by the CREDIT DATABASE ABSTRACT RESOURCE AGENT. Examples of strategies are to look for apparent misspellings, for previous, failed credit applications by the client, or for records on credits applied for by the client's spouse.
- 9. The CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT resolves ambiguities identified in the previous step. This may include interaction with a human operator, if the agent could not resolve an ambiguity with sufficient certainty. In this case it asks the Operator to verify the information.
- 10. The CLIENT IDENTITY VERIFICATION FUNCTIONAL AGENT consolidates the verified information and, if there is any evidence of the client already being in the database, returns it to the ISSUE CREDIT CARD FUNCTIONAL AGENT.
- 11. If no evidence has been found, the Credit identify verification workflow can continue, for example, with checking the client's credit history. The ISSUE CREDIT CARD FUNCTIONAL AGENT proceeds by sending a goal to the CREDIT BUREAU FUNCTIONAL AGENT to check the credit history of the client. The remainder of that workflow is not shown.
- FIG. 2 shows a specific physical embodiment of the invention. The system components are connected by a LAN. The
computers PC 1 andPC 2 are connected to the LAN.PC 1 is used to enter client information and to trigger a client identify verification.PC 2 is used to interact with the Operator when the application requires the Operator's intervention. - The computers Host1 to Host 7 are also connected to the LAN. The agents and database resources run in programs on these computers.
- Host I hosts
Functional Agent 1 andFunctional Agent 2.Functional Agent 1 is a program that executes the logic of the ISSUE CREDIT CARD FUNCTIONAL AGENT.Functional Agent 2 executes the CREDIT IDENTITY VERIFICATION FUNCTIONAL AGENT.Host 2 hosts the user agents for the Issue credit officer and the Operator. User Agent I executes the ISSUE CREDIT OFFICER USER AGENT,User Agent 2 the OPERATOR USER AGENT.Host 3 hosts the CREDIT BUREAU FUNCTIONAL AGENT. - The CREDIT DATABASE ABSTRACT RESOURCE AGENT executes on
host 4. The database resource agents for the Paradox, Oracle and Ingres databases run onhosts - FIG. 3 shows the internal structure of an agent. In this embodiment, each agent has a head-body architecture found in many agent-based systems. A head-body agent has two subsystems: a control subsystem (head) and an action subsystem (body). The head processes external goals, which have been sent by other agents, as well as internal goals, which result from the decomposition of an external goal, or to internal triggers generated in the body. The body interacts with external resources and provides the mechanisms for sending goals to other agents. Head and body communicate through a common blackboard.
- The head comprises a goal resolution area, and a set of process and strategy knowledge sources (KS). The goal resolution area receives incoming goals and posts them to the appropriate process KS. Each process KS implements a workflow or subworkflow. It operates by decomposing goals into subgoals and tasks. For further details refer to aforementioned U.S. Pat. No. 5,638,494. Subgoals are posted back to the goal resolution area, and tasks are processed by knowledge sources in the body. Each subgoal is then posted to another process KS or a strategy KS. For example, the process KS for handling “verify the client identity” service requests activates the “similar names” strategy by posting a subgoal to it upon receiving such a service request. In addition, a process KS can post data to the blackboard and read hypotheses from the blackboard, which were posted by a strategy KS. This is another way process and strategy KSs communicate.
- Each strategy KS implements a strategy for detecting and resolving ambiguities in the data posted to the blackboard by a knowledge source in the body. It employs a mixture of algorithms (for example, for computing the similarity between two database entries), and if-then rules, as they are found in expert systems, and produces hypotheses which are posted to the blackboard where they become visible to process KSs and other strategy KSs. During its execution, a strategy KS also reads data from the blackboard previously posted by a process KS.
- For example, given a set of similar database entries as in FIG. 4, the “similar names” strategy KS would post a hypothesis that different database entries actually represent the same client. This hypothesis would then trigger if-then else rules in the KS, which may result in the conclusion that the client should not be issued a card. This conclusion is again posted to the blackboard as a hypothesis. This hypothesis is then interpreted by the process KS which activated the “similar names” strategy KS as a result to the service request to verify the client identity. FIG. 4 shows the trace of the resulting flow of information.
- The body contains a set of agent adapter and resource adapter KSs. Each agent adapter KS provides a mechanism to send a goal to another agent over which this agent has a usage right. It triggers when an outgoing goal is posted to the blackboard by one of the process KSs. Each resource adapter KS provides an interface to an attached resource, for example, a database. It can interpret tasks posted to the blackboard and translates them into appropriate API calls on the resource. It also interprets callbacks from the resource as triggers to knowledge sources in the head. In particular the callback can be used to pass back a result to a service request (for example, a database query). For further details see the U.S. Pat. No. 5,638,494.
- The invention can be applied to improve call center routing.
- Here data mining would be used to match an incoming call with the most appropriate human agent. Conventionally, a call center application maintains a database of customers and information on previous calls by these customers (such as a trouble-ticket number). However, the information that can be used to match a caller to a human agent is limited to “hard” information such as the caller id or a trouble-ticket number. Such hard information is not always available, for example, the caller might be calling from a hotel (not from his home) phone.
- The name of the customer is already a piece of “soft” information, because of the different ways a name could be entered by the attendant taking the call when it first arrives at the call center. In the described scenario of a caller calling from a hotel phone, other information must be taken into account to route the call. One application of the invention would be to ask the caller a series of questions (name, trouble ticket number, contact, etc.), making use of speech recognition or based on the information entered by the attendant, to identify whether the caller has called the center before, whether it is an important customer etc. so as to allow routing to the appropriate human agent.
- In summary, more information about a caller can be used to make better routing decisions in a call center (“soft” information being an example). The information will be ambiguous and distributed on multiple databases. The mechanisms described in the present application address these issues and can thus improve the quality of response of a call center application.
- While particular embodiments have been described and illustrated it will be apparent to one skilled in the art that numerous changes can be made to the basic concept. It is to be understood that such changes will fall within the scope of the invention as defined by the appended claims.
Claims (15)
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
GB9806879.4 | 1998-04-01 | ||
GB9806879A GB2336007B (en) | 1998-04-01 | 1998-04-01 | Agent-based data mining and warehousing |
GB9806879 | 1998-04-01 |
Publications (2)
Publication Number | Publication Date |
---|---|
US20020062315A1 true US20020062315A1 (en) | 2002-05-23 |
US6460037B1 US6460037B1 (en) | 2002-10-01 |
Family
ID=10829600
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US09/241,304 Expired - Lifetime US6460037B1 (en) | 1998-04-01 | 1999-02-01 | Agent-based data mining and warehousing |
Country Status (3)
Country | Link |
---|---|
US (1) | US6460037B1 (en) |
CA (1) | CA2260647C (en) |
GB (1) | GB2336007B (en) |
Cited By (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020107641A1 (en) * | 1999-03-10 | 2002-08-08 | Schaeffer Anthony J. | Methods and kits for managing diagnosis and therapeutics of bacterial infections |
US20030074301A1 (en) * | 1999-11-01 | 2003-04-17 | Neal Solomon | System, method, and apparatus for an intelligent search agent to access data in a distributed network |
US20050234696A1 (en) * | 2004-04-15 | 2005-10-20 | The University Of Chicago | Automated agent-based method for identifying infrastructure interdependencies |
US20080154556A1 (en) * | 2006-12-22 | 2008-06-26 | Merced Systems, Inc. | Disambiguation with respect to multi-grained dimension coordinates |
US20090083216A1 (en) * | 2007-09-24 | 2009-03-26 | Merced Systems, Inc. | Temporally-aware evaluative score |
US20090106069A1 (en) * | 2007-10-19 | 2009-04-23 | Mitsutaka Asakura | Counter management apparatus |
US7809663B1 (en) | 2006-05-22 | 2010-10-05 | Convergys Cmg Utah, Inc. | System and method for supporting the utilization of machine language |
US8260619B1 (en) | 2008-08-22 | 2012-09-04 | Convergys Cmg Utah, Inc. | Method and system for creating natural language understanding grammars |
US20120291135A1 (en) * | 2001-01-03 | 2012-11-15 | Portauthority Technologies Inc. | Method and application for a reactive defense against illegal distribution of multimedia content in file sharing networks |
Families Citing this family (36)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6574655B1 (en) * | 1999-06-29 | 2003-06-03 | Thomson Licensing Sa | Associative management of multimedia assets and associated resources using multi-domain agent-based communication between heterogeneous peers |
DE10014717A1 (en) * | 2000-03-24 | 2001-09-27 | Abb Research Ltd | Method for management of online customer inquiries where a supplier web-site and server are equipped with management software that connects the customer inquiry with the relevant supplier personnel or product information |
US7062527B1 (en) * | 2000-04-19 | 2006-06-13 | Silicon Graphics, Inc. | Management and scheduling of a distributed rendering method and system |
US7092983B1 (en) | 2000-04-19 | 2006-08-15 | Silicon Graphics, Inc. | Method and system for secure remote distributed rendering |
US7783695B1 (en) | 2000-04-19 | 2010-08-24 | Graphics Properties Holdings, Inc. | Method and system for distributed rendering |
US7383299B1 (en) * | 2000-05-05 | 2008-06-03 | International Business Machines Corporation | System and method for providing service for searching web site addresses |
US6785666B1 (en) | 2000-07-11 | 2004-08-31 | Revenue Science, Inc. | Method and system for parsing navigation information |
US20040034589A1 (en) * | 2000-10-25 | 2004-02-19 | International Business Machines Corporation | Data mining techniques for enhancing product stockpile management |
US6668254B2 (en) * | 2000-12-21 | 2003-12-23 | Fulltilt Solutions, Inc. | Method and system for importing data |
US6988095B1 (en) * | 2001-05-07 | 2006-01-17 | Hearst Business Communications, Inc. | Systems and methods for performing parametric searches |
US7356820B2 (en) * | 2001-07-02 | 2008-04-08 | International Business Machines Corporation | Method of launching low-priority tasks |
US6912533B1 (en) | 2001-07-31 | 2005-06-28 | Oracle International Corporation | Data mining agents for efficient hardware utilization |
EA200400873A1 (en) * | 2001-12-28 | 2005-12-29 | Джеффри Джэймс Джонас | REAL-TIME DATA STORAGE |
US8566102B1 (en) | 2002-03-28 | 2013-10-22 | At&T Intellectual Property Ii, L.P. | System and method of automating a spoken dialogue service |
US7813951B2 (en) * | 2002-06-04 | 2010-10-12 | Sap Ag | Managing customer loss using a graphical user interface |
US20040039593A1 (en) * | 2002-06-04 | 2004-02-26 | Ramine Eskandari | Managing customer loss using customer value |
US7813952B2 (en) | 2002-06-04 | 2010-10-12 | Sap Ag | Managing customer loss using customer groups |
US7440941B1 (en) | 2002-09-17 | 2008-10-21 | Yahoo! Inc. | Suggesting an alternative to the spelling of a search query |
EP1563628A4 (en) | 2002-11-06 | 2010-03-10 | Ibm | Confidential data sharing and anonymous entity resolution |
US8620937B2 (en) * | 2002-12-27 | 2013-12-31 | International Business Machines Corporation | Real time data warehousing |
CN100541443C (en) * | 2002-12-31 | 2009-09-16 | 国际商业机器公司 | The method and system that is used for deal with data |
US7200602B2 (en) * | 2003-02-07 | 2007-04-03 | International Business Machines Corporation | Data set comparison and net change processing |
EP1631908A4 (en) * | 2003-03-24 | 2012-01-25 | Ibm | Secure coordinate identification method, system and program |
US20040215656A1 (en) * | 2003-04-25 | 2004-10-28 | Marcus Dill | Automated data mining runs |
US7360215B2 (en) * | 2003-05-15 | 2008-04-15 | Sap Ag | Application interface for analytical tasks |
US7694307B2 (en) * | 2003-05-15 | 2010-04-06 | Sap Ag | Analytical task invocation |
US7370316B2 (en) * | 2003-06-03 | 2008-05-06 | Sap Ag | Mining model versioning |
US7373633B2 (en) * | 2003-06-03 | 2008-05-13 | Sap Ag | Analytical application framework |
US7672927B1 (en) * | 2004-02-27 | 2010-03-02 | Yahoo! Inc. | Suggesting an alternative to the spelling of a search query |
US20070174290A1 (en) * | 2006-01-19 | 2007-07-26 | International Business Machines Corporation | System and architecture for enterprise-scale, parallel data mining |
US7599861B2 (en) | 2006-03-02 | 2009-10-06 | Convergys Customer Management Group, Inc. | System and method for closed loop decisionmaking in an automated care system |
US8379830B1 (en) | 2006-05-22 | 2013-02-19 | Convergys Customer Management Delaware Llc | System and method for automated customer service with contingent live interaction |
US8204831B2 (en) | 2006-11-13 | 2012-06-19 | International Business Machines Corporation | Post-anonymous fuzzy comparisons without the use of pre-anonymization variants |
US7630978B2 (en) * | 2006-12-14 | 2009-12-08 | Yahoo! Inc. | Query rewriting with spell correction suggestions using a generated set of query features |
US9760591B2 (en) | 2015-05-14 | 2017-09-12 | Walleye Software, LLC | Dynamic code loading |
US10198469B1 (en) | 2017-08-24 | 2019-02-05 | Deephaven Data Labs Llc | Computer data system data source refreshing using an update propagation graph having a merged join listener |
Family Cites Families (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CA2119085C (en) * | 1994-03-15 | 2002-01-15 | Deborah L. Pinard | Adaptive communication system |
US5655081A (en) * | 1995-03-08 | 1997-08-05 | Bmc Software, Inc. | System for monitoring and managing computer resources and applications across a distributed computing environment using an intelligent autonomous agent architecture |
US5752246A (en) * | 1995-06-07 | 1998-05-12 | International Business Machines Corporation | Service agent for fulfilling requests of a web browser |
US5710918A (en) * | 1995-06-07 | 1998-01-20 | International Business Machines Corporation | Method for distributed task fulfillment of web browser requests |
US5721908A (en) * | 1995-06-07 | 1998-02-24 | International Business Machines Corporation | Computer network for WWW server data access over internet |
US5809478A (en) * | 1995-12-08 | 1998-09-15 | Allstate Insurance Company | Method for accessing and evaluating information for processing an application for insurance |
JPH1069487A (en) * | 1996-08-28 | 1998-03-10 | Hitachi Ltd | Managing method for information with ambiguous name |
US5983200A (en) * | 1996-10-09 | 1999-11-09 | Slotznick; Benjamin | Intelligent agent for executing delegated tasks |
US6108004A (en) * | 1997-10-21 | 2000-08-22 | International Business Machines Corporation | GUI guide for data mining |
US6151601A (en) * | 1997-11-12 | 2000-11-21 | Ncr Corporation | Computer architecture and method for collecting, analyzing and/or transforming internet and/or electronic commerce data for storage into a data storage area |
US6128624A (en) * | 1997-11-12 | 2000-10-03 | Ncr Corporation | Collection and integration of internet and electronic commerce data in a database during web browsing |
US6151584A (en) * | 1997-11-20 | 2000-11-21 | Ncr Corporation | Computer architecture and method for validating and collecting and metadata and data about the internet and electronic commerce environments (data discoverer) |
-
1998
- 1998-04-01 GB GB9806879A patent/GB2336007B/en not_active Expired - Lifetime
-
1999
- 1999-02-01 US US09/241,304 patent/US6460037B1/en not_active Expired - Lifetime
- 1999-02-02 CA CA002260647A patent/CA2260647C/en not_active Expired - Lifetime
Cited By (18)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7627489B2 (en) | 1999-03-10 | 2009-12-01 | Illinois Institute Of Technology | Method for the construction and utilization of a medical records system |
US20020107641A1 (en) * | 1999-03-10 | 2002-08-08 | Schaeffer Anthony J. | Methods and kits for managing diagnosis and therapeutics of bacterial infections |
US7418399B2 (en) * | 1999-03-10 | 2008-08-26 | Illinois Institute Of Technology | Methods and kits for managing diagnosis and therapeutics of bacterial infections |
US20080319800A1 (en) * | 1999-03-10 | 2008-12-25 | Schaeffer Anthony J | Method for the construction and utilization of a medical records system |
US20030074301A1 (en) * | 1999-11-01 | 2003-04-17 | Neal Solomon | System, method, and apparatus for an intelligent search agent to access data in a distributed network |
US9177120B2 (en) * | 2001-01-03 | 2015-11-03 | Portauthority Technologies, Inc. | Method and application for a reactive defense against illegal distribution of multimedia content in file sharing networks |
US20120291135A1 (en) * | 2001-01-03 | 2012-11-15 | Portauthority Technologies Inc. | Method and application for a reactive defense against illegal distribution of multimedia content in file sharing networks |
US20050234696A1 (en) * | 2004-04-15 | 2005-10-20 | The University Of Chicago | Automated agent-based method for identifying infrastructure interdependencies |
US7809663B1 (en) | 2006-05-22 | 2010-10-05 | Convergys Cmg Utah, Inc. | System and method for supporting the utilization of machine language |
US20080154556A1 (en) * | 2006-12-22 | 2008-06-26 | Merced Systems, Inc. | Disambiguation with respect to multi-grained dimension coordinates |
US8036859B2 (en) * | 2006-12-22 | 2011-10-11 | Merced Systems, Inc. | Disambiguation with respect to multi-grained dimension coordinates |
US8335690B1 (en) | 2007-08-23 | 2012-12-18 | Convergys Customer Management Delaware Llc | Method and system for creating natural language understanding grammars |
US20090083216A1 (en) * | 2007-09-24 | 2009-03-26 | Merced Systems, Inc. | Temporally-aware evaluative score |
US8051075B2 (en) | 2007-09-24 | 2011-11-01 | Merced Systems, Inc. | Temporally-aware evaluative score |
US8166050B2 (en) | 2007-09-24 | 2012-04-24 | Merced Systems, Inc | Temporally-aware evaluative score |
US20110161275A1 (en) * | 2007-09-24 | 2011-06-30 | Merced Systems, Inc. | Temporally-aware evaluative score |
US20090106069A1 (en) * | 2007-10-19 | 2009-04-23 | Mitsutaka Asakura | Counter management apparatus |
US8260619B1 (en) | 2008-08-22 | 2012-09-04 | Convergys Cmg Utah, Inc. | Method and system for creating natural language understanding grammars |
Also Published As
Publication number | Publication date |
---|---|
GB2336007A (en) | 1999-10-06 |
CA2260647A1 (en) | 1999-10-01 |
US6460037B1 (en) | 2002-10-01 |
CA2260647C (en) | 2002-11-05 |
GB9806879D0 (en) | 1998-05-27 |
GB2336007B (en) | 2003-01-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US6460037B1 (en) | Agent-based data mining and warehousing | |
KR100850255B1 (en) | Real time data warehousing | |
US6757670B1 (en) | Method and system for query processing | |
US4974254A (en) | Interactive data retrieval system for producing facsimile reports | |
EP0807290B1 (en) | Method and system for accessing data | |
US8620937B2 (en) | Real time data warehousing | |
US6014658A (en) | Using a database for managing solutions to problems | |
US20100115100A1 (en) | Federated configuration data management | |
US11281664B1 (en) | Search engine optimizer | |
US6850927B1 (en) | Evaluating queries with outer joins by categorizing and processing combinations of relationships between table records | |
JP2011509472A (en) | Data clustering method, system, apparatus, and computer program for applying the method | |
JP2009521770A (en) | Method and system for enhancing matching from customer-driven queries | |
WO2021159834A1 (en) | Abnormal information processing node analysis method and apparatus, medium and electronic device | |
US6782391B1 (en) | Intelligent knowledge base content categorizer (IKBCC) | |
US20050091210A1 (en) | Method for integrating and accessing of heterogeneous data sources | |
CN108287901A (en) | Method and apparatus for generating information | |
JP2003006162A (en) | Authentication application service system | |
US20020072949A1 (en) | Item allocation method, system and program for workflow system | |
US6778978B1 (en) | Determining a workbasket identification for an item in a data store | |
Xu et al. | PBKM: A secure knowledge management framework | |
CN103634326B (en) | A kind of method and device for processing application system request message | |
CN113204644B (en) | Government affair encyclopedia construction method based on knowledge graph | |
Rosalia et al. | The Application Of Online Presence To The Work Discipline Of Purwakarta State Court Employees | |
Delugach et al. | Applying conceptual graphs for inference detection using second path analysis | |
KR20220007911A (en) | Server for managing of meta data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: MITEL CORPORATION, CANADA Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:WEISS, MICHAEL;MANKOVSKII, SERGUEII;REEL/FRAME:009745/0044 Effective date: 19990125 |
|
AS | Assignment |
Owner name: MITEL KNOWLEDGE CORPORATION, CANADA Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:MITEL CORPORATION;REEL/FRAME:011871/0001 Effective date: 20010215 |
|
STCF | Information on status: patent grant |
Free format text: PATENTED CASE |
|
AS | Assignment |
Owner name: MITEL NETWORKS CORPORATION,CANADA Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:MITEL KNOWLEDGE CORPORATION;REEL/FRAME:016345/0283 Effective date: 20021101 Owner name: MITEL NETWORKS CORPORATION, CANADA Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:MITEL KNOWLEDGE CORPORATION;REEL/FRAME:016345/0283 Effective date: 20021101 |
|
AS | Assignment |
Owner name: MITEL NETWORKS CORPORATION,CANADA Free format text: SECURITY AGREEMENT;ASSIGNOR:HIGHBRIDGE INTERNATIONAL LLC;REEL/FRAME:016345/0236 Effective date: 20050427 Owner name: MITEL NETWORKS CORPORATION, CANADA Free format text: SECURITY AGREEMENT;ASSIGNOR:HIGHBRIDGE INTERNATIONAL LLC;REEL/FRAME:016345/0236 Effective date: 20050427 |
|
AS | Assignment |
Owner name: BNY TRUST COMPANY OF CANADA, TRUST COMPANY OF CANA Free format text: SECURITY AGREEMENT;ASSIGNOR:MITEL NETWORKS CORPORATION, A CORPORATION OF CANADA;REEL/FRAME:016891/0959 Effective date: 20050427 |
|
FPAY | Fee payment |
Year of fee payment: 4 |
|
AS | Assignment |
Owner name: MORGAN STANLEY & CO. INCORPORATED, NEW YORK Free format text: SECURITY AGREEMENT;ASSIGNOR:MITEL NETWORKS CORPORATION;REEL/FRAME:019817/0847 Effective date: 20070816 Owner name: MORGAN STANLEY & CO. INCORPORATED, NEW YORK Free format text: SECURITY AGREEMENT;ASSIGNOR:MITEL NETWORKS CORPORATION;REEL/FRAME:019817/0881 Effective date: 20070816 Owner name: MORGAN STANLEY & CO. INCORPORATED,NEW YORK Free format text: SECURITY AGREEMENT;ASSIGNOR:MITEL NETWORKS CORPORATION;REEL/FRAME:019817/0847 Effective date: 20070816 Owner name: MORGAN STANLEY & CO. INCORPORATED,NEW YORK Free format text: SECURITY AGREEMENT;ASSIGNOR:MITEL NETWORKS CORPORATION;REEL/FRAME:019817/0881 Effective date: 20070816 |
|
AS | Assignment |
Owner name: MITEL NETWORKS CORPORATION, CANADA Free format text: RELEASE & DISCHARGE OF SECURITY INTEREST;ASSIGNOR:HIGHBRIDGE INTERNATIONAL LLC/BNY TRUST COMPANY OF CANADA;REEL/FRAME:021794/0510 Effective date: 20080304 Owner name: MITEL NETWORKS CORPORATION,CANADA Free format text: RELEASE & DISCHARGE OF SECURITY INTEREST;ASSIGNOR:HIGHBRIDGE INTERNATIONAL LLC/BNY TRUST COMPANY OF CANADA;REEL/FRAME:021794/0510 Effective date: 20080304 |
|
FPAY | Fee payment |
Year of fee payment: 8 |
|
AS | Assignment |
Owner name: MITEL NETWORKS CORPORATION, CANADA Free format text: RELEASE OF SECURITY INTEREST IN PATENTS;ASSIGNOR:WILMINGTON TRUST, NATIONAL ASSOCIATION FKA WILMINGTON TRUST FSB/MORGAN STANLEY & CO. INCORPORATED;REEL/FRAME:030165/0776 Effective date: 20130227 |
|
AS | Assignment |
Owner name: BANK OF AMERICA, N.A., AS COLLATERAL AGENT, TEXAS Free format text: SECURITY AGREEMENT;ASSIGNOR:MITEL NETWORKS CORPORATION;REEL/FRAME:030186/0894 Effective date: 20130227 Owner name: WILMINGTON TRUST, N.A., AS SECOND COLLATERAL AGENT Free format text: SECURITY INTEREST;ASSIGNOR:MITEL NETWORKS CORPORATION;REEL/FRAME:030201/0743 Effective date: 20130227 |
|
AS | Assignment |
Owner name: MITEL NETWORKS CORPORATION, CANADA Free format text: RELEASE BY SECURED PARTY;ASSIGNORS:BANK OF NEW YORK MELLON, THE;MORGAN STANLEY & CO. INCORPORATED;MORGAN STANLEY SENIOR FUNDING, INC.;REEL/FRAME:030264/0470 Effective date: 20130227 |
|
AS | Assignment |
Owner name: MITEL NETWORKS CORPORATION, CANADA Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:WILMINGTON TRUST, NATIONAL ASSOCIATION;REEL/FRAME:032167/0464 Effective date: 20140131 Owner name: MITEL US HOLDINGS, INC., ARIZONA Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:WILMINGTON TRUST, NATIONAL ASSOCIATION;REEL/FRAME:032167/0464 Effective date: 20140131 |
|
AS | Assignment |
Owner name: MITEL NETWORKS CORPORATION, CANADA Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:BANK OF AMERICA, N.A.;REEL/FRAME:032210/0245 Effective date: 20140131 Owner name: MITEL US HOLDINGS, INC., ARIZONA Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:BANK OF AMERICA, N.A.;REEL/FRAME:032210/0245 Effective date: 20140131 |
|
AS | Assignment |
Owner name: JEFFERIES FINANCE LLC, AS THE COLLATERAL AGENT, NE Free format text: SECURITY AGREEMENT;ASSIGNORS:MITEL US HOLDINGS, INC.;MITEL NETWORKS CORPORATION;AASTRA USA INC.;REEL/FRAME:032264/0760 Effective date: 20140131 |
|
FPAY | Fee payment |
Year of fee payment: 12 |
|
AS | Assignment |
Owner name: MITEL US HOLDINGS, INC., ARIZONA Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:JEFFERIES FINANCE LLC, AS THE COLLATERAL AGENT;REEL/FRAME:035562/0157 Effective date: 20150429 Owner name: MITEL NETWORKS CORPORATION, CANADA Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:JEFFERIES FINANCE LLC, AS THE COLLATERAL AGENT;REEL/FRAME:035562/0157 Effective date: 20150429 Owner name: MITEL COMMUNICATIONS INC. FKA AASTRA USA INC., TEX Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:JEFFERIES FINANCE LLC, AS THE COLLATERAL AGENT;REEL/FRAME:035562/0157 Effective date: 20150429 |
|
AS | Assignment |
Owner name: BANK OF AMERICA, N.A.(ACTING THROUGH ITS CANADA BR Free format text: SECURITY INTEREST;ASSIGNOR:MITEL NETWORKS CORPORATION;REEL/FRAME:035783/0540 Effective date: 20150429 |
|
AS | Assignment |
Owner name: CITIZENS BANK, N.A., MASSACHUSETTS Free format text: SECURITY INTEREST;ASSIGNOR:MITEL NETWORKS CORPORATION;REEL/FRAME:042107/0378 Effective date: 20170309 |
|
AS | Assignment |
Owner name: MITEL (DELAWARE), INC., ARIZONA Free format text: RELEASE BY SECURED PARTY;ASSIGNORS:BANK OF AMERICA, N.A., AS COLLATERAL AGENT;BANK OF AMERICA, N.A., (ACTING THROUGH ITS CANADA BRANCH), AS CANADIAN COLLATERAL AGENT;REEL/FRAME:042244/0461 Effective date: 20170309 Owner name: MITEL NETWORKS, INC., ARIZONA Free format text: RELEASE BY SECURED PARTY;ASSIGNORS:BANK OF AMERICA, N.A., AS COLLATERAL AGENT;BANK OF AMERICA, N.A., (ACTING THROUGH ITS CANADA BRANCH), AS CANADIAN COLLATERAL AGENT;REEL/FRAME:042244/0461 Effective date: 20170309 Owner name: MITEL BUSINESS SYSTEMS, INC., ARIZONA Free format text: RELEASE BY SECURED PARTY;ASSIGNORS:BANK OF AMERICA, N.A., AS COLLATERAL AGENT;BANK OF AMERICA, N.A., (ACTING THROUGH ITS CANADA BRANCH), AS CANADIAN COLLATERAL AGENT;REEL/FRAME:042244/0461 Effective date: 20170309 Owner name: MITEL NETWORKS CORPORATION, CANADA Free format text: RELEASE BY SECURED PARTY;ASSIGNORS:BANK OF AMERICA, N.A., AS COLLATERAL AGENT;BANK OF AMERICA, N.A., (ACTING THROUGH ITS CANADA BRANCH), AS CANADIAN COLLATERAL AGENT;REEL/FRAME:042244/0461 Effective date: 20170309 Owner name: MITEL US HOLDINGS, INC., ARIZONA Free format text: RELEASE BY SECURED PARTY;ASSIGNORS:BANK OF AMERICA, N.A., AS COLLATERAL AGENT;BANK OF AMERICA, N.A., (ACTING THROUGH ITS CANADA BRANCH), AS CANADIAN COLLATERAL AGENT;REEL/FRAME:042244/0461 Effective date: 20170309 Owner name: MITEL COMMUNICATIONS, INC., TEXAS Free format text: RELEASE BY SECURED PARTY;ASSIGNORS:BANK OF AMERICA, N.A., AS COLLATERAL AGENT;BANK OF AMERICA, N.A., (ACTING THROUGH ITS CANADA BRANCH), AS CANADIAN COLLATERAL AGENT;REEL/FRAME:042244/0461 Effective date: 20170309 |
|
AS | Assignment |
Owner name: MITEL NETWORKS CORPORATION, CANADA Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:CITIZENS BANK, N.A.;REEL/FRAME:048096/0785 Effective date: 20181130 |
|
AS | Assignment |
Owner name: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT, NEW YORK Free format text: SECURITY INTEREST;ASSIGNOR:MITEL NETWORKS ULC;REEL/FRAME:047741/0704 Effective date: 20181205 Owner name: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT, NEW YORK Free format text: SECURITY INTEREST;ASSIGNOR:MITEL NETWORKS ULC;REEL/FRAME:047741/0674 Effective date: 20181205 Owner name: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLAT Free format text: SECURITY INTEREST;ASSIGNOR:MITEL NETWORKS ULC;REEL/FRAME:047741/0704 Effective date: 20181205 Owner name: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLAT Free format text: SECURITY INTEREST;ASSIGNOR:MITEL NETWORKS ULC;REEL/FRAME:047741/0674 Effective date: 20181205 |