www.singlestore.com Open in urlscan Pro
2600:9000:223e:6c00:1d:6ef1:2fc0:93a1  Public Scan

Submitted URL: https://app.go.singlestore.com/e/er?s=1387486446&lid=3659&elqTrackId=74AB12ABCDEFGHIJKLMNOPQ26c4bc5bd&elq=43ec4cbfaAB12ABCDEFGH...
Effective URL: https://www.singlestore.com/customers/siemens/?utm_medium=email&utm_source=singlestore&utm_campaign=newsletter-prospect-2022-08
Submission: On August 26 via api from CH — Scanned from DE

Form analysis 0 forms found in the DOM

Text Content

We value your privacy

We use cookies to enhance your browsing experience, serve personalized ads or
content, and analyze our traffic. By clicking "Accept All", you consent to our
use of cookies. Read More

Customize Reject All Accept All
Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions.
You will find detailed information about all cookies under each consent category
below.

The cookies that are categorized as "Necessary" are stored on your browser as
they are essential for enabling the basic functionalities of the site. ... Show
more

NecessaryAlways Active

Necessary cookies are required to enable the basic features of this site, such
as providing secure log-in or adjusting your consent preferences. These cookies
do not store any personally identifiable data.

 * Cookie
   _biz_sid
 * Duration
   30 minutes
 * Description
   This cookie is set by Bizible, to store the user's session id.

 * Cookie
   _biz_pendingA
 * Duration
   1 year
 * Description
   A Cloudflare cookie set to record users’ settings as well as for
   authentication and analytics.

 * Cookie
   _biz_flagsA
 * Duration
   1 year
 * Description
   A Cloudflare cookie set to record users’ settings as well as for
   authentication and analytics.

 * Cookie
   checkForPermission
 * Duration
   10 minutes
 * Description
   This cookie is set by Beeswax to determine whether the user has accepted the
   cookie consent box.

 * Cookie
   ARRAffinity
 * Duration
   session
 * Description
   ARRAffinity cookie is set by Azure app service, and allows the service to
   choose the right instance established by a user to deliver subsequent
   requests made by that user.

 * Cookie
   ARRAffinitySameSite
 * Duration
   session
 * Description
   This cookie is set by Windows Azure cloud, and is used for load balancing to
   make sure the visitor page requests are routed to the same server in any
   browsing session.

 * Cookie
   __cfruid
 * Duration
   session
 * Description
   Cloudflare sets this cookie to identify trusted web traffic.

 * Cookie
   AWSALBCORS
 * Duration
   7 days
 * Description
   This cookie is managed by Amazon Web Services and is used for load balancing.

 * Cookie
   YII_CSRF_TOKEN
 * Duration
   session
 * Description
   This cookie is used a unique token that used in securing forms and other
   website inputs against XSS attacks.

 * Cookie
   connect.sid
 * Duration
   2 hours
 * Description
   This cookie is used for authentication and for secure log-in. It registers
   the log-in information.

 * Cookie
   _GRECAPTCHA
 * Duration
   5 months 27 days
 * Description
   This cookie is set by the Google recaptcha service to identify bots to
   protect the website against malicious spam attacks.

 * Cookie
   cf_ob_info
 * Duration
   past
 * Description
   The cf_ob_info cookie is set by Cloudflare to provide information on HTTP
   Status Code returned by the origin web server, the Ray ID of the original
   failed request and the data center serving the traffic.

 * Cookie
   cf_use_ob
 * Duration
   past
 * Description
   Cloudflare sets this cookie to improve page load times and to disallow any
   security restrictions based on the visitor's IP address.

Functional


Functional cookies help perform certain functionalities like sharing the content
of the website on social media platforms, collecting feedback, and other
third-party features.

 * Cookie
   _biz_uid
 * Duration
   1 year
 * Description
   This cookie is set by Bizible, to store user id on the current domain.

 * Cookie
   _biz_nA
 * Duration
   1 year
 * Description
   This cookie, set by Bizible, is a sequence number that Bizible includes for
   all requests, for internal diagnostics purposes.

 * Cookie
   __cf_bm
 * Duration
   30 minutes
 * Description
   This cookie, set by Cloudflare, is used to support Cloudflare Bot Management.

 * Cookie
   UserMatchHistory
 * Duration
   1 month
 * Description
   LinkedIn sets this cookie for LinkedIn Ads ID syncing.

 * Cookie
   lang
 * Duration
   session
 * Description
   LinkedIn sets this cookie to remember a user's language setting.

 * Cookie
   bcookie
 * Duration
   1 year
 * Description
   LinkedIn sets this cookie from LinkedIn share buttons and ad tags to
   recognize browser ID.

 * Cookie
   lidc
 * Duration
   1 day
 * Description
   LinkedIn sets the lidc cookie to facilitate data center selection.

 * Cookie
   bscookie
 * Duration
   1 year
 * Description
   LinkedIn sets this cookie to store performed actions on the website.

 * Cookie
   ELOQUA
 * Duration
   1 year 1 month
 * Description
   The domain of this cookie is owned byOracle Eloqua. This cookie is used for
   email services. It also helps for marketing automation solution for B2B
   marketers to track customers through all phases of buying cycle.

 * Cookie
   split
 * Duration
   1 month
 * Description
   This cookie is used to evaluate the changes to the website by checking which
   multivariate test the user takes part in.

