Business Intelligence, Big Data Management, Data Architecture

Kinetica Announces Conversational Query First OpenAI ChatGPT Integration with Analytic Database

Prnewswire | May 03, 2023 | Read time : 05:00 min

Kinetica Announces Conversational Query First OpenAI ChatGPT

Kinetica today announced the industry's first analytic database to integrate with ChatGPT, ushering in 'conversational querying.' Users can ask any question of their proprietary data, even complex ones that were not previously known, and receive an answer in seconds. The combination of ChatGPT's front-end interface that converts natural language to Structured Query Language (SQL), and Kinetica's analytic database purpose built for true ad-hoc querying at speed and scale, provides a more intuitive and interactive way of analyzing complex data sets. Together, ChatGPT and Kinetica remove the limits of data exploration and unlock the full potential of an organization's data.

In today's fast-paced world, people expect instant gratification and rapid results, and ChatGPT's ability to deliver on this expectation is a major factor in its popularity. While ChatGPT can convert natural language to SQL, the speed of response for data analytics questions is dependent on the underlying data platform of the organization. Conventional analytic databases require extensive data engineering, indexing, and tuning to enable fast queries, which means the question must be known in advance. If the questions are not known in advance, a query may take hours to run or not complete at all.

The Kinetica database provides answers in seconds without the need for pre-engineering data. What makes it possible for Kinetica to deliver on conversational query is the use of native vectorization. In a vectorized query engine, data is stored in fixed-size blocks called vectors, and query operations are performed on these vectors in parallel, rather than on individual data elements. This allows the query engine to process multiple data elements simultaneously, resulting in radically faster query execution on a smaller compute footprint. Vectorization is made possible by GPUs and the latest advancements in CPUs, which perform simultaneous calculations on multiple data elements, greatly accelerating computation-intensive tasks by allowing them to be processed in parallel across multiple cores or threads.

Further, Kinetica converges multiple modes of analytics such as time series, spatial, graph, and machine learning that broadens the types of questions that can be answered, such as, "How can we improve the customer experience considering factors such as seasonality, service locations and relationships?" Kinetica also ingests massive amounts of streaming data in real-time to ensure answers represent the most up to date information, such as, "What is the real-time status of our inventory levels and how can we reroute active delivery vehicles to reduce the chances of products being out of stock?"

"While ChatGPT integration with analytic databases will become table stakes for vendors in 2023, the real value will come from rapid insights to complex ad-hoc questions," said Nima Negahban, Cofounder and CEO, Kinetica. "Enterprise users will soon expect the same lightning-fast response times to random text-based questions of their data as they currently do for questions against data in the public domain with ChatGPT."

With ChatGPT integration with Kinetica, querying becomes more interactive and conversational. Instead of writing complex SQL queries or navigating through complex user interfaces, users can simply ask questions using natural language. ChatGPT can understand the user's intent and generate queries based on their questions. The user can then ask follow-up questions or provide additional context.

"Kinetica plus ChatGPT makes complex, ad-hoc queries truly interactive, avoiding the 'interactus interruptus' of other integrations between large language models and databases," said Amit Vij, Cofounder and President, Kinetica. "Generative AI is a killer app for data analytics."

Conversational querying has several benefits, including:

  • Ease of Use: Allows users to ask questions using their own words and phrasing, making it easier to express their questions in a natural way. This approach removes the need to write and debug complex SQL queries, making the system more intuitive and accessible for a wider range of users. This broad data accessibility ultimately leads to more data driven decisions.
  • Increased Productivity: Conversational querying increases productivity by providing rapid access to information. Users get immediate answers to their questions without waiting for long running queries or data pipelines to be built. This saves time and improves overall efficiency.
  • Improved Data Insights: Conversational querying can help users uncover new insights and patterns in their data. By asking natural language questions coupled with immediate answers, users can discover unexpected correlations and relationships that may not have been immediately apparent or too tedious to uncover through traditional querying methods. This leads to improved business outcomes and better decision-making overall.

Kinetica with ChatGPT is available now for free in Kinetica Cloud.

