Method, computer program product and computer system for a single database system to support multiple application systems

• US 7,392,236 B2
• Filed: 11/21/2001
• Issued: 06/24/2008
• Est. Priority Date: 03/20/2001
• Status: Expired due to Term

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Inhoff, Uwe, Raupp, Thomas, Rusch, Gert, Marquard, Ulrich
• Primary Examiner(s): LE, UYEN T
• Application Number:
  US09/989,070
• Publication Number:
  US 20020174097A1
• Time in Patent Office: 2,407 Days
• Field of Search: 707 1- 3, 707/10, 707/100, 707/200, 711/100, 711/147, 711/148, 711/153, 711/170, 711/173, 709/212, 709/213, 709/214, 709/215, 709/216
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing

Abstract

The invention allows multiple application systems to use a single database system. The database system is divided into at least a first memory portion and a second memory portion. The memory portions are disjunctive. The database system stores a first assignment of a first profile to the first memory portion and a second assignment of a second profile to the second memory portion . The first and second profiles are unique and refer to the first and second application systems, respectively. The first application system and the second application system access the first memory portion and the second memory portion, through the respective profiles.

Claims

1. A computer system comprising at least a first application system and a second application system and a database system, each application system running at least one application service for at least one application system user;

said computer system characterized in that;

the database system has at least a first memory portion and a second memory portion, wherein the memory portions are disjunctive;

the database system stores a first assignment of a first profile to the first memory portion and a second assignment of a second profile to the second memory portion, wherein the first profile is uniquely associated with only the first memory portion and the first application system and the second profile is uniquely associated with only the second memory portion and the second application system;

each of the first and second application systems accessing the first memory portion and the second memory portion, respectively, through the corresponding profiles.

2. The computer system of claim 1, wherein the memory portions store tables of the database system.

3. The computer system of claim 1, wherein the database system is a parallel server system.

4. The computer system of claim 1, wherein the database system is a relational database system.

5. The computer system of claim 1, wherein the database system uses shared memory processors.

6. The computer system of claim 5, wherein the database system uses an operating system that creates multiple logical groups of processors.

7. The computer system of claim 6, wherein each group of processors is assigned to one application system.

8. A computer-implemented method for accessing a database system, the method comprising the steps:

providing at least a first application system and a second application system, wherein each application system runs at least one application service for a plurality of users of the application system;

connecting the database system with at least the first application system and the second application system;

dividing a memory of the database system into at least a first memory portion and a second memory portion, both portions being disjunctive;

assigning first and second memory portions to first and second application systems, respectively, using at least two predefined, unique profiles, a first profile uniquely associated with only the first memory portion and the first application system and a second profile uniquely associated with only the second memory portion and the second application system; and

accessing first and second memory portions by the first and second application systems based on the first and second profiles, respectively.

9. The computer-implemented method of claim 8, wherein in the dividing step, the memory portions store tables of the database system.

10. The computer-implemented method of claim 8, wherein in the assigning step, one of the at least two predefined, unique profiles is assigned to each memory portion.

11. The computer-implemented method of claim 10, wherein in the assigning step, each predefined unique profile is assigned to one of the application systems.

12. The computer-implemented method of claim 11, wherein in the accessing step, each application system accesses the database system through at least one of the predefined profiles that are assigned to the application system.

13. The computer-implemented method of claim 8, wherein in the accessing step, accessing is selected from the group of read, write, copy, modify, insert, append and delete.

14. A computer-readable medium storing a computer program product thereon, the computer program product characterized in that:

a first program portion causes a processor of a database system to disjunctively partition a memory of the database system into a first memory portion and a second memory portion and to provide a first database profile and a second database profile, wherein the first profile is uniquely associated with only the first memory portion and a first application system and the second profile is uniquely associated with only the second memory portion and a second application system;

a second program portion causes a processor of the first application system to provide a first business application service to a first plurality of application users and to use at least the first database profile to communicate data from the first application system to the database system; and

a third program portion causes a processor of the second application system to provide a second business application service to a second plurality of application users and to use at least the second database profile to communicate data from the second application system to the database system.

15. A computer-readable medium having a plurality of sequences of instructions stored thereon which when executed by one or more processors, perform the steps of:

causing a processor of a database system to disjunctively partition a memory of the database system into a first memory portion and a second memory portion and to provide a first database profile and a second database profile, where the first and second database profiles are unique and are each uniquely assigned to one of the first and second memory portions, respectively;

causing a processor of a first application system to provide at least a first business application service to a first plurality of application users and to use at least the first database profile to communicate data from the first application system to the database system through the first memory portion; and

causing a processor of at least a second application system to provide at least a second business application service to a second plurality of application users and to use at least the second database profile to communicate data from the second application system to the database system through the second memory portion.