The results of an unusual three-week hackathon — a competition for solving technological problems of the IT-kvartal Challenge — will be announced on Thursday, November 14!

Our partners provided nine real-world tasks to improve their business processes.

The Tech Garden Autonomous Cluster Fund partners — Halyk Bank Kazakhstan, ReLog, Association of Financiers of Kazakhstan, OrionM2M, Asia-Soft, Evotech CA, ALCOR and Azimut Labs — provided 9 real tasks to improve their processes.

The companies also presented prizes: cash prizes, signing a contract or implementing a pilot project.

Startups had three weeks to solve problems. The deadline for solving problems ends. And on November 14, the solvers will have to present their options to customers. The creators of the best solutions will receive awards from the customers. In addition, the Tech Garden Autonomous Cluster Fund will provide the best team with free coworking spaces for six months.

Among the tasks: to develop a Vehicle Routing Problem algorithm, create a creative QR generator / reader, create a service of short links with analytics, auto-scaling, design a universal rate scale and create billing algorithms for rates, and others.

This competition is a kind of trial solution for working out the mechanism of corporate acceleration, which we plan to actively implement next year. Prior to that, several training and motivating events were held — in particular, in 2017, a trip was organized for residents of the FEZ “PIT” to Silicon Valley. It consisted of a series of lectures, professional panels, business master classes, meetings with mentors, and so on. At the end of November, we are bringing the executives of several large companies to South Korea so that they can be inspired by the experience of “open innovation” on the example of such giants as Hyundai Engineering and Construction, Samsung SDS, Hyosung, LS Industrial Systems and others.

Background information: Autonomous Cluster Fund (ACF) Tech Garden is a state organization established by the Government of the Republic of Kazakhstan. The Chairman of the ACF Steering Committee is the Prime Minister of the Republic of Kazakhstan. The Tech Garden innovation cluster is a professional environment for the development of innovations demanded by industry and business.

For additional information: Tatiana Napolskaya, +7 (707) 652-40-55

ID	(5,07)	Class	SQL
0	1,33	DB	SELECT * FROM en_press_releases WHERE id = :id AND active = :active AND active = 1 ORDER BY idx A SELECT * FROM en_press_releases WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
1	0,26	DB	SELECT * FROM en_rubrics WHERE 1=1 AND (en_rubrics.furl='press_releases') AND active = :active AN SELECT * FROM en_rubrics WHERE 1 = 1 AND ( en_rubrics.furl = 'press_releases' ) AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
2	0,48	DB	SELECT * FROM en_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1 SELECT * FROM en_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
3	0,21	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
4	0,15	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
5	0,16	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
6	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
7	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
8	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
9	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
10	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
11	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
12	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
13	0,15	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
14	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
15	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
16	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
17	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
18	0,17	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
19	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
20	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
21	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
22	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
23	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1

(5,07)

Class

SQL

1,33

SELECT * FROM en_press_releases WHERE id = :id AND active = :active AND active = 1 ORDER BY idx A

SELECT 
  * 
FROM 
  en_press_releases 
WHERE 
  id = :id 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  1

0,26

SELECT * FROM en_rubrics WHERE 1=1 AND (en_rubrics.furl='press_releases') AND active = :active AN

SELECT 
  * 
FROM 
  en_rubrics 
WHERE 
  1 = 1 
  AND (
    en_rubrics.furl = 'press_releases'
  ) 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  1

0,48

SELECT * FROM en_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1

SELECT 
  * 
FROM 
  en_rubrics 
WHERE 
  1 = 1 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  10000

0,21