Solved

# Data Comparison

Posted on 2014-12-13
67 Views
Hi,
I having to write a web application which compares different values (e.g. prices) over a period of time in real time. This includes values from different companies. I'm looking at the best approach. This will mean comparing 1m records and trying to get quick results from the comparison (e.g. within 30-60 seconds). Any advice on the best approach?
The initial plan was to use MS SQL server.
0
Question by:fred2k3
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 4
• 3
• 2
• +1

LVL 27

Expert Comment

ID: 40497900
Compare how? Within the same table or different tables? Prices of what? You should compare apples with apples. More information please.
0

Author Comment

ID: 40497940
Comparing data from the same table. For example prices from different suppliers.
0

LVL 27

Expert Comment

ID: 40497943
Some sample data would help with some example of what you need to achieve.
0

LVL 50

Expert Comment

ID: 40499923
Would be good and easier for us if you could post some sample data and also the data model as well.
0

Author Comment

ID: 40500690
sorry i dont have sample data - its only a theory exercise at the minute to find the best way.
The comparison would be like to like, so it would be comparing prices between different prices.
0

LVL 50

Expert Comment

ID: 40500715
How do you want to compare the prices?
The cheapest? The expensive? Against average of the product? Or the family product?
And what should be returned?
A Boolean? The price position (Top position)? In ascending or descending order? All product row?
0

Author Comment

ID: 40501332
Thanks Vitor, my question is more about comparing data on mass. An example is comparing 100K items from different suppliers to see which is the best overall supplier. But the calculations need to happen as quickly as possible - hence i'm trying to see what would give the best result
0

LVL 50

Expert Comment

ID: 40504721
Still very generic. I would suggest you to work on it, even with sample data and as soon you have something more concrete you can post here so we can help you.
0

LVL 32

Accepted Solution

awking00 earned 500 total points
ID: 40534039
You might try simplifying the task of supplying sample data with say 10 items and 4 suppliers. Not all suppliers carry all 10 items (maybe none of them). The price comparisons are easy (either greater than, less than, or equal) but the analysis might not be. A slight difference in price might be offset by other factors (e.g. one supplier's payment requirements may be on delivery while another is payment in 30 days), so criteria for determining the "best" supplier would have to spelled out. Additionally, the database performance will largely depend on issues like capacity, statistics analysis, proper indexing, etc. Furthermore, the performance might be better managed by some sort of Java application or GUI rather than the underlying database.
0

Author Closing Comment

ID: 40644737
Didnt fully address the question - this was relatively the closest answer when compared to the others.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
###### Suggested Courses
Course of the Month4 days, 1 hour left to enroll