Hi,
I have to implement a report where a text search functionality is to be provided. There will be 3 search options for report users: whole phrase, some of the words or all of the words.
The user will key in the words to be searched and depending on the search option chosen, records must be displayed where two free text columns provide the match.
What would be the performance implications of implementing this in a MOLAP platform? Or is ROLAP more suited for this purpose?
Regards,
Emil
Hi Emil,
It's not obvious from your report description why you're considering an OLAP solution at all - is the data multi-dimensional?
|||Hi Deepak,
The data is multi-dimensional. The columns where text search is to be performed holds problem and its solution. There are other dimensions on which most of the analysis of the data is done. The fact holds no aggregatable measures except count of records for the various dimensions.
I hope I have been able to give you some clarity.
Thanks and Regards,
Emil
No comments:
Post a Comment