Query builder for database system

Abstract: Large amount of data is used by companies to enable good analysis of their system’s workability. Data can be stored in a partitioned database, to enable an optimal way of accessing the data. The problem with partitioning is that the complexity of the database structure increases. Therefore retrieving data demands higher expertise of the user. This degree project will examine different solutions to create an efficient and easy to use method, to access and retrieve data from a database with such architecture. Interviews have been conducted at Ericsson and were an important source of information. Existing query builders were another source - they were analyzed for comparison and ideas. As result of research and development, a customized query builder was created. It was adapted to Ericsson’s database environment and internal software. The SQL-queries are generated dynamically using the query builder that was developed in this degree project. The query builder takes input parameters, interpret them and then generate a query. It was implemented in C++, and satisfies specific demands and functionality.