Business Intelligence (or BI) is about processes and technology for collecting and analyzing business information. It is also regarded as a way to enhance data into information and then into knowledge.

Issues for Business Managers : how to query on very large databases ?

Of course, such transformation processes seldom apply to small amounts of data. Very large databases are becoming very common nowadays. Usual BI applications deal with terabytes of data. Unfortunately, the underlying relational database systems are not able to deal with complex queries on such huge volume of data. Only OLAP methods can be applied to such data.

However this comes together with a complex technical chain of processes to be executed prior to improving the performance. Moreover, such improvements will only be achieved in a predefined, rigid scope.

Ekoz Technology allows for querying on any scope of the Business available information

When a traditional relational database is used for Business Intelligence, indexing methods are used to speed up the retrieval of Information.

Without indexes, relational database would have to read the entire repository in order to find the relevant rows and attributes. Hence, If those indexes are designed the right way, they can improve the performance queries on a large relational database. On the other hand, a poorly defined index has dramatic consequences on the overall performance.

Ekoz Technology relies on relational database and does not use indexes

Traditional solutions - Hardware improvement

Another way for improving querying performance is to act on the hardware system. Indeed, the traditional trend in the software industry has been to match problem complexity with computing power: the more complex the problem was, the more CPU you added.

Whatever, it leads to more IT expenses with poor ROI in most cases. And for the most complex problems, it is unfortunately technically and physically impossible to increase the number of CPUs.

The quantum computers carries great potential:

When a classical computer has a memory made up of bits (1 or 0), A quantum computer works on qubits (1, 0, or a superposition of 1s and 0s). It is widely believed that if large-scale quantum computers can be built, they will be able to solve certain problems faster than any classical computer. The fact is : they are not ready yet.

Ekoz Technology relies on standard IT systems to provide you with undisputed best response time

Usage of Ekoz Universal Technology

EKOZ Universal Technology allows for querying on very large database with near-real-time response time.

1. OLAP Technology is no more necessary : the original information is not transformed (within complex IT Staff projects), nor limited in scope
2. Designing indexes in predefined dimensions known as being frequently used in complex queries is no more necessary.
3. With EKOZ, the race for computing power comes to an end. Whatever the problem complexity, very limited of computing power is needed. Multiple processors and highly parallelized architectures, and so on, are not necessary anymore.