Difference between revisions of "DROID Siegfried Sqlite Analysis Engine"

From COPTR
Jump to navigation Jump to search
(Development Activity)
(Updated summary information and introduction)
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
<!-- Use the structure provided in this template, do not change it! -->
+
{{Infobox tool
−
 
+
|purpose=Format Identification Analysis and Reporting
−
{{Infobox_tool
+
|homepage=https://github.com/exponential-decay/demystify
−
|purpose=Analysis and automatic generation of summary information from DROID output
 
−
|image=
 
−
|homepage=https://github.com/ross-spencer/droid-sqlite-analysis
 
 
|license=Open source (see URL above)
 
|license=Open source (see URL above)
 
|platforms=sqlite + Python + text/html
 
|platforms=sqlite + Python + text/html
 +
|function=Metadata Extraction, Content Profiling, De-Duplication
 
}}
 
}}
−
 
+
{{Infobox tool details}}
−
<!-- Add one ore more categories to describe the function of the tool. Choose carefully, and view the list of existing categories first (see the Navigation sidebar on the left). The following are common category examples, remove those that don't apply -->
 
−
[[Category:Metadata Extraction]]
 
−
[[Category:Content Profiling]]
 
−
[[Category:De-Duplication]]
 
−
 
 
−
<!-- Add relevant categories to describe the content type that the tool addresses. Choose carefully, and view the list of existing categories first (see the Navigation sidebar on the left). If the tool works on any content type, do not add a category. The following are common category examples, remove those that don't apply -->
 
−
 
 
 
== Description ==
 
== Description ==
 
<!-- Describe the what the tool does, focusing on it's digital preservation value. Keep it factual. -->
 
