Consolidate SQL Educational Resources With the SQL Tutor
June 8, 2021
Developers often use SQL to access data in Db2 for i. With the ever-increasing number of IBM i Services, system administrators have a need to learn SQL as well. Regardless of whether you are new to SQL, or an experienced SQL developer, there is always more learn. A relatively new resource, the SQL Tutor, is available […]
ArticlesIBM i Gets a Refresh, Increasing Automation and Storage Options
April 20, 2021
The latest round of IBM i technology refreshes (TRs) provides enhancements to offerings, services and hardware. On Tuesday, April 13, IBM announced the latest round of OS TRs—IBM i 7.4 TR4 and 7.3 TR10. These TRs demonstrate a commitment to IBM i services, showcase a continuing push toward automation and represent a heavy investment in […]
ArticlesKey Considerations for Comparing NoSQL and SQL
February 19, 2021
Data models conceptually describe the logical structure of data storage inside a database. While there are many data models, we will mainly talk about two kinds in this guide: 1. Document data models The document data model uses a simpler key-value pairs storage form. The key itself typically takes the form of a string that […]
ArticlesA Beginner’s Guide to NoSQL
January 19, 2021
Traditionally the way that SQL works is through relational databases. As such, it tends to run into certain issues, for example, complex design due to needing to avoid data duplication. Another big issue is the fact that SQL is only vertically scalable, and therefore can become quite expensive as a project expands. NoSQL was made […]