New! View global litigation for patent families

US20030182261A1 - Queuing model for a plurality of servers - Google Patents

Queuing model for a plurality of servers Download PDF

Info

Publication number
US20030182261A1
US20030182261A1 US10366475 US36647503A US2003182261A1 US 20030182261 A1 US20030182261 A1 US 20030182261A1 US 10366475 US10366475 US 10366475 US 36647503 A US36647503 A US 36647503A US 2003182261 A1 US2003182261 A1 US 2003182261A1
Authority
US
Grant status
Application
Patent type
Prior art keywords
server
query
service
request
requests
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
US10366475
Other versions
US7333974B2 (en )
Inventor
James Patterson
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
International Business Machines Corp
Original Assignee
Cognos Inc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date

Links

Images

Classifications

    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/10Network-specific arrangements or communication protocols supporting networked applications in which an application is distributed across nodes in the network
    • H04L67/1002Network-specific arrangements or communication protocols supporting networked applications in which an application is distributed across nodes in the network for accessing one among a plurality of replicated servers, e.g. load balancing
    • H04L67/1036Load balancing of requests to servers for services different from user content provisioning, e.g. load balancing to DNS servers or firewalls
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/10Network-specific arrangements or communication protocols supporting networked applications in which an application is distributed across nodes in the network
    • H04L67/1002Network-specific arrangements or communication protocols supporting networked applications in which an application is distributed across nodes in the network for accessing one among a plurality of replicated servers, e.g. load balancing
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/10Network-specific arrangements or communication protocols supporting networked applications in which an application is distributed across nodes in the network
    • H04L67/1002Network-specific arrangements or communication protocols supporting networked applications in which an application is distributed across nodes in the network for accessing one among a plurality of replicated servers, e.g. load balancing
    • H04L67/1004Server selection in load balancing
    • H04L67/1012Server selection in load balancing based on compliance of requirements or conditions with available server resources
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/10Network-specific arrangements or communication protocols supporting networked applications in which an application is distributed across nodes in the network
    • H04L67/1002Network-specific arrangements or communication protocols supporting networked applications in which an application is distributed across nodes in the network for accessing one among a plurality of replicated servers, e.g. load balancing
    • H04L67/1004Server selection in load balancing
    • H04L67/1023Server selection in load balancing based on other criteria, e.g. hash applied to IP address, specific algorithms or cost
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99932Access augmentation or optimizing
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99951File or database maintenance
    • Y10S707/99952Coherency, e.g. same view to multiple users
    • Y10S707/99953Recoverability

Abstract

The current invention provides a system and method for queuing and distributing requests to one or more query servers. The system contains a first tier queue associated with a server based mechanism for directing service requests to a second tier queue associated with each of the one or more query servers. The current invention provides a “pull” model for the distribution of an initial service request of a query containing two or more service requests. Subsequent service requests from this query are assigned to a query server without being placed in a first tier queue. These subsequent service requests are placed directly in the queue of the query server that handled the previous service request from the same query.

