Free Essay

Dell Sun

In: Computers and Technology

Submitted By maun
Words 4937
Pages 20
Migrating Sun-based Oracle® Databases to Dell™ PowerEdge™ Servers

Dell PowerEdge 6450 and 8450 with Microsoft® Windows® 2000 Advanced Server

1 Enterprise Systems Group (ESG)

Dell White Paper

2 By Dave Jaffe and Todd Muirhead



5 [pic]


Executive Summary 3
Introduction 4
Solution Overview 6
The Database Servers 8 The Hardware 8 The Software 9
The Application Servers 11 The Hardware 11 The Software 11
Migrating the Application 13
The Tests 15
Conclusions 17
Acknowledgements 18
Bibliography 19 Appendix A : Baseball Database Organization 20 Database Tables 20 Master 20 Teammaster 20 Batting 21 Pitching 21 Fielding 22 Sample Query 22

Figure 1: The Dell and Sun Solution Implementations 6

Table 1: Database Server Comparison: PowerEdge 6450 and 8450 vs. Sun Enterprise 4500 8
Table 2: RAID Organization for Three Configurations 9
Table 3: Oracle Database Layout 9
Table 4: Oracle9i Tuning Parameters 10
Table 5: Application Servers: Dell PowerEdge 1550 vs. Sun Enterprise 220R 11
Table 6: Oracle Pricing 12
Table 7: 4-CPU Test Results: PowerEdge 6450 vs. Sun E4500 w/ 4 CPUs 15
Table 8: 8-CPU Test Results: PowerEdge 8450 vs. Sun E4500 w/ 8 CPUs 16 Section 1

Executive Summary

Following studies showing the advantages of migrating Tier 1 web servers and Tier 2 application servers from Sun Microsystems, Inc. servers to Dell PowerEdge servers, this study examined the issues involved in migrating Oracle databases from the Sun/Solaris platform to the Dell/Windows platform. The study showed that Oracle database and application migration is very easily accomplished. Furthermore, Dell PowerEdge servers run Oracle9i database applications faster than the equivalent Sun server at roughly one-fourth the price.

A multi-tiered database application was built with Oracle9i Application Server (Oracle9iAS) on a Sun Enterprise 220R rack-mounted server driving Oracle9i Database Server on a Sun Enterprise 4500 midrange server. The E4500 was configured with either four or eight processors. A moderately sized database of baseball statistics was built on the database server. Using the portal component within Oracle9iAS, a web portal was created that allows on-line users to submit queries to the database that list the top 10 players in any of 20 statistical categories (home runs, earned run average, etc.) for the years 1901 – 2000.

The baseball database and portal application (which are both stored in the back-end database) were then migrated to a Dell configuration using the Dell PowerEdge 1550 as the application server running Oracle9iAS and either the PowerEdge 6450 (4 CPUs) or the PowerEdge 8450 (8 CPUs) for the Oracle9i Database server. Migration was simply a matter of using the Oracle export/import commands plus a script generated by the Oracle9iAS Portal manager. The entire migration process took about 20 minutes for our midsize database.

Testing with an internal web stress tool showed that the PowerEdge servers are faster than the corresponding Sun servers, at about one fourth the price (see Table 1). With a reasonable “think time” of 10 seconds between requests, the 4-CPU PowerEdge 6450 can easily handle 450 simultaneous users while the 8-CPU PowerEdge 8450 can handle 700 users; in comparison, the Sun systems handled the same number of users with higher response times and greater CPU use.

Section 2


Sun to Dell migration issues have been studied in a series of papers from Dell Enterprise System Group’s Solution Enablement Lab and Showcase (see complete list in Section10, Bibliography). With a target audience of customers currently running servers from Sun Microsystems, Inc. but interested in migrating to Dell PowerEdge servers, the papers showed the ease and benefits of migrating low-end web servers and mid-tier application servers from the Sun platform to the Dell PowerEdge platform. In those tests, however, the Oracle database remained on a Sun server.

The current study targets a customer who is now ready to migrate their entire Oracle application server and database stack to Dell PowerEdge servers. To demonstrate the migration we have selected a multitiered web application using Oracle9i Application Server (including the Apache web server) on one machine driving Oracle9i Database Server running on a second machine. The back-end database consists of a moderately sized database of baseball statistics. A web application was written using Oracle9iAS Portal, a component of Oracle9i Application Server, to enable users to generate Top 10 lists for any of 20 different statistics over 100 years.

The web application was first implemented on a Sun Enterprise 220R 2-CPU application server driving a Sun Enterprise E4500 database server, both running Solaris 8.0. The E4500 was configured with either four 450 MHz UltraSPARC II processors and 4 GB of memory or eight such CPUs and 8 GB of memory. On the Dell side, the PowerEdge 1550 2-CPU application server with Microsoft Windows 2000 Server was used to drive either the 4-CPU PowerEdge 6450 or the 8-CPU PowerEdge 8450, each running Microsoft Windows 2000 Advanced Server.

The Oracle9i baseball database was easily migrated from the Sun E4500 to both PowerEdge servers with the Oracle export and import feature. Since Oracle9i Application Server stores its application data in the backend Oracle database it was a simple matter to migrate the portal web application from the Sun application server to the Dell application server.

Once ported, the application ran better on the Dell servers with their multi-threaded Windows 2000 implementation of Oracle9i Database than on the Sun E4500 server with its Solaris single-threaded process model, and was much easier to tune. This in spite of the fact that the Dell servers, both the 4-CPU PowerEdge 6450 and the 8-CPU PowerEdge 8450, are about one fourth the cost of the comparatively configured Sun E4500. (See Table 1.) An internal stress tool used in earlier tests was utilized in this test to generate queries against the database and record response times.

A full description of the application is given in Section 3, Solution Overview, followed by details of The Database Servers and The Application Servers in Section 4 and Section 5. Migration details are in Section 6, Migrating the Application, followed by test details in Section 7, The Tests.

Section 3

Solution Overview

To demonstrate Oracle database migration and measure relative performance, a multi-tiered database application was built on a Sun server stack and then migrated to two different Dell stacks (see Figure 1: The Dell and Sun Solution Implementations). The Sun Enterprise E4500 was run with either 4 or 8 processors to compare to the Dell PowerEdge 6450 or Dell PowerEdge 8450, respectively.

