Re: Simple Question?

Paul Brown wrote: > > Michael Segel (Mikey@NOSPAM.KingofMyDomain.MAPSON.Segel.com) wrote: > : the question: "How will UDO help me better manage my portfolio, (A/LM), > : or my Derivitives?" > > Every minute, for every stock, you get a row like; > > Stock Time Volume Ask Offer Last_Sale > > Now, the kinds of questions I want to ask are: > > "Show me the stocks who's six month momentum moving average is outside the > twenty-four month range?" > [SNIP] Paul, I am well aware of Bond Basis or Day Basis. As well as managing some derivatives. But you just brought up an interesting point. > - The central advantage of UDO is that all of this complexity > can be encapsulated behind a set of interfaces that extend the > SQL language. > Actually no. Not all. Some maybe but not all. > - To be efficient, you can't use the ROW per Tick model. You need > to use the extensible storage management stuff to interact with > this kind of data efficiently. Row per tick? Its really row per trade. (Sorry I can't comment more on that.) [NDA's are a bitch] > you write these applications. Suddenly, the trader/analyst can ask > questions like "Show me any press releases containing the name of > the CEO?" or "For this insurance company show me the geographic > distribution of their policy holders?" etc. > That's mixing apples and oranges. Think of the size of such a database and a machine which will be able to handle a *trading* scenario. [SNIP] My point is that you have to see the process for what it is. You have a database which is responsible for managing data. You need to process your data. Do you perform all the tasks on one machine? For some applications, yes. Or you can move to a 2 or 3 tier system. (Client/Server), (Thin Client/App server/ Calc Engine/ DB) In the examples of real time trading, (real time valuation of a security/option/derivative), you don't want to have all the processes on the same machine as your database. Think about it. You have an OLTP from 7-4 or longer. Then you want to run a monte carlo scenario on the same machine? Or you want to generate a *random path* based on two or more variables for your model? You will kill the machine. (Think distributed.) UDO doesn't allow for that. Even using ITO Calculus, you still have to run several complex equations in real time. I don't think I would want to run it as part of the engine. Now you had mentioned. J-SPL and C-SPL. How are they part of UDO? > > Let's talk Images. More precisely, let's talk images of faces. > No, I wanted to talk videos. A poster from the OSU math dept. Mentioned that the video is not part of the DB. So how does the Video DB enhance the performance over a non UDO solution? [SNIP] Go to your mainframe and ask "Show me all the sex offenders currently not in jail who live within the following counties." Now add "Who have eyes brwn, hair brwn" You will get the same results. But if you want to talk biometrics, then its a different story. [And no, I can't talk about it] -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resemblence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** * Attention * -*- Due to AGIS's Refusal to Act Responsibly -*- Due to ACSI's Refusal to Act Responsibly We are blocking all of their domains at the packet level. This block will exist until they modify their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************