About Kinetica

Kinetica is the creator of the only distributed, fully vectorized database for complex real-time analytic workloads, providing unrivaled scale and speed. Many of the world's largest companies across the public sector, financial services, telecommunications, energy, healthcare, retail, automotive and beyond rely on Kinetica, including the US Air Force, Ford, Citibank, T-Mobile, and others. Kinetica is a privately held company, backed by leading global venture capital firms Canvas Ventures, Citi Ventures, GreatPoint Ventures, and Meritech Capital Partners. Kinetica has a rich partner ecosystem, including AWS, Microsoft, NVIDIA, Intel, Dell, Tableau, and Oracle. For more information and to try Kinetica, visit kinetica.com or follow us on LinkedIn and Twitter.

Spotlight

Integrating analytics into UX work helps to make data-based decisions and focus efforts on projects with the most significant impact.


Other News
Data Science

PingCAP Attains Coveted AWS Data and Analytics Competency Status

PingCAP | September 13, 2023

On September 12, 2023, PingCAP, a prominent distributed SQL database provider, announced its attainment of the coveted Amazon Web Services (AWS) Data and Analytics Competency status. This prestigious designation underscores PingCAP's track record of successfully assisting customers in collecting, storing, governing, and analyzing data at any scale. The achievement of AWS Data and Analytics Competency signifies PingCAP as a distinguished member of the AWS Partner Network (APN), specializing in software solutions tailored to assist enterprises in embracing, developing, and deploying intricate projects on the AWS platform. This designation is reserved for APN members with extensive AWS proficiency who deliver solutions seamlessly within the AWS environment. Moreover, PingCAP has also secured AWS Service Ready designations for both AWS PrivateLink and Amazon Linux 2. The AWS Service Ready Program rigorously assesses AWS partner solutions for compatibility with specific AWS services. To obtain these accolades, PingCAP underwent meticulous technical evaluations of its product architecture, received references from customers, and provided product documentation. By harnessing AWS PrivateLink, customers gain access to a streamlined experience for connecting PingCAP TiDB Cloud with other AWS services and applications, ensuring heightened security and adaptable network configuration. AWS empowers organizations of all sizes with scalable, flexible, and cost-effective solutions, ranging from startups to global enterprises. In support of seamless integration and deployment of these solutions, AWS has instituted the AWS Competency Program, enabling customers to identify AWS Partners with profound industry acumen and expertise. Eddie Xu, Director of Cloud Alliances at PingCAP, commented, We are thrilled to achieve the AWS Data and Analytics Competency. Many of our customers have made long-term strategic investments to build their digital businesses on AWS. Being a part of this program reflects PingCAP's commitment to delivering a solution that meets security, compliance, and efficiency standards in support of our customers scaling their transactional workloads on AWS. [Source: Globe Newswire] About PingCAP PingCAP, headquartered in Silicon Valley, is the visionary behind TiDB, an advanced, open-source, distributed SQL database. This database powers modern applications, boasting a streamlined tech stack, elastic scalability, real-time analytics, and uninterrupted access to data—all unified within a singular database solution. These innovative capabilities liberate emerging enterprises from the complexities of data infrastructure management, allowing them to set their sights firmly on the future. Some of the world's leading businesses across the travel, technology, financial services, web3, and gaming sectors trust TiDB to manage their mission-critical workloads.

Read More

Big Data Management

Kinetica Redefines Real-Time Analytics with Native LLM Integration

Kinetica | September 22, 2023

