-
.
Local Times:
-
|.
Chicago: 16:04
|.
New York: 17:04
|.
London: 22:04
|.
Frankfurt: 23:04
|.
Tokyo: 7:04
..Options pricers, company research, company valuation, research in theoretical finance.
DerivativesStrategy.com
Options pricers, company research, company valuation, research in theoretical finance..
.--.
Print this       
.
:.--:
-home
-
-login
-
-DS Magazine
-
-Best of
-
-Archives
-
-Media Kit
-
-Comix
-
-Subscribe/Renew
-
-Sample Issue
-
-Conferences
-
-Software Database

Information Management Network

 
-
|select-------
-------------
-
Bloomberg's Secret

Hidden inside your Bloomberg is an impressive suite of trading and risk management applications.

By Andrew Webb

Although I have been aware of Bloomberg since its inception, I've spent much of my trading career using proprietary systems. From a derivatives viewpoint, I have always regarded Bloomberg as a product for dilettantes-fine for getting an overall picture (and including some neat features), but nothing you could really trade with.

I have to admit that most of my preconceptions were wrong. In the last three or four years, the company's derivatives service has come of age. Its data and analytics service incorporates derivatives functionality for all types of underlying securities. This functionality is not a stand-alone module, but is fully integrated with all other security pricing and analytics, news, and messaging.

In the past, the company was infuriatingly selfish with its data, and made it difficult or impossible for users to export its data to their own spreadsheets for analysis. But the company's Open Bloomberg system now allows derivatives aficionados to manipulate Bloomberg's proprietary database.

Bloomberg's screens had also been hampered by limited hardware capacity. A large investment in mainframes has given the company the horsepower to handle the data proliferation caused by the huge range of contract specifications in derivatives. At the same time, a large number of programmers have been added to the staff, improving the range of derivatives functionality and analysis.

You won't, however, find screens for the latest hot pricing model. Bloomberg tends to be cautious about road-testing such features as new pricing models before putting them on the system. But I was surprised by just how sophisticated the derivatives coverage was. As one user put it, "You'd never say that Bloomberg is going to be the first to do something, but when they do it you know it'll be solid."

Looking at the fixed-income screen (GOTK) gives one a clear impression of the system's scope. Users can value bonds against swap curves, both historically and on an asset-swap basis. Although Bloomberg was not designed as a dedicated derivatives feed and trading system, the swaps coverage comes pretty close. The range of contributors is impressive and it has the analytics to match-fixed-versus-floating, currency swaps, callables, whatever. Complete swap portfolios as well as individual swaps can be entered, tracked and revalued at will. Equity derivatives coverage is equally comprehensive, with every conceivable market covered in detail.

Value-at-Risk, curve volatilities and other risk management numbers are also available, but I don't think Bloomberg is (or pretends to be) a complete risk management solution. That's fair enough, as the Bloomberg approach is to combine respectable depth with enormous breadth. Getting involved in the ramifications of developing an on-line risk management application would divert resources needed for media, data and other analytics.

Those clients who opt for Open Bloomberg have the ability to download both raw and Bloomberg-calculated data into Excel and manipulate it, so if they want to use your own proprietary pricing models, volatilities and curves, they can. On the other hand, they can't (as yet) export the formulas for Bloomberg analytics, which is a shame. Given that some of the pricing models have become virtually the industry standard, this shortcoming could allow the competition to steal a march in the longer term.

Being a prominent member of the paper-based flat earth society, I feel uneasy without a systems manual. Bloomberg's view is that since virtually every week brings a new release or modification to the system, any printed manual would be out of date as soon as it was released. Users can instead print out any relevant sections of the online manual that they require, to ensure timeliness.

Support was outstanding, and the staff was both knowledgeable and helpful. There was always someone available; no hanging on listening to canned music or being shunted around voice mail hell. Nothing was too much trouble. When a flaky dial-up connection on my workstation acted up (not a Bloomberg problem), a member of the support team immediately dispatched a Bloomberg Traveler laptop to my office, two hours from Bloomberg's London office.

