Actian

概述
总部
美国
|
成立年份
2005
|
公司类型
私营公司
|
收入
$10-100m
|
员工人数
201 - 1,000
|
网站
|
推特句柄
|
公司介绍
Actian delivers cloud and On-Premises data solutions that simplify how people connect, manage, and analyze data. We transform business by enabling customers to make confident, data-driven decisions that accelerate their organization’s growth. Our data platform integrates seamlessly, performs reliably, and delivers at industry-leading speeds.
Supplier missing?
Start adding your own!
Register with your work email and create a new supplier profile for your business.
实例探究.
Case Study
Safety Comes First
STRATEC is one of the most innovative medical engineering companies in Germany. The development team was looking for a small but powerful object-oriented database that was available in “embedded mode” and would not require any database administration tasks from end users. The company develops and manufactures fully automated analyzer systems for clinical diagnostics and biotechnology. Main applications are blood group analysis, serological tests for infectious diseases, and immunoassays. About 90% of STRATEC’s products are licensed and sold through OEM customers, who market the systems under their own brands, including the chemical reagents.
Case Study
Actian Ingres: Reliance Mutual relies on Actian Ingres to drive business growth
Reliance Mutual, a UK-based life and pensions company, underwent a significant shift in its business model in 2003. Instead of writing new policies, the company started buying poorly performing existing life and pensions policies from other insurers. This aggressive growth strategy relied on the company's ability to aggregate these disparate policies within a single, highly efficient administration system that could turn the previously unprofitable into a robust income generator. The transition posed a two-fold challenge for Reliance Mutual’s IT department – to build and maintain a database capable of managing tremendous volumes of data, including migrating and integrating blocks of newly acquired policies – and to do so with a staff that had been dramatically reduced as part of a strategic review.
Case Study
Streamlining Invoicing Process in Oil & Gas Industry: A Case Study of Pinnergy and Actian Business Xchange
Pinnergy, a leading diversified energy services company, was facing significant challenges with its manual, double-entry invoicing process. The process was not only tedious but also time-consuming, taking between 30 and 90 days to get an invoice entered into a client’s Electronic Data Interchange (EDI) system. The company's customers, which included a wide range of large and small oil and gas industry firms, did not rely on any common back-office system, making electronic invoicing a complex task. As Pinnergy’s business grew, the order management became even more complex with more customers to invoice and higher volumes of transactions to manage. The invoicing process became a bottleneck, resulting in high transaction costs and accounts receivable aging. Pinnergy officials knew that an electronic invoicing solution would dramatically streamline this process, but the challenge was to find a solution that could integrate with the diverse EDI systems of their customers.
Case Study
Pediatrix Medical Claims Reporting is 80% Faster with Data Integration
Pediatrix Medical Group, a leading provider of maternal-fetal, newborn, and pediatric sub-specialty physician services, was facing significant challenges in its claims processing due to lack of data integration. The company works with multiple clearinghouses for insurance claims and receiving claims status reports, each of which employs unique and complex formats in generating reports. The lack of data integration between internal applications and clearinghouses caused breaks in information flow, slowing down the claims review and reporting process, and creating a disconnect between reporting and other process steps in the Pediatrix patient life cycle. As the volume of the claims increased, these challenges grew more severe, causing bottlenecks and delays in insurance claims processing.
Case Study
C&K Market Rings Up Business with Actian Open Source
C&K Market, a supermarket chain servicing Oregon and Northern California, was facing the need to transition from its legacy VMS platform to a new platform. The company wanted to adopt an open source database solution to take advantage of improved efficiencies, scalability, and low total cost of ownership. The company had been running Ingres on a VMS platform, which was being phased out. The efficient reporting and analysis of pricing and inventory – and effective control of costs – was all enabled through the Ingres Database, an enterprise open source database.
Case Study
Integrated facility services made easy at ISS Switzerland with Ingres and OpenROAD
ISS Switzerland, a leading integrated facilities services company, was in need of a robust ERP back-office solution to support their payroll/HR, accounting, invoicing, and financial reporting needs. In the highly competitive market of facilities management, the company required a strong ERP system that would allow local management to run their business optimally. Additionally, the local entity needed to ensure that it could report its financials back to their corporate business in a timely manner and meet all the financial reporting requirements on an international level. After an exhaustive tender process where ISS Switzerland evaluated many other solutions, the company chose to work with Syslog and implement their ERP solution: Syslog ERP.
Case Study
Versant Object Database
Verite Group was developing a packet reconstruction and network intelligence application, Netscope, which was expected to handle diverse deployment environments and large, complex data streams. The original designs for Netscope called for a relational approach, with the IBM DB2 PureXML to drive the application. However, during testing, it became apparent that the computational cost of retrieving and translating XML from the database into in-memory objects was prohibitive, to the point where enterprise scaling would be limited. Turning to an object-oriented approach, Verite looked to the Hibernate framework and ran simulations with both MySqL and PostGres powering the system. While the object approach proved the right path, the Hibernate setup put a drain on CPU and disk usage, to the point where it impeded performance at even modest network data volumes.
Case Study
Unruly Media Helps Big Brands Target Social Video Campaigns Using Analytics
Unruly Media, a leading global technology platform for social video distribution and analytics, was faced with the challenge of providing its clients with real-time visibility into the social footprint of their videos. This included factors such as reach, shareability, and other elements critical to gaining a competitive business advantage. The company needed a robust solution that could handle the delivery, tracking, and auditing of billions of video views across thousands of social video campaigns for hundreds of brands.
Case Study
NK Transforms Big Data into Actionable Insights that Drive Business Success
NK.pl, a popular social networking service in Poland, was facing a challenge in keeping pace with the changing preferences and behaviors of its 13 million users. The traditional transaction database used by NK.pl was not powerful enough to process the 250 terabytes of data generated by its users in a timely manner. When product managers attempted to run queries against the data, which was spread across 1,500 servers, they faced query response times of three to four weeks. Such slow response times were unacceptable to NK.pl because the data was outdated and meaningless by the time it was received. To optimize product features, marketing efforts, and the experience of its social network members, NK.pl needed a system that could perform both simple and rich queries quickly for intra-day analysis and response in an extremely cost-effective manner.
Case Study
Peerless Foods Eyes Substantial Savings with Ingres Database
With its business growing, Peerless needed a more consistent, flexible platform to modernize its production environment and support future expansion. The company began exploring commercial off-the-shelf enterprise resource planning (ERP) systems and underlying databases. While companies in similar situations often go straight to proprietary vendors, Peerless decided to build its own ERP solution from the ground up. With a team of just a half-dozen developers, Hamilton’s department set out to develop a fully featured business platform that would automate every aspect of the company’s business processes – from forecasting and ordering, to production, packaging, and distribution – in order to enable a highly optimized just-in-time manufacturing process. To support this environment, Peerless required a flexible, scalable database environment that would be easy for developers to optimize around the evolving ERP platform.
Case Study
IoT Integration in ERP: A Case Study of Global Shop Solutions
The advent of the Internet of Things (IoT) has revolutionized the manufacturing industry. The replacement of expensive PLC-based devices with cost-effective IoT-enabled devices has become a norm. Global Shop Solutions, a provider of a popular ERP solution for over 40 years, faced the challenge of meeting customer demands for IoT-enabled options. They needed a lightweight, embedded database solution that could interact efficiently with the Actian Zen database, the core of its ERP solution. The challenge was to find a serverless database that could be embedded within these inexpensive devices to store and process information. Using a tool like SQLite could meet the need for a small-footprint serverless database capable of collecting data, but sharing the data with any server-based database would require a middleware layer to transform the SQLite data into a format that another database could ingest.
Case Study
Streamlining High-Volume Data Acquisition for Insurance Client Onboarding: A Case Study of Hannover Re
Hannover Life Reassurance Company of America (Hannover Re) was facing a significant challenge in onboarding new insurance clients due to the high volume and variety of data and file formats. The existing custom-coded solution was unable to efficiently ingest, transform, or normalize all the data for downstream consumption within the firm. This inability to handle the variety and volume of information slowed down data ingestion and transformation, subsequently delaying downstream analysis by other teams at Hannover Re. The company needed a solution that would not only improve data integration and management but also enable teams to access and use the information without the constant intervention of the IT department.
Case Study
Lufthansa Systems Leverages Actian for Efficient Flight Planning
Lufthansa Systems, a leading full-service IT provider for the airline and aviation sector, faced the challenge of providing a robust and stable database platform to support its own planning and routing software. This software is not only used by Lufthansa but is also licensed to hundreds of airlines globally. The database platform needed to be reliable, capable of real-time data availability, and cost-effective. The challenge was to ensure high levels of uptime and stability, crucial for the smooth operation of thousands of flights and the satisfaction of millions of passengers worldwide.
Case Study
Cloud-Based Employee Spend Management: A Case Study on PredictX
PredictX, a leading provider of predictive expense analytics, faced a challenge when a client required greater insight into their Employee Generated Spend (EGS). The client needed a solution that could provide a comprehensive view of various expenses, ranging from office equipment to meal delivery and entertainment. The challenge was not only to control costs but also to ensure good governance and accountability to shareholders. PredictX had a solution that could meet these needs, but it was not cloud-based. The client had a specific requirement for the solution to be deployed on the Google Cloud Platform (GCP) due to its security and governance features. While PredictX had plans for a cloud-based offering in the future, they needed to expedite this process to meet the client's needs.
Case Study
Lechler Caps Customer Service with Actian-Powered ERP Solution
Lechler GmbH, a German mid-sized company specializing in the manufacture of nozzles and custom spray technology solutions, needed to revamp its company-wide manufacturing technology solution. The company aimed to improve its business processes, enhance and extend its reporting options, and ensure flexibility in its database administration. The ultimate goal was to continuously improve customer service and minimize the time from order to delivery. Prior to the implementation of the new system, Lechler was working with a large data processing center which was very inflexible.
Case Study
Data Integration and PIDX Standards Improve Orders-to-Cash Cycle
Pinnergy, a diversified energy services company, was struggling with an outdated, manually-driven invoicing process. Invoices moved from the dispatch system through customer signoff and then had to be entered into customers’ online electronic data interchange (EDI) systems. This process was tedious and involved significant duplication of effort and data, increasing the potential for errors and disputed invoices. As Pinnergy’s business grew, order management became more complex, with more customers and a higher volume of transactions moving through multiple applications with various data formats to support and no common standard for data exchange. The invoicing process became a bottleneck, resulting in high cost per transaction and high accounts receivable aging.
Case Study
Banca IFIS Banks on Actian Ingres Database for Big Savings and Scalability
Banca IFIS, an independent Italian bank specializing in financing enterprises, faced a challenge when new Italian banking regulations imposed a demand for a higher level of security and data protection. The bank had to evolve its core business application to meet these new challenges. The main issue was the limited time frame available to implement the new version of their application to meet the timeline given to the bank. In less than one year, they had to deliver a cost-effective and scalable solution, a fully unicode enabled database and application to support Banca IFIS expansion, high availability, and a secured infrastructure fulfilling disaster recovery targets imposed by new banking regulations.
Case Study
British Friendly reduces risk and guarantees system availability with Actian Services and Enterprise Management Appliance (EMA)
British Friendly, an income protection mutual company, was running an outdated version of the Ingres database (v2.6) for their M2000 insurance application. The company wanted to upgrade to Ingres v9.2.3 to benefit from the database’s new functionality and new hardware. However, they only had one administrator to manage the M2000 insurance application and lacked the internal resources needed to both upgrade to v.9.2.3 or continue to monitor the Ingres database to ensure their applications and associated systems continue to run smoothly. Furthermore, the company needed to ensure that their internal risk levels were not compromised by upgrading their internal systems.
Case Study
Connecting Machines and Devices
Echelon is a pioneer and world leader in control networks and embedded control networks, which connect machines and other electronic devices. They needed an embedded database compatible with the object-oriented application model. A predecessor of LNS was introduced in 1991, using procedural code and an embedded record oriented/ relational data storage toolkit. As object-oriented programming began to emerge, the team realized that using object-oriented programming was the most productive way to add features and power to the system. At the same time, the team realized that the record oriented storage toolkit was an obstacle to object-oriented development and a big usability problem because it exposed the embedded database structure to their broad OEM programmer community.
Case Study
Increasing Capacity with Versant Object Database and RailEdge® Movement Planner
The Federal Railroad Administration is expecting railroad freight traffic to double by 2020. However, the U.S. railroad infrastructure cannot be expanded to keep pace with this demand. Railroads are confronted with meeting this demand in some other way. GE Transportation Systems, the global technology leader and supplier to the railroad industry, is addressing the problem with RailEdge® Movement Planner, an object-oriented software system incorporating the Versant Object Database. GE Transportation’s customer, Norfolk Southern Railroad, operates 2,500 trains per day over a 21,000-mile system serving every major container port in the eastern United States. Norfolk Southern expects to increase railroad capacity, velocity and efficiency with no new tracks, to increase average network train speed 10 to 20 percent, and to save millions of dollars in capital and expense.
Case Study
On the hunt for the next big medical discovery: Oxford University Clinical Trial Service Unit reduces the data supply process from days to just minutes thanks to Actian Vectorwise
The Clinical Trial Service Unit and Epidemiological Studies Unit (CTSU) of the University of Oxford is involved in extensive bioresearch and healthcare studies. They extract and analyze data related to the causes, prevention, and treatment of chronic illnesses such as cancer, heart disease, and strokes. However, they faced a significant challenge when they realized that their existing database platform could not cope with the large data volumes involved in their research. The legacy platform struggled with complex queries, especially when they involved several thousand fields. The analytics could take days, which was not acceptable for the fast-paced research environment. They needed a solution that could handle high-speed analytics and deliver results within extremely fast timescales.
Case Study
The Pesticides Safety Directorate Eradicates Inefficiency with Actian Ingres Database
The Pesticides Safety Directorate (PSD), an executive agency of the UK Department for Environment, Food, and Rural Affairs, was facing the challenge of keeping pace with rising regulatory challenges without increasing costs. The organization’s mission encompasses ensuring the safety, effectiveness, and regulatory compliance of plant protection products used by both industry and amateur gardeners; regulating a market worth around £450 million in the UK and a similar figure in overseas exports; and shaping UK policies on pesticide issues – all with a staff of only 200. Technology plays a vital role in making this possible. Most recently, Park’s group was called on to deliver a particularly high-profile project – enabling the electronic delivery of all services, followed by the introduction of a complete, end-to-end electronic workflow for the entire new product application and approval process.
Case Study
Actian Vectorwise
The Rohatyn Group (TRG), a hedge fund based in New York, needed a solution to manage risk in the highly volatile market of hedge funds. Information about positions, pricing, and risk is critical to investment decision-making. For tactical decision-making, TRG provided analysts immediate access to the information they needed in a format that they could use through a self-service data access environment. However, the combination of market volatility and a desire to do more strategic analysis drove the need to understand how their positions had performed over time. While the existing solution provided the interactive analysis TRG was looking for, it did not have the historical data. They wanted the user tools to remain the same and the query responses to be interactive, but they needed to do the analysis on more than 1000 times the data.
Case Study
Transitioning from Netezza to Actian: A Cost-effective Upgrade
The Bank’s in-house analytics solution, Netezza, had reached its end-of-life cycle and was not going to be supported by IBM or its channel partners. The Bank needed to create one data repository for all positions across all asset classes, enabling ad hoc analysis of positions and their sensitivity to market factors. The Bank also wanted greater visibility into its risk exposure. It knew that presently, managing client risk and exposure was at 20th-century levels. For example, risk and opportunity value was analyzed via batch data dumps once a day. The Bank needed greater insights, delivered in sub-minute intervals, multiple times a day. It also had additional criteria that had to be met, including improved price/performance levels, ease of development and maintenance, durability, and a palatable TCO.
Case Study
Bucap and Actian X: A Long-Term Solution for Long-Term Archiving
Bucap, a leading document archiving and management services provider, was faced with the challenge of managing and archiving massive amounts of data for public, private, and governmental organizations throughout Italy. The company needed a flexible, scalable database that could enable quick and easy customization of applications in response to evolving business requirements. The data may not be touched for decades, but some of it may be required at a moment’s notice. Bucap’s customers needed assurance that their data was secure and that they could access it without delay if and when necessary. In 1995, Bucap realized that meeting the company’s growth goals would depend on smart investments in IT. They needed to build an archiving solution that would be scalable, reliable, highly available, and easy to maintain to support all the business processes of storage, indexing, retrieving, and displaying documents at the service levels they wanted to offer their customers.
Case Study
Actian Vector: A High-Performance Path Away From Netezza for a Global Bank
A large global bank was faced with a significant challenge when support for its analytics solution, Netezza Twinfin, ended. The bank needed a new analytics solution that would not only replace Netezza but also deliver deeper insights faster, scale with the bank's growth, and keep costs low while delivering high performance. The bank required a solution that would support a single data repository for all positions across all asset classes, facilitating ad hoc analysis of positions and their sensitivity to market factors. The bank also wanted a solution that could ingest, analyze, and act on massive volumes of both structured and unstructured data in short order. The bank had long desired deeper and more timely insights into its risk exposure, as Netezza provided risk and opportunity value analyses only once per day via batch data dump. The bank aimed for a solution that could deliver insights in sub-minute intervals throughout the day. Performance, scalability, reliability, and cost were also critical factors in the bank's decision.
Case Study
Streamlining Invoicing and Improving Cash Flow at Superior Energy Services with IoT
Superior Energy Services, a Houston-based company serving the drilling, completion, and production-related needs of oil and gas companies worldwide, faced a significant challenge in improving its working capital by reducing days sales outstanding (DSO). The company had grown by acquiring hundreds of smaller firms, each operating autonomously with their own unique ERP systems. This resulted in a decentralized IT infrastructure with over 100 different product and service lines. The lack of a unified system led to inefficiencies, particularly in invoicing. Individual units within Superior were invoicing the same customers independently, which was both inefficient and time-consuming. This fragmented approach also increased the overall number of days it took for Superior to collect payment for its services, negatively impacting the DSO key performance indicator (KPI). The challenge was to streamline this process without imposing a centralized system or specific mandates on the individual units.
Case Study
Unit4 C-Logic's High-Performance Accounting Solution with Actian Zen Database
Unit4 C-Logic, a Bruges-based company, was in search of a high-performance accounting solution that was easy to manage and designed around Belgian accounting rules. The company wanted an embeddable, performance-oriented database that could operate optimally without ongoing administration. The challenge was to find a database that could deliver high performance, extensibility, and scalability without requiring the active involvement of a database administrator (DBA). This was crucial as their target customers were small-to-mid-sized accounting firms, which typically do not have sophisticated (and costly) database administration skills. The company needed a database that could reliably deliver a high-performance experience without the ongoing attention or cost of a DBA.
Case Study
Real-time Analytics for Targeted Social Video Campaigns: A Case Study on Unruly Media
Unruly Media, a London-based advertising technology firm, was faced with the challenge of delivering actionable, real-time insights to its clients to help them make decisions about expanding the social footprint of their critical video campaigns. The company needed to provide insights on where the video is running, who is viewing it, who has tagged it, and who is sharing it. The challenge was to provide these insights in real time, not days or weeks later. Unruly Media needed to tame the unruly stream of real-time data and enable clients to make use of it.
Case Study
Netwrix And Actian Deliver Decreased Time To Revenue
Netwrix Corporation, a market-leading visibility and governance platform for IT environments, was facing several issues due to their archaic data management system of copying and pasting data between datasets. This process did not scale as the company grew to a $20 million company and it quickly became clear that the company needed a better solution. The company faced three main challenges: eliminating errors in their copy and paste method, scaling their processes, and improving data integrity. In order to solve these systematic problems, Netwrix needed an efficient and effective enterprise planning software that could allow them to smoothly integrate with Salesforce.
Case Study
Actian Services Upgrades HSS Hire in One Weekend
HSS Hire, a leading tool and equipment hire company in the UK, needed to upgrade its database infrastructure to incorporate transaction encryption functionality for secure credit card transactions. The company had developed an online platform, HSSlivehire.com, which tied into an early version of the Actian X hybrid database. However, as the platform grew, so did the demands on the database. The company faced the challenge of not having designed its core database with online payment in mind. To provide an environment that was 100% secure for accepting credit card transactions through its website, HSS needed to upgrade its database. However, the company lacked the internal IT resources and expertise to perform the database upgrade.
Case Study
Europe’s Freight & Cargo Leader Drives Efficiency and Security with Analytics
TimoCom, Europe’s leading provider of freight and vehicle exchange services, was faced with the challenge of managing 450,000 freight offers per day and 30,000 warehouse/logistics options with efficiency and security. The business was complicated by the varied operational and regulatory requirements and languages of different countries. Company leaders recognized early on that sustained business growth would require improved performance and deeper insights into its international operations. In the transport and freight forwarding industry, orders tend to be large and represent a large investment on the part of the customer. Criminal organizations sometimes monitor and prey upon transport networks, attempting to steal valuable freight in transit.
Case Study
Data for Profit: AutometricS HelpS Auto induStry HeAvyweigHtS drive Better, more profitABle BuSineSS deciSionS
In the depths of the 2008-2009 economic downturn, Autometrics faced a significant business challenge. The recession had hit the automotive and travel industries hard, and Autometrics felt the pinch. The company needed to completely reinvent itself to survive. Autometrics had access to a phenomenal array of U.S. auto industry data from sophisticated third-party sources, that, when combined with auto manufacturer data and intelligently analyzed, could help predict buyer behavior and deliver real impact to manufacturers’ and dealers’ bottom lines. However, many potential clients were not only reluctant to give up their internal data but also reluctant to trust it to a cloud environment.
Case Study
Public Libraries Expand Services and Control Costs with OpenGalaxy Plus
Axiell, a UK-based company that designs, develops, implements, and supports systems for libraries, archives, museums, and other community resources, was looking to expand its services to all 33 boroughs of London, a growth rate of almost 200 percent. The company's existing system, a 64-bit Solaris system, limited scalability and was not able to support the increased workload that would come with this expansion. Axiell needed a system that could handle the increased workload without causing slowdowns or failures. Additionally, many of Axiell's customers are run by local government agencies, which are under pressure to control costs. As a result, Axiell was looking for a less expensive but technically superior platform that could help it increase service without increasing costs.
Case Study
Badoo Quickens the Pulse with Big Data Insight from Actian Vectorwise
Badoo, a global networking site, was facing challenges in understanding the effectiveness of their marketing campaigns and assessing the impact of their reach. They were using a hard-coded, custom-built analytics solution that was limited in functionality and could not provide the level of detail needed by the marketing and finance teams. The previous solution lacked the ability to perform detailed analytics and could not provide actionable insights based on events occurring among their user base.
Case Study
BBP builds reliable reputation on integrated development stack of Ingres and Red Hat
BBP AG is a software and solution vendor specializing in the integration of interbank applications. The company's middleware, IGTplus, connects financial institutions to payment transactions, securities trading, and processing systems. BBP offers this middleware on an in-house or ServiceBureau basis for a range of financial networks including SWIFTNet, the trading, clearing and settlement systems of the SIX Group, as well as FED and CHIPS. The company serves more than 200 financial institutions, making it the largest SWIFT SB in the world. Product reliability, security, and control are top priorities for BBP. The company must be able to guarantee continuous interbank connection availability and 24x7 access to their business-critical application, along with unshakable security and low total cost of ownership (TCO).
Case Study
Keeping European Football Safe is the “Goal” for Actian Ingres Database
The CIV, a subsidiary of the Dutch Police and a center of excellence for football hooligan management, was created in 1986 after particular heavy riots and violence related to football. The CIV needed to find a way to track previous football related violence, maintain a record of trends among offenders, and keep a database of all known football hooligans. As a result, it created the Hooligan Tracking System (VVS in Dutch) to gather information regarding incidents of violence, hooligans’ backgrounds, effects of actions, previous convictions, and trends in behavior. Cost management is key to any IT project in the public sector. The ability to integrate and allow access to the system was central to its success as a national and pan-European knowledgebase. As Hooligans travel through Europe for games, the VVS also understood the important of supporting multiple European languages, using Dutch and English as the default languages.
Case Study
Actian Helps Cypress Semiconductor Maintain Blue-Chip Manufacturing Quality
Cypress Semiconductor Corporation is a diversified supplier of high-performance, integrated circuits for network infrastructure and access equipment. The company’s manufacturing processes are intensive in both scale and precision, as its billion-dollar wafer fabrication plants conduct and log dozens of intricate manufacturing processes. If its machinery sits idle, the company has serious production problems. If the measurement specifications are off by a fraction of a millimeter, that’s trouble, too. “If you botch a wafer lot by executing a wrong step or mismanaging precision controls, you’ve literally destroyed a million dollars worth of wafers,” said Robert Price, DBA Manager at Cypress. “If any aspect of the system goes down, it will cost you.” This need for reliable, consistent performance has led Cypress to demand absolute perfection from its databases and related services. Simply put, if its systems can’t keep pace with its requirements, the company’s productivity comes to a costly halt.
Case Study
Supply Chain Delivery Solution in the Amazon EC2 Cloud
DAI Rubicon, a company that provides publishers with an end-to-end solution including print, distribution, and circulation management, was facing a challenge. They were in a high volume, low margin business and needed to find a better way for customers to manage their logistics for online purchases. They decided to add a point of sale supply chain delivery solution that would make the ordering process more transparent, scalable, and easier to manage without adding to the cost. They chose Base2Services, Australia’s leading open source cloud computing specialist, to build the supply chain delivery solution. They wanted a solution that was more scalable, more transparent, and easy to use, built on the Amazon EC2 cloud that would lower their ongoing operational costs.
Case Study
Actian Supplies Emerson Network Power with 24x7 Support for Less than the Cost of a DBA
Emerson Network Power, a global leader in supplying business-critical power solutions, was in the process of centralizing their IT helpdesk in Manila. The goal was to seamlessly integrate the Australian operations with Singapore, Malaysia, and Hong Kong. Emerson used the Infor Enterprise Resource Planning (ERP) solution ‘MK’ as the central hub for information, distribution, and reporting. MK was built on Ingres Database and was integral to the daily operations of Emerson. The cost of downtime per business day was estimated at $1 million AUD. It was essential that a 24x7 disaster recovery resource was available to respond to any situation in a timely manner. Additional local support would be required to properly manage IT networks, systems, and databases for Australia. Due to the consolidating nature of the project, interoperability issues would become visible, and Emerson’s handling process would need continual development and improvement. To take all this work in-house would require hiring a minimum of three full-time employees which was considered an unworkable timeframe. Emerson needed a partner that could provide both the skill sets and knowledge base to service the Ingres database underlying the MK application, and provide a 24x7 support service with the highest level of support and continuity.
Case Study
Actian Open Source Database Gives Germany an Unshakeable Foundation for Monitoring Earthquakes and the Comprehensive Nuclear-Test-Ban Treaty
The Federal Institute for Geosciences and Natural Resources (BGR) in Germany was tasked with monitoring seismometer and infrasound stations in support of the Comprehensive Nuclear-Test-ban Treaty (CTbT). The CTbT, signed in 1996, prohibits all forms of nuclear testing in any environment, whether it’s underground, underwater, or in the atmosphere. The international monitoring system monitors compliance with the treaty, and comprises a global network of monitoring stations. One of BGR’s primary tasks includes monitoring seismometer and infrasound stations in support of the CTbT. In addition to monitoring the CTbT, the second key task of the BGR research group is the monitoring of earthquakes. Even today, it is still almost impossible to forecast when and where an earthquake might occur. Germany has seismically active regions that are repeatedly subject to earthquakes. Due to the high population and industrial density, continuous monitoring of seismic activity is essential. Only by careful monitoring is it possible to identify long term trends and make forecasts on future earthquakes and the accompanying seismic hazard. Both current and historical data on earthquakes form the basis for many scientific investigations.
Case Study
Leading Auto Glass Company Lynx Services Finds Ingres Open Source Database Unbreakable
Lynx Services, a market leader in auto glass claims management, required a high availability, transaction-processing oriented database solution that would enable it to process claims for its clients 24x7. The solution needed to be reliable, easy to use, and able to scale as the company grew. The company manages more than 3 million claims each year, processing three types of claims for insurance clients – auto glass claims, first notice of loss claims, and auto physical damage claims. The company needed a database that could handle this volume of transactions and provide high availability and quick transactional processing.
Case Study
Magna reduces risk and saves support costs with Actian Services and Enterprise Management Service (EMS)
Magna, a leading global automotive supplier, had built a successful application called MAGIC that manages their complete production line as they manufacture and supply parts to car companies such as BMW, Bentley, and Land Rover. The application runs on Actian Ingres and Actian OpenROAD. However, Magna had limited internal resources to manage and monitor MAGIC, and they were looking to outsource this to a third party. The previous management of the application was done by Computacenter.
Case Study
Actian Ingres Database Helps NCMEC Find and Recover Endangered Children Worldwide
The National Center for Missing & Exploited Children (NCMEC) is dedicated to solving cases of child abduction and child sexual exploitation. Timely information is vital to the organization’s work, as its workers collaborate internally and with partner agencies around the globe to find and recover children at risk. When NCMEC began the implementation of its first database, it wanted to make sure its technology worked as hard – and as tirelessly – as its personnel. To help agencies and organizations around the world work together, the solution had to be able to support Web-based applications and websites in multiple languages and character sets serving diverse user communities. With time a critical factor in every case, the system also had to deliver maximum availability under any conditions.
Case Study
Actian and NETinfo Form Partnership to Bank On
NETinfo, a rapidly growing independent software vendor, was faced with the challenge of providing a cost-effective, fully customizable e-banking multi-channel solution to financial institutions. The solution needed to meet high-performance requirements including scalability, always-on availability, robust security, and full customizability. Additionally, the solution had to support multiple jurisdictions, single sign-on across multiple banks, and multi-signature workflows. The company initially used Oracle for the NETteller e-banking platform, but the high upfront licensing fees and costly ongoing support significantly increased the total cost of ownership. MySQL was also considered but was quickly rejected due to its lack of critical features such as online backup, point-in-time restore, and security features.
Case Study
Versant Object Database
Sabre Holdings, a world leader in the travel marketplace, was looking for an open system solution to provide real-time inventory for travelocity.com and several other websites. The challenge was processing Origination and Destination, also known as Airline Inventory, which requires massive transactional throughput. Relational technology was not a good fit for this task. Sabre was looking to migrate from an expensive and proprietary IBM Mainframe System, TPF, to an open system solution using an object-oriented design approach to run its SabreSonic Inventory System.
Case Study
Versant Object Database
Telecom Bretagne, a prestigious graduate engineering school in France, was tasked with developing a French validator and demonstrator system for the UsiXML project, which is based on the European Maritime Surveillance project. The challenge was to develop a database technology that could provide both the objects of the simulation and the operational information captured during the experimental or effective mission. The system needed to integrate various autonomous surveillance applications, tactile surfaces, and sensor systems, including maritime search and rescue, traffic monitoring, fishing inspections, and maritime border surveillance.
Case Study
Streamlining Invoicing and Customer Onboarding in Transportation with IoT
ACME Truck Line, a leading transportation company in the United States, was grappling with a labor-intensive and error-prone paper-based invoicing process. The company had to manually enter all invoicing data twice, once in its own accounting system and again in its customer’s invoice system. This double-entry practice not only increased the risk of errors and delays but also complicated the customer onboarding process. The challenge was further compounded by the fact that ACME's customers all had different invoice processing systems. The company was therefore faced with the daunting task of implementing an electronic invoicing solution that could seamlessly connect with all its customers' diverse systems.
Case Study
Bloomberg Industry Group Leverages Actian for Efficient Data Integration
Bloomberg Industry Group was faced with the challenge of integrating its Advantage Fixed Assets tax and accounting software into existing customer application and data infrastructures. The constant changes to tax laws and regulations often required the finance team to monitor and manage corporate data and assets in new and unexpected ways. This was problematic as the financial software and the corporate data and assets were not well and flexibly integrated. The changes often required finance professionals to gather data they had not had to track and monitor before, which may not even reside in their primary ERP systems. Tax changes could even be retroactive, requiring finance professionals to interact in new ways with systems and data repositories configured to support compliance with rules that no longer apply.
Case Study
EidosMedia and Actian NoSQL: Revolutionizing News Delivery Globally
EidosMedia, a developer of digital publishing solutions, was faced with the challenge of creating a new digital editorial platform. The developers recognized that modern news consists of complex and relatively unstructured data, requiring a solution beyond a conventional relational database. The platform needed to manage and deliver content to a variety of emerging endpoints. The complexity and inconsistent structures of the content, which could range from text, graphics, audio, video, and more, posed serious challenges. The platform also needed to cater to an ever-widening range of devices, from televisions to smartphones, tablets, and more.
Case Study
Accelerating Service Quality Insights from Months to Minutes: Expandium's IoT Journey
Expandium, a provider of network monitoring and management systems, was faced with the challenge of finding a robust analytics solution. Their mobile telco customers required near-real-time insights into the events impacting their large and complex networks, specifically those that could potentially affect their Service Level Agreements (SLAs). The need was for a solution that could be integrated into the intelligent systems Expandium was building, to provide deep visibility into network events, down to individual calls. The solution had to be capable of handling the massive volumes of data generated by these networks and deliver insights quickly enough for proactive issue resolution.
Case Study
Transforming Salesforce CRM Data into Actionable Customer 360 Insights
A mid-size enterprise software vendor, based in California, was struggling to optimize its sales and marketing operations in response to market disruptions caused by the Covid-19 pandemic. Despite major investments in solutions from Salesforce, Marketo, and other vendors, the company was unable to gain a comprehensive 360-degree view of its customers. The individual apps feeding into Salesforce CRM were providing only fragments of the total customer picture, and the Salesforce CRM solution itself was unable to present these fragmented pictures as quickly as the company’s fast-moving go-to-market initiatives demanded. The full, 360-degree customer view, accessible in real time, continued to elude the company. The advent of the Covid-19 pandemic had disrupted the dynamics of commerce like nothing in recent history. Uncertain economic conditions threatened to affect both the company and its customers, and the company needed to be able to respond more quickly and appropriately to customer needs and opportunities.
Case Study
Scalable System Integration Solution Facilitates Growth at Netwrix
Netwrix, a company that provides information security and governance solutions, was facing growth and scalability challenges. The company needed to integrate its Salesforce and Oracle NetSuite solutions to support its transition from a small to a mid-sized company. The volume of inbound data was increasing, and there was a demand to process this data accurately and consistently across multiple systems. The old method of manually cutting, pasting, and reconciling data between systems was no longer efficient or effective. Furthermore, data integrity and security considerations required Netwrix to facilitate this integration in a way that protected and ensured the auditability of processes.
Case Study
Reducing Time to Insight from Days to Minutes: A Case Study on the University of Oxford's Clinical Trial Service Unit
The Clinical Trial Service Unit and Epidemiological Studies Unit (CTSU) at the University of Oxford was struggling with an aging legacy database infrastructure that could not handle the increasing volume of data nor run analytics against thousands of fields in multiple tables in a timely manner. The researchers at CTSU were dealing with vast amounts of information related to the causes and treatments of chronic illnesses such as cancer, heart disease, and stroke. They were seeking greater insights into links between causes and diseases as well as prevention and treatment options. However, extracting insights from the ever-increasing volume of data was becoming more and more difficult. Their ad hoc analytical queries could take multiple days to return a response. The researchers needed a faster, more cost-effective way to identify, manipulate, and extract the exact data they needed from the large pool of data they had accumulated, and gain insights from that data far faster than the legacy infrastructure could accommodate.
Case Study
Actian Zen Empowers TAIFUN ERP: A Case Study
TAIFUN Software, a Hannover-based company that has been developing commercial software for over 30 years, faced a significant challenge. The company needed a high-performance database with a small footprint for its ERP system, specifically designed for firms operating in the German and Austrian building trades. The database needed to be user-friendly and require minimal management, as most of the companies TAIFUN was targeting did not have access to an IT team or a skilled database manager. Many databases that were capable of providing a touch-free experience typically sacrificed performance for ease of use. Conversely, those that could provide the high performance TAIFUN wanted often came at the cost of ease of use, requiring ongoing management for optimal performance.
Case Study
Enhancing Revenue Collection Efficiency in the Republic of Ireland with IoT
The Office of the Revenue Commissioners in the Republic of Ireland (Revenue) faced a significant challenge in improving the performance of their mission-critical database systems without compromising application availability or service delivery. The agency needed a highly reliable and available database platform to support uninterrupted operation of its mission-critical computer systems. The Revenue had to ensure that it could efficiently manage tax revenues, enforce import and export controls, administer various European Union schemes, and provide collection services for several other Irish government departments. The challenge was to maintain a system that could handle the influx of information and transactions as a large percentage of Revenue’s customer base moved to mandatory e-filing and e-paying.
Case Study
Tsubakimoto’s Material Handling System: A Case Study on High-Speed Sorting
Tsubakimoto Chain Co., a global machinery manufacturer based in Japan, was faced with the challenge of creating a registration and identification database capable of tracking and sorting up to 10,000 items per hour on their high-speed conveyor belt sorting systems. The company needed a solution that could meet their millisecond-level response times for database reads and writes. The challenge was not only to find a database that could handle the high volume of items but also to ensure that it could maintain its speed and efficiency over time. The company also needed a solution that could seamlessly integrate with their existing systems and processes.
Case Study
University of Western England Manages Major Migration Amidst Global Pandemic
The University of the West of England (UWE) was faced with the challenge of upgrading its student record system and underlying Ingres from Ingres 10 to Actian X, and migrating the entire system to the CentOS 8 implementation of Linux. This was a daunting task as the student record system was the only mission-critical application still running on the university’s aging Solaris UNIX systems. The challenge was further compounded by the global pandemic, which made it impossible for the teams to meet in person to plan or execute this critical project. The goal was to upgrade the database from Ingres 10.2 to Actian X 11.1 and to migrate the entire student record system from Solaris UNIX to the Linux platform, without interrupting access to the system.
Case Study
How a Transport Leader Reduced DSO and Streamlined Onboarding
ACME Truck Line, a leader in the truck transport of equipment, materials, and supplies throughout the United States, was facing challenges with its invoice processing standards. The company was asked by a major oil and gas industry customer to shift from paper to electronic invoicing. However, the traditionally paper-based truck transport industry had varying invoice processing standards from customer to customer. Before deploying the Actian solution, ACME had to enter all of its invoicing data twice: once in its own accounting system and once in its customer’s e-invoice system. This 'double-entry' practice doubled the risk of errors, delays and rework in the invoicing process. It also had an adverse impact on the company’s customer onboarding process, making it unnecessarily cumbersome and complex and hindering support of high-volume customers.
Case Study
Bucap and Actian Ingres: a winning team for archiving firm
Bucap, a leading Italian company providing outsourced document archiving and management services, needed a highly flexible and scalable system to allow quick and easy customization of the applications to respond to business requirements. The company handles huge quantities of data which must be managed and stored in systems compliant with the requirements of high availability, accessibility and security. Bucap also needed the system to be scalable, reliable, highly available and easy to maintain, in order to be able to support all the business processes of storage, indexing, retrieving, and displaying of the documents at the service level agreement committed with the customers.
Case Study
Egide Informatique relies on Actian for its low maintenance, high performance database
Egide Informatique, a Paris-based company providing a comprehensive solution for real estate management, was in search of a reliable, high-performing database that would not require maintenance by a database administrator (DBA). Their software encompasses the commercial, residential, and social housing and addresses the needs of property administrators, co-ownership trustees, and property managers through its modular set of features. They have a wide-ranging base of 500 customers who can have anywhere from one to 200 workstations each, with some not even having an IT system in place. The challenge was to find a database solution that could cater to this diverse customer base, ensuring high performance and reliability without the need for constant maintenance.
Case Study
Actian automates “quote-to-cash” and enables TE21 to focus on growing their business
TE21, an education company, was facing challenges due to its growth and the development of more complex business processes. They were outgrowing their manual QuickBooks solution and needed a more robust and automated process. The company also needed a CRM system that could enable a true “quote–to–cash” process starting with sales, which could be easily connected to their financial billing, collection, and reporting system. The challenge was to find a solution that could handle the growing business's challenges.
Case Study
Lufthansa Systems Depend on Actian to Ensure Flights go Smoothly for Passengers
Lufthansa Systems, a leading IT service provider for the airline and transportation markets, needed a robust and stable database platform to underpin its airline planning and routing software. This software is sold to hundreds of airlines globally to ensure every flight is a safe one. The company offers a modular range of products and services to manage all aspects of airline operations and planning. The challenge was to provide real-time availability of data, high levels of uptime, reliability and stability, cost-effective licensing, and vendor support.
Case Study
For AAH Pharmaceuticals, Ingres is the key to a healthy business
AAH Pharmaceuticals Ltd. is the United Kingdom’s leading distributor of pharmaceutical and healthcare products and services to pharmacies, hospitals, and doctors. With more than 4,000 employees, 19 distribution warehouses in the United Kingdom and Northern Ireland, and more than 2.6 million products delivered daily, the company relies on an enterprise-class IT infrastructure to support its large-scale logistical operations. At the same time, in its highly regulated and constantly-changing market, AAH must also maintain the agility to respond quickly and efficiently to emerging business requirements. The company’s role as an intermediary between suppliers and end customers brings additional complexity to the challenge; each business application used and each link in the value chain must perform optimally to maintain competitive advantage.
Case Study
Algonquin College Navigates the Learning Landscape with Actian Technology
Algonquin College, based in Ottawa, Ontario, offers over 100 courses of study to more than 30,000 full-time and part-time students. The college's mission statement includes incorporating technology to improve service delivery and exceed client expectations. Advanced technology drives services for students, faculty, and employees, providing them with wireless and web-based access to curriculum, self-service, and student information. In 1993, when developing its technology-based services, Algonquin knew it needed to invest in a high-performance, transaction-oriented database that would scale. They chose Ingres, and today, the college continues to run mission-critical student and faculty applications on Ingres open source technology.
Case Study
Actian Ingres Database Powers Global Circulation for Askews Library Services
Askews Library Systems provides libraries around the world with complete services including selection support, buying, cataloguing, physical preparation for lending, promotional support, and management reporting. The libraries market within which Askews provides these services has become increasingly sensitive in recent years as economic pressures cap and in some cases depress spending. Four other companies compete with Askews in the £90m-a-year UK market, where contracts are awarded by competitive tender. Over the past decade, these pressures led the 130-yearold Askews to embrace state-of-the-art technology and process automation, including using the Web to market globally and Electronic Data Interchange (EDI) to serve customers world-wide. In addition, the company undertook the development of a bespoke e-procurement system.
Case Study
Top Level Performance
China Telecom, managing a customer base of 250 million ADSL subscribers, was facing a significant challenge with its existing database system. The company's applications relied on the ADSL subscriber database to provide real-time access to hundreds of thousands of account objects. The subscriber database was deployed on a relational database management system (RDBMS), which required a high-performance server that was expensive to maintain. The system was proving too cumbersome over time to keep up with the company’s growing customer base. The company needed a solution that could handle as many as 480,000 queries and 1,000 update transactions per second at peak times, with database performance and reliability being top priorities.
Case Study
Actian Ingres Database - the Basis for Europe’s Leading Tracking System
The challenge faced by Comsoft was to ensure highly available access to the database for business-critical applications. In 2009, German Air Traffic Control (DFS) counted more than 2.9 million flights according to Instrument Flight Rules (IFR) in the airspace of the Federal Republic of Germany alone. Air traffic management deploys cutting edge technology to control and regulate whether planes are maintaining the necessary safe distance from one another in controlled airspace, that they are on the right course and flying at the correct altitude and speed. It uses special air traffic management systems, instrument landing systems, and radar and navigation systems to enable fast and accurate processing of huge data volumes, thus ensuring the smooth flow of traffic. The wealth of different data processing systems in Europe, has led EUROCONTROL, the European Organisation for the Safety of Air Navigation, to take steps towards harmonizing European Air Traffic Management.
Case Study
Solutions in the Public Cloud
Today’s emerging HPC applications must handle complex and large volumes of data, which if not managed appropriately, may result in a serious performance bottleneck. CRL (Computational Research Laboratories Ltd.), a TATA Group company, was looking for a database engine running on a highly scalable Linux cluster. The company needed a solution that could offer sustained performance of complex analytics in the face of increasing data and seamless performance-oriented scalability of elastic database services underpinned by a tensile computing infrastructure.
Case Study
Datamatics Selects Ingres Vectorwise to Power its Smart Meter Solution
The German Energy Management Act prescribes that a smart meter for power and gas, which is read at least every 15 minutes to provide tariff information, is mandatory for every new building or every energy-conserving renovation. The data volumes that are aggregated in modern power meters and transmitted to utility companies surpass the previous amount of data by a factor of 35,000. Utilities need an appropriate IT infrastructure to manage and process such data volumes if they opt for an in-house smart meter solution. While larger utilities can afford this, it represents a huge investment for smaller energy providers such as local public utilities.
Case Study
Department of Education and Training in Western Australia Makes the Grade with Actian and Red Hat
The Department of Education and Training in Western Australia (WA DET) was facing a challenge with its back-end computing environment. The department managed a range of administrative activities to support programs delivered by 11 colleges and 8,000 staff throughout the state. The systems collectively managed over 1 million student records with 120,000 students processed through the state’s training systems annually. However, regional locations had to manage their own back-end environments, which imposed an expensive support burden on WA DET staff and vendor support engineers. Proprietary Unix server environments, often built on a variety of hardware models of differing ages, had to be managed remotely, along with the complex applications they were running. With many DET colleges hundreds of kilometers apart, it had become too expensive and cumbersome to maintain this computing environment.
Case Study
Deutsche Familienversicherung Boosts Customer Service and Operational Performance with Vectorwise
Deutsche Familienversicherung AG (DFV AG), a leading insurance company based in Germany, was facing challenges with the growth of data in the insurance sector. The speed and stability of a database had become major factors, especially when it came to analyzing and reporting on corporate figures and, ultimately, customer satisfaction. As its master data had grown considerably over the years and also increased in complexity, DFV AG was looking for a stable and future-proof database that would also easily accommodate further growth. As part of its strategy, DFV AG uses commercial Open Source solutions for Business Intelligence (BI) and ETL. Representing the third technology layer in the IT stack, DFV sought to find a reliable database software solution that would then fit in with the existing IT infrastructure and hardware environment.
Case Study
Data from Outerspace
The European Space Agency’s (ESA) Herschel Telescope, stationed at Noordwijk (The Netherlands), is constantly bombarded by infrared radiation, high-energy particles from solar eruptions and other events in outer space. The telescope, which is carrying the largest telescope ever flown, collects an average of six to seven gigabit raw telemetry data every day. The data is managed in an onboard storage facility and downloaded during a daily three-hour window to one of two satellite stations on the ground. The data is then transmitted to the ESA satellite control center in Darmstadt, Germany, and forwarded to the scientific control center in Madrid, Spain. On previous ESA missions, the teams responsible for the in-flight instruments had to use a multitude of tools to analyze critical instrument data extracted from various files.
Case Study
Database Benchmark for IPTV
The challenge was the rapidly growing number of users simultaneously accessing the same TV programs and channels via Internet. In this application domain, the database must provide fast access to rather complex data, easy integration into an ever evolving application code, and support massive concurrent access from potentially millions of consumers. The Fraunhofer FOKUS Open IPTV Ecosystem was in need of a database system that could handle these demands efficiently.
Case Study
Resource Industry Mines Data Faster with Actian and Geological Data Design
Geological Data Design (GDD) was facing the challenge of efficiently collecting, managing, and analyzing large volumes of exploration and mining data. The data collected during the day from various field instruments, GPS, and cameras often integrated into a very large database, in some cases hundreds of millions or even billions of records. This made it difficult for geologists to quickly analyze large volumes of sample data for complex scenarios such as project timings, cash flows, and profitability with greater sensitivity levels.
Case Study
Global DIY Retail Chain Accelerates Business Insight with Actian
GROUPE ADEO, a leading international home improvement retailer, was dealing with huge data volumes aggregated across the group's datamarts due to its extensive market presence. The company had hundreds of stores, multiple retail concepts, thousands of product references, and millions of sales translations made every day. Despite the company's experience of using Business Intelligence across this wide range of data, GROUPE ADEO was looking for an agile analytical database to complement its existing environment. The companies in the group needed a more affordable and user-friendly solution.
Case Study
HSE reduces risk by calling on Actian to provide an outsourced environment for its secure website
The Chemicals Regulations Directorate (CRD) of the Health and Safety Executive (HSE) was in the process of splitting its two main websites into two separate IP addresses. The first, public-facing website was to be moved to a third-party hosting provider. However, CRD needed to find a hosting provider who could provide a managed environment for its second secure site that also included the management of Actian Ingres and OpenROAD. As a result, CRD needed more than just a simple hosted Windows environment. A number of criteria had to be taken into account: the future of the existing in-house environment provider was unsure, the approach to outsourcing the secure website had to be low risk as the whole area of support for hardware and environment was under review, and the managed service had to be controlled yet flexible enough to allow CRD staff access when necessary.
Case Study
Modernizing Railroad Infrastructures
Indra Sistemas, a global technology company, was tasked with building the control centers for Spain’s AVE high-speed bullet train system. The company needed a database that could handle the complex and demanding architecture of the integrated high-speed train control system (IRC). The system was designed from a global perspective, integrating information and control from each of the elements that make up a high-speed rail line. The architecture used by Indra includes three areas of management allowing for different degrees of accessibility and control of the line. The Real-time System Control Framework consists of over 30,000 objects in memory and 30 classes, with 80 TB of information eventually flowing into Oracle’s relational database on the corporate level.
Case Study
A System that Never Sleeps
INIT is a leading supplier of Intelligent Transportation Systems and Electronic Ticketing Systems for public transportation. Their application components place significant demands on concurrency, availability, and runtime performance. They were looking for a database technology that could efficiently store and retrieve complex real-time data in 24/7 operation. The challenge was to find a solution that could handle complex networked data and real-time requirements. The solution needed to be scalable, flexible, and capable of transparent data distribution and replication.
Case Study
Medical Data Vision save lives with Vectorwise
Medical Data Vision (MDV) develops management support software for hospitals and private health clinics throughout Japan. The MDV analyzer is an Evidence Based Medicine (EBM) service that collects and shares medical data from hospitals across Japan. The MDV analyzer aims to improve the quality of medical care by analyzing and sharing medical results with Pharmaceutical companies for epidemiological studies, market research and further drug development. MDV’s previous EBM required an upgrade due to slow performance. “Our previous application used another column type database and performance was taking up to 30 seconds for a report on 2 years of data,” said Hirai-san. “This was unacceptable, so over a 2 month period we evaluated 5 other high performance databases to see which offered the best performance.”
Case Study
Clouds in Real-Time
Northrop Grumman was tasked with developing a next-generation simulation application, the Cloud Depiction and Forecast System II (CDFS II), for the U.S. Air Force. The application needed to deliver results six times faster and with four times higher resolution than the previous system. The challenge was to program complex algorithms using object-oriented programming techniques. The previous system could only create a 48-hour forecast every six hours and a nine-hour forecast on request. The new system needed to improve on these capabilities.
Case Study
Mission: Bypass SQL
Bot Colony is a massive multiplayer game developed by North Side Inc., a progressive MMO game developer located in Canada. The game leverages breakthroughs in Natural Language Processing (NLP), which is extremely intensive in terms of CPU requirements. The player converses with the game’s characters in English to solve a mystery and conduct missions. The NLP component is extremely intensive in terms of its CPU requirements, requiring access to vast amounts of data for linguistic processing and reasoning. The system database contains both linguistic data and a large store of world knowledge, represented as formal axioms. North Side became interested in Versant Object Database when it ran into a programming bottleneck, consisting of serialization and deserialization of data with MySQL.
Case Study
Research in Real-Time
The National Snow and Ice Data Center (NSIDC) at the University of Colorado is conducting research on the impact of global warming. The project, titled 'Data Rods: Enabling Time-Series Analysis of Massive Multi-Modality Cryospheric Data', is focused on the Greenland ice sheet. The challenge was to process billions of time-series information in real-time to enable a time-centric change analysis of data. The database for the project contains over 10 billion persistent objects. Indexed queries to the database can span millions of data rods simultaneously across time and space and must achieve response times of only a few seconds. Using a relational database was completely impractical due to the large size of the data sets and required response time.
Case Study
The Office of Revenue Commissioners (Ireland) Commits to Actian Ingres Database
The Office of the Revenue Commissioners in Ireland, responsible for the assessment and collection of taxes and duties, required high availability and high performance for its mission-critical computer systems. It had adopted the Ingres database and the OpenROAD application development toolset in 1993 and had constantly upgraded to the latest versions to ensure a stable, manageable, and economical platform. However, the organization faced challenges in improving transaction processing as well as better batch and checkpoint performance. It was essential to move mission-critical systems to Actian Ingres database without any impact on live services. The organization had many databases in multiple Ingres installations, all of which support mission-critical applications either in production or at various stages of development. It was essential to have minimal downtime during the upgrade and to ensure that all applications, especially its large-scale batch applications, continued to run smoothly.
Case Study
Actian Helps Fast Growing U.S. Convenience Store Chain to Save Money and Take Action on Big Data
Sheetz, a rapidly growing convenience store chain in the U.S., was facing the challenge of managing and analyzing increasing volumes of data from multiple sources. The company needed to optimize costs, maintain high quality, and ensure a positive customer experience. As data volumes continued to grow, Sheetz recognized the need to switch from a more expensive platform to a more cost-effective and efficient one that could handle the increasing data and provide actionable insights. The company was also looking to expand its data analysis from one year to two years, which equates to approximately three billion rows of data. Furthermore, Sheetz was anticipating its data to double over the next two to three years.
Case Study
Versant Object Database
Siemens Industry Automation was tasked with providing a scalable solution for the automation of batch processes in the chemical, pharmaceutical, and food & beverage industry. The solution needed to ensure high product quality, production performance over time, complete traceability of production, quick response to market conditions, and efficient use of production equipment. The challenge was to find a database technology that would optimally match the requirements of the SIMATIC® BATCH program design, which provides an object-oriented view on models, procedures, and recipes for comprehensive batch processes. The system needed to be stable, performant, and capable of handling large database files up to double-digit Gigabytes in size. It also needed to provide fast and reliable real-time access to prevent any significant delay, failure, or shutdown that could potentially affect product quantity and quality.
Case Study
Actian Helps the Scottish Qualifications Authority Pass Every Test
The Scottish Qualifications Authority (SQA) was faced with the challenge of rapidly expanding its database functionality and capacity to accommodate the increasing number of subjects and students. The agency needed to maximize the system’s development agility to offer new functionality in response to growing user expectations. The agency was also expanding to new markets in China, the Caribbean, and beyond, which required robust performance and open source flexibility.
Case Study
Vectorwise empowers SaaS provider, Softwear BV, to offer retailers and wholesalers high-speed intuitive analytics
Softwear BV, a SaaS solution provider for retailers, was facing challenges with its legacy database system. The poor performance and functionality of the system were unable to meet the analytical needs of its customers. As the database tables grew from millions of records to potentially billions, the transactional-based database solution could not keep up with the analytic demands from the customers. Furthermore, Softwear wanted to streamline the applications and reduce the amount of hardware needed in its data centers. The company also aimed to offer the analytic reporting layer as a SaaS-based on-demand online solution.
Case Study
Don’t Sing the ORM Blues
Sony Creative Software was facing a challenge with their Blu-ray authoring software, Blu-print. The software was built using object-relational mapping (ORM) technology, which was not scaling as required. The production of a Blu-ray disc can involve as many as 200,000 objects, demanding a fast and reliable database capable of handling an equal number of complex object relationships. Additionally, the emerging Blu-ray specification was in flux, and every change to the spec required a corresponding adjustment to the data model and database schema. Whenever a change was required to the data model, a time-consuming process ensued, requiring the export of all data to XML, updating and migrating the schema, and then reimporting the data.
Case Study
TNT Express turns to Actian Services to develop, run and maintain Ingres and OpenROAD-based application systems as a managed service
TNT Express Services was in need of a reliable partner who could not only provide robust technology for building business applications, but also a qualified team of IT professionals who could support them by developing, running, and maintaining their applications. The company was looking for a solution that could help them track high-value items shipped by two of their divisions: Technology Express, which distributed IT and computing equipment, and Retail Express, now Fashion Group, which distributed high-end clothing from manufacturers to High Street outlets. Over time, the need for the system expanded to cover all items shipped by TNT Express.
Case Study
Split-Second Response Time Moves UK Insurance Carrier to the Top of Customers List
The AA, a leading provider of roadside assistance services in the UK, needed a solution that would enable it to underwrite a prospective driver and deliver a risk-balanced, competitive insurance quote with sub-second speed. This was particularly important as insurance comparison websites in the UK give top billing to insurers who respond fastest to online requests for quotes. The AA wanted to target and provide highly competitive insurance rates to customers with the best driving records. To do this, they needed to be able to go beyond website provided data and create a more complete risk profile of a driver before determining eligibility and rates. The AA subscribes to multiple services that enable them to validate the information an applicant submits and enrich that information with data the applicant may not have provided.