Timeline for Which is best software design for heavy query based app
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 16, 2018 at 13:47 | comment | added | X.Otano | you are right, best name is a is a "pricing engine" If you give me an answer explaining which approach you will take (software desing, where to put the workers, etc) in that pricing engine i will give you "correct answer" many thanks dude | |
| May 16, 2018 at 13:36 | comment | added | X.Otano | Can you give more light over it? What do you mean by worker jobs? | |
| May 16, 2018 at 13:36 | comment | added | Ewan | sounds like a pricing engine. can be pretty heavy work, if you need to work out combination discounts on 1000s of items. not datawarehouse or sql you need to split it into worker jobs | |
| May 16, 2018 at 13:28 | comment | added | X.Otano | each car is composed by thousands of pieces. Each piece is involved in some kind of processes which applies disccounts. All the info is stored in the database. Imagine : piece XXX01 have a disccount because there is an active promotion with the provider until 30-may-2018. Maybe the queries are not as heavy as you are thinking. Just thousands of records should be considered. When yopu are composing the car you will get a graph and a grid with the data of your Car, disccounts applied. logistic cost, etc | |
| May 16, 2018 at 13:27 | comment | added | Ewan | if im buying a car and selecting upgrades, say "alloy wheels" then that's a price not a budget, how does it fit with "performing heavy queries generating , graphs and grid-tables to show the information" | |
| May 16, 2018 at 13:25 | comment | added | X.Otano | No, we want the budget to be generated for a new car driver with the actual data (not historical, or reports, just the active data today) . Reporting is another piece of the app. But main work will be to analize and provide an instant budget | |
| May 16, 2018 at 13:22 | comment | added | Ewan | if you mean "the average cost of cars by model calculated by summing the part cost from various suppliers, broken down per month" then yes definitely | |
| May 16, 2018 at 13:22 | comment | added | X.Otano | yes , you are right with the meaning of budget | |
| May 16, 2018 at 13:21 | comment | added | Ewan | hmm it could do "budget" is an odd word to use if you mean "the cost of a single car assembled from these parts" | |
| May 16, 2018 at 12:50 | comment | added | X.Otano | the database is not only for reporting. As an example: the database will store wich pieces compose a CAR . Each model of car will have their own set of pieces, each one with its price, provider, etc etc. We want to query that data for generating budgets with one click. The budgets should query price of each item, also apply some disccounts based on some calculations of other facts like driver experience, accidents, relations with providers etc (huge etc). Do you think that fits a data wharehouse? | |
| May 16, 2018 at 12:33 | history | answered | Ewan | CC BY-SA 4.0 |