Welcome!

SDN Journal Authors: Liz McMillan, Yeshim Deniz, Elizabeth White, Pat Romanski, TJ Randall

Related Topics: @DXWorldExpo, Microsoft Cloud, Cognitive Computing , @CloudExpo, Apache, SDN Journal

@DXWorldExpo: Article

Sentiment Analytics in SQL Server

Semantic search builds upon the existing full-text search feature in SQL Server,

Sentiment analytics is an emerging technology enabler for enterprises to extract the sentiments, opinions and emotions from their Big Data sources, so that enterprises can predict the potential acceptance of their products and offerings. This goes a long way in defining the success of the enterprise. As mentioned in my earlier posts it's always better to explore the extensions from the existing investments so that the enterprises get the best out of their existing investments. In this context the following notes throw some light on how sentiment analytics can be performed with SQL Server databases.

Semantic Search in SQL Server
Semantic search builds upon the existing full-text search feature in SQL Server, but enables new scenarios that extend beyond keyword searches. While full-text search lets you query the words in a document, semantic search lets you query the meaning of the document. Solutions that are now possible include automatic tag extraction, related content discovery, and hierarchical navigation across similar content.

There are two major functionalities that are part of Semantic Search Features, which can help when doing Sentiment Analytics.

  • Finding the key phrases in a document, ‘semantickeyphrasetable' TSQL procedure works on a table that consists of Text columns analyses them and returns the key phrases found in the specific text column. This function also returns a score, which specifics the statistical significance of the key phrase within the document.
  • Finding the key phrases that makes two documents similar or related to one another, ‘semanticsimilaritydetailstable' TSQL procedure works on a source text column and a matched text column on a table and returns all the key phrases that are common between the two documents mentioned.

With the above functions we can extract the key phrases within the documents as well as find the matching documents for a document of interest.

Mapping Semantic Search with Sentiment Analytics
The following table explains the typical attributes of sentiment analytics tool and how SQL Server with Semantic Search feature can be fit to that purpose.

Sentiment Analytics Requirement

SQL Server Feature Mapping

Natural Language Processing

The full text indexing options that enables semantic search accepts the language as a parameter. As per the documentation most of the languages like German, English, French, Italian, and Russian  are supported.

Text Analytics

The above mentioned options like the extraction of key phrases together with the Full Text Search features provides a solid building block for Text Analytics.

Storage & Indexing

Both the Full Text and Semantic Search indexes are supported with the storage optimization and flexibilities provided by SQL Server in the form of file group and data file placement.

Transformation

The sentiment analytics is not a one-stop process. With the building blocks provided by Semantic Search, multiple iterations of the key phrases and their relevance ranking needs to be transformed to get the results. SQL server options like SSIS and / or TSQL transformation procedures can play a vital role here.

Analytical Models

The process of classifying sentiments require complex algorithms like ‘Naïve Bayes' which have been already supported by SSAS (SQL Server Analysis Services). With the tight integration between SSAS and SQL Server utilizing these pre built algorithms in to sentiment analytics is quite possible.

Performance / Scalability / Big Data

While Sentiment Analytics can be done without Big Data, generally social media, click stream feeds and other unstructured data been the source for sentiment analytics. Technologies like Polybase which provides seamless integration between Hadoop HDFS stored data with SQL server tables will be an easier choice for sentiment analytics.

Also time consuming process like text extraction, indexing have been optimized using scale up capabilities of SQL Server core engine.

Summary
Utilizing sentiment analytics to promote their marketing campaigns and to improve the product offering will be a key project in most of organizations. With the growth of unconventional data sources the integration of text analytics is also an important aspect. While there are other choices, SQL Server with the integration of other supporting products mentioned above can be an effective choice for performing sentiment analytics.

More Stories By Srinivasan Sundara Rajan

Highly passionate about utilizing Digital Technologies to enable next generation enterprise. Believes in enterprise transformation through the Natives (Cloud Native & Mobile Native).

CloudEXPO Stories
ClaySys Technologies is one of the leading application platform products in the ‘No-code' or ‘Metadata Driven' software business application development space. The company was founded to create a modern technology platform that addressed the core pain points related to the traditional software application development architecture. The founding team of ClaySys Technologies come from a legacy of creating and developing line of business software applications for large enterprise clients around the world.
To Really Work for Enterprises, MultiCloud Adoption Requires Far Better and Inclusive Cloud Monitoring and Cost Management … But How? Overwhelmingly, even as enterprises have adopted cloud computing and are expanding to multi-cloud computing, IT leaders remain concerned about how to monitor, manage and control costs across hybrid and multi-cloud deployments. It’s clear that traditional IT monitoring and management approaches, designed after all for on-premises data centers, are falling short in this new hybrid and dynamic environment.
Most modern computer languages embed a lot of metadata in their application. We show how this goldmine of data from a runtime environment like production or staging can be used to increase profits. Adi conceptualized the Crosscode platform after spending over 25 years working for large enterprise companies like HP, Cisco, IBM, UHG and personally experiencing the challenges that prevent companies from quickly making changes to their technology, due to the complexity of their enterprise. An accomplished expert in Enterprise Architecture, Adi has also served as CxO advisor to numerous Fortune executives.
DevOpsSUMMIT at CloudEXPO, to be held June 25-26, 2019 at the Santa Clara Convention Center in Santa Clara, CA – announces that its Call for Papers is open. Born out of proven success in agile development, cloud computing, and process automation, DevOps is a macro trend you cannot afford to miss. From showcase success stories from early adopters and web-scale businesses, DevOps is expanding to organizations of all sizes, including the world's largest enterprises – and delivering real results. Among the proven benefits, DevOps is correlated with 20% faster time-to-market, 22% improvement in quality, and 18% reduction in dev and ops costs, according to research firm Vanson-Bourne. It is changing the way IT works, how businesses interact with customers, and how organizations are buying, building, and delivering software.
Dynatrace is an application performance management software company with products for the information technology departments and digital business owners of medium and large businesses. Building the Future of Monitoring with Artificial Intelligence. Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more business becomes digital the more stakeholders are interested in this data including how it relates to business. Some of these people have never used a monitoring tool before. They have a question on their mind like "How is my application doing" but no idea how to get a proper answer.