2 Replies Latest reply: Sep 4, 2013 10:13 AM by user2545677 RSS

    timesten trigonometric  functions

    user2545677

      We cache oracle 11g2 data in timesten 11.2.2.5.0   ( IMDB )

       

      We can't find any trigonometric functions like  cos(x), sin(x)  or so in timesten.

      Does that means timesten doesn't support trigonometric functions?

      So how we work around this problem then?

        • 1. Re: timesten trigonometric  functions
          Chrisjenkins-Oracle

          TimesTen does not currently support trigonometric functions. The only workaround is to move this processing logic into application code. Of course, that is not always a good solution...

           

          Chris

          • 2. Re: timesten trigonometric  functions
            user2545677

            Thanks for you answer anyway.

            sin/cos/asin  really make me suffer for three days.

            1. First I wanna use external function call c or java math method , but luckily,  timesten doesn't support it.  (oracle does)

            2. Then I  write my own sin/cos/asin algorithm in user defined function (took a long time to make it happen) , but still luckily, timesten doesn't support call user defined function in sql

             

             

            I sincerely hope timesten support trigonometric functions and calling user defined function in sql in the next edition (it's still 11.2.2.0.5, should be 12.*  like  the oracle 12c).

             

            It's a long way since v7.0,  I think it's the time to make user happier. Otherwise people should looking solidb for substitute.