2
We have setup Microsofts product line for our clients to replace Access. You could either utilize sharepoint, or a better option visually, the Common Data Service. It is not too expensive depending on how many users you have. I believe $35/m for one user to set up everything, and then at least $4 for each user that needs access to this data to make edits.
...
2
It's expensive, but a custom web application with a robust database backend may be what you need to meet your fairly specific needs, as well as the scale of your data. The Access database could be migrated to SQL Server using SQL Server Migration Assistant for Access and the business logic would have to be replicated in a web app (the obvious choice being a ....
1
So, assuming such a software doesn't exist (which I am not sure of, spark users may come from SQL and have had such requirements before). What I think would need to be done if one were to write one:
parse the SQL. In a way that gives you a sensible model you can work with. Here is a question where exactly this is asked. https://stackoverflow.com/questions/...
1
Try DynamoDB if you can pay for it. Yes, it doesn't match with your open-source requirement, but it does it all.
but it's semi-structured dynamically-changing data
ideal use-case for DynamoDB
As the table is not aimed to grow infinitely, each table could be stored in a JSON document using an array of arrays.
Dynamo tables are sets of key-value and can be ...
Only top voted, non community-wiki answers of a minimum length are eligible
