Thursday, March 29, 2012
Does SQLSERVER support fuzzy text searching(like the function of agrep).
For example, given the input keyword [homogenos] and similarity
parameter [2 characters], the function will find out valid result from
datasource by either replacing,inserting or deleting upto two different
characters from word [homogenos].
Both homogenooos(homogeno[+oo]s) and homogeos(homoge[-n]os are valid
result.
thx.No, not directly. You need to build a function that does Levenstein Edit
distance. You will find an implementation of this in the Fuzzy functions
which ship with SSIS in SQL 2005.
You can also use the expansion options in the thesaurus capabilities in
FullText search so a search on homogenos could be expanded to search on
homogenos homogenoos, homogeneous or homogeos, but you have to know in
advance what all the expansions might be and hard code them into your
thesaurus file.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"zlf" <zlfcn@.hotmail.com> wrote in message
news:uGyRG55YGHA.4944@.TK2MSFTNGP02.phx.gbl...
> Does SQLSERVER support fuzzy text searching(like the function of agrep).
> For example, given the input keyword [homogenos] and similarity
> parameter [2 characters], the function will find out valid result from
> datasource by either replacing,inserting or deleting upto two different
> characters from word [homogenos].
> Both homogenooos(homogeno[+oo]s) and homogeos(homoge[-n]os are valid
> result.
> thx.
>
Thursday, March 22, 2012
Does RS cache AD groups?
I've run into a few problems, and I think RS may be to blame. I was hoping
one of the experts out there would be able to offer some input.
I set up role-based security in RS as follows:
Report 1, 2, and 3: all authenticated users assigned browser role
Reports 4, 5: a select group (AD security group named
"ReportingCommissions") assigned browser role
I added a new user to the ReportingCommissions group via Active Directory
Users and Groups and replicated both domain controllers.
After that, the user was not able to see report 4 or 5 in his list of
reports in the folder. If I added his exact Windows username to report 4 as
a browser, he can see it immediately.
Rebooting the server that houses the RS web app did the trick - the user can
now see both folders as a member of the group ReportingCommissions.
This leads me to believe that RS is somehow caching the list of members of
each Windows security group assigned to roles in RS. I can see why this
would be done, as it would slow folder browsing down to enumerate these
groups for every report in the current folder. Whereas matching up a
username should be much quicker, so there is no need to cache that info.
Is my assumption correct, or am I missing something? If the group
memberships are being cached in RS, can you tell me for how long? Is there
any way to clear that cache or add to a group's membership within the db?
Restarting the ReportServer service did not help, but I didn't try
restarting any of the IIS-related services.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]Has anyone run across this before? Any answers from MS? Thanks in
advance...
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
Jake Marx wrote:
> Hi,
> I've run into a few problems, and I think RS may be to blame. I was
> hoping one of the experts out there would be able to offer some input.
> I set up role-based security in RS as follows:
> Report 1, 2, and 3: all authenticated users assigned browser role
> Reports 4, 5: a select group (AD security group named
> "ReportingCommissions") assigned browser role
> I added a new user to the ReportingCommissions group via Active
> Directory Users and Groups and replicated both domain controllers.
> After that, the user was not able to see report 4 or 5 in his list of
> reports in the folder. If I added his exact Windows username to
> report 4 as a browser, he can see it immediately.
> Rebooting the server that houses the RS web app did the trick - the
> user can now see both folders as a member of the group
> ReportingCommissions.
> This leads me to believe that RS is somehow caching the list of
> members of each Windows security group assigned to roles in RS. I
> can see why this would be done, as it would slow folder browsing down
> to enumerate these groups for every report in the current folder. Whereas
> matching up a username should be much quicker, so there is no
> need to cache that info.
> Is my assumption correct, or am I missing something? If the group
> memberships are being cached in RS, can you tell me for how long? Is
> there any way to clear that cache or add to a group's membership
> within the db? Restarting the ReportServer service did not help, but
> I didn't try restarting any of the IIS-related services.|||I got a response for you from Tudor Trufinescu, a dev lead. He says he's
answered this often enough that it was time to create a blog entry. It's at
http://blogs.msdn.com/tudortr/archive/2004/10/27/248846.aspx and it mentions
a KB article as well.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jake Marx" <msnews@.longhead.com> wrote in message
news:eBAH5z3uEHA.3976@.TK2MSFTNGP09.phx.gbl...
> Has anyone run across this before? Any answers from MS? Thanks in
> advance...
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>
> Jake Marx wrote:
>> Hi,
>> I've run into a few problems, and I think RS may be to blame. I was
>> hoping one of the experts out there would be able to offer some input.
>> I set up role-based security in RS as follows:
>> Report 1, 2, and 3: all authenticated users assigned browser role
>> Reports 4, 5: a select group (AD security group named
>> "ReportingCommissions") assigned browser role
>> I added a new user to the ReportingCommissions group via Active
>> Directory Users and Groups and replicated both domain controllers.
>> After that, the user was not able to see report 4 or 5 in his list of
>> reports in the folder. If I added his exact Windows username to
>> report 4 as a browser, he can see it immediately.
>> Rebooting the server that houses the RS web app did the trick - the
>> user can now see both folders as a member of the group
>> ReportingCommissions.
>> This leads me to believe that RS is somehow caching the list of
>> members of each Windows security group assigned to roles in RS. I
>> can see why this would be done, as it would slow folder browsing down
>> to enumerate these groups for every report in the current folder. Whereas
>> matching up a username should be much quicker, so there is no
>> need to cache that info.
>> Is my assumption correct, or am I missing something? If the group
>> memberships are being cached in RS, can you tell me for how long? Is
>> there any way to clear that cache or add to a group's membership
>> within the db? Restarting the ReportServer service did not help, but
>> I didn't try restarting any of the IIS-related services.
>|||Stephen Dybing [MSFT] wrote:
> I got a response for you from Tudor Trufinescu, a dev lead. He says
> he's answered this often enough that it was time to create a blog
> entry. It's at
> http://blogs.msdn.com/tudortr/archive/2004/10/27/248846.aspx and it
> mentions a KB article as well.
Thanks, Stephen. I thought I had waited more than 15 minutes, but I was
probably just being impatient. I don't think our security group updates
will be that frequent, so I'll probably have users wait the 15 minutes (or
restart the w3 publishing service if we can't wait).
Thanks again - I appreciate the followup.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
Friday, February 24, 2012
Does a synchronous transformation process all rows in a buffer before outputting to next transfo
If you have two synchronous transformation components and the input of the second is connected to the output of the first, does the first transformation process (loop through) all rows in the buffer before outputting these rows to the second transformation? Or does the first transformation output each individual row to the second transormation as soon as it has finished processing it?
Thanks in advance,
Lawrie.
Parts:
Component A (CA), Component B (CB), Row 1 (R1), Row 2 (R2), Row 3 (R3)
Example Synchronous:
CA and CB are Synchronous transforms (as defined by something like: output.SynchronousInputID = Input.ID in the ProvideComponentProperties()) (http://msdn2.microsoft.com/en-us/library/ms136027.aspx). The package has the row buffer size set to 1. The data source has 3 rows. The package starts and the following happens.
R1 gets to CA from upstream
CA's ProcessInput is called with R1
CA's ProcessInput finishes and R1 is passed downstream
R1 gets to CB from upstream
CB's ProcessInput is called with R1
CB's ProcessInput finishes and R1 is passed downstream
R2 gets to CA from upstream
CA's ProcessInput is called with R2
CA's ProcessInput finishes and R2 is passed downstream
R2 gets to CB from upstream
CB's ProcessInput is called with R2
CB's ProcessInput finishes and R2 is passed downstream
R3 gets to CA from upstream
CA's ProcessInput is called with R3
CA's ProcessInput finishes and R3 is passed downstream
R3 gets to CB from upstream
CB's ProcessInput is called with R3
CB's ProcessInput finishes and R3 is passed downstream
Example Asynchronous:
CA and CB are Asynchronous transforms (as defined by something like: output.SynchronousInputID = 0 in the ProvideComponentProperties()) (http://msdn2.microsoft.com/en-us/library/ms135931.aspx). The package has the row buffer size set to 1. The data source has 3 rows. The package starts and the following happens.
R1 gets to CA from upstream
CA's ProcessInput is called with R1
CA stores R1
CA's ProcessInput finishes
R2 gets to CA from upstream
CA's ProcessInput is called with R2
CA stores R2
CA's ProcessInput finishes
R3 gets to CA from upstream
CA's ProcessInput is called with R3
CA stores R3
CA loops through stored rows and calls AddRow() on the output buffer and passes the data from the stored row to the new row
CA's ProcessInput finishes
R1-3 are passed downstream
R1 gets to CB from upstream
CB's ProcessInput is called with R1
CB stores R1
CB's ProcessInput finishes
R2 gets to CB from upstream
CB's ProcessInput is called with R2
CB stores R2
CB's ProcessInput finishes
R3 gets to CB from upstream
CB's ProcessInput is called with R3
CB stores R3
CB loops through stored rows and calls AddRow() on the output buffer and passes the data from the stored row to the new row
CB's ProcessInput finishes
R1-3 are passed downstream
OR
R1 gets to CA from upstream
CA's ProcessInput is called with R1
CA calls AddRow() on the output buffer and passes the data from R1 to the new row
CA's ProcessInput finishes and R1 is passed downstream
R1 gets to CB from upstream
CB's ProcessInput is called with R1
CB calls AddRow() on the output buffer and passes the data from R1 to the new row
CB's ProcessInput finishes and R1 is passed downstream
R2 gets to CA from upstream
CA's ProcessInput is called with R2
CA calls AddRow() on the output buffer and passes the data from R2 to the new row
CA's ProcessInput finishes and R2 is passed downstream
R2 gets to CB from upstream
CB's ProcessInput is called with R2
CB calls AddRow() on the output buffer and passes the data from R2 to the new row
CB's ProcessInput finishes and R2 is passed downstream
R3 gets to CA from upstream
CA's ProcessInput is called with R3
CA calls AddRow() on the output buffer and passes the data from R3 to the new row
CA's ProcessInput finishes and R3 is passed downstream
R3 gets to CB from upstream
CB's ProcessInput is called with R3
CB calls AddRow() on the output buffer and passes the data from R3 to the new row
CB's ProcessInput finishes and R3 is passed downstream
The point is with Asynchronous transforms is that the component must call AddRow() on the output buffer and passe the data from input buffer row to the new row for it to be passed downstream. As soon as ProcessInput finishes, any rows added to the output buffer are passed downstream. You may need to store all rows or just some and the base classes allow you to pass on records whenever you wish.
Many thanks for taking the time to provide such a detailed response. The only problem is that my question was really what happens with synchronous transforms when the package has the row buffer size set greater than 1!
If you could provide an example for this I'd be really grateful...
Thanks,
Lawrie
|||
lawrieg wrote:
Hi, If you have two synchronous transformation components and the input of the second is connected to the output of the first, does the first transformation process (loop through) all rows in the buffer before outputting these rows to the second transformation? Or does the first transformation output each individual row to the second transormation as soon as it has finished processing it?
Thanks in advance,
Lawrie.
The SSIS pipeline works on buffers at a time, not individual rows (unless buffer size is one).
So, the first component will pass rows to its output when its finished processing that row. But the second compoennt won't start processing until the LAST row in the buffer is passed - because then the buffer will be passed to the next component.
Does that make sense?
-Jamie
|||To expand the explanation for synchronous; change R1, R2, R3 to B1, B2, B3 where B = Buffer.Tuesday, February 14, 2012
Do we know when Reporting Services finish the report??
I'm using Reporting Services with ASP .NET, user input report parameters in the web page then click submit, report will be display in an IFRAME in page. For a small report, things go fine. However, some reports need about a minute or 2 to finish, and during that time, all we can see is a blank rectangle frame... Because the code's only job is passing parameters to Reporting Services, no running status is displayed in the status bar. Sometimes our users think that the report contains no data, but it's actually running.
I was trying to put a "Please wait" button in the page, but the wait message runs only when the program was still in OnClick proc, which is not correct in this case because OnClick finished just in second...
Any way we can know when Reporting Services finish loading data to the frame, so we can display a message or status? Right now I have to put a text say: Report process will take up to 5 minutes, please wait
Thanks,Use ReportViewer Control to show the Reports in ASP.NET pages.
http://www.odetocode.com/Articles/128.aspx
Regards,
Karthik.A|||
I'm using Report Viewer now. And that's why I have the problem. Whenever you push parameters to Reporting Services, Report Viewer "iframe" will be displayed right away, but first as a blank rectangle, then the data will appear. For a small report, the time is about a second or 2, but for some of my reports, you have to stare at that rectangle for a few minutes to see data...
And 'cause Report Viewer is loaded, no way (IMO) ASP page can know whether the data is displayed or not....
Anyway we can know when the data is displayed in the Viewer so I can tell the user?
Thanks for yr time, though
what i did ,First invisible the ReportViewer and the time of assigning the path i make it visible.
and try using Collapsable panel of eworld.UI control.
Regards,
Karthik.A
|||But for a lot of processing, the report will not display data right after you assign the path. When you assign the path, you actually pass on the parameters, no data is available yet... My problem is after I assign the path, I make the Report Viewer visible and my sub finish; but it takes the report a few minutes to process all the SQL query then push data back to the page. In the mean time, all you see is a blank rectangle.|||yes u r correct
i too tried for the same.i also got the same problem.
i have facerd another problem
when i try to send a long parameter as Query string
it gives me an Error stating Query Parameter is too long exceds 256 Characters.
How can i overcome this.
please enlighten me.
Thanx,
Karthik.A
|||Well, for a parameter, I'm not really sure why you want to put too much data in it. 256 is fine for me. If I want to pass long string to the report, I rather put it in a db table, then have the report read it... I don't think execute 1 more SQL Select command hurts your performance...