Description

    FIELD OF INVENTION
  • [0001]
    The invention relates generally to computers, and more particularly to a queuing model for accessing information from a plurality of servers.
  • BACKGROUND OF THE INVENTION
  • [0002]
    There are two basic models used for creating a queue. They are commonly known as the bank line model and the grocery line model because of their use in these industries. The bank line model employs a single queue that is serviced by a plurality of service providers. In this model the queue advances by one each time a service provider becomes available and the first request in the queue is assigned to the newly available service provider. The time that a request resides in the queue is a function of the service times for all of the requests that are in front of it in the queue. This model of queuing is functionally known as a “pull” model whereby service requests are pulled from the queue when they can be fulfilled.
  • [0003]
    The grocery store model, on the other hand, employs a queue for each service provider. This model of queuing employs a “push” model of assignment whereby requests are assigned to a queue associated with each service provider. Generally there is a control mechanism associated with such queues that tries to estimate the time required to fulfill the tasks in each queue. This information is then fed into an optimisation scheme to determine to which queues service requests should be assigned. The time required for service in the grocery store model is quite variable due to the possibility of entering a queue where all of the requests that are ahead in the queue are serviced quite quickly or the possibility that one or more of the requests in the queue require considerable time to be serviced. In general the time required to fill a request in the bank line model is considerably less variable, but not necessarily less, because every request in the queue is dependant on the time required for each request being served ahead of it. There are no “faster” queues in this model. A disadvantage in either model is the possibility of a request being serviced by a provider that is not well suited for the request.
  • [0004]
    The above discussion of queuing models should now be brought into the context of information retrieval systems where requests for information are presented to a plurality of servers or mechanisms operating thereon that are capable of providing the requested information. The queues used in such information retrieval systems are often, more refined derivatives of the basic queuing models presented above with the refinements reflecting the desire for improved efficiency and an optimization of the method of dealing with requests from a particular client type or requesting information of a particular type.
  • [0005]
    The servers and mechanisms operating thereon used for the delivery of information are often arranged in two tiers. The first tier generally contains a mechanism that interfaces between a source of service requests and the servers of the second tier. The first tier also contains a mechanism that manages the assignment of requests to the second tier servers. Second tier servers that supply the information requested in service requests are referred to as query servers. A first tier server further will contain a queue (first tier queue) which holds service requests prior to them being distributed to a query server. The distribution of requests contained in the first tier queue to query servers can take place by one of two methods; they can be “pushed” by the first tier server on to a server of the second tier or they can be “pulled” from the first tier server by a server of the second tier, which can be either a query server or a server that manages a group of query servers. These two basic methods of assigning requests have advantages and disadvantages that at least in part reflect the nature of client requests being serviced. Both of these strategies require a first tier server that manages the assignment of service requests and maintains a queue that holds service requests prior to their distribution to query servers.
  • [0006]
    The “push” model of assigning requests to a server generally uses a two tier queue model. Service requests are queued in the first tier queue until they are assigned to a query server where they will be queued again. There are numerous approaches to assigning a request to a query server which generally rely on some form of server management. In one case the server that maintains the “main” queue, or an associated control server, maintains data on the response time required for query servers to fulfill service requests. This data, or calculations based on it, is used by the server of the first tier when assigning requests to query servers. The process aims to minimise the response time for a given service request. However, the ability to predict the time required for a given query server to fulfill a newly assigned service request is never completely accurate, casting doubt on the usefulness of the exercise. In another “push” model service requests are assigned to servers according to the request “type”. Service requests are assigned to a query server if that server is currently servicing requests of the same type. If there are no servers currently fulfilling service requests of the same type as the request about to be assigned to a query server the requests is assigned based on the above or similar server management considerations.
  • [0007]
    A second model for the assignment of requests in a queue is the “pull” model. The pull model also employs a two tier arrangement of servers. The level of server management that is required for the assignment of service requests is quite a bit lower than with the “push” model. Servers of the second tier simply indicate that they are ready to accept another service request instead of a control server requesting status updates for the second tier servers to determine their current request load.
  • [0008]
    In U.S. Pat. No. 6,023,722, Coyler presents a “pull” queue model that is applied to servicing of information requests from the World Wide Web. There is only one queue, associated with the first tier server, in the system presented in this patent. A queue at the second tier servers is not necessary as a new service request is only assigned to a second tier server once the server has completed the previous request and has indicated that it is ready to process another request. It is indicated that this model of assigning information requests to server of the second tier is more efficient because the server managing the main queue does not have to continually query the second tier servers to determine their current status.
  • [0009]
    Business Intelligence (BI) applications are often focussed on the production and editing of complex reports that are based on information contained in a data warehouse. The manipulation (including editing and authoring) of such reports involves multiple requests for data from a database. Thus the manipulation of such reports requires multiple requests to the database or data warehouse to obtain the required information. These multiple requests are often included in the same general query to the data warehouse. For example, the results of a query request are usually presented in pages, typically, of say 10 rows of data per page, with an individual service request being required to return each of these query pages.
  • [0010]
    It is the nature of contemporary database systems that information requests to a database usually involve a query preparation stage followed by a stage where rows of data are retrieved. Most of the data processing associated with a request to a database is generally performed in the query preparation stage (e.g. all rows of data identified in the query may need to be sorted). Thus, in cases of a plurality of requests within a single query the resources (and cost) associated with the first request of a query are often considerably higher than those associated with later requests against the same query. These later requests will only need to retrieve a fixed number of additional rows and not perform the preparatory work associated with the query.
  • [0011]
    Editing of business intelligence reports is also enabled by server requests which retrieve “metadata” or descriptions of the underlying reports themselves for the client to modify or apply modifications to those report definitions to a persistent store of reports. The query servers in this application provide the database access and document formatting necessary to create these reports dynamically based upon requests from the clients. Any activity of sufficient complexity or which needs to access centralized resources would benefit from a client-server architecture that reflects the above use of multiple requests within a single query.
  • [0012]
    There is a need for a system and method of providing information from a database to queries to the database that contain numerous service requests. The system and method should consider efficiencies related to the provision of information to closely related requests within a single query.
  • SUMMARY OF THE INVENTION
  • [0013]
    The current invention provides a system and method for queuing and distributing requests to one or more query servers. The system contains a first tier queue associated with a server based mechanism for directing service requests to a second tier queue associated with each of the one or more query servers. The current invention provides a “pull” model for the distribution of an initial service request of a query containing two or more service requests. Subsequent service requests from this query are assigned to a query server without being placed in a first tier queue. These subsequent service requests are placed directly in the queue of the query server that handled the previous service request from the same query.
  • BRIEF DESCRIPTION OF THE DRAWINGS
  • [0014]
    The invention will be described with reference to the accompanying drawings, wherein:
  • [0015]
    [0015]FIG. 1 is a schematic diagram illustrating elements of the queuing model according to an embodiment of the invention;
  • [0016]
    [0016]FIG. 2 is a schematic diagram illustrating an arrangement of servers and queues that are suitably used in an embodiment of the invention;
  • [0017]
    [0017]FIG. 3 is a flow chart illustrating steps related to the movement of service requests associated with the gateway according to one embodiment of the invention;
  • [0018]
    [0018]FIG. 4 is a flow chart illustrating steps related to the movement of service requests associated with the dispatcher request listener process thread according to one embodiment of the invention; and
  • [0019]
    [0019]FIG. 5 is a flow chart is a flow chart illustrating steps related to the movement of service requests associated with the dispatcher query server monitor process thread according to one embodiment of the invention.
  • DETAILED DESCRIPTION OF EMBODIMENTS OF THE INVENTION
  • [0020]
    [0020]FIG. 1 is a schematic diagram illustrating an embodiment of the invention. A service request 10 is provided to a system 18 for the provision of information requested therein. Receipt of the service request 10 leads to the invoking of a gateway 12. The gateway 12 either forwards the service request to a dispatcher 14 to be placed in a queue contained therein or it forwards the service request to a query server 16. Specifics of the service request 10 will determine how it is routed by the gateway 12 within the system 18. Service requests that are queued in the dispatcher 14 are dequeued and returned to the gateway 12 for forwarding to the query server 16 after the query server 16 indicates it is able to accept a service request.
  • [0021]
    The system of the current embodiment and an arrangement of servers on which this system is suitably used is schematically presented in FIG. 2. A web server 202 acts as a source of service requests for the system and method of the current embodiment. The service requests may be queued in a queue 204 that is an element of the web server 202. A gateway 205 is an interface component between the web server 202 and at least one server based mechanism of the current embodiment.
  • [0022]
    The gateway 205 is connected to and in communications with a dispatcher 206. This connection is formed by a communications link 208. The dispatcher 206 is a server based mechanism that directs service requests that are provided to it by the gateway 205. The dispatcher 206 contains queue 210 that is suitable for queuing service requests. The dispatcher 206 may be considered as an element of the first tier and queue 210 maybe considered as a first tier queue.
  • [0023]
    The gateway 205 is further connected to and in communications with one of servers 214 and 216 via communications links 215 and 217, respectively. The servers 214 and 216 generally provide an information provision mechanism that can retrieve information from a database or data warehouse. They more specifically provide query server processes. Servers 214 and 216 will be referred to as query servers to reflect the mechanisms operating thereon. The query servers 214 and 216 contain a queue, 218 and 220, respectively.
  • [0024]
    A server manager 222 is connected to and in communication with query servers 214 and 216 via communications links 224 and 226, respectively. The server manager 222 is further connected to and in communications with the dispatcher 206 via communications link 228. In the current embodiment the query servers 214 and 216 and the server manager 222 are mechanisms operating on a single server 230. The server 230 and the queues contained therein may be considered as from the “second tier”.
  • [0025]
    The communications links 208, 215, 217, 224, 226 and 228 are any suitable communications links as would be apparent to those of skill in the art. This includes both hardware and software links for instances where the servers are physically separate entities or elements of the same computer, respectively. In the current embodiment industry standard TCP/IP networking protocols are implemented. However, it will be apparent to one skilled in the art that any networking protocols could be substituted without affecting the scope of the embodiments of the invention. Communication links which provide for communications amongst processes operating or the same machine, communication links i.e. 224 and 226, are implemented using non-networked interprocess protocols as will be known to those of skill in the art. Such interprocess protocols may be more efficient in some environments.
  • [0026]
    The operation of the system of the current embodiment will now be discussed. The web server 202 is able to queue service requests in queue 204 prior to the invocation of gateway 205. The gateway 205 is invoked by the web server 202 upon the receipt of a service request by the web server 202. This invocation of gateway 205 is performed for each service request. Service requests received from the web server 202 are passed to the gateway 205 using a common gateway interface protocol, as will be known to those of skill in the art. There may be a plurality of active gateway requests at any particular point in time, a gateway request being a service request that is delivered by the gateway 205. After invoking gateway 205 web server 202 is not involved in the distribution and queuing of service requests.
  • [0027]
    The dispatcher 206 is connected to and in communication with the server manager 222. The server manager 222 is connected to and associated with query servers 214 and 216. The server manager 222 monitors the activity, including availability and performance, on the query servers 214 and 216. The server manager 222 provides this information to the dispatcher 206. For example the dispatcher 206 receives the network address of an available query server from server manager 222 and forwards this address to the gateway 205. Gateway 205 further negotiates between dispatcher 206 and query servers 214 and 216.
  • [0028]
    The server manager 222 is a server based mechanism that provides a controlling process for the one or more query server processes executing on the query servers 214 and 216. The server manager 222 is responsible for initiating and terminating the configured number of query server processes according to the requirements of the system and it monitors each query server process to ensure that it is functioning correctly. Server manager 222 further maintains an open connection to the query servers 214 and 216 associated with it. The query servers 214 and 216 communicate status information to the server manager process that started it as service requests are initiated or completed to the server manager 222. As the server manager 222 receives this information it collects it into packets and forwards it along to any dispatcher that may have registered with it.
  • [0029]
    The queuing of service requests in the first tier queue 210 of the dispatcher 206 and the distribution of service requests by the gateway 205 is facilitated by a process comprising steps that are performed by the dispatcher 206 and the gateway 205. The process according to an embodiment of the invention will be presented in three flow charts. FIG. 3 considers the steps that are performed by the gateway 205 while FIGS. 4 and 5 consider those steps that are performed by the dispatcher 206.
  • [0030]
    [0030]FIG. 3 is a flow chart illustrating steps occurring on the gateway 205 which are associated with the movement of service requests through the system of the current embodiment. A service request is received at step 300 and the gateway 205 is invoked. The gateway 205 interrogates the service request at step 302 to determine if there is a server identification parameter included with it.
  • [0031]
    Server identification parameters are included with a response to a service request and will be included with subsequent service requests from the same query. Server identification parameters identify the query server to which a previous service request from the same query was dispatched. In the current embodiment the server identification is encoded in a parameter of the form IWS_SRVLOC=value where value specifies the network location of the query server that bad previously handled a request from the same query as the current request. Each instance of the query server must have a unique network identity. In a TCP/IP network this is provided by the IP address and a TCP port number. The Server Identification Parameter encodes this information into a string format that is consistent with the web server protocol where it is used. It will be apparent to those skilled in the art that the server identification parameter can possess other formats that indicate the network location of the query server.
  • [0032]
    If the service request has a server identification parameter associated with it the service request is forwarded to the query server identified in the server identification parameter at step 308. Thus, a service request with which a server identification parameter is included is forwarded directly from gateway 205 to the query server identified by the server identification parameter. A service request that is the first request of a query will not have a server identification parameter included with it. If the service request does not have a server identification parameter included with it the gateway 205 forwards the service request to the dispatcher 206 at step 304. In the current embodiment the entire service request is not actually forwarded to the dispatcher. Rather a service request's identification information including the user and application is forwarded to the dispatcher 206. It will be apparent to one skilled in the art that additional identification information or the entire service request could be forwarded to the dispatcher 206. At step 306 the gateway 205 receives a query server identification from the dispatcher 206 for a query server that has indicated it is available for a service request. The gateway 205 forwards the service request to the query server identified in the query server identification at step 310. At either step 308 or step 310 the service request is placed in the queue associated with the query server to which the request is routed.
  • [0033]
    A flow chart illustrating the steps that are performed by the dispatcher 206 with respect to interactions with the gateway 205 is presented in FIG. 4. These steps are steps in the request listener process thread i.e. where the dispatcher listens for service requests from the gateway. At step 402 the dispatcher 206 waits to receive a service request from the gateway 205. At step 404 the dispatcher 206 receives a service request from the gateway 205. At step 406 the dispatcher 206 queries whether there is a query server available to receive the service request. If there is a query server available the dispatcher 206 provides the server identification parameter of the available server to the gateway 205 at step 410. This identification parameter is received by the gateway 205 at step 306 of FIG. 2. If there is no available query server at step 406 the service request is placed in the queue 210 of the dispatcher 206. The process returns to step 402 from either step 410 or 408.
  • [0034]
    [0034]FIG. 5 presents a flow chart of another processing thread that is performed by the dispatcher 206. This processing thread monitors for available query servers. The dispatcher 206 waits for a query server status update at step 502. Such a status update is provided to the dispatcher 206 when the status of a query server changes. Such changes include a query server becoming busy with a new service request and a query server becoming available when it finishes completing all requests currently assigned to it. This process of updating the dispatcher 206 follows a “pull” model of distributing queued service requests. At step 504 the dispatcher 206 receives such an update. At step 506 the dispatcher 206 queries the update as to whether a query server is available. If a query server has become available the dispatcher 206 examines queue 210, at step 508, as to determine whether there are gateway requests awaiting a query server. Such waiting gateway requests were placed in the queue 210 of dispatcher 206 at step 408 of FIG. 4. If there are waiting gateway requests the dispatcher 206 dequeues a waiting gateway request at step 511. The dispatcher 206 then forwards the service request with a query server identification of an available query server to the gateway 205 at step 512. The query server identification is received by the gateway 205 at step 306 of FIG. 3. Else, if there are no service requests awaiting a query server, the dispatcher 206 marks the available query server as such. If the update received at step 504 indicated a query server is busy the dispatcher 206 marks the query server as unavailable at step 514. The process now returns to step 502.
  • [0035]
    A service request waiting in the queue 210 of the dispatcher 206 remains queued until the requests in front of it in the queue are dispatched and a query server identifies itself as available to accept a new request. A query server is deemed available when it no longer has requests queued in its queue. Thus the query servers “pull” service requests from queue 210 of dispatcher 206.
  • [0036]
    Even though a given query server may indicate that it is available for a new service request in the server status update a service request forwarded to it may be qeueued in the queue of the query server. This situation may arise if one or more service requests that have a server identification parameter attached to them were forwarded to the query server during the time the query server became available and the time the text queued service request was forwarded to it.
  • [0037]
    It is a characteristic of the business intelligence application to which the current embodiment is applied that there are frequently groups of related service requests which are more efficiently executed by a single server. For example, the results of a query request are usually presented in pages, typically, of say 10 rows of data per page, with an individual service request being required to return each of these query pages. A refinement of the basic invention allows service requests which are related to a previous service request, in this respect, (e.g. all requests for pages with the exception of the very first page) to be queued directly to the queue of the query server that processed the initial request.
  • [0038]
    In the queuing model and method of operation thereof of the present invention the selection of a query server to which a request is forwarded is made by the dispatcher 206. The dispatcher 206 considers a number of factors when making this decision. These parameters will now be discussed. The dispatcher 206 considers the overhead associated with establishing and disconnecting from query sessions. All requests handled by the application servers must have an associated user for authentication purposes. For every user handled by a specific query server, a user session is created, that is, a user session defines the relationship between a particular identified user and a specific query server. Each user session has some associated overhead such as database handles and computer memory, so the overall capacity of the system is improved if the total number of user sessions can be optimized. The queue selection algorithm employed by the dispatcher 206 will not in fact be a strictly first in first out scheme. Rather a history of query server service request interactions for previous user-based requests is maintained. Further numerous parameters and the values they identify are used to refine the behaviour of the queuing mechanism associated with the queue 210 of the dispatcher 206.
  • [0039]
    Max Server Session is a parameter that specifies the number of servers upon which each user can be active. If a request for a server arrives for a user, and no available server is active for that user, then an idle server will be assigned as long as the current number of servers associated with that user is less than this value.
  • [0040]
    Setting this value to 1 has the effect of locking user sessions to a single server. Setting it to the number of servers (or higher) allows a user session to go to any inactive server, though precedence will still be given to servers where an associated user session is already active.
  • [0041]
    Request Limit is a parameter that defines the total number of requests that can be waiting for service at any one time. If a request arrives when the number of requests in query server queues is equal to Request Limit the new request will be turned away. A message that indicates “Servers all busy” will be returned to the client.
  • [0042]
    Because servers often will have a request running, but may quickly finish them and become available, a Minimum Idle Wait interval can ensure that new user sessions are not created arbitrarily. If a Minimum Idle Wait interval is established and a request is received for a user which has not reached the Max Server Session limit, then the dispatcher 206 will wait at least this long before assigning a new query server for a request if none is currently available.
  • [0043]
    It is more costly to switch a user to a new server if the user already has its quotas of session servers active. This is because the cost incurred is not only the cost of initiating a new session but also of closing one of the existing sessions in order to keep the overall session count within that defined by Max Server Session. Consequently, a separate metric called Minimum Switch Wait is provided to define the time to wait before a user which already has Max Server Session servers assigned will be switched to a new server and have a preexisting session closed. This will typically be several times the value for Minimum Idle Wait. If it is set to “unlimited” users will not be switched to idle servers once they reach Max Server Session. Instead they will remain in the main queue until a server where they are already resident becomes available.
  • [0044]
    The current embodiment of the invention has been presented with a particular number of dispatchers, server managers and query servers. It will be apparent to one skilled in the art that the numbers of specific elements of the arrangement of servers suitably used by an embodiment of the invention is for exemplary purposes only. The specific number of these components may vary and still lie within the scope of the invention.
  • [0045]
    An embodiment of the invention that contains a server manager located between the dispatcher 206 and query servers has been presented. Server managers are implemented when the number of sockets being maintained in an “open” state is of importance. In an alternative embodiment of the invention there are no server managers located between the query servers and the dispatcher 206. Such an embodiment is straightforward to derive within the scope of the invention. In this embodiment, each query server communicates its status (ready or busy) directly back to the dispatcher 206 rather than communicating to the server manager which batches up and relays this information to the dispatcher 206. This embodiment is simpler and so may be more efficient in situations with a smaller number of servers. The disadvantage of not using a server manager is that there will be more communication paths to the dispatcher 206. This could lead to a resource issue on the computer system on which the dispatcher 206 resides if there are a large number of individual query servers.
  • [0046]
    While the invention has been described according to what is presently considered to be the most practical and preferred embodiments, it must be understood that the invention is not limited to the disclosed embodiments. Those ordinarily skilled in the art will understand that various modifications and equivalent structures and functions may be made without departing from the spirit and scope of the invention as defined in the claims. Therefore, the invention as defined in the claims must be accorded the broadest possible interpretation so as to encompass all such modifications and equivalent structures and functions.

