Consolidating data across regions or international borders requires careful assessment of data warehouse models. Government and public sector organizations have faced the problem of reporting and analysis across regions and countries for decades. Combining data from different cultures, jurisdictions, time zones, alphabets, and platforms is always highly challenging. However, there are ways to address these challenges.
Before designing a data warehouse for any multinational entity, architects need to ensure there is real business value for creating one in the first place. In the case of the Comparative Constitution initiative, the challenge was consolidating the world’s constitutions into a semantic data lake for centralized faceted search.
University of Texas, University of Chicago, University College, London
Constitutional design and redesign is constant. Over the last 200 years, countries have replaced their constitutions an average of every 19 years and some have amended them almost yearly. A basic problem in the drafting of these documents is the search and analysis of model text deployed in other jurisdictions. Traditionally, this process has been ad hoc and the results suboptimal. As a result, drafters generally lack systematic information about the institutional options and choices available to them.
Capsenta Ultrawrap™ was chosen as the solution of choice to integrate the world’s constitution into a single unified semantic endpoint for contextual searching. The Constitute Project was launched at the General Assembly of the United Nations in 2013 and continues to integrate over 196 current databases of all of the world’s constitutions on the web. This public site is available to the world market at http://www.constituteproject.org. Numerous countries throughout the world have taken advantage of this free service to modify and develop their countries constitutions.
Speed to Market: Reduced time to launch from 10 months with 9 FTEs assigned to 6 1/4 days for full faceted search.
Operational Efficiency: Eliminated the need for manual data processing of constitutional data to an automated process.
Language Extensibility – Multi-lingual capability enables mutliple nationalities to leverage the power of semantic search
If not for the differentiated ability of the Capsenta’s Ultrawrap(TM) solution to enrich the data with semantics, the integration and faceted search of disparate constitutional data would have not been possible.”
Dr Zachary Elkins, PhD, Comparative Constitutions Project Lead and Professor of Government, University of Texas