{"id":310,"date":"2024-02-22T22:27:23","date_gmt":"2024-02-22T22:27:23","guid":{"rendered":"http:\/\/77interactive.com\/?p=310"},"modified":"2024-02-26T15:05:15","modified_gmt":"2024-02-26T15:05:15","slug":"questions-to-ask-when-provisioning-a-new-database","status":"publish","type":"post","link":"http:\/\/77interactive.com\/?p=310","title":{"rendered":"Questions to ask when provisioning a new database"},"content":{"rendered":"\n

The following list is a list of questions that a Database Administrator should ask when provisioning a new database. The questions are also useful when examining an existing database as well.<\/p>\n\n\n\n

Data Ingestion and Format<\/h3>\n\n\n\n
    \n
  1. Source:<\/strong> Where will the data be coming from (e.g., applications, manual entry, external feeds)?<\/li>\n\n\n\n
  2. Format:<\/strong> In what formats will the data be ingested (e.g., CSV, JSON, raw)?<\/li>\n\n\n\n
  3. Frequency and Volume:<\/strong> How often and in what volume will the data be ingested (real-time, batch, scheduled; number of records, size per record)?<\/li>\n<\/ol>\n\n\n\n

    Data Usage and Performance<\/h3>\n\n\n\n
      \n
    1. Primary Purpose:<\/strong> What is the main purpose of storing this data (e.g., analytics, reporting, transactions)?<\/li>\n\n\n\n
    2. Expected Queries and Performance Requirements:<\/strong> What kind of queries will be most frequent, and are there specific latency or throughput requirements (e.g., aggregations, joins, filtering)?<\/li>\n\n\n\n
    3. Read\/Write Ratio:<\/strong> What is the expected ratio of read vs. write operations?<\/li>\n<\/ol>\n\n\n\n

      Reporting, Access, and Security<\/h3>\n\n\n\n
        \n
      1. Reporting Needs and User Access:<\/strong> What kind of reports will be generated, and who needs access (e.g., dashboards, ad-hoc analysis; specific users, applications)?<\/li>\n\n\n\n
      2. Authorization Levels:<\/strong> What level of access should different users have (e.g., read-only, read-write, full control)?<\/li>\n\n\n\n
      3. Security Measures:<\/strong> What security measures are needed to protect the data (e.g., encryption, access control)?<\/li>\n<\/ol>\n\n\n\n

        Maintenance, Backup, and Disaster Recovery<\/h3>\n\n\n\n
          \n
        1. Retention Policy:<\/strong> How long should the data be retained (e.g., archival, legal requirements)?<\/li>\n\n\n\n
        2. Backup Strategy and Disaster Recovery:<\/strong> How will the database be backed up, and what is the plan for recovery (e.g., frequency, location)?<\/li>\n<\/ol>\n\n\n\n

          PostgreSQL Specifics and Scalability<\/h3>\n\n\n\n
            \n
          1. Version and Extensions:<\/strong> Which version of PostgreSQL is required, and are any specific extensions needed?<\/li>\n\n\n\n
          2. Table Partitioning and Indexing Strategy:<\/strong> Is table partitioning considered, and what indexing strategy is needed for optimal performance?<\/li>\n\n\n\n
          3. Monitoring and Logging:<\/strong> How will database performance and activity be monitored and logged?<\/li>\n<\/ol>\n\n\n\n

            Additional Considerations and Integrations<\/h3>\n\n\n\n
              \n
            1. Future Growth and Scalability Needs:<\/strong> How much is the data expected to grow, and does the database need to be scalable?<\/li>\n\n\n\n
            2. Integration with Other Systems:<\/strong> Does the database need to integrate with other systems or applications?<\/li>\n\n\n\n
            3. Cost Considerations:<\/strong> What are the budget constraints for setting up and maintaining the database?<\/li>\n\n\n\n
            4. Compliance Requirements:<\/strong> Are there any specific compliance regulations that need to be met?<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

              The following list is a list of questions that a Database Administrator should ask when provisioning a new database. The questions are also useful when examining an existing database as well. Data Ingestion and Format Data Usage and Performance Reporting, Access, and Security Maintenance, Backup, and Disaster Recovery PostgreSQL Specifics and Scalability Additional Considerations and […]<\/p>\n","protected":false},"author":1,"featured_media":311,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,46],"tags":[41,5,18],"class_list":["post-310","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mongodb","category-postgresql","tag-database","tag-mongodb","tag-postgresql"],"yoast_head":"\nQuestions to ask when provisioning a new database - 77 Interactive<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/77interactive.com\/?p=310\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Questions to ask when provisioning a new database - 77 Interactive\" \/>\n<meta property=\"og:description\" content=\"The following list is a list of questions that a Database Administrator should ask when provisioning a new database. The questions are also useful when examining an existing database as well. Data Ingestion and Format Data Usage and Performance Reporting, Access, and Security Maintenance, Backup, and Disaster Recovery PostgreSQL Specifics and Scalability Additional Considerations and […]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/77interactive.com\/?p=310\" \/>\n<meta property=\"og:site_name\" content=\"77 Interactive\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-22T22:27:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-26T15:05:15+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/77interactive.com\/wp-content\/uploads\/2024\/02\/BearWithPresentWide-1024x455.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"455\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Rudy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rudy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/77interactive.com\/?p=310#article\",\"isPartOf\":{\"@id\":\"http:\/\/77interactive.com\/?p=310\"},\"author\":{\"name\":\"Rudy\",\"@id\":\"http:\/\/77interactive.com\/#\/schema\/person\/0e61d2a984b8304618026b207e6121e9\"},\"headline\":\"Questions to ask when provisioning a new database\",\"datePublished\":\"2024-02-22T22:27:23+00:00\",\"dateModified\":\"2024-02-26T15:05:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/77interactive.com\/?p=310\"},\"wordCount\":373,\"image\":{\"@id\":\"http:\/\/77interactive.com\/?p=310#primaryimage\"},\"thumbnailUrl\":\"http:\/\/77interactive.com\/wp-content\/uploads\/2024\/02\/BearWithPresentWide.png\",\"keywords\":[\"database\",\"mongodb\",\"postgresql\"],\"articleSection\":[\"mongodb\",\"PostgreSQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/77interactive.com\/?p=310\",\"url\":\"http:\/\/77interactive.com\/?p=310\",\"name\":\"Questions to ask when provisioning a new database - 77 Interactive\",\"isPartOf\":{\"@id\":\"http:\/\/77interactive.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/77interactive.com\/?p=310#primaryimage\"},\"image\":{\"@id\":\"http:\/\/77interactive.com\/?p=310#primaryimage\"},\"thumbnailUrl\":\"http:\/\/77interactive.com\/wp-content\/uploads\/2024\/02\/BearWithPresentWide.png\",\"datePublished\":\"2024-02-22T22:27:23+00:00\",\"dateModified\":\"2024-02-26T15:05:15+00:00\",\"author\":{\"@id\":\"http:\/\/77interactive.com\/#\/schema\/person\/0e61d2a984b8304618026b207e6121e9\"},\"breadcrumb\":{\"@id\":\"http:\/\/77interactive.com\/?p=310#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/77interactive.com\/?p=310\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/77interactive.com\/?p=310#primaryimage\",\"url\":\"http:\/\/77interactive.com\/wp-content\/uploads\/2024\/02\/BearWithPresentWide.png\",\"contentUrl\":\"http:\/\/77interactive.com\/wp-content\/uploads\/2024\/02\/BearWithPresentWide.png\",\"width\":2305,\"height\":1024,\"caption\":\"Cartoon Bear with a gift\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/77interactive.com\/?p=310#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/77interactive.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Questions to ask when provisioning a new database\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/77interactive.com\/#website\",\"url\":\"http:\/\/77interactive.com\/\",\"name\":\"77 Interactive\",\"description\":\"Rudy's Code snippets\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/77interactive.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/77interactive.com\/#\/schema\/person\/0e61d2a984b8304618026b207e6121e9\",\"name\":\"Rudy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/77interactive.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e336b9aecd39b40691ff8ccfcd68506415072dbe8caffc0485b94a1bc22b774d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e336b9aecd39b40691ff8ccfcd68506415072dbe8caffc0485b94a1bc22b774d?s=96&d=mm&r=g\",\"caption\":\"Rudy\"},\"url\":\"http:\/\/77interactive.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Questions to ask when provisioning a new database - 77 Interactive","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/77interactive.com\/?p=310","og_locale":"en_US","og_type":"article","og_title":"Questions to ask when provisioning a new database - 77 Interactive","og_description":"The following list is a list of questions that a Database Administrator should ask when provisioning a new database. The questions are also useful when examining an existing database as well. Data Ingestion and Format Data Usage and Performance Reporting, Access, and Security Maintenance, Backup, and Disaster Recovery PostgreSQL Specifics and Scalability Additional Considerations and […]","og_url":"http:\/\/77interactive.com\/?p=310","og_site_name":"77 Interactive","article_published_time":"2024-02-22T22:27:23+00:00","article_modified_time":"2024-02-26T15:05:15+00:00","og_image":[{"width":1024,"height":455,"url":"http:\/\/77interactive.com\/wp-content\/uploads\/2024\/02\/BearWithPresentWide-1024x455.png","type":"image\/png"}],"author":"Rudy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rudy","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/77interactive.com\/?p=310#article","isPartOf":{"@id":"http:\/\/77interactive.com\/?p=310"},"author":{"name":"Rudy","@id":"http:\/\/77interactive.com\/#\/schema\/person\/0e61d2a984b8304618026b207e6121e9"},"headline":"Questions to ask when provisioning a new database","datePublished":"2024-02-22T22:27:23+00:00","dateModified":"2024-02-26T15:05:15+00:00","mainEntityOfPage":{"@id":"http:\/\/77interactive.com\/?p=310"},"wordCount":373,"image":{"@id":"http:\/\/77interactive.com\/?p=310#primaryimage"},"thumbnailUrl":"http:\/\/77interactive.com\/wp-content\/uploads\/2024\/02\/BearWithPresentWide.png","keywords":["database","mongodb","postgresql"],"articleSection":["mongodb","PostgreSQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/77interactive.com\/?p=310","url":"http:\/\/77interactive.com\/?p=310","name":"Questions to ask when provisioning a new database - 77 Interactive","isPartOf":{"@id":"http:\/\/77interactive.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/77interactive.com\/?p=310#primaryimage"},"image":{"@id":"http:\/\/77interactive.com\/?p=310#primaryimage"},"thumbnailUrl":"http:\/\/77interactive.com\/wp-content\/uploads\/2024\/02\/BearWithPresentWide.png","datePublished":"2024-02-22T22:27:23+00:00","dateModified":"2024-02-26T15:05:15+00:00","author":{"@id":"http:\/\/77interactive.com\/#\/schema\/person\/0e61d2a984b8304618026b207e6121e9"},"breadcrumb":{"@id":"http:\/\/77interactive.com\/?p=310#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/77interactive.com\/?p=310"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/77interactive.com\/?p=310#primaryimage","url":"http:\/\/77interactive.com\/wp-content\/uploads\/2024\/02\/BearWithPresentWide.png","contentUrl":"http:\/\/77interactive.com\/wp-content\/uploads\/2024\/02\/BearWithPresentWide.png","width":2305,"height":1024,"caption":"Cartoon Bear with a gift"},{"@type":"BreadcrumbList","@id":"http:\/\/77interactive.com\/?p=310#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/77interactive.com\/"},{"@type":"ListItem","position":2,"name":"Questions to ask when provisioning a new database"}]},{"@type":"WebSite","@id":"http:\/\/77interactive.com\/#website","url":"http:\/\/77interactive.com\/","name":"77 Interactive","description":"Rudy's Code snippets","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/77interactive.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/77interactive.com\/#\/schema\/person\/0e61d2a984b8304618026b207e6121e9","name":"Rudy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/77interactive.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e336b9aecd39b40691ff8ccfcd68506415072dbe8caffc0485b94a1bc22b774d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e336b9aecd39b40691ff8ccfcd68506415072dbe8caffc0485b94a1bc22b774d?s=96&d=mm&r=g","caption":"Rudy"},"url":"http:\/\/77interactive.com\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/posts\/310","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/77interactive.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=310"}],"version-history":[{"count":0,"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/posts\/310\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/media\/311"}],"wp:attachment":[{"href":"http:\/\/77interactive.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/77interactive.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=310"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/77interactive.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}