Data Warehouse Features

Read what people say are the most valuable features of the solutions they use.
it_user555939 says in a Pivotal Greenplum review
Information Architecture Specialist (TOGAF Certified) at a comms service provider
* It's one of the fastest databases in the market. * It's easy to use. * From a maintenance perspective it's a good product. * The segmentation, or architecture of the product is different than other databases such as Oracle. So even in 10 years, the data distribution for such segments will not affect other segments. * The query performance of the product, for complex queries, is very good. * It has good integration with Hadoop and Big Data. View full review »
Chris Bradham says in an Oracle Exadata review
Senior Technical Director at a consultancy with 51-200 employees
We primarily run OLTP with some reporting. With that being said, the feature that provides us the most performance gains is the Smart Flash Cache for the OLTP databases. The "offloading" capabilities provide the biggest performance gains for Reporting such as smart scans and storage indexes. There is a new security feature which allows disabling ssh to the storage servers which will make my security folks very happy. Also, there is a STIG script for hardening storage servers and Database Nodes which can be implemented as a report only or actually implement security settings. Would advise running report first to assess the results and then manually modify, as needed. View full review »
Johan Bornman says in a SAP IQ review
Snr DBA at a insurance company with 1,001-5,000 employees
The most valuable features of the product are the column structure, speed, and compression. Partitioning is one of the most useful features with SAP IQ. It was something that they used to charge a lot for but it costs less now. View full review »
BrenoNunes says in a Teradata review
Auditor Federal de Finan├žas e Controle with 1,001-5,000 employees
The feature that we find most valuable is its ability to perform Massive Parallel Processing. View full review »
Padmanesh NC says in a Snowflake review
Big Data Solution Architect - Spatial Data Specialist at Sciera, Inc.
* Scalability. This solution has the ability to load a huge number of datasets (I have experience with petabytes of data) and process them. Storage is not limited, and we can increase what we want. * Performance. The distributed architecture of Snowflake has the capacity to process huge datasets faster and allows us to scale up and down according to our needs. * Flexibility. This feature is helpful for the user to increase the node size and config depending on their need. There is no need to wait for hardware to be in place whenever we increase the dataset. Snowflake provides the option to increase the node or cluster size whenever required. * Multi-formatted accessibility. The Snowflake engine has the capability to read the following file formats: CSV, DELIMITER, FIXEDWIDTH, AVRO, JSON, BZIP2, GZIP, LZOP. The user can choose which format is best for their requirements. * Configuration. Even though its running in the AWS platform, it beats their platform product. I feel more flexible with this solution than I do with Redshift. * Snowpipe. Snowpipe is a better system to feed stream data to the Snowflake database. View full review »
business650640 says in a Netezza review
Senior Consultant at a software R&D company with 1,001-5,000 employees
High performance RDBMS appliance optimized for data warehousing and enterprise reporting. Very simple to manage huge volumes of data without having to worry about indexing and partitioning. Automated compression of tables without any custom scripting or manual intervention. Achieved almost 3x compression effortlessly which meant that 12 TB of data compressed into around 4 TB. View full review »
Robin Saikat Chatterjee says in an Oracle Exadata review
Head of Oracle Exadata Centre of Excellence at a tech services company with 10,001+ employees
Ksplice, Prevalidated Oracle RPMS , the testing done with Oracle database and weblogic and the UEK kernel have made Oracle linux systems best for running large oracle databases and other packaged applications.Exadata's IORM and DBRM make it a great consolidation platform. its smartscan feature and flash cache are unparallelled in providing performance. View full review »
Microsoft Dynamics Specialist at Strategix Business Solutions
What I like the most about this solution is the fact that you can basically add capacity behind your data modeling, and you speed up the process before it goes into the Cube holding section. That's a great integration layer. You can basically collect all your data, and then that becomes a staging database for other models, where you can then either report directly with Power BI, or Excel, or other applications, and in more specifically, data Cubes with Microsoft Analysis Services. View full review »
reviewer1033794 says in an Oracle Database Appliance review
IT Systems Manager at a comms service provider with 51-200 employees
The performance of the system is the solution's most valuable aspect. In combination with the database, it gives perfect results. It's a better system than using other kinds of integrated systems. In general, the ODA control is much simpler to use and offers up the best performance. View full review »
I.T. Manager at Egypt Foods group
The security and audit procedures are the most valuable features. View full review »
reviewer1175826 says in a Snowflake review
Solution Architect at a tech services company with 1,001-5,000 employees
The entire managed service operations for the solution is great. Snowflake does everything for us. Whatever version they have, they implement the latest for us; we don't have to worry about any versions, any upgrades, anything else because they handle it. View full review »
Cesar AugustoSiado Leyva says in a Snowflake review
Business Intelligence Consultant at a tech services company with 201-500 employees
The most valuable features are: The multi-clustering: being able to access stored data without contention. Virtual Warehouse (VW) sizing: Change the size of your VW on demand. Zero copy clone: Easy to create development and test environments. View full review »
DrazenOrescanin says in an Oracle Exadata review
Principal Consultant at Poslovna Inteligencija
The most valuable feature is that you have the same familiar environment of an Oracle database but with the additional performance you get from this architecture. View full review »
reviewer860583 says in an Apache Hadoop review
Data Scientist at a tech vendor with 501-1,000 employees
We don't use many of the Hadoop features, like Pig, or Sqoop, but what I like most is using the Ambari feature. You have to use Ambari otherwise it is very difficult to configure. What comes with the standard setup is what we mostly use, but Ambari is the most important. View full review »
reviewer1148196 says in a Pivotal Greenplum review
Site Manager at a tech services company with 51-200 employees
The most valuable feature for us is horizontal scaling. View full review »
Gary Nelson says in a Teradata IntelliFlex review
Senior Technical Architect at a financial services firm with 10,001+ employees
Having continual fallback is good for security. We use the standard TTU utilities. That's what we use with all the different versions. It's faster and more resilient. View full review »
Direct678 says in a SAP BW/4HANA review
Director with self employed
The processes are the most valuable aspect of this solution. You can try to change the way you do business with the customer while we tell the customer that we have Suite 4HANA that they need to adopt because we have at this moment and for that, we have a methodology that is SAP Activate. We use this methodology to discover what your business requirements are. You can get a glimpse of what it is in the ERP, because it's an ERP, and then you can discover which way you to do the business process with the new tools, instead of using the old ones. You need to adopt the business processes that are supported by this new tool, Suite 4HANA because otherwise, you will have the same issues that you had before in ERP in the compromised world when you had a lot of customization because you need to adopt the tool to your business process. We try to push for the cloud version because then you can leverage many other things that are not available in the on-premise version. View full review »
DrazenOrescanin says in a Pivotal Greenplum review
Principal Consultant at Poslovna Inteligencija
It's a good core database. Scalability and performance are very good. I also like the fact the solution is open-source, so you can use it free of charge. View full review »
Servicman67 says in a Teradata IntelliFlex review
Services Manager at a tech services company with 201-500 employees
The solution is the Rolls-Royce of data warehousing. Because of the way it's been developed, and the parallel processing, there's no other system in the world that can touch it. I don't think it's there yet, but if you're using Tableau, it's much more user-friendly when you want to start reporting. On Teradata, I think there are some improvements that need to be done because you still have to be an expert to understand PDCR. View full review »
Bigr67 says in a SAP BW/4HANA review
Manager for BI at a manufacturing company with 1,001-5,000 employees
The most valuable feature is that it's robust. View full review »
Asst. Senior IT Manager at a retailer with 5,001-10,000 employees
There are several features in the product that we use all the time and find very valuable. Data modelling and ETL (Extract, Transform and Load) features are quite extensive in SAP NetWeaver Business Warehouse. We use SAP Business Explorer (BEx) tools for creating reports. The BEx Query and Web template are then published on the SAP Enterprise portal. There are valuable tools in the product. The feature set is pretty robust. BEx Queries published on the SAP Enterprise Portal have excellent features for horizontal drill down, vertical drill down, creating bookmarks and filters. It works with convenient drag-and-drop functionality. It is easy to add and remove key figures. It's an excellent over-all tool for managers to analyze their business. View full review »
COfound677 says in a Pivotal Greenplum review
Co-Founder, Chief of Operations with 10,001+ employees
We chose Greenplum because of the architecture in terms of clustering databases and being able to have, or at least utilize the resources that are sitting on a database. View full review »
Valai Gunapalan says in a Snowflake review
Architect at Sony Corporation of America
The data warehouse is one of the great concepts of Snowflake. The coding plans are also a great feature. You can switch out the values or sizes. View full review »
ITexp677 says in an Apache Hadoop review
IT Expert at a comms service provider with 1,001-5,000 employees
The most valuable thing about this program for us is that it is very powerful and very cheap. We're using a lot of the program's modules and features because we're using software and hardware that can be difficult to integrate. For example, we're using supersets and a lot of old products from difficult systems. We love having the various options and features that allow us to work with flexibility. View full review »
MahalingamShanmugam says in an Apache Hadoop review
User
The most valuable features are the ability to process the machine data at a high speed, and to add structure to our data so that we can generate relevant analytics. View full review »
Sign Up with Email