Bloomberg includes in its price on-site training for new clients, yet the system is fairly intuitive in its own right. It took me about an hour without assistance to get up to speed on the basics. Within four hours, I was happily constructing improbable swaps. I found both the range and depth of Bloomberg's derivatives coverage impressive. Granted, if you're an ambitious quant on the cutting edge of derivatives innovation, you might find an odd gap to complain about, but for mere mortals this is the right stuff.

 

Jose Ohayon
Managing director, OTC

Overall, Bloomberg's derivatives offering is quite comprehensive, combining superior market information and securities descriptive data with a set of powerful analytics and risk management calculations.

Market information

Thanks to the breadth and depth of its information, Bloomberg uniquely provides the ability to analyze domestic and international fixed-income and derivatives markets to identify trading and arbitrage opportunities. World markets swaps, money market rates, and generic and customized pages are available to compare historical spread between countries, track live rates, or perform basis spread analyses. Bloomberg also offers a broad selection of international swap curves (Eurodollar, international and non-LIBOR) as well as user-definable swap curves that can be manipulated and stored for scenario analysis and what-if valuations for swaps, caps, floors, swaptions, bonds and repo instruments. These are complemented by a wide range of international yield curve volatilities that provide the foundation for pricing swap instruments with embedded options. Finally, a multitude of spot and forward yield curves (governments, corporates, agencies, swaps, Euros) allow users to perform multiple curves comparisons, intermarket spread analyses, and historical and future analyses of the bond and swap markets.

Securities descriptive data

The ability to create, store and retrieve derivative securities descriptive and pricing information via predefined templates for swaps, swaptions and other complex swaps structures, combined with the capability to distribute these "deals" to customers, make the Bloomberg product a powerful yet simple "offering" system. Securities coverage includes bonds, caps, floors, collars and FRAs, as well as vanilla, amortizing, cross-currency, callable/puttable, O/N indexed swaps and LIBOR/non-LIBOR basis swaps. Securities can be marked-to-market and what-if analyses can be performed and saved on the user's private database. Market conventions are also stored, including the curves selected for valuation purposes.

Calculators

Bloomberg offers many calculators with predefined market and data conventions relying on both standard and nonstandard calculation methodologies. These calculators can be combined with user-defined yield and volatility yield curves to allow for exhaustive what-if analyses.

These calculators include swap calculators for all swap structures; cap/floor/collar calculators for premium, implied volatility or strikes values using Black-Scholes FRA calculators (including broken dates); calculations using cash/LIBOR and Eurocurrency rates; swaption calculators for market value and sensitivities calculations for European-, Bermuda- and American-style options using Black, Black-Derman-Toy, log-normal and normal nonreversion calculation methods; and cash flow analyzers for valuing swaps cash flows with user-defined curves.

Analytics

Bloomberg analytics enable users to perform a wide variety of analyses on securities stored in both the user's and Bloomberg's private database. They include swap horizon analyses; swap cash flow generation and NPV calculations; rich/cheap analyses and current/future values for FRAs; swap hedge ratio analysis; TED and asset swaps spread analysis; swap futures duration hedging; matrix pricing; futures strip analyses; and bond-versus-swap yields analysis.

Options analytics include premium, volatility and sensitivities calculations for equities, indices, bonds, swaps and currencies, including exotic options (Asian, barrier, digital, compound, chooser and executive options). All these analyses can be performed on previously stored securities using a variety of standard and user-defined yield curve scenarios and benchmarks.

Portfolio analysis and risk management

Bloomberg offers both portfolio analysis and tactical risk management capabilities. Users can create, store and retrieve individual securities or portfolios, and perform position, P&L and Value-at-Risk calculations.

