1 / 24

Multiple Components in One Database (MCOD)

Learn about the new feature of Multiple Components in One Database (MCOD) and how it simplifies the installation process of mySAP.com components. Discover the technical realization for Oracle, availability, and outlook.

nancycflores
Download Presentation

Multiple Components in One Database (MCOD)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Multiple Componentsin One Database(MCOD) Dr. Georg Leffers SAP AG

  2. Agenda Introducing Multiple Components in One Database (MCOD) è è Simplifying the mySAP.com System Landscape using MCOD è Technical Realization for Oracle è Availability è Outlook

  3. Agenda Introducing Multiple Components in One Database (MCOD) è è Simplifying the mySAP.com System Landscape using MCOD è Technical Realization for Oracle è Availability è Outlook

  4. Multiple Components in One Database • Multiple Components in One Database (MCOD) is a new feature in the installation process for mySAP.com components • It provides the possibility to install several components independently in one single database SAP CRM SAP Workplace RDBMS SAP R/3 4.6C SAP R/3 4.6C

  5. Technical Realization • Each mySAP.com component connects the database with one single database user. This user is independent of the user logged on to the SAP system itself. The default database user is SAP R/3. • Databases support schema. Tables with the same name can exist independent in different schema with different contents. • Using a one to one relation between the database user and the database schema, each mySAP.com component uses its own schema by accessing the database with a unique dedicated database user. SAP R/3 SAP CRM T100 (SAP R/3) T100 (SAP CRM) DB-User: SAP R/3 DB-User: SAP CRM

  6. Agenda Introducing Multiple Components in One Database (MCOD) è è Simplifying the mySAP.com System Landscape using MCOD è Technical Realization for Oracle è Availability è Outlook

  7. SAP R/3 SAP BW RDBMS RDBMS RDBMS RDBMS RDBMS SAP SEM SAP WP Highly Flexible IT Landscape Today Situation: N Systems, N Databases Benefits • Flexibility through components • Separate upgrades possible • Different operating systems and databases • Highest scalability achievable Administrative challenges • Maintaining different operating systems, databases • Complicated high availability solutions • Synchronized backup & restore SAP CRM

  8. SAP R/3 SAP BW SAP CRM SAP SEM RDBMS SAP WP Installed on one physical server Simplification Of The System Landscape With MCOD Situation: N Systems, 1 Database Administrative opportunity • Multiple independent and different software solutions are located in one database • One logical and physical database instance • Point in time recovery of semantically related systems e.g. SAP R/3 and SAP CRM possible • Migration of existing systems is possible • All systems use the same OS/DB release

  9. business data SAP R/3 SAP CRM RDBMS X business data Independence Of Single Systems • (De)Installation of individual components • Upgrade of individual components • Data exchange on application level • Integrity of business data • No special coding for MCOD installations • No locking conflicts on database tables

  10. Installed on one physical server RDBMS RDBMS Separate OLTP And OLAP Systems Performance considerations • For performance / sizing reasons separate OLTP and OLAP systems Possible deployment option • Maintain a high level of performance and good response times OLTP OLAP SAP R/3 SAP BW SAP CRM SAP SEM SAP WP

  11. multiple servers, one databases multiple servers, multiple databases one server, one database one server, multiple databases Various Deployment Options • Full range of scalability & flexibility • Decide how many different systems will reside in one physical database • Additive sizing approach

  12. Benefits detail: Estimated savings 10% of disk space Disk For example, tapes, tape drives, disk systems 30% of hardware backup costs Backup administration or high-availability concepts 40% of operating costs Reduced Maintenance & Operating Costs Only need to administer one database • Similar effort compared to maintain one component on one database

  13. Sizing & Administration • Sizing & Administration of an MCOD installation • The total sizing of an MCOD installation can be achieved by an additive sizing approach of the appropriate values of the single systemsExample: Combined installation of System1 and System2 using MCOD • Decide which systems to combine to achieve a maximum of savings in administration and system handling while keeping the flexibility of the complete installation

  14. System Recommendations • Combination of systems with semantically related data like SAP R/3 and SAP CRM. • Combination of systems of the same type e.g. combination of development systems or combination of production systems. • The combination of production and non production systems is not supported. Development System 1 ... Devevelopment System N Test System 1... Test System N Production System 1 ... Production System N

  15. Agenda Introducing Multiple Components in One Database (MCOD) è è Simplifying the mySAP.com System Landscape using MCOD è Technical Realization for Oracle è Availability è Outlook

  16. Oracle / SAPSYSTEMNAME 1 : C11 SAPSYSTEMNAME 2 : C12 oracle DB – User: sapc11 DB – User: sapc12 <DB_SID> sapdata1 sapdata2 sapdata3 sapdata4 sapdata5 sapdata<n> PSAPC11 PSAPC1146D PSAPC11USR PSAPC12 PSAPROLL PSAPTEMP PSAPC1246D PSAPSYSTEM PSAPC12USR Oracle - Database <DB_SID>

  17. Implementation on Oracle • Technical Implementation: • One database will contain the data of all systems • Each SAP system will create its own database schema/database user sap<SID> • Each SAP system will create its own set of tablespaces • The new tablespace layout is described in SAP note 490365

  18. Agenda Introducing Multiple Components in One Database (MCOD) è è Simplifying the mySAP.com System Landscape using MCOD è Technical Realization for Oracle è Availability è Outlook

  19. More Information What will be supported • MCOD is available on all OS/DB platforms supported by SAP • General Availability since 1st of July, 2002 • For the future all upcoming mySAP.com components are planned to be enabled for an MCOD installation • Information about the current available components is updated regularly and can be found at the service market place under the quicklink MCOD More information • http://service.sap.com/mcod

  20. Available mySAP.com Components

  21. Agenda Introducing Multiple Components in One Database (MCOD) è è Simplifying the mySAP.com System Landscape using MCOD è Technical Realization for Oracle è Availability è Outlook

  22. Outlook Backup and recovery of single systems within an MCOD installation • Planned for SAP WebAS 6.30 introducing a backup and recovery on tablespace level in SAPDBA Transport of single systems • Implementation projects at customer side on the basis of transportable tablespaces Oracle RAC with MCOD • Improved scaling capabilities by distributing the single database nodes • Breakdown of the OLTP / OLAP division with an individual parameterization for the single database nodes • First tests planned for Q1/2003 in combination with blade servers

  23. Conclusion Main advantages are Full flexibility and independence of the installed components Simplified administration, backup and recovery Additive sizing approach System spanning data consistency Reduced maintenance and operating costs With “Multiple Components in One Database” SAP offers a powerful option to install several mySAP.com components in one physical database

  24. More Information Visit the MCOD homepage:http://service.sap.com/mcod Visit the mySAP Technology homepage:http://service.sap.com/technology

More Related