Now here's the output of your command, which includes a lot of tables which aren't SNOMEDCT. But, by looking at the id info from my previous post you can determine which tables are associated with SNOMEDCT. I will go through the raw output myself, but wanted to share the full output first.
mysql> select TABLE_NAME,TABLE_ROWS,DATA_LENGTH from information_schema.tables where TABLE_SCHEMA='umlsinterfaceindex'; +-------------------------------------------+------------+--------------+ | TABLE_NAME | TABLE_ROWS | DATA_LENGTH | +-------------------------------------------+------------+--------------+ | a04a60a7a1215fded8733443883611035946174f0 | 121973 | 17289108 | | a04dd6e774baba1e7cc2448a61093b16b1aa55039 | 0 | 0 | | a04e9167f136dbb4c9d0d9aff6cf5de00f942b7c2 | 0 | 16384 | | a0702cbe3889f3c1508351bc7779c9deabb11c394 | 0 | 16384 | | a084422931c8a967e17d4bb845b2abe26fee8a9d8 | 0 | 16384 | | a0874a941310dd3c3ca79e2c9c8fdaaeb4cc13037 | 25292 | 429964 | | a0b07857c4f57e321feb8f475c2a4f3efd4f63538 | 0 | 0 | | a0c422d8edafeafae925736cfd9f6346615ebd73d | 0 | 0 | | a0cc2dced7768e7d0fdd515aad852d3ea6b06783b | 164807 | 24707072 | | a0ee319b0525ff96da43b0e415b0865b87d50849e | 1 | 17 | | a155d24951b08a440c964624e54dcdc157c620ec1 | 1 | 17 | | a15e208b9de1791d4b67b5dc05c82f283129fb119 | 0 | 0 | | a18d11c72da2697d9b84ba440d30371dbe06a3191 | 0 | 0 | | a1caf449e98a445ab97e97a21b20f9a0c997dd7aa | 49 | 1225 | | a1cce23a5480124f4ad9c7d6c7684e0276038c97e | 31063 | 2637824 | | a1d95f2196e40caab646d344a42ff44b9927a484d | 0 | 16384 | | a1e5f3947eee1c209fe40406390becd953ea79458 | 0 | 0 | | a210dd7f592f44f8f812802511cc4fdacf1f797b9 | 0 | 16384 | | a21efdca5f1a49b3b0cf4700e784db98437c6776b | 67483 | 7446784 | | a232248e67b9baccb46f16d6b5d4f4035ddb1be4b | 0 | 16384 | | a2bb74d8ae404472d63aad4f9ce9856fba2b5b914 | 0 | 0 | | a2c66d8a9ed71912ee4aea85685adc400e7a45c4e | 0 | 16384 | | a2e634941cbaa1937a2b4e1d29dbb94852610e3ad | 7201 | 360448 | | a2ff537b40d0d43376f2e335531bdb707d8e28096 | 12506498 | 1755399764 | | a310d815f01278f5211b138c749b8a9ea1b9c66da | 1 | 16384 | | a33581240c802f1c3ccd5f412485c578a2c621bcc | 78207 | 11026432 | | a3398f2a0ebebc7adb3d96eb11dba04c1114199e9 | 0 | 0 | | a3465d4d0b247b19d25b16fe33d3c5ffca58a8bb6 | 1 | 16384 | | a35ebdde5abec0423610ef39add03e6f739a6771f | 1 | 16384 | | a365d5c2010ae32218c1ffe296652e65817674c33 | 8 | 16384 | | a369729bcde1bf1b195bf1157d51cafe7e955d043 | 0 | 0 | | a3738b1d8c74b85b50929d746e245a945efa97126 | 0 | 0 | | a37ebfbc7d4bf0bf762abb60e820dd416201f27cf | 27 | 459 | | a395741e1cd956d2bb089108392f03240bb6f6166 | 1 | 16384 | | a3a92c2cf9c17fb71414ce0d1bd9e276187479105 | 0 | 16384 | | a3e76cd0a3a000fed8babb7ac8d71b7f2971507a0 | 0 | 0 | | a41a134ef537c21f32fd16811165f877004b8cd25 | 2 | 16384 | | a42b0a26b48eba0aa4770b16dee363d29cf132af8 | 1 | 17 | | a43a77e0c1e32ad861877f151764678ec20f57ebe | 8 | 200 | | a44fdb71b1b8467bed9c75fb2c00966f615382064 | 2 | 16384 | | a4581b1737d64638989da6e99da24455cb1d3021e | 1 | 17 | | a45ee9e30d91a6f605a607e842dd457e3867b66a4 | 1 | 17 | | a476b6c988c163f23a525d912ffc1e30d45f63194 | 0 | 16384 | | a47a8bab54633fef4fb41f8537ea96ae6674f77db | 27 | 459 | | a494252ed0bdc44c0cac223f40735da144a347be0 | 1 | 16384 | | a496f939c6d1489937fe0146669c2950ed9dd4daa | 1 | 16384 | | a4a2378c227b10de0d0b393ae9abc4371b838d03c | 0 | 0 | | a4d00525700fdfa1546506e40c3142977fb7b9ac4 | 0 | 0 | | a4d57d67339e5f6fb72048d3a1e4b6310efde69d9 | 1 | 16384 | | a4f321291c94b141722bd56a6f146401339f13c1c | 24138 | 1478428 | | a4f330bf6859d63e3a02440e6a5cf997b246e82f6 | 0 | 0 | | a4fa967dce92d4d9034e0f8b5d3a69a9a4e81e5e7 | 1 | 16384 | | a50747bfba0aa694f7f0b9ab97bc5cb24d700407f | 0 | 16384 | | a54f03554150aa93846659cd8d7a7bc0b221596a1 | 2455 | 41735 | | a5589088c133f5f16d60c2df631b5356d44cd10dc | 1 | 17 | | a587caf030ec7353a31083276537378034719df42 | 1 | 17 | | a5895f8d74938480da0ae14b9081e1f97a72b881c | 1 | 16384 | | a5978c88bd2c53f6124059543fc38ed66a11e2d0c | 1 | 17 | | a5ae59d7989f1c39bedaa0c8bb9bfd543a6153a4b | 0 | 16384 | | a5ce8cf73df2562233ad559dc34f9abcfb078a110 | 77935 | 1324895 | | a61994af45895a14eeb8f720eaba083cb9383b698 | 1 | 16384 | | a61c5279ab3bb2a2b04d000659bdd6fd56f491157 | 1 | 17 | | a63d5997ac8ba509a8ff0ad63e5f024f3f2e04902 | 0 | 0 | | a65a0e9cc47e54e4a6cfbb9aa70c05d6bde20df42 | 0 | 0 | | a683e2e58ce9c7b5a2bdd04e708996c3e41891f5d | 1 | 16384 | | a6a022016290badf5e0725c9355008c36eb8f3e37 | 0 | 0 | | a6ee10e8247b3aa29909797233a5fda5ff8ef7da0 | 0 | 16384 | | a7025fe449d0f52c5ca2264288378b0d4b8f2615d | 0 | 0 | | a7543270d74da3d0e7fecfdfd287e31dc4e1fec65 | 2447 | 147456 | | a7ba7965e06be029027983a292c031cc385b49909 | 1 | 16384 | | a7fca5e367af4dc51ecdaa2ae21cd343651c97fc2 | 1 | 16384 | | a8067cb44b75142ab1b6232bce1bebfe8db02de1c | 0 | 0 | | a820bb49ec5eca9822232db1ae77f741228f4663d | 27451 | 1589248 | | a8400784f45657960b749a38775377fbf1d548796 | 27451 | 1589248 | | a84b1b06497c3739a5cd8245c5d67891d446aa36c | 0 | 16384 | | a8573da3e26bbf527543902b1a30c7043037846c3 | 6514 | 110738 | | a858292e208961aa89e06de254ba58519fca19580 | 6514 | 110738 | | a8603200ae558a7dd39bd5595a825ab7b5960363f | 0 | 0 | | a87330cb3e0a50bf916857ea5fe4ac050d84a1790 | 0 | 0 | | a8d0d978fc864212452af2529be731e73678aced9 | 46 | 1150 | | a8f25d97563f196502d60ebb00282a817530caeaa | 0 | 16384 | | a8f97a657861acbe14cc79e02bbd1b9ac184c9dc8 | 0 | 16384 | | a92d8e88a5a9124ca8951f1e33d0dc352fc13b41c | 2455 | 41735 | | a97e5d4b3ec7a098734948e85ffbb5b5f9b60ee3d | 204646 | 21544960 | | a98ed54ff628c3db02b249c65aa26595a806dc359 | 1 | 25 | | a994990acd7ebbe17d48b46ade002195091a2d5a5 | 1 | 16384 | | a9d65c65835fefbd4f81531673fd500c31e600439 | 0 | 16384 | | a9f231a2b24c428cfcb30f09a379899be75c6b394 | 2563 | 147456 | | aa09ed9c3cd85cd768dbe8e89c7782a65ce7456c5 | 0 | 16384 | | aa110beb257fb6646d3426c5d2962c56ba064fa1d | 1 | 17 | | aa130883cbc6841f4fd7b634300f5916e50ca2129 | 1 | 16384 | | aa177d0ce4b54b32ee8fef6e8ca1d52afd1cca092 | 9008 | 153136 | | aa185b099d1967cc2f90c288ddde604d1eebf2743 | 1 | 16384 | | aa2caaf2a4fa7fd992a35a85b6c941b530bde199c | 8 | 200 | | aa337e568342857c2f7b00366cfba8c8c2859621e | 12761986 | 2353004544 | | aa40adc627b1c1cfd831c5534418c63919e3eb281 | 36 | 900 | | aa427fc7f57045ac226fbb3dbc00d0e4a54d464ff | 1 | 17 | | aa6e066ba2b01cb7a15d4b69f90a7bb81507cf1e1 | 22396 | 380732 | | aa6edb2d3631fcff52ed85e5494fe340c8aad777c | 2 | 34 | | aab31a9d8005409da860c44a37ec7edff50b5065a | 1 | 16384 | | aac73645444fe4145a40cc9019671504c0db44f99 | 2 | 34 | | aac765865fcde4ca400ca07a6bb749a4a2ac9d64a | 1 | 16384 | | aad4c9cae591269a229cc84177e1a43056879a786 | 1 | 16384 | | aae504cc310c256e6bf6b375d3c9fdfb45f5b84af | 0 | 16384 | | aaf001e7d3776579cc9290256f290fb9deb4a1883 | 0 | 16384 | | ab256a3a09eaddd7b3a3e87ef611dcf540d4726ca | 2 | 16384 | | ab3030395fe432ff478f1a2d619c4a3ee3bcec2e9 | 1 | 17 | | ab30943027aaf3f54e79eb9dd1dbd4927aa586fd2 | 0 | 0 | | ab5427f1027b2fbba2c1c3dca12b3d3c38e73eec1 | 8 | 16384 | | ab5883ee36fdaa2ec56f88b7cede84b135673e98b | 1 | 17 | | ab779f2de132976d817f6116589278c9a7c43e9b9 | 0 | 0 | | ab9871f09bb9ce3ca71030bcc872e2ca6720bd04c | 0 | 16384 | | aba61423af62914f08715657353243a1ae3272155 | 0 | 0 | | abfe7b347e93940b50c9dc593194370429a8a203f | 24572 | 1589248 | | ac056b3eedf63b12e3b5db901d1663d13960beb8d | 1 | 17 | | ac0912172a06d72409cbefffb6659915cf3245ce7 | 7201 | 360448 | | ac144f48ef4fbad7770e3e9c4b9c84a8629a18ca9 | 0 | 16384 | | ac1de1e5b8dbc953a28fdfb6728d6bcc99a837fec | 22396 | 380732 | | ac1ea0b1e2ef2b3d0391890f1febcfc935100349b | 9008 | 153136 | | ac1f71180392fb3e232ab3932b136c6288e286f2a | 1 | 17 | | ac2b3b22608232882e303e25901513688c3709fca | 0 | 16384 | | ac4de0ccf7848a81ed96a08bbefeef51a09629a04 | 1 | 16384 | | acbc57c3f09fa2b8334fca6a181fc8abea3abc170 | 2 | 56 | | acda27da591145d3b4e9ebf9d3c2a3e1dd4d0f40b | 0 | 16384 | | ad019a4482e850588d091ddf527619fb803833c2e | 0 | 16384 | | ad0606171405c2bc57a508f0632fb88ed265187aa | 1 | 17 | | ad2158a3099c1027babf4327b4afcfc5701933525 | 194568 | 15911032 | | ad40034eb38bd5cf3036d83ffae5f164c9bd629ba | 0 | 16384 | | ad6690e7bd0fa7f22d659ef2eb57c84436ec7e0a9 | 0 | 16384 | | ada1a2dadfb7cf7a0581c9cc98dfb8d7bc5b560cd | 0 | 0 | | adabf6f044b5faae96b9edd4e8700f6fe0a11edad | 0 | 16384 | | adaeb5446b71a8de5ecce266d293841654438d6a8 | 0 | 0 | | adbe1ddfdbe9b9ed1f1916e4f64f5d83743553bce | 0 | 0 | | ade1e298110be4bcc41f8e7fe6aad180ed5405c1e | 0 | 0 | | ade818412445695723eae72d21dbef66cb90f36f9 | 0 | 0 | | ae0ee9024e41333163e943dc758db1729cd2717e9 | 1 | 17 | | ae5e1b2470a1d034648a442e8df510850c8056ffb | 1 | 16384 | | ae65cb7c637b192efba22e37fc85214325a7b0649 | 0 | 16384 | | ae80891f5a828108d19216b1fd882943b14e68350 | 1 | 16384 | | aea2fe5c88af946eb74501025bbea30b11eeaff2c | 1 | 16384 | | aebb8d3c39c5978f66f36fee3ae1b0f2dab3e842a | 1 | 16384 | | af079e176b60658264937cf19fb22313811430606 | 1 | 16384 | | af21ba98267bce31a1f685e63a809bba000af43f8 | 0 | 16384 | | af38a8da7c33ec35a58df0d347116a837772d57c9 | 609411875 | 204498534400 | | af52b581023bdcc73335c7179e1e0b39ddfa14355 | 1 | 16384 | | af6322043fa3abeacfd8ca70d68615cb798a5712a | 0 | 16384 | | af6775d186247528e2be3c7304636ab675475b40e | 1 | 16384 | | afa4316811ff169d2c4432245ea6aeee012b63ef8 | 1 | 17 | | afa6d672f196fb7dd72adb444471ef0fe05a29ba5 | 1 | 16384 | | afd87d8aa1aba83d2c31906b1b058a127a2ca9b77 | 82353 | 4734976 | | tableindex | 150 | 14668 | +-------------------------------------------+------------+--------------+ 151 rows in set (0.61 sec) On Fri, Jul 18, 2014 at 10:29 AM, Ted Pedersen <[email protected]> wrote: > We have quite a few different resources indexed, so the output from your > command is a little messy. So to start with, here are the table names for > the indices associated with SNOMEDCT (available via the command shown), > This is using PAR CHD relations with SNOMEDCT in 2013AA version of UMLS... > > ted@maraca:~$ getTableNames.pl --config config/snomedct.config > > CuiFinder User Options: > --config option set > > > UMLS-Interface Configuration Information > Sources (SAB): > SNOMEDCT > Relations (REL): > CHD > PAR > Database: > umls (MMSYS-2013AA-20130404) > > > > > > The tables associated with the given configuration file are as follows: > > Table Table Name > acda27da591145d3b4e9ebf9d3c2a3e1dd4d0f40b > MMSYS_2013AA_20130404_SNOMEDCT_CHD_PAR_cache > a61994af45895a14eeb8f720eaba083cb9383b698 > MMSYS_2013AA_20130404_SNOMEDCT_CHD_PAR_child > a494252ed0bdc44c0cac223f40735da144a347be0 > MMSYS_2013AA_20130404_SNOMEDCT_CHD_PAR_parent > aa337e568342857c2f7b00366cfba8c8c2859621e > MMSYS_2013AA_20130404_SNOMEDCT_CHD_PAR_table > > > > On Fri, Jul 18, 2014 at 8:57 AM, [email protected] > [umls-similarity] <[email protected]> wrote: > >> >> >> Hello >> >> Can you share the output of the following SQL query: >> >> select TABLE_NAME,TABLE_ROWS,DATA_LENGTH from information_schema.tables >> where TABLE_SCHEMA='umlsinterfaceindex'; >> >> >> This will give us an idea of how much more we have to go. >> >> Also, is it possible for you to share the SQL dumps of the indexed >> tables. That would be awesome ! >> >> Thanks, >> Chaitanya. >> >> >> > > > > -- > Ted Pedersen > http://www.d.umn.edu/~tpederse > -- Ted Pedersen http://www.d.umn.edu/~tpederse