Portfolio historical, present and horizon analyses offer position, P&L, cash-flows, price sensitivity and return calculations under different currency, yield and volatility curve scenarios. Yield, duration and convexity scenario analyses allow users to perform strategy adjustments on their portfolios. Stress-testing of portfolios is made easy thanks to the available market and securities information and their complete integration with analytics such as the Portfolio Rebalancing and Trade Entry Idea capabilities. Several formats for portfolio pricing, structuring and risk display are available. The product gives users up to 10 risk reports for each portfolio.

Bloomberg's PVAR enables users to assess risk across a group of securities using both historical and option analysis. Bloomberg performs VAR calculations using the Variance/Covariance methodology of JP Morgan RiskMetrics with either JP Morgan's data or its own. Both portfolio summary and individual securities VAR calculations are available, and allow for intracurrency, intercurrency and intermarket risk reduction. Finally, a PCAD (portfolio capital adequacy) report is available.

Once more, the strength of this analysis stems from the availability of a comprehensive security database and cash-flows for all types of instruments, historical prices to track volatilities and correlations (correlation matrices), and option analytics to handle nonlinear assets. For the latter, Bloomberg calculates the delta, vega, gamma and theta using a modified Black-Scholes model for European options and a binomial price tree for American options.

Overall, Bloomberg has delivered strong derivatives analytics and tactical risk management capability by seamlessly integrating Bloomberg market and securities data with powerful analytical, modeling and archiving capabilities. The ability to create curves, swap structures, analyses and risk reports and to distribute them in a simple way is one of the most powerful features of the system. The product provides a standard, easy-to-use interface but lacks flexibility, particularly with respect to capturing transactional data from external systems. In conclusion, the product meets the needs of a broad audience of risk practitioners and managers.

Jose Ohayon is a managing director of OTC, a consulting and software development organization. Ohayon has more than 12 years' experience in the strategic analysis and development of electronic order routing and execution, trading and analytical systems in the foreign exchange, fixed-income and derivatives markets. He holds a master of science degree in computer science and an MBA from the Massachusetts Institute of Technology.


Bloomberg

One system: $1640/month
More than one: $1140/month per system; slightly higher in continental Europe and Indonesia
Terms: two-year lease; 1.5 months try and return.
Headquarters: Bloomberg Financial Markets, 499 Park Avenue, New York, NY 10022
Contact: Leslie Van Orsdel, derivatives product manager
Phone: (212) 318-2244
Fax: (212) 318-2080
email: orsdel@bny1.bloomberg.com
London: City Gate House, 39-45 Finsbury Square, London EC2A1PQ, 44-171-330-7500


Clients' Opinions

Dan Golla
LIFFE floor trader (Bund and Euromark)

Although I don't use Bloomberg now (it isn't really appropriate when you are looking at only a few markets), I used it extensively when I was a member of the OTC bond option team at UBS. For that it is excellent, because you are looking at curves, repo, volatility and history at the same time. It's OK for daily charting, but not ideal for really fast markets like these. A great advantage is the extensive database for bonds, options, volatilities and so on. There is really nothing like Bloomberg, and for a prop trader in a bank it's ideal.

Gavin Gilbert
Associate director, Bear Stearns, London

It's the best and cheapest thing out there for people who can't or won't build their own system. Though I trade using models that I built myself, I use all the Bloomberg functions as well, because clients and other traders also use them. Data delivery is timely-it may not always be the fastest, but if you want it much faster you'll have to go and work on the floor.

Bloomberg is careful to test new functions thoroughly before general release. I do quite a lot of this for them, and after an initial trial period we sit down and discuss any problems. Even after extensive additional testing, it will only go on conditional release with a disclaimer attached, warning that it's still under test.

Jim Liu
Vice president, Union Bank, California

We've been using Bloomberg for just over a year. We use it for interest rate swaps, currency swaps and pricing interest rate options such as caps, collars and floors.