Figure 1: The Dell and Sun Solution Implementations

The application architecture is the same in all three cases. Oracle9i Application Server, including the Apache web server and Oracle9iAS Portal, runs on the Application Server layer. (In this study a single server was employed in this layer. In a future study multiple Oracle9iAS servers will be used to provide redundancy and performance scaling). An Oracle Procedural Language/Structured Query Language (PL/SQL) application runs under the mod_plsql module of Apache, calling a stored procedure on the backend Oracle database. Oracle9iAS Portal provides a web-based platform for creating these web applications with appropriate security, authentication and caching.

A database of baseball statistics, Baseball Archive Database 4.0, was obtained from Sean Lahman at in Microsoft Access form, exported as comma-separated values, and then loaded into Oracle tables with the sqlldr command. The database contains batting, pitching and fielding data for 15,558 players going back to 1886 (See Database Tables in Appendix A). Using Oracle9iAS Portal, dynamic PL/SQL pages were created that enable a web user to display the Top 10 leaders in any of 20 statistical categories for any year between 1901 and 2000, and for either the American or National Leagues, or both, a total of 6,000 unique queries.

The input required by Oracle9iAS Portal for each dynamic web page is the Oracle SELECT statement to generate the corresponding Top 10 table (see Sample Query in Appendix A). Oracle9iAS Portal generates the PL/SQL wrapper code that creates the connection to the backend database, calls the query and caches the resulting page. Oracle9iAS stores all of these components in the backend database, facilitating application backup and migration. Oracle9iAS Portal provides a web-based GUI to manage the dynamic pages and other components.

Section 4

The Database Servers

The Hardware

The Sun server for both the 4-CPU and 8-CPU configurations was an Enterprise 4500 midrange server running the July 2001 version of Solaris 8.0. In both configurations the E4500 used 64-bit UltraSPARC-II 450 MHz CPUs. Both the Dell 4-CPU PowerEdge 6450 and the Dell 8-CPU PowerEdge 8450 ran Windows 2000 Advanced Server on 700 MHz Intel® Xeon™ processors based on the Intel 32 bit architecture. See Table 1: Database Server Comparison: PowerEdge 6450 and 8450 vs. Sun Enterprise 4500 for details.

| |Dell PowerEdge 6450 |Dell PowerEdge 8450 |Sun Enterprise 4500 |
|Operating System |Windows 2000 Advanced Server |Windows 2000 Advanced Server |Solaris 8.0 7/01 |
|CPU |4x 700 MHz Pentium III Xeon |8x 700 MHz Pentium III Xeon |4-CPU: 4 x 450 MHz |
| | | |8-CPU: 8 x 450 MHz UltraSPARC-II|
|CPU L2 Cache |2 MB |2 MB |8MB |
|Memory |4 GB |8 GB |4-CPU: 4 GB |
| | | |8-CPU: 8 GB |
|Internal Disk |4x 18 GB* |2x 36 GB* |2x 36 GB* |
|External Disk |PowerVault 210S - 10x 18 GB |PowerVault 210S – 10x 18 GB |StorEdge D1000 – 8 x 36 GB |
|NICs |2x 100 Mb/s (1 internal, 1 PCI |2x 100 Mb/s (1 PCI card) |1x 100 Mb/s (I/O card) |
| |card) | | |
|RAID Controller |2x PERC/2 Dual Channel |2x PERC/2 Dual Channel |A3500FC RAID Controller |
|Video |On-board |On-board |Remote console |
|Height |4 Rack Unit (4U) or 7” |7 Rack Unit (7U) or 12.25” |8 Rack Units (8U) or 14” |
|Price as configured |$32,683 |$62,437 |4-CPU: $147,085 |
| | | |8-CPU: $228,885 |
|Source | 2/15/02 | 2/15/02 | 2/15/02 |

*For hard drives, GB means 1 billion bytes; total accessible capacity varies depending on operating environment.

Table 1: Database Server Comparison: PowerEdge 6450 and 8450 vs. Sun Enterprise 4500

The Sun and the Dell database servers were configured with similar external SCSI storage. The Sun server was attached via fibre channel to a Sun StorEdge A3500FC controller that drove a single StorEdge D1000 disk pod containing 8 36GB SCSI disks. The Dell PowerEdge 6450 and 8450 were attached to Dell PowerVault 210S SCSI disk pod through Dell PowerEdge RAID Controller/2 (PERC/2) PCI cards. Each PV210S was configured with 10 18GB disks. The RAID configuration on the disks, shown in Table 2: RAID Organization for Three Configurations, was created to be as similar to each other as possible, but due to differing numbers of internal disks on each server there were slight differences in the RAID configurations.

|Logical Disk |Dell PowerEdge 6450 |Dell PowerEdge 8450 |Sun Enterprise 4500 |
| 0 | RAID 1 – Internal Disks 0,1 | RAID 1 – Internal Disks 0,1 |Internal Disk 0 |
| 1 |RAID 1 – Internal Disks 2,3 |RAID 1 – 210S Disks 0,1 |RAID 1 – D1000 Disks 0,1 |
| 2 |RAID 1 – 210S Disks 0,1 |RAID 1 – 210S Disks 2,3 |RAID 1 – D1000 Disks 2,3 |
| 3 |RAID 1/0 – 210S Disks 2,3,4,5,6,7,8,9 |RAID 1/0 – 210S Disks 4,5,6,7,8,9 |RAID 1/0 – D1000 Disks 4,5,6,7 |

Table 2: RAID Organization for Three Configurations

The Software

Oracle9i Database was installed using the Oracle Universal Installer on both Windows 2000 and Solaris 8. The same options were selected on both. Oracle9i installation was completed without creating an initial database. The Oracle Database Creation Assistant (DBCA) was then used to create a new database instance using similar settings on the two platforms. The control files, log files, and data files were placed on different partitions of the external storage and the shared server option was used (see Table 3: Oracle Database Layout). We also applied the appropriate patch set on each platform to take 9i to the level.