<!-- Describe the what the tool does, focusing on it's digital preservation value. Keep it factual. -->
−
Engine for analysis of [https://github.com/digital-preservation/droid DROID] CSV export files, [https://github.com/richardlehane/siegfried Siegfried] YAML export files, and Siegfried 'DROID compatible' output. The tool has three purposes, break the exports into their components and store them within a table in a SQLite database; create additional columns to augment the output where useful; and query the SQLite database, outputting results in a readable form useful for analysis by researchers and archivists within digital preservation departments in memory institutions.
+
Now known as "Demystify" with thanks to Joshua Ng for the suggestion to rename it. Demystify is an engine for the analysis of [https://github.com/digital-preservation/droid DROID] CSV export files, [https://github.com/richardlehane/siegfried Siegfried] YAML export files, and Siegfried 'DROID compatible' output. The tool has three purposes, break the exports into their components and store them within a table in a SQLite database; create additional columns to augment the output where useful; and query the SQLite database, outputting results in a readable form useful for analysis by researchers and archivists within digital preservation departments in memory institutions.
  
−
The tool provides archivist definitions for each of the sections output; these definitions are customisable. The tool also supports output of statistics about files that may require further triage or may not be appropriate for long-term preservation based on institutional rules, in the form of a blacklist. The tool also analyses file names and directory names for non-ascii characters, and also characteristics that may present problems cross-file-system based on known Microsoft rules: http://msdn.microsoft.com/en-us/library/aa365247(VS.85).aspx
+
The tool provides archivist definitions for each of the sections output; these definitions are customizable. The tool also supports output of statistics about files that may require further triage or may not be appropriate for long-term preservation based on institutional rules, in the form of a blacklist. The tool also analyses file names and directory names for non-ascii characters, and also characteristics that may present problems cross-file-system based on known Microsoft rules: http://msdn.microsoft.com/en-us/library/aa365247(VS.85).aspx
  
 
The engine can be used to generate a list of file paths for files that may present digital preservation risks (Rogues) or files which on the surface i.e. via identification alone, look okay (Heroes) and these listings can be used in conjunction with [http://manpages.ubuntu.com/manpages/trusty/man1/rsync.1.html rsync] to isolate these sets from one-another to be more flexible to work with.  
 
The engine can be used to generate a list of file paths for files that may present digital preservation risks (Rogues) or files which on the surface i.e. via identification alone, look okay (Heroes) and these listings can be used in conjunction with [http://manpages.ubuntu.com/manpages/trusty/man1/rsync.1.html rsync] to isolate these sets from one-another to be more flexible to work with.  
Line 38: Line 29:
 
=== Release Feed ===
 
=== Release Feed ===
 
Below the last 3 release feeds:
 
Below the last 3 release feeds:
−
<rss max=3>https://github.com/ross-spencer/droid-sqlite-analysis/releases.atom</rss>
+
<rss max=3>https://github.com/exponential-decay/droid-siegfried-sqlite-analysis-engine/releases.atom</rss>
 
   
 
   
 
=== Activity Feed ===
 
=== Activity Feed ===
 
Below the last 5 commits:
 
Below the last 5 commits:
−
<rss max=5>https://github.com/ross-spencer/droid-sqlite-analysis/commits/master.atom</rss>
+
<rss max=5>https://github.com/exponential-decay/demystify/commits/main.atom</rss>
 
   
 
   
 
<!-- Add the Ohloh.com ID for the tool, if known. -->
 
<!-- Add the Ohloh.com ID for the tool, if known. -->
−
{{Infobox_tool_details
 
−
|ohloh_id=
 
−
}}
 

Latest revision as of 11:54, 21 January 2022




Format Identification Analysis and Reporting
Homepage:https://github.com/exponential-decay/demystify
License:Open source (see URL above)
Platforms:sqlite + Python + text/html
Function:Metadata Extraction,Content Profiling,De-Duplication



Description

Now known as "Demystify" with thanks to Joshua Ng for the suggestion to rename it. Demystify is an engine for the analysis of DROID CSV export files, Siegfried YAML export files, and Siegfried 'DROID compatible' output. The tool has three purposes, break the exports into their components and store them within a table in a SQLite database; create additional columns to augment the output where useful; and query the SQLite database, outputting results in a readable form useful for analysis by researchers and archivists within digital preservation departments in memory institutions.

The tool provides archivist definitions for each of the sections output; these definitions are customizable. The tool also supports output of statistics about files that may require further triage or may not be appropriate for long-term preservation based on institutional rules, in the form of a blacklist. The tool also analyses file names and directory names for non-ascii characters, and also characteristics that may present problems cross-file-system based on known Microsoft rules: http://msdn.microsoft.com/en-us/library/aa365247(VS.85).aspx

The engine can be used to generate a list of file paths for files that may present digital preservation risks (Rogues) or files which on the surface i.e. via identification alone, look okay (Heroes) and these listings can be used in conjunction with rsync to isolate these sets from one-another to be more flexible to work with.

User Experiences

Development Activity

All development activity is visible on GitHub: http://github.com/ross-spencer/droid-sqlite-analysis/commits

Release Feed

Below the last 3 release feeds:

2025-12-17 20:32:22
[tag:github.com,2008:Repository/15066530/3.0.0-rc.4 3.0.0-rc.4]
by ross-spencer
2025-12-17 19:43:13
[tag:github.com,2008:Repository/15066530/3.0.0-rc.3 3.0.0-rc.3]
by ross-spencer
2025-12-17 19:39:38
[tag:github.com,2008:Repository/15066530/2.1.0 2.1.0]
by ross-spencer

Activity Feed

Below the last 5 commits:

2025-12-17 19:30:15
[tag:github.com,2008:Grit::Commit/5808ca753a2b6cd504b54469b89583ba4dfaa9da Correct rogues logic]
by ross-spencer https://github.com/ross-spencer
2025-12-17 18:30:26
[tag:github.com,2008:Grit::Commit/fa99f8ef0f2e629d104e6568eb4944f3e9165b82 Remove lxml]
by ross-spencer https://github.com/ross-spencer
2025-12-17 18:29:56
[tag:github.com,2008:Grit::Commit/39287330b07ba573d6d94ace7f052f4e0b825d5d Revert "Update sqlitefid and pathlesstaken"]
by ross-spencer https://github.com/ross-spencer
2025-12-17 18:29:29
[tag:github.com,2008:Grit::Commit/fb2f415b0109d5a4165592ce2eccd656357aae73 Revert sqlitefid and pathlesstaken]
by ross-spencer https://github.com/ross-spencer
2025-12-17 18:18:51
[tag:github.com,2008:Grit::Commit/34b2f119a2eb11337d0bab54581069f70095838e Update workflow]
by ross-spencer https://github.com/ross-spencer


Retrieved from ‘https://coptr.digipres.org/index.php?title=DROID_Siegfried_Sqlite_Analysis_Engine&oldid=5566’