Analytics


Analytical cookies are used to understand how visitors interact with the
website. These cookies help provide information on metrics such as the number of
visitors, bounce rate, traffic source, etc.

 * Cookie
   _BUID
 * Duration
   1 year
 * Description
   This cookie, set by Bizible, is a universal user id to identify the same user
   across multiple clients’ domains.

 * Cookie
   ajs_anonymous_id
 * Duration
   1 year
 * Description
   This cookie is set by Segment to count the number of people who visit a
   certain site by tracking if they have visited before.

 * Cookie
   _ga
 * Duration
   2 years
 * Description
   The _ga cookie, installed by Google Analytics, calculates visitor, session
   and campaign data and also keeps track of site usage for the site's analytics
   report. The cookie stores information anonymously and assigns a randomly
   generated number to recognize unique visitors.

 * Cookie
   _gid
 * Duration
   1 day
 * Description
   Installed by Google Analytics, _gid cookie stores information on how visitors
   use a website, while also creating an analytics report of the website's
   performance. Some of the data that are collected include the number of
   visitors, their source, and the pages they visit anonymously.

 * Cookie
   _gcl_au
 * Duration
   3 months
 * Description
   Provided by Google Tag Manager to experiment advertisement efficiency of
   websites using their services.

 * Cookie
   _hjFirstSeen
 * Duration
   30 minutes
 * Description
   Hotjar sets this cookie to identify a new user’s first session. It stores a
   true/false value, indicating whether it was the first time Hotjar saw this
   user.

 * Cookie
   _hjIncludedInSessionSample
 * Duration
   2 minutes
 * Description
   Hotjar sets this cookie to know whether a user is included in the data
   sampling defined by the site's daily session limit.

 * Cookie
   _hjIncludedInPageviewSample
 * Duration
   2 minutes
 * Description
   Hotjar sets this cookie to know whether a user is included in the data
   sampling defined by the site's pageview limit.

 * Cookie
   _hjAbsoluteSessionInProgress
 * Duration
   30 minutes
 * Description
   Hotjar sets this cookie to detect the first pageview session of a user. This
   is a True/False flag set by the cookie.

 * Cookie
   _gat_UA-21693588-1
 * Duration
   1 minute
 * Description
   A variation of the _gat cookie set by Google Analytics and Google Tag Manager
   to allow website owners to track visitor behaviour and measure site
   performance. The pattern element in the name contains the unique identity
   number of the account or website it relates to.

 * Cookie
   ajs_user_id
 * Duration
   never
 * Description
   This cookie is set by Segment to help track visitor usage, events, target
   marketing, and also measure application performance and stability.

 * Cookie
   ajs_group_id
 * Duration
   never
 * Description
   This cookie is set by Segment to track visitor usage and events within the
   website.

 * Cookie
   undefined
 * Duration
   never
 * Description
   Wistia sets this cookie to collect data on visitor interaction with the
   website's video-content, to make the website's video-content more relevant
   for the visitor.

 * Cookie
   _hjTLDTest
 * Duration
   session
 * Description
   To determine the most generic cookie path that has to be used instead of the
   page hostname, Hotjar sets the _hjTLDTest cookie to store different URL
   substring alternatives until it fails.

 * Cookie
   CONSENT
 * Duration
   2 years
 * Description
   YouTube sets this cookie via embedded youtube-videos and registers anonymous
   statistical data.

 * Cookie
   browser_id
 * Duration
   5 years
 * Description
   This cookie is used for identifying the visitor browser on re-visit to the
   website.

Performance


