Article Benjamin De Boe · Jan 10 4m read Columnar Storage in 2022.3 As you may well remember from Global Summit 2022 or the 2022.2 launch webinar, we're releasing an exciting new capability for including in your analytics solutions on InterSystems IRIS. Columnar Storage introduces an alternative way of storing your SQL table data that offers an order-of-magnitude speedup for analytical queries. First released as an experimental feature in 2022.2, the latest 2022.3 Developer Preview includes a bunch of updates we thought were worth a quick post here. #SQL #InterSystems IRIS Open Exchange app 8 2 3 230
Article Benjamin De Boe · Oct 18, 2022 6m read Keeping the API happy - SQL utilities cleanup With IRIS 2021.1, we released a significant revision our SQL utilities API at %SYSTEM.SQL. Yes, that's a while ago now, but last week a customer asked a few questions about this and then @Tom Woodfin applied gentle mental pressure ;-) to make me describe the rationale of these changes in a little more detail on the Developer Community. So here we go! #SQL #InterSystems IRIS 8 1 2 269
Article Benjamin De Boe · Sep 13, 2022 8m read CI/CD with IRIS SQL In the vast and varied SQL database market, InterSystems IRIS stands out as a platform that goes way beyond just SQL, offering a seamless multimodel experience and supporting a rich set of development paradigms. Especially the advanced Object-Relational engine has helped organizations use the best-fit development approach for each facet of their data-intensive workloads, for example ingesting data through Objects and simultaneously querying it through SQL. Persistent Classes correspond to SQL tables, their properties to table columns and business logic is easily accessed using User-Defined Functions or Stored Procedures. In this article, we'll zoom in on a little bit of the magic just below the surface, and discuss how it may affect your development and deployment practices. This is an area of the product where we have plans to evolve and improve, so please don't hesitate to share your views and experiences using the comments section below. #Continuous Delivery #Continuous Integration #Source Control #SQL #InterSystems IRIS 8 5 0 370
Article Benjamin De Boe · Dec 15, 2021 4m read 2021.2 SQL Feature Spotlight - Advanced Table Statistics This is the third article in our short series around innovations in IRIS SQL that deliver a more adaptive, high-performance experience for analysts and applications querying relational data on IRIS. It may be the last article in this series for 2021.2, but we have several more enhancements lined up in this area. In this article, we'll dig a little deeper into additional table statistics we're starting to gather in this release: Histograms #Relational Tables #SQL #InterSystems IRIS 9 0 0 304
Article Benjamin De Boe · Dec 15, 2021 4m read 2021.2 SQL Feature Spotlight - Smart Sampling & Automation for Table Statistics This is the second piece in our series on 2021.2 SQL enhancements delivering an adaptive, high-performance SQL experience. In this article, we'll zoom in on the innovations in gathering Table Statistics, which are of course the primary input for the Run Time Plan Choice capability we described in the previous article. #Relational Tables #SQL #InterSystems IRIS 9 2 0 426
Article Benjamin De Boe · Dec 15, 2021 4m read 2021.2 SQL Feature Spotlight - Run Time Plan Choice The 2021.2 release of the InterSystems IRIS Data Platform includes many exciting new features for fast, flexible and secure development of your mission-critical applications. Embedded Python definitely takes the limelight (and for good reason!), but in SQL we've also made a massive step forward towards a more adaptive engine that gathers detailed statistical information about your table data and exploits it to deliver the best query plans. In this brief series of articles, we'll take a closer at three elements that are new in 2021.2 and work together towards this goal, starting with Run Time Plan Choice. It's hard to figure out the right order to talk about these (you can't imagine how often I've reshuffled them in writing this article!) because they fit together in such a nice way. As such, feel free to go on a limb and read these in random order . #Relational Tables #SQL #InterSystems IRIS 13 2 1 521
Article Benjamin De Boe · Feb 23, 2021 1m read IRIS memory configuration wizard - looking for feedback Hi, I just published isc-mem-config on OpenExchange and ZPM. It's a prototype to test whether this kind of user experience (UX) is a good fit for novice and / or more seasoned users. The settings it generates are already fairly-good-practice :-), but also being reviewed by experts within InterSystems in parallel. #InterSystems IRIS Open Exchange app 3 2 1 133
Article Benjamin De Boe · Mar 25, 2020 5m read New in 2020.1: the Universal Query Cache InterSystems IRIS 2020.1 brings a broad set of improved and new capabilities to help build important applications. In addition to the many significant performance improvements accrued through 2019.1 and 2020.1, we are introducing one of our biggest changes in recent SQL history: the Universal Query Cache. This article provides more context on its impact to SQL-based applications at a technical level. #SQL #InterSystems IRIS 13 0 0 607
Article Benjamin De Boe · Jan 22, 2019 1m read Using PMML models in your Business Processes Running predictive models natively in an InterSystems IRIS Business Process has of course always been the goal of our PMML support, but somehow never made it into the kit because there were a few dependencies and choices that needed addressing and answering. Anyhow, thanks to some pushing and code kindly provided by @Amir Samary (Thanks again Amir!), we finally got it wrapped in a GitHub repo for your enjoyment, review and suggestions. #Analytics #Business Operation #Interoperability #InterSystems IRIS 1 2 3 363
Article Benjamin De Boe · Jan 31, 2018 4m read Introducing the InterSystems IRIS Connector for Apache Spark With the release of InterSystems IRIS, we're also making available a nifty bit of software that allows you to get the best out of your InterSystems IRIS cluster when working with Apache Spark for data processing, machine learning and other data-heavy fun. Let's take a closer look at how we're making your life as a Data Scientist easier, as you're probably already facing tough big data challenges already, just from the influx of job offers in your inbox! #AI #Analytics #Big Data #Distributed Data Management #Java #Machine Learning #Sharding #InterSystems IRIS 2 2 0 1,123