In this infographic, we have outlined a few of the ways EHS programs benefit from having an AWS-hosted solution. Locus customers recently received these benefits as a result of moving our entire infrastructure to Amazon Web Services—the world’s leading cloud. Learn more about the move to AWS.
SAN FRANCISCO, Calif., 23 July 2019 — Locus Technologies (Locus), the market leader in multi-tenant SaaS water quality, environmental compliance, and sustainability management, today announced that it is going all-in on Amazon Web Services, Inc. (AWS), moving its entire infrastructure to the world’s leading cloud. By moving its flagship product EIM (Environmental Information Management) to AWS this month, Locus will complete its transition to AWS. Locus previously moved its Locus Platform (LP) to AWS in 2018.
EIM is the world’s leading water quality management software used by many Fortune 500 companies, water utilities, and the US Government since 1999. Among its many features, EIM delivers real-time tools to ensure that water utilities deliver clean water to consumers’ taps and don’t discharge contaminated wastewater above allowable limits to groundwater or surface water bodies like streams, lakes, or oceans.
EIM generates big data, and with over 500 million analytical records at over 1.3 million locations worldwide, it is one of the largest centralized, multi-tenant water quality management SaaS systems in the world. With anticipated growth in double digits stemming from the addition of streaming data from sensors and many IoT monitoring devices, Locus needed to have a highly scalable architecture for its software hosting. The unmatched performance and scalability of AWS’s offerings are just the right match for powering Locus’ SaaS.
Because of the scope of its applications, Locus is expecting to leverage the breadth and depth of AWS’s services (including its database systems, serverless architecture, IoT streaming, blockchain, machine learning, and analytics) to automate and enhance the on-demand EHS compliance, sustainability, facility, water, energy, and GHG management tools that Locus’ software provides to its customers.
Running on AWS’s fault-tolerant and highly performant infrastructure will help support Locus’s everyday business, and will scale easily for peak periods, where reporting demand such as GHG calculation engine or significant emissions incidents like spills can skyrocket scalability demand.
By leveraging Amazon CloudFront, Amazon Virtual Private Cloud (Amazon VPC), Amazon Elastic Kubernetes Service (Amazon EKS) and AWS Lambda, Locus is migrating to a microservices architecture to create more than 150 microservices that independently scale workloads while reducing complexity in the cloud, thereby enhancing every element of the customer cloud experience. Locus built a data lake on Amazon Simple Storage Service (Amazon S3) and will leverage Amazon Redshift to analyze the vast amount of data it is storing in the cloud, delivering insights and predictive analytics that uncover chemicals trending patterns and predict future emissions releases at various locations.
Locus intends to leverage AWS IoT services and Amazon Managed Blockchain by building a new native integration to help businesses generate value from the millions of events generated by connected devices such as real-time environmental monitoring sensors and environmental treatment systems controls. AWS IoT is a set of cloud services that let connected devices easily and securely interact with cloud applications like EIM and Locus Platform and other devices. Locus IoT Cloud on AWS allows customers to experience real-time emissions monitoring and management across all their connected sensors and devices. And for customers who want to allow multiple parties to transact (e.g. GHG trading) without a trusted central authority, AWS provides a fully managed, scalable blockchain service. Amazon Managed Blockchain is a fully managed service makes it easy to setup, deploy, and manage scalable blockchain networks that Locus intends to use for emissions management and trading.
For example, a water utility company that maintains thousands of IoT-enabled sensors for water flow, pressure, pH, or other water quality measuring devices across their dispersed facilities and pipeline networks will be able to use Locus IoT on AWS to ingest and manage the data generated by those sensors and devices, and interpret it in real time. By combining water sensor data with regulatory databases, water utility companies will be able to automatically create an emergency shutdown if chemical or other exceedances or device faults are detected and as such, will be better prepared to serve their customers and environment.
By combining the powerful, actionable intelligence in EIM and rapid responsiveness through Locus Platform with the scalability and fast-query performance of AWS, customers will be able to analyze large datasets seamlessly on arrival in real time. This will allow Locus’ customers to explore information quickly, find insights, and take actions from a greater variety and volume of data—all without investing the significant time and resources required to administer a self-managed on-premises data warehouse.
“After 22 years in business, and after evaluating AWS for a year with our Locus Platform, we decided to switch and continue all our business on AWS. We are taking advantage of their extensive computing power, depth and breadth of services and expertise to develop an effective cloud infrastructure to support our growing business and goal of saving the planet Earth by providing and managing factual information on emissions management, all the while reducing operational costs of Locus’ customers,” said Neno Duplan CEO of Locus. “By operating on AWS, we can scale and innovate quickly to provide new features and improvements to our services – such as blockchain-based emissions management – and deliver exceptional scalability for our enterprise customers. With AWS, we don’t have to focus on the undifferentiated heavy lifting of managing our infrastructure, and can concentrate instead on developing and improving apps and services.”
“By organizing and analyzing environmental, sustainability, and water quality information in the cloud, Locus is helping organizations to understand the impact of climate change on drinking water,” said Mike Clayville, Vice President, Worldwide Commercial Sales at AWS. “AWS’s unmatched portfolio of cloud services, proven operational expertise, and unmatched reliability will help Locus to further automate environmental compliance for companies ranging from local water utilities to multinational manufacturing corporations, to federal government research agencies. ”By choosing to go all-in on AWS, Locus is able to innovate and expand globally, developing new solutions that will leverage comprehensive analytics and machine learning services to gain deeper insights and forecast sustainability metrics that will help deliver clean drinking water to consumers around the world.”
Continued from Part 2
Microsoft Support confirms that it is possible to share an Excel workbook. Two or more individuals can indeed access the same spreadsheet simultaneously. Edits are even possible:
You can create a shared workbook and place it on a network location where several people can edit the contents simultaneously… As the owner of the shared workbook, you can manage it by controlling user access to the shared workbook and resolving conflicting changes. When all changes have been incorporated, you can stop sharing the workbook.
Sharing a spreadsheet may work in a small office or facility with a couple of users, but it certainly is not a viable option when more users need to access, view, and generate reports. This is a task for which databases are far better suited.
On any given day, for example, Locus EIM supports hundreds of simultaneous users. Some may be inputting form data, while others are loading and checking laboratory EDDs, and still others are creating reports and graphs and viewing data on maps and in tables. Many of these are very data-intensive processes—yet Locus EIM handles them seamlessly.
Being able to handle such simultaneous activity is inherent in the designs of relational databases. In contrast, the ability to share an Excel workbook is not a native feature of such software and, as such, is unlikely to meet the needs of most organizations (especially as they evolve and grow).
7) Processing speed, capacity, and scalability is better with databasesCompared to spreadsheets, databases are the hands-down winners with respect to processing speed and the numbers of records they can store. Higher-end databases can store hundreds of millions of records. In contrast, spreadsheets with hundreds of thousands of records can bog down and become difficult to manage.
An underappreciated, yet the critical difference is that while you’re using a spreadsheet, the entire file is stored in a computer’s random access memory (RAM). In contrast, when using a database, only the dataset that you are currently working with is loaded into RAM.
To illustrate just how fast a powerful database can be, I sent a query to EIM at our secure facility on the opposite coast, asking how many “benzene” records were in one of our larger laboratory results table (N > 4,500,000). Sitting at a desk here in the hinterlands of Vermont, the result (“number of records = 64773”) came back in less than a second. I did not even have time to call in the cows for their afternoon milking.
Because they are both faster and can store more, databases scale far better than spreadsheets. As such, they can meet both your current and future requirements, no matter how fast the information you are required to store grows over time.
8) Databases support creating and following complex workflowsIn contrast to spreadsheets, databases support the creation of formal workflows. Let’s consider one example from EIM—its cradle-to-grave sample planning, collection, and tracking process.
Using EIM’s Sample Planning module, you can:
You simply could not build such a comprehensive and sophisticated workflow in Excel. Notice we mentioned maps. Building complex workflows is yet another area where advanced, integrated database management systems shine, especially as they can automatically create GIS-based maps of the results from data housed in the database—without the need (or expense) for ancillary software.
9) Databases provide more security than spreadsheetsMicrosoft identifies the following security features available in Excel:
You can remove critical or private data from view by hiding columns and rows of data, and then protect the whole worksheet to control user access to the hidden data. In addition to protecting a worksheet and its elements, you can also lock and unlock cells in a worksheet to prevent other users from unintentionally modifying essential data.
At the file level, you can use encryption to prevent unauthorized users from seeing the data. You can also require password entry to open a workbook, or you can secure a workbook by employing a digital signature.
You can specify user-based permissions to access the data, or set read-only rights that prevent other users who may be able to view the data from making changes to it.
Perusing the web for postings comparing the features of databases to spreadsheets, you’ll find plenty of accusations that spreadsheets lack security and control features. Clearly, Microsoft’s description of the security features available in Excel shows that this isn’t the case. However, these security features may not be as robust as Microsoft claims, and they may prove difficult for the average user to implement.
As Martin Cacace of BoundState Software explains, “Although Excel allows you to protect data with a password and Windows-based permissions, it is extremely delicate and requires a deep understanding of Excel.” Some of these features won’t work if you have people using different operating systems or if you need access from other computers. Even a password protected Excel file is not really secure; there are tools on the Internet that anyone can use to unlock a protected Excel file without knowing the password.”
Databases offer far more control than spreadsheets over who can access and make changes to data. As an example, Locus EIM users must have a unique username and password. Users can be assigned to multiple privilege levels, ranging from “administrator” to “guest”. Customers that require a more fine-grained approach can use “roles” to assign permissions to specific modules, activities, or functionality to users. Password security is typically robustly designed in commercial databases, and can be configured to require complex passwords, session expiry, and password expirations to match customer IT requirements, something Excel would find challenging. Locus EIM also tracks all users and makes that information available to database admins to provide yet another layer of security for the system.
10) Databases are better at preventing data loss and data corruptionBecause of the general lack of controls that exist in most spreadsheets, it is far easier for a user to wreak havoc on them. One of the most dreaded developments that can occur is associated with the “Sort” function. A user may choose to sort on one or more columns, but not all—resulting in the values in the missed columns not matching up with those in the sorted ones. Nightmares like this are easily preventable (or are simply not possible) in databases.
Another advantage of database management systems is their ability to create audit trails, which preserve the original values in separate tables when changes are made to records. In the event that a user wants to undo some changes (including deletions) that he or she has made to a table, a data administrator can retrieve and restore the original state of the modified or deleted records. Also importantly, the circumstances of these changes are fully tracked (who, what, when, where), which is a minimum requirement for any quality assurance process.
Lastly, Excel stores the entire spreadsheet in memory, so if there is a system crash, you will lose everything you have entered or edited since your last save. In contrast, each operation you perform in a database is saved as you complete it. Moreover, most databases have daily backups, and in some cases, maintain an up-to-date copy of the data on a secondary device. Additionally, data is typically backed up in multiple geographic locations to provide even more recovery options in a disaster situation. Any good commercial database vendor will be happy to share their disaster recovery process because securing and maintaining your data is their most important job. In short, you can rest assured that your valuable data—often gathered over many years at a high cost—will not be lost if it is stored in a DBMS like Locus EIM.
About the author—Gregory Buckle, PhD, Locus Technologies
Dr. Buckle has more than 30 years of experience in the environmental field, most of which have been devoted to the design, development, and implementation of environmental database management systems. When he joined Locus in 1999, he was responsible for building and deploying Locus’ cloud-based EIM software. He was also instrumental in customizing EIM for the water utility industry and developing EIM’s powerful Sample Planning and Data Validation modules. The latest iteration of the Sample Planning module that Dr. Buckle built is currently being used by Los Alamos National Laboratory and San Jose Water Company to plan and schedule thousands of samples per year.
About the author—Marian Carr, Locus Technologies
Ms. Carr is responsible for managing overall customer solution deployments and customer relationships with Locus’ government accounts. Her career at Locus includes heading the product development team of the award-winning cloud-based environmental ePortal solution as well as maintaining and growing key customer accounts with Locus’ Fortune 100 enterprise deployments. In addition, Ms. Carr was instrumental in driving the growth and adoption of the Locus EIM platform with key federal and water organizations.
MOUNTAIN VIEW, Calif., 5 June 2018 — Locus Technologies (Locus), a leader in multi-tenant Software-as-a-Service (SaaS) for environmental compliance and sustainability management, will provide its IoT integration capability to Aquam Corporation (“Aquam”), a global provider of risk mitigation technologies for water and energy transmission and distribution assets, to create a robust data platform for its customers via Orbis Intelligent Systems. The Locus software will be integrated with the Orbis platform to allow interconnectivity across multiple devices, data streams, and geographical locations.
Orbis Intelligent Systems is positioned to be a market leader in infrastructure and water quality data-driven monitoring for commercial, domestic and utility applications.
“We chose Locus software for the reliability and data security that enables our technology platform to operate with robust, data-driven communication for all Aquam customers around the world to utilize. With the integration of rapidly scalable Locus software, we are at the forefront of IoT and well-positioned to offer asset ‘active management’—a core value to our customers and value proposition,” said Danny Krywyj, president for Orbis.
Locus Technologies’ multi-tenant cloud platform can help organizations to manage, organize, and monitor the structured and unstructured data coming from various sources. This allows customers to create a centralized data repository to analyze the key indicators for environmental data management, sustainability, and environmental compliance.
“Aquam Corporation will reap the benefits of IoT integration for monitoring data generated by different streaming devices, by centrally connecting these sources in a scalable cloud-based application for better managing compliance. Real-time monitoring of data directly and effectively solves many challenges related to smarter environmental management and sustainability initiatives,” said Wes Hawthorne, president of Locus Technologies.
ABOUT AQUAM CORPORATION
Aquam Corp is a global provider of technology solutions for water and energy distribution infrastructure. We ensure the health, longevity, safety, and reliability of vital resources for water and gas utility, municipal, commercial, residential, and industrial markets. Our award-winning proprietary technologies address water scarcity issues by the diagnosis, cleaning, and remediation of aging infrastructure. Aquam also provides end-to-end service solutions and technologies for the maintenance, life extension, and full rehabilitation of network distribution infrastructure, which include: Nu Flow Technologies, a leader in small-diameter infrastructure rehabilitation technologies; Specialized Pipe Technologies (SPT), a pipe assessment and rehabilitation services provider; Aquam Pipe Diagnostics, a global pipeline assessment specialist. Aquam services are available in North America, South America, Europe, Africa, Australasia, and the Middle East. For more information visit www.aquamcorp.com or contact aquam@missionC2.com.
EHS SaaS Multitenancy explained and why it matters.
There is a considerable degree of (intended) confusion in the EHS software space when it comes to cloud computing and multitenancy. If your software vendor cannot share statistics in real time like shown in the figure nearby, most likely they do not run on a multitenant SaaS platform.
The real-time information on system performance and security of SaaS cloud platform is the most important element that frequently gets overlooked during EHS software selection process. Success in the cloud is built on trust. Trust starts with transparency.
Our real time status monitoring (ran by an independent provider of web monitoring services) provide transparency around service availability and performance for Locus’ EHS SaaS products.
Just as with airlines that fly through clouds, our entire business is built on trust and security of our cloud offerings. Over 700,000 locations around the globe trust Locus to safeguard their data in the cloud.
Cloud Computing
Since the turn of the millennium, cloud computing has revolutionized the landscape of the computing world because it provides enterprise-grade computing resources that are affordable and instantly available. Clouds provide straightforward access to IT resources—you just access as many resources as you need when you need them, and never have to deal with the complexities of managing all of the underlying infrastructures that provide those resources. EHS manager job is suddenly a lot simpler and easier with cloud computing. You don’t even need help from IT department (if you don’t want it).
Multitenancy
Multitenancy is the fundamental technology that clouds use to share computing resources cost-efficiently and securely. Just like a bank—in which many tenants cost-efficiently share a hidden, common infrastructure, yet utilize a defined set of highly secure services, with complete privacy from other tenants—a cloud uses multitenancy technology to share IT resources securely among multiple applications and tenants (businesses, organizations, etc.) that use the cloud. Some clouds use virtualization-based architectures to isolate tenants; others use custom software architectures to get the job done. The multitenant design of a cloud service can have a dramatic impact on the application delivery and productivity of an IT organization, yet most CIOs, CTOs, system architects, and developers who use clouds don’t give it a second thought because it’s all magic that transparently happens behind the scenes.
Locus Platform is the proven cloud application development platform that powers popular Locus cloud EHS and Sustainability applications as well as custom applications that customers build to satisfy their specific EHS+S requirements.
SAN FRANCISCO, Calif., 24 August 2016 — Locus Technologies (Locus), the industry leader in cloud computing enterprise software for environmental, energy, air, water, and compliance management, is pleased to announce that the company has undergone a Service Organization Control 1SM and 2SM examination. A CPA report has been issued stating that Locus Technologies has maintained effective management over financial reporting, as well as the security, availability, processing integrity, confidentiality and privacy of its Software as a Service (SaaS) system. The assessment was performed by A-Lign. Locus is proud to have held these reports for the past four years.
The SOC 1SM report provides assurance to current or potential customers about the effectiveness of financial reporting systems at Locus. This report was prepared in accordance with Statement on Standards for Attestation Engagements (SSAE) No. 16, Reporting on Controls at a Service Organization. It is specifically intended to meet the needs of the entities that use Locus’ SaaS products and the CPAs that audit Locus’ financial statements, in evaluating the effect of the controls at Locus on the company’s financial statements.
Locus’ SOC 1SM report is a Type 2–report stating that the presentation and description of Locus’ system is fair, and that its design and operating effectiveness of controls achieve the related objectives included in the description throughout a specified period of time.
The SOC 2SM report is designed for customers who inquire about the effectiveness of controls at Locus that are relevant to the security, availability, or processing integrity of the system Locus uses to process customers’ information, or the confidentiality or privacy of that information.
The SOC 2SM report places Locus in a rare category among environmental data management providers to have attained this rigorous classification. In today’s corporate social responsibility (CSR) and risk-management environment, it is essential that service providers like Locus demonstrate that they have adequate controls and safeguards in place, so customers can be confident that their data are safe. Unlike most other environmental data management providers, Locus does not limit the SOC 2SM review to their data centers for hosting, but rather the entirety of the software development and management process, including the data centers.
“We are pleased that our SOC 1SM report has shown that we have the appropriate financial controls in place. This is in addition to a SOC 2SM report we received that is focused on mitigating risks related to security, availability, processing integrity, confidentiality and privacy of customers’ environmental, energy, sustainability, and compliance data stored in Locus’ cloud,” said Dr. Neno Duplan, CEO of Locus Technologies.
“The culture here at Locus is to put our customers first at all times, and it is essential that they feel secure with our financial information management and in trusting us with their data.”
MOUNTAIN VIEW, CA–(Marketwired – February 02, 2016) — Locus Technologies announced today that Environmental Business Journal (EBJ), a business research publication which provides high value strategic business intelligence to the environmental industry, granted the company the 2015 award for Information Technology in the environmental and sustainability industry for the tenth year running.
Locus was recognized for continuing its strategic shift to configurable Multitenant pure Software as a Service (SaaS) EHS solutions and welcoming new, high profile customers. In 2015 Locus scored record revenue from Cloud software with annual growth over 20 percent. Locus also achieved a record renewal rate of 99 percent and signed up new customers including Shell Oil Company, Philips 66, Ameresco, California Dairies, Cemex, Frito-Lay, Genentech, Lockheed Martin, PPG Industries, United Airlines and US Pipe & Foundry. Locus also became the largest provider of SaaS environmental software to the commercial nuclear industry; currently over 50 percent of U.S. nuclear generating capacity uses Locus’ flagship product. Locus’ configurable Locus Platform gained momentum in 2015 with new implementations in the manufacturing, agricultural and energy sectors, including a major contract with Sempra Energy for greenhouse gas management and reporting.
“Locus continues to influence the industry with its forward-thinking product set, pure SaaS architecture, and eye for customer needs,” said Grant Ferrier, president of Environmental Business International Inc. (EBI), publisher of Environmental Business Journal.
“We are very proud and honored to receive the prestigious EBJ Information Technology award in environmental business for a tenth time. We feel it is a testament to our unwavering commitment and dedication to accomplish this level of recognition, especially now as we lead the market by providing robust solutions for the emerging space of cloud and mobile-based environmental information management,” said Neno Duplan, President and CEO of Locus Technologies.
The 2015 EBJ awards will be presented at a special ceremony at the Environmental Industry Summit XIV in San Diego, Calif. on March 9-11, 2016. The Environmental Industry Summit is an annual three-day executive retreat hosted by EBI Inc.
The conversation about the environmental landscape has evolved drastically over the last 20 years as we continue to understand the extent to which human activity has affected the planet.
Businesses are currently not so keen on sharing the data they collect about their emissions, wastewater, and energy use as they are with sharing consumer information. But they are gathering those data, aggregating and analyzing it, and even acting on their activities as part of their risk-management protocols and environmental stewardship. What’s missing is the commitment to work across an industry, region, or country to measure all of these activities in a meaningful way on a global scale?
I am appalled that some Fortune 100 companies environmental managers I talk to tell me that they would not even host their company’s environmental data in the Cloud for fear of someone accessing it without authorization—the very same data their company is obliged to report to regulators and for which it is against the laws to not disclose data if found to exceed regulatory limits. Ironically, some of the very same companies see no problem with accessing our private information from consumer cloud companies to target us in selling their products and services.
Despite this resistance from business leaders, over the longer term I envision a world in which we can use shared environmental data to take a more concerted approach in our collective environmental stewardship. I consider the work that we do at Locus to be an important step in addressing a monumental global problem. There is a growing need for companies to harness their huge disconnected databases and spreadsheets and mine the information. In a decade or so, I envision the whole planet Earth as a meshed grid of static sensors coupled with movable ones installed on people, transportation devices, and other moving objects to collect data in real time.
Companies and society need a collective and holistic understanding of the problems we face. The only way to understand the full picture, and in turn to act meaningfully on a global level, is for all individuals and companies to understand the impact of their activities. It’s impossible to mitigate the risks and effects of those activities to the planet when we don’t have the data to characterize the problem and see a full picture.
While perhaps someday we will have environmental data sharing among all public and private organizations, the regulatory bodies that govern them, and the scientific community at large, which will provide us with an even more complete picture of our environmental activities, any coordinated effort is years in the making. One of impediments to institute a change like this lies with the Government. So far, it has not been able to impose data exchange standards, a prerequisite for a broad data exchange. In the meantime, Locus is ensuring we are ready to help tackle the problem one site, one facility, and one enterprise at a time.
Through the Locus EIM platform public facing website, Intellus, the general public can now access remediation and environmental data records associated with the Office of Environmental Management’s (EM’s) legacy nuclear cleanup program.
Containing more than 14 million records, Locus’ Intellus has consolidated Los Alamos National Laboratory’s (LANL’s) information that was previously handled in multiple independent databases. The centralized, cloud-based solution directly attributed to an estimated $15 million in cost savings for LANL through 2015.
The public facing site also ensures users have real-time access to the most recent data. The same data that scientists and analysts use to base important environmental stewardship decisions off of. Through tools and capabilities such as automated electronic data validation, interactive maps, and the ability to include data from other third-party providers and environmental programs, Intellus provides the ultimate platform to view LANL’s environmental data without compromising the core EIM system that LANL scientists use on a daily basis.
Locus has always advocated for the power of data transparency via the cloud. When you apply the most extensive security protocols to a cloud-based system, it can be a winning combination for data management and public trust.
Previously contained in a dozen independent databases, the integrated records of Los Alamos National Laboratory (LANL) — are now stored in one location, the publicly-accessible website Intellus.
Through the Locus EIM platform public facing website, Intellus, the general public can now access remediation and environmental data records associated with the Office of Environmental Management’s (EM’s) legacy nuclear cleanup program.
Containing more than 14 million records, Locus’ Intellus has consolidated Los Alamos National Laboratory’s (LANL’s) information that was previously handled in multiple independent databases. The centralized, cloud-based solution directly attributed to an estimated $15 million in cost savings for LANL through 2015.
The public facing site also ensures users have real-time access to the most recent data. The same data that scientists and analysts use to base important environmental stewardship decisions off of. Through tools and capabilities such as automated electronic data validation, interactive maps, and the ability to include data from other third-party providers and environmental programs, Intellus provides the ultimate platform to view LANL’s environmental data without compromising the core EIM system that LANL scientists use on a daily basis.
Locus has always advocated for the power of data transparency via the cloud. When you apply the most extensive security protocols to a cloud-based system, it can be a winning combination for data management and public trust.