Performance cookies are used to understand and analyze the key performance
indexes of the website which helps in delivering a better user experience for
the visitors.

 * Cookie
   _gat
 * Duration
   1 minute
 * Description
   This cookie is installed by Google Universal Analytics to restrain request
   rate and thus limit the collection of data on high traffic sites.

 * Cookie
   _uetsid
 * Duration
   1 day
 * Description
   Bing Ads sets this cookie to engage with a user that has previously visited
   the website.

 * Cookie
   _uetvid
 * Duration
   1 year 24 days
 * Description
   Bing Ads sets this cookie to engage with a user that has previously visited
   the website.

 * Cookie
   SRM_B
 * Duration
   1 year 24 days
 * Description
   Used by Microsoft Advertising as a unique ID for visitors.

 * Cookie
   AWSALB
 * Duration
   7 days
 * Description
   AWSALB is an application load balancer cookie set by Amazon Web Services to
   map the session to the target.

 * Cookie
   dtCookie
 * Duration
   session
 * Description
   This cookie is set by the provider Dynatrace. This is a session cookie used
   to collect information for Dynatrace. Its a system to track application
   performance and user errors.

Advertisement


Advertisement cookies are used to provide visitors with customized
advertisements based on the pages you visited previously and to analyze the
effectiveness of the ad campaigns.

 * Cookie
   MUID
 * Duration
   1 year 24 days
 * Description
   Bing sets this cookie to recognize unique web browsers visiting Microsoft
   sites. This cookie is used for advertising, site analytics, and other
   operations.

 * Cookie
   test_cookie
 * Duration
   15 minutes
 * Description
   The test_cookie is set by doubleclick.net and is used to determine if the
   user's browser supports cookies.

 * Cookie
   _fbp
 * Duration
   3 months
 * Description
   This cookie is set by Facebook to display advertisements when either on
   Facebook or on a digital platform powered by Facebook advertising, after
   visiting the website.

 * Cookie
   personalization_id
 * Duration
   2 years
 * Description
   Twitter sets this cookie to integrate and share features for social media and
   also store information about how the user uses the website, for tracking and
   targeting.

 * Cookie
   IDE
 * Duration
   1 year 24 days
 * Description
   Google DoubleClick IDE cookies are used to store information about how the
   user uses the website to present them with relevant ads and according to the
   user profile.

 * Cookie
   bito
 * Duration
   1 year 1 month
 * Description
   This cookie is set by Beeswax for advertisement purposes.

 * Cookie
   bitoIsSecure
 * Duration
   1 year 1 month
 * Description
   Beeswax sets this cookie for targeting and advertising. The cookie is used to
   serve the user with relevant advertisements based on real time bidding.

 * Cookie
   tuuid
 * Duration
   2 years
 * Description
   The tuuid cookie, set by BidSwitch, stores an unique ID to determine what
   adverts the users have seen if they have visited any of the advertiser's
   websites. The information is used to decide when and how often users will see
   a certain banner.

 * Cookie
   tuuid_lu
 * Duration
   2 years
 * Description
   This cookie, set by BidSwitch, stores a unique ID to determine what adverts
   the users have seen while visiting an advertiser's website. This information
   is then used to understand when and how often users will see a certain
   banner.

 * Cookie
   ANONCHK
 * Duration
   10 minutes
 * Description
   The ANONCHK cookie, set by Bing, is used to store a user's session ID and
   also verify the clicks from ads on the Bing search engine. The cookie helps
   in reporting and personalization as well.

 * Cookie
   bku
 * Duration
   6 months 1 day
 * Description
   Bluekai uses this cookie to build an anonymous user profile with data like
   the user's online behaviour and interests.

 * Cookie
   bkpa
 * Duration
   6 months 1 day
 * Description
   Set by Bluekai, this cookie stores anonymized data about the users' web usage
   in an aggregate form to build a profile for targeted advertising.

 * Cookie
   NID
 * Duration
   6 months
 * Description
   NID cookie, set by Google, is used for advertising purposes; to limit the
   number of times the user sees an ad, to mute unwanted ads, and to measure the
   effectiveness of ads.

 * Cookie
   YSC
 * Duration
   session
 * Description
   YSC cookie is set by Youtube and is used to track the views of embedded
   videos on Youtube pages.

 * Cookie
   VISITOR_INFO1_LIVE
 * Duration
   5 months 27 days
 * Description
   A cookie set by YouTube to measure bandwidth that determines whether the user
   gets the new or old player interface.

 * Cookie
   yt-remote-device-id
 * Duration
   never
 * Description
   YouTube sets this cookie to store the video preferences of the user using
   embedded YouTube video.

 * Cookie
   yt.innertube::requests
 * Duration
   never
 * Description
   This cookie, set by YouTube, registers a unique ID to store data on what
   videos from YouTube the user has seen.

 * Cookie
   yt.innertube::nextId
 * Duration
   never
 * Description
   This cookie, set by YouTube, registers a unique ID to store data on what
   videos from YouTube the user has seen.

 * Cookie
   yt-remote-connected-devices
 * Duration
   never
 * Description
   YouTube sets this cookie to store the video preferences of the user using
   embedded YouTube video.