|Logical |Oracle |Windows |Solaris |
|Disk |Use | | |
| | |Partition |Size (GB) |Partition |Size (GB) |
|0 |Oracle Binaries |C: |16.83 |/u01 |6.33 |
|1 |Control files, |D: |16.87 |/u02 |33.36 |
| |Logs, Misc. | | | | |
|2 |Undo tablespace |E: |16.87 |/u03 |33.36 |
|3 |Users tablespace, |F: |67.49 (6450) |/u04 |66.71 |
| |Indexes | |50.60 (8450) | | |

Table 3: Oracle Database Layout

The database initialization parameters are listed in Table 4: Oracle9i Tuning Parameters. For the most part the Sun E4500 and the PowerEdge 8450 were set up the same way to facilitate 8-CPU comparison. The large pool and shared pool were set at 400MB to provide sufficient space for the largest number of simultaneous users. Processes were limited to 200 and sessions to 300 to optimize performance for the web application on both platforms. On the Dell 8-CPU system the minimum number of shared servers was set to 40 (with more created by Oracle dynamically up to a maximum of 160) but on the Sun it was found that 80 shared servers were needed to be on hand at all times, perhaps due to the larger CPU requirement to create and destroy new shared server processes under Solaris vs. new shared server threads under Windows. The number of DB writer processes was set equal to the number of processors. The parameters on the PowerEdge 6450 are scaled down to reflect the lower concurrent usage.

|Parameter |Dell PowerEdge |Dell PowerEdge |Sun Enterprise 4500|
| |6450 |8450 | |
|DB_BLOCK_SIZE |8192 |8192 |8192 |
|DB_CACHE_SIZE |117440512 |117440512 |117440512 |
|DISPATCHERS |16 |16 |16 |
|LARGE_POOL_SIZE |200000000 |400000000 |400000000 |
|MAX_DISPATCHERS |40 |40 |40 |
|MAX_SHARED_SERVERS |80 |160 |160 |
|OPEN_CURSORS |400 |400 |400 |
|PROCESSES |200 |200 |200 |
|SESSIONS |220 |300 |300 |
|SHARED_POOL_SIZE |200000000 |400000000 |400000000 |
|SHARED_SERVER_SESSIONS |210 |285 |285 |
|SHARED_SERVERS |32 |40 |80 |
|SORT_AREA_SIZE |64000000 |64000000 |64000000 |

Table 4: Oracle9i Tuning Parameters

Section 5

The Application Servers

The Hardware

The Dell PowerEdge 1550 and Sun Enterprise 220R servers used for the application tier are similar in terms of processing power and memory capacity. The Sun E220R is 7 inches in height (4 rack units) while the Dell PowerEdge1550 is only 1.75 inches (1U) in height. This size difference allows for many more 1550s to be installed into a single rack than 220Rs by a significant margin. This advantage is not noted in the pricing or performance data, but is an important factor in space conscious data centers and computer labs. For configuration details see Table 5: Application Servers: Dell PowerEdge 1550 vs. Sun Enterprise 220R.

| |Dell PowerEdge 1550 |Sun Enterprise 220R |
|Operating System |Windows 2000 Server |Solaris 8.0 7/01 |
|CPU |2x 1 GHz Pentium 3 |2x 450 MHz UltraSPARC-II |
|CPU L2 Cache |256 KB |4MB |
|Memory |2 GB |2 GB |
|Disk |3x 9 GB* |2x 36 GB* |
|NICs |2x 100 Mbs (internal) |2x 100 Mbs (1 internal, 1 PCI card) |
|RAID Controller |PERC 2/DCL |None |
|Video |On-board |PCI card |
|Height |1 Rack Unit (1U) or 1.75” |4 Rack Units (4U) or 7” |
|Price as configured |$6,865 |$22,140 |
|Source | 2/20/02 | 2/20/02 |

*For hard drives, GB means 1 billion bytes; total accessible capacity varies depending on operating environment.

Table 5: Application Servers: Dell PowerEdge 1550 vs. Sun Enterprise 220R

The Software

Windows 2000 Server and Solaris 8 were the operating systems used on the respective Dell and Sun servers. Oracle9i Application Server was installed using the same settings on the Dell and Sun servers. Oracle9iAS is based on the Apache HTTP server and uses the Oracle backend database as a store for the pages and logic of its applications. In addition, Oracle9iAS includes components to enable security, web caching, database caching and single sign on. The use of Oracle9iAS Portal to create the database queries used in this study is described in Section 3, Solution Overview.

