Big Data. Big Decisions
InformationWeek
Special Coverage Series


Aestiva Offers Array 4GL Database Free

Previously $5,000 per server instance, Aestiva's Array browser-accessed 4GL database and development environment is now free.

Aestiva Software has announced that its Aestiva Array browser-native application development environment, which previous cost $5,000 per server instance, is now available in a free Developer Edition and a $1,500 Professional Edition.

According to Dave Silverberg, a senior manager at the company, the previous free version of Array could only be used for to try out the product, but did not including the commercial business license needed to be used for live business applications; the new Developer Edition does not have that restriction. The Professional Edition includes collaborative and other enterprise-oriented features, and Aestiva also sell support and training services for Array.

Array's components include a relational database engine developed by Aestiva, and Rapid Application Development (RAD) environment, including Aestiva's HTML/OS 4GL programming language. "To us, 4GL means true integration of the database into the programming environment," says Silverberg. "In our case, it's also integrated into the Web environment, so, for example, if you want to pull a record from the database and put it into an HTML form, it only takes one call, versus environments like MySQL, or Microsoft or Oracle's, where there's programming at every step. And the same is true in the other direction, reading data in."

This integration, according Silverberg, "is why programming Array needs so much less code. See examples on our site, like the one on how to write a database editor in four lines of code."

According to Silverberg, Aestiva Array is used for business and commercial applications, like inventory, a user authentication database, or database for vendors, parts or orders -- "Anything that's a custom database application. Array lets groups within a company learn and create a database app within hours, especially if they know some HTML already. The amount of code to do a database application using Array, versus MySQL, should require less than half the technical knowledge and one quarter of the time -- you can create a database application with Array in ten lines of code."

Array can also be used for non-database applications, Silverberg notes; Aestiva also offers applications based on Array, such as its Power Office.

Users access Array applications via a web browser as the client program. Browser-native, says Silverberg, "implies a software product that works through a browser, without the aid of any other software, including browser plug-ins. It's all server-side, there are no browser dependencies, no ActiveX, so any browser that's come out within the past five years should be able to work." However, Silverberg adds, developers can create applications that use JavaScript.

According to Aestiva, Array minimizes the IT staff/expertise requirements to learn use and support it, including:

  • Array's programming language is simple enough that most programmers should be able to be programming databases and other applications within a few hours, according to the company.
  • No web-server-specific settings needed, e.g., for Apache or for Microsoft IIS, reducing an SMB's need for expertise in these applications.
  • Since Array is a 4GL (fourth-generation programming language), a project should not need a Database Administrator (DBA).
  • Array uses a security-by-default architecture, "so there's typically no need for a security team.
  • Since the client is a web browser, end users need less IT support.

The Aestiva Array runs on Windows, Linux, Unix and MacOS 10. "Almost any hosting provider with CGI capability can host our technology; we have several partner sites with the software pre-installed and configured," notes Silverberg.

By making the Developer Edition of Array available at no cost, "We are is bringing ourselves in line with many Open-Source tools, making it free for developers, including some support through our HTMLOS.org site, and offering paid support, and more features," says Silverberg. (Note: Aestiva Array itself is not Open-Source; the company does provide the HTML/OS source code for many of the business applications it offers that use Array.)

"We've been using Aestiva for database-driven applications since it first came in '90s," says David Harris, owner, Alpha Dog, Inc., a Delaware, Ohio-based web design and marketing service firm. "It's the best 4GL we've found. Now that it's free, we can include it in every site we build, so that those features are there, in case we need them. In some cases, we may need to upgrade to the Professional version, but in most cases, the free version will suffice."

"Although we also work in the LAMP environment, Aestiva Array is our primary and our preferred language, the free developer version of Aestiva is an incredible opportunity for us," says Connie Kelly, President, TelState International Corporation, which has been developing Aestiva Array applications since 1998. "It means that we can develop and install 4GL business applications for our small business customers or web applications for our corporate customers without charging for the software."



Related Reading


More Insights




Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

BYTE encourages readers to engage in spirited, healthy debate, including taking us to task. However, BYTE moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing/SPAM. BYTE further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.

Follow InformationWeek

By The Numbers

What Are Your Primary Concerns About Using Big Data Software?

Base: 417 respondents at organizations using or planning to deploy data analytics, BI or statistical analysis software
Data: InformationWeek 2013 Analytics, Business Intelligence and Information Management Survey of 541 business technology professionals, October 2012

What Do You Think?

What's your attitude about SQL analysis on top of Hadoop?
We want fast, standard SQL analysis capabilities on Hadoop ASAP
Hadoop is for unstructured data; SQL is for relational databases
We'll give SQL on Hadoop a try, but relational DBs will remain the mainstay
Given strong SQL support on Hadoop, we'd nix the data warehouse
We're not interested in Hadoop
No opinion



Related Content

From Our Sponsor

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Business leaders often need a visual snapshot of data to quickly grasp and use it. This paper identifies five challenges in presenting data and how visual analytics can resolve them. Solutions are suggested to overcome the challenges of: speed, data clarity, data quality, displaying meaningful results, and dealing with outliers.

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Today's competitive advantage requires a deeper understanding of your business, your market and your customers. As an IT executive, you can drive that knowledge transformation. In this white paper, learn how to make decisions as a strategic business leader and three steps to begin an analytics initiative within your enterprise.

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

High-performance data visualization turns sophisticated analyses into meaningful graphics, leading to faster and smarter decision making. In this white paper, learn how visual analytics can transform big data, with additional features such as real-time functionality, mobile compatibility, robust applications for technical groups and accessibility for nontechnical users.

Big Data: Lessons from the Leaders

Big Data: Lessons from the Leaders

Financial performance, competitive advantage, operational efficiency, strategic decision making - every business goal can extract value from big data, and the time for doubt or inaction has long passed. In this Economist Intelligence Unit report, in-depth interviews with data pioneers reveal the link between the effective use of big data and the bottom line among other results.

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Which came first, the data or the decision? This white paper makes the case for having a decision in mind, then tailoring big data's volume, variety and velocity to achieve business results such as overcoming customer dissatisfaction or creating well-informed strategies in real time.

Informationweek Reports

Research: The Big Data Management Challenge

Research: The Big Data Management Challenge

The challenge of big data is real, but most organizations don't differentiate 'big data' from traditional data, and nearly 90% of respondents to our survey use conventional databases as the primary means of handling data. We'll help you understand what constitutes big data (it's not just size) and the numerous management challenges it poses.