Others


Other uncategorized cookies are those that are being analyzed and have not been
classified into a category as yet.

 * Cookie
   singlestoreTraits
 * Duration
   1 year
 * Description
   No description

 * Cookie
   mp_956569872348636f9bc2d62e4f838261_mixpanel
 * Duration
   1 year
 * Description
   No description

 * Cookie
   AnalyticsSyncHistory
 * Duration
   1 month
 * Description
   No description

 * Cookie
   li_gc
 * Duration
   5 months 27 days
 * Description
   No description

 * Cookie
   _rdt_uuid
 * Duration
   3 months
 * Description
   No description available.

 * Cookie
   muc_ads
 * Duration
   2 years
 * Description
   No description

 * Cookie
   CLID
 * Duration
   1 year
 * Description
   No description

 * Cookie
   _hjSessionUser_2171074
 * Duration
   1 year
 * Description
   No description

 * Cookie
   _hjSession_2171074
 * Duration
   30 minutes
 * Description
   No description

 * Cookie
   chzdpsync
 * Duration
   1 month
 * Description
   No description available.

 * Cookie
   _clck
 * Duration
   1 year
 * Description
   No description

 * Cookie
   _clsk
 * Duration
   1 day
 * Description
   No description

 * Cookie
   SM
 * Duration
   session
 * Description
   No description available.

 * Cookie
   intercom-id-oc3xi4bh
 * Duration
   8 months 26 days 1 hour
 * Description
   No description

 * Cookie
   intercom-session-oc3xi4bh
 * Duration
   7 days
 * Description
   No description

 * Cookie
   debug
 * Duration
   never
 * Description
   No description available.

 * Cookie
   loglevel
 * Duration
   never
 * Description
   No description available.

 * Cookie
   _zendesk_shared_session
 * Duration
   session
 * Description
   No description available.

 * Cookie
   _zendesk_session
 * Duration
   session
 * Description
   No description available.

 * Cookie
   _zendesk_thirdparty_test
 * Duration
   session
 * Description
   No description available.

 * Cookie
   _zendesk_authenticated
 * Duration
   past
 * Description
   No description

 * Cookie
   AUTH_SESSION_ID
 * Duration
   session
 * Description
   No description available.

 * Cookie
   AUTH_SESSION_ID_LEGACY
 * Duration
   session
 * Description
   No description available.

 * Cookie
   KC_RESTART
 * Duration
   session
 * Description
   No description available.

 * Cookie
   __tld__
 * Duration
   session
 * Description
   No description

 * Cookie
   r
 * Duration
   session
 * Description
   No description

 * Cookie
   docebo_session
 * Duration
   session
 * Description
   No description available.

 * Cookie
   SimpleSAMLSessionID
 * Duration
   session
 * Description
   This cookie is used for tracking the website sessions. It enables the users
   to remain logged in.

 * Cookie
   route-gcrowd-fe-prod
 * Duration
   session
 * Description
   No description available.

 * Cookie
   ajs%3Atest
 * Duration
   1 year
 * Description
   No description available.

 * Cookie
   ajs%3Acookies
 * Duration
   session
 * Description
   No description available.

 * Cookie
   _cookie_id
 * Duration
   session
 * Description
   No description available.

 * Cookie
   _forum_session
 * Duration
   session
 * Description
   No description available.

 * Cookie
   _help_center_session
 * Duration
   session
 * Description
   No description available.

Reject All Save My Preferences Accept All
Maximum Performance. Unprecedented Scale. Announcing SAS® Viya® With
SingleStore.
Find out more

Times Icon

 * Product
   
   Database
   Cloud Icon
   Cloud
   Database Icon
   On-Premises
   Align Right Icon
   Ingest Data
   Tools Icon
   Tools and Monitoring
   Lock Icon
   Security
   Services
   User Headset Icon
   Professional Services
   Life Ring Icon
   Support
   Presentation Icon
   Training
   Request a Demo
   Our product experts will give you a live demo and discuss your requirements
   Learn MoreArrow Right Icon
   Video
   Learn how SingleStore works and see it in action
   Watch NowArrow Right Icon
 * Solutions
   
   Use Cases
   Analytics Icon
   Real-Time Analytics
   Tachometer Fast Icon
   Supercharge SaaS Apps
   Expand Icon
   Scale Your Database
   Database Icon
   Consolidate Databases
   Industries
   Landmark Icon
   Financial Services
   Video Icon
   Media & Communication
   Bolt Icon
   Energy
   Microchip Icon
   High Tech
   View All SolutionsArrow Right Icon
   Why SingleStore?
   SingleStore enables companies to simplify their data architectures
   Learn MoreArrow Right Icon
   Customer Stories
   Trusted by Leading Global Brands and Data Innovators.
   View Case StudiesArrow Right Icon
 * Docs
   
   Build
   Book Icon
   Documentation
   Question Circle Icon
   FAQ
   Check Icon
   Tutorials
   Presentation Icon
   Training
   Developer Hub
   Build fast data applications with code repositories and more
   Start DevelopingArrow Right Icon
 * Resources
   
   View
   File Icon
   Case Studies
   Chart Line Icon
   Infographics
   Presentation Icon
   Webinars
   Play Icon
   Videos
   Read
   Book Icon
   Ebooks
   File Icon
   White Papers
   File Icon
   Solution Briefs
   Newspaper Icon
   Industry Reports
   View All ResourcesArrow Right Icon
   Industry Report
   The Gartner© Magic Quadrant™ for Cloud Database Management Systems
   Read NowArrow Right Icon
 * Community
   
   Engage
   Comments Icon
   Forums
   Code Icon
   Developer Hub
   Calendar Icon
   Events
   Webinar
   Captain Metrics: Why We Ditched MongoDB
   Watch NowArrow Right Icon
 * Company
   
   About
   Building Icon
   About Us
   Mountain Icon
   Leadership
   Puzzle Piece Icon
   Partners
   Briefcase Icon
   Careers
   Connect
   Blog Icon
   Blog
   Newspaper Icon
   News & Press
   Heart Icon
   SingleStore.org
   Comment Icon
   Contact Us
   We're hiringArrow Right Icon
   Blog Post
   It’s a Pivotal Time for Data and Disruption — and SingleStore Is Leading the
   Way in the Cloud
   Read NowArrow Right Icon
 * Pricing
   
   Open Search

 * Sign InSign In
   
   Laptop Icon
   Portal
   Access Cloud & Licenses
   Comments Icon
   Forums
   Ask the Community
   Users Class Icon
   Training
   Self-Paced Learning
   Life Ring Icon
   Enterprise Support
   Submit a Ticket
 * Start FreeStart Free
   


SINGLESTORE DELIVERS 10-100X PERFORMANCE
GAINS TO HELP SIEMENS AND ITS CUSTOMERS
MAKE SMART DECISIONS IN REAL TIME


Customers/Siemens
“With SingleStore, we no longer look at the database as a limiting factor in our
business." Christoph Malassa, Managing Consultant / Head of Analytics and
Intelligence Solutions, Siemens

--------------------------------------------------------------------------------

Data dashboards are ubiquitous today, but they were a technological marvel a
decade ago. Having visual dashboards in a browser was a major transformation,
improving accessibility to data insights. Back then, it took a long time to get
results from the system, but simply having access was a novelty. Expectations
are much different today. 

Siemens has empowered its customers through technology to transform the everyday
since 1847. Siemens, which at time of publication ranks #150 on Fortune's Global
500, purchased dashboarding software 12 years ago to create embedded dashboards,
integrating it into the platform. Over time, Siemens realized it wanted to have
dashboards outside of this platform, independent of any use case. 

Siemens built its Siemens Pulse Analytics platform as an internal Siemens
service in response to concrete problems, specific inquiries, individual use
cases, and a lack of offers on the market. This has resulted in
widely-applicable solutions that enable virtually any company to fully exploit
the potential of its data.

“We realized through the projects we were doing that we need surrounding
processes around the reporting. What we offer with the Pulse platform is the
entire end-to-end process for reporting analytics with surveys included, because
we have a long history of running internal and external surveys here at
Siemens,” said Christoph Malassa, Managing Consultant / Head of Analytics and
Intelligence Solutions, Siemens.








CHALLENGES/GOALS

Dashboarding needs to be tailored and flexible at the same time to bring
together data from different sources into reports. Once this transparency is
available on the dashboard, the question becomes: what do you do with it? How do
you make data actionable.

Pulse offered capabilities for internal and external projects to make data
actionable, but the system, based on SQL Server, fell short when it came to
performance. Customers were unable to harness the full value of their data
because they were frustrated by slow response times that didn’t meet modern
requirements.

Malassa explained, “Everything we wanted to do, we could do, but it was
painfully slow. Integrating data took a half hour. If you’re a business person,
you would approve a data flow and then wait for 30 minutes for this information
to appear in the staging area. Then you needed to make a decision to move to
production.”

