Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server and NoSQL Expand / Collapse
Author
Message
Posted Tuesday, March 26, 2013 11:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 11:23 PM
Points: 114, Visits: 186
Hi there

I need some advice/articles to go through. We have a ecommerce website using SQL Server 2008 R2. For the searches we implement a ranking system using FullText and some other ranking criteria, for example, the amount of units that product has sold etc.

The search is working pretty well, but my manager wants to explore the use of NoSQL infrastructure to speed up our search results.

Two questions:

1. Can noSQL be completely integrated with SQL Server, so we can use the data in SQL to populate the NoSQL somehow?

2. Will we have the flexibility to modify our searches according to our specific business needs?

Any advice/articles pointing in the right direction will be appreciated.

Thanks.
Post #1435634
Posted Tuesday, March 26, 2013 11:27 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, November 21, 2014 12:57 PM
Points: 546, Visits: 1,062
The first thing you'll need to look at is which NoSQL engine you're going to use. Got any information on that?
Post #1435637
Posted Tuesday, March 26, 2013 11:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 11:23 PM
Points: 114, Visits: 186
No idea which engine yet, we are just investigating ways to improve the speed of the result set.

Anything from NoSQL to the use of CUDA programming.
Post #1435639
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse