{"id":39478,"date":"2020-08-08T17:36:03","date_gmt":"2020-08-08T16:36:03","guid":{"rendered":"https:\/\/itrc-2020.ouce.ox.ac.uk\/?page_id=39478"},"modified":"2020-09-24T20:13:06","modified_gmt":"2020-09-24T19:13:06","slug":"databases","status":"publish","type":"page","link":"https:\/\/www.itrc.org.uk\/themes\/databases\/","title":{"rendered":"Databases"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.2.2″ background_color=”#636363″ background_color_gradient_direction=”160deg” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2020\/06\/infrastructure-e1593363350576.jpg” background_blend=”multiply” custom_margin=”||||false|false” animation_style=”fade”][et_pb_row _builder_version=”3.26.6″][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_6_font=”|700|||||||” header_6_text_color=”#fe6223″ background_layout=”dark”]<\/p>\n

THEMES<\/h6>\n

[\/et_pb_text][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” background_layout=”dark” custom_margin=”-40px|||||”]<\/p>\n

DATABASES<\/h1>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row module_id=”navigation-strip” _builder_version=”4.2.2″][et_pb_column type=”4_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ header_4_text_color=”#ffffff” header_4_font_size=”17px”]<\/p>\n

Addressing the need to be able to securely store and manage the multi-scale hetrogenous data required for complex household level infrastructure modelling, NISMOD-DB++ has been developed to provide a key national resource for infrastructure related data, developing novel data handling methods and techniques.<\/h4>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.2.2″ background_color=”rgba(0,0,0,0)” custom_padding=”0px||0px||false|false”][et_pb_row column_structure=”1_5,1_5,1_5,1_5,1_5″ _builder_version=”4.2.2″ custom_margin=”-24px|auto||auto||” custom_padding=”0px||0px||false|false” link_option_url=”#navigation-strip”][et_pb_column type=”1_5″ _builder_version=”4.2.2″][et_pb_button button_url=”#introduction” button_text=”Introduction” button_alignment=”center” module_class=”full-width-btn” _builder_version=”4.2.2″ background_layout=”dark”][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_5″ _builder_version=”4.2.2″][et_pb_button button_url=”#results” button_text=”Results” module_class=”full-width-btn” _builder_version=”4.2.2″ positioning=”relative” background_layout=”dark”][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_5″ _builder_version=”4.2.2″][et_pb_button button_url=”#applications” button_text=”Applications” module_class=”full-width-btn” _builder_version=”4.2.2″ background_layout=”dark”][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_5″ _builder_version=”4.2.2″][et_pb_button button_url=”#models” button_text=”Models” button_alignment=”center” module_class=”full-width-btn” _builder_version=”4.2.2″ background_layout=”dark” hover_enabled=”0″][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_5″ _builder_version=”4.2.2″][et_pb_button button_url=”#resources” button_text=”Resources” button_alignment=”center” module_class=”full-width-btn” _builder_version=”4.2.2″ background_layout=”dark” hover_enabled=”0″][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ module_id=”introduction” _builder_version=”4.2.2″ background_enable_color=”off” animation_direction=”left” z_index_tablet=”500″ border_color_all=”#ffffff” border_width_top=”20px” border_width_right=”20px” border_width_left=”20px” border_width_top_tablet=”20px” border_width_top_phone=”20px” border_width_right_tablet=”20px” border_width_right_phone=”20px” border_width_left_tablet=”20px” border_width_left_phone=”20px” box_shadow_horizontal_tablet=”0px” box_shadow_vertical_tablet=”0px” box_shadow_blur_tablet=”40px” box_shadow_spread_tablet=”0px” locked=”off”][et_pb_row _builder_version=”4.2.2″ custom_padding=”||30px|||” animation_style=”slide” animation_direction=”left” animation_intensity_slide=”4%”][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_6_font=”|700|||||||” header_6_text_color=”#fe6223″ background_layout=”dark”]<\/p>\n

DATABASES<\/h6>\n

[\/et_pb_text][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_3_font=”|700||on|||||” header_3_text_color=”#3c3c3c” header_4_text_color=”#3c3c3c” background_layout=”dark” custom_margin=”-40px|||||”]<\/p>\n

INTRODUCTION<\/h3>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.2.2″ custom_padding=”0px|||||”][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_text _builder_version=”4.2.2″ text_text_color=”#3c3c3c” header_text_color=”#fe6223″ header_4_font_size=”19px” header_4_line_height=”1.7em” header_5_text_color=”#fe6223″ max_width=”100%” custom_margin=”|-384px||||” custom_padding=”|0px||||”]Underpinning modelling and analysis, data is a vital resource, and easy, efficient and secure access is essential for all modelling purposes. Developing a database which enables this, while ensuring data providers are confident in the data management and security protocols in place requires complex solutions.<\/p>\n

Using emerging technologies, a federated databases is employed allowing data to be stored across multiple databases, yet remain accessable, facilitating different types of databases (relational, graph, array) with varying storage methods to be used for improve data and access efficiency, while also enabling methods of ensuring access requirements for datasets can be implemented with more ease.<\/p>\n

Through the provision of an API (Application Programming Interface) access to the data is enabled for modellers and others developing code based applications with data returned in JSON\/GeoJSON allowing data to be injested straigt from the API into models and for analysis, improving the potential scalability of the developed code. Data can also be returned in other formats for more easy injestion into other appliations, including as ESRI Shapefiles and GeoPackages, more suitable for software based GIS applications.<\/p>\n

An associated web-interface allows users to view, query and download data using an easy-to-use interface. Built on the API and a GeoServer instance, this allows users to query data based on locations\/boundaries, as well as on attributes, enabling use of this data resource for those wihout the need to engage in code development. Both these endpoints, the API and web-interface, utilise the developed security and metadata protocols, enabling users to only access data they have been granted permission to do so.<\/p>\n

The data available continues to evolve as new datasets are added, new versions of existing datasests are added, and data licensing is updated opening up new data to users.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.26.6″][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_button button_url=”#navigation-strip” button_text=”Back to top” button_alignment=”right” _builder_version=”4.2.2″ custom_button=”on” button_text_size=”14px” button_border_radius=”60px” button_font=”|700|||||||” button_icon=”%%0%%” button_icon_color=”#ffffff” button_on_hover=”off” background_layout=”dark”]
\n[\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ module_id=”results” _builder_version=”4.2.2″ background_color=”#f1f9fa” custom_padding=”||60px|||” animation_direction=”left” z_index_tablet=”500″ border_color_all=”#ffffff” border_width_top=”20px” border_width_right=”20px” border_width_left=”20px” border_width_top_tablet=”20px” border_width_top_phone=”20px” border_width_right_tablet=”20px” border_width_right_phone=”20px” border_width_left_tablet=”20px” border_width_left_phone=”20px” box_shadow_horizontal_tablet=”0px” box_shadow_vertical_tablet=”0px” box_shadow_blur_tablet=”40px” box_shadow_spread_tablet=”0px”][et_pb_row _builder_version=”3.26.6″ custom_padding=”||30px|||” animation_style=”slide” animation_direction=”left” animation_intensity_slide=”4%”][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_6_font=”|700|||||||” header_6_text_color=”#fe6223″ background_layout=”dark”]<\/p>\n

DATABASES<\/h6>\n

[\/et_pb_text][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_3_font=”|700||on|||||” header_3_text_color=”#3c3c3c” header_4_text_color=”#3c3c3c” background_layout=”dark” custom_margin=”-40px|||||”]<\/p>\n

RESULTS<\/h3>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ use_custom_gutter=”on” gutter_width=”2″ make_equal=”on” _builder_version=”4.2.2″ background_color=”rgba(0,0,0,0)” custom_margin=”||50px||false|false” custom_padding=”0px||0px||true|false” border_radii=”on|6px|6px|6px|6px” border_color_all=”#d6d6d6″ border_width_bottom=”0px” border_color_bottom=”#006f74″][et_pb_column type=”1_3″ _builder_version=”4.2.2″ background_color=”#ffffff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|6px|6px|6px|6px” border_width_all=”1px” border_color_all=”#d6d6d6″ border_width_bottom=”5px” border_color_bottom=”#fe6223″][et_pb_blurb _builder_version=”4.2.2″ header_font=”|600|||||||” header_line_height=”2.3em” custom_margin=”||||false|false” custom_padding=”||80px||false|false”]A flexible and extendable database of data for national infrastructure research with over 600 datasets stored efficiently for data management and access, utilising a range of database software and methodologies.[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.2.2″ background_color=”#ffffff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|6px|6px|6px|6px” border_width_all=”1px” border_color_all=”#d6d6d6″ border_width_bottom=”5px” border_color_bottom=”#fe6223″][et_pb_blurb _builder_version=”4.2.2″ header_font=”|600|||||||” header_line_height=”2.3em” custom_margin=”||||false|false” custom_padding=”||||false|false”]<\/p>\n

A application programming interface enabling secure access to data from directly within models facilitating more scaleable modelling approaches. Users are able to develop API calls through live-online documentation, and deploy within their models to retrieve available datasets required for their own models in a flexible manner which provides an easy scaleable solution. Data is made made available in a range of formats, from JSON, to ESRI shapefiles and GeoPackages. A suite of online pages also allow users to view their API call history, enabling the re-use of previous calls they have made.<\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.2.2″ background_color=”#ffffff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|6px|6px|6px|6px” border_width_all=”1px” border_color_all=”#d6d6d6″ border_width_bottom=”5px” border_color_bottom=”#fe6223″][et_pb_blurb _builder_version=”4.2.2″ header_font=”|600|||||||” header_line_height=”2.3em” custom_margin=”||||false|false” custom_padding=”||||false|false”]User focused web-interface for easily viewing, downloading and querying data within the developed database from within a web browser. Allows users to build queries to explore data within the database, using data in the database or a user-created boundary, to filter data based on boundaries or values (attributes). Data can be viewed online and also downloaded in a range of formats, for custom maps or use in modelling.[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.26.6″][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_button button_url=”#navigation-strip” button_text=”Back to top” button_alignment=”right” _builder_version=”4.2.2″ custom_button=”on” button_text_size=”14px” button_border_radius=”60px” button_font=”|700|||||||” button_icon=”%%0%%” button_icon_color=”#ffffff” button_on_hover=”off” background_layout=”dark”]
\n[\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ module_id=”applications” _builder_version=”4.2.2″ background_color=”#006f74″ custom_padding=”||60px|||” animation_direction=”left” z_index_tablet=”500″ border_color_all=”#ffffff” border_width_top=”20px” border_width_right=”20px” border_width_left=”20px” border_width_top_tablet=”20px” border_width_top_phone=”20px” border_width_right_tablet=”20px” border_width_right_phone=”20px” border_width_left_tablet=”20px” border_width_left_phone=”20px” box_shadow_horizontal_tablet=”0px” box_shadow_vertical_tablet=”0px” box_shadow_blur_tablet=”40px” box_shadow_spread_tablet=”0px”][et_pb_row _builder_version=”3.26.6″ custom_padding=”||30px|||” animation_style=”slide” animation_direction=”left” animation_intensity_slide=”4%”][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_6_font=”|700|||||||” header_6_text_color=”#fe6223″ background_layout=”dark”]<\/p>\n

DATABASES<\/h6>\n

[\/et_pb_text][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_3_font=”|700||on|||||” header_3_text_color=”#ffffff” header_4_text_color=”#3c3c3c” background_layout=”dark” custom_margin=”-40px|||||”]<\/p>\n

APPLICATIONS<\/h3>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ use_custom_gutter=”on” gutter_width=”2″ make_equal=”on” _builder_version=”4.2.2″ background_color=”rgba(0,0,0,0)” custom_margin=”||50px||false|false” custom_padding=”0px||0px||true|false” border_radii=”on|6px|6px|6px|6px” border_color_all=”#d6d6d6″ border_width_bottom=”0px” border_color_bottom=”#006f74″][et_pb_column type=”1_3″ _builder_version=”4.2.2″ background_color=”#ffffff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|6px|6px|6px|6px” border_width_all=”1px” border_color_all=”#d6d6d6″ border_width_bottom=”5px” border_color_bottom=”#fe6223″][et_pb_blurb title=”Multi-source access” use_icon=”on” font_icon=”%%77%%” icon_color=”#ffffff” use_circle=”on” circle_color=”#006f74″ _builder_version=”4.2.2″ header_font=”|600|||||||” custom_margin=”||||false|false” custom_padding=”||80px||false|false”]Through the developed database, API and web-interface, users have a location whereby they can locate and access data required for their modelling and data requirements, from a range of sources.[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.2.2″ background_color=”#ffffff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|6px|6px|6px|6px” border_width_all=”1px” border_color_all=”#d6d6d6″ border_width_bottom=”5px” border_color_bottom=”#fe6223″][et_pb_blurb title=”Complex security layer” use_icon=”on” font_icon=”%%287%%” icon_color=”#ffffff” use_circle=”on” circle_color=”#006f74″ _builder_version=”4.2.2″ header_font=”|600|||||||” custom_margin=”||||false|false” custom_padding=”||||false|false”]The developed database, through utilising emerging databases technologies, such as graph databases and database federation, enables fast and efficient access to key datasets, while a complex security layer ensures users can only access data they are allowed to. [\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.2.2″ background_color=”#ffffff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|6px|6px|6px|6px” border_width_all=”1px” border_color_all=”#d6d6d6″ border_width_bottom=”5px” border_color_bottom=”#fe6223″][et_pb_blurb title=”National Infrastructure Database” use_icon=”on” font_icon=”%%144%%” icon_color=”#ffffff” use_circle=”on” circle_color=”#006f74″ _builder_version=”4.2.2″ header_font=”|600|||||||” custom_margin=”||||false|false” custom_padding=”||||false|false”]The developed database will be deployed onto DAFNI (web link), forming a key part of the NID (National Infrasturcture Database), a national resource for infrastructure research. [\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.26.6″][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_button button_url=”#navigation-strip” button_text=”Back to top” button_alignment=”right” _builder_version=”4.2.2″ custom_button=”on” button_text_size=”14px” button_border_radius=”60px” button_font=”|700|||||||” button_icon=”%%0%%” button_icon_color=”#ffffff” button_on_hover=”off” background_layout=”dark”]
\n[\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ module_id=”models” _builder_version=”4.2.2″ background_color=”#f1f9fa” animation_direction=”left” hover_enabled=”0″ z_index_tablet=”500″ border_color_all=”#ffffff” border_width_top=”20px” border_width_right=”20px” border_width_left=”20px” border_width_top_tablet=”20px” border_width_top_phone=”20px” border_width_right_tablet=”20px” border_width_right_phone=”20px” border_width_left_tablet=”20px” border_width_left_phone=”20px” box_shadow_horizontal_tablet=”0px” box_shadow_vertical_tablet=”0px” box_shadow_blur_tablet=”40px” box_shadow_spread_tablet=”0px” locked=”off”][et_pb_row _builder_version=”3.26.6″ custom_padding=”||30px|||” animation_style=”slide” animation_direction=”left” animation_intensity_slide=”4%”][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_6_font=”|700|||||||” header_6_text_color=”#fe6223″ background_layout=”dark”]<\/p>\n

DATABASES<\/h6>\n

[\/et_pb_text][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_3_font=”|700||on|||||” header_3_text_color=”#3c3c3c” header_4_text_color=”#3c3c3c” background_layout=”dark” custom_margin=”-40px|||||”]<\/p>\n

MODELS<\/h3>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_2,1_2″ use_custom_gutter=”on” gutter_width=”1″ make_equal=”on” _builder_version=”4.2.2″ background_color=”rgba(0,0,0,0)” custom_margin=”||50px||false|false” custom_padding=”0px||0px||true|false”][et_pb_column type=”1_2″ _builder_version=”4.2.2″ background_color=”#006f74″ custom_padding=”30px|30px|30px|30px|true|true”][et_pb_blurb title=”NISMOD-DB API” _builder_version=”4.2.2″ header_level=”h6″ header_font=”|700|||||||” header_text_color=”#fe6223″ header_font_size=”19px” background_layout=”dark” custom_padding=”||50px||false|false”]<\/p>\n

A application programming interface for access to the datasets within NISMOD-DB++ for modelling and other purposes.<\/p>\n

[\/et_pb_blurb][et_pb_button button_url=”http:\/\/www.nismod.ac.uk\/api” url_new_window=”on” button_text=”Learn more” button_alignment=”center” _builder_version=”4.2.2″ custom_button=”on” button_text_color=”#ffffff” button_bg_color=”#fe6223″ button_border_color=”#fe6223″ button_icon=”%%20%%” button_icon_color=”#ffffff” button_on_hover=”off” positioning=”absolute” position_origin_a=”bottom_right” background_layout=”dark” custom_margin=”35px||||false|false”][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.2.2″ background_color=”#ffffff” custom_padding=”30px|30px|30px|30px|true|true”][et_pb_blurb title=”NISMOD-DB Query Tool” _builder_version=”4.2.2″ header_level=”h6″ header_font=”|700|||||||” header_text_color=”#fe6223″ header_font_size=”19px” custom_padding=”||50px||false|false”]<\/p>\n

A user interface and query buildier for viewing, querying and downloading datasets within NISMOD-DB++.<\/p>\n

[\/et_pb_blurb][et_pb_button button_url=”https:\/\/www.nismod.ac.uk\/querytool” url_new_window=”on” button_text=”Learn more” button_alignment=”center” _builder_version=”4.2.2″ custom_button=”on” button_text_color=”#ffffff” button_bg_color=”#006f74″ button_border_color=”#006f74″ button_icon=”%%20%%” button_icon_color=”#ffffff” button_on_hover=”off” positioning=”absolute” position_origin_a=”bottom_right” background_layout=”dark” custom_margin=”35px||||false|false”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.26.6″][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_button button_url=”#navigation-strip” button_text=”Back to top” button_alignment=”right” _builder_version=”4.2.2″ custom_button=”on” button_text_size=”14px” button_border_radius=”60px” button_font=”|700|||||||” button_icon=”%%0%%” button_icon_color=”#ffffff” button_on_hover=”off” background_layout=”dark”]
\n[\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ module_id=”resources” _builder_version=”4.2.2″ background_color=”#006f74″ animation_direction=”left” hover_enabled=”0″ z_index_tablet=”500″ border_color_all=”#ffffff” border_width_top=”20px” border_width_right=”20px” border_width_left=”20px” border_width_top_tablet=”20px” border_width_top_phone=”20px” border_width_right_tablet=”20px” border_width_right_phone=”20px” border_width_left_tablet=”20px” border_width_left_phone=”20px” box_shadow_horizontal_tablet=”0px” box_shadow_vertical_tablet=”0px” box_shadow_blur_tablet=”40px” box_shadow_spread_tablet=”0px” locked=”off”][et_pb_row _builder_version=”3.26.6″ custom_padding=”||30px|||” animation_style=”slide” animation_direction=”left” animation_intensity_slide=”4%”][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_6_font=”|700|||||||” header_6_text_color=”#fe6223″ background_layout=”dark”]<\/p>\n

DATABASES<\/h6>\n

[\/et_pb_text][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_3_font=”|700||on|||||” header_3_text_color=”#ffffff” header_4_text_color=”#3c3c3c” background_layout=”dark” custom_margin=”-40px|||||”]<\/p>\n

RESOURCES<\/h3>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ use_custom_gutter=”on” gutter_width=”2″ make_equal=”on” _builder_version=”4.2.2″ background_color=”rgba(0,0,0,0)” custom_margin=”||50px||false|false” custom_padding=”0px||0px||true|false” border_radii=”on|6px|6px|6px|6px” border_color_all=”#d6d6d6″ border_width_bottom=”0px” border_color_bottom=”#006f74″][et_pb_column type=”1_3″ _builder_version=”4.2.2″ background_color=”#ffffff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|6px|6px|6px|6px” border_width_all=”1px” border_color_all=”#d6d6d6″ border_width_bottom=”5px” border_color_bottom=”#fe6223″][et_pb_blurb image=”https:\/\/itrc-2020.ouce.ox.ac.uk\/wp-content\/uploads\/2020\/09\/themes_databases_fig2.jpg” _builder_version=”4.2.2″ header_font=”|600|||||||” header_line_height=”2.3em” custom_margin=”||||false|false” custom_padding=”||||false|false”]<\/p>\n

NISMOD DB++ Architecture<\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.2.2″ background_color=”#ffffff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|6px|6px|6px|6px” border_width_all=”1px” border_color_all=”#d6d6d6″ border_width_bottom=”5px” border_color_bottom=”#fe6223″][et_pb_blurb image=”https:\/\/itrc-2020.ouce.ox.ac.uk\/wp-content\/uploads\/2020\/09\/themes_databases_fig1.png” _builder_version=”4.2.2″ header_font=”|600|||||||” header_line_height=”2.3em” custom_margin=”||||false|false” custom_padding=”||||false|false”]<\/p>\n

A closer look at the Mistral Query Builder\u00a0<\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.2.2″ background_color=”#ffffff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|6px|6px|6px|6px” border_width_all=”1px” border_color_all=”#d6d6d6″ border_width_bottom=”5px” border_color_bottom=”#fe6223″][et_pb_blurb image=”https:\/\/itrc-2020.ouce.ox.ac.uk\/wp-content\/uploads\/2020\/09\/themes_databases_fig3.png” _builder_version=”4.2.2″ header_font=”|600|||||||” header_line_height=”2.3em” custom_margin=”||||false|false” custom_padding=”||||false|false”]<\/p>\n

NISMOD DB++ explained<\/p>\n

[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.26.6″][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_button button_url=”#navigation-strip” button_text=”Back to top” button_alignment=”right” _builder_version=”4.2.2″ custom_button=”on” button_text_size=”14px” button_border_radius=”60px” button_font=”|700|||||||” button_icon=”%%0%%” button_icon_color=”#ffffff” button_on_hover=”off” background_layout=”dark”]
\n[\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ module_id=”casestudies” _builder_version=”4.2.2″ background_color=”#ffffff” animation_direction=”left” z_index_tablet=”500″ border_color_all=”#ffffff” border_width_top=”20px” border_width_right=”20px” border_width_left=”20px” border_width_top_tablet=”20px” border_width_top_phone=”20px” border_width_right_tablet=”20px” border_width_right_phone=”20px” border_width_left_tablet=”20px” border_width_left_phone=”20px” box_shadow_horizontal_tablet=”0px” box_shadow_vertical_tablet=”0px” box_shadow_blur_tablet=”40px” box_shadow_spread_tablet=”0px”][et_pb_row _builder_version=”3.26.6″ custom_padding=”||30px|||” animation_style=”slide” animation_direction=”left” animation_intensity_slide=”4%”][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_6_font=”|700|||||||” header_6_text_color=”#fe6223″ background_layout=”dark”]<\/p>\n

DATABASES<\/h6>\n

[\/et_pb_text][et_pb_text _builder_version=”4.2.2″ header_text_color=”#ffffff” header_font_size=”35px” header_3_font=”|700||on|||||” header_3_text_color=”#3c3c3c” header_4_text_color=”#3c3c3c” background_layout=”dark” custom_margin=”-40px|||||”]<\/p>\n

CASE STUDIES<\/h3>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.26.6″ custom_padding=”||30px|||” animation_style=”slide” animation_direction=”left” animation_intensity_slide=”4%”][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_dpblog_portfolio fullwidth=”off” posts_number=”3″ custom_post_types=”casestudies” include_categories=”84″ show_categories=”off” show_excerpt=”on” excerpt_limit=”200″ show_more=”on” show_pagination=”off” hover_icon=”%%20%%” zoom_icon_color=”#fe6223″ module_class=”three-column-grid project-list” _builder_version=”4.2.2″ title_font_size=”22px” excerpt_font=”||||||||” excerpt_font_size=”18px” excerpt_more_link_font=”|700|||||||” excerpt_more_link_text_color=”#3c3c3c” excerpt_more_link_font_size=”18px” text_orientation=”left” custom_css_portfolio_readmore=”display: block;” excerpt_more_link_text_color__hover_enabled=”on”][\/et_pb_dpblog_portfolio][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.26.6″][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_button button_url=”#navigation-strip” button_text=”Back to top” button_alignment=”right” _builder_version=”4.2.2″ custom_button=”on” button_text_size=”14px” button_border_radius=”60px” button_font=”|700|||||||” button_icon=”%%0%%” button_icon_color=”#ffffff” button_on_hover=”off” background_layout=”dark”]
\n[\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ module_id=”researchthemes” module_class=”themes” _builder_version=”4.2.2″ background_color=”#006f74″ width=”100%” max_width=”98%” module_alignment=”center” min_height=”432px” custom_margin=”20px||||false|false” custom_padding=”16px||38px||false|false” z_index_tablet=”500″ border_color_all=”#AECC52″ border_width_top=”10px” border_color_top=”rgba(0,0,0,0)” border_width_bottom=”5px” border_color_bottom=”#fe6223″ border_width_top_tablet=”20px” border_width_top_phone=”20px” box_shadow_horizontal_tablet=”0px” box_shadow_vertical_tablet=”0px” box_shadow_blur_tablet=”40px” box_shadow_spread_tablet=”0px” global_module=”33572″][et_pb_row _builder_version=”4.2.2″][et_pb_column type=”4_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ text_font=”||||||||” header_text_color=”#ffffff” header_3_font=”|700|||||||” header_3_text_color=”#ffffff” header_4_font=”|700|||||||” header_4_text_color=”#006f74″]<\/p>\n

RESEARCH THEMES<\/h3>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_4,1_4″ use_custom_gutter=”on” gutter_width=”2″ make_equal=”on” custom_padding_last_edited=”on|phone” _builder_version=”4.2.2″ position_origin_f=”top_center” width=”96%” max_width=”1760px” min_height=”100px” height=”100px” max_height=”100px” custom_margin=”||||false|false” custom_padding=”0px||150px||false|false” custom_padding_tablet=”0px||250px||false|false” custom_padding_phone=”||455px||false|false” animation_style=”zoom” max_width__hover_enabled=”on|desktop”][et_pb_column type=”1_4″ _builder_version=”4.2.2″ background_enable_image=”off”][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2020\/06\/energy-e1593364327475.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/themes\/energy\/” header_6_font_size_phone=”10px” border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

ENERGY<\/h6>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2020\/06\/transport-e1593371139417.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/themes\/transport\/” header_6_font_size_phone=”10px” border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

TRANSPORT<\/h6>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2019\/08\/shutterstock_790878583.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/themes\/water\/” header_6_font_size_phone=”10px” border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

WATER<\/h6>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2020\/06\/digital-e1593371103180.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/themes\/digital\/” header_6_font_size_phone=”10px” border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

DIGITAL COMMUNICATIONS<\/h6>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_4,1_4″ use_custom_gutter=”on” gutter_width=”2″ make_equal=”on” custom_padding_last_edited=”on|phone” _builder_version=”4.2.2″ position_origin_f=”top_center” width=”96%” max_width=”1760px” min_height=”100px” height=”100px” max_height=”100px” custom_margin=”||||false|false” custom_padding=”0px||150px||false|false” custom_padding_tablet=”||250px||false|false” custom_padding_phone=”||455px||false|false” animation_style=”zoom” max_width__hover_enabled=”on|desktop”][et_pb_column type=”1_4″ _builder_version=”4.2.2″ background_enable_image=”off”][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2019\/08\/shutterstock_536340229-1.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/themes\/demographics\/” header_6_font_size_phone=”10px” border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

DEMOGRAPHICS<\/h6>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2020\/06\/digital-e1593371103180.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/themes\/urban-development\/” header_6_font_size_phone=”10px” border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

URBAN
DEVELOPMENT<\/h6>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2019\/08\/shutterstock_712110304.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/themes\/economics\/” header_6_font_size_phone=”10px” border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

ECONOMICS<\/h6>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2020\/06\/digital-e1593371103180.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/themes\/infrastructure-governance\/” header_6_font_size_phone=”10px” border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

INFRASTRUCTURE
GOVERNANCE<\/h6>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_4,1_4″ use_custom_gutter=”on” gutter_width=”2″ make_equal=”on” custom_padding_last_edited=”on|phone” _builder_version=”4.2.2″ position_origin_f=”top_center” width=”96%” max_width=”1760px” min_height=”100px” height=”100px” max_height=”100px” custom_margin=”||||false|false” custom_padding=”0px||150px||false|false” custom_padding_tablet=”||250px||false|false” custom_padding_phone=”||445px||false|false” animation_style=”zoom” max_width__hover_enabled=”on|desktop”][et_pb_column type=”1_4″ _builder_version=”4.2.2″ background_enable_image=”off”][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2020\/06\/infrastructure-e1593363350576.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/nismod\/” header_6_font_size_phone=”10px” border_color_top=”#fe6223″ border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

NISMOD<\/h6>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2020\/06\/risk-resilience-e1593363402667.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/themes\/risk-and-resilience\/” header_6_font_size_phone=”10px” border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

RISK AND
RESILIENCE<\/h6>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2020\/06\/digital-e1593371103180.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/themes\/research-software-engineering\/” header_6_font_size_phone=”10px” border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

RESEARCH SOFTWARE ENGINEERING<\/h6>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ header_5_font=”|700|||||||” header_5_text_align=”center” header_5_text_color=”#ffffff” header_6_font=”|700|||||||” header_6_text_align=”center” header_6_text_color=”#ffffff” header_6_font_size=”18px” use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.5)” background_color_gradient_end=”rgba(0,0,0,0.5)” background_color_gradient_overlays_image=”on” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2020\/06\/digital-e1593371103180.jpg” min_height=”120px” height=”120px” custom_margin=”||||false|false” custom_padding=”10%||||false|false” link_option_url=”\/themes\/databases\/” header_6_font_size_phone=”10px” border_width_bottom=”2px” border_color_bottom=”#fe6223″]<\/p>\n

DATABASES<\/h6>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.2.2″ background_color=”#636363″ background_color_gradient_direction=”160deg” background_image=”https:\/\/www.itrc.org.uk\/wp-content\/uploads\/2020\/06\/infrastructure-e1593363350576.jpg” background_blend=”multiply” custom_margin=”||||false|false” animation_style=”fade”][et_pb_row _builder_version=”3.26.6″][et_pb_column type=”4_4″ _builder_version=”3.26.6″][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” header_6_font=”|700|||||||” header_6_text_color=”#fe6223″ background_layout=”dark”] THEMES [\/et_pb_text][et_pb_text _builder_version=”4.2.2″ header_font_size=”35px” background_layout=”dark” custom_margin=”-40px|||||”] DATABASES [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row module_id=”navigation-strip” _builder_version=”4.2.2″][et_pb_column type=”4_4″ _builder_version=”4.2.2″][et_pb_text _builder_version=”4.2.2″ header_4_text_color=”#ffffff” header_4_font_size=”17px”] Addressing the need to be able to securely store and manage the multi-scale hetrogenous data required for complex household level infrastructure modelling, NISMOD-DB++ […]<\/p>\n","protected":false},"author":12,"featured_media":0,"parent":33438,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[],"tags":[],"class_list":["post-39478","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.itrc.org.uk\/wp-json\/wp\/v2\/pages\/39478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itrc.org.uk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.itrc.org.uk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.itrc.org.uk\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itrc.org.uk\/wp-json\/wp\/v2\/comments?post=39478"}],"version-history":[{"count":12,"href":"https:\/\/www.itrc.org.uk\/wp-json\/wp\/v2\/pages\/39478\/revisions"}],"predecessor-version":[{"id":40260,"href":"https:\/\/www.itrc.org.uk\/wp-json\/wp\/v2\/pages\/39478\/revisions\/40260"}],"up":[{"embeddable":true,"href":"https:\/\/www.itrc.org.uk\/wp-json\/wp\/v2\/pages\/33438"}],"wp:attachment":[{"href":"https:\/\/www.itrc.org.uk\/wp-json\/wp\/v2\/media?parent=39478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itrc.org.uk\/wp-json\/wp\/v2\/categories?post=39478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itrc.org.uk\/wp-json\/wp\/v2\/tags?post=39478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}