ValueEdge: Value Stream Management
Align corporate investments with business strategy
Continuous quality from requirements to delivery
Scale enterprise SCCM with security and compliance
Resilient AI-powered functional test automation
Enterprise-level requirements management
Deliver continuous application performance testing
Plan, track, orchestrate, and release applications
Govern quality and implement auditable processes
Automate deployments for continuous delivery
Build business applications using new tools & platforms
The leading solution for COBOL application modernization
Modernize mainframe applications for the Cloud
Modernize host application access
Discover the future of CORBA
Modern mainframe application delivery for IBM Z
Secure, zero-footprint access to host applications
Access host data and automate processes with RPA
Multi-factor Authentication for IBM z/OS endpoints
Build secure software fast
Augment human intelligence
Discover, analyze, and protect sensitive data
Drive IT ecosystem with identity-centric expertise
Deliver simplified, secure access to users
Scale to billions of identities with IGA platform
Gain control of privileged user activities
Track changes and activities in managed services
Get fast, accurate detection of threats
Analytics for text, audio, video, and image data
Reduce risk, cost, and maintenance, and T2M
AI and machine learning for data analysis
Enterprise backup/disaster recovery
Unified traditional and mobile device management
Meet regulatory & privacy retention requirements
Email, IM, and chat-based collaboration
Mobile workforce communication & collaboration
Secure critical file storage and print services
Manage IT & non-IT services with automation and AI
Discover, monitor, and remediate with AIOps
Monitor and optimize complex networks
Discover, manage, and map configurations & assets
Accelerate provisioning with governance in place
Automate and orchestrate processes end to end
Manage IT & software assets for better compliance
Automate server provisioning, patching, and compliance
Automate screen-based human actions with robots
All Micro Focus learning in one place
Build the skills to succeed
Streamline software delivery for faster value
ValueEdge: Value Stream Management
Align corporate investments with business strategy
Continuous quality from requirements to delivery
Scale enterprise SCCM with security and compliance
Resilient AI-powered functional test automation
Enterprise-level requirements management
Deliver continuous application performance testing
Plan, track, orchestrate, and release applications
Govern quality and implement auditable processes
Automate deployments for continuous delivery
Access all products in application delivery management
Modernize Core Business Systems to Drive Business Transformation
Build business applications using new tools & platforms
The leading solution for COBOL application modernization
Modernize mainframe applications for the Cloud
Modernize host application access
Discover the future of CORBA
Modern mainframe application delivery for IBM Z
Secure, zero-footprint access to host applications
Access host data and automate processes with RPA
Multi-factor Authentication for IBM z/OS endpoints
Access all products in Application Modernization & Connectivity
Security at the core to everything you do; Operations, Applications, Identity and Data
Build secure software fast
Augment human intelligence
Discover, analyze, and protect sensitive data
Drive IT ecosystem with identity-centric expertise
Deliver simplified, secure access to users
Scale to billions of identities with IGA platform
Gain control of privileged user activities
Track changes and activities in managed services
Get fast, accurate detection of threats
Access all products in CyberRes
Trusted, proven legal, compliance and privacy solutions
Analytics for text, audio, video, and image data
Reduce risk, cost, and maintenance, and T2M
AI and machine learning for data analysis
Enterprise backup/disaster recovery
Unified traditional and mobile device management
Meet regulatory & privacy retention requirements
Email, IM, and chat-based collaboration
Mobile workforce communication & collaboration
Secure critical file storage and print services
Access all products in Information Management and Governance
Simplify Your IT Transformation
Manage IT & non-IT services with automation and AI
Discover, monitor, and remediate with AIOps
Monitor and optimize complex networks
Discover, manage, and map configurations & assets
Accelerate provisioning with governance in place
Automate and orchestrate processes end to end
Manage IT & software assets for better compliance
Automate server provisioning, patching, and compliance
Automate screen-based human actions with robots
Access all products in IT Operations Management
Give your team the power to make your business perform to its fullest
Improve the delivery of time-sensitive data and analytics of semiconductor/electronics manufacturing data.
The company’s legacy database, Microsoft SQL Server, was adequate for basic operational needs. However, the largest customer was approaching 60 TBs of compressed data (300-400 TBs of uncompressed data), which pushed SQL Server past its limits. The IT team had to decide which data to delete or shorten retention times, limiting the amount of historical information accessible for analytics. In addition to resolving data retention issues, Optimal Plus also sought to improve its predictive algorithms to ensure supreme uptime of plant assets. The company considered EXASOL, ParAccel, and Vertica solutions.
Headquartered in Holon, Israel, Optimal Plus last year processed data on 50 billion ICs and boards, which was up 15 billion year over year. Compared to homegrown data-collection alternatives, the company’s holistic software enables seamless visibility across distributed supply chains. Developed for the Industrial Internet of Things (IIoT), the software connects to various plant assets, sensors, and devices to record, store, and analyze continuous streams of data.
“We chose Vertica, the market leader in column store compressed databases,” says Michael Schuldenfrei, Chief Technology Officer for Optimal Plus.
Michael Schuldenfrei – CHIEF TECHNOLOGY OFFICER
Optimal Plus
During tests, Schuldenfrei and Alon Malki, the company’s Chief Architect, saw that they could load and process data in the database at speeds which were significantly faster than with their legacy database.
Michael Schuldenfrei – CHIEF TECHNOLOGY OFFICER
Optimal Plus
Regarding the solution’s fast query speeds, Schuldenfrei explains, “We can answer every query in scales that we couldn’t before. A million data points would take 30 seconds in SQL and processing a billion would take forever. We calculated 17 different statistical functions on 2 billion data points in less than a minute, which is faster than our previous system would have taken or any other system I’m aware of would have taken just to retrieve the data.”
Optimal Plus is now able to run analytics which would have never completed execution in SQL Server, according to Malki.
“We’ve removed the limitations we had before with the amount of data we could store and the size of queries we can do for customers,” Malki says.
Optimal Plus addressed its scalability requirements, as Vertica uses commodity servers instead of expensive, specialized brands. That will make horizontal scalability cost efficient and practically endless. Additionally, the high compression rate of Vertica can generate significant savings.
“The compression rate is so good in Vertica that databases are much smaller than the real data you inject into them. That can lead to significant savings in hardware and licensing costs,” Schuldenfrei says.
Using Vertica, Optimal Plus can compare historical data with almost-instant test information to predict faults and prevent downtime. Optimal Plus analysts create historical baselines, form models from the history, and launch the models into customer facilities to receive actionable insights.
Malki notes that 95% of customer data resides in Vertica, which functions as an index on top of Hadoop software. “We’ve successfully piloted the combined Vertica-Hadoop solution for a customer,” Malki says. “We’ll drive this out fully over the next couple of months.”
The company plans to create a “hot” environment by storing recent data for fast ad hoc queries. Older data will be stored in a “cold” environment, utilizing Hadoop for longer retention. “This arrangement will leverage Vertica’s ability to query data off Hadoop, which it does extremely well,” Malki says.
In production environments where errors can cause profit loss, Optimal Plus customers are enjoying prompt analytics with a solution that integrates numerous data islands.
“Companies demand that analytical tools integrate with their ecosystems and we deliver that. We’re delighted with the platform and Vertica team. They’ve supported us each step of the way,” Schuldenfrei concludes.
