VbzCart/docs/tables/cache flow: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
m (moved VbzCart/tables/data flow to VbzCart/tables/cache flow: rewriting caching processes)
imported>Woozle
(updated purpose)
Line 1: Line 1:
==About==
==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
* '''Refers to''': {{vbzcart|table|cache_tables}}, {{vbzcart|table|cache_queries}}
* '''Refers to''': {{vbzcart|table|cache_tables}}, {{vbzcart|table|cache_queries}}
* '''History''':
* '''History''':

Revision as of 14:19, 9 November 2010

About

  • Purpose: Keeps track of data dependencies between tables – which queries update cached data in which tables from which sources
  • Refers to: Template:Vbzcart, Template:Vbzcart
  • History:
    • 2010-11-09 Renamed data_flow -> cache_flow; ID_Proc -> ID_Query

SQL

<section begin=sql /><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>

<section end=sql />