Oracle9i Database was actually released several months after Oracle9iAS. As a result of this, there were some patches that had to be applied in order to get Oracle9iAS to use Oracle9i as its database (referred to as the origin database). The patches are available from Oracle’s Metalink support site ( Sun Solaris required one patch and Windows 2000 needed two patches.

Oracle pricing is per CPU and is the same on all platforms. Some sample list pricing from Oracle’s web site is provided in Table 6: Oracle Pricing.

| |2 CPUs |4 CPUs |8 CPUs |
|Oracle9i Application Server Enterprise |$38,000 | | |
|Edition | | | |
|Oracle9i Database Server Enterprise | |$136,000 |$256,000 |
|Edition | | | |
|Source | 2/15/02 |

Table 6: Oracle Pricing

Section 6

Migrating the Application

Migrating the baseball statistics database and application from the Sun to the Dell solution was a simple two-step process. The first step was to migrate the baseball database tables. The second step was migrating the Portal-based Top 10 application. Oracle on different platforms is remarkably similar in the tools that are available and the procedures used to perform different operations. This provided for an easy migration path from Sun to Dell for both components of the migration.

The baseball data was moved via the Oracle export and import commands. On the source database (the Sun system in this case), a database dump file is created through the following command:

% exp baseball/password parfile=exp.params

where user baseball is the owner of the baseball database and the export parameter file exp.params contains


The baseball.dmp file was copied to the two Dell Windows 2000 Advanced Server systems and then the import command was run:

C:\oracle> imp baseball/password parfile=imp.params

where the import parameter file imp.params contains:

FILE=baseball.dmp IGNORE=Y FULL=Y

The import/export process can also be done through Oracle Enterprise Manager, Oracle’s graphical management tool.

This completed the first step in the migration, moving the actual baseball statistics data to the Dell servers. The next step was to move the dynamic pages that provide the logic for running the database queries against that data.

Oracle9iAS Portal actually stores all of the dynamic pages in the origin (backend) database and provides an export tool from its web interface to export this information into an export script file.

This export script file was created on the source (Sun E220R) application server and then copied to the two Dell PowerEdge 1550 application servers. The appimp command was run from the command line to import the Portal application into the database and register it with the instance of 9iAS on the Dell server. With the ORACLE_HOME environment variable set (C:\oracle\isuites in our case), in the C:\Oracle\iSuites\portal30\admin\plsql\wwu directory the appimp command was run as follows:

appimp -s portal30 -p password -m CREATE –f c:\temp\baseballappscript.sql -c

where the input parameters have the following meaning: -s database schema -p password -m mode (either CREATE or CHECK are valid) -f export script file -c connect string to origin database

The entire migration from Sun to Dell took about 20 minutes.

Section 7

The Tests An internal Dell simulation tool described in paper #1 of this series (see Section10, Bibliography) drove the web queries. Each simulated user issues one of the 6,000 possible queries and then spends an average of 10 seconds examining the results of that query before issuing another. The response time was measured from when the simulator submits the URL to the application/web server until the last byte of the returned HTML page is received. Server CPU utilization percent was measured on the Dell and Sun platforms by the Windows 2000 Performance Monitor and the Solaris vmstat command, respectively. The TCP/IP connection between the simulated browser and the application/web server was not kept alive between queries.

Four- and eight-CPU test results are shown in Table 7 and Table 8, respectively.

In the 4-CPU comparison, the Dell PowerEdge 6450 easily handled 450 users, delivering 2693 queries per minute with about a .1 second response time while utilizing only 65% of the server’s CPU power. The Sun E4500 with 4 CPUs, on the other hand, had more difficulty with that workload, using 90% of its CPU power and delivering 2,444 queries per minute with a much slower .9 second response time.

|Number of Users |Dell PowerEdge 6450 w/ 4 CPUs |Sun E4500 w/ 4 CPUs |
| |Queries per minute|Response Time |Server CPU% |Queries per minute|Response Time |Server CPU% |
| | |(sec) | | |(sec) | |
|200 |1199 |0.083 |26 |1155 |0.149 |43 |
|300 |1799 |0.093 |40 |1773 |0.188 |68 |
|400 |2388 |0.141 |56 |2288 |0.522 |84 |
|450 |2693 |0.116 |65 |2444 |0.9 |90 |

Table 7: 4-CPU Test Results: PowerEdge 6450 vs. Sun E4500 w/ 4 CPUs

The 8-CPU comparison between the Dell PowerEdge 8450 and the Sun E4500 with 8 CPUs tells a similar story. At 700 users, the Dell system handled 3,890 queries per minute with response time of less than .9 seconds and 57% CPU utilization vs. the Sun system’s 3,775 queries per minute at nearly 1.2 seconds response time and 74% CPU utilization.

|Number of Users |Dell PowerEdge 8450 w/ 8 CPUs |Sun E4500 w/ 8 CPUs |
| |Queries per minute|Response Time |Server CPU% |Queries per minute|Response Time |Server CPU% |
| | |(sec) | | |(sec) | |
|400 |2399 |0.107 |28 |2383 |0.151 |46 |
|500 |2980 |0.124 |40 |2927 |0.256 |55 |
|600 |3583 |0.162 |50 |3410 |0.982 |61 |
|700 |3890 |0.854 |57 |3775 |1.18 |74 |

Table 8: 8-CPU Test Results: PowerEdge 8450 vs. Sun E4500 w/ 8 CPUs

Section 8


Applications using the combination of Oracle9i Application Server and Oracle9i Database are easily migrated from Sun Solaris configurations to Dell PowerEdge servers. By storing all the components of Oracle9iAS Portal-based web applications in the backend database and providing powerful export/import tools, Oracle9i facilitates migration of the database tables as well as the application.

Once migrated, Oracle9i applications run faster on Dell configurations than on much more expensive similarly configured Sun systems. Using a realistic web-based query engine against a database of baseball statistics, we showed that a 4-CPU PowerEdge 6450 priced at $32,683 handles 450 users more easily than a Sun Enterprise 4500 with the same number of processors, which costs $147,085 or over four times as much. Similarly, we showed that an 8-CPU PowerEdge 8450 costing $62,437 outperforms the $228,885 Sun E4500 with 8 CPUs.

This White Paper is for informational purposes only. DELL MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS WHITE PAPER. Dell cannot be responsible for errors in typography or photography.

Dell, PowerEdge, and PowerVault are trademarks of Dell Computer Corporation. Oracle is a registered trademark and Oracle9i is a trademark of Oracle Corporation. Microsoft and Windows are registered trademarks of Microsoft Corporation.

Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and names or their products. Dell disclaims proprietary interest in the marks and names of others.

©Copyright 2002 Dell Computer Corporation. All rights reserved. Reproduction in any manner whatsoever without the express written permission of Dell Computer Corporation is strictly forbidden. For more information, contact Dell.

Information in this document is subject to change without notice.

Section 9


The authors would like to thank Zafar Mahmood and Sudhir Shetty for valuable insights into Oracle’s inner workings, Sean Lahman for use of his baseball data, and Bill Blackley of SIS Technologies for his repeated visits to our lab to fix the Sun Enterprise 4500.



1) Migrating Sun-Based ISPs to Dell Web Server Appliances. Part 1: Dell PowerApp.web 100 With Red Hat Linux • Power Solutions: • Tech Report (approved for external distribution):

2) Migrating Sun-Based ISPs to Dell Web Server Appliances. Part 2: Dell PowerApp.web 120 Microsoft Windows Powered • Power Solutions: • Tech Report (approved for external distribution):

3) Four Approaches to Dynamic Content With the Dell PowerApp Web Server • Power Solutions: • Tech Report (approved for external distribution):

4) Migrating Sun-Based BEA WebLogic Application Servers to Dell PowerEdge Servers. Part 1: Dell PowerEdge 1550 with Microsoft Windows 2000 Server • Power Solutions: • Tech Report:

5) Migrating Sun-Based BEA WebLogic Application Servers to Dell PowerEdge Servers. Part 2: Dell PowerEdge 1550 with Red Hat Linux • Power Solutions: • Tech Report:


: Baseball Database Organization

Database Tables