Siemens previously had to run advanced analytics offline using IBM SPSS. “Even
when everything was done, if you looked at the dashboard and wanted to drill
through, the waiting times were longer than 2 seconds. If it's not instant or
very close to instant, it becomes painful. At that point, people just don’t do
the analytics and valuable information is lost. If you don't use it, and if you
don't analyze, you can’t find these things, you're not going to improve your
business.”




--------------------------------------------------------------------------------

“The waiting times were longer than 2 seconds. If it's not instant or very close
to instant, it becomes painful. At that point, people just don’t do the
analytics and valuable information is lost. If you don't use it, and if you
don't analyze, you can’t find these things, you're not going to improve your
business.”

Christoph Malassa, Managing Consultant / Head of Analytics and Intelligence
Solutions, Siemens

--------------------------------------------------------------------------------






TECHNOLOGY REQUIREMENTS 

Fast, real-time dashboards were a necessity for Pulse to live up to its
potential. Siemens’ primary business goals included: 

 * Running the platform in the cloud. 
 * Improving and increasing it from a capability perspective. 
 * Helping customers answer their questions using data with any existing
   business intelligence tools. 

Siemens Pulse needed super fast queries and analytics to support these business
goals, and their initial database technology choice, Microsoft SQL Server, was
not able to deliver on these requirements. 

Since the company offers professional services to its customers, every project
is different. The data sources could be almost anything, from databases to IoT
devices.




--------------------------------------------------------------------------------

“For this to work, we have to have a fantastic database so that anything we do
is quick. You want dashboards to be instant instead of waiting five seconds if
you change a filter.”

Christoph Malassa, Managing Consultant / Head of Analytics and Intelligence
Solutions, Siemens

--------------------------------------------------------------------------------




“If it exists somewhere, it can be a data source. We help customers answer the
questions using the data, or other data sources that we can connect to. For this
to work, we have to have a fantastic database so that anything we do is quick.
You want dashboards to be instant instead of waiting five seconds if you change
a filter,” said Malassa.






WHY SINGLESTORE

“We gradually became more and more unhappy with our platform’s performance. In
the early days the expectations of our customers were pretty low, because the
whole concept of dashboarding was so new. But then the amount of data grew
because we kept the history and were adding data every day. So the dashboards
became slower and users became less happy,” Malassa explained.

Siemens evaluated other database options as managed instances in AWS, including
MySQL and PostgreSQL, but found both were not well-suited for analytics due to a
lack of columnstore.

Faced with its growing dilemma and in Malassa’s words, “fed up” with SQL Server,
Siemens Googled for an answer. “We Googled, ‘what's the fastest relational
database analytics’? That’s how we found SingleStore. And that's exactly what we
needed to run super-fast analytics,” said Malassa.




--------------------------------------------------------------------------------

“Once we found SingleStore, there really wasn’t a reason to look at anything
else. We said, ‘Okay, this is awesome. We need this'.”

Christoph Malassa, Managing Consultant / Head of Analytics and Intelligence
Solutions, Siemens

--------------------------------------------------------------------------------




“Once we found SingleStore, there really wasn’t a reason to look at anything
else. We got the trial version on Thursday and the buying decision was done by
Tuesday, because we had huge improvements before we even really understood how
tuning worked,” said Malassa. “We said, ‘Okay, this is awesome. We need this'."






SOLUTION

Siemens Pulse Analytics is now a hybrid containerized app combining SingleStore,
Kubernetes, and AWS. Malassa and team store all data on SingleStore and upload
it to AWS S3 so Siemens and its customers can run analytics and machine learning
operations. “Analytics and all the processes surrounding analytics, such as data
preparation, machine learning results, action creation, and anything we report
on that users interact with, lives in SingleStore. The system loads data into
AWS S3 with the help of SingleStore’s Bottomless Storage, which separates
storage and compute,” said Malassa. “And SingleStore is an auto-scaling
analytical database. That is HUGE. You don’t see that.”




--------------------------------------------------------------------------------

“SingleStore is an auto-scaling analytical database. That is HUGE. You don’t see
that.”

Christoph Malassa, Managing Consultant / Head of Analytics and Intelligence
Solutions, Siemens

--------------------------------------------------------------------------------




The foundation of the system is a one SingleStore cluster configuration on a
single large machine with 96 cores processing millions or billions of rows of
data that it scales vertically as required. Malassa explained, “We originally
had four servers across two availability zones, but found that the simplest
setup is best for us. With everything on one machine, we gain the best
performance because we don’t have network traffic. Our main priority is when we
do ingest data we must recalculate the entire dataset because business rules
change over time. We also have strict data preparation standards, and reporting
must be quick. This all means we must be able to query billions of rows and get
results back in less than 100 milliseconds.”



