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)- 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
- 10:52, 9 October 2022 Salkin talk contribs created page Software Description (Created page with "== Introduction == We provide a software package to simplify building up a database, browsing through data and exporting specific parts of the database in one of the supported file formats. To install our software refer to the Get Started page. == Software Components == === MySQL Server Community Edition === MySQL is an open-source relational database managment system.<ref>https://en.wikipedia.org/wiki/MySQL</ref> === phpMyAdmin === PhpMyAdmin is one of the...")
- 10:42, 9 October 2022 Salkin talk contribs created page D references (Redirected page to Reference Table) Tag: New redirect
- 16:25, 8 October 2022 Salkin talk contribs created page Deserialize Raw Data (Created page with "== Theory == The raw data field is a stream of 60 little endian IEEE 754 floats, so it has exactly 240 bytes. The first 4 bytes represent the first minute of the hour and so on. Note that 0x000000 is defined to be NULL (no value). == C# example == public static float?[] GetRawValues(byte[] data) { var elements = data.Length / 4; byte[] buf = new byte[4]; float?[] ret = new float?[elements]; for(int i = 0...")
- 16:14, 8 October 2022 Salkin talk contribs created page Data float h (Redirected page to Float Data Hourly) Tag: New redirect