It's also used for such non-vanilla things as swaps in arrears, amortizers and roller coasters. I'm quite happy with it; if there is ever a problem I send Bloomberg a message and it is corrected in a few days. Once, for example, the amortization schedule was too short. We asked them to lengthen it and they did. As a result of all this feedback, the software is getting better all the time.

We're thinking of moving over to the Open Bloomberg system. Now, if I create mark-to-market values for 40 swaps I have to manually plug those numbers into a spreadsheet, which is hard work.

I particularly like the portfolio feature, which allows users to put everything together and run the entire portfolio in a few seconds. That saves a lot of time. Users can even schedule it to do that automatically.

The system also has the ability to analyze multiple scenarios, so users can apply shocks to the yield curve and recalculate mark-to-market values instantaneously, for example.

William Hugel
Assistant vice president, Fuji Bank, New York

We use the trading system for our capital markets and securities trading groups. I've personally used Bloomberg since 1988 in both the open and closed versions of the product. I think its big strength is the ability to benchmark models against something that many other users and clients are running their systems off-or trading with. Because there is a wide acceptance of Bloomberg's models, they have credibility. The models offer a huge range of analysis, and Bloomberg is the only company that can provide you with all of this. In order to reproduce it yourself, you'd have to hire your own quant.


Informix's Universal Server

It's still early, but Informix's latest offering seems to serve up just what the doctorates ordered.

Universal Server is Informix's object-relational database management system (DBMS), which allows complex data types to be defined and handled efficiently through the use of purpose-built installable software modules. The driving force behind this innovation has been the fact that real-world data queries not only involve multiple data types, but often have complex internal structures. Though the product has numerous applications in the general business world, it has a number of specific features that make it particularly appropriate for financial markets, especially in risk management and derivatives. Universal Server runs on both UNIX and Windows NT.

History and background

Universal Server evolved from parallel developments at Informix and Illustra Information Technologies. In the early 1990s Informix made the decision to invest significant resources in "re-architecting" its existing OnLine Dynamic database server. The objective was to enable the server to use a multithreaded multiserver architecture called dynamic scaleable architecture (DSA), which uses lightweight threads for user tasks rather than full OS processes. Apart from allowing the database management system to use system resources more efficiently, this would also provide support for symmetric multiprocessing platforms and parallel database operations. In particular, the ability to partition data across multiple disks and to parallel-process such things as index creation and backups meant that the OnLine Dynamic server was capable of efficiently handling extremely large databases.

At the same time, Informix took the precaution of building hooks into core DBMS components so that the OnLine Dynamic server would be able to accommodate such things as user-defined data types and functions in the future. Specifically, Informix chose to adopt the object-relational model from the Postgres database research project at the University of California at Berkeley.

Postgres subsequently evolved into the Illustra Server, an extensible object-relational DBMS that could query and store complex data types as first class types as well as mix them with traditional data types within a relational database. A prominent part of the technology was the ability to use installable software modules (called DataBlades) that could introduce the server to new and complex data types, which could be user- or third-party defined. Informix, wanting to be first to market with an extensible DBMS, decided to acquire Illustra Information Technologies in early 1996 to shorten the development time span.

Product structure and principal features

The principal feature that sets Universal Server apart is its extensibility. A major factor in that extensibility is the DataBlade, which contains a collection of code and database objects that enhance the database server's performance by allowing it to handle specific and complex data types. The result is that server speed performance on these new data types is indistinguishable from that on existing built-in formats. Universal Server can thus enable the user to query the database to return the value of a portfolio of swaps and options. Currently no other database has the ability to directly represent, manage and query complex financial objects.

Informix has already provided some 20 different DataBlade modules which can handle data that includes anything from video to time-series information. In addition, the company provides the DataBlade Developers Kit, which clients and third-party developers can use to produce their own specialist data types. The DataBlade API allows any DataBlade to be snapped directly into the Universal Server. Informix proposes to license the API to third parties including other DBMS developers in the expectation of it becoming a common standard. Tandem has already announced its intention to add the DataBlade API to its NonStop SQL database manager, which will allow it to use any DataBlade that works with Universal Server.

