{"id":3567,"date":"2015-06-16T12:27:09","date_gmt":"2015-06-16T11:27:09","guid":{"rendered":"http:\/\/www.onomi.co.uk\/?page_id=3567"},"modified":"2021-07-14T09:57:32","modified_gmt":"2021-07-14T08:57:32","slug":"database-design","status":"publish","type":"page","link":"http:\/\/content.n4stack.io\/database-design\/","title":{"rendered":"Database Design"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.0.11&#8243; background_color=&#8221;#3d3d3d&#8221;][et_pb_row column_structure=&#8221;3_5,2_5&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_text _builder_version=&#8221;4.4.5&#8243; text_text_color=&#8221;#ffffff&#8221; header_text_color=&#8221;#ffffff&#8221; header_4_text_color=&#8221;#ffffff&#8221; header_6_text_color=&#8221;#ffffff&#8221; custom_padding=&#8221;||3px||false|false&#8221;]<\/p>\n<h1 style=\"text-align: left;\">Database Design<\/h1>\n<p>Give your project the best possible start with our Design and Transition service.<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;\/contact-us&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Get started&#8221; _builder_version=&#8221;4.4.5&#8243; custom_button=&#8221;on&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#1786c8&#8243; button_border_color=&#8221;#1786c8&#8243;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_image src=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/05\/Database-Design-1-300&#215;229.png&#8221; title_text=&#8221;Database Design (1)&#8221; _builder_version=&#8221;4.4.5&#8243;][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.22&#8243;][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.4.5&#8243;]<\/p>\n<h3 style=\"text-align: center;\">Our Design &amp; Transition Service<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\">N4Stack\u2019s Design and Transition service gives your project the best possible start. We typically spend a couple of days doing onsite workshops with you and your team before delivering a high-level design and a detailed recommendations report. Our core workshop modules are:<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_blurb title=&#8221;Technology Options&#8221; image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/05\/Magnifying-Glass-150&#215;150.png&#8221; _builder_version=&#8221;4.4.5&#8243; text_orientation=&#8221;center&#8221;][\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_blurb title=&#8221;Database Modelling&#8221; image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/04\/Database-150&#215;150.png&#8221; _builder_version=&#8221;4.4.5&#8243; text_orientation=&#8221;center&#8221;][\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_blurb title=&#8221;Database Architecture&#8221; image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/05\/Data-Architecture-150&#215;150.png&#8221; _builder_version=&#8221;4.4.5&#8243; text_orientation=&#8221;center&#8221;][\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.22&#8243;][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_tabs _builder_version=&#8221;3.19.18&#8243; body_text_align=&#8221;left&#8221;][et_pb_tab title=&#8221;Technology Options&#8221; _builder_version=&#8221;3.19.18&#8243;]Choosing a database is a long term decision and changing that decision later can be a difficult and expensive proposition. Our independent position in the marketplace combined with the skills and experience of our multi-platform database experts provides the base for a compelling service to help our customers pick the right database technology for the right job. This database design model is there to help our customers test and challenge their default database vendor choice. The rise of NoSQL and cloud native database options provide customers with a wide range of options. Answers to questions such as the below examples, can result in very different technology and vendor choices:<\/p>\n<ul>\n<li>What type of data is the project using (numbers, records, text, complex etc..)?<\/li>\n<li>What is the volume of data and how fast is new data generated?<\/li>\n<li>What are the read vs write volumes and ratio?<\/li>\n<li>What are the security requirements?<\/li>\n<li>What type of transactions are expected, do they need to be atomic?<\/li>\n<li>How many users\/devices access the data concurrently and what is the anticipated growth?<\/li>\n<li>Does the data need to be distributed?<\/li>\n<li>What is the core development environment language?<\/li>\n<li>How much computation is involved in data analysis?<\/li>\n<li>What the project budget and internal skills\/ support capability?<\/li>\n<li>What other technologies need integration?<\/li>\n<li>What is the preferred infrastructure choice e.g. Cloud, Dedicated?<\/li>\n<li>What are the potential scaling scenarios?<\/li>\n<\/ul>\n<p>The database technology options module typically consists of a 1-2 day onsite workshop followed by a recommendations report.<br \/>\n[\/et_pb_tab][et_pb_tab title=&#8221;Database Modelling&#8221; _builder_version=&#8221;3.19.18&#8243;]Developing a well-designed data model and schema at the beginning of a project is key to achieving better performance, simplified queries, and optimisation of the infrastructure deployment for your application. During the engagement, our experienced consultants collaborate with you and your team to gather the data and query requirements. The consultant creates a design draft based on your application requirements, with consideration to other requirements such as multi-tenancy, Warehousing etc. and then delivers a final database design report with best practice recommendations. The type of database i.e. Relational, NoSQL: Document, Key Value, Columnar or Graph will drive the core focus areas of this design workshop as there are large variations in data model requirements. You can expect to come away from the engagement with a clear understanding of how the chosen database technology data model works with recommendations tailored to the needs of your business. You will also develop an understanding of the process for designing performant queries and schemas.<br \/>\n[\/et_pb_tab][et_pb_tab title=&#8221;Database Architecture&#8221; _builder_version=&#8221;3.19.18&#8243;]<\/p>\n<p>If you are looking for high performance and availability from your database deployment, then the N4Stack Database Architecture Design service will provide you with a blueprint to achieve your goals. Typically a 2-3 day design workshop with the development and operational teams, this service addresses the following design areas:<\/p>\n<ul>\n<li>Application &amp; Business Needs Assessment<\/li>\n<li>Performance Requirements<\/li>\n<li>Security Requirements<\/li>\n<li>Distributed Deployments and Replication<\/li>\n<li>Infrastructure Requirements<\/li>\n<li>Scaling (Vertical or Horizontal)<\/li>\n<li>High Availability<\/li>\n<li>Capacity Planning<\/li>\n<li>Disaster Recovery &amp; Backup<\/li>\n<\/ul>\n<p>Following the workshop we will deliver a high level design and a detailed report of recommendations.<\/p>\n<p>[\/et_pb_tab][\/et_pb_tabs][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.4.8&#8243; background_color=&#8221;#ededed&#8221; saved_tabs=&#8221;all&#8221; global_module=&#8221;62027&#8243;][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;4.4.5&#8243;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_image src=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2021\/07\/DBaaS-101-731&#215;1024.png&#8221; title_text=&#8221;DBaaS 101&#8243; url=&#8221;https:\/\/n4stack.io\/database-as-a-service-101\/&#8221; url_new_window=&#8221;on&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_text _builder_version=&#8221;4.9.7&#8243; custom_margin=&#8221;20px||||false|false&#8221;]<\/p>\n<h3 style=\"text-align: center;\">Database as a Service 101: The Beginner&#8217;s Guide to DBaaS<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\">Businesses have long turned to database managed services providers (MSPs) to help them keep their databases available and performant &#8211; and that\u2019s not going to change. More recently, however, those same businesses have been looking to MSPs to help them get more functional value from their data \u2013 whether that\u2019s through moving databases from private to public cloud infrastructure, building modern data warehouses or investing in analytics.<\/p>\n<p style=\"text-align: center;\">In this guide, you\u2019ll learn more about modern database management services, the benefits they can bring to your business, and the key things to consider when choosing a DBaaS provider.<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/n4stack.io\/database-as-a-service-101\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Download guide&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#e05206&#8243; button_border_color=&#8221;#e05206&#8243; background_layout=&#8221;dark&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.3.4&#8243; background_enable_color=&#8221;off&#8221;][et_pb_row _builder_version=&#8221;4.3.4&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.3.4&#8243;][et_pb_text _builder_version=&#8221;4.3.4&#8243;]<\/p>\n<h3 style=\"text-align: center;\">You might also be interested in&#8230;<\/h3>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_5,1_5,1_5,1_5,1_5&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_column type=&#8221;1_5&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_blurb title=&#8221;Data Operations (DataOps)&#8221; url=&#8221;\/azure-service-partner\/database-managed-service\/&#8221; url_new_window=&#8221;on&#8221; image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/04\/IaaS-DB-Management.png&#8221; admin_label=&#8221;Blurb&#8221; _builder_version=&#8221;4.4.5&#8243; header_text_align=&#8221;center&#8221; link_option_url=&#8221;\/azure-service-partner\/database-managed-service\/&#8221; link_option_url_new_window=&#8221;on&#8221;][\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_5&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_blurb title=&#8221;Database Consulting&#8221; url=&#8221;\/database-consulting\/&#8221; url_new_window=&#8221;on&#8221; image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/04\/Database-Consulting.png&#8221; admin_label=&#8221;Blurb&#8221; _builder_version=&#8221;4.4.5&#8243; header_text_align=&#8221;center&#8221; link_option_url=&#8221;\/database-consulting\/&#8221; link_option_url_new_window=&#8221;on&#8221;][\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_5&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_blurb title=&#8221;Database Strategy Consulting&#8221; url=&#8221;\/strategic-database-consulting\/&#8221; url_new_window=&#8221;on&#8221; image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/04\/Database-Consulting.png&#8221; admin_label=&#8221;Blurb&#8221; _builder_version=&#8221;4.4.5&#8243; header_text_align=&#8221;center&#8221; link_option_url=&#8221;\/strategic-database-consulting\/&#8221; link_option_url_new_window=&#8221;on&#8221;][\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_5&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_blurb title=&#8221;Database Health Check&#8221; url=&#8221;\/database-performance-tuning&#8221; url_new_window=&#8221;on&#8221; image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/04\/DB-Health-Check.png&#8221; _builder_version=&#8221;4.4.5&#8243; header_text_align=&#8221;center&#8221; link_option_url=&#8221;\/database-performance-tuning&#8221; link_option_url_new_window=&#8221;on&#8221;][\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_5&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_blurb title=&#8221;Azure Managed SysOps&#8221; url=&#8221;\/azure-service-partner\/managed-sysops&#8221; url_new_window=&#8221;on&#8221; image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/04\/SysOps.png&#8221; _builder_version=&#8221;4.4.3&#8243; header_text_align=&#8221;center&#8221; link_option_url=&#8221;\/azure-service-partner\/managed-sysops&#8221; link_option_url_new_window=&#8221;on&#8221;][\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.4.5&#8243; background_color=&#8221;#e8e8e8&#8243;][et_pb_row _builder_version=&#8221;4.0.11&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_text _builder_version=&#8221;4.0.11&#8243;]<\/p>\n<h3 style=\"text-align: center;\">Further Resources<\/h3>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_4,1_4,1_4,1_4&#8243; _builder_version=&#8221;4.0.11&#8243; custom_padding=&#8221;||0px||false|false&#8221;][et_pb_column type=&#8221;1_4&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_blog posts_number=&#8221;1&#8243; include_categories=&#8221;484&#8243; use_manual_excerpt=&#8221;off&#8221; excerpt_length=&#8221;0&#8243; show_author=&#8221;off&#8221; show_date=&#8221;off&#8221; show_categories=&#8221;off&#8221; show_excerpt=&#8221;off&#8221; show_pagination=&#8221;off&#8221; _builder_version=&#8221;4.4.5&#8243; header_text_color=&#8221;#0c71c3&#8243; link_option_url_new_window=&#8221;on&#8221;][\/et_pb_blog][\/et_pb_column][et_pb_column type=&#8221;1_4&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_blog posts_number=&#8221;1&#8243; include_categories=&#8221;484&#8243; use_manual_excerpt=&#8221;off&#8221; excerpt_length=&#8221;0&#8243; show_author=&#8221;off&#8221; show_date=&#8221;off&#8221; show_categories=&#8221;off&#8221; show_excerpt=&#8221;off&#8221; show_pagination=&#8221;off&#8221; offset_number=&#8221;1&#8243; _builder_version=&#8221;4.4.5&#8243; header_text_color=&#8221;#0c71c3&#8243; link_option_url_new_window=&#8221;on&#8221;][\/et_pb_blog][\/et_pb_column][et_pb_column type=&#8221;1_4&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_blog posts_number=&#8221;1&#8243; include_categories=&#8221;484&#8243; use_manual_excerpt=&#8221;off&#8221; excerpt_length=&#8221;0&#8243; show_author=&#8221;off&#8221; show_date=&#8221;off&#8221; show_categories=&#8221;off&#8221; show_excerpt=&#8221;off&#8221; show_pagination=&#8221;off&#8221; offset_number=&#8221;2&#8243; _builder_version=&#8221;4.4.5&#8243; header_text_color=&#8221;#0c71c3&#8243; link_option_url_new_window=&#8221;on&#8221;][\/et_pb_blog][\/et_pb_column][et_pb_column type=&#8221;1_4&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_button button_url=&#8221;\/blog&#8221; button_text=&#8221;Read more&#8230;&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.0.11&#8243; custom_margin=&#8221;25px||||false|false&#8221; custom_padding=&#8221;||||false|false&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Design Give your project the best possible start with our Design and Transition service. Get started Our Design &amp; Transition Service &nbsp; N4Stack\u2019s Design and Transition service gives your project the best possible start. We typically spend a couple of days doing onsite workshops with you and your team before delivering a high-level design [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":""},"yst_prominent_words":[2329,269,2310,159,2308,136,219,2405,2324,2321,2313,475,2330,2326,2911,2317,2315,41,2325],"_links":{"self":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/pages\/3567"}],"collection":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/comments?post=3567"}],"version-history":[{"count":27,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/pages\/3567\/revisions"}],"predecessor-version":[{"id":62044,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/pages\/3567\/revisions\/62044"}],"wp:attachment":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/media?parent=3567"}],"wp:term":[{"taxonomy":"yst_prominent_words","embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/yst_prominent_words?post=3567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}