Kinetica, a renowned speed layer for generative AI and real-time analytics, has recently unveiled a native Large Language Model (LLM) integrated with Kinetica's innovative architecture. This empowers users to perform ad-hoc data analysis on real-time, structured data with the ease of natural language, all without the need for external API calls and without data ever leaving the secure confines of the customer's environment. This significant milestone follows Kinetica's prior innovation as the first analytic database to integrate with OpenAI. Amid the LLM fervor, enterprises and government agencies are actively seeking inventive ways to automate various business functions while safeguarding sensitive information that could be exposed through fine-tuning or prompt augmentation. Public LLMs, exemplified by OpenAI's GPT 3.5, raise valid concerns regarding privacy and security. These concerns are effectively mitigated through native offerings, seamlessly integrated into the Kinetica deployment, and securely nestled within the customer's network perimeter. Beyond its superior security features, Kinetica's native LLM is finely tuned to the syntax and industry-specific data definitions, spanning domains such as telecommunications, automotive, financial services, logistics, and more. This tailored approach ensures the generation of more reliable and precise SQL queries. Notably, this capability extends beyond conventional SQL, enabling efficient handling of intricate tasks essential for enhanced decision-making capabilities, particularly for time-series, graph, and spatial inquiries. Kinetica's approach to fine-tuning places emphasis on optimizing SQL generation to deliver consistent and accurate results, in stark contrast to more conventional methods that prioritize creativity but yield diverse and unpredictable responses. This steadfast commitment to reliable SQL query outcomes offers businesses and users the peace of mind they deserve. Illustrating the practical impact of this innovation, the US Air Force has been collaborating closely with Kinetica to leverage advanced analytics on sensor data, enabling swift identification and response to potential threats. This partnership contributes significantly to the safety and security of the national airspace system. The US Air Force now employs Kinetica's embedded LLM to detect airspace threats and anomalies using natural language. Kinetica's database excels in converting natural language queries into SQL, delivering responses in mere seconds, even when faced with complex or unfamiliar questions. Furthermore, Kinetica seamlessly combines various analytics modes, including time series, spatial, graph, and machine learning, thereby expanding the range of queries it can effectively address. What truly enables Kinetica to excel in conversational query processing is its ingenious use of native vectorization. In a vectorized query engine, data is organized into fixed-size blocks called vectors, enabling parallel query operations on these vectors. This stands in contrast to traditional approaches that process individual data elements sequentially. The result is significantly accelerated query execution, all within a smaller compute footprint. This remarkable speed is made possible by the utilization of GPUs and the latest CPU advancements, which enable simultaneous calculations on multiple data elements, thereby greatly enhancing the processing speed of computation-intensive tasks across multiple cores or threads. About Kinetica Kinetica is a pioneering company at the forefront of real-time analytics and is the creator of the groundbreaking real-time analytical database specially designed for sensor and machine data. The company offers native vectorized analytics capabilities in the fields of generative AI, spatial analysis, time-series modeling, and graph processing. A distinguished array of the world's largest enterprises spanning diverse sectors, including the public sector, financial services, telecommunications, energy, healthcare, retail, and automotive industries, entrusts Kinetica to forge novel solutions in the realms of time-series data and spatial analysis. The company's clientele includes various illustrious organizations such as the US Air Force, Citibank, Ford, T-Mobile, and numerous others.

Read More

Business Intelligence

Dremio Launches Next-gen Reflections Redefining SQL Query Acceleration

Dremio | September 15, 2023

