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

• US 8,261,271 B2
• Filed: 08/13/2007
• Issued: 09/04/2012
• Est. Priority Date: 04/27/2000
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Polizzi, Kathleen Riddell, Godbeer, Gail Helen, Yedwab, Gadi, Murphy, Anthony John, Bick, Robert Mark, Ewry, Jeffrey Alan, Hippenmeyer, William, Burton, Peter Alan, Norris, Jack
• Primary Examiner(s): Tang, Kenneth
• Application Number:
  US11/838,071
• Publication Number:
  US 20080034369A1
• Time in Patent Office: 1,849 Days
• Field of Search: 718/100, 709/202
• US Class Current: 718/100
• CPC Class Codes: G06F 16/954 Navigation, e.g. using categorised browsing
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/959 Network
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

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

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.