November 9, 2021 Performance Testing Production Workloads for Ingres and Vector One of the main concerns of Ingres and Vector customers whose systems need to undergo a significant change, such as major version upgrades, OS migration, major software releases, increased volumes of usage, etc, is how to properly test the database under realistic conditions in a test environment. Some customers have heard of the Query,… Read More
October 3, 2019 Your Dreams Are Our Dreams I recently had the privilege of presenting at Insight Technology’s db tech showcase in Tokyo. The night before my presentation my colleagues and I had been invited to a meal with one of our partners. At the end of the meal, one of my colleagues was thanking our hosts for a wonderful meal and… Read More
March 8, 2019 Connecting to an Actian X (Ingres) Database from PHP via JDBC We have documented the best way to connect from PHP to an Ingres database via ODBC in an Actian Knowledge Base article called Ingres ODBC with PHP and in a previous post, Connecting to Actian X (Ingres) with PHP and NGINX. Sometimes, however, due to limitations, users may need to use JDBC instead of ODBC… Read More
March 29, 2018 Ingres (Actian X) Disaster Recovery Most production Ingres (now called Actian X) installations have a need for some degree of disaster recovery (DR). Options range from shipping nightly database checkpoints to off-site storage locations to near real-time replication to a dedicated off-site DR site. Ingres, Actian's enterprise hybrid database, ships with built in checkpoint and journal shipping features which… Read More
February 26, 2018 Get Ready for the Gartner Data & Analytics Summit 2018 in Grapevine, Texas The next big data and analytics conference is right around the corner with the Gartner Data & Analytics Summit, hosted at the Gaylord Texan Resort Hotel & Convention Center in Grapevine, Texas from March 5-8, 2018 and Actian will be present, both on the show floor and in a presentation. Emma McGrattan, SVP, Engineering, will… Read More
February 9, 2018 Automatically Synchronize Your OLTP and OLAP Tables in Actian X (Ingres 11) A key feature of the latest update to our hybrid database Actian X (Ingres 11) is the inclusion of the x100 analytics engine and support for x100 tables. Adding a world class analytics engine to Actian X’s enterprise OLTP (OnLine Transaction Processing) capability enables a new class of applications that can mix OLTP and analytic… Read More
December 19, 2017 Database History in the Making: Ingres Meets X100 Doug Inkster is an Actian Fellow with a long history in the database market, starting with IDMS in the 1970’s and moving to Ingres in the 1990’s. We asked him to reminisce about the most exciting times in his long career. Here are some of his thoughts: In my 40+ years of working with… Read More
September 21, 2017 Delivering Real-Time Reporting at Speed and Scale When a major UK logistics company wanted to improve reporting for its large accounts, they turned to Actian to design, implement and support the underlying database system (“LARS”) using Ingres, HVR and Vector products for its architecture. The Brief The customer had around 100 Customer Accounts Representatives dedicated to large accounts, with each Rep… Read More
August 8, 2017 Can Your Applications Find You? One important trend in database management is integrating location data better to improve insights about events and activities that matter to your business. …Interest in analyzing geospatial/location data has increased over the past four years from 26% to 36%.” Source: Gartner Survey Analysis: Big Data Investments Begin Tapering in 2016, September 2016 Tracking customer… Read More
May 30, 2017 Predictions for the hybrid data landscape The Age of Data has arrived, with new data sources, targets and processing models proliferating madly across enterprises of all sizes. While data has never been more valuable to a business — it now informs the who, what, where, when and how of decision making — this new hybrid data landscape introduces new challenges.… Read More
April 27, 2017 Introducing Actian X – the new Ingres Last week, Actian introduced the the new Ingres - Actian X Hybrid Database, combining the industry-leading Ingres RBMS with the record breaking analytic database Vector. With column-based storage, vector processing, multi-core parallelism (and more), Actian X puts amazing performance in the hands of Ingres developers. We've also bundled two other really big features: 1)… Read More
April 26, 2017 HTAP at Actian: The Best of Both Worlds in Data Management One of the most exciting trends for the balance of this decade will be HTAP, or Hybrid Transactional/Analytical Processing - a recently-coined term representing the next generation of hybrid, converged software infrastructure that can handle both traditional Transactional Data Management AND modern Analytic Data Management workloads. Every business is struggling to find new tools… Read More
April 19, 2017 Hybrid Data is a Gamechanger Imagine this scenario - you have just "clicked" on an item that you are ordering online. What kind of "data trail" have you generated? Well, you are sure to have generated a transaction - the kind of "business event" that goes into a seller's accounting system, and then on to their data warehouse for subsequent sales… Read More
April 17, 2017 The Start of Something Really Big It is rare in life that one gets an opportunity to step back, take a fresh look and reset one’s mission and trajectory. For Actian, today is such a day, as we launch a new vision, a new product solution portfolio and of course, a new tag line. Got to have a new tag… Read More
January 12, 2018 Integrating Python with Vector or Actian X Introduction Today we're going to look at how to get started with Actian Vector, our high-performance in-memory analytics database, and Python, one of the most oft-used languages by data scientists in recent times. Using the techniques below, you'll be able to get started with Python using Vector ODBC and JDBC. (You'll be able to use… Read More
December 12, 2017 Connecting to Actian X (Ingres) with PHP and NGINX Not long ago I spoke at the Actian Hybrid Data Conference in London about connecting Actian X (Ingres), Actian's combination of industry-leading transactional and high-speed analytic databases, to the Web. Here we present how to use a very popular web server (reverse proxy, load balancing, etc...) on Linux, NGINX, to do just that. Here's how… Read More
November 27, 2017 The Big Show: Visit Actian at AWS re:Invent 2017 in Las Vegas The largest cloud computing conference of 2017 is now here in AWS re:Invent and it’s taking over Las Vegas in a big way. An estimated 40,000 engineers, product leads, marketers, technical architects, and expert users from around the world will be descending on The Strip, attending keynotes, bootcamps, demos, hackathons, and in-depth hands-on training… Read More
November 15, 2017 Sparking a Revolution at Big Data London If you’re visiting what’s billed as the United Kingdom’s largest data and analytics events, you know that Big Data London at the Olympia promises to be a massive gathering of experts and analysts across the fields of Big Data, machine learning, AI, cloud technologies, and more. You’ll be able to learn from numerous pioneers… Read More