I’m not aware of any work or even sci-fi that addresses AGI with regards to this question, and would be curious if there’s stuff out there?
Anyways, with some naive googling I found these references which seem interesting with regards to lineage and causality (for the query "lineage causal database schema"):
[0] Causality and Explanations in Databases. The "Related topics in Databases" section seems interesting.
[1] Duke's 'Understanding Data: Theory and Applications, Lecture 16: Causality in Databases' (by one of [0]'s authors).
[2] Quantifying Causal Effects on Query Answering in Databases. This has some interesting definitions.
[3] Causality in Databases. Seems like a more in depth version of [0].
[4] A whole course on "Provenance and lineage"
[5] Causality and the Semantics of Provenance. Defines "provenance graphs" and some properties.
-----------
[0] http://www.vldb.org/pvldb/vol7/p1715-meliou.pdf
[1] https://www2.cs.duke.edu/courses/fall15/compsci590.6/Lecture...
[2] https://www.usenix.org/sites/default/files/conference/protec...
[3] https://www.cs.cornell.edu/home/halpern/papers/DE_Bulletin20...
However, with a more general AI, we would be able to tell it "this is where and how the data were collected" and it could make the necessary inferences. Fully general AI would also be able to ask the right questions and make reasonable guesses on its own. Everything you do now, and nothing like anything that's been developed.
To me the weak point of this article isn't in the thesis (of course everyone can agree that general intelligence is more useful than narrow, all else being equal) but that there was nothing said about how to get there. The only reason ML is currently resurgent is because it we've figured out how to do something that works, while general intelligence has proven beyond our reach for 60+ years.
Edit: actually it seems to be "classical AI" and hybrid approaches and I guess for more details one would need to read the book.
I guess articles like this are worthwhile to temper expectations of what's possible with the current crop of technologies for those not in the field, which could help prevent another winter due to overinflated expectations.
Your point about AGI which needs to ask questions about data provenance is super interesting. Are you aware of the line of inquiry into active learning? It's fascinating and has a long history: https://papers.nips.cc/paper/1011-active-learning-with-stati...
https://en.wikipedia.org/wiki/Active_learning_(machine_learn...
Or if we're talking serious AGI level, just feed it your codebase/email/slack history and have it learn all of that hidden info.
The human state of the art solution seems to be going on slack and asking questions about the data provenance, which will decidedly not work for an automated approach.
A primary reason I can do better a better job than a generic algorithm is because you told me where the data came from (or I designed the schema and ETL myself), while the algo can't make any useful assumptions because all that info is hidden.