Design of Banking Data Warehouse Architecture for Natural Language Query Execution

Student: Frenkel Dmitry

Supervisor: Anton Alexandrovich Afanasyev

Educational Programme: Business Informatics (Master)

Year of Graduation: 2017

Competitive advantage of the company in the market in large part depends on the quickness of the management decisions. Quickness and simplicity of extracting data from the company's information systems for the decision-making are two important success factors. This paper describes the architecture of a semantic layer of a bank data warehouse. The architecture allows for the formulation of analytical queries using natural language. The interaction of the user with the data warehouse is carried out in real time via graphical interface of an instant messages system, which is installed on the user's mobile phone. The designed semantic layer includes a logical data model of the data warehouse, business glossary and a list of key words and functions with defined restrictions. Semantic layer allows user to form unrestricted natural language queries, which execution result is either an aggregate indicator, characterizing a certain activity of a bank, or a selection of rows which is chosen according to user defined conditions.

Student Theses at HSE must be completed in accordance with the University Rules and regulations specified by each educational programme.

Summaries of all theses must be published and made freely available on the HSE website.

The full text of a thesis can be published in open access on the HSE website only if the authoring student (copyright holder) agrees, or, if the thesis was written by a team of students, if all the co-authors (copyright holders) agree. After a thesis is published on the HSE website, it obtains the status of an online publication.

Student theses are objects of copyright and their use is subject to limitations in accordance with the Russian Federation’s law on intellectual property.

In the event that a thesis is quoted or otherwise used, reference to the author’s name and the source of quotation is required.

Search all student theses