IP Library Granted Patent US 8,261,271
Granted Patent B2
US 8,261,271 · App. 11/838,071 · Granted Sep 4, 2012

Method and apparatus for processing jobs on an enterprise-wide computer system

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,261,271
App. No.
11/838,071
Granted
Sep 4, 2012
Kind
B2
Abstract

A method and apparatus for processing jobs on an enterprise-wide computer system. The computer system uses a portal architecture to allow a user to view a wide variety of content retrieved from a variety of different computer systems. The computer system is configured such that a plurality of users can access the system at the same time through a computer network such as the Internet. The computer system may also be connected to one or more back-end databases that correspond to the different computer systems within the enterprise. The computer system is configured to run predefined jobs to process data. These jobs can perform a variety of tasks such as retrieving data from a back-end database, preparing a report based upon retrieved data, processing data already resident within the portal system, or notifying a user when a particular condition occurs within the portal system.

Claims (77)

1. A method of processing a job in an enterprise-wide computer portal system comprised of a job server configured to execute a job and to process a set of input data corresponding to the job, a job repository including computer memory encoded with a plurality of objects including at least one job and at least one set of job properties corresponding to said at least one job, wherein said set of job properties includes a set of input data to be provided to a job server when a corresponding job is executed, and wherein the enterprise-wide computer portal system is electrically connected to a plurality of enterprise computer systems and configured for communication with at least one enterprise user through a network interface, the method comprising:

receiving a request to execute a job from an enterprise user connected to the enterprise-wide computer portal system through a computer network;

retrieving the requested job and a corresponding set of input data from the job repository;

dispatching the requested job and the corresponding set of input data for processing on a corresponding job server;

processing the requested job with the corresponding set of input data in the job server to produce an output report,

receiving a set of user identification data from the enterprise user;

generating a secure output report comprised of a master file and a plurality of markup pages, wherein the master file includes a plurality of containers, each of which corresponds to one of said plurality of markup pages, wherein each of said plurality of markup pages includes a set of permissions defining the ability of said at least one enterprise user to view that page;

comparing the set of user identification data to the set of permissions for a corresponding markup page to determine the ability of the enterprise user to view that page; and

placing a view flag in the container if the enterprise user has permission to view the corresponding markup page;

for each container in the secure output report that contains a view flag, retrieving one or more corresponding markup pages;

assembling the one or more corresponding markup pages into a user-specific output report; and

transmitting the user-specific output report to the corresponding enterprise user through the network interface.

2. A method according to claim 1 , wherein said at least one set of job properties further includes a list of enterprise users to be notified when a corresponding job has been executed, the method further comprising:

processing said at least one set of job properties and providing a notification to each user in the list of enterprise users when a corresponding job is executed.

3. A method according to claim 1 , wherein said at least one set of job properties further includes one or more exception conditions and a corresponding list of enterprise users subscribing to the exception conditions, the method further comprising:

comparing the output report to the exception conditions to determine the existence of an exception event;

providing a notification to each user in the corresponding list of enterprise users when the exception event exists.

4. A method according to claim 1 , wherein said at least one job is a secure Structured Query Report (SQR job), the method further comprising:

receiving a set of user identification data from the enterprise user;

generating a secure bursted output report comprised of a master file and a plurality of HTML pages, wherein the master file includes a plurality of containers, each of which corresponds to one of said plurality of HTML pages, wherein each of said plurality of HTML pages includes a set of permissions defining the ability of said at least one enterprise user to view that page;

for each of said plurality of containers in the secure bursted output report, performing the following steps i) and ii):

i) comparing the set of user identification data to the set of permissions for a corresponding HTML page to determine the ability of the enterprise user to view that page; and

ii) placing a view flag in the container if the enterprise user has permission to view the corresponding HTML page;

for each container in the secure bursted output report that contains a view flag, retrieving a corresponding HTML page;

assembling the retrieved HTML page(s) into an user-specific output report; and

transmitting the user-specific output report to the corresponding enterprise user.

5. A method according to claim 1 , wherein the job server is connected to at least one enterprise back-end database, the method further comprising:

retrieving a set of data corresponding to the requested job from an enterprise back-end database; and

processing the requested job in the job server with the set of data retrieved from the enterprise back-end database and the corresponding set of input data so as to produce an output report.

6. A method according to claim 5 , wherein said at least one set of job properties further includes a list of enterprise users to be notified when a corresponding job has been executed, the method further comprising:

processing said at least one set of job properties and providing a notification to each user in the list of enterprise users when a corresponding job is executed.

7. A method according to claim 5 , wherein said at least one set of job properties further includes one or more exception conditions and a corresponding list of enterprise users subscribing to the exception conditions, the method further comprising:

comparing the output report to the exception conditions to determine the existence of an exception event;

providing a notification to each user in the corresponding list of enterprise users when the exception event exists.

8. A method according to claim 5 , wherein said at least one job is a secure Structured Query Report (SQR) job, the method further comprising:

receiving a set of user identification data from the enterprise user;

generating a secure bursted output report comprised of a master file and a plurality of HTML pages, wherein the master file includes a plurality of containers, each of which corresponds to one of said plurality of HTML pages, wherein each of said plurality of HTML pages includes a set of permissions defining the ability of said at least one enterprise user to view that page;

for each of said plurality of containers in the secure bursted output report, performing the following steps i) and ii):

