Difference between revisions of "VbzCart/tables/cache flow"

Latest revision as of 22:26, 13 November 2010

About

Purpose: Keeps track of data dependencies between tables – which queries update cached data in which tables from which sources
Used by :

REDIRECT Template:l/vc/query

Refers to: cache_tables, cache_queries
Fields:
- doWrite: TRUE = ID_Table is written to (i.e. TARGET table); otherwise it is only read from (SOURCE).
Notes:
- If it turns out that some tables are both read and written, then we might want a doRead field as well.
History:
- 2010-11-09 Renamed data_flow -> cache_flow; ID_Proc -> ID_Query
- 2010-11-13 Significant revision: ID_Srce/ID_Dest replaced by ID_Table/doWrite

SQL

<mysql>CREATE TABLE `cache_flow` (

   ID_Proc INT NOT NULL COMMENT "cache_queries.ID of stored procedure which calculates Dest data from Srce data",
   ID_Table INT NOT NULL COMMENT "cache_tables.ID of a table",
   doWrite BOOL COMMENT "TRUE = writes to this table",
   Notes   VARCHAR(255) COMMENT "loose explanatory or descriptive notes",
   PRIMARY KEY (`ID_Query`,`ID_Table`)
) ENGINE = MYISAM;</mysql>

previous version

<mysql>CREATE TABLE `cache_flow` (

   ID_Srce INT NOT NULL COMMENT "cache_tables.ID of SOURCE table",
   ID_Dest INT NOT NULL COMMENT "cache_tables.ID of DESTINATION table",
   ID_Query INT NOT NULL COMMENT "cache_queries.ID of stored procedure which calculates Dest data from Srce data",
   Notes   VARCHAR(255) COMMENT "loose explanatory or descriptive notes",
   PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Query`)
) ENGINE = MYISAM;</mysql>

@@ Line 1: / Line 1: @@
 ==About==
-* '''Purpose''': Keeps track of data dependencies between tables &ndash; which procs update which caches from which sources
+* '''Purpose''': Keeps track of data dependencies between tables &ndash; which queries update cached data in which tables from which sources
+* '''Used by ''': {{vbzcart/query|qryCache_Flow_Procs}}
+* '''Refers to''': {{vbzcart|table|cache_tables}}, {{vbzcart|table|cache_queries}}
+* '''Fields''':
+** '''doWrite''': TRUE = ID_Table is ''written'' to (i.e. TARGET table); otherwise it is only ''read'' from (SOURCE).
+* '''Notes''':
+** If it turns out that some tables are both read and written, then we might want a doRead field as well.
+* '''History''':
+** '''2010-11-09''' Renamed data_flow -> cache_flow; ID_Proc -> ID_Query
+** '''2010-11-13''' Significant revision: ID_Srce/ID_Dest replaced by ID_Table/doWrite
 ==SQL==
-<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_flow`;
+<section begin=sql /><mysql>CREATE TABLE `cache_flow` (
+     ID_Proc INT NOT NULL COMMENT "cache_queries.ID of stored procedure which calculates Dest data from Srce data",
-CREATE TABLE `data_flow` (
+     ID_Table INT NOT NULL COMMENT "cache_tables.ID of a table",
-     ID_Srce INT NOT NULL COMMENT "data_tables.ID of SOURCE table",
+     doWrite BOOL COMMENT "TRUE = writes to this table",
-     ID_Dest INT NOT NULL COMMENT "data_tables.ID of DESTINATION table",
+     Notes   VARCHAR(255) COMMENT "loose explanatory or descriptive notes",
-     ID_Proc INT NOT NULL COMMENT "data_procs.ID of stored procedure which calculates Dest data from Srce data",
+     PRIMARY KEY (`ID_Query`,`ID_Table`)
-     Notes varchar(255) COMMENT "loose explanatory or descriptive notes",
-     PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Proc`)
   ) ENGINE = MYISAM;</mysql>
 <section end=sql />
+===previous version===
+<mysql>CREATE TABLE `cache_flow` (
+    ID_Srce INT NOT NULL COMMENT "cache_tables.ID of SOURCE table",
+    ID_Dest INT NOT NULL COMMENT "cache_tables.ID of DESTINATION table",
+    ID_Query INT NOT NULL COMMENT "cache_queries.ID of stored procedure which calculates Dest data from Srce data",
+    Notes   VARCHAR(255) COMMENT "loose explanatory or descriptive notes",
+    PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Query`)
+ ) ENGINE = MYISAM;</mysql>

Difference between revisions of "VbzCart/tables/cache flow"

Latest revision as of 22:26, 13 November 2010

About

SQL

previous version

Navigation menu

Search