|Publication number||US7941542 B2|
|Application number||US 10/391,128|
|Publication date||10 May 2011|
|Filing date||17 Mar 2003|
|Priority date||6 Sep 2002|
|Also published as||US20080046568|
|Publication number||10391128, 391128, US 7941542 B2, US 7941542B2, US-B2-7941542, US7941542 B2, US7941542B2|
|Inventors||Tal Broda, Tim J. Beauchamp, Tana Christine Jackson, Kenneth C. Gardner, Geoffrey Deane Owen Nicholls|
|Original Assignee||Oracle International Corporation|
|Export Citation||BiBTeX, EndNote, RefMan|
|Patent Citations (296), Non-Patent Citations (177), Referenced by (30), Classifications (8), Legal Events (6)|
|External Links: USPTO, USPTO Assignment, Espacenet|
The present application claims the benefit of U.S. Provisional Application No. 60/410,989, filed Sep. 16, 2002, entitled “Business Intelligent System” and is a continuation-in-part of and claims priority to, U.S. patent application Ser. No. 10/237,559, filed Sep. 6, 2002 entitled “Enterprise Link For a Software Database,” both of which are incorporated by reference in their entirety for all purposes.
The present invention relates in general to enterprise information systems. More particularly, the present invention relates to methods and apparatus for optimizing the delivery of data to a device.
Timely intelligence is critical to proper business decision making. Collecting and quickly analyzing information, however, is often difficult. In a dynamic marketplace, delayed delivery of intelligence can reduce both its reliability and relevancy. Substantial delays can even make the information, often acquired at considerable cost, completely worthless.
Intelligence is often extracted from OLTP applications and from specialized databases, called operational data stores. OLTP (online transaction processing) applications are those enterprise systems that manage a company's basic transactions, such as order entry and billing systems. Since they are commonly optimized for reading and writing, and not for querying, extracting information from an OLTP application can be sufficiently complex to require additional user training. Furthermore, while operational data stores generally archive OLTP information in a format for querying, they also generally do not maintain important historical information. For instance, an operational data store may store a current checking account balance, but not the individual daily balances over the previous month.
In addition, the queries themselves often take substantial time to execute, producing only static snapshots of the information. Observing the dynamic aspect of changing information is therefore difficult. A possible solution may be to sequentially execute and aggregate a series of queries. However, this solution can be both inefficient and ineffective, since manual manipulation still often delays the information delivery. That is, these queries must be first manually aggregated and summarized, before intelligence reports can be generated and delivered.
ETL (extraction, transformation, and loading) systems help by extracting, transforming, and aggregating the information. But latency inherently found in most distributed networks, coupled with considerable manual intervention that ETL systems often require, mean that critical information can still be received late.
Automatic notification is a possible solution. Many analytical products such as business intelligence (BI) and online analytical processing (OLAP) systems are capable of monitoring, scheduling, and broadcasting alerts via email or pager. These systems, however, cannot generally assure that the intended recipient promptly receives and reads the message. This presents a significant problem for time-sensitive information, where minutes or even seconds can make a difference.
To facilitate discussion,
OLTP (online transaction processing) applications 152 are commonly coupled to each other, as well as to other enterprise applications, through a dedicated messaging and queuing application (MQ), such as IBM's MQSeries. MQ provides an efficient communication channel for these applications, by storing and forwarding data messages, in a manner that is similar to email.
Commonly coupled to each OLTP application 152 is operational data store 154, such as an Oracle database. Through an API (application programming interface), transactional data can be transferred between the OLTP application and the database. Operational data store 154 consolidates that data from multiple sources and provides a near real-time, integrated view of volatile, current data. Since its purpose is to provide integrated data for operational purposes, operational data store 154 primarily has add, change, and delete functionality.
In order to conduct meaningful analysis, this information is often further placed in a more stable environment, optimized for random querying. ETL system 155 extracts the information from the appropriate data store 154, transforms and combines the data based on pre-defined constraints, and subsequently loads the data into data warehouse 156. A popular ETL technique, developed by Sagent, is the use of data flows.
Data flows are a series of rule-enabled transformations that are connected in data pipelines. They handle the tasks of joining, merging, comparing and splitting data and permit the separation of data into different logic paths, each of which can be further combined and split off to create more complex transformation sequences.
ETL data extractions often occur by either a bulk or a trickle method. In the bulk method, periodic snap shots of data in operational data store 154 are extracted and uploaded into data warehouse 156. This commonly occurs as a large batch file scheduled during a low system utilization period. In the trickle method, changes in operational data store 154 are continuously uploaded, or “trickled” into data warehouse 156. These updates are therefore frequent, smaller, and more current than in the bulk method. As in the case of OLTP 152 systems, ETL 155 can also use the MQ for data extraction.
Once the data is in data warehouse 156, it is available for OLAP 158 (online analytical processing). OLAP enables trained users to perform ad hoc analysis of data in multiple dimensions, such as with an OLAP cube. OLAP cubes provide multi-dimensional views of data, querying, and analytical capabilities. Furthermore, many OLAP products can schedule, run, publish, and broadcast reports, alerts and responses over the network, email, or personal digital assistant. Users often access OLAP 158 by thin client 162. Thin clients are applications that generally are integrated into the underlying client device, and generally require minimal modification. For instance, a thin client can be browser with a Macromedia Flash module installed.
Although OLAP analysis can provide valuable insight about business operations, critical information is often received late, even with automated reporting. Automated OLAP reporting often only has access to the information within data warehouse 156, which can be several processing stages behind OLTP 152. This delay can be substantial, reducing the information's value. Furthermore, these reports are often only static snapshots of information in data warehouse 156.
For example, a NASDAQ broker places an order into an OLTP 152 application called an electronic communications network, or ECN. The ECN matches customer buy and sell orders directly through the computer. In this case, an order to buy 100 shares of ABC at $18.75 was entered. This open order is stored in the ECN operational data store 154, subsequently extracted by ETL 155, and analyzed by OLAP 158. If the buy order amount is the then highest in the ECN, OLAP 158 forwards the information to thin client 164, NASDAQ quote montage, where it is immediately displayed on the familiar stock market ticker tape. And although this system delivers stock information to individual brokers with reasonably small latency, it is also not easily modified. The NASDAQ application is custom designed for the specific purpose of enabling stock trading. As such, it would be difficult to display additional data on the stock ticker, such as non-financial information, without substantial additional programming.
In view of the foregoing, there is desired a method and apparatus for optimizing the delivery of data to a device, in which relevant information is received in a timely manner, and in which that data is rendered in a dynamic format.
The invention relates, in one embodiment, to method for optimally maintaining the execution of a first application, wherein the first application is further configured to received a set of sequential data elements from a second application, and the set of sequential data elements further includes a first data element and a second data element. The method includes establishing a connection between the first application and the second application. The method further includes transmitting a request to send the set of sequential data elements; receiving the first data element from the second application; and determining if the connection is still active. If not, the method also includes reestablishing the connection; transmitting a request to the second application to resend the first data element; receiving the first data element; and, if necessary, receiving the second data element.
In another embodiment, the invention relates to an apparatus for optimally maintaining the execution of a first application, wherein the first application is further configured to received a set of sequential data elements from a second application, and the set of sequential data elements further includes a first data element and a second data element. The apparatus further includes a means for establishing a connection between the first application and the second application; a means for transmitting a request to send the set of sequential data elements; and a means for receiving the first data element from the second application; and a means for determining if the connection is still active. If not, the apparatus includes a means for reestablishing the connection; a means for transmitting a request to the second application to resend the first data element; a means for receiving the first data element; and, if necessary, a means for receiving the second data element.
These and other features of the present invention will be described in more detail below in the detailed description of the invention and in conjunction with the following figures.
The present invention is illustrated by way of example, and not by way of limitation, in the figures of the accompanying drawings and in which like reference numerals refer to similar elements and in which:
The present invention will now be described in detail with reference to a few preferred embodiments thereof as illustrated in the accompanying drawings. In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. It will be apparent, however, to one skilled in the art, that the present invention may be practiced without some or all of these specific details. In other instances, well known process steps and/or structures have not been described in detail in order to not unnecessarily obscure the present invention. The features and advantages of the present invention may be better understood with reference to the drawings and discussions that follow.
In accordance with one embodiment of the present invention, an active data architecture is advantageously employed to facilitate the presence-aware delivery of timely data. That is, determining the type of device available to the user, and delivering the information in a format within the device's capabilities. In accordance with another embodiment of the present invention, information can be continuously extracted from data sources without the need for manual queries, or additional user training. In accordance with another embodiment of the present invention, information may be dynamically delivered in order to render streaming real-time or near real-time data and/or analytical results, whether graphically, textually, audibly, or otherwise.
Referring now to
Through the use of browser technology, such as DHTML, thin client 114 and a rich client 282 provide the user with enhanced visualization functionality, such as the capability to graphically render streaming data. Thin client 114, in one embodiment, is called active viewer, and comprises a browser. Rich client 282, in another embodiment, is called active viewer pro, and comprises a browser with additionally installed software. DHTML is a combination of HTML, style sheets, and scripts, and allows web-pages to be animated. In addition, rich client 282 further allows for enhanced functionality, such as pen-based user input, secure instant messaging, robust printing capability, and the use of skins. Skins are configuration files that allow modification of the browser appearance. Messaging client 115, such as a SMS cell phone, or an instant messaging program, such as Yahoo Messenger or Windows Messenger, provides alert capability. These alerts, as well as static reports, can also be received through thin client 114, such as a browser. Other 280 represents those enterprise applications that have been programmatically coupled to active data platform 210, as a client.
In one embodiment, client applications in client layer 142 can reside on a Tablet PC. The Tablet PC represents the evolution of the business notebook personal computer. It marks a new direction for notebook PCs, adding pen-based technologies to existing notebook functionality and enabling Windows XP-compatible applications to take advantage of various input modes, such as pen and voice-based data. The Table PC will be among the most versatile PCs ever made, with high-powered and efficient processors, lightweight designs, and, for man, built-in wireless capability. All Tablet PCs will have keyboards, some permanently attached and others detachable. But the Tablet PC is more than just a great notebook. The real value of the Table PC is that it makes it possible for information workers to bring the power of their business PC into more places than ever before, and they can do it with the same software they use on their office PC or notebook today.
For example, betting transactions would be normally stored in a casino's game transaction system. Wanting to be extra-attentive to high-rollers, a casino would configure the active data platform to observe for any customer whose betting exceeds a specified threshold, upon which an alert would be sent to the closest pit boss. The pit boss would locate these customers and personally oversee that exceptional customer service was provided.
Active data cache 256 is the core repository for the active data platform. Unlike traditional databases, such as operational data store 104 and data warehouse 106, active data cache 256 stores data in a de-normalized format. Normalization is the practice of optimizing the database structure into multiple tables, eliminating data redundancy and improving scalability and maintainability.
Since active data cache 256 is primarily focused on automatic reporting, and not on querying, it generates substantially de-normalized tables representing each report or data stream. By logically placing these de-normalized tables near client layer 142, in a non-obvious fashion, fewer processing stages are required and latency is substantially reduced.
Database tables are not commonly de-normalized, since data is duplicated. In general, duplicated data tends to increase the likelihood of data corruption during updates. That is, multiple separate entries no longer match each other. Furthermore, de-normalized tables tend to be more difficult to query than normalized tables, since each individual data record may be substantially larger, and hence take longer to search. This is even more so if the table is not properly indexed. However, since ad-hoc querying is not a substantial requirement, and table joins are not necessary, normalization enables database tables within active data cache 256 to be optimized for the efficient creation of pre-defined reports and alerts. In one embodiment, a single de-normalized table is the source for each report.
Active design process 290 is powerful, intuitive suite of applications that allow a user to create rules, map onto message queues, manage security, define data objects, and configure enterprise link 254 processes and sources, based on simple drag-and-drop operations for the data streams, reports, and alerts. In addition to active design process 290 in active data layer 241, there is a corresponding active design process client in client layer 142, such as a web browser. In one embodiment, active design process 290 comprises an application entitled architect. Unlike traditional real time business intelligence applications, active design process 290 allows a user to dynamically add new data sources, or create new transformations and reports, without changing the system as a whole. That is, unlike the NASDAQ stock trading example previously shown, which is not easily modified, active design process 290 can easily tailor the active data platform to new applications and changing corporate infrastructures.
Active report engine 274 converts the raw information in active data cache 256 into charts, tables, and graphs for display on a device in the client layer 142. Active studio 291 is a presentation editor that allows a user to easily create and format specific graphical and textual active views of data, based on pre-defined templates. Common views are tables, pie graphs, bar graphs, line graphs, scatter graphs, columnar reports, form reports, geographic (map) views, crosstabs, and Excel integration. For instance, a user can create an hourly report in which gambling customers are aggregated into different groups based on the value of their accumulated betting that day. The user selects a bar graph for the report, and changes the fill color and font type to the user's preference. These views can be substantially active, changing in near real time as the underlying data changes, or the can be static, like a printed report.
Event engine 257 monitors the information in active data cache 256 for pre-determined changes, or events. Once an event occurs, such as a rising temperature in a chemical processing plant, message center 272 is notified, subsequently forwarding the appropriate message to messaging client 115, thin client 114, or rich client 282.
In one embodiment, message center 272 tracks the presence of client devices, as well as the status of users themselves, in order to substantially assure message delivery. This is in contrast to traditional messaging systems that cannot determine if messages are, in fact, delivered to intended recipients. Presence determines if the device is available on the network. Status determines if the intended recipient is available to read and respond to the instant message. Common status categories include descriptive information, such as “out to lunch”, “busy”, “away from desk”, “important meeting”, etc. For instance, the device may be turned on and available, but the intended recipient is in an important meeting and does not wish to be disturbed. The intended recipient sets the status to “important meeting” in order to notify message center 272, as well as any other subscribed user, that he will probably not respond to the alert until after the meeting. Message center 272 would then choose an alternative available recipient, based on an established notification rule.
For example, a casino's active data platform attempts to notify the nearest pit boss of a particularly prolific gaming customer. However, since the pit boss has a “busy” status, the casino manager is alerted instead, and subsequently walks over to greet the customer.
Enterprise security system 258 represents a company's existing security infrastructure, such as Steel-Belted Radius by Funk Software. Since operational information may be sensitive, active data cache 256 can be integrated into enterprise security system 258. In this way users are authenticated before information is transmitted to client layer 142 devices.
Event engine 257 is further comprised of four logical components: event generator manager 428, rules manager 408, accountability manager 410, and actions manager 412. Event generator manager 428 maintains the state information of monitored events 402 for rules manager 408. Rules manager 408 is the primary event handler for the active data platform. Accountability manager 410 monitors the delivery status of all reports and alerts. And, actions manager 412 initiates actions based on input from the actions module 434 of the rules manager 408.
Event generator manager 428 maintains state information of monitored events 402 for rules manager 408. Constraint module 426 specifies the parameters that must be satisfied before evaluating an event and/or a condition and/or before applying the rule. Conditions module 424 maintains information for the corresponding conditions module 432 in rules manager 408. It further specifies attributes relevant to the specific event, other than constraints, which must be satisfied before the action associated with the rule may be taken. Events module 425 maintains event information for the corresponding events module 430 in rules manager 408.
Rules manager 408 further includes three components in order to manage active data: an events module 430, a conditions module 432, and an actions module 434. Events module 430 monitors all generated events 402 within the active data platform. Conditions module 432 filters out non-relevant events, and forwards the information to actions module 434, which in turn, initiates new system events based on criteria within rule sets 256. For example, all betting transactions are sent as events to event generator manager 428, which in turn sends the information to the events module 430 of rules manager 408. The conditions module 432 is configured to subsequently filter out all but the blackjack events. The actions module, based on rules 256, then creates an internal system event to instruct the active reports engine 274, as shown in
Accountability manager 410 monitors the delivery status of all reports and alerts. It further includes an unaccounted notifies module 438, and a report engine tie module 436. The unaccounted notifies module 438 maintains the status of undelivered alerts and reports. That is, unaccounted notifies module 438 determines if a recipient cannot be reached, subsequently forwards a delivery-incomplete message to rules manager 408. Report engine tie 436 monitors for successfully received reports and alerts, and subsequently forwards a delivery-complete message to rules manager 408. For example, a receipt notification status message is received in accountability manager 410, which is subsequently processed. If the receipt notification status message comprises an acknowledgment, report engine tie module 436 further processes the message and forwards the information to rules manager 408. However, if an acknowledgment is not received, unaccounted notifies module 438 processes the message and forwards the information to rules manager 408, which in turn allows active data cache to escalate alerts and reports to alternate recipients, based on status and presence, should the original recipient be unavailable.
Actions manager 412 initiates events and actions based upon input from the actions module 434. It further includes a notification module 416, a generate event module 414, a run a plan module 418, a web service/MQ module 420, and an others module 422. Notification module 416 forwards any report and alert non-delivery messages to unaccounted notifies module 438. Generate event module 414 generates system events initiated by actions module 434 in rules manager 408. Run a plan module 418 executes script based on rules 256. Web service/MQ module 420 provides an interface to third-party web-services based on WSDL (web-service description language), as well as message queue applications. Others module 422 is an API that allows additional modules to be later added.
Rich client 282 is comprised of a main application 536, a rendered reports 540 component, and a re-notify applet 506 component. Main application 536 provides the core environment for client interface to the active data cache 256. It comprises several functional components that can dynamically render incoming data streams from active data cache 256, and locally create reports, such as report builder 538. Rendered reports 540 functions as a viewer to display reports from active data cache 256 which already have been assembled. Re-notify applet 506 displays notification messages to the user.
Active data cache further comprises functional components that facilitate the generation of a report. These are: a report execution component 522, a view execution component 524, a report builder component 528, a rule builder component 530, a modifier builder component 532, data object builder component 534, a structured data supplier component 526, and a message center gateway 536.
Report execution 522 creates, caches, and then forwards specific reports based on configuration, to either rendered reports 540 for report builder 538. View execution 524 likewise creates and forwards views to report builder 538. Views are data objects that may be filtered. Report builder 528 pre-processes extracted information from multiple sources, and transforms the aggregated data into a format optimized for use in multiple reports. Rule builder 530 pre-processes stored rules from multiple rule caches for use in the generation of multiple reports. Modifier builder 532 pre-processes intermediate information transformations, such as additional metrics that the user wishes calculated and reported. Data object builder 534 pre-processes data objects into optimized formats for report execution component 522. Structured data supplier 526 forwards external pre-processed data to report builder 528.
API layer 605 provides a uniform application interface for system generated events, such as notification request 608, administration request 606, and presence request 604. Presence and notify component 612 provides the main messaging infrastructure for the active data platform. It insures that the reports and alerts are properly routed to intended recipients. Local user information 626 maintains a local cache of user profile information, such as names, passwords, and delivery preferences.
Rich client interface 614 is further coupled to rich client 282, which provides the user with enhanced visualization functionality, such as the capability to graphically render streaming data. Thin client interface 616 is coupled to thin client 112, which further comprises agent application 660. Since thin client 114 is commonly a browser without presence functionality, agent 660 notifies presence and notify component 612 that a given report or alert is being viewed. Agent 660 is commonly an Active X component or a java applet. Email interface 618 is further coupled to email server 632, such as an SMTP server, which forwards messages to email client 115 a. IM interface is further coupled to IM client manager 628 which sends a notification request 630 to IM client 115 b. Instant messaging (IM) is a means for sending small, simple messages that are delivered immediately to online users. It differs from email primarily in that its primary focus is immediate end-user delivery. Through an IM client application, a user can discover and immediately begin a text conversation, or chat session. Common public instant message systems include AOL Instant Messenger, MSN Messenger, Yahoo! Messenger, Microsoft Exchange 2000 IM, and Lotus Sametime.
For example, a casino's active data cache identifies particularly prolific gaming customer. The active data cache forwards a notification request 608 to message center 272. The presence & notify module 626 then determines if the intended user's device is present, and the user is available. If so, message center 272 forwards an alert through IM interface 620 to IM server 630, and finally to IM client 657.
Unlike like the prior art, the active data platform is general purpose, and is substantially customizable by entering new parameters in active design process 290 and the active studio 291, as shown is
Referring now to
The display is divided into three sections, a tab pane 701, a function pane 714, and a display pane 715. Tab pane 701 further allows the user to select one of various functional displays within active studio 304, such as: home 705, my reports 706, shared reports 707, personalize 708, and alerts 709. Home 705 comprises a summarized view of the user's most recent activities. My reports 706 comprises a summarized list of the user's created reports. Shared reports 707 comprises a summarized list of third-party reports to which the user has subscribed. Personalize 708 comprises administrative components that can allow the user to modify report delivery and display parameters. And alerts 709 comprises a summarized list of a user's active alerts.
Function pane 714 displays several functional list boxes within home 705 tab, such as: recent list box 710, new list box 711, list toolbox 712, and actions list box 713. Recent list box 710 displays the user's most recently accessed reports. The new list box 711 displays the user's new reports. The alerts list box 712 displays the user's currently active alerts. And the actions list box 713 allows the user to create and edit reports. Display pane 715 displays the corresponding result of the chose function of function pane 714. In this case, a dynamic financial report comprising a cost bar graph and a percentage change line graph. For example, if a user where to select intraday sales by region in the new list box 711, the corresponding dynamic intraday sales report would be displayed in display pane 715. As sales are booked through out the day, the sales chart would dynamically change as well.
Referring now to
Referring now to
Referring now to
Referring now to
In another aspect of the invention, an Iteration instant messaging & collaboration server is advantageously employed to enable rich secure graphical collaboration in an instant messaging environment. Instant messaging systems commonly monitor the presence of devices, and availability state of users. Presence determines if the IM device is coupled to the given IM network, or at least reachable from the client. Status determines if the intended recipient is available to read and respond to the instant message. Common status categories also include descriptive information, such as “out to lunch”, “busy”, “away from desk”, “important meeting”, etc. For instance, the IM device may be turned on and available, but the user is in an important meeting and does not wish to be disturbed. The user would set the status to “important meeting,” in order to notify other subscribed IM users that he will probably not respond to a text message until after the meeting.
These IM systems, however, commonly lack the capability for graphical peer-to-peer or multi-party collaboration. That is, while short text messages can be sent back and forth in an online chat meeting, there is no comparable means for sharing a graph or report. This would normally have to be compressed and transmitted ahead of time to each recipient, who would each then download, de-compress, and locally store the file. In situations where the underlying data is continuously changing, as temperatures would be in a chemical plant, and impromptu collaboration is desired, pre-mailing a graph would be very impractical, inefficient, and of marginal use to the problem at hand.
Furthermore, public IM systems are not particularly secure. They were originally designed for rapid information text conversations, called chat. IM protocols emerged and were established primarily without supervision from any standard bodies, such as the Internet Engineering Task Force. Subsequently, security was never originally considered and common instant messaging traffic is essentially unencrypted. Just about anyone on the network can secretly monitor a chat conversation.
User manager 811 manages user profile information. Users create profiles based on rules, in which they describe events of which they want to be notified. Should such an event occur, user manager 811 notifies message center 272, which in turn contacts the user. Furthermore, user manager 811 selects alternative recipients, if the primary recipient is unavailable, based on user preference and availability status. For instance, user #1 has configured user manger 811 for notification of a specific event, for example a temperature change beyond a certain range. Furthermore, user #1 also wants user #2 to be notified should user #1 be unavailable. Once the event occurs, if user #1 is unavailable, message center 272 attempts to notify user #2. Presence manager 813 monitors for the availability of user devices on the network. For instance, in the previous example, user #1 has a wireless PDA and a SMS phone. If the event occurs, and the PDA is turned-off, an alert is sent to the SMS phone instead.
IIM (Iteration instant messenger) interface 806 provides an interface to the IIM client 819-823, an enhanced IM application that allows secure concurrent graphical collaboration and pen-based user input. In general, it is sometimes desirable to implement private instant messaging systems having enhanced capability (including different protocols, encryption capabilities, graphical processing/display capabilities, I/O capabilities, and/or the like) compared to public messaging systems (such as those available from Yahoo™, AOL™, and the like). IIM client is an example of a client in such a private instant messaging system.
IIM client 819-823 commonly connect through active collaboration server 817, which marshals collaboration request from multiple IIM clients, and combines connections whenever possible to improve overall system performance and scalability. Furthermore, active collaboration server 817 synchronizes the text and graphical portions of the IIM session to insure that all users view the same information at substantially the same time.
Active collaboration server 817 further enforces security protocols as implemented by the IIM client, in order to prevent unauthorized interception of the collaboration session. In one embodiment, IIM client 819-823 implements a Triple DES security protocol to protect the collaboration session and insure message integrity. Triple DES is an encryption algorithm whose security is based on a single secret key. Each key is generated (selected at random from all possible keys) for each particular collaboration session.
In another embodiment, only one user in an IIM collaboration session needs authorization to access a given alert or report. By virtue of being authenticated to the session, all other users will receive the alert or report with the security privileges of authorized user, for as long as these users participate in the session.
In addition to IIM interface 806, there is SMTP interface 807 and other IM interface 809. SMTP, or simple mail transfer protocol, is the most common protocol for sending email message on the internet. Through SMTP interface 807, message center 272 can forward email notifications with the event information to email server 815. Unlike IIM client 819-823, however, notification is not automatic. The user must first log onto mail server 815 with a SMTP client 827, such as MS Outlook and download the messages. Likewise, other IM interface 809 represents traditional IM interfaces to currently available IM systems 831, such as AOL Instant Messenger, MSN Messenger, Yahoo! Messenger, Microsoft Exchange 2000 IM, and Lotus Sametime. In contrast to SMTP, notification can be automatic, although communication is generally insecure. Furthermore, graphical collaboration is difficult.
For example, user #1 is a chemical engineer at a petroleum processing plant. He created a profile in user manager 811, in which he wants to be notified of specific event, such as a change in a process temperature beyond a certain range. The event occurs. Message center 272 forwards the notification to active collaboration server 817, through IIM interface 806. Seeing the temperature dynamically change on his device, user #1 realizes that he wants additional advice from user #2, his manager. Through his IIM device, he instructs message center 272 to initiate a request for collaboration with user #2. Receiving a collaboration request from his subordinate, user #2 accepts the connection. User #1's display is immediately rendered on User 2's device, upon which they collaborate on the matter at hand.
For example, user #1 is a network systems engineer monitoring traffic at a company's e-commerce web site. When network congestion reaches a certain point, active report engine 274 generates a report and forwards it to user #1. Realizing that customers are starting to have difficulty placing online orders, user #1 initiates a connection with user #2, the web site manager, and user #3, the customer service manager. Once both accept, user #1's display is immediately rendered on the other devices, upon which all can collaborate on the mater at hand.
In another embodiment, an instant messaging manager is advantageously employed to rapidly alert intended recipients of data events. Referring to
Rules-based monitoring engine 916 monitors the applications in enterprise systems 902 for pre-defined events. A rule is s pre-defined procedure comprising the event(s) to be monitored, and the subsequent action or transformation that is required. For example, the event can be a specific transaction, a change in a file size, the publishing of a report, etc. Rules U/I 920 is typically graphical application that allows a user to create sophisticated and complex rules, as well as store the rules in the rules db 918 for use by rules based monitoring engine 916. In this case, the subsequent action is an alert.
When a specific event occurs, rules-based monitoring engine 916 forwards an alert to notification engine 924 a, which properly formats the alert and transmits it via email system 915 a, pager system 915 b, or another system through proprietary API 915 c. Alerts sent to email system 915 a can further contain an embedded link to a report generated by active reports engine 274, as shown if
For example, betting transactions would be normally stored in a casino's game transaction system. Wanting to be extra-attentive to high-rollers, a casino would configure the rules based monitoring engine 916 to observe for any customer whose betting exceeds a specified threshold, upon which an alert would be sent to the closest pit boss with an embedded link to the customer record.
Instant messaging manager 924 b properly formats the alert as an instant message and transmits to the intended recipient through on of the various instant message systems 915 d-f. Unlike notification engine 924 a, however, instant messaging manager 924 b also monitors the various instant message systems 915 d-f for changes in state for any subscribed users. State is comprises of presence and status. Presence determines if the IM device is coupled to the given IM network, or at least reachable from the client. The given instant message system 915 d-f normally determines the presence of individual IM clients, and broadcast the information to interested parties, such as the instant messaging manager 924 b. Status determines if the intended recipient is able to read and respond to the instant message. Normally whether a recipient is available or not is a true or false question. However, it is common for recipients to customize the unavailable status with further descriptive information, such as “out to lunch”, “busy”, “away from desk”, “important meeting”, etc.
For instance, the IM device can be turned on and available, but the user is in an important meeting and does not wish to be disturbed. The user can set the status to “important meeting” notifying any other subscribed users that he will probably not be able to respond to the instant message until after the meeting. The rules-based monitoring engine 916, realizing that the user will not immediately read the instant message, will choose an alternative present and available user based on a pre-determined notification rule. Rules-based monitoring engine 916 can forward an alert to instant messaging manager 924 b for immediate delivery to the intended recipient.
Referring now to
In another embodiment, an event engine is advantageously employed to substantially assure the examination of a report by a user. Many analytical products such as business intelligence (BI) and online analytical processing (OLAP) systems are capable of monitoring, scheduling, and broadcasting alerts via email or pager. These systems, however, cannot generally assure that the intended recipient promptly receives and reads the message. This presents a significant problem for time-sensitive information, where minutes or even seconds can make a difference.
In the current invention, the event engine monitors the state of transmitted alerts in an escalation table. Upon receipt of an alert, the user reviews the received report. This is commonly done by manually browsing for the report, or by clicking an embedded URL contained within the alert. If the user does not review the report within a specified time, the escalation table can further escalate the alert to another user based upon predefined rules. For instance, the alert is transmitted to the user's manager.
Enterprise data 140 comprises those enterprise systems that manage a company's basic transactions, such as order entry and billing systems. Active data cache 256 monitors transaction data packets 1104 generated by enterprise data 140. Active data cache 256 further comprises user data manager 1108, which describes user event interest, and monitoring rule manager 1111, that analyzes data packet 1104 for specific events.
Should an event of interest occur, monitoring rule manager 111 forwards a rule fired message 1116 to the rules list manager 1120 of event engine 257. Rules list manager 1120 further comprises the subsequent actions required for the fired rule, such as the transmission of a notification message to a user, the execution of a subsequent rule, or the generation of an accountability escalation event. In this case, notification message 1130 is forwarded to message center 272. Rules list manager 1120 also places an entry into escalation table 1120, describing notification message 1130, the intended recipient, and the time the message was sent. If a report viewed message 1176 is not received within a pre-determined amount of time, a timeout occurs, and escalation table 1122 notifies escalation manager 1138, which in turn executes pre-configured escalation rules, such as notification of a different person or entity, or the calling of a web service.
Upon receiving notification message 1130, user address manager 1142 attempts to find a device address at which the user is currently available. Message center 272 further embeds a link in notification message 1146, through which the user can review the corresponding report from active reports engine 274.
The user subsequently receives notification message 1146 on his device, in this case, through a browser. If not already viewing the report, the user can either locate the report by manually entering information such as a URL, or can also simply click on an embedded link to the report.
Upon receiving a request, report supplier 1168 of report engine 274, generates the report from information in the active reports table 1170, and forwards it to user device 1150. A report viewed message 1176 is also generated and forwarded to escalation table 1122, which in turn deactivates the previous notification message entry.
For example, a large multi-site manufacturing organization, such as Ford Motor Company, would configure the active data platform to monitor manufacturing processing information, such as increasing part reject rates, or outright machine failures. Should a machine failure actually occur, an alert is forwarded to the appropriate manufacturing process engineer. The alert would contain an embedded link to the specific machine's status report, as generated by active reports engine 274. If the process engineer did not review the report within a few minutes (or any time period specified), a new alert would be immediately forwarded to the local plant manager for immediate action.
In accordance with one aspect of the present invention, rule evaluation is advantageously distributed in order to improve efficiency. To further elaborate, a rule often comprises multiple interdependent components (i.e., event, constraint, condition, and action) that must be evaluated and acted upon.
The first component of a rule is the event, which specifies the event of interest. An example of an event is when the sales volume exceeds 5,000 units. If the sales volume exceeds 5,000 units, the event component is satisfied.
The second component of a rule is the constraint, which specifies the parameters that must be satisfied before evaluating an event and/or a condition and/or before applying the rule. A constraint is usually provided for efficiency reason and commonly comprises dates, times, and/or frequencies. For instance, if the specific event described in the event clause (e.g., sales volume in the previous example) does not need to be monitored over the weekend or between certain times or more often than a given frequency, then the constraint clause would instruct the event engine to that effect. Typically a constraint is evaluated to be either true or false. In one embodiment, if the constraint is evaluated to be false by the event engine, the satellite evaluation engine is informed accordingly and does not even need to spend its resources evaluating the event. Advantageously, efficiency is improved.
The third component of a rule is the condition, which further specifies other attributes relevant to the specific event, which attributes must be satisfied before the action associated with the rule may be taken. In the previous example, the condition may be to take action only if the sales volume that fires the event is achieved without any special promotion in place. Generally speaking, all conditions may be thought of as events but not all events are conditions.
The fourth component of a rule is the action, which determines the course of action taken should the event, constraint and/or condition components are satisfied. For instance, the sending of a notification to a specific person may be an action that needs to be taken if, as in the previous example, during a weekday (constraint satisfied), the sales volume exceeds 5,000 units (event satisfied) and the sales volume is achieved without any special promotion in place (condition satisfied).
It should be noted that a rule typically includes an action but a rule does not require all three other components, i.e., event, condition, and constraint. A rule may have one, two, or three of these components as desired by the rule designer. Furthermore, each of the event, condition, constraint, and action components may be a complex Boolean operation comprising multiple sub-components. A preferred embodiment, however, is a single event component per rule.
For example, an event may be satisfied if sales volume is greater than 5,000 and the total revenue is greater than $10,000 (a Boolean operation of two sub-events).
In order to reduce design complexity, a common solution has been to evaluate and execute these rules in a centralized event engine. It is found, however, that the information that needs to be monitored and evaluated can be found anywhere on the enterprise network. It is often the case that the information that must be monitored and evaluated (e.g., the event or condition) may be distributed in one or more machines (such as servers) remote from the computer executing the centralized event engine. In some cases, only 5% of the information may be relevant to a particular rule. Yet when the rule evaluation is centralized, all the data that needs to be monitored and evaluated must be transmitted across machine and/or process boundaries for the centralized event engine to perform its rule evaluation task. In a networked environment, the remaining 95% of the information that is needlessly sent represents an inefficient use of scarce network resources and bandwidth, as well as a detriment to performance.
In accordance with one embodiment of the invention, rule evaluation is distributed in one or more satellite evaluation engines local to or closer to the origin of the monitored information. The evaluation is distributed in satellite evaluation engines that are in communication with an event engine. Distributed rule evaluation allows the evaluation of a rule to take place with reduced bandwidth usage and delay. Since active data and the timely report/notification responsive to active data are important aspects of the active data platform, minimizing delay is an important consideration, and the distributed evaluation mechanism substantially furthers that goal.
To facilitate the implementation of distributed rule evaluation, it is highly preferable that a universal rule syntax be developed that allows the event engine to analyze any given rule and decides which portion of the rule should be distributed and which portion of the rule should be processed by the centralized event engine.
In accordance with one embodiment of the invention, a rule syntax is developed in which the four components of a rule (event, constraint, condition, action) are specified as clauses in a specific order to facilitate parsing.
For example, the following is a simplified example of a rule that may be executed:
In accordance with one embodiment of the present invention, a rule is parsed to one or more core events, which are then distributed to one or more appropriate satellite evaluation engines to facilitate evaluation of the distributed event(s). In the previous example, the rule may be parsed and the event pertaining to the sales volume may be distributed to, for example, the satellite evaluation engine associated with the active data cache. The satellite evaluation engine then evaluates the monitored data (sales volume in this example) and communicates the result (which may be simply true/false or may include pertinent sales volume data) back to the event engine. Meanwhile, the event engine is offloaded from the task of handling that rule until the event is satisfied.
To further improve efficiency, the centralized event engine may not even parse all components of a rule until the event is satisfied. Thus, if an event is never satisfied, no resource has been wasted parsing the entire rule and preparing the centralized event engine and/or the satellite evaluation engine(s) to handle the other components (which may never need to be handled if the event is never satisfied). Further, the satellite evaluation engine may only send information back to the event engine if the event evaluates to be true. Thus, if the sales volume is below 5,000 in the previous example, no message is sent from the satellite evaluation engine to advantageously avoid wasting bandwidth. Of course, as mentioned earlier, the evaluation of an event may be held off by the satellite evaluation engine to further avoid wasting resource unless the constraint is evaluated to be true by the centralized event monitor.
If the event is evaluated to be true at the satellite evaluation engine (and assuming any applicable constraint is also evaluated to be true), the satellite evaluation engine informs the centralized event engine, which may then evaluate the condition using either the same or another satellite evaluation engine or using the centralized resource. If the same or a different satellite evaluation engine is also used to evaluate a condition, the event monitor may send out the parsed condition and ask for the result of the evaluation of the condition. As the exemplary syntax above indicates, each of the event, constraint, condition, and action may be (but not required in all cases) implemented as a function. Distributing rule evaluation thus may comprise using the appropriate satellite evaluation engine to make the required function call.
Satellite evaluation engines 1036 a-1036 h are some exemplary satellite evaluation engines employed by the active data platform of
In accordance with another embodiment of the present invention, there is provided a universal function call syntax to facilitate the task of distributing certain aspects of rule evaluation to one or more satellite evaluation engines. As discussed above, the rule syntax allows an event, a constraint, a condition, or an action to be specified as a function. Thus, the function call syntax may have the following construct:
By creating a universal function call syntax, the invention substantially simplifies the task of specifying that a particular satellite evaluation engine should handle a particular event or condition. Furthermore, the function syntax improves scalability in that when a new satellite evaluation engine is added to the system, only the satellite evaluation engine name needs to be changed and the remainder of the syntax may be reused. Also, if a new event or condition is specified vis-ŕ-vis an existing satellite evaluation engine, only the function name needs to be changed.
In one embodiment, a rule template library may be provided to allow users to leverage on work done by others. A rule template is simply a rule with certain argument(s) not completely specified. For example, a rule template may specify that if the sales volume exceeds 5,000 on a weekday and no special promotion is involved then notify person X. In this case, person X represents the argument that remains to be filled out to turn the rule template into a rule instance. In this example, the filling out of the person may be automatically accomplished by filling in the missing argument with the identity of the user accessing the rule template. In other cases, the missing arguments may be filled out by the user wishing to employ the rule template.
Of course the user can always edit existing rules (i.e., complete rule instances) to fit his needs. For example, the user can access an existing report and edit the rules therein to modify the arguments related to the event, condition, constraint, and/or action so that the newly created report would contain the information needed. The universal rule syntax renders it simple to implement rule templates and makes it easy for users to convert a rule template to a rule instance or to modify an existing rule to fit his needs.
In another aspect of the current invention, an active data architecture is advantageously employed to maintain application execution over an intermittent network connection. In one embodiment, the intermittent network connection is a wireless network, such as 802.11b. In another embodiment, the intermittent network connection is a wired network, such as Ethernet. In another embodiment, the data transmitted on the intermittent network connection is XML. In another embodiment, the data transmitted on the intermittent network connection is DHTML.
Modern data networks, such as the Internet, allow packets to arrive at their destination by multiple paths. However, since different portions of the network may be congested to different degrees, transmitted packets can sporadically arrive. Should the arrival delay between successive packets become sufficiently long, an intermittent connection results. Furthermore, in wireless networks, an intermittent network connection may also be caused by ambient radio interference, or by dead pockets, caused by multi-path. Multi-path is interference caused when signals bounce around between obstructions, creating multiple reflections of the same signal. Small changes in the spatial relationship between the transmitter and the receiver (i.e., by walking around) can substantially alter the extent of multi-path interference, and the subsequent degree of network connection intermittence.
For many applications, such as static web pages, an intermittent network connection is tolerable. Though potentially bothersome to a user, the utility of the web page is generally not diminished by the waiting a few minutes. For others, such as streaming applications, an intermittent network connection is problematic. These applications may require a continuous supply of packets in order to properly function, since they are generally designed to receive, buffer, render, and discard packets over a period of time. And although buffering a surplus of packets may improve perceived latency, upon depletion, the streaming application can freeze and even drop the connection altogether. Since this often requires the connection to be actively reestablished, should a user be subsequently preoccupied, reestablishment of the connection could be substantially delayed. Furthermore, in situations where the streaming information may be both urgent and dynamic, such as with active data, an opportunity for the user to react may be entirely lost.
Active studio 291 is further comprised of communications browser window coupled to a rendering browser window, wherein the communications browser window maintains the connection, and the rendering browser window renders the received data stream. In one embodiment of the present invention, a first rendering browser window establishes the connection by rendering an initial web page. The rendering browser window, in turn, instantiates a second communications browser window to receive and then forward updates to the rendering browser window. However, unlike in a common web page, the communications browser window maintains an open connection, never fully receiving the web page from the web server (e.g. since periodic active data updates are being received). Should the connection be interrupted (generating a JScript onload event), the communications browser may automatically attempt to reestablish the connection, and reload the web page again.
The functional components shown in
The process would again be repeated for the next chunk of data. That is, active studio 291 requests the next segment of data, or a chunk, from active reports server 274 at step 1520 (GetChangeList (Viewset ID, chunk_index=1)). Active reports server 274, in turn, forwards the request at step 1522 to report cache 1404. Report cache 1404 then determines if it contains the requested chunk of data at step 1524 (Check if cache (1)). Chunk 1 is not available in the cache, since it is the first time that the chunk has been requested. Report cache 1404, in turn, forwards the request at step 1526 to active data cache 256. Active data cache 256 generates the chunk and forwards it back to report cache 1404 at step 1528 (Active Data XML Chunk (1)). Report cache 1404 forwards the chunk to active reports server 274 at step 1530, as well as maintaining a local cached copy at step 1529 (Persist (1)). Active Reports server 274, in turn, forwards the chunk to active studio 291 at step 1532. The process would again be repeated for the next chunk of data.
At this point, however, the connection is interrupted and subsequently reestablished at step 1519. The last chunk that was received is once again requested at step 1540, (GetChangeList (Viewset ID, chunk_index=0)). Active reports server 274, in turn, forwards the request at step 1542 to report cache 1404. Report cache 1404 then determines if it contains the requested segment of data at step 1544 (Check if cache (0)). In this instance, since the chunk had previously been requested, a copy has been cached. Report cache 1404, in turn, resends the chunk to active reports server 274 at step 1546. Active Reports server 274, in turn, forwards the chunk to active studio 291 at step 1548, passively completing the request.
In another aspect of the current invention, a browser can natively print a report in a substantially WSYIWIG format. The pervasiveness of browser technology has simplified the deployment enterprise software applications. Instead of mandating the installation of proprietary clients, which often can be costly to implement and frustrating to use, users can access the same enterprise applications through common Internet browsers, such as Netscape Navigator or Microsoft Internet Explorer. And in the case of Explorer, the browser is further integrated into the underlying operating system, requiring no additional installation.
Traditionally, web pages were designed to be viewed on many different platforms, from text-only terminals, to Macintoshes, to handheld computers. Since there was no way to know how the web page would be displayed (i.e., availability of fonts, ability to render images, etc.) the browser was designed to optimize the web page structure into a format that its host computer is equipped to display. In practice, it was therefore entirely possible for the web page to render differently on the screen of its reader than it did on the screen of its author. Furthermore, since the browser was primarily concerned with rendering the web page, and not in printing it, browser printed output was often problematic. For simple or small web pages, this was not necessarily a problem, since the entire rendered web page could be printed on a single printed page. However, the columnar or tabular reports generated by enterprise applications often would often span multiple printed pages.
Unlike modern word-processors, such as Microsoft Word, browsers do not generally print WYSIWYG (“What You See Is What You Get”). That is, web pages may be rendered without respect to the selected printer. Printing a web page generally causes the appropriate printer driver to map the rendered web page display to each printed page. However, the appearance of the printed page is generally dependent on client configuration (i.e., screen resolution, margin settings, paper size, paper orientation, type of printer, etc.). Since the web page was not originally rendered with the printer limitations in mind, as would be the case with a word processor, portions of the web page may be unexpectedly chopped off.
Furthermore, since printer drivers generally understand only the displayed screen pixels and not data objects, such as text or figures, portions of the rendered web page will either be lost (if they exceed the page's printable width), or printed on the following page (if they exceed the page's printable length). The result is text or figures that are split across a printed page boundary. And, unlike a word processor, navigation bars and sidebars will be printed as well. Any page breaks and frame boundaries, created by the web page designer, will also cause the print driver to forward subsequent pixels to the following page.
A possible solution is to copy the rendered data into a WYSIWYG application, like Microsoft Word, and then print. Simply copying, however, is problematic since it can be both time-consuming and error-prone. In the process of pasting data from the browser into the application, original formatting may be lost. And although text in paragraph form will simply wrap, remaining readable, tables and columns may transfer misaligned, causing information from one column or cell to appear to be in another. Careful error checking may therefore be required to insure data integrity. For particularly large reports, this may require several hours of work, creating a printing disincentive, and hence reducing the effectiveness of the enterprise application as a whole.
Another possible solution is for the web server to generate the web-page in a proprietary WYSIWYG format, such as in Microsoft Word or Adobe Acrobat. This, too, can be problematic since it requires the installation of a third party application which may further increase cost and complexity, or may not be available for a given client device. The browser, in essence, again becomes a proprietary client. Furthermore, the use of a proprietary format may also produce large documents, substantially increasing download latency.
Yet a third solution may be for the web server to provide a link for a separate printer friendly web page. Such a page would leave out navigation bars and sidebar information. A single web page, however, can be very large, again increasing download latency. Furthermore, printer friendly usually refers to the web page's printable width, and not its printable length. Since there is generally no way for the web server to discover the local client's configuration settings, figures and text may still be split across two printed page boundaries.
A more optimum solution may be to provide functionality that allows the browser to natively print active reports in a substantially WSYIWIG format. The active data architecture comprises two general types of reports: continuous columnar and tiled. Continuous columnar reports are comparable to common accounting spreadsheets in that they usually have column and report titles, as well as aggregate cells (i.e., subtotals, sums, etc.). These reports generally summarize or analyze some aspect of the underlying data, and are generally intended to be printed out in total. Tiled reports, by comparison, are more comparable to Microsoft PowerPoint slides. They can simultaneously comprise both lists (i.e., a sequential list of text and numbers without aggregates) and graphical display objects (i.e., charts, graphs, office web components, etc.). Furthermore, the tiled reports are optimized to allow the user to select and print just the relevant portion of the list.
Referring now to
Since transferring large web pages can be slow, the current invention transmits the continuous columnar report to the client browser in a series of smaller frames, each optimized to reduce latency. These frames are then rendered in separate independent browser windows, which are contiguously positioned without frame borders, to give the impression of a single large web page. The first frame, slightly larger than the display window, would generally render relatively quickly, creating the perception that the entire web page has arrived (since the hourglass is no longer visible), although subsequent frames may still be rendering. However, once the user manually scrolls down from the first frame, subsequent frames should have substantially rendered.
In this example, two frames are displayed, a first frame 1612 and a second frame 1616. The first frame 1612 has thirty lines (F1-L1 to F1-L30), while the second frame 1616 also has thirty lines, although only two lines (beginning at F2-L1) are displayed for purposes of illustration. The each line is further comprised of cells which may further include display elements (i.e., active data elements, aggregate elements, report titles, header text, footer text, etc.) contiguously arranged. Since the first frame 1612 is larger than display pane 1606, both vertically and horizontally, a user would subsequently need to use the scroll bars to see the hidden portions of the frame.
Active reports, unlike normally rendered web pages, can further be manipulated and customized by the users when in edit or print preview mode. For instance, columns can be re-sized (both width and height), re-positioned (swapping one column with another), and re-formatted (font type, font size, line borders, background color, etc). Function pane 714 further displays several functional list boxes within home 705 tab, such as actions list box 1609 which further comprises a print function 1611 (which allows the user to print the rendered report) and a print boundaries function 1610.
In traditional browser printing, printer output can be previewed by using the browser's print preview function. This function takes computer and printer configuration information (i.e., such as page size, orientation, margins, etc.), calculates the total amount of screen pixels that can fit on a printed page, and renders a static picture of that page in a new print preview window. As previous discussed, portions of the web page beyond the print boundaries will be chopped off. Any portion of the web page exceeding the printed page width will be completely lost, while any portion exceeding the printed height will be printed on the next page, potentially splitting text and figures between two contiguous pages. Furthermore, since the print preview window is essentially a static snapshot, the user is generally unable to manipulate elements on the page to fit within the displayed print boundaries.
In a non-obvious fashion, print boundaries function 1610 superimposes a set of non-printable guides 1608 identifying the printable areas of the columnar report, as rendered in display pane 715. Vertical row positioning can be further optimized to insuring that a page break does not occur in the middle of a row. Furthermore, unlike the traditional static print preview window, the user can manipulate the rendered report to fit within the displayed guides, allowing the active report to be printed in a substantially WYSIWYG manner. That is, users can both re-sized and re-positioned columns, as well as re-formatted font types and sizes.
Referring now to
Depending on the set of rows selected, there are four possible situations that must be addressed. The first test determines if the FVR and the LVR are both within the parent frame at step 1764. If so, the rows above the FVR and below the LVR in the parent frame are hidden, at step 1772. If not, a second test determines if the FVR is in the parent frame and the LVR is in a child frame, step 1766. If so, the rows above the FVR in the parent frame, and the rows below the LVR in the child frame, are hidden at step 1774. If not, a third test determines if the FVR and the LVR are in the same child frame at step 1768. If so, the rows above the FVR and below the LVR are hidden in the child frame at step 1776. If not, a final test determines if the FVR is in a first child frame and the LVR is in a second child frame, at step 1770. If so, the rows above the FVR in the first child frame, and the rows below the LVR in the second child frame, are hidden at step 1778. At this stage, the remaining frames are hidden, at step 1780. Since the remaining visible rows fit within the printed page, the vertical scroll bar also disappears. The titled report is forwarded to the printer, at step 1780. At this point, all rows that were previously hidden are made visible, returning the vertical scroll bar, at step 1782.
Referring now to
Referring now to
While this invention has been described in terms of several preferred embodiments, there are alterations, permutations, and equivalents which fall within the scope of this invention. For example, although reference is given to Sagent Business Intelligence Solutions, it should be understood that the invention can also integrate with other business intelligence and ETL solutions. It should also be noted that there are many alternative ways of implementing the apparatuses of the present invention. It is therefore intended that the following appended claims be interpreted as including all such alterations, permutations, and equivalents as fall within the true spirit and scope of the present invention.
Advantages of the invention include optimizing the presence-aware delivery of relevant information a device in a timely manner, and rendered in a dynamic format. Additional advantages include the continuous extraction of information from data sources without the need for manual queries, or the need of additional user training.
Having disclosed exemplary embodiments and the best mode, modifications and variations may be made to the disclosed embodiments while remaining within the subject and spirit of the invention as defined by the following claims.
|Cited Patent||Filing date||Publication date||Applicant||Title|
|US5010478||2 Aug 1989||23 Apr 1991||Deran Roger L||Entity-attribute value database system with inverse attribute for selectively relating two different entities|
|US5033009||3 Mar 1989||16 Jul 1991||Dubnoff Steven J||System for generating worksheet files for electronic spreadsheets|
|US5283894||11 Apr 1991||1 Feb 1994||Deran Roger L||Lockless concurrent B-tree index meta access method for cached nodes|
|US5510980||27 Jun 1994||23 Apr 1996||Microsoft Corporation||Method and system for selecting and executing arithmetic functions and the like|
|US5553215||21 Sep 1994||3 Sep 1996||Microsoft Corporation||Method and system of sharing common formulas in a spreadsheet program and of adjusting the same to conform with editing operations|
|US5592608||15 Oct 1993||7 Jan 1997||Xerox Corporation||Interactively producing indices into image and gesture-based data using unrecognized graphical objects|
|US5615362||22 Mar 1995||25 Mar 1997||Persistence Software, Inc.||Method and apparatus for managing relational data in an object cache|
|US5654726||26 May 1994||5 Aug 1997||International Business Machines Corporation||Screen display sharing system|
|US5717895||1 Dec 1994||10 Feb 1998||Cray Research, Inc.||Associative scalar data cache with write-through capabilities for a vector processor|
|US5721847||3 Feb 1997||24 Feb 1998||Microsoft Corporation||Method and system for linking controls with cells of a spreadsheet|
|US5754774||15 Feb 1996||19 May 1998||International Business Machine Corp.||Client/server communication system|
|US5765164||21 Dec 1995||9 Jun 1998||Intel Corporation||Apparatus and method for management of discontinuous segments of multiple audio, video, and data streams|
|US5778372||18 Apr 1996||7 Jul 1998||Microsoft Corporation||Remote retrieval and display management of electronic document with incorporated images|
|US5781911||10 Sep 1996||14 Jul 1998||D2K, Incorporated||Integrated system and method of data warehousing and delivery|
|US5784275||23 Sep 1996||21 Jul 1998||National Instruments Corporation||System and method for performing interface independent virtual instrumentation functions in a graphical data flow program|
|US5787409||17 May 1996||28 Jul 1998||International Business Machines Corporation||Dynamic monitoring architecture|
|US5809267||18 Mar 1996||15 Sep 1998||Xerox Corporation||Apparatus and method for executing multiple-concatenated command gestures in a gesture based input system|
|US5812840||26 Sep 1996||22 Sep 1998||Speedware Ltee./Ltd.||Database query system|
|US5831609||6 Jun 1995||3 Nov 1998||Exodus Technologies, Inc.||Method and system for dynamic translation between different graphical user interface systems|
|US5831615||30 Apr 1996||3 Nov 1998||Intel Corporation||Method and apparatus for redrawing transparent windows|
|US5857201||18 Jun 1996||5 Jan 1999||Wright Strategies, Inc.||Enterprise connectivity to handheld devices|
|US5862325||27 Sep 1996||19 Jan 1999||Intermind Corporation||Computer-based communication system and method using metadata defining a control structure|
|US5864669||11 Jul 1996||26 Jan 1999||Microsoft Corporation||Method and system for accessing a particular instantiation of a server process|
|US5890174||16 Nov 1995||30 Mar 1999||Microsoft Corporation||Method and system for constructing a formula in a spreadsheet|
|US5893126||12 Aug 1996||6 Apr 1999||Intel Corporation||Method and apparatus for annotating a computer document incorporating sound|
|US5893150||1 Jul 1996||6 Apr 1999||Sun Microsystems, Inc.||Efficient allocation of cache memory space in a computer system|
|US5898434||22 Aug 1994||27 Apr 1999||Apple Computer, Inc.||User interface system having programmable user interface elements|
|US5918009||25 Apr 1997||29 Jun 1999||Lucent Technologies Inc.||Technique for sharing information on world wide web|
|US5922044||12 Jun 1997||13 Jul 1999||3Com Corporation||System and method for providing information to applets in a virtual machine|
|US5926177||17 Oct 1997||20 Jul 1999||International Business Machines Corporation||Providing multiple views in a model-view-controller architecture|
|US5928327||8 Aug 1996||27 Jul 1999||Wang; Pong-Sheng||System and process for delivering digital data on demand|
|US5930794||26 Nov 1996||27 Jul 1999||Sagent Technologies, Inc.||Database repository with deferred transactions|
|US5943620||9 Dec 1996||24 Aug 1999||Ericsson Inc.||Method for associating one directory number with two mobile stations within a mobile telecommunications network|
|US5974236||17 Aug 1995||26 Oct 1999||Aes Corporation||Dynamically reconfigurable communications network and method|
|US6023694||29 Jun 1998||8 Feb 2000||Timeline, Inc.||Data retrieval method and apparatus with multiple source capability|
|US6025844||27 Aug 1997||15 Feb 2000||Netscape Communications Corporation||Method and system for creating dynamic link views|
|US6035324 *||28 Aug 1997||7 Mar 2000||International Business Machines Corporation||Client-side asynchronous form management|
|US6038558||17 Oct 1997||14 Mar 2000||Sagent Technology, Inc.||Extensible database retrieval and viewing architecture|
|US6055548||3 Jun 1996||25 Apr 2000||Microsoft Corporation||Computerized spreadsheet with auto-calculator|
|US6070197||12 Aug 1997||30 May 2000||International Business Machines Corporation||Object oriented transaction monitor for distributed transaction processing environments|
|US6073242||19 Mar 1998||6 Jun 2000||Agorics, Inc.||Electronic authority server|
|US6075530||17 Apr 1997||13 Jun 2000||Maya Design Group||Computer system and method for analyzing information using one or more visualization frames|
|US6088481||30 Jun 1995||11 Jul 2000||Sanyo Electric Co., Ltd.||Handwritten character input device allowing input of handwritten characters to arbitrary application program|
|US6092102||24 Oct 1997||18 Jul 2000||University Of Pittsburgh Of The Commonwealth System Of Higher Education||System and method for notifying users about information or events of an enterprise|
|US6094681||31 Mar 1998||25 Jul 2000||Siemens Information And Communication Networks, Inc.||Apparatus and method for automated event notification|
|US6112236||21 Nov 1996||29 Aug 2000||Hewlett-Packard Company||Method and apparatus for making quality of service measurements on a connection across a network|
|US6141659||12 May 1998||31 Oct 2000||International Businss Machines Corporation||Systems, methods and computer program products for retrieving documents from multiple document servers via a single client session|
|US6170019 *||10 Dec 1997||2 Jan 2001||Siemens Aktiengesellschaft||Means system and method for operating an apparatus|
|US6175859||28 Oct 1998||16 Jan 2001||Avaya Technology Corp.||Sender-defined time for reporting on the status of a sent message or of the message's recipient|
|US6182116||14 Sep 1998||30 Jan 2001||Matsushita Electric Industrial Co., Ltd.||Virtual WWW server for enabling a single display screen of a browser to be utilized to concurrently display data of a plurality of files which are obtained from respective servers and to send commands to these servers|
|US6185582||17 Jun 1998||6 Feb 2001||Xerox Corporation||Spreadsheet view enhancement system|
|US6189069||17 Feb 1998||13 Feb 2001||Microsoft Corporation||Optimized logging of data elements to a data storage device|
|US6201539||4 Jan 1994||13 Mar 2001||International Business Machines Corporation||Method and system for customizing a data processing system graphical user interface|
|US6205474 *||14 Apr 1998||20 Mar 2001||Compaq Computer Corporation||Access mechanism for parallel status update for multiple servers|
|US6208990||15 Jul 1998||27 Mar 2001||Informatica Corporation||Method and architecture for automated optimization of ETL throughput in data warehousing applications|
|US6233578||11 Sep 1997||15 May 2001||Nippon Telegraph And Telephone Corporation||Method and system for information retrieval|
|US6239797 *||2 Apr 1998||29 May 2001||Partnerware Technologies||Method and apparatus for remote database record scroll/update without refresh|
|US6240444||27 Sep 1996||29 May 2001||International Business Machines Corporation||Internet web page sharing|
|US6243698||7 Dec 1999||5 Jun 2001||Sagent Technology, Inc.||Extensible database retrieval and viewing architecture|
|US6243713||24 Aug 1998||5 Jun 2001||Excalibur Technologies Corp.||Multimedia document retrieval by application of multimedia queries to a unified index of multimedia data for a plurality of multimedia data types|
|US6256649||17 Jun 1998||3 Jul 2001||Xerox Corporation||Animated spreadsheet for dynamic display of constraint graphs|
|US6256676||5 Oct 1999||3 Jul 2001||Saga Software, Inc.||Agent-adapter architecture for use in enterprise application integration systems|
|US6260114||30 Dec 1997||10 Jul 2001||Mcmz Technology Innovations, Llc||Computer cache memory windowing|
|US6269393||19 Jun 2000||31 Jul 2001||Microstrategy, Inc.||System and method for automatic transmission of personalized OLAP report output|
|US6292803||18 Nov 1997||18 Sep 2001||Honeywell International Inc.||Object state change and history management mechanism|
|US6301601||12 Jul 1999||9 Oct 2001||Microsoft Corporation||Disabling and enabling transaction committal in transactional application components|
|US6304546 *||19 Dec 1996||16 Oct 2001||Cisco Technology, Inc.||End-to-end bidirectional keep-alive using virtual circuits|
|US6314463||29 May 1998||6 Nov 2001||Webspective Software, Inc.||Method and system for measuring queue length and delay|
|US6317737||17 Oct 1997||13 Nov 2001||Sagent Technologies, Inc.||Data descriptions in a database system|
|US6336135||19 May 1997||1 Jan 2002||International Business Machines Corporation||Gateway for converting synchronous client/server protocols into asynchronous messaging protocols and storing session state information at the client|
|US6341312 *||16 Dec 1998||22 Jan 2002||International Business Machines Corporation||Creating and managing persistent connections|
|US6348933||20 Jul 1998||19 Feb 2002||Hewlett-Packard Company||Single logical screen display using multiple remote computer systems|
|US6363363||24 Aug 1999||26 Mar 2002||Verifone, Inc.||System, method and article of manufacture for managing transactions in a high availability system|
|US6393421||6 Aug 1999||21 May 2002||Neriel Paglin||Communication method and system utilizing a specific communication code uniquely assigned to the data record|
|US6397217||4 Mar 1999||28 May 2002||Futuretense, Inc.||Hierarchical caching techniques for efficient dynamic page generation|
|US6430576||10 May 1999||6 Aug 2002||Patrick Gates||Distributing and synchronizing objects|
|US6430604||3 Aug 1999||6 Aug 2002||International Business Machines Corporation||Technique for enabling messaging systems to use alternative message delivery mechanisms|
|US6449344||27 Jan 1997||10 Sep 2002||Aol Acquisition Corporation||Communication system|
|US6467052||3 Jun 1999||15 Oct 2002||Microsoft Corporation||Method and apparatus for analyzing performance of data processing system|
|US6480847||29 Jan 1999||12 Nov 2002||Sagent Technology, Inc.||Database repository with deferred transactions|
|US6501956 *||17 Oct 2000||31 Dec 2002||Intervoice Limited Partnership||Providing blended interface for wireless information services|
|US6510457||15 Jun 1999||21 Jan 2003||Hitachi, Ltd.||Data analysis method and apparatus for data mining|
|US6513047||4 Sep 1997||28 Jan 2003||Sun Microsystems, Inc.||Management of user-definable databases|
|US6519568||23 Dec 1999||11 Feb 2003||Schlumberger Technology Corporation||System and method for electronic data delivery|
|US6519601||21 May 1997||11 Feb 2003||Universitaire Ziekenhuizen Leuven||Relational database compiled/stored on a memory structure providing improved access through use of redundant representation of data|
|US6523046||7 Dec 2000||18 Feb 2003||Microsoft Corporation||Infrastructure and method for supporting generic multimedia metadata|
|US6532465||5 Apr 2001||11 Mar 2003||Bruce Hartley||Operational system for operating on client defined rules|
|US6535227||8 Feb 2000||18 Mar 2003||Harris Corporation||System and method for assessing the security posture of a network and having a graphical user interface|
|US6542165||3 Mar 1999||1 Apr 2003||International Business Machines Corp.||System, apparatus and method of relating annotation data to an application window|
|US6567796||1 Jul 1999||20 May 2003||Microstrategy, Incorporated||System and method for management of an automatic OLAP report broadcast system|
|US6567814||26 Aug 1999||20 May 2003||Thinkanalytics Ltd||Method and apparatus for knowledge discovery in databases|
|US6574618||28 Dec 2000||3 Jun 2003||Appstream, Inc.||Method and system for executing network streamed application|
|US6574639||27 Jun 2001||3 Jun 2003||International Business Machines Corporation||Query optimization with deferred updates and autonomous sources|
|US6591277||27 Dec 2000||8 Jul 2003||International Business Machines Corporation||Dynamic object persistence|
|US6591278||3 Mar 2000||8 Jul 2003||R-Objects, Inc.||Project data management system and method|
|US6598167||24 Sep 1998||22 Jul 2003||Worldcom, Inc.||Secure customer interface for web based data management|
|US6606596||7 Dec 1999||12 Aug 2003||Microstrategy, Incorporated||System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, including deployment through digital sound files|
|US6640234||31 Dec 1998||28 Oct 2003||Microsoft Corporation||Extension of formulas and formatting in an electronic spreadsheet|
|US6647272||19 Nov 1999||11 Nov 2003||Nokia Corporation||Apparatus, and associated method, for automatically notifying a mobile station of occurrence of a triggering event|
|US6651055||1 Mar 2001||18 Nov 2003||Lawson Software, Inc.||OLAP query generation engine|
|US6651142||5 May 2000||18 Nov 2003||Sagent Technology||Method and apparatus for processing data using multi-tier caching|
|US6654790||28 Feb 2002||25 Nov 2003||International Business Machines Corporation||Technique for enabling wireless messaging systems to use alternative message delivery mechanisms|
|US6664978||17 Nov 1997||16 Dec 2003||Fujitsu Limited||Client-server computer network management architecture|
|US6668173||15 Dec 2000||23 Dec 2003||Motorola, Inc.||Instant message user location tracking system|
|US6678719||20 Dec 1999||13 Jan 2004||Mediaone Group, Inc.||Virtual workplace intercommunication tool|
|US6687360||30 Dec 1999||3 Feb 2004||At&T Corp.||Personal IP follow-me service|
|US6701485||15 Jun 1999||2 Mar 2004||Microsoft Corporation||Binding spreadsheet cells to objects|
|US6714982||19 Jan 2000||30 Mar 2004||Fmr Corp.||Message passing over secure connections using a network server|
|US6731314||16 Aug 1999||4 May 2004||Muse Corporation||Network-based three-dimensional multiple-user shared environment apparatus and method|
|US6745193||29 Jun 2001||1 Jun 2004||Microsoft Corporation||System and method for defining, refining, and personalizing communications policies in a notification platform|
|US6766418||30 Apr 2001||20 Jul 2004||Emc Corporation||Methods and apparatus for accessing data using a cache|
|US6775267||30 Dec 1999||10 Aug 2004||At&T Corp||Method for billing IP broadband subscribers|
|US6775298 *||12 Aug 1999||10 Aug 2004||International Business Machines Corporation||Data transfer mechanism for handheld devices over a wireless communication link|
|US6782424||23 Aug 2002||24 Aug 2004||Finite State Machine Labs, Inc.||System, method and computer program product for monitoring and controlling network connections from a supervisory operating system|
|US6789083||17 Sep 2001||7 Sep 2004||Hewlett-Packard Development Company, L.P.||Methods and system for browsing large text files|
|US6792456||8 May 2000||14 Sep 2004||International Business Machines Corporation||Systems and methods for authoring and executing operational policies that use event rates|
|US6807562||29 Feb 2000||19 Oct 2004||Microsoft Corporation||Automatic and selective assignment of channels to recipients of voice chat data|
|US6807583||8 Nov 2001||19 Oct 2004||Carleton University||Method of determining causal connections between events recorded during process execution|
|US6832341||23 Sep 1999||14 Dec 2004||International Business Machines Corporation||Fault event management using fault monitoring points|
|US6839737||19 Jul 2000||4 Jan 2005||Neoplanet, Inc.||Messaging system for indicating status of a sender of electronic mail and method and computer program product therefor|
|US6870830||30 Nov 2000||22 Mar 2005||3Com Corporation||System and method for performing messaging services using a data communications channel in a data network telephone system|
|US6898625||18 Dec 2001||24 May 2005||Hewlett-Packard Development Company, L.P.||Document tracking methods and system therefor|
|US6901592||27 Nov 2001||31 May 2005||Redback Networks, Inc.||Method and apparatus for the enumeration of sets of concurrently scheduled events|
|US6907422||18 Dec 2001||14 Jun 2005||Siebel Systems, Inc.||Method and system for access and display of data from large data sets|
|US6915457||4 Jun 1999||5 Jul 2005||Nortel Networks Limited||Apparatus and method for monitoring messages forwarded between applications|
|US6920607||20 Jul 2000||19 Jul 2005||Microsoft Corp.||Methods and systems for dynamically creating user interfaces|
|US6937713||30 Dec 1999||30 Aug 2005||At&T Corp.||IP call forward profile|
|US6938221||30 Nov 2001||30 Aug 2005||Microsoft Corporation||User interface for stylus-based user input|
|US6941345||3 Dec 1999||6 Sep 2005||Nortel Networks Limited||Real-time, text-based messaging between devices in plural communities|
|US6941351 *||15 Jun 2001||6 Sep 2005||Microsoft Corporation||Application program caching|
|US6954757||7 Sep 2001||11 Oct 2005||Hewlett-Packard Development Company, L.P.||Framework, architecture, method and system for reducing latency of business operations of an enterprise|
|US6954902||30 Mar 2000||11 Oct 2005||Sony Corporation||Information sharing processing method, information sharing processing program storage medium, information sharing processing apparatus, and information sharing processing system|
|US6996768||15 Jun 2000||7 Feb 2006||International Business Machines Corporation||Electric publishing system and method of operation generating web pages personalized to a user's optimum learning mode|
|US7003568 *||12 Nov 1999||21 Feb 2006||Ntt Docomo, Inc.||Communication control method, communication control apparatus and storage medium|
|US7003731||17 Oct 2000||21 Feb 2006||Digimare Corporation||User control and activation of watermark enabled objects|
|US7024474||24 Jan 2001||4 Apr 2006||Telecommunication Systems, Inc.||System and method to publish information from servers to remote monitor devices|
|US7028092||27 Apr 2001||11 Apr 2006||Acme Packet, Inc.||System and method for assisting in controlling real-time transport protocol flow through multiple networks via media flow routing|
|US7031314||19 Apr 2002||18 Apr 2006||Bytemobile, Inc.||Systems and methods for providing differentiated services within a network communication system|
|US7032006||26 Jan 2001||18 Apr 2006||Zhuk Jeff Yefim||Distributed active knowledge and process base allowing system elements to be shared within a collaborative framework|
|US7035923||10 Apr 2002||25 Apr 2006||Nortel Networks Limited||Presence information specifying communication preferences|
|US7058953||23 Jul 2002||6 Jun 2006||Microsoft Corporation||Managing a distributed computing system|
|US7096432||14 May 2002||22 Aug 2006||Microsoft Corporation||Write anywhere tool|
|US7113964||5 Jun 2003||26 Sep 2006||Iteration Software, Inc.||Method and apparatus for archiving data in a relational database system|
|US7120139||30 Dec 1999||10 Oct 2006||At&T Corp.||Broadband cable telephony network architecture IP ITN network architecture reference model|
|US7139797||10 Apr 2002||21 Nov 2006||Nortel Networks Limited||Presence information based on media activity|
|US7171473||9 Nov 2000||30 Jan 2007||Planet Exchange, Inc.||System using HTTP protocol for maintaining and updating on-line presence information of new user in user table and group table|
|US7174339||7 Mar 2000||6 Feb 2007||Tririga Llc||Integrated business system for the design, execution, and management of projects|
|US7177909||10 Mar 2003||13 Feb 2007||Centerpost Communications, Inc.||Method and system for content driven electronic messaging|
|US7197565||3 Oct 2002||27 Mar 2007||Sun Microsystems, Inc.||System and method of using a pipe advertisement for a peer-to-peer network entity in peer-to-peer presence detection|
|US7221658||14 Dec 1999||22 May 2007||Nortel Networks Ltd||Independent contact spanning multiple access networks|
|US7222294||22 Sep 2003||22 May 2007||Microsoft Corporation||Extension of formulas and formatting in an electronic spreadsheet|
|US7233979||14 Jun 2002||19 Jun 2007||Microsoft Corporation||Instant messaging session invite for arranging peer-to-peer communication between applications|
|US7243124||5 Nov 2002||10 Jul 2007||Oracle International Corporation||Architecture for general purpose near real-time business intelligence system with client devices and methods therefor|
|US7243127||9 Oct 2001||10 Jul 2007||Swiftview, Inc.||Network-based document delivery system with receipt and display verification|
|US7243130||16 Mar 2001||10 Jul 2007||Microsoft Corporation||Notification platform architecture|
|US7269627||27 Jul 2001||11 Sep 2007||Intel Corporation||Routing messages using presence information|
|US7272660||5 Nov 2002||18 Sep 2007||Oracle International Corporation||Architecture for general purpose near real-time business intelligence system and methods therefor|
|US7275215||29 Jul 2002||25 Sep 2007||Cerulean Studios, Llc||System and method for managing contacts in an instant messaging environment|
|US7283805||20 Nov 2001||16 Oct 2007||Cingular Wireless Ii, Llc||Methods and systems for providing application level presence information in wireless communication|
|US7284034||11 Jul 2002||16 Oct 2007||International Business Machines Corporation||Transparent combination of instant message protocols|
|US7296217||5 May 2000||13 Nov 2007||Timberline Software Corporation||Electronic transaction document system|
|US7299257||21 Jun 2001||20 Nov 2007||Lucent Technologies Inc.||Apparatus and method for use in collaboration services|
|US7310532||5 Dec 2001||18 Dec 2007||Intel Corporation||Method of automatically updating presence information|
|US7313593||24 Oct 2000||25 Dec 2007||International Business Machines Corporation||Method and apparatus for providing full duplex and multipoint IP audio streaming|
|US7313617||28 Sep 2001||25 Dec 2007||Dale Malik||Methods and systems for a communications and information resource manager|
|US7353455||19 Aug 2002||1 Apr 2008||At&T Delaware Intellectual Property, Inc.||Caller initiated distinctive presence alerting and auto-response messaging|
|US7359938||14 Dec 1999||15 Apr 2008||Nortel Networks Limited||System indicating the presence of an individual or group of individuals|
|US7373428||14 Dec 1999||13 May 2008||Nortel Networks Limited||Intelligent filtering for contact spanning multiple access networks|
|US7379963||14 Jul 2000||27 May 2008||Knownow-Delaware||Delivery of any type of information to anyone anytime anywhere|
|US7386588||10 Apr 2001||10 Jun 2008||Research In Motion Limited||System and method for pushing information from a host system to a mobile data communication device|
|US7389351||15 Mar 2001||17 Jun 2008||Microsoft Corporation||System and method for identifying and establishing preferred modalities or channels for communications based on participants' preferences and contexts|
|US7392478||31 Jan 2002||24 Jun 2008||International Business Machines Corporation||Method and system in an electronic spreadsheet for handling graphical objects referring to working ranges of cells in a copy/cut and paste operation|
|US7401158||5 Nov 2002||15 Jul 2008||Oracle International Corporation||Apparatus and method for instant messaging collaboration|
|US7406569||12 Aug 2002||29 Jul 2008||Nxp B.V.||Instruction cache way prediction for jump targets|
|US7412481||5 Nov 2002||12 Aug 2008||Oracle International Corporation||Method and apparatus for distributed rule evaluation in a near real-time business intelligence system|
|US7412486||12 Sep 2002||12 Aug 2008||Edial, Inc.||Methods and apparatus providing a web based messaging system|
|US7412518||7 Sep 2000||12 Aug 2008||Sun Microsystems, Inc.||Method and apparatus for proximity discovery of services|
|US7412645||4 May 2004||12 Aug 2008||Microsoft Corporation||User interface for integrated spreadsheets and word processing tables|
|US7415502||16 Nov 2001||19 Aug 2008||Sbc Technology Resources, Inc.||Method and system for intelligent routing based on presence detection|
|US7426059||17 Mar 2003||16 Sep 2008||Oracle International Corporation||Data presentation methods and apparatus to facilitate printing and reviewing|
|US7433922||10 May 2002||7 Oct 2008||Varia Llc||Method and system for collecting and displaying aggregate presence information for mobile media players|
|US7436947||26 Jun 2002||14 Oct 2008||Avaya Inc.||Method and apparatus for automatic notification and response based on communication flow expressions|
|US7454423||6 Sep 2002||18 Nov 2008||Oracle International Corporation||Enterprise link for a software database|
|US7487437||27 Feb 2004||3 Feb 2009||International Business Machines Corporation||System and method in a data table for managing insertion operations in recursive scalable template instances|
|US7552204||15 May 2002||23 Jun 2009||Microsoft Corporation||Method and system for supporting the communication of presence information among computing devices of a network|
|US7627666||25 Jan 2002||1 Dec 2009||Accenture Global Services Gmbh||Tracking system incorporating business intelligence|
|US7631047||24 Jun 2002||8 Dec 2009||At&T Intellectual Property I. L.P.||Systems and methods for providing critical information based on profile data|
|US7664817||7 Feb 2002||16 Feb 2010||Fujitsu Limited||Information distribution method and device|
|US7668917||5 Nov 2002||23 Feb 2010||Oracle International Corporation||Method and apparatus for ensuring accountability in the examination of a set of data elements by a user|
|US20010034733||2 Mar 2001||25 Oct 2001||Michel Prompt||System and method for providing access to databases via directories and other hierarchical structures and interfaces|
|US20010039616||22 Dec 2000||8 Nov 2001||Ids Corporation||Carrier-free terminal authentication system by means of a mail-back method|
|US20010040945 *||29 Dec 1997||15 Nov 2001||Nobutsugu Fujino||Communications system and communications method|
|US20010049683||2 Jul 1998||6 Dec 2001||Masazumi Yoshikawa||Data calculator performing automatic recalculation based on data structure network|
|US20010049721||28 Jun 2001||6 Dec 2001||John Blair||Method and system for continuous interactive communication in an electronic network|
|US20020013853||18 Apr 2001||31 Jan 2002||Baber Stephen C.||Methods, systems and computer program products for transferring a file using a message queue|
|US20020032602||29 Jan 2001||14 Mar 2002||Lanzillo Kenneth F.||Recipient selection and message delivery system and method|
|US20020038217||9 Apr 2001||28 Mar 2002||Alan Young||System and method for integrated data analysis and management|
|US20020056000||18 Jan 2001||9 May 2002||Albert Coussement Stefaan Valere||Personal interaction interface for communication-center customers|
|US20020057678||16 Aug 2001||16 May 2002||Jiang Yuen Jun||Method and system for wireless voice channel/data channel integration|
|US20020059425||22 Jun 2001||16 May 2002||Microsoft Corporation||Distributed computing services platform|
|US20020059472||17 Dec 2001||16 May 2002||Sun Microsystem, Inc.||Method and apparatus for transporting behavior in an event-based distributed system|
|US20020065894||30 Nov 2000||30 May 2002||Dalal Siddhartha R.||Local presence state and user-controlled presence and message forwarding in unified instant messaging|
|US20020075303||18 Dec 2000||20 Jun 2002||Nortel Networks Limited And Bell Canada||Method and system for creating a virtual team environment|
|US20020078208 *||7 Oct 1998||20 Jun 2002||Richard Crump||Efficient recovery of multiple connections in a communication network|
|US20020083072||22 Dec 2000||27 Jun 2002||Steuart Stacy Rhea||System, method and software application for incorporating data from unintegrated applications within a central database|
|US20020083118||18 May 2001||27 Jun 2002||Sim Siew Yong||Method and apparatus for managing a plurality of servers in a content delivery network|
|US20020095465||16 Jan 2001||18 Jul 2002||Diane Banks||Method and system for participating in chat sessions|
|US20020103909 *||31 Jan 2001||1 Aug 2002||Devine Wesley Mcmillan||Methods, systems and computer program products for resuming SNA application-client communications after loss of an IP network connection|
|US20020107864||7 Sep 2001||8 Aug 2002||Gregory Battas||Enabling a zero latency enterprise|
|US20020107905||4 Feb 2002||8 Aug 2002||Roe Colleen A.||Scalable agent service system|
|US20020107957||7 Sep 2001||8 Aug 2002||Bahman Zargham||Framework, architecture, method and system for reducing latency of business operations of an enterprise|
|US20020116362||31 Oct 2001||22 Aug 2002||Hui Li||Real time business process analysis method and apparatus|
|US20020116461||5 Feb 2002||22 Aug 2002||Athanassios Diacakis||Presence and availability management system|
|US20020120697||16 Aug 2001||29 Aug 2002||Curtis Generous||Multi-channel messaging system and method|
|US20020120765||22 Dec 2000||29 Aug 2002||Bellsouth Intellectual Property Corporation||System, method and apparatus for obtaining real-time information associated with a telecommunication network|
|US20020138640 *||22 Dec 2000||26 Sep 2002||Uri Raz||Apparatus and method for improving the delivery of software applications and associated data in web-based systems|
|US20020143710||3 Apr 2001||3 Oct 2002||Gary Liu||Certified transmission system|
|US20020147777||21 Jun 2001||10 Oct 2002||Hackbarth Randy L.||Apparatus and method for use in portal service for a team utilizing collaboration services|
|US20020152402||7 Feb 2001||17 Oct 2002||Tov Ofer Shem||Personalized visitor pages|
|US20020165849||26 Sep 2001||7 Nov 2002||Singh Narinder Pal||Automatic advertiser notification for a system for providing place and price protection in a search result list generated by a computer network search engine|
|US20020178353||11 Apr 2001||28 Nov 2002||Graham Randall James||Secure messaging using self-decrypting documents|
|US20020184187||7 Nov 2001||5 Dec 2002||Reuven Bakalash||Method of and apparatus for data aggregation utilizing a multidimensdional database and multi-stage data aggregation operations|
|US20020194393||8 Nov 2001||19 Dec 2002||Curtis Hrischuk||Method of determining causal connections between events recorded during process execution|
|US20020198985||19 Oct 2001||26 Dec 2002||Noam Fraenkel||Post-deployment monitoring and analysis of server performance|
|US20030004742||19 Feb 2002||2 Jan 2003||Palmer Simon James||Business intelligence monitor method and system|
|US20030023691||27 Jul 2001||30 Jan 2003||Knauerhase Robert C.||Routing messages using presence information|
|US20030028597||13 Mar 2002||6 Feb 2003||Matti Salmi||Separation of instant messaging user and client identities|
|US20030028682||1 Aug 2001||6 Feb 2003||Sutherland James Bryce||System and method for object persistence life-cycle and object caching integration|
|US20030028683||1 Aug 2001||6 Feb 2003||Yorke Gordon James||Method and system for object cache synchronization|
|US20030033329||22 Jun 2001||13 Feb 2003||Bergman Eric D.||Method and apparatus for entry and editing of spreadsheet formulas|
|US20030037103||13 Mar 2002||20 Feb 2003||Nokia Corporation||Realization of presence management|
|US20030037113||27 Aug 2002||20 Feb 2003||Yevgeniy Petrovykh||Method and apparatus for anticipating and planning communication-center resources based on evaluation of events waiting in a communication center master queue|
|US20030071850||12 Oct 2001||17 Apr 2003||Microsoft Corporation||In-place adaptive handwriting input method and system|
|US20030074393||2 Oct 2001||17 Apr 2003||Franklyn Peart||Methods for distributed program execution with file-type association in a client-server network|
|US20030088633||28 Oct 2002||8 May 2003||Chiu Denny K.||System and method for remotely controlling mobile communication devices|
|US20030093585 *||23 Aug 2002||15 May 2003||Stanley Allan||System and method for providing real-time information to a web browser|
|US20030101201||10 Jan 2003||29 May 2003||Saylor Michael J.||System and method for management of an automatic OLAP report broadcast system|
|US20030101223||4 Sep 2001||29 May 2003||Pace Charles P.||System and method for synchronizing assets on multi-tiered networks|
|US20030105837||30 Nov 2001||5 Jun 2003||Yury Kamen||Interception for optimal caching of distributed applications|
|US20030112948||19 Dec 2001||19 Jun 2003||Wendell Brown||System and method for establishing a connection between parties based on their availability|
|US20030115186||14 Dec 2001||19 Jun 2003||Wilkinson Francis M.||System for controlling access to and generation of localized application values|
|US20030120805||21 Dec 2001||26 Jun 2003||Couts Jeffrey David||System and method for automatically forwarding a communication message|
|US20030126136||24 Jun 2002||3 Jul 2003||Nosa Omoigui||System and method for knowledge retrieval, management, delivery and presentation|
|US20030154177||14 Feb 2003||14 Aug 2003||Holland Paul Edward||Combined issue identifying analyzer and intelligent report generator|
|US20030158873||15 Feb 2002||21 Aug 2003||International Business Machines Corporation||Dynamic links to file system snapshots|
|US20030182428||19 Mar 2002||25 Sep 2003||Jiang Li||Peer-to-peer (P2P) communication system|
|US20030182461||30 Apr 2002||25 Sep 2003||Stelting Stephen A.||Service mapping method of enterprise application modeling and development for multi-tier service environments|
|US20030187971||29 Mar 2002||2 Oct 2003||Uliano Anthony X.||Enterprise macro-manager of contact center communications technologies|
|US20030204741||26 Apr 2002||30 Oct 2003||Isadore Schoen||Secure PKI proxy and method for instant messaging clients|
|US20030208543||25 Jul 2001||6 Nov 2003||Noel Enete||Video messaging|
|US20030217081||14 May 2002||20 Nov 2003||Ken White||System and method of maintaining functional client side data cache coherence|
|US20030217142||15 May 2002||20 Nov 2003||Microsoft Corporation||Method and system for supporting the communication of presence information regarding one or more telephony devices|
|US20030220860||24 Apr 2003||27 Nov 2003||Hewlett-Packard Development Company,L.P.||Knowledge discovery through an analytic learning cycle|
|US20030229722||11 Jun 2002||11 Dec 2003||Siemens Information And Communication Networks, Inc.||Methods and apparatus for processing an instant message|
|US20030235279 *||26 Mar 2003||25 Dec 2003||Morgan Richomme||Dynamic web conference monitoring through a streaming mechanism|
|US20040002958||26 Jun 2002||1 Jan 2004||Praveen Seshadri||System and method for providing notification(s)|
|US20040003090||28 Jun 2002||1 Jan 2004||Douglas Deeds||Peer-to-peer media sharing|
|US20040010543||15 Jul 2002||15 Jan 2004||Steven Grobman||Cached resource validation without source server contact during validation|
|US20040019695||25 Jul 2002||29 Jan 2004||International Business Machines Corporation||Messaging system and method using alternative message delivery paths|
|US20040024822||1 Aug 2002||5 Feb 2004||Werndorfer Scott M.||Apparatus and method for generating audio and graphical animations in an instant messaging environment|
|US20040030762||9 Aug 2002||12 Feb 2004||Paul Silverthorne||System, computer product and method for event monitoring with data centre|
|US20040039776 *||26 Aug 2002||26 Feb 2004||Eugene Ballard||System and method for efficient data refresh|
|US20040039800||14 Jan 2003||26 Feb 2004||Bellsouth Intellectual Property Corporation||System and method for providing interoperability between different programming protocols|
|US20040049477||6 Sep 2002||11 Mar 2004||Iteration Software, Inc.||Enterprise link for a software database|
|US20040054802||5 Nov 2002||18 Mar 2004||Iteration Software, Inc.||Apparatus and method for instant messaging collaboration|
|US20040060001||22 Sep 2003||25 Mar 2004||Microsoft Corporation||Extension of formulas and formatting in an electronic spreadsheet|
|US20040073596||14 May 2003||15 Apr 2004||Kloninger John Josef||Enterprise content delivery network having a central controller for coordinating a set of content servers|
|US20040087300||18 Nov 2002||6 May 2004||Lewis John Ervin||System and method for providing message notification|
|US20040146044||15 Mar 2002||29 Jul 2004||Andreas Herkerdorf||Cache entry selection method and apparatus|
|US20040152477||14 Nov 2001||5 Aug 2004||Xiaoguang Wu||Instant messaging system and method|
|US20040254998||30 Jun 2004||16 Dec 2004||Microsoft Corporation||When-free messaging|
|US20050004984||8 Aug 2001||6 Jan 2005||Simpson Anita Hogans||System and method for notifying an offline global computer network user of an online interaction|
|US20050055329||5 May 2004||10 Mar 2005||Reuven Bakalash||Database management system having data aggregation module integrated therein|
|US20050086211||9 Aug 2004||21 Apr 2005||Yaron Mayer||System and method for searching, finding and contacting dates on the Internet in instant messaging networks and/or in other methods that enable immediate finding and creating immediate contact|
|US20050102294||3 Jan 2001||12 May 2005||Dirk Coldewey||Method for prefetching recursive data structure traversals|
|US20050102611 *||6 Nov 2003||12 May 2005||Danny Chen||Process for creating dynamic web pages driven from the server side|
|US20050125377||9 Oct 2004||9 Jun 2005||Microsoft Corporation||System and method for integrating spreadsheets and word processing tables|
|US20050144114||24 Sep 2004||30 Jun 2005||Ruggieri Thomas P.||System and method for providing global information on risks and related hedging strategies|
|US20050187982||4 May 2004||25 Aug 2005||Eiichi Sato||Method and device for acquiring snapshots and computer system with snapshot acquiring function|
|US20060089939||12 Dec 2005||27 Apr 2006||Oracle International Corporation||Business intelligence system with interface that provides for immediate user action|
|US20060161540||6 Mar 2006||20 Jul 2006||Schmitz Benjamin W||System and method for receiving and loading fare and schedule data|
|US20060206589||1 Mar 2006||14 Sep 2006||Lentini Russell P||Method and systems for providing access to dynamic content via static pages|
|US20080043256||17 Mar 2003||21 Feb 2008||Tal Broda||Data presentation methods and apparatus to facilitate printing and reviewing|
|US20080046505||5 Nov 2002||21 Feb 2008||Tana Christine Netsch||Method and apparatus for ensuring accountability in the examination of a set of data elements by a user|
|US20080046506||30 May 2003||21 Feb 2008||Tal Broda||Method and apparatus for a multiplexed active data window in a near real-time business intelligence system|
|US20080046510||5 Nov 2002||21 Feb 2008||Beauchamp Tim J||Method for selectively sending a notification to an instant messaging device|
|US20080046536||17 Mar 2003||21 Feb 2008||Tal Broda||Method and apparatus for a report cache in a near real-time business intelligence system|
|US20080046556||5 Nov 2002||21 Feb 2008||Geoffrey Deane Owen Nicholls||Method and apparatus for distributed rule evaluation in a near real-time business intelligence system|
|US20080046803||17 Mar 2003||21 Feb 2008||Beauchamp Tim J||Application-specific personalization for data display|
|US20080046837||17 Mar 2003||21 Feb 2008||Tim Beauchamp||Transparent windows methods and apparatus therefor|
|US20080077656||14 Jun 2007||27 Mar 2008||Oracle International Corporation||Method and apparatus for a report cache in a near real-time business intelligence system|
|US20080148289||21 Feb 2008||19 Jun 2008||Oracle International Corporation||Method and apparatus for distributed rule evaluation in a near real-time business intelligence system|
|US20080155020||28 Feb 2008||26 Jun 2008||Oracle International Corporation||Apparatus and method for instant messaging collaboration|
|US20090031205||9 Jul 2008||29 Jan 2009||International Business Machines Corporation||System for exporting-impoting the content of input cells from a scalable template instance to another|
|US20090037803||29 Sep 2008||5 Feb 2009||International Business Machines Corporation||System in an electronic spreadsheet for persistently self-replicating multiple ranges of cells through a copy-paste operation and a self-replication table|
|WO2001063466A2 *||23 Feb 2001||30 Aug 2001||Hummingbird Ltd.||A system and method for providing real-time information to a web browser|
|1||"A Data Warehousing Tutorial", Paretoanalysts, Dec. 27, 2001.|
|2||"Achieving Global Business Visibility with the webMethods Integration Platform", webMethods, Inc., Sep. 2001.|
|3||"Adding Printer Capabilities," Interactivetools.Com, posted Oct. 19, 2002.|
|4||"An Introduction to Messaging and Queuing", IBM Corp, Jun. 1995.|
|5||"Brocade Rapidly Implements Customer and Sales Analytics", Informatica Corporation, 2002.|
|6||"Business Intelligence Software: Engendering a Quiet Revolution in the Business Place", MicroStrategy, Dec. 20, 2002.|
|7||"Business Rules: Powering Business and E-Business", White Paper, ILOG, May 2001.|
|8||"Business Transformation Through End-to-End Integration", IBM, Aug. 2002.|
|9||"Express Communicator", White Paper, ACD Systems Ltd., May 2001.|
|10||"Guidelines for Implementing and Using the NBS Data", Federal Information Processing Standards, Publication 74, Apr. 1, 1981.|
|11||"ILOG Views 2D Graphics: The C++ Library for Interactive 2D Graphics", ILOG.|
|12||"Implementing the RosettaNet eBusiness Standard: Automating High-tech Supply Chains using BusinessWare for RosettaNet", Vitria Technology Inc., 2000.|
|13||"Informatica Applications: Informatica Customer Relationship Analytics", Informatica Corporation, 2002.|
|14||"Informatica Applications: Leverage your Enterprise Information for Better Decision Making", Informatica Corporation, 2002.|
|15||"Jabber: About: Technology Overview", Jabber Software Foundation, Dec. 12, 2003.|
|17||"Middleware-The Essential Component for Enterprise Client/Server Applications", International Systems Group, Inc., Feb. 1997.|
|18||"Middleware—The Essential Component for Enterprise Client/Server Applications", International Systems Group, Inc., Feb. 1997.|
|19||"MQSeries link for R/3", International Business Machines Corporation, 1998.|
|21||"Protecting the Enterprise from Rogue Protocols", Akonix Systems, Inc., 2002.|
|22||"Relational OLAP: An Enterprise-Wide Data Delivery Architecture", MicroStrategy, Incorporated, 1994.|
|23||"Report of Novelty Search", Patentec, dated Apr. 3, 2004.|
|24||"Report of Novelty Search," by Patentec, dated Oct. 16, 2003.|
|25||"Sametime 3 Features and Benefits", IBM publication, date unknown (1 page).|
|26||"Sametime for iSeries 2.5", Lotus Software, IBM Corporation, 2002.|
|27||"Scripting Support for Web Page Printing Sample," Microsoft Corporation, 2004.|
|28||"Steel-Belted Radius/Enterprise Edition", Funk Software, Inc., 2004.|
|29||"The Basics of Browser", Santa Clara County Office of Education Internet Institute (SCCOE), 1999.|
|30||"The Business Intelligence Industry's Leading Products and Services", Business Objects, 2001.|
|31||"The Sagent Analytic Advantage", Sagent Technology Inc., May 2002.|
|32||"The Sagent Performance Story", Sagent Technology, Inc., Oct. 2001.|
|33||"X Window System: Getting Started", Stanford University, Oct. 26, 2000.|
|34||Aaron Weiss, "The Document Object Model Dissected", Jupitermedia Corporation, 2002.|
|35||Advisory Action for U.S. Appl. No. 10/289,155, dated Apr. 14, 2008; 3 pages total.|
|36||Advisory Action for U.S. Appl. No. 10/289,155, dated May 31, 2007; 3 pages total.|
|37||Advisory Action for U.S. Appl. No. 10/390,978, dated Nov. 3, 2008, 3 pages total.|
|38||Advisory Action for U.S. Appl. No. 10/391,073, dated Aug. 23, 2010; 2 pgs.|
|39||Advisory Action for U.S. Appl. No. 10/391,073, dated Oct. 28, 2008; 3 pages total.|
|40||Advisory Action for U.S. Appl. No. 10/391,073, dated Sep. 18, 2009, 3 pages total.|
|41||Advisory Action for U.S. Appl. No. 10/391,544, dated Dec. 11, 2009, 2 pages total.|
|42||Advisory Action for U.S. Appl. No. 10/391,544, dated Dec. 3, 2008, 6 pages total.|
|43||Advisory Action for U.S. Appl. No. 11/299,441, dated Dec. 16, 2008, 3 pages total.|
|44||Advisory Action of U.S. Appl. No. 10/237,559 dated Oct. 25, 2007, 3 pages total.|
|45||Advisory Action of U.S. Appl. No. 12/039,471 dated Sep. 8, 2010, 2 pages total.|
|46||Allan Christian Long et al., "PDA and Gesture Use in Practice: Insights for Designers of Pen-based User Interfaces", University of California at Berkeley, 1997.|
|47||Allen Gwinn, "Simple Network Paging Protocol-Version 3-Two-Way Enhanced," Network Working Group, Oct. 1995. (23 pages).|
|48||Allen Gwinn, "Simple Network Paging Protocol—Version 3—Two-Way Enhanced," Network Working Group, Oct. 1995. (23 pages).|
|49||Andrew Nosenko, "Scripting Support for Web Page Printing," Microsoft Corporation, Mar. 28, 2000.|
|50||Anton, Jesse et al., "Web Catching for Database Applications with Oracle Cache", Jun. 4-6, 2002, pp. 594-599.|
|51||Arno Schoedl, "Issues for Implementing User Interface Software", Georgia Institute of Technology, Sep. 26, 1998.|
|52||Bernstein, Philip A. and Erhard Rahm, "Data Warehouse Scenarios for Model Management", Microsoft Corporation, 2000.|
|53||Bob Woods, "CypherGuard Secures MSN, Windows IM", Instant Messaging Planet, JupiterMedia Corporation, Oct. 3, 2002.|
|54||Constantine Stephanidis et al., "Design Representations and Development Support for User Interface Adaptation", Institute of Computer Science Foundation for Research and Technology, 1995.|
|55||Dabke P, "Enterprise Integration Via Corba-Based Information Agents," IEEE Internet Computing, Sep./Oct. 1999, pp. 49-57, vol. 3, Issue 5.|
|56||Excel 2000, publ. by Microsoft in 1999, screen captures pp. 1-12.|
|57||*||Extensible Markup Language (XML) 1.0 (Second Edition), Oct. 6, 2000, printed from w3.org.|
|58||Final Office Action for U.S. Appl. No. 10/289,155, dated Jan. 6, 2009; 11 pages total.|
|59||Final Office Action for U.S. Appl. No. 10/289,155, dated Mar. 27, 2007; 12 pages total.|
|60||Final Office Action for U.S. Appl. No. 10/390,978, dated Jun. 17, 2010, 28 pages total.|
|61||Final Office Action for U.S. Appl. No. 10/390,978, dated Jun. 25, 2007, 17 pages total.|
|62||Final Office Action for U.S. Appl. No. 10/390,978, dated May 18, 2006, 13 pages total.|
|63||Final Office Action for U.S. Appl. No. 10/390,978, dated Sep. 3, 2008, 17 pages total.|
|64||Final Office Action for U.S. Appl. No. 10/390,978, dated Sep. 4, 2009, 24 pages total.|
|65||Final Office Action for U.S. Appl. No. 10/391,073, dated Jun. 17, 2010; 9 pgs.|
|66||Final Office Action for U.S. Appl. No. 10/391,073, dated Jun. 21, 2007; 7 pages total.|
|67||Final Office Action for U.S. Appl. No. 10/452,665, dated May 9, 2007, 7 pages total.|
|68||Final Office Action for U.S. Appl. No. 11/299,441, dated Jun. 25, 2010, 28 pages total.|
|69||Final Office Action for U.S. Appl. No. 11/299,441, dated Oct. 3, 2008, 18 pages total.|
|70||Final Office Action of U.S. Appl. No. 10/237,559 dated Aug. 15, 2007, 13 pages total.|
|71||Final Office Action of U.S. Appl. No. 10/237,559 dated Dec. 30, 2005, 10 pages total.|
|72||Final Office Action of U.S. Appl. No. 10/289,139 dated Apr. 11, 2006, 16 pages total.|
|73||Final Office Action of U.S. Appl. No. 10/289,142 dated Apr. 24, 2006, 12 pages total.|
|74||Final Office Action of U.S. Appl. No. 10/289,142 dated May 30, 2007, 10 pages total.|
|75||Final Office Action of U.S. Appl. No. 10/289,162 dated Apr. 20, 2007, 8 pages total.|
|76||Final Office Action of U.S. Appl. No. 10/289,231, dated Apr. 11, 2006, 15 pages total.|
|77||Final Office Action of U.S. Appl. No. 10/289,231, dated Apr. 16, 2007, 15 pages total.|
|78||Final Office Action of U.S. Appl. No. 10/289,231, dated Dec. 14, 2009, 9 pages total.|
|79||Final Office Action of U.S. Appl. No. 10/390,945 dated Jul. 5, 2007, 9 pages total.|
|80||Final Office Action of U.S. Appl. No. 12/039,471 dated Jun. 24, 2010, 20 pages total.|
|81||Goldsmith D. et al., "UTF-7: A Mail-Safe Transformation Format of Unicode," Network Working Group, Request for Comments: 2152, Obsoletes: RFC 1642, Category: Informational, May 1997, pp. 1-15.|
|82||Habraken J. "Ten Minute Guide to Microsoft Excel 2002," Sep. 27, 2001, Que, Section, "Lesson 6, Performing Calculations with Functions."|
|83||Howlett, Dennis and Keith Rodgers, "Delivering Value Back to the Business: A Guide to Successful Portal Selection and Implementation", TIBCO Software, 2002.|
|84||Hugh J. Watson, "Recent Developments in Data Warehousing", Communications of the Association for Information Systems, vol. 8, 2001.|
|85||*||Introduction to Dynamic HTML, printed from microsoft.com.|
|86||Jake Howlett, "Further Control of Printing," Codestore, Jan. 3, 2002.|
|87||Jan Smith, "Browser Basics: Printing", Feb. 3, 2003.|
|88||Jarkko Oikarinen and Darren Reed, "Internet Relay Chat Protocol," Nerwork Working Group, May 1993. (58 pages).|
|89||Karn P. et al., "The ESP Triple DES Transform," Network Working Group, Request for Comments: 1851, Category: Experimental, Sep. 1995, pp. 1-11.|
|90||Mark Day et al., "A Model for Presence and Instant Messaging", Network Working Group, Request for Comments 2778, The Internet Society, Feb. 2000.|
|91||Mark Handley et al., "SIP: Session Initiation Protocol", Network Working Group, Request for Comments 2543, The Internet Society, Mar. 1999.|
|92||Michael Tsai, "The Personal Computing Paradigm", ATPM Inc., 1998.|
|93||Microsoft Excel Print Screen Images (figs. 1-6).|
|94||Moran, Brian and Russ Whitney, "Getting to Know OLAP and MDX", Windows IT Pro, Instant Doc #5112, Apr. 1999.|
|95||Nicolas Pioch, "A Short IRC Primer", Jan. 1, 1997.|
|96||Notice of Allowance for U.S. Appl. No. 10/289,155, dated Jun. 11, 2009; 9 pages total.|
|97||Notice of Allowance for U.S. Appl. No. 10/289,155, dated Sep. 29, 2009; 7 pages total.|
|98||Notice of Allowance for U.S. Appl. No. 10/391,544, dated Aug. 13, 2010, 10 pages total.|
|99||Notice of Allowance for U.S. Appl. No. 10/391,544, dated Mar. 25, 2010, 12 pages total.|
|100||Notice of Allowance of U.S. Appl. No. 10/237,559 dated Aug. 21, 2008, 9 pages total.|
|101||Notice of Allowance of U.S. Appl. No. 10/289,139 dated May 1, 2007, 6 pages total.|
|102||Notice of Allowance of U.S. Appl. No. 10/289,142 dated Jan. 4, 2008, 9 pages total.|
|103||Notice of Allowance of U.S. Appl. No. 10/289,142 dated May 2, 2008, 5 pages total.|
|104||Notice of Allowance of U.S. Appl. No. 10/289,162 dated Apr. 16, 2008, 17 pages total.|
|105||Notice of Allowance of U.S. Appl. No. 10/289,162 dated Nov. 30, 2007, 12 pages total.|
|106||Notice of Allowance of U.S. Appl. No. 10/390,945 dated Jan. 9, 2008, 7 pages total.|
|107||Notice of Allowance of U.S. Appl. No. 10/390,945 dated Jun. 9, 2008, 7 pages total.|
|108||Office Action dated Feb. 1, 2008, issued in U.S. Appl. No. 10/237,559.|
|109||Office Action dated Feb. 5, 2008, issued in U.S. Appl. No. 11/299,441.|
|110||Office Action dated Jan. 28, 2008, issued in U.S. Appl. No. 10/289,155.|
|111||Office Action dated Jan. 4, 2008, issued in U.S. Appl. No. 10/391,073.|
|112||Office Action dated Nov. 30, 2007, issued in U.S. Appl. No. 10/289,162.|
|113||Office Action for U.S. Appl. No. 10/289,155, dated Aug. 6, 2007; 11 pages total.|
|114||Office Action for U.S. Appl. No. 10/289,155, dated Jul. 28, 2008, 10 pages total.|
|115||Office Action for U.S. Appl. No. 10/289,155, dated May 18, 2006; 11 pages total.|
|116||Office Action for U.S. Appl. No. 10/289,231, dated Apr. 12, 2010, 12 pgs.|
|117||Office Action for U.S. Appl. No. 10/390,978, dated Dec. 14, 2009, 25 pages total.|
|118||Office Action for U.S. Appl. No. 10/390,978, dated Feb. 21, 2007, 16 pages total.|
|119||Office Action for U.S. Appl. No. 10/390,978, dated Jan. 9, 2008, 16 pages total.|
|120||Office Action for U.S. Appl. No. 10/390,978, dated Jan. 9, 2008, 5 pages total.|
|121||Office Action for U.S. Appl. No. 10/390,978, dated Jun. 17, 2010, 28 pgs.|
|122||Office Action for U.S. Appl. No. 10/390,978, dated Mar. 5, 2009, 19 pages total.|
|123||Office Action for U.S. Appl. No. 10/390,978, dated Sep. 1, 2005, 15 pages total.|
|124||Office Action for U.S. Appl. No. 10/390,978, dated Sep. 4, 2009, 24 pages total.|
|125||Office Action for U.S. Appl. No. 10/391,073, dated Feb. 12, 2009, 8 pages total.|
|126||Office Action for U.S. Appl. No. 10/391,073, dated Feb. 8, 2007; 7 pages total.|
|127||Office Action for U.S. Appl. No. 10/391,073, dated Jan. 19, 2010; 9 pages total.|
|128||Office Action for U.S. Appl. No. 10/391,073, dated Jul. 30, 2009, 9 pages total.|
|129||Office Action for U.S. Appl. No. 10/391,073, dated Sep. 12, 2008, 9 pages total.|
|130||Office Action for U.S. Appl. No. 10/391,544, dated Aug. 28, 2009, 17 pages total.|
|131||Office Action for U.S. Appl. No. 10/391,544, dated Feb. 3, 2009, 16 pages total.|
|132||Office Action for U.S. Appl. No. 10/391,544, dated Sep. 17, 2008, 14 pages total.|
|133||Office Action for U.S. Appl. No. 10/391,544, dated Sep. 8, 2006, 12 pages total.|
|134||Office Action for U.S. Appl. No. 10/452,665, dated Dec. 7, 2006, 8 pages total.|
|135||Office Action for U.S. Appl. No. 11/299,441, dated Feb. 4, 2009, 19 pages total.|
|136||Office Action for U.S. Appl. No. 11/299,441, dated Jan. 5, 2010, 27 pages total.|
|137||Office Action for U.S. Appl. No. 11/299,441, dated Sep. 11, 2009, 22 pages total.|
|138||Office Action for U.S. Appl. No. 11/763,134, dated Jun. 3, 2010; 21 pages total.|
|139||Office Action of U.S. Appl. No. 10/237,559 dated Aug. 8, 2005, 11 pages total.|
|140||Office Action of U.S. Appl. No. 10/237,559 dated Feb. 1, 2008, 12 pages total.|
|141||Office Action of U.S. Appl. No. 10/237,559 dated Jan. 11, 2007, 10 pages total.|
|142||Office Action of U.S. Appl. No. 10/237,559 dated Jan. 31, 2005, 11 pages total.|
|143||Office Action of U.S. Appl. No. 10/289,139 dated Dec. 9, 2005, 14 pages total.|
|144||Office Action of U.S. Appl. No. 10/289,139 dated Nov. 30, 2006, 14 pages total.|
|145||Office Action of U.S. Appl. No. 10/289,142 dated Dec. 20, 2005, 9 pages total.|
|146||Office Action of U.S. Appl. No. 10/289,142 dated Dec. 4, 2006, 9 pages total.|
|147||Office Action of U.S. Appl. No. 10/289,162 dated Dec. 21, 2005, 12 pages total.|
|148||Office Action of U.S. Appl. No. 10/289,231 dated Apr. 30, 2009, 10 pages total.|
|149||Office Action of U.S. Appl. No. 10/289,231, dated Apr. 15, 2008, 12 pages total.|
|150||Office Action of U.S. Appl. No. 10/289,231, dated Dec. 9, 2005, 17 pages total.|
|151||Office Action of U.S. Appl. No. 10/289,231, dated Nov. 30, 2006, 13 pages total.|
|152||Office Action of U.S. Appl. No. 10/289,231, dated Nov. 6, 2008, 10 pages total.|
|153||Office Action of U.S. Appl. No. 10/390,945 dated Feb. 9, 2007, 8 pages total.|
|154||Office Action of U.S. Appl. No. 12/035,376 dated Sep. 15, 2010, 9 pages total.|
|155||Office Action of U.S. Appl. No. 12/039,471 dated Dec. 11, 2009, 13 pages total.|
|156||Perfetti, Christine and Jared M. Spool, "Macromedia Flash: A New Hope for Web Applications", User Interface Engineering, 2002.|
|157||Ramu Movva and William Lai, "MSN Messenger Service 1.0 Protocol," Internet Draft, Aug. 1999. (19 pages).|
|158||Randy Corke, "Keeping Data Warehouses Current: Automating Incremental Updates With Data Movement", DM Direct, May 1999.|
|159||Roman S. "Writing Excel Macros with VBA: Second Edition," Jun. 25, 2002, Chapter 6: Functions and Subroutines.|
|160||Stephen Brewster, "Windowing Systems", Glasgow Interactive Systems Group, 2001.|
|161||Steve Cimino, "How Can I Print a Web Page in ASP?", Internet.Com Corp., posted Jul. 27, 2001.|
|162||Thomas Loo and Martin Honnen, "How Can I Print a Document That is not Currently Loaded Into a Frame or Window," Synop Software, Apr. 24, 2002.|
|163||Tristan Richardson and Kenneth R. Wood, "The RFB Protocol," ORL Cambridge, Jul. 16, 1998. (26 pages).|
|164||U.S. Appl. No. 10/289,142, filed Nov. 5, 2002, Nicholls et al.|
|165||U.S. Appl. No. 10/289,155, filed Nov. 5, 2002, Netsch et al.|
|166||U.S. Appl. No. 10/289,231, filed Nov. 5, 2003, Beauchamp et al.|
|167||U.S. Appl. No. 10/390,945, filed Mar. 17, 2003, Broda et al.|
|168||U.S. Appl. No. 10/390,978, filed Mar. 17, 2003, Beauchamp et al.|
|169||U.S. Appl. No. 10/391,073, filed Mar. 17, 2003, Beauchamp et al.|
|170||U.S. Appl. No. 10/391,544, filed Mar. 17, 2003, Broda.|
|171||U.S. Appl. No. 10/452,665, filed Mar. 30, 2003, Broda.|
|172||U.S. Appl. No. 11/763,134, filed Jun. 14, 2007, Broda.|
|173||U.S. Appl. No. 12/035,376, filed Feb. 21, 2008, Nicholls et al.|
|174||U.S. Appl. No. 12/039,471, filed Feb. 28, 2008, Beauchamp et al.|
|175||Ünal A. "Electronic Commerce and Multi-enterprise Supply/Value/Business Chains," Information Sciences, Aug. 2000, pp. 63-68, vol. 127, Issues 1-2, NH Elsevier.|
|176||Using Microsoft Excel 97 Manual. Bestseller Edition. Que Corporation, 1997.|
|177||Wang, Wenjie and Jiaying Pan, "Instant Messaging Insight", Computer Science Department, New York University, Nov. 22, 2000.|
|Citing Patent||Filing date||Publication date||Applicant||Title|
|US8095679 *||19 Mar 2008||10 Jan 2012||Symantec Corporation||Predictive transmission of content for application streaming and network file systems|
|US8095872 *||11 Aug 2008||10 Jan 2012||Microsoft Corporation||Method and system for laying out paginated content for viewing—continuation|
|US8165993||12 Dec 2005||24 Apr 2012||Oracle International Corporation||Business intelligence system with interface that provides for immediate user action|
|US8191078||22 Mar 2005||29 May 2012||Progress Software Corporation||Fault-tolerant messaging system and methods|
|US8255454||30 May 2003||28 Aug 2012||Oracle International Corporation||Method and apparatus for a multiplexed active data window in a near real-time business intelligence system|
|US8276115||4 Feb 2008||25 Sep 2012||Progress Software Corporation||Automated construction and deployment of complex event processing applications and business activity monitoring dashboards|
|US8301720 *||18 Jul 2006||30 Oct 2012||Progress Software Corporation||Method and system to collect and communicate problem context in XML-based distributed applications|
|US8301800||1 Jul 2003||30 Oct 2012||Actional Corporation||Message processing for distributed computing environments|
|US8402095||28 Feb 2008||19 Mar 2013||Oracle International Corporation||Apparatus and method for instant messaging collaboration|
|US8516054||14 Nov 2001||20 Aug 2013||Aurea Software, Inc.||Message handling|
|US8566693 *||4 Apr 2011||22 Oct 2013||Oracle International Corporation||Application-specific personalization for data display|
|US8577989 *||14 Jun 2007||5 Nov 2013||Oracle International Corporation||Method and apparatus for a report cache in a near real-time business intelligence system|
|US8639804 *||2 Sep 2010||28 Jan 2014||Oracle International Corporation||Techniques for maintaining current content|
|US8656350||4 Feb 2008||18 Feb 2014||Software Ag||Event-based process configuration|
|US8826375 *||14 Apr 2008||2 Sep 2014||Lookwithus.Com Inc.||Rich media collaboration system|
|US8832580||5 Nov 2009||9 Sep 2014||Aurea Software, Inc.||Software with improved view of a business process|
|US9009234||5 Feb 2008||14 Apr 2015||Software Ag||Complex event processing system having multiple redundant event processing engines|
|US9094258||9 Aug 2012||28 Jul 2015||Oracle International Corporation||Method and apparatus for a multiplexed active data window in a near real-time business intelligence system|
|US9280319||18 Oct 2013||8 Mar 2016||Microsoft Technology Licensing, Llc||Integrated visualization for modeled customizations|
|US9288239||2 May 2014||15 Mar 2016||Iona Technologies, Plc||Method for recoverable message exchange independent of network protocols|
|US20020078132 *||14 Nov 2001||20 Jun 2002||Cullen William M.||Message handling|
|US20070106804 *||10 Nov 2005||10 May 2007||Iona Technologies Inc.||Method and system for using message stamps for efficient data exchange|
|US20080077656 *||14 Jun 2007||27 Mar 2008||Oracle International Corporation||Method and apparatus for a report cache in a near real-time business intelligence system|
|US20080196006 *||4 Feb 2008||14 Aug 2008||John Bates||Event-based process configuration|
|US20080209078 *||4 Feb 2008||28 Aug 2008||John Bates||Automated construction and deployment of complex event processing applications and business activity monitoring dashboards|
|US20080301548 *||11 Aug 2008||4 Dec 2008||Microsoft Corporation||Method and system for laying out paginated content for viewing - continuation|
|US20090260060 *||14 Apr 2008||15 Oct 2009||Lookwithus.Com, Inc.||Rich media collaboration system|
|US20120059929 *||2 Sep 2010||8 Mar 2012||Oracle International Corporation||Techniques for maintaining current content|
|US20120060078 *||4 Apr 2011||8 Mar 2012||Oracle International Corporation||Application-specific personalization for data display|
|US20120317474 *||12 Apr 2012||13 Dec 2012||IBT - Internet Business Technologies||Methods and systems for real-time web content publishing|
|U.S. Classification||709/227, 709/217|
|Cooperative Classification||H04L67/14, H04L67/02, G06F17/30563|
|European Classification||H04L29/08N13, G06F17/30S5E|
|17 Mar 2003||AS||Assignment|
Owner name: ITERATION SOFTWARE, INC., CALIFORNIA
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:BRODA, TAL;BEAUCHAMP, TIM J.;JACKSON, TANA CHRISTINE;ANDOTHERS;REEL/FRAME:013891/0365
Effective date: 20030313
|27 Sep 2007||AS||Assignment|
Owner name: ISTANTE SOFTWARE, INC., CALIFORNIA
Free format text: CHANGE OF NAME;ASSIGNOR:ITERATION SOFTWARE, INC.;REEL/FRAME:019892/0117
Effective date: 20040521
Owner name: ISTANTE SOFTWARE, INC.,CALIFORNIA
Free format text: CHANGE OF NAME;ASSIGNOR:ITERATION SOFTWARE, INC.;REEL/FRAME:019892/0117
Effective date: 20040521
|8 Oct 2007||AS||Assignment|
Owner name: ORACLE INTERNATIONAL CORPORATION, CALIFORNIA
Free format text: CHANGE OF NAME;ASSIGNOR:ISTANTE SOFTWARE, INC.;REEL/FRAME:019930/0108
Effective date: 20071003
Owner name: ORACLE INTERNATIONAL CORPORATION,CALIFORNIA
Free format text: CHANGE OF NAME;ASSIGNOR:ISTANTE SOFTWARE, INC.;REEL/FRAME:019930/0108
Effective date: 20071003
|26 Oct 2007||AS||Assignment|
Owner name: ORACLE INTERNATIONAL CORPORATION, CALIFORNIA
Free format text: CORRECTIVE ASSIGNMENT TO CORRECT THE NATURE OF CONVEYANCE FROM "CHANGE OF NAME" TO "ASSIGNMENT OF ASSIGNOR S INTEREST" PREVIOUSLY RECORDED ON REEL 019930 FRAME 0108;ASSIGNOR:ISTANTE SOFTWARE, INC.;REEL/FRAME:020018/0684
Effective date: 20071003
Owner name: ORACLE INTERNATIONAL CORPORATION,CALIFORNIA
Free format text: CORRECTIVE ASSIGNMENT TO CORRECT THE NATURE OF CONVEYANCE FROM "CHANGE OF NAME" TO "ASSIGNMENT OF ASSIGNOR S INTEREST" PREVIOUSLY RECORDED ON REEL 019930 FRAME 0108. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT OF THE PROPERTY IDENTIFIED IN THE ASSIGNMENT;ASSIGNOR:ISTANTE SOFTWARE, INC.;REEL/FRAME:020018/0684
Effective date: 20071003
Owner name: ORACLE INTERNATIONAL CORPORATION, CALIFORNIA
Free format text: CORRECTIVE ASSIGNMENT TO CORRECT THE NATURE OF CONVEYANCE FROM "CHANGE OF NAME" TO "ASSIGNMENT OF ASSIGNOR S INTEREST" PREVIOUSLY RECORDED ON REEL 019930 FRAME 0108. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT OF THE PROPERTY IDENTIFIED IN THE ASSIGNMENT;ASSIGNOR:ISTANTE SOFTWARE, INC.;REEL/FRAME:020018/0684
Effective date: 20071003
|4 Oct 2011||CC||Certificate of correction|
|15 Oct 2014||FPAY||Fee payment|
Year of fee payment: 4