1 Master

15538 Rows

|Name |Datatype |Size |Scale |Nulls? |
|LAHMANID |VARCHAR2 |10 |0 |No |
|LASTNAME |VARCHAR2 |25 |0 |Yes |
|FIRSTNAME |VARCHAR2 |25 |0 |Yes |
|BATS |VARCHAR2 |1 |0 |Yes |
|THROWS |VARCHAR2 |1 |0 |Yes |
|BIRTHDAY |NUMBER |2 |0 |Yes |
|DEBUT |NUMBER |4 |0 |Yes |

2 Teammaster

149 Rows

|Name |Datatype |Size |Scale |Nulls? |
|TEAM |VARCHAR2 |4 |0 |No |
|LEAGUE |VARCHAR2 |3 |0 |Yes |
|START_YEAR |NUMBER |4 |0 |Yes |
|END_YEAR |NUMBER |4 |0 |Yes |
|CITY |VARCHAR2 |15 |0 |Yes |
|NICKNAME |VARCHAR2 |20 |0 |Yes |

3 Batting

80435 Rows

|Name |Datatype |Size |Scale |Nulls? |
|LAHMANID |VARCHAR2 |10 |0 |No |
|YEAR |NUMBER |4 |0 |No |
|TEAM |VARCHAR2 |4 |0 |No |
|LG |VARCHAR2 |3 |0 |Yes |
|G |NUMBER |3 |0 |Yes |
|AB |NUMBER |4 |0 |Yes |
|R |NUMBER |4 |0 |Yes |
|H |NUMBER |4 |0 |Yes |
|2B |NUMBER |4 |0 |Yes |
|3B |NUMBER |4 |0 |Yes |
|HR |NUMBER |4 |0 |Yes |
|RBI |NUMBER |4 |0 |Yes |
|SH |NUMBER |4 |0 |Yes |
|SF |NUMBER |4 |0 |Yes |
|SB |NUMBER |4 |0 |Yes |
|CS |NUMBER |4 |0 |Yes |
|BB |NUMBER |4 |0 |Yes |
|IBB |NUMBER |4 |0 |Yes |
|HBP |NUMBER |4 |0 |Yes |
|SO |NUMBER |4 |0 |Yes |
|POS |VARCHAR2 |25 |0 |Yes |
|BA |NUMBER |5 |3 |Yes |
|DOUBLES |NUMBER |4 |0 |Yes |
|TRIPLES |NUMBER |4 |0 |Yes |

4 Pitching

33574 Rows

|Name |Datatype |Size |Scale |Nulls? |
|LAHMANID |VARCHAR2 |10 |0 |No |
|YEAR |NUMBER |4 |0 |No |
|TEAM |VARCHAR2 |4 |0 |No |
|LG |VARCHAR2 |3 |0 |Yes |
|W |NUMBER |4 |0 |Yes |
|L |NUMBER |4 |0 |Yes |
|G |NUMBER |4 |0 |Yes |
|GS |NUMBER |4 |0 |Yes |
|CG |NUMBER |4 |0 |Yes |
|SH |NUMBER |4 |0 |Yes |
|SV |NUMBER |4 |0 |Yes |
|IP |NUMBER |7 |3 |Yes |
|H |NUMBER |4 |0 |Yes |
|ER |NUMBER |4 |0 |Yes |
|HR |NUMBER |4 |0 |Yes |
|BB |NUMBER |4 |0 |Yes |
|SO |NUMBER |4 |0 |Yes |
|ERA |NUMBER |7 |3 |Yes |

5 Fielding

113571 Rows

|Name |Datatype |Size |Scale |Nulls? |
|LAHMANID |VARCHAR2 |10 |0 |No |
|YEAR |NUMBER |4 |0 |No |
|TEAM |VARCHAR2 |4 |0 |No |
|LG |VARCHAR2 |3 |0 |Yes |
|POS |VARCHAR2 |3 |0 |Yes |
|G |NUMBER |4 |0 |Yes |
|PO |NUMBER |4 |0 |Yes |
|A |NUMBER |4 |0 |Yes |
|E |NUMBER |4 |0 |Yes |
|DP |NUMBER |4 |0 |Yes |

6 Sample Query

select ROWNUM "Rank", FIRSTNAME||' '||LASTNAME "Player", CITY||' '||NICKNAME "Team", LG "League", YEAR "Year", HR "Home Runs" from (select * from MASTER M, BATTING B, TEAMMASTER T where M.LAHMANID=B.LAHMANID and B.TEAM=T.TEAM and YEAR=:YEAR and LEAGUE LIKE :LEAGUE order by HR desc, LASTNAME, FIRSTNAME) where rownum < 11


Sun4 E4500
4x or 8x 450 MHz SPARC
4 or 8 GB Memory
2x18GB Disks internal
8 x 36 GB Disks RAID 10
Solaris 8.0 7/01
Oracle9i DB

Ora6450d PE6450
4x 700 MHz PIII Xeon
4 GB Memory
3x18GB Disks internal
8 x 36 GB Disks RAID 10
Windows 2000 Adv Server
Oracle9i DB

Ora8450a PE8450
8x 700 MHz PIII Xeon
8 GB Memory
3x18GB Disks internal
8 x 36 GB Disks RAID 10
Windows 2000 Adv Server
Oracle9i DB


100 BT Switch

100 BT Switch

100 BT Switch

Dell6 PowerEdge 1550
2x 1GHz Pentium 3
2 GB Memory
3x 9GB Disks
Windows 2000 Server
Oracle9i AS

Sun6 E220R
2x 450 MHz SPARC
2 GB Memory
2x 36GB Disks
Solaris 8
Oracle9i AS

Dell5 PowerEdge 1550
2x 900 MHz Pentium 3
1 GB Memory
3x 9GB Disks
Windows 2000 Server
Oracle9i AS


100 BT Switch

100 BT Switch

100 BT Switch

Firewall, routers, etc.

Firewall, routers, etc.

Firewall, routers, etc.

Users on browsers

Users on browsers

Users on browsers

Similar Documents

Premium Essay

Case Analysis