Claims (13)

    What is claimed is:
  1. 1. A system for the distribution of service requests to one or more query servers that are suitable for fulfilling the service requests, the system being operable on a plurality of servers, the system comprising:
    an interface component, the interface component being; suitable for operation on the plurality of servers, suitable to determine if the service request is to be directed to a pre-identified query server and suitable for distributing the service request to either the pre-identified query server or a query server available to accept the service request; and
    a first server based mechanism for receiving information related to the at least one query server, the server based mechanism communicating with the interface component and directing the interface component in the distribution of service requests.
  2. 2. A system according to claim 1 further comprising a second server based mechanism, the second server based mechanism collecting information related to the operation of the query servers, the second server based mechanism communicating the collected information to the first server based mechanism.
  3. 3. A system according to claim 1 wherein the first server based mechanism comprises a queue appropriate for maintaining service requests.
  4. 4. A system for the provision of information from a database to a client that provides a service request requesting information, the system comprising:
    an interface component, the interface component being; suitable for operation on the plurality of servers, suitable to determine if the service request is to be directed to a pre-identified query server and suitable for distributing the service request to either the pre-identified query server or a query server available to accept the service request;
    one or more query servers, the one or more query servers being suitable for receiving service requests from the interface component and being suitable for the provision of information requested in the service requests;
    a first server based mechanism for receiving information related to the at least one query server, the server based mechanism with the interface component and directing the interface component in the distribution of service requests; and
    a first server, the first server being suitable for the operation of the first server based mechanism thereon and being suitable for communication with the interface component.
  5. 5. A system according to claim 4 wherein the first server comprises a queue appropriate for maintaining service requests.
  6. 6. A system according to claim 4 wherein the one or more query servers comprise a queue appropriate for maintaining service requests.
  7. 7. A system according to claim 4 further comprising:
    a second server based mechanism, the second server based mechanism being suitable for collecting information related to the operation of the query servers and providing this information to the first server based mechanism.
  8. 8. A system according to claim 7 wherein the first server comprises a queue appropriate for maintaining service requests.
  9. 9. A system according to claim 7 wherein the one or more query servers comprise a queue appropriate for maintaining service requests.
  10. 10. A method or routing a service request to a query server, the query server being elements of a system for the distribution of service requests containing one or more query servers, the system further comprising an interface component for interfacing between a source of service requests and the query servers of the system and a mechanism for directing service requests, the method comprising the steps of:
    invoking of the interface component by the source of service requests upon the receipt of a service request;
    routing of service requests by the interface component to either the mechanism for directing service requests or a query server;
    monitoring of the interface component by the mechanism for directing service requests; and
    monitoring of the one or more query servers or notification from the query servers regarding the status of the query servers.
  11. 11. A method of routing service requests by the interface component, the method comprising the steps of:
    interrogating a service request to determine if a server identification parameter is included with the service request;
    forwarding identification information related to the service request to the mechanism for directing service requests if the service request does not have a server identification parameter included with it;
    receiving a query server identification for a query server that is available for accepting the service request;
    forwarding of the service request to the query server identified by the query server identification; and
    forwarding the service request to the query server identified in the server identification parameter if the service request has a server identification parameter included with it.
  12. 12. A method of monitoring an interface component by the mechanism for directing service requests, the method comprising the steps of:
    waiting to receive a service request from the interface component, the interface component providing an interface between a source of service requests and . . . ;
    receiving a service request from the interface component, the interface component providing an interface between a source of service requests and . . . ;
    determining if a query server is available for the acceptance of a service request for the provision of information thereto;
    placing the service request in a queue associated with the mechanism for directing service requests if there is no query server available to accept the service request; and
    forwarding the service request and query server identification related to the query server that is able to accept the service request to the interface component if a query server was determined to be available to accept the service request.
  13. 13. A method of monitoring one or more query servers by the mechanism for directing one or more service requests to query servers for notification from the query servers regarding the status of the query servers, the method comprising the steps of:
    waiting for a notification related to the query server status;
    receiving a notification related to the query server status;
    determining if the query server that provided a notification related is available or unavailable to accept the service request;
    determining if service requests are waiting for a query server to become available to accept a service request, if a query server has become available to accept a service request;
    dequeuing a service request from the queue associated with the mechanism for directing service requests, if a service request is waiting for a query server to become available to accept a service request;
    forwarding the service request and query server identification related to the query server that is able to accept the service request to the interface component;
    marking the available query server as available if there are no service request is waiting for a query server to become available to accept a service request; and
    marking the unavailable query server as unavailable if a query server has indicated it is unavailable to accept a service request.