Siemens Pulse Analytics supports upwards of 100 projects. On any given day it is
supporting from tens to hundreds to thousands of concurrent users, but since
many projects report monthly or quarterly, and Siemens itself has massive
projects that run several times per year. “System usage can be super spiky,
ranging from 500 to 100,000 users per day, and SingleStore scales linearly to
support this,” said Malassa.




--------------------------------------------------------------------------------

“System usage can be super spiky, anywhere from 500 to 100,000 users per day,
and SingleStore scales linearly to support this.”

Christoph Malassa, Managing Consultant / Head of Analytics and Intelligence
Solutions, Siemens

--------------------------------------------------------------------------------




Siemens can now do things such as instantly translating text right on the
database through HTTP User-Defined Functions in SingleStore. This allows
SingleStore to talk to APIs to bounce data from within the database to machine
learning functions, supporting capabilities such as translations instead of
having to offload it somewhere else.

SIEMENS PULSE ANALYTICS HELPS EVEN THE LARGEST ORGANIZATIONS TRANSFORM
COMPLEXITY INTO OPERATIONAL EXCELLENCE

By choosing SingleStore, Siemens was able to meet challenging data requirements
while making the system user-friendly for business users. The complexity of the
platform is abstracted away and the underlying data sources are handled in the
background so its customers can focus on the benefits associated with its two
unique selling propositions (USPs):

 * Optimize their businesses by cross-matching survey results at the team and
   individual level.\ Large organizations quickly encounter data complexity as
   they support cross-functions such as IT and HR, each of which may have
   organizational trees 10-12 levels deep and additional dotted-line reporting
   across multiple teams. With Siemens Pulse Analytics, however, organizations
   are transforming complexity into operational excellence. “This complexity
   also means an endless amount of useful combinations for our customers to
   study as they work to optimize their businesses,” said Malassa. “For example,
   if they do a survey and want to see results where IT and anyone on any other
   team in a division are in scope, now they can deduplicate results on the fly
   and show all applicable data — and only the applicable data, and each insight
   only once — to each user.”
 * Take it to the next level by validating data correlations.\ Another example
   of the value Siemens Pulse Analytics delivers is when organizations generate
   NPS scoring by surveying their customers. ‘On a scale of 1 to 10, how likely
   are you to recommend our company to others’ is useful, but it does nothing to
   identify and quantify the underlying factors that contributed to the
   customer’s assessment. “For example,” explained Malassa, “what impact did
   various dimensions, such as product quality, support, cost, and more have on
   their score — and on which dimension do they give your organization the
   lowest score? With Siemens Pulse Analytics, our customers can now drill down
   into things like NPS to get at the root cause of a score, drive those
   insights back into the business, improve their scores, and most importantly,
   retain their end customers.” In the past, Pulse had to provide these analytic
   insights by moving data into IBM SPSS, which as noted earlier, was painfully
   slow. With SingleStore as the underlying data foundation, Siemens and its
   customers can now slice and dice data in real time, and in the NPS example,
   instantly understand the validity of a data correlation.

"With Siemens Pulse Analytics, our customers can now drill down into things like
NPS to get at the root cause of a score, drive those insights back into the
business, improve their scores, and most importantly, retain their end
customers,” he added.




--------------------------------------------------------------------------------

“With Siemens Pulse Analytics, our customers can now drill down into things like
NPS to get at the root cause of a score, drive insights back into the business,
improve their scores, and most importantly, retain their end customers.”

Christoph Malassa, Managing Consultant / Head of Analytics and Intelligence
Solutions, Siemens

--------------------------------------------------------------------------------




SIEMENS IS DELIVERING GREATLY IMPROVED CUSTOMER EXPERIENCES WITH SINGLESTORE

“Having a database that makes it possible for dashboards to be instant is huge.
It's something that you always wish for. It should be the norm, but it wasn't,
at least for us, before we had SingleStore. Everything is still possible, but
significantly faster. Data processes run faster. Access to reports is much
faster. The whole user experience is just greatly improved.”




--------------------------------------------------------------------------------

“I'm not a Linux administrator, and I was able to deploy SingleStore on my own.
It’s pretty straightforward, and when you have questions, support is super
helpful.”

Christoph Malassa, Managing Consultant / Head of Analytics and Intelligence
Solutions, Siemens

--------------------------------------------------------------------------------




Deploying SingleStore was user-friendly for Malassa and team. “I'm not a Linux
administrator, and I was able to deploy SingleStore on my own. It’s pretty
straightforward, and when you have questions, support is super helpful,” he
said.








OUTCOMES 

