http://www.sybase.com
Sybase RAP-The Trading Edition, provides capital markets firms with a trading platform that combines a very fast, ultra-low latency solution, an in-memory component for real-time analysis and a column-based data warehouse that can store and analyze huge amounts of historical data extremely quickly. Rap The Trading Edition, solves issues with the volume and velocity of information that is coming into the financial services institutions.
Hi, my name is Neil McGovern and I am the Director of Product Marketing for Sybase. Today, I want to talk to you about some of the data challenges being faced by some of our financial services customers and how Sybase is helping address these issues. The major issue is the volume and velocity of information that is coming into financial services institutions. This has been growing exponentially over the last few years, and at the same time, the data windows, the trading windows, have been going down, the decision windows have been decreasing. And these are now less than one millisecond in many cases. And this is where the problem lies. In here. Too much data coming in too quickly and the need for reaction time is faster and faster every day. Financial services institutions, to date, have had to make a compromise. Do they choose speed or do they choose the ability to store and work with the huge volumes of information. If they choose speed, they use the technology from complex event processing, companies such as ALaRI, StreamBase and Correlate. This applies sequel to the information as its coming in and identifies significant events for trading systems. If they needed to store a volume of information they started to load that into their traditional relational database management systems. These systems really were just not designed for this volume or velocity of data. Too much information coming in too quickly, the systems could get overloaded, the response times goes down significantly, queries can take minutes, something hours. So even with the traditional solutions being used there are problems.
Sybase, with our customers and our partners created an alternative solution to this. We kept the CEP engines so that as these huge volumes of information come in, we can identify significant events. But we also added a unique piece of technology called the vertical database that is very good at storing information very quickly and can scale to store huge amounts of information. We put these together in one package called RAP The Trading Edition. But we did more. We also added in an in-memory data base so that you can store your information as it comes in memory almost instantaneously and have all access to it for real time risk management, for real time trade cost analysis or a few minutes later, or a few seconds later, the information will be available in the massive data store with years and years of context and historical data.
This vertical database, in addition to being very good at storing information, is also very, very quick at retrieving information. Queries that can take minutes or longer on traditional systems take seconds. We see performance increases of a hundred to a thousand times fairly regularly. And people, when I tell them this, ask how it is done. Well, it is the architecture of the database. In the traditional database, data is stored in rows, so you have column one, next column two, column three, column four and so on. And if you are trying to do a view of column two, you have to read here and then keep reading through it to read the next row and then the next row to get the information. This is very time consuming, this horizontal way of storing data is very time consuming when you are retrieving information. In a vertical database we store the column information together so column one is altogether, column two is altogether, so you can see taking a view of column two is almost instantaneous. But it gets better than that. Because we know we are storing the same types of information together, we can apply compression techniques to this, and, because the information is stored in an index, basically, we dont need indexes in this database. The data is the index. So we can take a terabyte of information that typically would explode three terabytes, by the time you put it into the traditional database and add all the overhead, and we can take that and compress it down to, typically, maybe thirty percent of what it is, so one terabyte goes down to about a third of a terabyte. So, not only is this very quick, it's also very efficient.
So this is RAP The Trading Edition. A very, very fast solution, a memory solution for real time and also huge amounts of historical information that can be stored very quickly and accessed very quickly. If you need more information go to the Sybase.com/RAP. Thank you very much.
Loading...
Solution is easy. Evolving data compression program + quantum computer = advanced algorithms.
H0D0NKAIN 1 year ago