UTHSCSA STAR: ETL progress on stage1 for sprint05

Added by Angela Bos 1 day ago

stage1 ETL is running...

[bos@deb-mi-staging sprint05]$ ps -ef | grep heron
bos      26521 10372  0 12:51 pts/0    00:00:00 /usr/bin/python /home/bos/local/bin/paver config=heron_PROD.ini heron_load

UTHSCSA STAR: ETL progress on stage1 for sprint05

Added by Angela Bos 2 days ago

table spaces verified:
  • enc_data
  • temp0
  • bheron_indexes
synonyms verified:
  • clarity.*
schemas/data loaded:
  • i2b2metadata2
      -- user copied from stage pdb
      grant unlimited tablespace to i2b2metadata2;
      -- then run i2b2metadata2.sql
  • UMLS
      TEMPORARY TABLESPACE "TEMP0"; -- <<<<<<<<< TEMP0=stage0/1, TEMP=test/stageb
      -- then follow instructions here to load data:
  • RxNorm
      TEMPORARY TABLESPACE "TEMP0"; -- <<<<<<<<< TEMP0=stage0/1, TEMP=test/stageb
      -- then follow instructions here to load data:
  • ETL
    create user etl identified by "XXXXX" 
    default tablespace "ENC_DATA" 
    temporary tablespace "TEMP0"  -- <<<<<<<<< TEMP0=stage0/1, TEMP=test/stageb
    account unlock ; 
    grant resource, connect, dba to etl;
keyring passwords stored for oracle users:
  • stage1/etl
  • stage1/clarity
    [bos@deb-mi-staging heron_load]$ keyring set oracle://localhost/stage1.mi etl
    Password for 'etl' in 'oracle://localhost/stage1.mi':
    [bos@deb-mi-staging heron_load]$ keyring set oracle://localhost/stage1.mi clarity
    Password for 'clarity' in 'oracle://localhost/stage1.mi':

hg UTHSCSA branch is up2date, ready to run ETL

UTHSCSA STAR: Info for the data use RedCap form

Added by Alex Bokov 24 days ago

Here is a link to their RedCap data dictionary:

மின் புத்தக மாற்று செயற்திட்டம்: குழு உறுப்பினர்கள்

Added by Siva Karthikeyan Krishnan 27 days ago

இது வரை பதிமூன்று பேர் இணைந்திருக்கும் இந்த குழு சிறப்பாக செயல்பட்டுகொண்டிருக்கிறது. மேலும் நாம் அனைவரும் சந்திக்க அல்லது இணையவழி சந்திக்க முயற்சி செய்வோம். இது தவிர ஒரு நாள் பட்டறையும் நடத்தலாம். இது குறித்த விபரங்களை விவாதிக்க கருத்துக்களத்தினை (forums) உபயோகிக்கவும்.

  1. Shrinivasan
  2. Siva Karthikeyan Krishnan
  3. Anbu Jaya
  4. Arunkumar M
  5. Bharathy Sankara
  6. Chandrika D
  7. Gopi B
  8. Jeevaguru M
  9. Jophine Pranjal
  11. Rathinam Padmanaban
  12. Selvaganesan Muthusamy
  13. அருண் ப

உங்களின் பங்களிப்புக்கு நன்றி.

மின் புத்தக மாற்று செயற்திட்டம்: மின் புத்தக மாற்று செயற்த்திட்டம் - துவக்கம்

Added by Siva Karthikeyan Krishnan 29 days ago

மின் புத்தக மாற்று செயற்த்திட்டம் - மதுரை தமிழ் இலக்கிய மின்பதிப்புத் திட்டத்தின் புத்தகங்களை epub வடிவத்திற்கு மற்றும் ஒரு முயற்சியாகும். இது திரு ஸ்ரீனிவாசன் அவரது முயற்சியால் துவக்கப்பட்டது. இந்த செயற்திட்டத்தில் பலரும் பங்கு பெற அழைக்கப்படுகின்றனர்.


ZŠ horná dolná 1. A: Novy dokument

Added by Lukas Kekely about 1 month ago

Pribudol novy dolezity dokument

Website da ProfessionalIT: Lançamento do Projeto do novo website da ProfessionalIT.

Added by Leandro Severino about 1 month ago

Re-estruturação do novo site da empresa ProfessionalIT - Soluções em Tecnologia Ltda.

UTHSCSA STAR: Finally some progress or R Data Builder

Added by Alex Bokov 3 months ago

I managed to install the crcbroker R package and get the Data Builder for RStudio to show up on an I2B2 VMWare image. Now all I have to do is figure out where to deploy the python files that come with it.

This ate up most of my leave today, but it was almost worth it.

Real analytics on I2B2 data, here we come.

UTHSCSA STAR: GPC/PCORI Milestones (18 comments)

Added by Alex Bokov 3 months ago

Many if not most of the technical milestones can be expressed as queries. Here is a transcript of a conversation I had with Dan C on where to find the queries that have been written so far. I'm posting this here as a raw note to myself or to whomever I ask to follow these up and turn them into a proper Wiki page, probably on the GPC wiki.

(11:22:37 AM) DanC: bokov_UTHSCSA, there's been significant email discussion of these SQL queries and such. Let's see if I can nominate a few messages...
(11:23:17 AM) bokov_UTHSCSA: If you just point me toward the right thread/s, I'll dig through them.
(11:23:35 AM) bokov_UTHSCSA: Or, if that takes you more than a few seconds, please disregard-- it's my job to RTFM anyway.
(11:40:00 AM) bokov_UTHSCSA: After I dig up all current and relevant (to milestone deliverables) SQL files, any objection to me putting it on a separate wiki page (stuff that you currently should be able to run at your site).
(12:00:08 PM) DanC: I nominate Nathan's review
(12:00:19 PM) DanC: perhaps the archive mangles it a bit...
(12:00:19 PM) DanC: Feedback on GPC ticket 114 (Milestone 2.7)
(12:00:19 PM) DanC: Nathan Graham ngraham at
(12:00:19 PM) DanC: Mon Apr 28 17:19:22 CDT 2014
(12:00:29 PM) DanC: so you might want to look at it from your mailer
(12:01:14 PM) DanC: and my comment on his proposal Tue May 27 10:21:49 CDT 2014
(12:01:54 PM) DanC: in retrospect, I wish I had just said "would you please add i2b2 queries", since he seems OK to do that. Maybe I did say that... but I buried it under lots of confrontational stuff
(12:02:18 PM) DanC: reeder chimes in to support my position
(12:03:02 PM) DanC: ooh... nice one from Hubert that I had missed.

OndroSQL: General Availability of OndroSQL192

Added by Ondřej Krčál 3 months ago

1 2 3 ... 14 (1-10/136)

Also available in: Atom