i) comparing the set of user identification data to the set of permissions for a corresponding HTML page to determine the ability of the enterprise user to view that page; and

ii) placing a view flag in the container if the enterprise user has permission to view the corresponding HTML page;

for each container in the secure bursted output report that contains a view flag, retrieving a corresponding HTML page;

assembling the retrieved HTML page(s) into an user-specific output report; and

transmitting the user-specific output report to the corresponding enterprise user.

9. A system for processing a job in an enterprise-wide computer portal system comprised of a job server configured to execute a job and to process a set of input data corresponding to the job, a job repository including computer memory encoded with a plurality of objects including at least one job and at least one set of job properties corresponding to said at least one job, wherein said set of job properties includes a set of input data to be provided to a job server when a corresponding job is executed, and wherein the enterprise-wide computer portal system is electrically connected to a plurality of enterprise computer systems and configured for communication with at least one enterprise user through a network interface, the job server comprising a processor configured to:

receive a request to execute a job from an enterprise user connected to the enterprise-wide computer portal system through a computer network;

retrieve the requested job and a corresponding set of input data from the job repository;

dispatch the requested job and the corresponding set of input data for processing on a corresponding job server;

process the requested job with the corresponding set of input data in the job server to produce an output report,

receive a set of user identification data from the enterprise user;

generate a secure output report comprised of a master file and a plurality of markup pages, wherein the master file includes a plurality of containers, each of which corresponds to one of said plurality of markup pages, wherein each of said plurality of markup pages includes a set of permissions defining the ability of said at least one enterprise user to view that page;

compare the set of user identification data to the set of permissions for a corresponding markup page to determine the ability of the enterprise user to view that page; and

place a view flag in the container if the enterprise user has permission to view the corresponding markup page;

for each container in the secure output report that contains a view flag, retrieve one or more corresponding markup pages;

assemble the one or more corresponding markup pages into a user-specific output report; and

transmit the user-specific output report to the corresponding enterprise user through the network interface.

10. A system according to claim 9 , wherein said at least one set of job properties further includes a list of enterprise users to be notified when a corresponding job has been executed, the system further comprising:

the job server further configured to process said at least one set of job properties and providing a notification to each user in the list of enterprise users when a corresponding job is executed.

11. A system according to claim 9 , wherein said at least one set of job properties further includes one or more exception conditions and a corresponding list of enterprise users subscribing to the exception conditions, the processor further configured to:

compare the output report to the exception conditions to determine the existence of an exception event; and

provide a notification to each user in the corresponding list of enterprise users when the exception event exists.

12. A non-transitory computer readable medium containing thereon a set of computer instructions, which when executed by a job server computer cause the job server computer to:

receive a request to execute a job from an enterprise user connected to the enterprise-wide computer portal system through a computer network;

retrieve the requested job and a corresponding set of input data from the job repository;

dispatch the requested job and the corresponding set of input data for processing on a corresponding job server;

process the requested job with the corresponding set of input data to produce an output report,

receive a set of user identification data from the enterprise user;

generate a secure output report comprised of a master file and a plurality of markup pages, wherein the master file includes a plurality of containers, each of which corresponds to one of said plurality of markup pages, wherein each of said plurality of markup pages includes a set of permissions defining the ability of said at least one enterprise user to view that page;

compare the set of user identification data to the set of permissions for a corresponding markup page to determine the ability of the enterprise user to view that page; and

place a view flag in the container if the enterprise user has permission to view the corresponding markup page;

for each container in the secure output report that contains a view flag, retrieve one or more corresponding markup pages;

assemble the one or more corresponding markup pages into a user-specific output report; and

transmit the user-specific output report to the corresponding enterprise user through the network interface.

13. The non-transitory computer readable medium of claim 12 further comprising computer instructions that cause the job server computer to:

provide a notification to each user in a list of enterprise users when a job is executed.

14. The non-transitory computer readable medium of claim 13 , wherein said at least one set of job properties further includes one or more exception conditions and a list of enterprise users to be notified when a corresponding job has been executed, the medium further comprising computer instructions that cause the job server computer to:

compare the output report to the exception conditions to determine the existence of an exception event;

provide a notification to each user in the list of enterprise users when the exception event occurs.

Assignments (5)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 21, 2011
From: HYPERION SOLUTIONS CORPORATION
To: ORACLE INTERNATIONAL CORPORATION
Reel/Frame 025986/0490 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 4, 2011
From: BEA SYSTEMS, INC.
To: ORACLE INTERNATIONAL CORPORATION
Reel/Frame 025747/0775 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 14, 2007
From: POLIZZI, KATHLEEN RIDDELL; GODBEER, GAIL HELEN; YEDWAB, GADI; MURPHY, ANTHONY JOHN; BICK, ROBERT MARK; EWRY, JEFFREY ALAN; HIPPENMEYER, WILLIAM; BURTON, PETER ALAN; NORRIS, JACK
To: BRIO TECHNOLOGY, INC.
Reel/Frame 019693/0602 →
MERGER Recorded Aug 14, 2007
From: BRIO SOFTWARE, INC.
To: HYPERION SOLUTIONS CORPORATION
Reel/Frame 019693/0662 →
CHANGE OF NAME Recorded Aug 14, 2007
From: BRIO TECHNOLOGY, INC.
To: BRIO TECHNOLOGY SOFTWARE, INC.
Reel/Frame 019695/0250 →