The time-series DataBlade that Informix has developed is of particular relevance to financial markets. The number of individual records that this solution will produce for a financial instrument database is a fraction of that produced by a conventional RDBMS.

My view

The product is still in its early days. No investment banks have completed an implementation of Universal Server for risk management or derivatives as yet. Having said that, there are a number of banks already using either Illustra or OnLine Server who are likely to switch over to the combined technology of Universal Server in the next six to 12 months. There is no doubt that Universal Server is conceptually an attractive proposition; the ability to create one's own specialist data types with no performance penalty attached (the reverse, in fact) is significant. Even more significant are the architectural implications for risk management solutions when complex financial queries can be executed directly on the server. This is technology that has the potential to change the workflow from front to back office for derivatives trading. Informix's marketing claim that Universal Server's technology effectively provides a hardware upgrade to your data server is probably going to prove correct. The amount of redundant data processing that DataBlade technology should eliminate is justification enough for that.

The other obvious benefit will be a substantial reduction in network loading. The current situation in many banks is to have increasingly powerful user workstations with trading or RM models installed on them. The snag is that this involves calls to the server for binary large objects (BLOBs), which are then manipulated on the workstation before being returned to the server. Given that these may easily exceed five megabytes apiece, it doesn't take many power users to gridlock a network. Universal Server allows this data processing and manipulation (if desired) to be carried out on the server, with only the results of the analysis being sent to the workstation. With Sun's heavy promotion of its "thin client" network concept and the large number of Sun servers already in use in banks, the timing of Universal Server's release is, to say the least, fortuitous.


Independent Reviewers

Doug Crawford

With the addition of the Universal Server product line to its existing DSA server architecture, Informix offers intriguing new possibilities for designing and managing complex financial and risk management systems. The Informix Universal Server (IUS) greatly expands the range of traditional relational database systems by supporting complex data types and functions at the server level. The IUS combines the historical strengths of relational systems (speed, query facilities and so on) with the advantages of object-oriented systems in handling complex data. Complex data types can be manipulated as objects defined to the server rather than as BLOBs. Thus developers can use a proven query standard against complex data types.

Processing efficiencies

Informix has long used its dynamic scaleable architecture (DSA) as the basis for providing scaleable high performance in a transaction-processing environment involving traditional data types-numerical, decimal, floating point and so on. DSA uses server-optimized parallel, concurrent scan, join and sort operations to reduce processing times. This feature increases efficiency since the major components of query operations are broken down and processed in parallel, with the results being passed to the next operation as early as possible. Thus, the initial record scan is broken down across multiple processors and, as soon as results start to become available, join operations begin, followed by sort operations. In many systems the operations are performed consecutively. With the addition of IUS, applications can benefit by utilizing client or third-party-defined complex data types stored at the server rather than application level. One result will be applications with a naturally thinner client layer.

Development efficiencies

Developers can optimize their productivity through increased use of standards and reusable code. Since IUS supports complex data types and related functions defined as natural objects, developers can now use SQL to query complex data. Consider the query "Give me stocks whose 30-day moving average is higher than their 60-day moving average and recent articles on those stocks written by the analysts at Goldman Sachs and Morgan Stanley." In a traditional relational system, this query would be both a user's and a developer's nightmare. The time it takes the programmer simply to understand the bounds of the request would take several times longer than the user expects to get the completed answer back. Not to mention that such a query is not static; that is, the programmer would probably have to tweak his or her code if the same query ran a month later. If, on the other hand, the developer can define time series and text as data types and moving average as a function within the server, the query utilizes standard SQL with no sets of complex mapping required to retrieve and manipulate the data. By supporting complex data as objects, developers can take advantage of such object-oriented benefits as inheritance and overloading. Thus developers might define a simple swap object by defining a particular time-series data type for cash flows along with functions to calculate fixed flows, floating flows and price. To add a currency swap, object developers can create a subclass of swap and need only add a function for cross rates; everything else is inherited from the swap object.

