Part of content :
Database performance is typically evaluated by executing a standard or de-facto standard benchmark directly on an isolated database system. Examples for this kind of methodology are the results obtained by the Wisconsin Benchmark [BDT83], the TPC benchmark results reported by various database (and hardware) vendors, and the results compiled in the benchmark handbook [Gra93]. SAP R/3 uses a conventional relational database system as backend, and it is possible to choose among several commercial systems when installing SAP R/3 (e.g., ADABAS, DB2,Informix, Oracle, SQL Server). Give performance results that indicate the potential benefits and costs of a data warehouse for SAP R/3. This will again be interesting for end users and companies that use SAP R/3. In addition to the database, Overview of the TPC-D Benchmark : the TPC-D benchmark defines 17 queries and 2 update functions. In this study, we chose to carry out the TPC-D power test which specifies to execute all queries and update functions one at a time and measure their running time individually. Results. Size of the Database: Table 2 shows the size of the resulting SAP and original TPC-D databases.The SAP database has about 10 times the size of the original TPC-D database for the following three reasons: (1) As mentioned earlier, the SAP database is strongly partitioned in order to support specific requirements of business applications.
Tags : relational database system, oracle sql server, informix oracle, benchmark results, database overview, content database, database performance, power test, sap r 3, database table, hardware vendors, performance results, data warehouse, tpc, business applications
If you see unrelated pdf files with the description or copyrighted material published, please report to us, we'll correct/delete it it as soon as possible.NONE OF THOSE MATERIALS ARE HOSTED IN THIS SERVER NOR UPLOADED BY ME IN SOMEONE'S SERVERS. Read our DISCLAIMER for more detail.
We are neither affiliated with authors and brands nor responsible for its content and change of content.
Information contained herein is provided "as is" without warranty of any kind, either expressed or implied, including any warranty of merchantability or fitness for a particular purpose. In no event shall ANYONE be held liable for any loss of profit, special, incidental, consequential, or other similar claims.