Dremio, a renowned easy and open data lakehouse solution provider, has recently introduced its next-gen Reflections technology, marking a transformative milestone in SQL query acceleration. Dremio Reflections facilitate sub-second analytics performance across an organization's entire data ecosystem, irrespective of data location. This groundbreaking technology is redefining data access and analysis, ensuring that valuable insights are derived efficiently and swiftly, all while reducing costs to merely one-third of a typical cloud data warehouse. Reflections represent Dremio's innovative SQL query acceleration technology. Queries that leverage Reflections exhibit performance gains ranging from 10 to 100 times faster than their non-accelerated counterparts. This latest release introduces the Dremio Reflection Recommender, a pioneering feature that empowers users to accelerate Business Intelligence workloads in a matter of seconds. The Reflection Recommender automatically evaluates an organization's SQL queries and generates recommended Reflections to accelerate them. Tomer Shiran, founder of Dremio, commented, Dremio Reflections accelerate SQL queries by orders of magnitude, eliminating the need for BI extracts/imports and enabling companies to run their most mission-critical BI workloads directly on a lakehouse. With automatic recommendations and next-generation incremental updates, we've made it even easier for organizations to take advantage of this innovative technology. [Source: Business Wire] Reflection Recommender eliminates the need for labor-intensive manual data and workload analysis, making the process of obtaining the fastest and most intelligent query results effortless, requiring only a few simple actions. The user-friendly nature of the Reflection Recommender puts advanced query acceleration capabilities within the reach of all users, significantly saving both time and expenses. Dremio has also refined the process of refreshing Reflections to further bolster query performance and drive cost efficiencies. It now intelligently refreshes Reflections on Apache Iceberg tables, promptly capturing incremental data changes. This innovative approach obviates the requirement for complete data refreshes, resulting in speedier updates and reduced compute expenses. Dremio Reflections eliminates the need for data teams to export data from the data lakehouse into BI extracts or imports for analytical reasons and overcomes performance bottlenecks for BI dashboards and reports. In addition, Reflections negate the necessity of creating precomputed tables within the data lake or data warehouse to achieve sub-second performance for BI workloads, reducing the workload and complexity for data teams. About Dremio Dremio is a leading, easy and open data lakehouse solution provider, offering organizations the versatility of self-service analytics coupled with the functionality of a data warehouse and the flexibility of a data lake. Dremio's platform empowers users to harness the lightning-fast SQL query service alongside various processing engines, all on the same dataset. The company distinguishes itself through a pioneering data-as-code methodology akin to Git, which facilitates data experimentation, version control, and governance. This innovative approach enhances agility and empowers organizations to explore and manage their data resources with unprecedented efficiency. Furthermore, Dremio offers a fully managed service that expedites organizations' entry into analytics, allowing them to commence their data-driven journey within minutes.

Read More

Big Data Management

iMerit Unveils Innovative Solution for Radiology AI Data Challenges

iMerit | September 07, 2023

iMerit, a prominent player in the field of artificial intelligence (AI) data solutions, has unveiled its latest offering, the Radiology Annotation Product Suite. This innovative suite is designed to cater to the needs of medical AI developers by providing advanced automation, annotation, and analytics capabilities. This new product suite is firmly rooted in iMerit's Ango Hub platform, an end-to-end enterprise-grade technology platform that is specifically tailored to deliver top-notch data annotation tools for AI development teams. Within this suite, a comprehensive range of solutions awaits, including data sourcing, workflow design, cutting-edge data annotation tools, and the invaluable input of human experts, all seamlessly integrated into a single platform. This unique fusion of iMerit's technological prowess and radiology expertise ensures a smooth journey from training data all the way to regulatory benchmarking. A significant hurdle in radiology AI applications is the demand for specialized tools and insights from domain experts to ensure the necessary accuracy and precision in training data. For developers, the Radiology Annotation Product Suite offers a one-stop solution, combining automation, annotation tools, and analytics within a single platform, facilitating the creation of precise data pipelines essential for quick scaling radiology AI solutions into production. Sina Bari MD, Senior Director of Medical AI at iMerit, explained that their suite aims to combine human expertise, data management, and automation in a single solution. Notable features include Customized workflows designed for Radiologists with consensus and multistep capabilities. Diagnostic-level annotation accuracy with multiplanar functionality and 3D volume rendering. Efficient annotation facilitated by smart automation tools and model integration. Stringent data security and regulatory compliance, including CFR 21 Part 11, HIPAA, and SOC2. This solution seamlessly integrates U.S. and offshore experts, including board-certified radiologists, all within a highly secure end-to-end platform, ensuring cost-effective scaling of annotation efforts. Radha Basu, Founder and CEO of iMerit, emphasized the importance of their work, stating that they understand the challenges of developing AI applications and that their suite was built to scale data annotation efforts with high quality, accuracy, and speed. About iMerit iMerit is a prominent AI data solutions company specializing in data services such as dataset creation, image tagging, sentiment analysis, data verification, and content aggregation. It serves Fortune 500 enterprises in various industries and have a global presence, with headquarters in the United States and teams in India, the US, Bhutan, and Europe. iMerit's investors include Omidyar Network, Dell.org, Khosla Ventures, and British International Investment.

Read More