Development flexibility and extensibility

The merger of Informix and Illustra and the resulting DataBlade product offers developers the ability to choose among a variety of solutions to a given problem involving complex data types. DataBlades are packages that contain definitions of complex data types along with all the functions for manipulating the new types. DataBlades "snap" into IUS through a DataBlade API that allows the new data types to take advantage of IUS/DSA features-SQL3 parser, query optimization, access methods and so on.

Architectural flexibility

IUS allows system architects greater flexibility when designing database structures and related applications as well as when converting from existing systems. While IUS naturally supports a movement toward a thinner client/fatter server architecture, users can choose to move anywhere along the spectrum. A good example would be an existing client/server system using a standard SQL2 database engine moving to an Informix SQL3 database engine. The easiest approach would be to simply swap the SQL3 engine for the SQL2 engine and leave the client and mapping layers virtually untouched. Most work would involve the differences between SQL3 and SQL2 (differences in stored procedure handing, updating, client API and so on). Moving along the spectrum, users could start to define new data types to the server, thus reducing the client/mapping layer and providing more efficient handling of complex data.

Implications

The features described earlier have a number of implications for system designers in the derivatives area by effectively blurring the traditional distinctions between applications and database. Many problems in typical derivatives environments are caused by the necessity of (and subsequent errors in) reconciling multiple versions of data. In many areas the front-office pricing system and models are completely separate from the back-office systems, creating an often difficult reconciliation between P/L numbers. Another problem often occurs in the confirmation process. The documentation area must typically prepare a confirm, send it to the counterparty and then track its progress until signed and returned. IUS offers developers an opportunity to reduce the number of data sources (and thus the number of reconciliation processes) without sacrificing flexibility. Developers can define swap objects with different price functions for different users-multiple sets for a trader who is trying to understand a market, and another defined by the risk managers as the standard curve for end-of-day valuation. Once the price functions are signed off by risk management, the source data can be reduced to a single point. By supporting complex data such as text, IUS allows greater flexibility in designing systems allowing personnel to compare different versions of a document to track changes or to alert a trader that a certain counterparty has documents outstanding such that trading restrictions exist. In addition to increasing systems productivity, if properly conceived and implemented, the IUS model could be used to greatly reduce such risk factors as operational risk, credit risk and fraud.

Doug Crawford is an independent consultant based in Norwalk, Conn. His practice focuses on database issues in the development and management of derivatives pricing, operations and risk management systems. He has been involved with database consulting, derivatives sales and trading, running derivatives operations and developing derivatives systems for the last 18 years. He holds a bachelor of arts and an MBA from Yale University.

 

Bryan Johnson

The traditional Relational Database Management System (RDBMS) was developed to handle information stored using a limited number of simple data types, notably integers, scientific floating-point, character strings, date/time and money. Elaborate but reliable mechanisms have been developed to allow for the data in the database to be accessed and updated by many users simultaneously while ensuring that the consistency of the data is maintained.

The largely industry standard structured query language has provided the means to make relatively complex queries on this sort of data. But a simple SQL query alone cannot answer the question, "What are the 13-week average sales for our top-five profitable products?" The profitability of all products must first be calculated before they can be ranked, and, for the top five, the calculation of the 13-week average sales must be performed. In order to keep processing of the query within the database engine, special functions, which have knowledge of the data, need to be invoked by the engine. Currently some of this processing ends up being performed in application code outside of the database engine, breaking up what could have been a single query into several steps and making the whole total query more difficult to maintain.

Organizations are now increasingly requiring their information systems to process complex data types such as images, audio, time series or dynamic web pages. Complex data types are often referred to as "objects" because they represent complex internal structures and usually require special functions or methods to create and manipulate the data. To date, RDBMS products have not handled complex data types well, relegating them to second-class status, by storing them as BLOBs. Although the database engine can store the complex data, as it has no understanding of the structure of the data in a BLOB, it cannot perform content-based queries on them. Queries on the complex data or objects largely have to be performed outside of the database engine by applications that do have knowledge of them.

