We are looking for consultation with someone with expertise in planning/architecting a database for a specific use case.
We are working on a project where were trying to build a complex question and answer engine.
The format of questions and corresponding answers can be various. For example, it can be a set of multiple choice question, or it can be an input(text or other) from the user.
The next question can be branched depending upon the user response in the current question(and/or) a set of previousresponses.
The challenge is to store the logic for this complex branching, the set of previous responses the next question depends upon. We are trying to plan out an appropriate database design for the same.
Currently , we have chosen SQL as the database and using the ER-model to design the database. However, storing the complex logic for the branching of questions is becoming very complex. This made me question the whole approach.
We have given a thought about using NoSQL databases. However, we have to make complex analysis fro the data for which SQL seems to be the better alternative.
Is SQL the right choice for such a scenario. Is ER-model the right way to do it. If yes, then what factors should we keep in mind while implementing it so as to ensure integrity, consistency, and low latency for queries. How can we optimize the complex queries for such scenarios? What server configuration would be the most suitable one for the same.
If not, then what would be the best approach for this scenario. Are there already existing open source question and answer engines available which can be used?
If you think, you have a solution for a good architecture, we can get in touch.","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":350429},"skills":["software development"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2024-09-10T20:54:31+05:30","url":"https://www.toogit.com/freelance-jobs/MzUwNDI5"}
Remote Network And System Administration Job In IT And Networking
Find more Network And System Administration remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekHourly Type
Remote Job$26.83
Cost Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions
Looking for someone to setup our build server.
Ideally using: TeamCity
However, open to other options like Bamboo.
We plan to deploy a .Net Core + Angular JS app to a Linux server on AWS.
We would want roll-back support...read more
We have a website in French that we had translated in English with WPML. All the content is perfectly translated and in place. We just have a problem having the same header as the french version. We have the right settings in our page header option...read more
We are looking for a PHP developer with experience using Codeception for a European Startup. The source code is in PHP with no-framework, but organised cleanly as components.
The right candidate will:
- Create Acceptance Tests for...read more
Hello,
Idea: I represent a group of old gamers seeking to hire a programmer so he/she can create a program that could do a few things:
1. A global installer from which you could install a platform allowing you to download and i...read more
We are looking for experienced consultants:
1. Who have experience using the GP extended pack to implement project accounting and project costing modules.
2. Who can help with upgrade from 16R to 18R