Database Architect or Solution Architect required for consultation to plan and architect a database

Posted by - Satyajit Debnat at Jul 21, 2021
Mpumalanga, South Africa

BudgetTypeStatusValid Through
$21.84HOURLYOpenAug 11, 2021

Job Description

Hi,
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 we're 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.

Skills & Expertise Required

software development 

Offer to work on this project closes in 11 days!

Try more jobs by Satyajit Debnat

Scheduling app for upstart spa franchise - Hourly
installation of YetiForce on a Centos 7 VPS (VH) - Hourly
Senior Vue Js Developer - Hourly
Looking for a person who could set up Zendesk - Fixed
Web Design and Development; eCommerce for a 4-wheeler ATV/UTV business - Fixed
Editing for New Fitness Podcast- Ongoing Potential - Hourly
Need someone to migrate my site to a new server - Fixed
Automations ( Robotic process automation (RPA) software) - Hourly
Blogger in Las vegas to spread the word about Hawlit the peer to pickup truck sharing site - Hourly
Scheduling app for upstart spa franchise - Hourly
Data Scientist needed to create algorithm to assist with question recall prediction - Hourly
SEO Audit Backlinks & SMM Marketing - Hourly
Categorization and Product Labeling - Hourly
Skilled Photo Editor Needed - Exposure Blending, Object Removals, Etc. - Fixed
PHP Image Submit System, Using Ajax, JQuery, Bootstrap - Fixed
Customer Service Representative - Hourly
Senior React.js Developer w/ TypeScript experience - Fixed
Setting up of an AWS CI CD environment - Hourly
Need developer to connect Angular frontend template to our organization's Firebase backend - Fixed
Skilled Photo Editor Needed - Exposure Blending, Object Removals, Etc. - Fixed
PHP Image Submit System, Using Ajax, JQuery, Bootstrap - Fixed
Senior React.js Developer w/ TypeScript experience - Fixed
Setting up of an AWS CI CD environment - Hourly

Similar Projects

I need help removing iCloud activat...

I need help removing iCloud activation lock from an IPhone 7 plus..... The iPhone is on lost mode....
Fixed, $311.95

Help setting up Linux SFTP server

I need help setting up a linux SFTP server on Centos 7. I need to set this up today as soon as possible
Hourly, $12.48

IRC chat over the Tor network using...

I need help setting up Tor over the Irc protocol on my windows virtual machine and also on whonix virtual machines. This should be a very simple and easy task for an experienced programer.
Hourly, $10.14