...EXECUTIVE SUMMARY Dell computer was founded by Michael Dell at age of twenty one in his dorm at the University of Texas, Austin. Dell’s strategy is to build computer so that it can be order by the consumers. It’s build to order strategy has made Dell the most successful company in the information technology field. Dell sells its machines and other equipments directly to customers so it has eliminated the middleman. Dell has high margin because of direct sale strategy and customers get excellent state of the art machines at low cost compare to Dell’s competitors. Michael Dell’s visionary leadership has made Dell the second most successful PC maker in the industry. (IBM is the leader). Dell’s ability to adapt to changing circumstances is its great strength. One week after the September 11th 2001 attack, Dell reported selling 24,000 servers and desktops. Dell established mobile technology park in Washington D.C. and New York by converting three eighteen wheel trucks and operated its factories round the clock to fulfill the unexpected customers demand. The trustworthy relationship between Dell’s management and work force made it possible to change the disastrous moment in the I.T industry to a great opportunity for the organization. Dell has very user friendly web site and half of Dell’s sale, half of tech support and three quarter of order status takes place online. The supply chain and data integration with suppliers has made Dell one of the most......

Words: 3942 - Pages: 16

Free Essay

Apple Introduction

...Apple Inc. Apple was established in 1976 as a computer company. However, in the last decade, Apple has expanded into a complex company that specializes in much more than just computers. In 2001, Apple broke the barrier of the music devices with the iPod, eventually becoming the dominant market leader in music players. In following, Apple joined the phone industry in 2007 with the iPhone, which has also been widely successful. Apple competes with many different companies throughout the different industries it takes part in. (21 competitors: Asiarim Corporation, Concurrent Computer Corporation, Dell Inc., Digi International Inc., Hewlett-Packard Company, Lenovo Group Limited, Insight Enterprises, Inc., RadiSys Corporation, SteelCloud, Inc., Silicon Graphics International, Super Micro Computer, Inc. etc). Apple recently reached third place in personal computer sales in the U.S., selling more Macs. Also, Apple is the leader in the tablet market with its iPad. In one quarter sold 9.52 million iPads. Apple has established a unique reputation in the consumer electronics industry since it is flexible from its philosophy of comprehensive aesthetic design. Its main characteristic is that it has a very strong customer base, which is extremely important in understanding Apple, has diversified its market and range of products to increase its profits and market share. Among its highest traded products is the iPod which enjoys global recognition. The company is currently operating over......

Words: 702 - Pages: 3

Premium Essay

Case 2.2

...Interoffice Memorandum To: From: Subject : Dell Date: I have reviewed Dell Incorporated most recent SEC Form 10-K filed on 3/15/2012 for period 1/28/2012 below is my findings. Competitors Dell faces aggressive product and price competition from both branded and generic competitors. Some of Dell’s major competitors include Apple, Hewlett-Packard (HP), Sun Microsystems, Gateway, Lenovo, Sony Acer-Toshiba and Asus. Suppliers Many of the suppliers are located outside of the U.S. and significant portions of the products they sell are now assembled by contract manufactures, primarily in various parts of Asia. Hardware components such as housing, memory chips, motherboards, disk drives, monitors, modems, and connectors are purchased in a highly competitive global markets served by many companies. Microprocessors and software operating systems are supplied by a few limited companies. Intel is the main supplier for microprocessors and Microsoft is the main supplier for operating systems. Business Strategy Dell’s basic business strategy is Cost Leadership with the objective to become the lowest-cost producer in the industry. Dell’s efficient supply chain management allows them to enter into flexible and mutually beneficial purchase arrangements with their suppliers to minimize inventory risk. Products and Services Enterprise Solutions and Services -Includes servers, networking and storage products. Services include a broad range of configurable IT and...

Words: 1002 - Pages: 5

Premium Essay

Report About Dell Inc.

...[edit] History [pic] Michael Dell, Founder of Dell. [edit] Origins and evolution | |This article or section may contain an inappropriate mixture of prose and timeline. | | |Please help convert this timeline into prose or, if necessary, a list. | While a student at the University of Texas at Austin in 1984, Michael Dell founded the company as PC's Limited with capital of $1000[4]. Operating from Michael Dell's off-campus dorm room at Dobie Center [1], the startup aimed to sell IBM PC-compatible computers built from stock components. Michael Dell started trading in the belief that by selling personal computer-systems directly to customers, PC's Limited could better understand customers' needs and provide the most effective computing solutions to meet those needs. Michael Dell dropped out of school in order to focus full-time on his fledgling business, after getting about $300,000 in expansion-capital from his family. In 1985, the company produced the first computer of its own design — the "Turbo PC" — which contained an Intel 8088-compatible processor running at a speed of 8 MHz. PC's Limited advertised the systems in national computer-magazines for sale directly to consumers, and custom-assembled each ordered unit according to a selection of options. This offered buyers prices lower than those of retail brands, but with greater convenience than assembling the......

Words: 5908 - Pages: 24

Free Essay

Dell and Oracle

...Oracle Corporation It’s a huge company that provides enterprise software and computer hardware products and services. It develops, manufactures, markets, hosts, and supports database and middleware software, applications software, and hardware systems. It is organized into three businesses: software, hardware systems and services. Its software business consists of two segments: new software licenses and software license updates and product support. It’s hardware systems business consists of two segments: hardware systems products and hardware systems support. It authorizes database and middleware software, including database and database management, application server and cloud application, service-oriented architecture and business process management, business intelligence, identity and access management, data integration, Web experience management, portals, and content management and social network software, as well as development tools and Java, a software development platform; and applications software comprising enterprise resource planning, customer relationship management, financials, governance, risk and compliance, procurement, supply chain management, enterprise portfolio project and enterprise performance management, business intelligence analytic applications, Web commerce, and industry-specific applications software. It also provides customers with rights to unspecified software product upgrades and maintenance releases; Internet access to technical content;......

Words: 2530 - Pages: 11

Free Essay

How Companies Are Named

