database

Data and Reality: A Timeless Perspective on Perceiving and Managing Information in Our Imprecise World

July 13, 2020
reading, books, database

tags Database Computer Science READING Data and Reality: A Timeless Perspective on Perceiving and Managing Information in Our Imprecise World # Table 1: Clock summary at [2020-07-13 Mon 08:05] Headline Time Total time 1:01 Data and Reality: A Timeless… 1:01 :BOOK_CATEGORY: Database, software architecture, software engineering :BOOK_AUTHORS: William Kent :START_DATE:<2020-07-12 Sun> :END_DATE: nil :URL: https://www. ...

Database

June 21, 2020
database, cs

Notes from Data and Reality: A Timeless Perspective on Perceiving and Managing Information in Our Imprecise World William tries to approach data towards how we perceive the world. The following key concepts can be considered in data modeling as to our inner domain. Existence: To what extend are you really present and engaged in the process of life around yourself? How real are the physical things around you? Identity: Who are you? ...

List Foreign key constrants defined in a database

June 21, 2020
sql, programming, database

tags Programming Code snippets Postgres Postgres View foreign key constrants defined in all databases select kcu.table_schema || '.' ||kcu.table_name as foreign_table, '>-' as rel, rel_tco.table_schema || '.' || rel_tco.table_name as primary_table, string_agg(kcu.column_name, ', ') as fk_columns, kcu.constraint_name from information_schema.table_constraints tco join information_schema.key_column_usage kcu on tco.constraint_schema = kcu.constraint_schema and tco.constraint_name = kcu.constraint_name join information_schema.referential_constraints rco on tco.constraint_schema = rco.constraint_schema and tco.constraint_name = rco.constraint_name join information_schema.table_constraints rel_tco on rco.unique_constraint_schema = rel_tco. ...