US10366475 2002-02-15 2003-02-14 Queuing model for a plurality of servers Expired - Fee Related US7333974B2 (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CA2,372,092 2002-02-15
CA 2372092 CA2372092C (en) 2002-02-15 2002-02-15 A queuing model for a plurality of servers

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US12000394 US7895231B2 (en) 2002-02-15 2007-12-12 Queuing model for a plurality of servers

Publications (2)

Publication Number Publication Date
US20030182261A1 true true US20030182261A1 (en) 2003-09-25
US7333974B2 US7333974B2 (en) 2008-02-19

Family

ID=27768272

Family Applications (2)

Application Number Title Priority Date Filing Date
US10366475 Expired - Fee Related US7333974B2 (en) 2002-02-15 2003-02-14 Queuing model for a plurality of servers
US12000394 Active 2024-02-26 US7895231B2 (en) 2002-02-15 2007-12-12 Queuing model for a plurality of servers

Family Applications After (1)

Application Number Title Priority Date Filing Date
US12000394 Active 2024-02-26 US7895231B2 (en) 2002-02-15 2007-12-12 Queuing model for a plurality of servers

Country Status (2)

Country Link
US (2) US7333974B2 (en)
CA (1) CA2372092C (en)

Cited By (20)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20060048217A1 (en) * 2004-08-27 2006-03-02 International Business Machines Corporation Secure bidirectional cross-system communications framework
US20060143328A1 (en) * 2004-12-28 2006-06-29 Christian Fleischer Failover protection from a failed worker node in a shared memory system
US20060143618A1 (en) * 2004-12-28 2006-06-29 Christian Fleischer Connection manager that supports failover protection
US20060174011A1 (en) * 2005-02-01 2006-08-03 Microsoft Corporation Mechanism for preserving session state when using an access-limited buffer
US20100185847A1 (en) * 2009-01-20 2010-07-22 New York University Database outsourcing with access privacy
US8423662B1 (en) * 2003-04-28 2013-04-16 Akamai Technologies, Inc. Forward request queuing in a distributed edge processing environment
US8707323B2 (en) 2005-12-30 2014-04-22 Sap Ag Load balancing algorithm for servicing client requests
US20150046960A1 (en) * 2004-06-29 2015-02-12 Time Warner Cable Enterprises Llc Method and apparatus for network bandwidth allocation
US20150324244A1 (en) * 2014-05-09 2015-11-12 Wipro Limited System and method for a smart operating system for integrating dynamic case management into a process management platform
US9244966B2 (en) 2012-10-30 2016-01-26 International Business Machines Corporation Method and system for reducing lock occurrences in server/database systems
US9584839B2 (en) 2007-10-15 2017-02-28 Time Warner Cable Enterprises Llc Methods and apparatus for revenue-optimized delivery of content in a network
US9613109B2 (en) 2015-05-14 2017-04-04 Walleye Software, LLC Query task processing based on memory allocation and performance criteria
US9632723B1 (en) * 2004-10-15 2017-04-25 Amazon Technologies, Inc. Providing a reliable distributed queuing service
US9696903B2 (en) 2013-08-09 2017-07-04 Zoomdata, Inc. Real-time data visualization of streaming data
US20170220574A1 (en) * 2012-05-15 2017-08-03 Microsoft Technology Licensing, Llc Scenario based insights into structure data
US9811567B2 (en) 2015-02-27 2017-11-07 Zoomdata, Inc. Prioritization of retrieval and/or processing of data
US9817871B2 (en) 2015-02-27 2017-11-14 Zoomdata, Inc. Prioritized retrieval and/or processing of data via query selection
US9883223B2 (en) 2012-12-14 2018-01-30 Time Warner Cable Enterprises Llc Apparatus and methods for multimedia coordination
US9930387B2 (en) 2005-02-01 2018-03-27 Time Warner Cable Enterprises Llc Method and apparatus for network bandwidth conservation
US9934266B2 (en) 2016-05-14 2018-04-03 Walleye Software, LLC Memory-efficient computer system for dynamic updating of join processing

Families Citing this family (28)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7222148B2 (en) * 2002-05-02 2007-05-22 Bea Systems, Inc. System and method for providing highly available processing of asynchronous service requests
US20060075092A1 (en) * 2004-10-06 2006-04-06 Kabushiki Kaisha Toshiba System and method for determining the status of users and devices from access log information
KR100645537B1 (en) * 2005-02-07 2006-11-14 삼성전자주식회사 Method of dynamic Queue management for the stable packet forwarding and Element of network thereof
US7945041B2 (en) * 2005-05-27 2011-05-17 International Business Machines Corporation Method, system and program product for managing a customer request
US7689660B2 (en) * 2005-06-09 2010-03-30 Sap Ag Application server architecture
US8312507B2 (en) 2006-10-17 2012-11-13 A10 Networks, Inc. System and method to apply network traffic policy to an application session
US8584199B1 (en) 2006-10-17 2013-11-12 A10 Networks, Inc. System and method to apply a packet routing policy to an application session
US8209685B1 (en) * 2007-11-26 2012-06-26 Adobe Systems Incorporated Virtual machine device access
EP2065803A1 (en) * 2007-11-30 2009-06-03 Neutrino Concepts Ltd. Parallel pipelining and width processing
US8392402B2 (en) * 2008-12-03 2013-03-05 International Business Machines Corporation Hybrid push/pull execution of continuous SQL queries
US20110093522A1 (en) * 2009-10-21 2011-04-21 A10 Networks, Inc. Method and System to Determine an Application Delivery Server Based on Geo-Location Information
US9215275B2 (en) 2010-09-30 2015-12-15 A10 Networks, Inc. System and method to balance servers based on server load status
US9609052B2 (en) * 2010-12-02 2017-03-28 A10 Networks, Inc. Distributing application traffic to servers based on dynamic service response time
US8897154B2 (en) 2011-10-24 2014-11-25 A10 Networks, Inc. Combining stateless and stateful server load balancing
US9386088B2 (en) 2011-11-29 2016-07-05 A10 Networks, Inc. Accelerating service processing using fast path TCP
US9094364B2 (en) 2011-12-23 2015-07-28 A10 Networks, Inc. Methods to manage services over a service gateway
EP2820583A4 (en) * 2012-02-29 2015-11-25 Hewlett Packard Development Co Network service interface analysis
US8782221B2 (en) 2012-07-05 2014-07-15 A10 Networks, Inc. Method to allocate buffer for TCP proxy session based on dynamic network conditions
US9843484B2 (en) 2012-09-25 2017-12-12 A10 Networks, Inc. Graceful scaling in software driven networks
JP2015534769A (en) 2012-09-25 2015-12-03 エイ10 ネットワークス インコーポレイテッドA10 Networks, Inc. Load balancing in a data network
US9106561B2 (en) 2012-12-06 2015-08-11 A10 Networks, Inc. Configuration of a virtual service network
US9338225B2 (en) 2012-12-06 2016-05-10 A10 Networks, Inc. Forwarding policies on a virtual service network
US9531846B2 (en) 2013-01-23 2016-12-27 A10 Networks, Inc. Reducing buffer usage for TCP proxy session based on delayed acknowledgement
US9900252B2 (en) 2013-03-08 2018-02-20 A10 Networks, Inc. Application delivery controller and global server load balancer
US9654408B2 (en) * 2013-11-06 2017-05-16 Amazon Technologies, Inc. Strict queue ordering in a distributed system
US9906422B2 (en) 2014-05-16 2018-02-27 A10 Networks, Inc. Distributed system to determine a server's health
WO2017070368A1 (en) * 2015-10-22 2017-04-27 Oracle International Corporation System and method for providing mssq notifications in a transactional processing environment
WO2017066966A1 (en) * 2015-10-22 2017-04-27 Oracle International Corporation System and method for providing mssq notifications in transactional processing environment

Citations (25)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5341477A (en) * 1989-02-24 1994-08-23 Digital Equipment Corporation Broker for computer network server selection
US5553289A (en) * 1991-12-26 1996-09-03 International Business Machines Corporation System for automatically assigning attributes to objects of multimedia distribution when the objects being within a predetermined relationship
US5675797A (en) * 1994-05-24 1997-10-07 International Business Machines Corporation Goal-oriented resource allocation manager and performance index technique for servers
US5696969A (en) * 1996-03-19 1997-12-09 Bull Hn Information Systems Inc. Procedure to detect and disperse convoys for queued gate servers
US5742806A (en) * 1994-01-31 1998-04-21 Sun Microsystems, Inc. Apparatus and method for decomposing database queries for database management system including multiprocessor digital data processing system
US5761307A (en) * 1994-10-07 1998-06-02 Siemens Aktiengesellschaft Method for securing data in a telecommunications system
US5761507A (en) * 1996-03-05 1998-06-02 International Business Machines Corporation Client/server architecture supporting concurrent servers within a server with a transaction manager providing server/connection decoupling
US5774660A (en) * 1996-08-05 1998-06-30 Resonate, Inc. World-wide-web server with delayed resource-binding for resource-based load balancing on a distributed resource multi-node network
US5799173A (en) * 1994-07-25 1998-08-25 International Business Machines Corporation Dynamic workload balancing
US5844980A (en) * 1993-03-03 1998-12-01 Siemens Business Communication Systems, Inc. Queue managing system and method
US5857180A (en) * 1993-09-27 1999-01-05 Oracle Corporation Method and apparatus for implementing parallel operations in a database management system
US5881269A (en) * 1996-09-30 1999-03-09 International Business Machines Corporation Simulation of multiple local area network clients on a single workstation
US5889944A (en) * 1994-07-25 1999-03-30 British Telecommunications Public Limited Company Computer system having client-server architecture
US5974462A (en) * 1997-03-28 1999-10-26 International Business Machines Corporation Method and apparatus for controlling the number of servers in a client/server system
US6003083A (en) * 1998-02-19 1999-12-14 International Business Machines Corporation Workload management amongst server objects in a client/server network with distributed objects
US6023722A (en) * 1996-12-07 2000-02-08 International Business Machines Corp. High-availability WWW computer server system with pull-based load balancing using a messaging and queuing unit in front of back-end servers
US6058394A (en) * 1997-08-29 2000-05-02 International Business Machines Corporation Manager server selects an agent server to execute query based on availability of the server connections to data source and target
US6178438B1 (en) * 1997-12-18 2001-01-23 Alcatel Usa Sourcing, L.P. Service management system for an advanced intelligent network
US6195682B1 (en) * 1998-10-27 2001-02-27 International Business Machines Corporation Concurrent server and method of operation having client-server affinity using exchanged client and server keys
US6209018B1 (en) * 1997-11-13 2001-03-27 Sun Microsystems, Inc. Service framework for a distributed object network system
US6546403B1 (en) * 2000-01-19 2003-04-08 International Business Machines Corporation Mechanism to resubmit queries in a parallel database system
US6901440B1 (en) * 1999-07-02 2005-05-31 Agilent Technologies, Inc. System and method for universal service activation
US6901582B1 (en) * 1999-11-24 2005-05-31 Quest Software, Inc. Monitoring system for monitoring the performance of an application
US7082458B1 (en) * 2001-08-01 2006-07-25 Luigi Guadagno Dialog facilitation system for generating contextual order-preserving dialog postings and posting summaries from electronic messages
US7111077B1 (en) * 2000-12-22 2006-09-19 Unisys Corporation Method and apparatus for passing service requests and data from web based workstations directly to online transaction processing (OLTP) server systems

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5710918A (en) * 1995-06-07 1998-01-20 International Business Machines Corporation Method for distributed task fulfillment of web browser requests
US5701451A (en) * 1995-06-07 1997-12-23 International Business Machines Corporation Method for fulfilling requests of a web browser
US6616700B1 (en) * 1999-02-13 2003-09-09 Newstakes, Inc. Method and apparatus for converting video to multiple markup-language presentations
US6374300B2 (en) * 1999-07-15 2002-04-16 F5 Networks, Inc. Method and system for storing load balancing information with an HTTP cookie
US7123608B1 (en) * 1999-09-10 2006-10-17 Array Telecom Corporation Method, system, and computer program product for managing database servers and service
US6430602B1 (en) * 2000-08-22 2002-08-06 Active Buddy, Inc. Method and system for interactively responding to instant messaging requests

Patent Citations (25)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5341477A (en) * 1989-02-24 1994-08-23 Digital Equipment Corporation Broker for computer network server selection
US5553289A (en) * 1991-12-26 1996-09-03 International Business Machines Corporation System for automatically assigning attributes to objects of multimedia distribution when the objects being within a predetermined relationship
US5844980A (en) * 1993-03-03 1998-12-01 Siemens Business Communication Systems, Inc. Queue managing system and method
US5857180A (en) * 1993-09-27 1999-01-05 Oracle Corporation Method and apparatus for implementing parallel operations in a database management system
US5742806A (en) * 1994-01-31 1998-04-21 Sun Microsystems, Inc. Apparatus and method for decomposing database queries for database management system including multiprocessor digital data processing system
US5675797A (en) * 1994-05-24 1997-10-07 International Business Machines Corporation Goal-oriented resource allocation manager and performance index technique for servers
US5799173A (en) * 1994-07-25 1998-08-25 International Business Machines Corporation Dynamic workload balancing
US5889944A (en) * 1994-07-25 1999-03-30 British Telecommunications Public Limited Company Computer system having client-server architecture
US5761307A (en) * 1994-10-07 1998-06-02 Siemens Aktiengesellschaft Method for securing data in a telecommunications system
US5761507A (en) * 1996-03-05 1998-06-02 International Business Machines Corporation Client/server architecture supporting concurrent servers within a server with a transaction manager providing server/connection decoupling
US5696969A (en) * 1996-03-19 1997-12-09 Bull Hn Information Systems Inc. Procedure to detect and disperse convoys for queued gate servers
US5774660A (en) * 1996-08-05 1998-06-30 Resonate, Inc. World-wide-web server with delayed resource-binding for resource-based load balancing on a distributed resource multi-node network
US5881269A (en) * 1996-09-30 1999-03-09 International Business Machines Corporation Simulation of multiple local area network clients on a single workstation
US6023722A (en) * 1996-12-07 2000-02-08 International Business Machines Corp. High-availability WWW computer server system with pull-based load balancing using a messaging and queuing unit in front of back-end servers
US5974462A (en) * 1997-03-28 1999-10-26 International Business Machines Corporation Method and apparatus for controlling the number of servers in a client/server system
US6058394A (en) * 1997-08-29 2000-05-02 International Business Machines Corporation Manager server selects an agent server to execute query based on availability of the server connections to data source and target
US6209018B1 (en) * 1997-11-13 2001-03-27 Sun Microsystems, Inc. Service framework for a distributed object network system
US6178438B1 (en) * 1997-12-18 2001-01-23 Alcatel Usa Sourcing, L.P. Service management system for an advanced intelligent network
US6003083A (en) * 1998-02-19 1999-12-14 International Business Machines Corporation Workload management amongst server objects in a client/server network with distributed objects
US6195682B1 (en) * 1998-10-27 2001-02-27 International Business Machines Corporation Concurrent server and method of operation having client-server affinity using exchanged client and server keys
US6901440B1 (en) * 1999-07-02 2005-05-31 Agilent Technologies, Inc. System and method for universal service activation
US6901582B1 (en) * 1999-11-24 2005-05-31 Quest Software, Inc. Monitoring system for monitoring the performance of an application
US6546403B1 (en) * 2000-01-19 2003-04-08 International Business Machines Corporation Mechanism to resubmit queries in a parallel database system
US7111077B1 (en) * 2000-12-22 2006-09-19 Unisys Corporation Method and apparatus for passing service requests and data from web based workstations directly to online transaction processing (OLTP) server systems
US7082458B1 (en) * 2001-08-01 2006-07-25 Luigi Guadagno Dialog facilitation system for generating contextual order-preserving dialog postings and posting summaries from electronic messages

Cited By (46)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8423662B1 (en) * 2003-04-28 2013-04-16 Akamai Technologies, Inc. Forward request queuing in a distributed edge processing environment
US9578355B2 (en) * 2004-06-29 2017-02-21 Time Warner Cable Enterprises Llc Method and apparatus for network bandwidth allocation
US20150046960A1 (en) * 2004-06-29 2015-02-12 Time Warner Cable Enterprises Llc Method and apparatus for network bandwidth allocation
US7571464B2 (en) * 2004-08-27 2009-08-04 International Business Machines Corporation Secure bidirectional cross-system communications framework
US20060048217A1 (en) * 2004-08-27 2006-03-02 International Business Machines Corporation Secure bidirectional cross-system communications framework
US9632723B1 (en) * 2004-10-15 2017-04-25 Amazon Technologies, Inc. Providing a reliable distributed queuing service
US20060143328A1 (en) * 2004-12-28 2006-06-29 Christian Fleischer Failover protection from a failed worker node in a shared memory system
US7933947B2 (en) 2004-12-28 2011-04-26 Sap Ag Connection manager that supports failover protection
US8140678B2 (en) * 2004-12-28 2012-03-20 Sap Ag Failover protection from a failed worker node in a shared memory system
US20060143618A1 (en) * 2004-12-28 2006-06-29 Christian Fleischer Connection manager that supports failover protection
US20060174011A1 (en) * 2005-02-01 2006-08-03 Microsoft Corporation Mechanism for preserving session state when using an access-limited buffer
US9930387B2 (en) 2005-02-01 2018-03-27 Time Warner Cable Enterprises Llc Method and apparatus for network bandwidth conservation
US7565395B2 (en) * 2005-02-01 2009-07-21 Microsoft Corporation Mechanism for preserving session state when using an access-limited buffer
US8707323B2 (en) 2005-12-30 2014-04-22 Sap Ag Load balancing algorithm for servicing client requests
US9584839B2 (en) 2007-10-15 2017-02-28 Time Warner Cable Enterprises Llc Methods and apparatus for revenue-optimized delivery of content in a network
US20100185847A1 (en) * 2009-01-20 2010-07-22 New York University Database outsourcing with access privacy
US20170220574A1 (en) * 2012-05-15 2017-08-03 Microsoft Technology Licensing, Llc Scenario based insights into structure data
US9524313B2 (en) 2012-10-30 2016-12-20 International Business Machines Corporation Reducing lock occurrences in server/database systems
US9524314B2 (en) 2012-10-30 2016-12-20 International Business Machines Corporation Reducing lock occurrences in server/database systems
US9552386B2 (en) 2012-10-30 2017-01-24 International Business Machines Corporation Reducing lock occurrences in server/database systems
US9558227B2 (en) 2012-10-30 2017-01-31 International Business Machines Corporation Reducing lock occurrences in server/database systems
US9244966B2 (en) 2012-10-30 2016-01-26 International Business Machines Corporation Method and system for reducing lock occurrences in server/database systems
US9361333B2 (en) 2012-10-30 2016-06-07 International Business Machines Corporation Reducing lock occurrences in server/database systems
US9883223B2 (en) 2012-12-14 2018-01-30 Time Warner Cable Enterprises Llc Apparatus and methods for multimedia coordination
US9696903B2 (en) 2013-08-09 2017-07-04 Zoomdata, Inc. Real-time data visualization of streaming data
US9582331B2 (en) * 2014-05-09 2017-02-28 Wipro Limited System and method for a smart operating system for integrating dynamic case management into a process management platform
US20150324244A1 (en) * 2014-05-09 2015-11-12 Wipro Limited System and method for a smart operating system for integrating dynamic case management into a process management platform
US9817871B2 (en) 2015-02-27 2017-11-14 Zoomdata, Inc. Prioritized retrieval and/or processing of data via query selection
US9811567B2 (en) 2015-02-27 2017-11-07 Zoomdata, Inc. Prioritization of retrieval and/or processing of data
US9612959B2 (en) 2015-05-14 2017-04-04 Walleye Software, LLC Distributed and optimized garbage collection of remote and exported table handle links to update propagation graph nodes
US9690821B2 (en) 2015-05-14 2017-06-27 Walleye Software, LLC Computer data system position-index mapping
US9679006B2 (en) 2015-05-14 2017-06-13 Walleye Software, LLC Dynamic join processing using real time merged notification listener
US9710511B2 (en) 2015-05-14 2017-07-18 Walleye Software, LLC Dynamic table index mapping
US9672238B2 (en) 2015-05-14 2017-06-06 Walleye Software, LLC Dynamic filter processing
US9760591B2 (en) 2015-05-14 2017-09-12 Walleye Software, LLC Dynamic code loading
US9639570B2 (en) 2015-05-14 2017-05-02 Walleye Software, LLC Data store access permission system with interleaved application of deferred access control filters
US9619210B2 (en) 2015-05-14 2017-04-11 Walleye Software, LLC Parsing and compiling data system queries
US9613018B2 (en) 2015-05-14 2017-04-04 Walleye Software, LLC Applying a GUI display effect formula in a hidden column to a section of data
US9836495B2 (en) 2015-05-14 2017-12-05 Illumon Llc Computer assisted completion of hyperlink command segments
US9836494B2 (en) 2015-05-14 2017-12-05 Illumon Llc Importation, presentation, and persistent storage of data
US9613109B2 (en) 2015-05-14 2017-04-04 Walleye Software, LLC Query task processing based on memory allocation and performance criteria
US9886469B2 (en) 2015-05-14 2018-02-06 Walleye Software, LLC System performance logging of complex remote query processor query operations
US9898496B2 (en) 2015-05-14 2018-02-20 Illumon Llc Dynamic code loading
US9805084B2 (en) 2015-05-14 2017-10-31 Walleye Software, LLC Computer data system data source refreshing using an update propagation graph
US9934266B2 (en) 2016-05-14 2018-04-03 Walleye Software, LLC Memory-efficient computer system for dynamic updating of join processing
US9942312B1 (en) * 2016-12-16 2018-04-10 Zoomdata, Inc. System and method for facilitating load reduction at a landing zone

Also Published As

Publication number Publication date Type
US7333974B2 (en) 2008-02-19 grant
CA2372092C (en) 2010-04-06 grant
CA2372092A1 (en) 2003-08-15 application
US20080109452A1 (en) 2008-05-08 application
US7895231B2 (en) 2011-02-22 grant

Similar Documents

Publication Publication Date Title
US7543020B2 (en) Distributed client services based on execution of service attributes and data attributes by multiple nodes in resource groups
US6023722A (en) High-availability WWW computer server system with pull-based load balancing using a messaging and queuing unit in front of back-end servers
US5526492A (en) System having arbitrary master computer for selecting server and switching server to another server when selected processor malfunctions based upon priority order in connection request
US7127507B1 (en) Method and apparatus for network-level monitoring of queue-based messaging systems
US7406515B1 (en) System and method for automated and customizable agent availability and task assignment management
US6898633B1 (en) Selecting a server to service client requests
Davies et al. L 2 imbo: a distributed systems platform for mobile computing
US5802306A (en) Supporting multiple client-server sessions from a protocol stack associated with a single physical adapter through use of a plurality of logical adapters
US20030184583A1 (en) Web os and web desktop
US20020129123A1 (en) Systems and methods for intelligent information retrieval and delivery in an information management environment
US20040083479A1 (en) Method for organizing multiple versions of XML for use in a contact center environment
US6393458B1 (en) Method and apparatus for load balancing in a distributed object architecture
US20030088672A1 (en) Apparatus and method for routing a transaction to a server
US6868450B1 (en) System and method for a process attribute based computer network filter
US20030220946A1 (en) Resource list management system
US20020188733A1 (en) Method and apparatus to manage transactions at a network storage device
US8010607B2 (en) Management of queues in contact centres
US6014700A (en) Workload management in a client-server network with distributed objects
US5444848A (en) Distribution of communications connections over multiple service access points by choosing remote and local access points having lowest number of connections
US20070061282A1 (en) Data network information distribution
US20060050294A1 (en) Method and system for managing the distribution of print job files among shared printers on a computer network
US20040221031A1 (en) Method and apparatus using connection pools in communication networks
US6043898A (en) Method and system for concurrently executing multiple spooling systems in a networked computer system
US7096258B2 (en) System and method providing automatic policy enforcement in a multi-computer service application
US7519734B1 (en) System and method for routing service requests

Legal Events

Date Code Title Description
AS Assignment

Owner name: COGNOS INCORPORATED, CANADA

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:PATTERSON, JAMES EDMUND;REEL/FRAME:014509/0597

Effective date: 20020814

AS Assignment

Owner name: COGNOS ULC, CANADA

Free format text: CERTIFICATE OF AMALGAMATION;ASSIGNOR:COGNOS INCORPORATED;REEL/FRAME:021387/0813

Effective date: 20080201

Owner name: IBM INTERNATIONAL GROUP BV, NETHERLANDS

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:COGNOS ULC;REEL/FRAME:021387/0837

Effective date: 20080703

Owner name: INTERNATIONAL BUSINESS MACHINES CORPORATION, NEW Y

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:IBM INTERNATIONAL GROUP BV;REEL/FRAME:021398/0001

Effective date: 20080714

Owner name: COGNOS ULC,CANADA

Free format text: CERTIFICATE OF AMALGAMATION;ASSIGNOR:COGNOS INCORPORATED;REEL/FRAME:021387/0813

Effective date: 20080201

Owner name: IBM INTERNATIONAL GROUP BV,NETHERLANDS

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:COGNOS ULC;REEL/FRAME:021387/0837

Effective date: 20080703

Owner name: INTERNATIONAL BUSINESS MACHINES CORPORATION,NEW YO

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:IBM INTERNATIONAL GROUP BV;REEL/FRAME:021398/0001

Effective date: 20080714

REMI Maintenance fee reminder mailed
SULP Surcharge for late payment
FPAY Fee payment

Year of fee payment: 4

REMI Maintenance fee reminder mailed
LAPS Lapse for failure to pay maintenance fees
FP Expired due to failure to pay maintenance fee

Effective date: 20160219