Easily Access and Maintain Time-Based Versioned Data
(Slowly-Changing-Dimension)
![[R logo]](../../../doc/html/Rlogo.svg)
![[Up]](../../../doc/html/left.jpg)
![[Top]](../../../doc/html/up.jpg)
Documentation for package ‘SCDB’ version 0.4.0
Help Pages
| anti_join.tbl_sql | SQL Joins |
| close_connection | Close connection to the database |
| create_logs_if_missing | Create a table with the SCDB log structure if it does not exists |
| create_table | Create a historical table from input data |
| db_locks | Sets, queries and removes locks for database tables |
| db_timestamp | Determine the type of timestamps the database supports |
| defer_db_cleanup | Delete table at function exit |
| digest_to_checksum | Computes an checksum from columns |
| filter_keys | Filters .data according to all records in the filter |
| full_join.tbl_sql | SQL Joins |
| get_catalog | Get the current schema/catalog of a database-related objects |
| get_catalog.Microsoft SQL Server | Get the current schema/catalog of a database-related objects |
| get_connection | Opens connection to the database |
| get_connection.default | Opens connection to the database |
| get_connection.duckdb_driver | Opens connection to the database |
| get_connection.OdbcDriver | Opens connection to the database |
| get_connection.PqDriver | Opens connection to the database |
| get_connection.SQLiteDriver | Opens connection to the database |
| get_schema | Get the current schema/catalog of a database-related objects |
| get_schema.PqConnection | Get the current schema/catalog of a database-related objects |
| get_schema.SQLiteConnection | Get the current schema/catalog of a database-related objects |
| get_table | Retrieves a named table from a given schema on the connection |
| get_tables | List the available tables on the connection |
| id | Convenience function for DBI::Id |
| id.character | Convenience function for DBI::Id |
| id.data.frame | Convenience function for DBI::Id |
| id.Id | Convenience function for DBI::Id |
| inner_join.tbl_sql | SQL Joins |
| interlace | Combine any number of tables, where each has their own time axis of validity |
| interlace_sql | Combine any number of tables, where each has their own time axis of validity |
| is.historical | Checks if table contains historical data |
| joins | SQL Joins |
| left_join.tbl_sql | SQL Joins |
| lock_table | Sets, queries and removes locks for database tables |
| Logger | Logger: Complete logging to console, file and database |
| LoggerNull | LoggerNull: The no-logging Logger |
| nrow | nrow() but also works on remote tables |
| right_join.tbl_sql | SQL Joins |
| schema_exists | Test if a schema exists in given connection |
| semi_join.tbl_sql | SQL Joins |
| slice_time | Slices a data object based on time / date |
| table_exists | Test if a table exists in database |
| table_exists.DBIConnection | Test if a table exists in database |
| unique_table_name | Create a name for a temporary table |
| unite.tbl_dbi | tidyr::unite for tbl_dbi |
| unlock_table | Sets, queries and removes locks for database tables |
| update_snapshot | Update a historical table |