To: DownSouth who wrote (2917 ) 3/30/2000 8:09:00 PM From: Lucky888 Read Replies (1) | Respond to of 10934
NTAP -- I will try here. Nowdays, I believe most storage boxes are purchased for increasing database needs and oracle database is the most popular type. It depends on the type of application running on top of oracle database, the requirement on the storage boxes are also quite different: (the following is from orcl's database documents) You can build thousands of types of applications on top of an Oracle Server. This section categorizes the most popular types of application and describes the design considerations for each. Each section lists topics that are crucial for performance for that type of system. * Online Transaction Processing (OLTP) * Data Warehousing * Multipurpose Applications Online Transaction Processing (OLTP) Online transaction processing (OLTP) applications are high-throughput, insert/ update-intensive systems. These systems are characterized by constantly growing large volumes of data that several hundred users access concurrently. Typical OLTP applications are airline reservation systems, large order-entry applications, and banking applications. The key goals of an OLTP system are availability (sometimes 7 day/24 hour availability); speed (throughput); concurrency; and recoverability. Data Warehousing Data warehousing applications distill large amounts of information into under-standable reports. Typically, decision support applications perform queries on the large amount of data gathered from OLTP applications. Decision makers in an orga-nization use these applications to determine what strategies the organization should take, based on the available information. The key goals of a data warehousing system are response time, accuracy, and avail-ability. When you design a decision support system, you must ensure that queries on large amounts of data can be performed within a reasonable time frame. Deci-sion makers often need reports on a daily basis, so you may need to guarantee that the report can complete overnight. Multipurpose Applications Many applications rely on several configurations and Oracle options. You must decide what type of activity your application performs and determine which fea-tures are best suited for it. One typical multipurpose configuration is a combination of OLTP and data warehousing systems. Often data gathered by an OLTP applica-tion ?feeds? a data warehousing system. ---------- As you can see from above, that OLTP requires high speed connection between the storage devices and the workstation running the oracle database. NTAP's filer is too slow for this case and that's where EMC boxes that with fiber channels coming into play. L. ps: More discussions are weclome