IT Central Station is now PeerSpot: Here's why
Buyer's Guide
Data Warehouse
July 2022
Get our free report covering Oracle, Amazon, Oracle, and other competitors of IBM Db2 Warehouse. Updated: July 2022.
622,645 professionals have used our research since 2012.

Read reviews of IBM Db2 Warehouse alternatives and competitors

Donghan Kim - PeerSpot reviewer
e-Business Department Professor at MANU MEDITEC
Real User
Top 10
Not dependent on third-party vendors
Pros and Cons
  • "We selected Apache Hadoop because it is not dependent on third-party vendors."
  • "Real-time data processing is weak. This solution is very difficult to run and implement."

What needs improvement?

Apache Hadoop's real-time data processing is weak and is not enough to satisfy our customers, so we may have to pick other products. We are continuously researching other solutions and other vendors.

Another weak point of this solution, technically speaking, is that it's very difficult to run and difficult to smoothly implement. Preparation and integration are important.

The integration of this solution with other data-related products and solutions, and having other functions, e.g. API connectivity, are what I want to see in the next release.

For how long have I used the solution?

We've started using Apache Hadoop since 2011.

Which solution did I use previously and why did I switch?

We selected Apache Hadoop because it is not dependent on third-party vendors. Previously, our main business unit was related to big vendors like IBM, Oracle, and EMC, etc. We wanted to have a competitive advantage in technology, so we selected the Apache project and used Apache open source.

What about the implementation team?

The solution was implemented through a local vendor team here in Korea.

Which other solutions did I evaluate?

We evaluated IBM, Oracle, and EMC solutions.

What other advice do I have?

My position in the company falls under the research and development of new technologies and solutions. I investigate, research, download, and read information and reports as part of my job.

Our company has a big data business division, and we propose, develop, and implement things which are related to big data projects. We are using Cloud Hadoop open source versions, distributed versions, and commercial Hadoop distributed versions. We propose all these versions to our customers from any industry.

Our focus is on the public sector. Big data is our strong point in Korea. Our company is the leader in big data technology, including infrastructure and visualization. This is a solution we provide to our customers. We are also in partnership with IBM. Our main focus is on Apache Hadoop.

We provide Apache Hadoop to our customers. I work for a systems integrator and technical consulting company.

Overall, our satisfaction with this solution is so-so. We continuously investigate new technologies and other solutions.

The Hadoop open source version was implemented in 95% of our company's customer base. Our remaining customers had the local vendor's Hadoop platform package implemented for them.

Our company is in the big data business. Before the big data business back in 1976, we implemented BI (business intelligence), DW (data warehouse), EIS, and DSS (decision support system), so we are in partnership with IBM.

I don't have advice for people looking into implementing this solution because I'm not in the business unit. I'm in the research field. My role is to plan new technology and provide consultation to our customers for big data projects in the early stages.

My rating for Apache Hadoop from a technical standpoint is eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
reviewer1501218 - PeerSpot reviewer
Managing Director at Jet iT Ltd.
Real User
Top 20
Good multi-platform SQL compatibility, as well as performance and data integrity
Pros and Cons
  • "The deployment of our solution across a number of servers using Ingres .NET has meant that we can protect the database server behind a highly secure firewall and deploy the front end solutions on a normal web server."
  • "The ability to reset the log file without stopping the DBMS would be helpful for us."

What is our primary use case?

We currently run Web server solutions (CMS, CRM business solutions).

Our CMS solution is obviously very text-oriented, and our CRM Business Solution was built for a finance and asset management business, which is capable of handling millions of transactions.

Performance, access control, data integrity are fundamental to any application but we have been able to more than satisfy our clients with the solutions we have delivered.

We have Ingres running on an AWS Linux server. We have Windows Server running front end solutions using Ingres OpenRoad and Linux Servers serving Web Applications through Apache and PHP.

How has it helped my organization?

Ingres is the only database solution that has maintained a level of consistency and integrity about the way users interact with it. As a database administrator, there is a level of transparency and control at all levels.

Over the last few years, we have migrated all of our business functional logic into database procedures, which improves performance significantly and allows us to alter our development tools/programming languages easily.

Our products CK5 and JS5 are offered as SaaS solutions through jetpac.co.nz

What is most valuable?

The deployment of our solution across a number of servers using Ingres .NET has meant that we can protect the database server behind a highly secure firewall and deploy the front end solutions on a normal web server. The User is never exposed to any configurations or logins other than their own initial identification.

The SQL capability is consistent across all platforms. This means that we can code into our PHP functions to manage the database so that the users can be generally self-sufficient and requiring DB support only rarely.

What needs improvement?

Whilst our server up-time is in the > 99%, we still have to reboot the DBMS periodically to allow us to archive the log file. The ability to reset the log file without stopping the DBMS would be helpful for us.

We have created our own error management/reporting process within our database procedures. Unfortunately, if there is a database error, such as a duplicate key, the default action is to abort. This means that our information is generally lost. An option to not abort on failure would be great. Of course, this only really occurs in testing.

For how long have I used the solution?

I first came across Actian Ingres in 1992 and have been using it in all of my solutions since then.

What do I think about the scalability of the solution?

It is completely scalable, as the Query Execution Process is completely dynamic based on the current number of rows and efficiency of the index structures.

Which solution did I use previously and why did I switch?

We did not use another solution, as this was a greenfield opportunity

Which other solutions did I evaluate?

We evaluated Oracle and DB2.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Data Warehouse
July 2022
Get our free report covering Oracle, Amazon, Oracle, and other competitors of IBM Db2 Warehouse. Updated: July 2022.
622,645 professionals have used our research since 2012.