Satyajit Debnat hiring software development experts from & nearby:

  • Afghanistan
  • Albania
  • Algeria
  • American Samoa
  • Andorra
  • Angola
  • Anguilla
  • Antarctica
  • Antiguaand Barbuda
  • Argentina
  • Armenia
  • Aruba
  • Australia
  • Austria
  • Azerbaijan
  • Bahamas
  • Bahrain
  • Bangladesh
  • Barbados
  • Belarus
  • Belgium
  • Belize
  • Benin
  • Bermuda
  • Bhutan
  • Bolivia
  • Bosniaand Herzegovina
  • Botswana
  • Bouvet Island
  • Brazil
  • British Indian Ocean Territory
  • Brunei
  • Bulgaria
  • Burkina Faso
  • Burundi
  • Cambodia
  • Cameroon
  • Canada
  • Cape Verde
  • Cayman Islands
  • Central African Republic
  • Chad
  • Chile
  • China
  • Christmas Island
  • Cocos Islands
  • Colombia
  • Comoros
  • Republic of the Congo
  • Democratic Republicof the Congo
  • Cook Islands
  • Costa Rica
  • Ivory Coast
  • Croatia
  • Cuba
  • Cyprus
  • Czech Republic
  • Denmark
  • Djibouti
  • Dominica
  • Dominican Republic
  • EastTimor
  • Ecuador
  • Egypt
  • El Salvador
  • Equatorial Guinea
  • Eritrea
  • Estonia
  • Ethiopia
  • External Territories of Australia
  • Falkland Islands
  • Faroe Islands
  • Fiji
  • Finland
  • France
  • French Guiana
  • French Polynesia
  • French Southern Territories
  • Gabon
  • Gambia
  • Georgia
  • Germany
  • Ghana
  • Gibraltar
  • Greece
  • Greenland
  • Grenada
  • Guadeloupe
  • Guam
  • Guatemala
  • Guernseyand Alderney
  • Guinea
  • Guinea-Bissau
  • Guyana
  • Haiti
  • Heard Islandand McDonald Islands
  • Honduras
  • HongKong
  • Hungary
  • Iceland
  • India
  • Indonesia
  • Iran
  • Iraq
  • Ireland
  • Israel
  • Italy
  • Jamaica
  • Japan
  • Jersey
  • Jordan
  • Kazakhstan
  • Kenya
  • Kiribati
  • North Korea
  • South Korea
  • Kuwait
  • Kyrgyzstan
  • Laos
  • Latvia
  • Lebanon
  • Lesotho
  • Liberia
  • Libya
  • Liechtenstein
  • Lithuania
  • Luxembourg
  • Macao
  • Macedonia
  • Madagascar
  • Malawi
  • Malaysia
  • Maldives
  • Mali
  • Malta
  • Man(Isleof)
  • Marshall Islands
  • Martinique
  • Mauritania
  • Mauritius
  • Mayotte
  • Mexico
  • Micronesia
  • Moldova
  • Monaco
  • Mongolia
  • Montserrat
  • Morocco
  • Mozambique
  • Myanmar
  • Namibia
  • Nauru
  • Nepal
  • Netherlands Antilles
  • Netherlands
  • New Caledonia
  • New Zealand
  • Nicaragua
  • Niger
  • Nigeria
  • Niue
  • Norfolk Island
  • Northern Mariana Islands
  • Norway
  • Oman
  • Pakistan
  • Palau
  • Palestinian Territory
  • Panama
  • Papua New Guinea
  • Paraguay
  • Peru
  • Philippines
  • Pitcairn
  • Poland
  • Portugal
  • Puerto Rico
  • Qatar
  • Reunion
  • Romania
  • Russia
  • Rwanda
  • Saint Helena
  • Saint Kittsand Nevis
  • Saint Lucia
  • Saint Pierreand Miquelon
  • Saint Vincentandthe Grenadines
  • Samoa
  • San Marino
  • Sao Tomeand Principe
  • Saudi Arabia
  • Senegal
  • Serbia
  • Seychelles
  • SierraLeone
  • Singapore
  • Slovakia
  • Slovenia
  • Smaller Territories of the UK
  • Solomon Islands
  • Somalia
  • South Africa
  • South Georgia and the South Sandwich Islands
  • South Sudan
  • Spain
  • Sri Lanka
  • Sudan
  • Suriname
  • Svalbardand Jan Mayen
  • Swaziland
  • Sweden
  • Switzerland
  • Syria
  • Taiwan
  • Tajikistan
  • Tanzania
  • Thailand
  • Togo
  • Tokelau
  • Tonga
  • Trinidadand Tobago
  • Tunisia
  • Turkey
  • Turkmenistan
  • Turksand Caicos Islands
  • Tuvalu
  • Uganda
  • Ukraine
  • United Arab Emirates
  • United Kingdom
  • United States
  • United States Minor Outlying Islands
  • Uruguay
  • Uzbekistan
  • Vanuatu
  • Vatican
  • Venezuela
  • Vietnam
  • British Virgin Islands
  • U.S.Virgin Islands
  • Wallis and Futuna
  • Western Sahara
  • Yemen
  • Yugoslavia
  • Zambia
  • Zimbabwe
  • Aland Islands
  • Saint Barthélemy
  • Bonaire, Saint Eustatiusand Saba
  • Curaçao
  • Guernsey
  • Isleof Man
  • Jersey
  • Montenegro
  • Saint Martin
  • Sint Maarten
  • East Timor
  • Kosovo