self referencing table - Page 665

Redirect Error rows

- by Sreejesh Kumar

In SSIS 2008, how do we redirect error data to a log table from ADO.Net destination, using Redirect Rows ?

approximating log10[x^k0 + k1]

Greetings. I'm trying to approximate the function Log10[x^k0 + k1], where .21 < k0 < 21, 0 < k1 < ~2000, and x is integer < 2^14. k0 & k1 are constant. For practical purposes, you can assume k0 = 2.12, k1 = 2660. The desired accuracy is 5*10^-4 relative error. This function is virtually identical to Log[x], except near 0, where it differs a lot. I already have came up with a SIMD implementation that is ~1.15x faster than a simple lookup table, but would like to improve it if possible, which I think is very hard due to lack of efficient instructions. My SIMD implementation uses 16bit fixed point arithmetic to evaluate a 3rd degree polynomial (I use least squares fit). The polynomial uses different coefficients for different input ranges. There are 8 ranges, and range i spans (64)2^i to (64)2^(i + 1). The rational behind this is the derivatives of Log[x] drop rapidly with x, meaning a polynomial will fit it more accurately since polynomials are an exact fit for functions that have a derivative of 0 beyond a certain order. SIMD table lookups are done very efficiently with a single _mm_shuffle_epi8(). I use SSE's float to int conversion to get the exponent and significand used for the fixed point approximation. I also software pipelined the loop to get ~1.25x speedup, so further code optimizations are probably unlikely. What I'm asking is if there's a more efficient approximation at a higher level? For example: Can this function be decomposed into functions with a limited domain like log2((2^x) * significand) = x + log2(significand) hence eliminating the need to deal with different ranges (table lookups). The main problem I think is adding the k1 term kills all those nice log properties that we know and love, making it not possible. Or is it? Iterative method? don't think so because the Newton method for log[x] is already a complicated expression Exploiting locality of neighboring pixels? - if the range of the 8 inputs fall in the same approximation range, then I can look up a single coefficient, instead of looking up separate coefficients for each element. Thus, I can use this as a fast common case, and use a slower, general code path when it isn't. But for my data, the range needs to be ~2000 before this property hold 70% of the time, which doesn't seem to make this method competitive. Please, give me some opinion, especially if you're an applied mathematician, even if you say it can't be done. Thanks.

Search Results

Search found 34305 results on 1373 pages for 'self referencing table'.

Page 665/1373 | < Previous Page | 661 662 663 664 665 666 667 668 669 670 671 672 | Next Page >

- by Sreejesh Kumar

- by Yale Zhang

- by vinise

- by user1843471

- by CTGA

- by jasmine

- by Sergio Tapia

- by Syom

- by Michael Stone

- by Timothy

- by user2953138

- by vamshi

- by geoff swartz

- by user288178

- by Gidiyo

- by Krishma

- by vp789

- by Zé Carlos

- by Aaron Brethorst

- by Seerumi

- by Pselus

- by DevAno1

- by StackPointer

- by kwokwai

- by Haroldo

< Previous Page | 661 662 663 664 665 666 667 668 669 670 671 672 | Next Page >