{ "_id": "6a1ee735b401979e734116e0", "Package": "TKCat", "Type": "Package", "Title": "Tailored Knowledge Catalog", "Version": "1.2.1", "Authors@R": "c(\nperson(\n\"Patrice\", \"Godard\",\nrole = c(\"aut\", \"cre\",\"cph\"),\nemail = \"patrice.godard@gmail.com\"\n)\n)", "Description": "Facilitate the management of data from knowledge resources\nthat are frequently used alone or together in research\nenvironments. In 'TKCat', knowledge resources are manipulated\nas modeled database (MDB) objects. These objects provide access\nto the data tables along with a general description of the\nresource and a detailed data model documenting the tables,\ntheir fields and their relationships. These MDBs are then\ngathered in catalogs that can be easily explored and shared.\nFinally, 'TKCat' provides tools to easily subset, filter and\ncombine MDBs and create new catalogs suited for specific needs.", "URL": "https://patzaw.github.io/TKCat/, https://github.com/patzaw/TKCat/", "BugReports": "https://github.com/patzaw/TKCat/issues", "License": "GPL-3", "Encoding": "UTF-8", "VignetteBuilder": "knitr", "Roxygen": "list(markdown = TRUE)", "Config/roxygen2/version": "8.0.0", "Config/pak/sysreqs": "cmake make libuv1-dev libxml2-dev libssl-dev\nlibnode-dev libx11-dev zlib1g-dev", "Repository": "https://patzaw.r-universe.dev", "Date/Publication": "2026-05-19 15:40:34 UTC", "RemoteUrl": "https://github.com/patzaw/tkcat", "RemoteRef": "HEAD", "RemoteSha": "2ca8fdd0081bb10f609fc558a4fc00cbc925c9d1", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-19 16:58:21 UTC", "User": "root" }, "Author": "Patrice Godard [aut, cre, cph]", "Maintainer": "Patrice Godard ", "MD5sum": "d91cc7dae35fa2aaffb5ec9f0210519f", "_user": "patzaw", "_type": "src", "_file": "TKCat_1.2.1.tar.gz", "_fileid": "91efa85f2e62ddb61591e53100b5eb234061dd1d14d3a4c352c6cc57a19deb0e", "_filesize": 913546, "_sha256": "91efa85f2e62ddb61591e53100b5eb234061dd1d14d3a4c352c6cc57a19deb0e", "_created": "2026-05-19T16:58:21.000Z", "_published": "2026-06-02T14:22:45.363Z", "_distro": "noble", "_jobs": [ { "job": 79093217174, "time": 254, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7090151615" }, { "job": 79093217679, "time": 214, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7090136596" }, { "job": 79093217241, "time": 162, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7090228245" }, { "job": 79093217762, "time": 170, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7090131837" }, { "job": 79093214176, "time": 256, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7090055303" }, { "job": 79093216077, "time": 151, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7360448639" }, { "job": 79093217409, "time": 159, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7090115868" }, { "job": 79093217648, "time": 144, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7090110438" }, { "job": 79093217575, "time": 150, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7090112702" } ], "_buildurl": "https://github.com/r-universe/patzaw/actions/runs/26112102578", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/patzaw/tkcat", "_commit": { "id": "2ca8fdd0081bb10f609fc558a4fc00cbc925c9d1", "author": "Patrice Godard ", "committer": "Patrice Godard ", "message": "Corrections and regeneration of documentation\n", "time": 1779205234 }, "_maintainer": { "name": "Patrice Godard", "email": "patrice.godard@gmail.com", "login": "patzaw", "linkedin": "in/patrice-godard-65a25920", "description": "Data scientist and bioinformatician. Strong experience in multiomics data analysis applied to pharmaceutical research.", "uuid": 9802306 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1", "role": "Depends" }, { "package": "ReDaMoR", "version": ">= 1.0.0", "role": "Depends" }, { "package": "DBI", "role": "Depends" }, { "package": "visNetwork", "role": "Depends" }, { "package": "dplyr", "role": "Depends" }, { "package": "ClickHouseHTTP", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "tidyselect", "role": "Imports" }, { "package": "askpass", "role": "Imports" }, { "package": "shiny", "role": "Imports" }, { "package": "shinydashboard", "role": "Imports" }, { "package": "DT", "role": "Imports" }, { "package": "htmltools", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "jsonlite", "role": "Imports" }, { "package": "jsonvalidate", "version": ">= 1.3.2", "role": "Imports" }, { "package": "markdown", "role": "Imports" }, { "package": "promises", "role": "Imports" }, { "package": "future", "role": "Imports" }, { "package": "xml2", "role": "Imports" }, { "package": "Matrix", "role": "Imports" }, { "package": "uuid", "role": "Imports" }, { "package": "crayon", "role": "Imports" }, { "package": "roxygen2", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RClickhouse", "role": "Suggests" }, { "package": "stringr", "role": "Suggests" }, { "package": "data.tree", "role": "Suggests" }, { "package": "BED", "role": "Suggests" } ], "_owner": "patzaw", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-21", "n": 2 }, { "week": "2025-23", "n": 3 }, { "week": "2026-16", "n": 1 }, { "week": "2026-17", "n": 3 }, { "week": "2026-18", "n": 1 }, { "week": "2026-19", "n": 4 }, { "week": "2026-21", "n": 4 } ], "_tags": [ { "name": "v1.1.14", "date": "2025-06-05" } ], "_stars": 5, "_contributors": [ { "user": "patzaw", "count": 286, "uuid": 9802306 }, { "user": "henrikbengtsson", "count": 1, "uuid": 1616850 } ], "_userbio": { "uuid": 9802306, "type": "user", "name": "Patrice Godard", "description": "Data scientist and bioinformatician. Strong experience in multiomics data analysis applied to pharmaceutical research." }, "_downloads": { "count": 239, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/TKCat" }, "_devurl": "https://github.com/patzaw/tkcat", "_pkgdown": "https://patzaw.github.io/TKCat/", "_searchresults": 58, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/readme.html", "extra/readme.md", "extra/TKCat.html", "manual.pdf" ], "_homeurl": "https://github.com/patzaw/tkcat", "_realowner": "patzaw", "_cranurl": true, "_releases": [ { "version": "0.5.4", "date": "2021-03-04" }, { "version": "0.7.1", "date": "2022-01-17" }, { "version": "1.0.3", "date": "2022-06-07" }, { "version": "1.0.6", "date": "2022-10-21" }, { "version": "1.0.7", "date": "2023-02-16" }, { "version": "1.1.7", "date": "2024-05-08" }, { "version": "1.1.8", "date": "2024-05-23" }, { "version": "1.1.11", "date": "2024-07-03" }, { "version": "1.1.12", "date": "2025-03-17" }, { "version": "1.1.14", "date": "2025-06-05" } ], "_exports": [ "add_chMDB_user", "add_chTKCat_collection", "add_collection_member", "add_feature_def", "add_helpers", "add_km_feature", "add_km_spec", "add_km_table", "add_property_values", "add_table_def", "add_table_features", "add_unit_def", "archive_chMDB", "as_chMDB", "as_fileMDB", "as_KMR", "as_memoMDB", "ch_insert", "change_chTKCat_password", "check_chTKCat", "chMDB", "chTKCat", "collection_members", "collection_members<-", "compare_MDB", "count_records", "create_chMDB", "create_chTKCat_user", "create_KMR", "create_POK", "data_file_size", "data_files", "data_model", "data_tables", "db_disconnect", "db_info", "db_info<-", "db_reconnect", "db_tables", "decode_bin", "dims", "drop_chMDB", "drop_chMDB_projections", "drop_chTKCat_user", "empty_chMDB", "encode_bin", "explore_MDBs", "fileMDB", "filter_mdb_matrix", "filter_with_tables", "get_chMDB_metadata", "get_chMDB_timestamps", "get_chTKCat_collection", "get_collection_mapper", "get_confrontation_report", "get_hosts", "get_km_spec", "get_KMR", "get_local_collection", "get_MDB", "get_POK", "get_query", "get_R_helpers", "get_shared_collections", "has_km_spec", "heads", "import_collection_mapper", "import_local_collection", "init_chTKCat", "is_chMDB_public", "is_current_chMDB", "is.chMDB", "is.chTKCat", "is.fileMDB", "is.KMR", "is.MDB", "is.memoMDB", "is.metaMDB", "is.POK", "is.TKCat", "join_mdb_tables", "list_chMDB_timestamps", "list_chMDB_users", "list_chTKCat_collections", "list_chTKCat_users", "list_feature_properties", "list_local_collections", "list_MDBs", "list_measurement_units", "list_measurements", "list_POKs", "list_property_values", "list_table_features", "list_table_types", "list_tables", "manage_chTKCat_users", "map_collection_members", "materialize_chMDB_projections", "MDBs", "memoMDB", "mergeTree_from_RelTableModel", "mergeTrees_from_RelDataModel", "metaMDB", "parse_R_helpers", "read_collection_members", "read_fileMDB", "read_KMR", "relational_tables", "remove_chMDB_user", "remove_chTKCat_collection", "rm_km_feature", "rm_km_table", "scan_fileMDBs", "search_MDB_fields", "search_MDB_tables", "set_chMDB_access", "set_chMDB_timestamp", "show_collection_def", "TKCat", "unarchive_chMDB", "update_chMDB_grants", "update_chTKCat_user", "write_collection_members", "write_MergeTree" ], "_help": [ { "page": "dot-format_bytes", "title": "Format bytes numbers in human readable values", "topics": [ ".format_bytes" ] }, { "page": "fileMDB", "title": "An MDB (Modeled DataBase) based on files: fileMDB", "topics": [ "$.chMDB", "$.fileMDB", "as.list.fileMDB", "fileMDB", "names<-.fileMDB", "rename.fileMDB", "[.fileMDB", "[[.fileMDB" ] }, { "page": "add_chMDB_user", "title": "Add a user to an MDB of a chTKCat object", "topics": [ "add_chMDB_user" ] }, { "page": "add_chTKCat_collection", "title": "Import a collection in a chTKCat database", "topics": [ "add_chTKCat_collection" ] }, { "page": "add_collection_member", "title": "Add a collection member to an MDB", "topics": [ "add_collection_member" ] }, { "page": "add_feature_def", "title": "Add a feature definition to Knowledge Management Requirements (KMR)", "topics": [ "add_feature_def" ] }, { "page": "add_helpers", "title": "Add a set of helper functions to a compatible object", "topics": [ "add_helpers", "add_helpers.KMR", "add_helpers.MDB" ] }, { "page": "add_km_feature", "title": "Add KM feature specifications to an MDB object", "topics": [ "add_km_feature" ] }, { "page": "add_km_spec", "title": "Add empty KM specification tables to an MDB object", "topics": [ "add_km_spec" ] }, { "page": "add_km_table", "title": "Add KM table specifications to an MDB object", "topics": [ "add_km_table" ] }, { "page": "add_property_values", "title": "Add possible values to an integer or a character feature property in KMR", "topics": [ "add_property_values" ] }, { "page": "add_table_def", "title": "Add a table definition to Knowledge Management Requirements (KMR)", "topics": [ "add_table_def" ] }, { "page": "add_table_features", "title": "Add possible features to table type in KMR", "topics": [ "add_table_features" ] }, { "page": "add_unit_def", "title": "Add a unit definition to Knowledge Management Requirements (KMR)", "topics": [ "add_unit_def" ] }, { "page": "archive_chMDB", "title": "Archive a chMDB in a chTKCat", "topics": [ "archive_chMDB" ] }, { "page": "as_chMDB", "title": "Push an MDB object in a ClickHouse database", "topics": [ "as_chMDB" ] }, { "page": "as_fileMDB", "title": "Write an MDB object", "topics": [ "as_fileMDB", "as_fileMDB.chMDB", "as_fileMDB.fileMDB", "as_fileMDB.memoMDB", "as_fileMDB.metaMDB" ] }, { "page": "as_KMR", "title": "Convert in a KMR object when possible", "topics": [ "as_KMR" ] }, { "page": "as_memoMDB", "title": "Convert any MDB object in a memoMDB object", "topics": [ "as_memoMDB" ] }, { "page": "ch_insert", "title": "Insert records by batches in a Clickhouse table", "topics": [ "ch_insert" ] }, { "page": "change_chTKCat_password", "title": "Change chTKCat password", "topics": [ "change_chTKCat_password" ] }, { "page": "check_chTKCat", "title": "Check a chTKCat object", "topics": [ "check_chTKCat" ] }, { "page": "chMDB", "title": "An MDB (Modeled DataBase) relying on ClickHouse: chMDB", "topics": [ "as.list.chMDB", "chMDB", "names<-.chMDB", "rename.chMDB", "[.chMDB", "[[.chMDB" ] }, { "page": "chTKCat", "title": "Connect to a ClickHouse TKCat instance", "topics": [ "chTKCat" ] }, { "page": "collection_members", "title": "Collection members", "topics": [ "collection_members", "collection_members.chMDB", "collection_members.chTKCat", "collection_members.fileMDB", "collection_members.memoMDB", "collection_members.metaMDB", "collection_members.TKCat", "collection_members<-", "collection_members<-.chMDB", "collection_members<-.fileMDB", "collection_members<-.memoMDB" ] }, { "page": "compare_MDB", "title": "Compare two MDB objects", "topics": [ "compare_MDB" ] }, { "page": "count_records", "title": "Count the number of records", "topics": [ "count_records", "count_records.MDB" ] }, { "page": "create_chMDB", "title": "Create a database in a chTKCat", "topics": [ "create_chMDB" ] }, { "page": "create_chTKCat_user", "title": "Create a chTKCat user", "topics": [ "create_chTKCat_user" ] }, { "page": "create_KMR", "title": "Create an MDB object with Knowledge Management Requirements (KMR)", "topics": [ "create_KMR", "KMR" ] }, { "page": "create_POK", "title": "Create a piece of knowledge (POK) from an MDB and a KMRobject", "topics": [ "create_POK", "POK" ] }, { "page": "data_file_size", "title": "Get the size of data files from a fileMDB object", "topics": [ "data_file_size" ] }, { "page": "data_files", "title": "Get the data files from a fileMDB object", "topics": [ "data_files" ] }, { "page": "data_model", "title": "Get object data model", "topics": [ "data_model", "data_model.chMDB", "data_model.fileMDB", "data_model.memoMDB", "data_model.metaMDB" ] }, { "page": "data_tables", "title": "Get object data tables", "topics": [ "data_tables", "data_tables.chMDB", "data_tables.fileMDB", "data_tables.memoMDB", "data_tables.metaMDB" ] }, { "page": "db_disconnect", "title": "Disconnect an object from a database", "topics": [ "db_disconnect", "db_disconnect.chMDB", "db_disconnect.chTKCat", "db_disconnect.metaMDB" ] }, { "page": "db_info", "title": "DB information", "topics": [ "db_info", "db_info.chMDB", "db_info.fileMDB", "db_info.memoMDB", "db_info.metaMDB", "db_info<-", "db_info<-.chMDB", "db_info<-.fileMDB", "db_info<-.memoMDB", "db_info<-.metaMDB" ] }, { "page": "db_reconnect", "title": "Reconnect an object to a database", "topics": [ "db_reconnect", "db_reconnect.chMDB", "db_reconnect.chTKCat", "db_reconnect.metaMDB", "db_reconnect.POK" ] }, { "page": "db_tables", "title": "Get the DB tables from a chMDB or metaMDB object", "topics": [ "db_tables" ] }, { "page": "decode_bin", "title": "Decode base64 string", "topics": [ "decode_bin" ] }, { "page": "dims", "title": "Detailed information about the format of the tables", "topics": [ "dims", "dims.chMDB", "dims.fileMDB", "dims.memoMDB", "dims.metaMDB" ] }, { "page": "drop_chMDB", "title": "Drop a database from a chTKCat", "topics": [ "drop_chMDB" ] }, { "page": "drop_chMDB_projections", "title": "Drop in ClickHouse any projection documented in the data model", "topics": [ "drop_chMDB_projections" ] }, { "page": "drop_chTKCat_user", "title": "Drop a user from a chTKCat object", "topics": [ "drop_chTKCat_user" ] }, { "page": "empty_chMDB", "title": "Empty a chMDB in a chTKCat", "topics": [ "empty_chMDB" ] }, { "page": "encode_bin", "title": "Encode a binary file in a base64 string", "topics": [ "encode_bin" ] }, { "page": "explore_MDBs", "title": "Explore available MDB in a shiny web interface", "topics": [ "explore_MDBs", "explore_MDBs.chTKCat", "explore_MDBs.TKCat" ] }, { "page": "filter_mdb_matrix", "title": "Filter a matrix stored in an MDB", "topics": [ "filter_mdb_matrix", "filter_mdb_matrix.chMDB", "filter_mdb_matrix.fileMDB", "filter_mdb_matrix.memoMDB", "filter_mdb_matrix.metaMDB" ] }, { "page": "filter_with_tables", "title": "Filter an MDB object according to provided tables", "topics": [ "filter_with_tables", "filter_with_tables.chMDB", "filter_with_tables.fileMDB", "filter_with_tables.memoMDB", "filter_with_tables.metaMDB" ] }, { "page": "filter.chMDB", "title": "Filter a chMDB object and return a memoMDB", "topics": [ "filter.chMDB" ] }, { "page": "filter.fileMDB", "title": "Filter a fileMDB object and return a memoMDB", "topics": [ "filter.fileMDB" ] }, { "page": "filter.memoMDB", "title": "Filter a memoMDB object", "topics": [ "filter.memoMDB" ] }, { "page": "filter.metaMDB", "title": "Filter a metaMDB object", "topics": [ "filter.metaMDB" ] }, { "page": "format.chTKCat", "title": "Format a chTKCat object for printing", "topics": [ "format.chTKCat" ] }, { "page": "get_chMDB_metadata", "title": "Get the metadata of an MDB from a chTKCat connection", "topics": [ "get_chMDB_metadata" ] }, { "page": "get_chMDB_timestamps", "title": "Get instance timestamps of an MDB in chTKCat", "topics": [ "get_chMDB_timestamps" ] }, { "page": "get_chTKCat_collection", "title": "Get a collection from a chTKCat", "topics": [ "get_chTKCat_collection" ] }, { "page": "get_collection_mapper", "title": "Get the default mapper function for a collection", "topics": [ "get_collection_mapper" ] }, { "page": "get_confrontation_report", "title": "Get the last generated MDB confrontation report", "topics": [ "get_confrontation_report" ] }, { "page": "get_hosts", "title": "Get database hosts", "topics": [ "get_hosts", "get_hosts.chMDB", "get_hosts.chTKCat", "get_hosts.DBIConnection", "get_hosts.metaMDB" ] }, { "page": "get_km_spec", "title": "Get KM specifications from an MDB object", "topics": [ "get_km_spec" ] }, { "page": "get_KMR", "title": "Get a KMR object from a TKCat or a chTKCat object", "topics": [ "get_KMR" ] }, { "page": "get_local_collection", "title": "Get the json definition of a local collection of concepts", "topics": [ "get_local_collection" ] }, { "page": "get_MDB", "title": "Get an MDB object from a TKCat related object", "topics": [ "get_MDB", "get_MDB.chTKCat", "get_MDB.TKCat" ] }, { "page": "get_POK", "title": "Get a POK from a chTKCat connection or a TKCat object", "topics": [ "get_POK" ] }, { "page": "get_query", "title": "Get SQL query", "topics": [ "get_query", "get_query.chMDB", "get_query.chTKCat" ] }, { "page": "get_R_helpers", "title": "Get a set of helper functions from an object", "topics": [ "get_R_helpers", "get_R_helpers.KMR", "get_R_helpers.MDB" ] }, { "page": "get_shared_collections", "title": "Get collections shared by 2 objects and return member combinations", "topics": [ "get_shared_collections" ] }, { "page": "has_km_spec", "title": "Check if KM specifications are available in an MDB object", "topics": [ "has_km_spec" ] }, { "page": "heads", "title": "Get the first records of each object data tables", "topics": [ "heads", "heads.chMDB", "heads.fileMDB", "heads.memoMDB", "heads.metaMDB" ] }, { "page": "import_collection_mapper", "title": "Import a function to map collection members", "topics": [ "import_collection_mapper" ] }, { "page": "import_local_collection", "title": "Import a the definition of a collection of concepts in the local environment", "topics": [ "import_local_collection" ] }, { "page": "init_chTKCat", "title": "Initialize a chTKCat database", "topics": [ "init_chTKCat" ] }, { "page": "is_chMDB_public", "title": "Is a chMDB public", "topics": [ "is_chMDB_public" ] }, { "page": "is_current_chMDB", "title": "Check if the chMDB object refers to the current instance of the MDB", "topics": [ "is_current_chMDB" ] }, { "page": "is.chMDB", "title": "Check if the object is a chMDB object", "topics": [ "is.chMDB" ] }, { "page": "is.chTKCat", "title": "Check the object is a chTKCat object", "topics": [ "is.chTKCat" ] }, { "page": "is.fileMDB", "title": "Check if the object is a fileMDB object", "topics": [ "is.fileMDB" ] }, { "page": "is.KMR", "title": "Check if an object represents Knowledge Management Requirements (KMR)", "topics": [ "is.KMR" ] }, { "page": "is.MDB", "title": "Check if the object is an MDB object", "topics": [ "is.MDB" ] }, { "page": "is.memoMDB", "title": "Check if the object is a memoMDB object", "topics": [ "is.memoMDB" ] }, { "page": "is.metaMDB", "title": "Check if the object is a metaMDB object", "topics": [ "is.metaMDB" ] }, { "page": "is.POK", "title": "Check if the object is a POK object", "topics": [ "is.POK" ] }, { "page": "is.TKCat", "title": "Check the object is a TKCat object", "topics": [ "is.TKCat" ] }, { "page": "join_mdb_tables", "title": "Join connected tables", "topics": [ "join_mdb_tables" ] }, { "page": "list_chMDB_timestamps", "title": "List instance timestamps of an MDB in chTKCat", "topics": [ "list_chMDB_timestamps" ] }, { "page": "list_chMDB_users", "title": "List users of an MDB of a chTKCat object", "topics": [ "list_chMDB_users" ] }, { "page": "list_chTKCat_collections", "title": "List collections available in a chTKCat", "topics": [ "list_chTKCat_collections" ] }, { "page": "list_chTKCat_users", "title": "List chTKCat user", "topics": [ "list_chTKCat_users" ] }, { "page": "list_feature_properties", "title": "List properties of a feature", "topics": [ "list_feature_properties" ] }, { "page": "list_local_collections", "title": "List local collections of concepts", "topics": [ "list_local_collections" ] }, { "page": "list_MDBs", "title": "List available MDB", "topics": [ "list_MDBs", "list_MDBs.chTKCat", "list_MDBs.TKCat" ] }, { "page": "list_measurement_units", "title": "List possible units for a type of measurement", "topics": [ "list_measurement_units" ] }, { "page": "list_measurements", "title": "List supported types of measurement", "topics": [ "list_measurements" ] }, { "page": "list_POKs", "title": "List available POK", "topics": [ "list_POKs" ] }, { "page": "list_property_values", "title": "List of supported values for an integer or a character property", "topics": [ "list_property_values" ] }, { "page": "list_table_features", "title": "List the features provided by a set of tables", "topics": [ "list_table_features" ] }, { "page": "list_table_types", "title": "List types of tables defined in a KMR object", "topics": [ "list_table_types" ] }, { "page": "list_tables", "title": "List tables in a clickhouse database", "topics": [ "list_tables", "list_tables.chTKCat", "list_tables.DBIConnection" ] }, { "page": "manage_chTKCat_users", "title": "Manage user information in a shiny interface", "topics": [ "manage_chTKCat_users" ] }, { "page": "map_collection_members", "title": "Map different collection members", "topics": [ "map_collection_members" ] }, { "page": "materialize_chMDB_projections", "title": "Materialize in ClickHouse any projection documented in the data model", "topics": [ "materialize_chMDB_projections" ] }, { "page": "MDB", "title": "MDB", "topics": [ "as.list.MDB", "c.MDB", "length.MDB", "lengths.MDB", "MDB", "merge.MDB", "names.MDB", "pull.MDB", "select.MDB" ] }, { "page": "MDBs", "title": "Get a list of MDB from metaMDB object", "topics": [ "MDBs" ] }, { "page": "memoMDB", "title": "An MDB (Modeled DataBase) in memory: memoMDB", "topics": [ "$.memoMDB", "memoMDB", "names<-.memoMDB", "rename.memoMDB", "[.memoMDB", "[[.memoMDB" ] }, { "page": "mergeTree_from_RelTableModel", "title": "Create a ClickHouse MergeTree table from a ReDaMoR::RelTableModel", "topics": [ "mergeTree_from_RelTableModel" ] }, { "page": "mergeTrees_from_RelDataModel", "title": "Create ClickHouse MergeTree tables from a ReDaMoR::RelDataModel", "topics": [ "mergeTrees_from_RelDataModel" ] }, { "page": "metaMDB", "title": "A metaMDB object", "topics": [ "$.metaMDB", "as.list.metaMDB", "metaMDB", "names<-.metaMDB", "rename.metaMDB", "[.metaMDB", "[[.metaMDB" ] }, { "page": "parse_R_helpers", "title": "Parse source code to get R helpers", "topics": [ "parse_R_helpers" ] }, { "page": "read_collection_members", "title": "Read a collection member JSON file", "topics": [ "read_collection_members" ] }, { "page": "read_fileMDB", "title": "Read a fileMDB from a path", "topics": [ "read_fileMDB" ] }, { "page": "read_KMR", "title": "Read KMR from a path", "topics": [ "read_KMR" ] }, { "page": "relational_tables", "title": "Get a list of relational tables", "topics": [ "relational_tables" ] }, { "page": "remove_chMDB_user", "title": "Drop a user of an MDB of a chTKCat object", "topics": [ "remove_chMDB_user" ] }, { "page": "remove_chTKCat_collection", "title": "Remove a collection from a chTKCat database", "topics": [ "remove_chTKCat_collection" ] }, { "page": "rm_km_feature", "title": "Remove KM feature specifications from an MDB object", "topics": [ "rm_km_feature" ] }, { "page": "rm_km_table", "title": "Remove KM table specifications from an MDB object", "topics": [ "rm_km_table" ] }, { "page": "scan_fileMDBs", "title": "Scan a catalog of fileMDB", "topics": [ "scan_fileMDBs" ] }, { "page": "search_MDB_fields", "title": "Search fields in a TKCat related object", "topics": [ "search_MDB_fields", "search_MDB_fields.chTKCat", "search_MDB_fields.TKCat" ] }, { "page": "search_MDB_tables", "title": "Search tables in a TKCat related object", "topics": [ "search_MDB_tables", "search_MDB_tables.chTKCat", "search_MDB_tables.TKCat" ] }, { "page": "set_chMDB_access", "title": "Set chMDB access", "topics": [ "set_chMDB_access" ] }, { "page": "set_chMDB_timestamp", "title": "Set timestamp of the current version of an MDB in chTKCat", "topics": [ "set_chMDB_timestamp" ] }, { "page": "show_collection_def", "title": "Show the definition of a collection", "topics": [ "show_collection_def" ] }, { "page": "slice.chMDB", "title": "Subset a chMDB object according to row position in one table and return a memoMDB", "topics": [ "slice.chMDB" ] }, { "page": "slice.fileMDB", "title": "Subset a fileMDB object according to row position in one table and return a memoMDB", "topics": [ "slice.fileMDB" ] }, { "page": "slice.memoMDB", "title": "Subset a memoMDB object according to row position in one table", "topics": [ "slice.memoMDB" ] }, { "page": "slice.metaMDB", "title": "Subset a metaMDB object according to row position in one table", "topics": [ "slice.metaMDB" ] }, { "page": "TKCat", "title": "TKCat: a catalog of MDB", "topics": [ "c.TKCat", "names<-.TKCat", "rename.TKCat", "TKCat", "[.TKCat" ] }, { "page": "unarchive_chMDB", "title": "Unarchive a chMDB in a chTKCat", "topics": [ "unarchive_chMDB" ] }, { "page": "update_chMDB_grants", "title": "Update grants on tables in an MDB of a chTKCat object", "topics": [ "update_chMDB_grants" ] }, { "page": "update_chTKCat_user", "title": "Update a chTKCat user information", "topics": [ "update_chTKCat_user" ] }, { "page": "write_collection_members", "title": "Write a collection member JSON file", "topics": [ "write_collection_members" ] }, { "page": "write_MergeTree", "title": "Write a Clickhouse MergeTree table", "topics": [ "write_MergeTree" ] } ], "_readme": "https://github.com/patzaw/tkcat/raw/HEAD/README.md", "_rundeps": [ "arrow", "askpass", "assertthat", "base64enc", "bit", "bit64", "brew", "bslib", "cachem", "callr", "cli", "ClickHouseHTTP", "clipr", "codetools", "colourpicker", "commonmark", "cpp11", "crayon", "crosstalk", "curl", "data.table", "DBI", "desc", "digest", "dplyr", "DT", "evaluate", "farver", "fastmap", "fontawesome", "fs", "future", "generics", "ggplot2", "globals", "glue", "gtable", "highr", "hms", "htmltools", "htmlwidgets", "httpuv", "httr2", "isoband", "jquerylib", "jsonlite", "jsonvalidate", "knitr", "labeling", "later", "lattice", "lazyeval", "lifecycle", "listenv", "litedown", "magrittr", "markdown", "Matrix", "memoise", "mime", "miniUI", "openssl", "otel", "parallelly", "pillar", "pkgbuild", "pkgconfig", "pkgload", "prettyunits", "processx", "progress", "promises", "ps", "purrr", "R6", "rappdirs", "RColorBrewer", "Rcpp", "readr", "ReDaMoR", "rintrojs", "rlang", "rmarkdown", "roxygen2", "rprojroot", "rstudioapi", "S7", "sass", "scales", "shiny", "shinydashboard", "shinyjs", "sourcetools", "sys", "tibble", "tidyselect", "tinytex", "tzdb", "utf8", "uuid", "V8", "vctrs", "viridisLite", "visNetwork", "vroom", "withr", "xfun", "xml2", "xtable", "yaml" ], "_vignettes": [ { "source": "TKCat.Rmd", "filename": "TKCat.html", "title": "Introduction to TKCat", "author": "Patrice Godard", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Create an MDB: a minimal example", "Loading example data", "Creating a data model with ReDaMoR", "Binding the model to the data in an MDB object", "Adding information about an MDB", "Documenting collection members", "Writing an MDB in files", "Leveraging MDB", "HPO", "ClinVar", "CHEMBL", "MDB implementations", "Exploring information", "Pulling, subsetting and combining", "Filtering and joining", "Merging MDBs with collections", "Collections and collection members", "Shared collections and merging", "Merging without collection", "A centralized catalog of MDB in ClickHouse (chTKCat)", "Local TKCat", "chTKCat", "Pushing an MDB in a chTKCat instance", "Specific operations on chMDB objects", "Data organization in ClickHouse", "Defining and using Requirements for Knowledge Management (KMR)", "Appendices", "chTKCat operations", "Instantiating the ClickHouse database", "Install ClickHouse, initialize and configure the TKCat instance", "Cleaning and removing a TKCat instance", "User management", "Creation", "Update", "Drop", "chMDB management", "chMDB Creation", "Populating chMDB", "Deleting a chMDB", "Collection management", "Implementation", "Data models", "Default database", "Modeled databases", "TKCat collections", "Creating a collection", "Documenting collection members", "Collection mapper functions", "Remarks about supported data format and data types", "Matrices of values", "Documents stored as base64 values", "References" ], "created": "2024-04-30 14:52:16", "modified": "2026-05-19 15:40:34", "commits": 14 }, { "source": "TKCat-KMR-POK.Rmd", "filename": "TKCat-KMR-POK.html", "title": "Defining and using Requirements for Knowledge Management (KMR) in TKCat", "author": "Patrice Godard", "engine": "knitr::rmarkdown", "headings": [ "Defining KMR", "KMR organization", "Define requirements", "Table and mandatory features", "Optional features", "Possible values for feature properties", "Measurements", "KM specifications", "Exploring requirements", "Documenting MDB specifications", "Simple example", "Piece Of Knowledge (POK)", "Helpers", "KMR helpers", "MDB helpers", "POK objects" ], "created": "2024-05-07 12:17:14", "modified": "2026-05-19 15:00:24", "commits": 3 } ], "_score": 6.307496037913213, "_indexed": true, "_nocasepkg": "tkcat", "_universes": [ "patzaw" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.2.1", "date": "2026-05-19T17:01:51.000Z", "distro": "noble", "commit": "2ca8fdd0081bb10f609fc558a4fc00cbc925c9d1", "fileid": "e8b4d5c3c13fb28473dee46a9c375e1fe4182580057d3f21fea8c8e882e7c297", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26112102578" }, { "r": "4.6.0", "os": "linux", "version": "1.2.1", "date": "2026-05-19T17:01:13.000Z", "distro": "noble", "commit": "2ca8fdd0081bb10f609fc558a4fc00cbc925c9d1", "fileid": "3690a0d2cafcad766d6f1189632d8f4c9498ff58593b164ae5fb3452b4b66b40", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26112102578" }, { "r": "4.5.3", "os": "mac", "version": "1.2.1", "date": "2026-05-19T17:05:34.000Z", "commit": "2ca8fdd0081bb10f609fc558a4fc00cbc925c9d1", "fileid": "2a96c56099f32175c08a561caead80a87725746ae59b49f15876cd6e1de32808", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26112102578" }, { "r": "4.6.0", "os": "mac", "version": "1.2.1", "date": "2026-05-19T17:01:00.000Z", "commit": "2ca8fdd0081bb10f609fc558a4fc00cbc925c9d1", "fileid": "d5559f08f010a3640d99ade038c1c8feb9d55747e7e358c6ee8cadcaf81dbbd4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26112102578" }, { "r": "4.7.0", "os": "win", "version": "1.2.1", "date": "2026-05-19T17:00:06.000Z", "commit": "2ca8fdd0081bb10f609fc558a4fc00cbc925c9d1", "fileid": "a92001086b7c6f42a7bc62d190e5f4dd4b7f6f691071ef4f10469e53f8410821", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26112102578" }, { "r": "4.5.3", "os": "win", "version": "1.2.1", "date": "2026-05-19T16:59:58.000Z", "commit": "2ca8fdd0081bb10f609fc558a4fc00cbc925c9d1", "fileid": "abfdebe972dca1c28df984c337fd12ae9843b98e920128957d6704e032e44fd4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26112102578" }, { "r": "4.6.0", "os": "win", "version": "1.2.1", "date": "2026-05-19T17:00:13.000Z", "commit": "2ca8fdd0081bb10f609fc558a4fc00cbc925c9d1", "fileid": "a5e42197a883274fe887be60999d8ae352aa60ea3846088becf43b29d0f4dd9c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26112102578" }, { "r": "4.6.0", "os": "wasm", "version": "1.2.1", "date": "2026-06-02T14:22:09.000Z", "commit": "2ca8fdd0081bb10f609fc558a4fc00cbc925c9d1", "fileid": "4ec2ae1131cccc7c1500f212fdbb5bddee8b5fdf90f618f032469696c66940dc", "status": "success", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26112102578" } ] }