Designing and implementing A New Method for Analysis and Designing Different Queries

Nowadays, a large amount of data is collected and stored in most organizations and companies, all the data that is collected in an organization is the result of years of activity of the organization, reporting of data is a very necessary thing and should be done in every organization according to the activities performed and the needs of the organization's managers. taken from the stored data, in most organizations they use databases or OLTP systems to store their data, reporting from OLTP systems is one of the most important challenges that most organizations face and they have always been looking for a way to be able to report their in the shortest time possible to create and be able to be completely sure of the correctness of the report taken, and they have always sought to create reports that they can use with high performance. by studying and researching in different methods, we found a way that you can use this method to prepare all your reports in the best way and with high performance in TSQL language from OLTP systems and be sure of the accuracy of the prepared report. It should be noted that the method that we want to present is implemented using the logic of discrete mathematics and the logic of executing queries. In this article, our main goal is to present this efficient method to you.

Keywords:

Data , Reporting , Databases , OLTP , TSQL