A multi-part series of videos about Canadian trademark data, which is made freely available in XML form by the Canadian Intellectual Property Office (“CIPO”).
• Part 1 describes the data and where to get it.
• Part 2 discusses getting the data into a database via "XML shredding".
• Part 3 explains a possible multi-dimensional data warehouse structure.
• Part 4 demonstrates user interaction, via a GUI front end, with a data warehouse incorporating details of 1,698,954 Canadian marks.
• Part 5 demonstrates derivation of business intelligence from an OLAP cube based on the data warehouse.
• Part 6 demonstrates a report server for deriving business intelligence reports from the data warehouse.
• Part 7 discusses some possible next steps.