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.
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?
tags Computer Architecture Computer Science 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.