It has become one of the holy grails of the database industry to provide SQL-based object-relational database systems that provide unlimited support for complex data types such as video, spatial, geographic and web, while retaining the performance, security and transactional features now expected of a RDBMS.

Universal Server can have any number of DataBlade modules installed. Customers will be expected to mix and match modules from Informix and third-party vendors or to write their own to meet unique business requirements. Informix has invested in a DataBlade Developers Kit to make it as easy as possible for third parties and customers to create, build and deploy their own DataBlade modules. Informix plans to have 250 available by the end of 1997.

While Informix sees the DataBlade architecture as a key benefit of its Universal Server, others have claimed that the approach is flawed. Grafting a third-party plug-in onto the kernel is seen as risky, because if the plug-in malfunctions, the database could crash. Oracle has announced that it will only embed in the kernel of its relational database engine the support for complex data types it develops in-house. Extensibility provided by third-party vendors, meanwhile, will reside outside of the database engine, in what are to be known as data cartridges.

Integrating the DataBlade modules within the database engine should allow for existing DBMS functionality such as transactional management, backup and recovery to be applied to the data stored in the new data types. This should increase the safety and reliability of the data. The stance taken by Oracle would seem to increase the problems of maintaining data consistency, as it will be stored across a number of independent databases, with the ensuing problems of multiphase commits.

In order to minimize the chance of reliability problems with DataBlades, Informix has established a certification process to ensure that a DataBlade module works with the Universal Server and all other certified modules, and that the DataBlade code does not affect the integrity of the DBMS. It is said that the certification process evaluates the DataBlade module in a number of areas, including code quality, test coverage, documentation and conformance to guidelines for safe execution.

Object-oriented programming is becoming the mainstream manner of application development. It is important that the underlying database should store data in a form that is as close as possible to the way it appears in the application. DataBlades provide the means to do this. The fact that it was shipped on schedule indicates the strength of the underlying object-orientated architecture the two original products shared. I look forward to having the opportunity to build an application using Universal Server.

Bryan Johnson, a British citizen, is a senior technical consultant at JCC (America). He holds a bachelor of science degree form Lancaster University in Great Britain, and has worked for the past 17 years as a database specialist on several large computer projects for clients including MCI, the government of the Netherlands, Digital Equipment Corp., ARAMCO and Price Waterhouse.


Client Opinion

Alexander Pastron
Assistant vice president of front-office technical services, Credit Suisse First Boston, New York

I think the Universal Server is a powerful concept. We are able to combine the standard relational data and the nonstandard object-oriented data in the same queries. This saves a lot of work on optimizing queries and gluing different systems together. Without Universal Server, the standard method would involve storing descriptive and time-series data in two separate databases. This causes a lot of problems for application developers; they have to know two different interfaces. It also causes problems when maintaining data for data integrity: How can you have the price for the security if you do not have a description of the security?

It's important that we are not tied to existing DataBlades, but that we have the option of writing our own code that will run in Universal Server. The extensibility of the server is the key feature, because while some existing DataBlades may not be as strong as existing Sybase functions, we can modify and enhance them ourselves, which you can't do on Sybase. You also have future proofing; if a previously untaught piece of technology suddenly appears, the company that specializes in it can simply write a DataBlade that can be ported to Universal Server far more quickly than to a standard closed-relational database.


Contacts

U.S.: James Maldonado, Director, financial services industry marketing, Informix Software Inc., 805 Third Avenue, New York, NY 10022
Phone: 212-546-0645
Fax: 212-753-4210
email: jem@informix.com
U.K.: John McKee, Sales manager, finance and banking division, Informix Software Ltd.
Phone: +44-171-395-5950
Mobile: +44-385-233674
Fax: +44-171-395-5901

--