The Alpha platform is a unified mobile and web app development and deployment environment with distinct "no-code" and "low-code" components. The vendor says that using the Alpha TransForm no-code environment, business users and developers can take full advantage of all the capabilities of the smartphone to turn any form into a mobile app in minutes, and power users can add advanced app functionality with Alpha TransForm's built-in programming language. IT developers can use the…
$35
Db2
Score 8.6 out of 10
N/A
DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.
The speed of development from concept, through development and delivery of the end product is so impressive [with Alpha Anywhere]. There is an impressive array of genies and helper functions meaning that you can focus on what matters, the end user experience. It is not a "No code" solution but it is a very impressive "low code" solution which allows detailed access under the hood to tweak the applications to your own needs and the needs of your clients.
I have primarily used it as the basis for a SIS - but I have migrated more than a few systems from there database systems to DB2 (Filemaker, MySQL, etc.). DB2 does have a better structural approach, as opposed to Filemaker, which allows for more data consistency, but this can also lead to an inflexibility that can sometimes be counterintuitive when attempting to compensate for the flexibility of the work environment as Schools tend to have an all in one approach.
Our company had been creating small business applications since the 1980's, when we used DBase IV (don't laugh... that's what was available). Then, we got more "sophisticated" with Microsoft Access. Clearly, we would always be limited with what we can do with those two programs. By accident, during an Internet search, we saw and ad for Alpha Anywhere (back then, it was called Alpha V). After working with the 30 free trial for just two weeks, we retired Access, for good. The best part was Alpha's flexibility in its use of "back end" data tables. That allowed us to use existing Access tables as we redesigned the front-end program (Alpha ships with its own DBF system, but we prefer SQL-Based tables). You can choose, SQL Server, MySQL, Oracle, Access, Paradox (actually, too many to name) for your tables. You can even create links to Excel spreadsheets or QuickBooks Tables. It's outstanding!
Alpha allows developers to create very large and very complex programs. However, it's also a great choice for RAD (Rapid Application Development) for those who need to be up and running quickly or for less experienced programmers. Actually, the interface truly allows for "codeless" development of your application (more on that later). That means you can design a fully functional application, without typing a single line of code. They have some examples on their website.
My favorite part of Alpha is that it is constantly adding features and functions that allow us to do more with our applications. In fact, one of my biggest problems is that I need more time to learn and practice the added features as fast as they are introduced
Prior to Alpha Anywhere, we never considered creating/developing "mobile" applications (for tablets, smartphones, etc.). Alpha created a unique "panel" system that makes those application work great... and allows for the design of very sophisticated Apps.
The DB2 database is a solid option for our school. We have been on this journey now for 3-4 years so we are still adapting to what it can do. We will renew our use of DB2 because we don’t see. Major need to change. Also, changing a main database in a school environment is a major project, so we’ll avoid that if possible.
You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
I have never had DB2 go down unexpectedly. It just works solidly every day. When I look at the logs, sometimes DB2 has figured out there was a need to build an index. Instead of waiting for me to do it, the database automatically created the index for me. At my current company, we have had zero issues for the past 8 years. We have upgrade the server 3 times and upgraded the OS each time and the only thing we saw was that DB2 got better and faster. It is simply amazing.
The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
Easily the best product support team. :) Whenever we have questions, they have answered those in a timely manner and we like how they go above and beyond to help.
Alpha Anywhere is a full-stack IDE. It’s no code and low code, but you can also custom code if you need to. About 10% of our application is no code. 80% is low code and 10% is custom code.
DB2 was more scalable and easily configurable than other products we evaluated and short listed in terms of functionality and pricing. IBM also had a good demo on premise and provided us a sandbox experience to test out and play with the product and DB2 at that time came out better than other similar products.
By using DB2 only to support my IzPCA activities, my knowledge here is somewhat limited.
Anyway, from what I was able to understand, DB2 is extremely scallable.
Maybe the information below could serve as an example of scalability.
Customer have an huge mainframe environment, 13x z15 CECs, around 80 LPARs, and maybe more than 50 Sysplexes (I am not totally sure about this last figure...)
Today we have 7 IzPCA databases, each one in a distinct Syplex.
Plans are underway to have, at the end, an small LPAR, with only one DB2 sub-system, and with only one database, then transmit the data from a lot of other LPARs, and then process all the data in this only one database.
The IzPCA collect process (read the data received, manipulate it, and insert rows in the tables) today is a huge process, demanding many elapsed hours, and lots of CPU.
Almost 100% of the tables are PBR type, insert jobs run in parallel, but in 4 of the 7 database, it is a really a huge and long process.
Combining the INSERTs loads from the 7 databases in only one will be impossible.......,,,,
But, IzPCA recently introduced a new feature, called "Continuous Collector".
By using that feature, small amounts of data will be transmited to the central LPAR at every 5 minutes (or even less), processed immediately,in a short period of time, and withsmall use of CPU, instead of one or two transmissions by day, of very large amounts of data and the corresponding collect jobs occurring only once or twice a day, with long elapsed times, and huge comsumption of CPU
I suspect the total CPU seconds consumed will be more or less the same in both cases, but in the new method it will occur insmall bursts many times a day!!
Allows for a great return on investment since you can quickly become very productive and complete more projects and applications in a shorter period of time with hand coding and the normal programming headaches of PHP, C#, Angular, etc.
You can afford to take on more and smaller projects since they will require far less time to complete than more traditional development environments.
Alpha Anywhere is continuously updated coming out with new features and capabilities on essentially a daily basis. Continuous improvement and frequent updates allows you to always stay ahead of the curve and competitors.
Alpha Anywhere allows you to offer lower cost solutions that will be completed in less time and that will be much easier to support and maintain.
There is great value the solution brings when it comes to building stored procedures and ongoing tasks that allows our team to streamlines processes.
The platform has allowed us to see value by providing a solution for data structuring and data hygiene which prevents deduplication of data and lowers costs
With the integration capabilities it allows our analytics team to more seamlessly create highly visible dashboards that see directly into the data and pinpoint areas that need attention.
