[et_pb_section fb_built=”1″ disabled_on=”off|off|off” admin_label=”Header” _builder_version=”4.25.1″ custom_padding=”||80px||false|false” custom_width_px__hover=”1080px” custom_width_px__hover_enabled=”1080px” custom_width_percent__hover=”80%” custom_width_percent__hover_enabled=”80%” locked=”off” global_colors_info=”{}” parallax_1__hover=”off” parallax_1__hover_enabled=”off” parallax_2__hover=”off” parallax_2__hover_enabled=”off” parallax_3__hover=”off” parallax_3__hover_enabled=”off” parallax_method_1__hover=”on” parallax_method_1__hover_enabled=”on” parallax_method_2__hover=”on” parallax_method_2__hover_enabled=”on” parallax_method_3__hover=”on” parallax_method_3__hover_enabled=”on” use_background_color_gradient__hover=”off” use_background_color_gradient__hover_enabled=”off” background_color_gradient_start__hover=”#2b87da” background_color_gradient_start__hover_enabled=”#2b87da” background_color_gradient_end__hover=”#29c4a9″ background_color_gradient_end__hover_enabled=”#29c4a9″ background_color_gradient_type__hover=”linear” background_color_gradient_type__hover_enabled=”linear” background_color_gradient_direction__hover=”180deg” background_color_gradient_direction__hover_enabled=”180deg” background_color_gradient_direction_radial__hover=”center” background_color_gradient_direction_radial__hover_enabled=”center” background_color_gradient_start_position__hover=”0%” background_color_gradient_start_position__hover_enabled=”0%” background_color_gradient_end_position__hover=”100%” background_color_gradient_end_position__hover_enabled=”100%” background_color_gradient_overlays_image__hover=”off” background_color_gradient_overlays_image__hover_enabled=”off” parallax__hover=”off” parallax__hover_enabled=”off” parallax_method__hover=”on” parallax_method__hover_enabled=”on” background_size__hover=”cover” background_size__hover_enabled=”cover” background_position__hover=”center” background_position__hover_enabled=”center” background_repeat__hover=”no-repeat” background_repeat__hover_enabled=”no-repeat” background_blend__hover=”normal” background_blend__hover_enabled=”normal” allow_player_pause__hover=”off” allow_player_pause__hover_enabled=”off” background_video_pause_outside_viewport__hover=”on” background_video_pause_outside_viewport__hover_enabled=”on” inner_shadow__hover=”off” inner_shadow__hover_enabled=”off” make_fullwidth__hover=”off” make_fullwidth__hover_enabled=”off” use_custom_width__hover=”off” use_custom_width__hover_enabled=”off” width_unit__hover=”on” width_unit__hover_enabled=”on” make_equal__hover=”off” make_equal__hover_enabled=”off” use_custom_gutter__hover=”off” use_custom_gutter__hover_enabled=”off” border_radii__hover=”on||||” border_radii__hover_enabled=”on||||” box_shadow_style__hover=”none” box_shadow_style__hover_enabled=”none” box_shadow_color__hover=”rgba(0,0,0,0.3)” box_shadow_color__hover_enabled=”rgba(0,0,0,0.3)” max_width__hover=”100%” max_width__hover_enabled=”100%” filter_hue_rotate__hover=”0deg” filter_hue_rotate__hover_enabled=”0deg” filter_saturate__hover=”100%” filter_saturate__hover_enabled=”100%” filter_brightness__hover=”100%” filter_brightness__hover_enabled=”100%” filter_contrast__hover=”100%” filter_contrast__hover_enabled=”100%” filter_invert__hover=”0%” filter_invert__hover_enabled=”0%” filter_sepia__hover=”0%” filter_sepia__hover_enabled=”0%” filter_opacity__hover=”100%” filter_opacity__hover_enabled=”100%” filter_blur__hover=”0px” filter_blur__hover_enabled=”0px” mix_blend_mode__hover=”normal” mix_blend_mode__hover_enabled=”normal” animation_style__hover=”none” animation_style__hover_enabled=”none” animation_repeat__hover=”once” animation_repeat__hover_enabled=”once” animation_direction__hover=”center” animation_direction__hover_enabled=”center” animation_duration__hover=”1000ms” animation_duration__hover_enabled=”1000ms” animation_delay__hover=”0ms” animation_delay__hover_enabled=”0ms” animation_intensity_slide__hover=”50%” animation_intensity_slide__hover_enabled=”50%” animation_intensity_zoom__hover=”50%” animation_intensity_zoom__hover_enabled=”50%” animation_intensity_flip__hover=”50%” animation_intensity_flip__hover_enabled=”50%” animation_intensity_fold__hover=”50%” animation_intensity_fold__hover_enabled=”50%” animation_intensity_roll__hover=”50%” animation_intensity_roll__hover_enabled=”50%” animation_starting_opacity__hover=”0%” animation_starting_opacity__hover_enabled=”0%” animation_speed_curve__hover=”ease-in-out” animation_speed_curve__hover_enabled=”ease-in-out” hover_transition_duration__hover=”300ms” hover_transition_duration__hover_enabled=”300ms” hover_transition_delay__hover=”0ms” hover_transition_delay__hover_enabled=”0ms” hover_transition_speed_curve__hover=”ease” hover_transition_speed_curve__hover_enabled=”ease” background_color_gradient_stops__hover=”#2b87da 0%|#29c4a9 100%”][et_pb_row admin_label=”row” _builder_version=”4.19.5″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_margin=”||||false|false” custom_padding=”0px||0px||true|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_post_title author=”off” date=”off” comments=”off” featured_image=”off” _builder_version=”4.25.1″ _module_preset=”default” title_font=”|600|||||||” title_text_align=”left” title_font_size=”48px” title_letter_spacing=”0.01em” title_line_height=”1.2em” meta_font=”|600||on|||||” meta_text_color=”#787f84″ meta_font_size=”12px” meta_letter_spacing=”0.1em” custom_margin=”||10px||false|false” custom_margin_tablet=”||10px||false|false” custom_margin_phone=”||10px||false|false” custom_margin_last_edited=”on|desktop” title_font_size_tablet=”34px” title_font_size_phone=”28px” title_font_size_last_edited=”on|desktop” locked=”off” global_colors_info=”{}”][\/et_pb_post_title][et_pb_image src=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9mZWF0dXJlZF9pbWFnZSIsInNldHRpbmdzIjp7fX0=@” align=”center” force_fullwidth=”on” _builder_version=”4.25.1″ _dynamic_attributes=”src” _module_preset=”default” custom_margin=”||||false|false” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#efeff0″ locked=”off” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.27.0″ _module_preset=”acf0c613-b10a-4218-965c-ed6dfe77c1c8″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n
A company needed a way to manage its client information \u2013 including first name, last name, company, and contact details<\/strong> \u2013 which clients updated through a landing page on the website. The company needed a way to temporarily store and review the updated information<\/strong> before making it permanent, with approval from a responsible person.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.0″ _module_preset=”acf0c613-b10a-4218-965c-ed6dfe77c1c8″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n The company faced several challenges in client information management, including:<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.0″ _module_preset=”acf0c613-b10a-4218-965c-ed6dfe77c1c8″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n To address these challenges, the company implemented client information management with temporal tables.<\/strong><\/p>\n Temporal tables<\/strong> are a feature in some database management systems that allow historical data changes to be tracked, with special columns indicating the validity period of each row.<\/p>\n When clients submitted their updated information through the landing page, the company temporarily stored it in temporal tables. A responsible person then reviewed and approved or rejected the information, making it permanent or discarding it.<\/p>\n The company also used temporal tables to track and maintain the history of client information changes. The temporal tables automatically recorded the start and end time of the validity period of the updated information.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/www.factory-x.hr\/wp-content\/uploads\/2024\/08\/temporal-tables-01-blurred.jpg” show_in_lightbox=”on” disabled_on=”off|off|off” _builder_version=”4.27.0″ _module_preset=”default” border_width_all=”1px” border_color_all=”#dddddd” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ admin_label=”row” _builder_version=”4.25.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”||||false|false” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.27.0″ _module_preset=”acf0c613-b10a-4218-965c-ed6dfe77c1c8″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n The implementation of temporal tables allowed the company to efficiently manage its client information.<\/strong><\/p>\n The temporary storage and approval process ensured that only accurate and up-to-date information became permanent. In addition. by tracking and maintaining the history of client information changes, the company gained valuable insights into client behavior.<\/p>\n As a result, their customer service improved as they processed clients\u2019 updated information quickly and accurately, reducing the need for repeated contacts from clients to update their information.<\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/www.factory-x.hr\/wp-content\/uploads\/2024\/08\/temporal-tables-02-blurred.jpg” show_in_lightbox=”on” _builder_version=”4.27.0″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=”row” _builder_version=”4.25.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”||||false|false” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.27.0″ _module_preset=”acf0c613-b10a-4218-965c-ed6dfe77c1c8″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n Temporal tables proved to be an effective solution for the company\u2019s client information management.<\/p>\n They provided a way to temporarily store and approve updated client information, while also tracking and maintaining the history of changes. This ensured only accurate and up-to-date information was made permanent, improving customer service and providing valuable insights into client behavior.<\/p>\n Are you looking for a custom software solution?\u00a0Contact us<\/a>\u00a0via the contact form or send an inquiry on\u00a0info@factory-x.hr<\/a>\u00a0.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" In this case study, we explain how they achieved efficient client information management with temporal tables.<\/p>\n","protected":false},"author":1,"featured_media":5155,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"project_category":[388],"project_tag":[],"class_list":["post-987511910","project","type-project","status-publish","has-post-thumbnail","hentry","project_category-case-study"],"yoast_head":"\nChallenges<\/h2>\n
\n
Solution<\/h2>\n
Results<\/h2>\n
Conclusion<\/h2>\n