Words: 1614
Joe Consultant of C/S R Us presented 3 client/server designs to the CIO and is questing the CIO to select one. The CIO is not sure which middleware design is best for the company goals. The CIO has asked Chris Consultant to present the advantages and disadvantages for each of the alternatives. Background ACME Financial Incorporated (OAF Inc. ) is an investment banking company that provides an on-line service that allows their clients to access account and market information. ACME Financial Inc. Gently acquired several small and medium sized companies throughout the country, each with their own financial and accounting systems. Almost all of the companies eve developed their own application software for their analysts’ use in their daily jobs, but only a few provided on-line account service. The analytical tools rely on near-real time market data and historical market data. The CIO wants to consolidate the financial and accounting information into a corporate information system that can support decision support applications for corporate management.
Naturally, since the computer hardware is different for different companies, the CIO expects to upgrade the hardware to accommodate the new Information Technology (IT) system. The CIO will select he best analytical software as the standard software used by all company analysts. Each local site will be expected to provide an on-line service for their customers. Customers will be given the necessary application software to access their account information. Finally, ACME Financial has developed special data mining software that gives them a competitive advantage. OAF Inc. Offers their customers investment advice based on the information derived by the data mining software. Each account manager receives the information and then provides tailored recommendations to each customer based on their portfolio. System Requirements The following list of system requirements reflects the system’s priorities (listed roughly in order Of priority): 1. Availability: The Coo’s number one priority is high availability. OAF Inc. Markets their reliability and feels that most clients choose them for their dependability. The CIO wants to maximize the system’s availability.
To achieve high availability, if a regional office cannot provide support then a customer must always have access to the on-line service through a different office. 2. Data Integrity: The requirement for data integrity varies within the system. The most important data are customer’s transactions. It is essential that a customer’s transaction is never lost and the system must guarantee that each transaction is completed. In contrast, data lost from the high data rate inputs, such as Reuters and the NYSE, are easily recovered during the each broadcast so it is not critical if some data are lost during a broadcast. . Performance: Financial markets are highly volatile; time sensitivity of data is measured in minutes. Millions can be lost if information is delayed getting to the analysts. The system must be able to support information broadcast throughout the network. . Security: The CIO is concerned about the security of the data mining software and the information produced by the data mining software. The Chief Executive Officer thinks the data mining information software provides a competitive advantage for the company.
If an unauthorized user had access to the information they could steal the data mining applications or steal the information produced by the data mining software. In either case, the perpetrator could make the same investment recommendations as OAF Inc. Account managers. Therefore, if competitors had access to the information he results could be financially devastating to the company. The CIO is concerned that a competitor could pose as a customer and hack into the highly sensitive information through his on-line service account. 5.
Growth: The CIO envisions an incremental migration process to install the new system due to the magnitude of the change. Also, he expects that OAF Inc. Will continue to grow and acquire more companies. The CIO wants to be able to develop more application software as new customer services are added. The CIO also wants to add more near-real time information sources to the system. 6. Backup and Recovery: The CIO understands that the system will encounter problems from time to time. A key factor in determining the system’s success is how quickly the system can recover from a failure.
Backup and recovery must be smooth and non-disruptive. One way to ensure that the system can easily recover from a system crash is to make sure the data is duplicated elsewhere on the system. The corporate database is the primary back up for each of the regional offices. Configuration Each local office (Northeast, Northwest, Southeast, Southwest) has accesses a regional information hub. Local offices use client software to access the local application server. These application servers access the local databases for almost all of the information needed on a daily basis.
For access to information needed less frequently the application software should access the central database at corporate headquarters. Each regional database has only the subset of information that is relevant for its area, whereas the corporate headquarters maintains all of the information from each region as well as data that is unique to corporate applications, such as additional accounting and company financial information. The corporate office is also responsible for the data mining software and information. Each of the regional databases is connected with high capacity links to the corporate database.
Finally, the corporate office receives information from Reuters, NYSE, NASDAQ, and other financial markets. The information flow fluctuates daily from 30 – 40 KBPS to 4 – 5 MBps. Twenty-five percent of the information is immediately broadcast to the regional offices to support the on-line account service. All the information is filtered and stored in the database. Architectural Alternatives Alternative l: The Database Management System This alternative takes advantage of the extended functionality provided by the popular relational database management companies, such as Oracle and Sybase.
All information is delivered into the system where it is immediately stored into one of the databases. The relational database management software is responsible for the distribution of information throughout the system. Clients communicate with the databases through Standard Query Language (SQL). Corporate and regional databases are kept synchronized using features supplied by the READS software. Transactions are guaranteed by using special Transaction Processing Software. The vendor-supplied READS software is responsible for back-up and recovery of all the databases.
Data security is handled at the row level within each database. This means that clients can only receive records for which their user has permission. Existing application software may have to be modified to use SQL. Alternative II: Common Object Request Broker Architecture (CORBA) This solution depends on CORBA to tie together the clients and databases. CORBA is responsible for distributing data across the system. The READS software is till responsible for the back-up and recovery, but the databases are kept synchronized using CORBA as the primary transport mechanism for the data.
Clients, application servers, and databases communicate to each other through CORBA’s transport mechanism. Existing application software would be wrapped in IDLE to communicate with other applications. Special near-real time handling application software would send the information to each of the regional offices where it would be directed to clients that subscribe to the information. Alternative Ill: Message and Queuing (M&Q) The message and ensuing design uses commercial M & Q software combined with a transaction processing product to ensure customers transactions are completed.
Deck Message Queue and MS Series are some of the leading products for messaging and queuing software. Clients communicate to other entities using messages. Messages are deposited in queues and the message and queuing middleware is responsible for message distribution to the appropriate clients. The software applications will be modified to send and receive messages from queues. Questions to Answer (Total 1 00 points) The case study must be discussed covering the designs and these questions tit your teammates, but your final write-up should be your collaborative work.
Doing research on specific products for the assignment should certainly be a team activity. The total length of the write-up should probably not exceed 5 pages. 1 . Describe in more detail the architecture of each architectural alternative. To do this you will need to flesh out the specifics of the various parts. This will require some research on the products indicated (or other comparable products that you locate). Note that some services are automatically provided when a particular product is purchased, while others gust be developed to satisfy the system requirements.
You should describe what services are automatically provided by the products, which services would need to be developed, and how services should be distributed across the network. (40 points) 2. Evaluate each of the alternatives against the system requirements, discussing the advantages and disadvantages of each. (You may assume that the hardware will support all solutions. ) In your analysis you might consider issues such as which alternative gives the system developers the most flexibility, which alternative provides easiest maintenance, and which alternative requires the least modification to the current system.
Other hints for system comparison are listed below. (40 points) 3. Prioritize each alternative or suggest a different solution if you think it superior to the presented alternatives. (20 points) Suggestions on how to proceed 1 . There is not enough information to make an informed decision about each of the alternatives. As a team, allot a percentage of your time to discover which products offer what type of services. You do not have enough time to do a complete market survey so be selective. 2. If you depend only on racketing information you may find that the alternatives are equivalent.