{"id":54228,"date":"2024-12-12T11:27:14","date_gmt":"2024-12-12T16:27:14","guid":{"rendered":"https:\/\/web.uri.edu\/draft-its\/?p=54228"},"modified":"2025-02-03T15:22:14","modified_gmt":"2025-02-03T20:22:14","slug":"databases","status":"publish","type":"post","link":"https:\/\/web.uri.edu\/draft-its\/databases\/","title":{"rendered":"Databases"},"content":{"rendered":"\n
\n
\n

Databases<\/h2>\n\n\n
\n
\"\"<\/figure>\n<\/div>\n\n\n

The University of Rhode Island provides robust database management services to support the institution\u2019s critical operations and core applications. URI\u2019s database environment includes both Oracle Database<\/strong> and Microsoft SQL (MS SQL)<\/strong> systems, offering secure and reliable solutions for online transaction processing (OLTP), data warehousing (DW), and other enterprise workloads. These databases are integral to the university\u2019s IT infrastructure and are managed by the ITS Infrastructure Database team.<\/p>\n<\/div>\n\n\n\n

\n\n

Executive Lead<\/h3>\n\n\n\n

Chi Shen<\/p>\n\n\n\n

Technical Lead<\/h3>\n\n\n\n

Chi Shen
cshen@uri.edu<\/p>\n\n\n\n

Support Team<\/h3>\n\n\n\n

ITS Cloud & IT Infrastructure<\/p>\n\n<\/div><\/section><\/div>\n<\/div>\n\n\n\n

Database Offerings<\/strong><\/h2>\n\n\n\n
    \n
  • Oracle Database<\/strong>:\n
      \n
    • Supports online transaction processing (OLTP), data warehousing (DW), and hybrid workloads.<\/li>\n\n\n\n
    • Operates as a foundational element for many of URI\u2019s core applications.<\/li>\n\n\n\n
    • Capable of running on-premises, in the cloud, or in hybrid environments.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
    • Microsoft SQL (MS SQL)<\/strong>:\n
        \n
      • Provides scalable and secure database solutions for enterprise and academic applications.<\/li>\n\n\n\n
      • Plays a vital role in URI\u2019s IT operations and supports data-driven decision-making.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n

        Who Should Use These Services?<\/strong><\/h3>\n\n\n\n

        Most users will not need direct access to URI\u2019s Oracle or MS SQL environments, as these systems primarily operate behind the scenes to support enterprise applications and IT services. For specialized needs or database-related projects, consultations are available.<\/p>\n\n\n\n

        Get Help<\/strong><\/h3>\n\n\n\n

        For database-related inquiries or to request a consultation, contact the ITS Service Desk<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"

        Enterprise-class database solutions supporting URI\u2019s core applications and infrastructure.<\/p>\n","protected":false},"author":5142,"featured_media":54603,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[24],"tags":[34,166,7,54,71,55,19,6],"class_list":["post-54228","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-services","tag-iac","tag-databases","tag-faculty","tag-infrastructure","tag-infrastructure-hosting","tag-research","tag-services","tag-staff"],"acf":[],"_links":{"self":[{"href":"https:\/\/web.uri.edu\/draft-its\/wp-json\/wp\/v2\/posts\/54228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/web.uri.edu\/draft-its\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/web.uri.edu\/draft-its\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/web.uri.edu\/draft-its\/wp-json\/wp\/v2\/users\/5142"}],"replies":[{"embeddable":true,"href":"https:\/\/web.uri.edu\/draft-its\/wp-json\/wp\/v2\/comments?post=54228"}],"version-history":[{"count":6,"href":"https:\/\/web.uri.edu\/draft-its\/wp-json\/wp\/v2\/posts\/54228\/revisions"}],"predecessor-version":[{"id":55292,"href":"https:\/\/web.uri.edu\/draft-its\/wp-json\/wp\/v2\/posts\/54228\/revisions\/55292"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/web.uri.edu\/draft-its\/wp-json\/wp\/v2\/media\/54603"}],"wp:attachment":[{"href":"https:\/\/web.uri.edu\/draft-its\/wp-json\/wp\/v2\/media?parent=54228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/web.uri.edu\/draft-its\/wp-json\/wp\/v2\/categories?post=54228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/web.uri.edu\/draft-its\/wp-json\/wp\/v2\/tags?post=54228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}