giftled.blogg.se - Tabular database

#Tabular database update#
#Tabular database software#

Business intelligence is about gathering insights from tabular data by transforming the data, adding features and presenting it in tabular format or on a graphical dashboard.

Disrupting the Business Intelligence marketĪs I have a background in business intelligence I was interested to see whether the AI capabilities that are currently making waves in other fields will also be influencing BI work in the future.

#Tabular database software#

With some experimentation it becomes very clear that the software development world will be disrupted by AI as well. The fact that ChatGPT has been used by millions of individuals and has seen large-scale media exposure tells that this field too is getting ready for real-world applications quickly.Ī major use case for ChatGPT and GPT-3 lies in their code-generation capabilities: they are not only capable of generating small snippets of program code but can generate larger programs like simple computer games which can be compiled and run. In November 2022 we have seen the release of ChatGPT which is a spinoff of the GPT-3 model and is even better suited for real-world conversations. Back in 2020 GPT-3 made huge improvements in the way that humans are able to interact with an AI, where the model showcased its ability to engage in compelling conversations with a human counterpart.

Large language models are emerging as a tool for solving many information and knowledge-related matters.

I will present an alternative approach by using the code-generation capabilities of GPT-3 to generate SQL for a database which in turn handle the query execution, showing great accuracy!.

TAPAS, a model tailored for table parsing and information extraction performs better than the GPT-based models, although it is still not perfect.

It appears that both ChatGPT and GPT-3 will present incorrect albeit very close answers to simple queries which require summations.

In this article I will examine what the capabilities of these models are for replacing business intelligence-based roles by investigating how they perform in extracting information from tables.

Large language models such as ChatGPT and GPT-3 are disrupting IT-based roles such as software development with their code-generation capabilities.

#Tabular database update#

Update May 4 2023: by this date, a more sophisticated way to perform querying on database tables is by using Langchain together with the SQLDatabaseChain.