All public logs
Jump to navigation
Jump to search
Combined display of all available logs of SICDB Doc. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).
(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)- 19:37, 31 October 2022 Salkin talk contribs created page Introduction (Created page with "The SICdb dataset provides insight to over 27 thousand intensive care admissions, including therapy and data of their preceding surgery. Data was collected between 2013 and 2021 from 4 of the intensive care units at the University Hospital Salzburg, having more than 3 thousand intensive care admissions per year on 37 beds. The dataset is deidentified and contains, amongst others, case information, laboratory, medication, monitor and respirator signal data.SICdb provides...")
- 19:33, 31 October 2022 Salkin talk contribs moved page File Encoding to File Description
- 19:31, 31 October 2022 Salkin talk contribs created page File Encoding (Created page with "All data files in the SICdb dataset are provided as comma seperated files (.csv) using the RFC 4180 standard. Additionally all files are compressed with gzip, an commonly used openly available compression method.")
- 18:56, 31 October 2022 Salkin talk contribs created page Data Description References (Created page with "== Data Description of references.csv.gz == The d_references table contains information on all encoded data fields of the SICDB dataset. To simplify JOIN and other types of subqueries each reference value has an unique global identifier. {| class="wikitable" |+ Caption d_references |- ! Name !! Description !! Comment |- | ReferenceGlobalID || The unique ID for the reference || Use this identifier as dictionary for alle encoded fields |- | ReferenceValue || Reference...")
- 18:47, 31 October 2022 Salkin talk contribs created page Data Description Cases (Created page with "== Data Description of cases.csv.gz === === Raw Fields === {| class="wikitable" |+ Caption text |- ! Name !! Description !! Comment |- | CaseID || A randomly assigned identifier || CaseID is unique to each admission. |- | PatientID || A randomly assigned identifier || PatientID is unique to each Patient, useful to identify readmission |- | AdmissionYear || Year of admission || |- | TimeOfStay || Time of stay || Time from primary metavision admission, to last dischar...")
- 18:39, 31 October 2022 Salkin talk contribs created page SingleFileDocumentation (Created page with "== List of files == {{:Case Data:Raw Fields}} {{:Float Data Hourly}}")
- 18:59, 10 October 2022 Salkin talk contribs created page Treatment Data (Created page with "== Raw Fields == {| class="wikitable" |+ Caption treatment |- ! Name !! Description !! Comment |- | id || Primary Key || |- | CaseID || || |- | TreatmentID || Refer to d_references for value (d_reference.ReferenceGlobalID = Treatment.TreatmentID || |- | Offset || Time in seconds from admission || |- | OffsetEnd || Time in seconds from admission, end of treatment || |}")
- 14:58, 10 October 2022 Salkin talk contribs created page Data ref (Created page with "==Table Description== The data_ref table contains one-per-case referenced data. == Predefined Fields (RooDataServer) == {| class="wikitable" |+ Fields |- ! Name !! Description !! Comment !! Type |- | PremedicationBetablocker || Yes/No || || |- | PremedicationACEInhibitor || Yes/No || || |- | PremedicationStatin || Yes/No || || |- | PremedicationDiuretic || Yes/No || || |- | PreconditionDiabetes || Any type of diabetes (IDDM or NIDDM) || || |- | Preconditi...")
- 14:36, 10 October 2022 Salkin talk contribs created page File:RooDataServer Statistics.png
- 14:36, 10 October 2022 Salkin talk contribs uploaded File:RooDataServer Statistics.png
- 14:35, 10 October 2022 Salkin talk contribs deleted page File:RooDataServerStatistics.png
- 14:34, 10 October 2022 Salkin talk contribs created page RooDataServer (Created page with "== Introduction == RooDataServer is part of the SICdb software package. It is used to build up the database from .csv files, view and browse the data and export == Import == After installing and starting the environment open http://localhost:5000 in your browser. Follow the instructions for installing the dataset. The import may take several hours and can be interrupted. == Query and Export == The Query Manager is used to create extended queries using predefined fie...")
- 14:31, 10 October 2022 Salkin talk contribs deleted page RooDataServer Statistics (content was: "== Introduction == RooDataServer has an extendable quick statistics system. These statistics are just for quick data analysis and must be recalculated by any validated statistics software. thumb", and the only contributor was "Salkin" (talk))
- 14:29, 10 October 2022 Salkin talk contribs created page RooDataServer Statistics (Created page with "== Introduction == RooDataServer has an extendable quick statistics system. These statistics are just for quick data analysis and must be recalculated by any validated statistics software. thumb")
- 14:29, 10 October 2022 Salkin talk contribs uploaded File:RooDataServerStatistics.png
- 14:29, 10 October 2022 Salkin talk contribs created page File:RooDataServerStatistics.png
- 12:02, 9 October 2022 Salkin talk contribs created page Unitlog (Created page with "==Table Description== The d_unitlog table contains information of patient transportation. == Raw Fields == {| class="wikitable" |+ Caption unitlog |- ! Name !! Description !! Comment |- | id || Primary Key || |- | CaseID || || |- | PatientID|| || |- | LogState || Internal raw Metavision value || |- | Offset || Time in seconds after admission || |- | HospitalUnit || Encoded unit value, unitlog.HospitalUnit = d_references.ReferenceGlobalID || i.e. C) |}")
- 11:43, 9 October 2022 Salkin talk contribs deleted page SICdb Environment (content was: "== Introduction == Working with medium sized datasets like SICdb may present a challenge to work with. While it is still possible to access using standard consumer hardware, not all applications are able to load, view, and filter data this size. At more than a billion data entries not even Spreadsheet software like Microsoft Excel will crumble, even importing into a mysql databa...", and the only contributor was "Salkin" (talk))
- 11:33, 9 October 2022 Salkin talk contribs uploaded File:ReferenceSelection.jpg
- 11:33, 9 October 2022 Salkin talk contribs created page File:ReferenceSelection.jpg