The world of database management can be a complex one. Applications continue to be built on top of special-purpose databases that make it hard to merge data. New innovations such as Internet of Things (IoT) sensors are generating never-before-seen quantities of data that must be integrated as well. Here we’ll look at how businesses…
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…
Databases Databases are everywhere. They store data and information organized by fields and tables. There are different types of databases that organize data into relational tables, hierarchical structures, networks, and objects. Databases can be personal, corporate, and shared resources. They can be used for recording business transactions to support decision making. The value of…
The era of data warehouse appliances is coming to an end, rapidly being replaced with a new generation of cloud services. The first data warehouse appliance was introduced onto the market in 2003. For nearly 15 years, this market grew with several large technology players, including IBM, Oracle, and Teradata developing or acquiring database…
A few months ago, Gartner published an update on the database market, which is highlighted in Adam Ronthal’s blog “There is only One DBMS Market” and made a rather profound declaration – the database markets have collapsed. No, the market isn't crashing, it is having the best year ever, what has happened is the…
Why Embedded Software Application Developers Loath Databases Last week I wrote an initial blog on flat files and why embedded software application developers readily adopted them. Simply put, they’re always there – if you’ve got an Operating System that’s more than a bare-bones executive kernel it’s there and it’s free. Also, flat files are…
Artificial Intelligence (AI) systems seem to be everywhere and for a good reason. AI represents the next generation of computing capabilities. It is leveraging the speed and scale of cloud computing to deliver not only high-speed automation but also continuous learning and adaptation capabilities that can finally match the pace of change in the…
Managing and analyzing heterogeneous data is a challenge for most companies, which the oncoming wave of Edge Computing-generated datasets has only exacerbated. This challenge stems from a rather large “data-type mismatch” as well as how and where data has been incorporated into applications and business process. How did we arrive here? At one time,…
Actian delivers an operational data warehouse as a managed service in the cloud. Its developer-friendly high-performance analytics engine has been proven to outperform other popular analytics platforms without specialized hardware or complicated software development. Actian requires minimal setup, provides automatic tuning to reduce database administration effort and enables highly-responsive end-user BI reporting. This is how to connect…
Modern businesses move fast and the speed of business is accelerating every day with no sign of slowing. To survive, companies must find ways to remove friction in their systems and business processes – leveraging real-time operational data and translating it into actionable insights that drive activities across the company. From strategic decision-making to…
The usefulness of an analytic database is closely tied to its ability to ingest, store, and process vast quantities of data. Data is typically ingested from multiple sources such as operational databases, CSV files, and continuous data streams. In most cases, daily data loads are measured in tens or hundreds of millions of rows,…
The Internet of Things (IoT) World conference is the largest IoT event in the world, combining some 12,000 industry professionals and innovators with hundreds of workshops, breakout sessions, and a 100,000 square foot expo hall filled with more than 300 exhibitors and startups. The event takes place between Monday, May 14 and Thursday, May…
OLAP (OnLine Analytical Processing) Cubes are used extensively today, because it is impossible for many database platforms to analyze large volumes of data quickly. This is because most database software does not fully leverage computing power and memory to deliver optimal performance. Some of the symptoms of this are: Large queries end up hogging…
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…
Actian is sponsoring three challenges on Topcoder this month, featuring our Vector and Zen database products and thousands of dollars in prizes. All you need to do is sign on to Topcoder (for free), read and follow the instructions for the competition, and win! It's that easy. Now, the challenges themselves are all different,…
Last November we announced that Actian Vector - Community Edition, our high-performing SQL analytics solution for the cloud, launched for free on the AWS Marketplace. Now we're happy to announce that a similar version has now been released on the Microsoft Azure Marketplace in a similar free-to-use pricing model. If you are a SQL…
