Page 13 of 76. Showing 757 results (0.011 seconds)
AUG Email 2011-Feb
in the query speed. We have reindexed and re-analyzed without much effect on speed. One thing we are looking at is the fact that our observation fact table … and thin client plug ins Thanks for these suggestions. Recreating the table with fewer numbers of larger extents turned out not to be helpful. Our BlockAUG Email 2011-Aug
version there shouldn't be? In the particular when were statistics gathered on the observation fact table? Maybe they are stale? From: Lisa Miao … ] Sent: Tuesday, August 30, 2011 11:34 AM To: Lisa Miao Cc: I2B2 AUG Members Subject: RE: index hint on the observation_fact table Hi, Ughh. I thoughtNLP cTakes Home
and i2b2 by formatting the output of cTAKES into the i2b2 observation_fact table format (facts, concepts, modifiers, and values) which can then be easily … is commonly stored as a single row in the observation_blob field in the observation_fact table in i2b2. One of NLP cTAKES' features is its capability to 'readAUG Email 2010_Jan-Jun
column, which is able to separate various facts into clusters that allow several modifiers to be attached to the same fact. The modifier table in the ontology cell … the text value or number value columns in the observation fact, in i2b2metadata.i2b2 (the metadata table), info needs to be added informationPatient Set Query Use Case Scenarios
, CONCEPT_CD, START_DATE, PROVIDER_ID, and INSTANCE_NUM value in the fact table. | specificity_scale Not implemented panel The panel … query by not using the temp table. As a default it is advisable to set the flag <query_mode> optimize_without_temp_table</query_mode> in the <psmheader>. To speedSearch Patient and Medication Info
and AND a frequency of once a day entered as a fact in the observation_fact table Where the medication dose and frequency have the same encounter_num , concept_cdAUG Email 2012-Apr
rows in fact table and the performance is acceptable. We have tuned our database for memory and have made some changes in the query that gets executed when you … a key record from the PM_PROJECT_USER_ROLES table. I see he gave you the same advice to insert a record into that table, though that table may have already hadDesign_and_Architecture.doc
table format (facts, concepts, modifiers, and values) which can then be easily queried by existing i2b2 interfaces. There will be 2 main components … Document Version:1.0I2b2 Software Release:1.6 Table of Contents TOC \o "1-4" \h \z \u HYPERLINK \l "_Toc322434466" Document Management1.6.04 Release Notes
, there is a listing of visits that are tied to patients and facts in the observation_fact table through the encounter_num column. Both the temporal (query) and panel … than 500 mg and a frequency of once a day entered as a fact in the observation_fact table, where the medication dose and frequency have the same patient_num1.6.03 Release Notes
by visit. In the visit table of the data repository, there is a listing of visits that are tied to patients and facts in the observation_fact table through … : there are 47 patients who have had a medication with a dose greater than 500 mg and a frequency of once a day entered as a fact in the observation_fact table, where