Timeline

07/02/26:

10:39 AdvancedTopic edited by 231082

(diff)

10:24 DDL_optimized.sql attached to AdvancedTopic by 231082

The DDL from the Advanced Topic.

10:19 AdvancedTopic edited by 231082

(diff)

10:10 DatabaseProgramming edited by 231082

(diff)

07/01/26:

23:29 AdvancedTopic created by 231082

18:30 meta-functions.sql attached to DatabaseProgramming by 231082

Helper (meta) functions.

18:29 triggers.sql attached to DatabaseProgramming by 231082

Triggers.

18:29 procedures.sql attached to DatabaseProgramming by 231082

Procedures.

18:29 functions.sql attached to DatabaseProgramming by 231082

Functions.

18:29 meta-functions.sql attached to QueryOptimization by 231082

Functional optimization of the two VIEWs.

18:28 testing.sql attached to QueryOptimization by 231082

Code for prototyping optimization.

18:27 analytical_views.sql attached to DatabaseCreation by 231082

Analytical VIEWs.

18:27 pure_views.sql attached to DatabaseCreation by 231082

Non-analytical VIEWs.

18:26 DDL_VP.sql attached to DatabaseCreation by 231082

DDL generated automatically from the diagrams in Visual Paradigm.

18:26 DDL_OSDM.sql attached to DatabaseCreation by 231082

DDL generated automatically from the diagrams in Oracle SQL Developer …

18:25 DDL_manual.sql attached to DatabaseCreation by 231082

Manually written DDL.

18:24 WikiStart edited by 231082

(diff)

18:13 QueryOptimization edited by 231082

(diff)

18:12 QueryOptimization edited by 231082

(diff)

18:06 AboutProject edited by 231082

(diff)

18:03 QueryOptimization edited by 231082

(diff)

18:01 DatabaseProgramming created by 231082

preliminary

17:46 DatabaseCreation edited by 231082

(diff)

17:42 DatabaseCreation created by 231082

preliminary

16:10 RelationalModel edited by 231082

(diff)

16:09 RelationalModel-CMS-OSDM.svg attached to RelationalModel by 231082

The relational diagram of the model, exported from Oracle SQL …

16:09 LogicalModel-CMS-OSDM.svg attached to RelationalModel by 231082

The logical diagram of the model, exported from Oracle SQL Developer …

16:08 RelationalModel-CMS-SurrogateKeys.vpp attached to RelationalModel by 231082

The version consisting of surrogate keys of the relational model, …

16:08 RelationalModel-CMS-IdentifyingRelationships.vpp attached to RelationalModel by 231082

The version consisting of composite natural keys & correct identifying …

16:07 RelationalModel-CMS-SurrogateKeys.svg attached to RelationalModel by 231082

The version consisting of surrogate keys of the relational model, …

16:07 RelationalModel-CMS-IdentifyingRelationships.svg attached to RelationalModel by 231082

The version consisting of composite natural keys & correct identifying …

16:04 WikiStart edited by 231082

(diff)