...w areHow companies are named? ABN AMRO- In the 1960s, the Nederlandse Handelmaatschappij (Dutch Trading Society; 1824) and the Twentsche Bank merged to form the Algemene Bank Nederland ( ABN; General Bank of the Netherlands). In 1966, the Amsterdamsche Bank and the Rotterdamsche Bank merged to form the Amro Bank. In 1991, ABNand Amro Bank merged to form ABN AMRO. Accenture- Accent on the Future. Greater-than 'accent' over the logo's t points forward towards the future. The name Accenture was proposed by a company employee in Norwayas part of a internal name finding process (BrandStorming). Prior to January 1, 2001 the company was called Andersen Consulting. Adidas- from the name of the founder Adolf (Adi) Dassler. Adobe- came from name of the river Adobe Creek that ran behind the houses of founders John Warnock and Chuck Geschke . AltaVista- Spanish for "high view". - Founder Jeff Bezos renamed the company to Amazon (from the earlier name of after the world's most voluminous river, the Amazon. He saw the potential for a larger volume of sales in an online bookstore as opposed to the then prevalent bookstores. (Alternative: It is said that Jeff Bezos named his book store Amazon simply to cash in on the popularity of Yahoo at the time. Yahoo listed entries alphabetically, and thus Amazon would always appear above its competitors in the relevant categories it was listed in.) AMD- Advanced Micro Devices. Apache- The name was......

Words: 3479 - Pages: 14

Premium Essay


...DELL INC. was founded in 1984 by Michael Dell at age 19 while he was a student living in a dormitory at the University of Texas. As a college freshman, he bought personal computers (PCs) from the excess inventory of local retailers, added features such as more memory and disk drives, and sold them out of the trunk of his car. He withdrew $1,000 in personal savings, used his car as collateral for a bank loan, hired a few friends, and placed ads in the local newspaper offering computers at 10%–15% below retail price. Soon he was selling $50,000 worth of PCs a month to local businesses. Sales during the first year reached $600,000 and doubled almost every year thereafter. After his freshman year, Dell left school to run the business full time. Michael Dell began assembling his own computers in 1985 and marketed them through ads in computer trade publications. Two years later, his company witnessed tremendous change: It launched its first catalog, initiated a field sales force to reach large corporate accounts, went public, changed its name from PCs Limited to Dell Computer Corporation, and established its first international subsidiary in Britain. Michael Dell was selected “Entrepreneur of the Year” by Inc. in 1989, “Man of the Year” by PC Magazine in 1992, and “CEO of the Year” by Financial World in 1993. In 1992, the company was included for the first time among the Fortune 500 roster of the world’s largest companies. By 1995, with sales of nearly $3.5 billion...

Words: 2871 - Pages: 12

Free Essay


...Corporativa. Primer Examen en Equipo. Caso DELL. Profesor: Dr. Gaspar Sánchez Sánchez Mejorada. Creado por: Osvelia Guerrero Pérez               A00348824                 Felipe Peralta Ortega                    A00349034                 Blanca Becerra                               A01064099                 Norma Ríos López                         A01064367                 Monserrat Morales Cibrián        A00986189 14 de Marzo del 2011. PARTE 1 MODELO DE EMPRESA 1. ¿Cuál es el modelo de empresa (mapa mental) pertinente para la empresa? Haga una figura pertinente 2. Realice la racionalización del modelo de empresa. Se pide: Visión (slogan), misión, estrategia de negocio, productos y servicios y estrategia operativa. VISIÓN: “Is the way we do business: customers complete satisfaction” MISIÓN: * Flexible (Cambiante) Cultura dominante DELL Control (Estable) La cultura dominante en DELL es altamente planeada, con un comportamiento burocrático, que se mueve en un entorno flexible, con un toque de emprendimiento en procesos. Para DELL inventar the next big thing no es la meta. Su misión es construir the current big thing mejor que cualquier otro. * Clientes Los clientes de DELL son: * Usuarios domésticos. * Micros, pequeñas y medianas empresas. * Sector público. * Productos & Servicios Los productos más importantes de DELL al 2011 son: * Laptops &......

Words: 13388 - Pages: 54

Premium Essay

Capstone Paper

...Dell was founded in 1984 by Michael Dell, while he was a student at the University of Texas with only $1,000; he presently is the CEO and chairman of the board for the corporation. The original name of the company was PCs Limited and was changed to Dell Computer Corporation in 1988; then to Dell Inc in 2004 (Hitt, 2011). Dell Inc is one of the leading technology companies that offers a broad range of products, including desktop, personal computers, servers, networking products, storage, mobility products, software and peripherals, and services. Today, Dell has global revenues of over $60 billion and employs more than 78,000 individuals. Despite this tremendous growth, the organization has remained committed to its core values. The “Soul of Dell” creates an ethical framework in which people are the common thread which links the organization’s current position and future aspirations. The organization’s mission is “…to be the most successful computer company in the world at delivering the best customer experience in the markets we serve” (Soul of Dell, 2006). The vision of the company is: “…to lead in all regions we serve. The foundation of our success is the same in the United Kingdom and France, China and Japan, Canada and other countries. Customers want technology products that are relevant to them, offer great value and can be easily purchased and used. That’s what our team around the globe consistently delivers” (Fiscal 2005 in Review, 2005). Considering variations in......

Words: 2291 - Pages: 10

Premium Essay

Product Development at Dell

...Product Development at DELL Since its founding in 1984, Dell corporation had enjoyed tremendous success in the desktop computer industry. Their strategy was to eliminate the middleman by directly servicing the customers through mail orders . Dell grew from obscurity to a fortune 500 company in 1992, making its founder Michael Dell one of the youngest highly successful entrepreneurs of his time. At the core of Dell’s business model was Spartanism which inspired informality in processes and low R&D costs allocation. This worked with their desktop business and their imitators such as Gateway 2000 and CompuAdd were always playing the catching-up game. However moving ahead this philosophy, their foray in to the portable computer business was not as successful. This was an industry that revolved around several technological breakthroughs and required higher workmanship & quality control to manufacture products. Here, Dell fell short of delivering quality portable computers. Their brand suffered a major setback when their first line of portables were reported to have technical problems and about 17,000 units had to be recalled just one day before the launch. Soon after, Dell’s percentage sales in portable computers went to 2% from 17%, and their stock plunged by $7 in a single day. The portable computer industry was growing fast [Exhibit 1] and was deemed to spark a new wave of consumer demand. The major problems staring Dell in face were regarding quality......

Words: 1668 - Pages: 7

Premium Essay

Dell Computer

