Relational Data Models

[Up] [Top]

Documentation for package ‘dm’ version 0.2.1

Help Pages

A C D E F G H I L M N P R S T U V

-- A --

anti_join.zoomed_dm 'dplyr' join methods for zoomed dm objects
arrange.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects
as_dm Data model class

-- C --

check_cardinality_0_1 Check table relations
check_cardinality_0_n Check table relations
check_cardinality_1_1 Check table relations
check_cardinality_1_n Check table relations
check_key Check if column(s) can be used as keys
check_set_equality Check column values for set equality
check_subset Check column values for subset
collect.dm Materialize
compute.dm Materialize
compute.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects
copy_dm_to Copy data model to data source
count.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects

-- D --

decompose_table Decompose a table into two linked tables
distinct.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects
dm Data model class
dm_add_fk Add foreign keys
dm_add_pk Add a primary key
dm_add_tbl Add tables to a 'dm'
dm_apply_filters Filtering
dm_apply_filters_to_tbl Filtering
dm_bind Merge several 'dm'
dm_disambiguate_cols Resolve column name ambiguities
dm_discard_zoomed Mark table for manipulation
dm_draw Draw a diagram of the data model
dm_enum_fk_candidates Foreign key candidates
dm_enum_pk_candidates Primary key candidate
dm_examine_constraints Validate your data model
dm_filter Filtering
dm_financial Creates a dm object for the Financial data
dm_financial_sqlite Creates a dm object for the Financial data
dm_flatten_to_tbl Flatten a part of a 'dm' into a wide table
dm_from_src Load a dm from a remote data source
dm_get_all_fks Get foreign key constraints
dm_get_all_pks Get all primary keys of a 'dm' object
dm_get_available_colors Color in database diagrams
dm_get_colors Color in database diagrams
dm_get_con Data model class
dm_get_filters Get filter expressions
dm_get_referencing_tables Get the names of referencing tables
dm_get_tables Data model class
dm_has_pk Check for primary key
dm_insert_zoomed Mark table for manipulation
dm_is_referenced Check foreign key reference
dm_join_to_tbl Join two tables
dm_mutate_tbl Update tables in a 'dm'
dm_nrow Number of rows
dm_nycflights13 Creates a dm object for the 'nycflights13' data
dm_paste Create R code for a dm object
dm_ptype Prototype for a dm object
dm_rename Rename columns
dm_rename_tbl Select and rename tables
dm_rm_fk Remove foreign keys
dm_rm_pk Remove a primary key
dm_rm_tbl Remove tables
dm_rows_delete Modifying rows for multiple tables
dm_rows_insert Modifying rows for multiple tables
dm_rows_patch Modifying rows for multiple tables
dm_rows_truncate Modifying rows for multiple tables
dm_rows_update Modifying rows for multiple tables
dm_rows_upsert Modifying rows for multiple tables
dm_select Select columns
dm_select_tbl Select and rename tables
dm_set_colors Color in database diagrams
dm_squash_to_tbl Flatten a part of a 'dm' into a wide table
dm_update_zoomed Mark table for manipulation
dm_zoom_to Mark table for manipulation
dplyr_join 'dplyr' join methods for zoomed dm objects
dplyr_table_manipulation 'dplyr' table manipulation methods for zoomed dm objects

-- E --

enum_fk_candidates Foreign key candidates
enum_pk_candidates Primary key candidate
examine_cardinality Check table relations

-- F --

filter.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects
full_join.zoomed_dm 'dplyr' join methods for zoomed dm objects

-- G --

group_by.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects

-- H --

head.zoomed_dm 'utils' table manipulation methods for 'zoomed_dm' objects

-- I --

inner_join.zoomed_dm 'dplyr' join methods for zoomed dm objects
is_dm Data model class

-- L --

left_join.zoomed_dm 'dplyr' join methods for zoomed dm objects

-- M --

materialize Materialize
mutate.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects

-- N --

new_dm Data model class

-- P --

pull.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects
pull_tbl Retrieve a table

-- R --

rename.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects
reunite_parent_child Merge two tables that are linked by a foreign key relation
reunite_parent_child_from_list Merge two tables that are linked by a foreign key relation
right_join.zoomed_dm 'dplyr' join methods for zoomed dm objects
rows-db Updating database tables
rows-dm Modifying rows for multiple tables
rows_insert.tbl_dbi Updating database tables
rows_truncate Truncate all rows
rows_update.tbl_dbi Updating database tables

-- S --

select.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects
semi_join.zoomed_dm 'dplyr' join methods for zoomed dm objects
separate.zoomed_dm 'tidyr' table manipulation methods for zoomed dm objects
slice.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects
sql_rows_insert Updating database tables
sql_rows_truncate Truncate all rows
sql_rows_update Updating database tables
sql_schema_create Create a schema on a database
sql_schema_drop Remove a schema from a database
sql_schema_exists Check for existence of a schema on a database
sql_schema_list List schemas on a database
summarise.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects

-- T --

tail.zoomed_dm 'utils' table manipulation methods for 'zoomed_dm' objects
tally.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects
tidyr_table_manipulation 'tidyr' table manipulation methods for zoomed dm objects
transmute.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects

-- U --

ungroup.zoomed_dm 'dplyr' table manipulation methods for zoomed dm objects
unite.zoomed_dm 'tidyr' table manipulation methods for zoomed dm objects

-- V --

validate_dm Data model class