|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ibm-db2-database-for-beginners/
课程评论:没有评论
课程名称:IBM DB2数据库初学者课程 课程概述:IBM Db2是IBM开发和市场推广的一系列相关数据管理产品,包括关系数据库服务器。自1970年代以来,IBM已开发出完整的数据库服务器系列,最初在虚拟机(VM)、虚拟存储扩展(VSE)和多个虚拟存储(MVS)等大型主机平台上运行。1996年,IBM发布了针对分布式平台的Db2通用数据库(Db2 UDB)5版,这是第一版针对Web进行优化的Db2版本。从Db2 UDB 5版起,IBM多年持续推出多个版本,结合了许多创新功能,例如2006年的pureXML,支持XML文档。2009年,IBM引入了Db2 SQL兼容性功能,使客户能够轻松迁移到Db2数据库。2012年,IBM发布Db2 10.1,拥有多项帮助客户降低运营成本的功能,其中多温存储的显著特征允许用户将数据分类为热数据和冷数据。热数据是经常访问的数据,存储在最快且最昂贵的硬件中;冷数据则是不常访问的数据,存储在速度较慢、成本较低的设备中。2013年,IBM推出Db2 10.4,推出了BLU加速功能,通过内存驱动的列存储,利用并行向量处理能力、动态内存能力和先进的存储技术。2016年,IBM发布Db2 11.1,带来了关键创新,降低整体拥有成本,同时增强了分析能力,提高了业务关键应用的可用性、可靠性和安全性。在2017年中期,IBM对其Db2和dashDB产品进行了重新品牌化,将其统一为Db2。 课程目标:本课程面向初学者,旨在帮助学生了解IBM Db2的基础知识、功能及其在现代数据管理中的应用。通过课程,学员将掌握关键概念,增强在数据库管理技能方面的能力,为未来的学习和工作打下坚实基础。
IBM Db2 is a family of related data management products, including relational database servers, developed and marketed by IBM. Since the 1970s, IBM has developed a complete family of database servers, started on mainframe platforms such as Virtual Machine (VM), Virtual Storage Extended (VSE), and Multiple Virtual Storage(MVS).In 1996, IBM released Db2 Universal Database for distributed platforms, or Db2 UDB version 5. This was the first Db2 version that IBM designed to optimize for the web. Since the DB2 UDB version 5, IBM continued delivering a number of releases of Db2 over the years with lots of innovations such as pureXML that supports XML documents in 2006. In 2009, IBM introduced the Db2 SQL compatibility feature that makes it easy for customers to migrate from other relational database products to Db2.In 2012, IBM released Db2 10.1 with several features that help customers reduce operational costs. A notable feature was multi-temperature storage. For example, you can classify the data as hot and cold. The hot data is the data that you access often, which will be resided in the fastest and more expensive hardware. While the cold data is the data you rarely access, which will be stored in slower and cheaper devices. In 2013, IBM released Db2 10.4 that introduced BLU acceleration, a memory-based column store which leverages parallel vector processing power, dynamic memory capability, and advanced storage disk technology. In 2016, IBM released Db2 11.1 that delivered key innovation which reduces the total cost of ownership. Db2 11.1 also enhanced analytics and increased availability, reliability, and security for your business-critical applications. In mid-2017, IBM re-branded its DB2 and dashDB product offerings to Db2.