“With Singlestore, we no longer look at the database as a limiting factor in our
business,” said Malassa. As a result of choosing SingleStore, Siemens is
experiencing a range of advantages that are helping the company and its
customers improve their businesses:

REAL-TIME DATA DRIVES ADVANCED ANALYTICS TO MAKE SMART DECISIONS AT THE SPEED OF
BUSINESS

“Transaction data works in many databases, but when it comes to analytics, most
databases don’t perform at all,” said Malassa. SingleStore’s powerful real-time
analytic capabilities accelerate time to insight to help Siemens and its
customers make better business decisions faster.

Before SingleStore, Siemens Pulse had limited capabilities due to how painfully
slow the system was. Integrating data took 30 minutes. With SingleStore, it is
experiencing a 10-100X improvement depending on the use case. Processes that
formerly required 10 steps are streamlined down to just one.

With SingleStore, users can now slice and dice the data in real time to
determine how valid a correlation is. They can also connect reporting lines in
endless useful combinations, with automatic deduplication. “They get
high-quality analytics that they can run in real time, and not just
aggregations, but statistical analysis as well. It’s all the advantages you get
from a really great analytics and reporting platform,” said Malassa.

ABILITY TO HAVE SINGLESTORE INSTANCES ACCESS THE SAME S3 DATA DELIVERS HUGE
COST-SAVINGS  

“The ability to have data in AWS S3 and have multiple SingleStore instances
accessing that same data means we can quickly scale up more clusters while
gaining a HUGE improvement in AWS costs,” said Malassa.




--------------------------------------------------------------------------------

“The ability to have data in AWS S3 and have multiple SingleStore instances
accessing that same data means we can quickly scale up more clusters while
gaining a HUGE improvement in AWS costs.”

Christoph Malassa, Managing Consultant / Head of Analytics and Intelligence
Solutions, Siemens

--------------------------------------------------------------------------------





PROCESSES INSTANT TEXT TRANSLATION AND MACHINE LEARNING FUNCTIONS RIGHT ON THE
DATABASE

Siemens can now instantly translate text right on the database through HTTP
User-Defined Functions in SingleStore, which allows APIs to bounce data from
within the database to machine learning functions in S3 and support capabilities
such as translations. 

QUERIES BILLIONS OF ROWS AND PETABYTES OF DATA IN REAL TIME TO ACCELERATE TIME
TO INSIGHT

Siemens had strict query result requirements to achieve their goal of real-time
reporting. For Pulse, instant results meant responses under 250 milliseconds.
The database must execute in 100 milliseconds or less to meet this requirement,
and SingleStore’s ultra-fast performance meets the challenge across hundreds of
terabytes or petabytes of data. 

ELASTIC SCALABILITY ACCOMMODATES SPIKY CONCURRENCY DEMANDS

The ability of SingleStore to auto-scale to accommodate massive usage spikes on
the fly enables Siemens to support from as few as 500 to as many as 100,000 
concurrent users. Siemens can confidently support its existing customer base and
scale as its Siemens Pulse Analytics business grows.




--------------------------------------------------------------------------------

Siemens is offering its customers Organization-Aware Analytics as a Service
powered by a core group of partners including SingleStore

Check out this Siemens review of SingleStore on TrustRadius, including:
"SingleStore is the fastest database ever tested by us."

SingleStore is helping companies compete and win across all verticals. Learn
more →


10-100X

speed improvements enabling real-time dashboards


<100MS

querying billions of rows & PB of Data <100ms


500 TO
100,000

Siemens Pulse Analytics auto-scales from 500 to 100,000 concurrent users


5 DAYS

from trial deployment to selection of Singlestore

SIEMENS IMPACT STORY

Download a PDF version of this customer story


READY TO GET STARTED?

Experience the performance of The Real-Time Distributed SQL Database for your
data today
Talk to a SpecialistStart for Free
 * Product
 * Cloud
 * On-Premises
 * Ingest Data
 * Tools and Monitoring
 * Security
 * Pricing
 * Request a Demo

 * Solutions
 * Why SingleStore?
 * Real-Time Analytics
 * Supercharge SaaS Apps
 * Scale Your Database
 * End Database Sprawl
 * Customers

 * Learn
 * Developer Hub
 * Forums
 * Events
 * Resources
 * Blog
 * News

 * Support
 * Support Plans
 * Support FAQ
 * Professional Services
 * Documentation
 * Training

 * Company
 * About Us
 * Leadership
 * Careers We're hiring
 * Partners
 * SingleStore.org
 * Contact Us

Twitter IconFacebook IconLinkedin In IconYoutube IconDiscourse IconGithub Icon
© SingleStore, Inc. |
Privacy Policy | Terms of Service | Legal Terms and Conditions