K9db
K9db copied to clipboard
MySQL-compatible database for GDPR compliance by construction.
- [ ] Enforce UNIQUE on INSERT - [ ] Enforce UNIQUE, PK, and AUTO_INCREMENT on UPDATE
We cannot guarantee that a UNION operator will respect the key of either input, e.g. a diamond flow may produce the same record with the same key twice, once from...
`PaperConflict` encodes relationships between `contactInfo` and `paperId` based on the value of `conflictType` (e.g. co-author or institutional relationship). The data ownership/accessorship pattern may vary depending on this relationship. For instance,...
Currently, if a record is owned via multiple paths, all anonymizations that are relevant to each of the paths are applied to the record. This could lead to having overly...
Encountered in the sample application schema for Mouthful located in `experiments/schema-annot/annotated/mouthful-annotated.sql` K9db cannot accurately capture the `Author` column in the `Comment` table which refers to a data subject that owns...
Encountered in the sample application schema for commento located in `experiments/schema-annot/annotated/commento-annotated.sql` In the table `comments` we would like to have a self referencing foreign key on the column `parentHex` with...
- [ ] Dataflow parallelism may be superflous - [ ] Improve locks: a flow-wide lock for writers only, a reader-writer lock for matview - [ ] Fork Rocksdb and...
Example: ``` CREATE DATA_SUBJECT TABLE t1(ID INT PRIMARY KEY); CREATE TABLE t4(ID INT PRIMARY KEY); CREATE TABLE t3(ID INT PRIMARY KEY, fkk int OWNS t4(ID)); CREATE TABLE t2(ID INT PRIMARY...
- [ ] Merge/adapt Mithi's changes on `default-values` branch - [ ] Ensure values make it to dataflow - [ ] Ensure values are consistent when data is shared (same...
Pelton currently doesn't support the creation of Primary keys involving multiple table columns. This can be necessary in some tables as some combination of columns might be required for the...