71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
the Fossil implementation is enhanced, and the content is recomputed from
the unchanging bag of artifacts. The local relational database is an
implementation detail which currently happens to use SQLite.
Another way to think of the relational tables in a Fossil repository is
as an index for the artifacts. Without the relational tables,
to generate a report like a timeline would require scanning every artifact -
the equivalent of a full table scan. The relational tables hold pointers
the relevant artifacts in presorted order so that generating a timeline
is much more efficient. So like an index in a relational database, the
relational tables in an Fossil repository do not add any new information,
they merely make the information in the artifacts faster and easier to
look up.
Fossil is not "based" on SQLite. Fossil simply exploits SQLite as
a powerful tool to make the implementation easier.
And Fossil doesn't use a distributed
NoSQL database because Fossil is a distributed NoSQL database. That answers
|
|
|
|
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
the Fossil implementation is enhanced, and the content is recomputed from
the unchanging bag of artifacts. The local relational database is an
implementation detail which currently happens to use SQLite.
Another way to think of the relational tables in a Fossil repository is
as an index for the artifacts. Without the relational tables,
to generate a report like a timeline would require scanning every artifact -
the equivalent of a full table scan. The relational tables hold pointers to
the relevant artifacts in presorted order so that generating a timeline
is much more efficient. So like an index in a relational database, the
relational tables in a Fossil repository do not add any new information,
they merely make the information in the artifacts faster and easier to
look up.
Fossil is not "based" on SQLite. Fossil simply exploits SQLite as
a powerful tool to make the implementation easier.
And Fossil doesn't use a distributed
NoSQL database because Fossil is a distributed NoSQL database. That answers
|