...CASE:  DELL COMPUTER’S  STATE‐OF‐THE ART PRODUCTION CENTERS USING                             VENDOR MANAGED INVENTORY MODELS    Michael Dell reshaped the computer industry with build‐to‐order computers directly sold to consumers.  His business model positioned the company for emerging internet sales , with one of the highest sales  figures in the industry. But Dell has done more than streamlined the selling and distribution process, he  has also streamlined the manufacturing process as well.  Dell can deliver the latest technology exactly the way the customer wants it at blinding speed, which has  earned them the nickname of “Dellocity”.  Examples of their speed are;  they delivered eight customized  fully loaded PowerEdge Servers to NASDAQ within 36 hours of receiving the order, or when they  delivered 2,000 PCs and 4,000 servers with proprietary and multimedia software delivered and installed  at 2,000 different WALMART stores all in 6 weeks. How does Dell manage to do all this at such incredible  speeds ?? Through close customer contacts and carefully orchestrated manufacturing and distribution  system.  Dell manufactures its’ computer systems in 6 different locations‐ Texas, Tennessee, Brazil, Ireland,  Malaysia, and China.  Dell has recently added a new factory in Round Rock, Texas, called the OPTIPLEX  Plant. This factory is state‐of‐the‐art and there are only a handful of such factories in the world.  The ......

Words: 849 - Pages: 4

Premium Essay


...Dell Inc., currently a US$60 billion company, was started by Michael Dell in 1984 when he was an undergraduate student at the University of Texas, in the United States. Within two decades, Dell, with headquarters in Round Rock, Texas, grew to become one of the world’s great computer companies, with near leading shares in the personal computer (PC) and server markets. Nearly 65 per cent of its revenue originated in North and South America; 23 per cent in Europe, the Middle East and Africa; and 12 per cent in the Asia–Pacific region. In 2003, a year in which most computer makers lost money due to slumping global demand for PCs, Dell saw its annual revenues jump by US$5 billion to US$36 billion, made US$2.8 billion in operating profit, and gained 2.3 per cent in global market share. By this time Dell had gained, and held for five years, the position of market-share leader. However, during the mid to late 2000s, Dell’s position in the global PC market began to change. In 2005 it lost its market-share lead to one of its main rivals, Hewlett-Packard. By 2008–9, Dell’s second-place PC ranking came under threat from the Taiwanese computer maker Acer. In 2003, Acer had ranked seventh in PC sales around the world, but by 2008–9 Acer’s share of the global market had risen to 11.8 per cent, just behind Dell with 13.7 per cent and HP still on top with 19.6 per...

Words: 259 - Pages: 2

Premium Essay

Giving Credit Where Credit Is Duw

...Krames (2003) is very enlightening an intuitive. Michael Dell according to Krames (2003) believes in the power of the customer, be it their positive or negative feedback, but especially in what the customer wants from a product (p. 56). Michael Dell birth a business model based solely on a one-on-one relationship with customers is the foundation of his company the Dell Corporation. Andy Grove’s model mandates protection or maximization of sales opportunities so to be prepared for all possibilities of success or failure which he based on Time magazine’s 1997 person of the year Andras Grof paranoid perspective (Only the paranoid survive) (Krames 2003, pp. 66-67). Business partner Moore’s metaphorically likened their organization to that of a three legged stool, if one leg is off balance so is the entire organization (Krames 2003, pp. 137-139). Lastly, Grove named the fear of an organization being on the brink of total failure as a “strategic inflection point” (SIP) which he describes as an organizations face-to-face with massive must change events even to a point of complete organizational failure (Krames, 2003, p. 141). Resistance Comparison Michael Dell organization encountered near death when the brilliance of his technical engineering team and himself put together a massive computer (The Olympic) that customers had no real need for, which in-turn caused a huge financial loss to the Dell corporation. Michael Dell went back to basics which involved customers from......

Words: 921 - Pages: 4

Premium Essay

Busn 412

...The Acer Group is one of the world's largest PC and computer component manufacturers. Associated Acer companies include the world's third largest PC manufacturer, and Acer's mobile computers, network servers and personal computers are ranked in the world's top ten most popular brands in their respective product categories. Acer is the market leader in many countries around the world, and is ranked in more than 30 countries globally owing to the strength of its core business. On the distribution side, in 2007 it is the world's No.4 PC branded PC vendor, number one in South East Asia, Latin America and Middle East, etc... Since spinning-off its manufacturing operation, Acer has focused on globally marketing its brand-name products: mobile and desktop PCs, servers and storage, LCD monitors and high-definition TVs, and handheld/navigational devices. Acer's unique Channel Business Model is instrumental to the company's continued success. The model encourages partners and suppliers to collaborate in a winning formula of supply-chain management, allowing Acer to provide customers with fresh technologies, competitive pricing, and quality service. Established in 1976, Acer Inc. employs 5,300 people supporting dealers and distributors in more than 100 countries. Estimated revenue for 2006 is US$11.31 billion (Acer Annual Report 2005). Stan Shih, the founder and chairman of the Acer group and widely regarded as a high-tech visionary, had a long term vision to transform the Group into a...

Words: 6727 - Pages: 27

Premium Essay

Acer's Strategy

...1. Acer's strategy has been described as "divide and conquer." Compare and contrast this to Lenovo's strategy. From the very beginning Acer has been a leading marketer of notebook and desktop PCs that were relabeled electronic products marketed and sold by recognized global companies. Acer struggled growing its business in the American market. To address this issue Acer spun off its manufacturing operations to transform from a global PC manufacturer to a marketing and services powerhouse by producing products faster, cheaper and more efficiently. The most effective way for Acer to grow was to engage in expanding its operations, marketing and selling activities to another market. In this case Acer decided to take the company globally and begin building a solid market in China. It's believed that if China becomes the company's "home" market, Acer will capture critical economies of scale that will allow it to develop innovative new products that will succeed in China as well as the rest of the world. Acer's chief technology officer, believes that Acer's knowledge of China's market will help the company achieve its growth and market share objectives. Acer implemented initiatives that placed them in a better position than Lenovo. At first Acer was suffering from poor brand recognition. Consumers were concerned about the quality and the reliability of its products. One of the ways that Acer overcame this obstacle was acquiring Gateway which created a path for Lenovo to......

Words: 1033 - Pages: 5