По-русски

Business Logic implements ECM solution in EXPINET expert system

10.09.2013

Business Logic implements ECM solution in EXPINET expert system
The company Business Logic (I.T. Group) finished the first project on the implementation of ECM Logic Business Platform in the EXPINET expert network. The solution is built on the free software platform Alfresco.

EXPINET is an information and communication environment designed to organize work of an expert community in the gathering and generation of knowledge. Long before expert boards arose, a popular saying stated that "two heads are better than one." In the case of expert communities, dozens or hundreds of extremely smart heads come together.

The problem of managing and controlling these hundreds of experts and their collective knowledge presents a serious challenge. The experts must be motivated to generate knowledge and share it with the community for assessment. The procedures for shortlisting the most valued documents and expertise must be elaborated in order not to spam the base with low-quality material. Expert competence lists must be created and the knowledge generation process organized so that queries are processed only by the professionals in the appropriate subject.

This problem was solved on both sides simultaneously. The experts worked out the cooperation policies and the developers of the Business Platform implemented the requirements set by the project manager. In particular, any knowledge generation process (reviews, exams or other works) should be accompanied by a subsequent collective assessment, which is to be accounted for using a specialized algorithm taking into account such parameters as the personality of each evaluator.

Thus, the requirements combined both the issues of the document status management and those related to knowledge base populating. It turned out, that ECM Logic Business Platform handled them well.

"Designing the product ECM Logic Business Platform on the Alfresco free software platform, we tried to take into account different scenarios for its possible application, namely electronic data storage, scanned documents flow management system, automatization platform for the intensive document flow, either for classic document flow or even for some special scenarios like crediting management or handling insurance refund requests," remarks Oleg Beilezon, chief ECM designer at Business Logic. "The Business Platform services provide a variety of tools and 'construction materials' for the implementation of such projects. But the practice exceeded our theories, and our very first customer of the Business Platform-based project tested its reliability by imposing a number of non-standard requirements."

"To evaluate the whole our concept of the expert network we decided to create a prototype of the software platform on the basis of an existing solution, into which we would be able to implement the scientific approaches and mathematical models developed by our expert collective. However, the adaptation of, for example, social network platforms would contradict our basic principles. No single existing solution known to us provided for a controllable BPM process for the life cycle of a document. It was the reason that the project became stuck at the stage of elaborating the primary technical specifications," commented Kirill Yeremin, head of the EXPINET expert network. "It lasted for quite a long time until we took into consideration the solution developed by our colleagues from Business Logic. After that, the prototype development process went like clockwork. As a result, the EXPINET platform now has a reliable and scalable engine."


Module: advertising
Class: CAdvBanner
File: /var/www/bitrix/modules/advertising/classes/mysql/advertising.php
Function: GetPageWeights_RS
Line: 943
MySQL Query Error: SELECT DISTINCT B.TYPE_SID, B.ID BANNER_ID, B.WEIGHT BANNER_WEIGHT, B.SHOWS_FOR_VISITOR, B.FIX_CLICK, B.FIX_SHOW, B.KEYWORDS BANNER_KEYWORDS, DATE_FORMAT(B.DATE_SHOW_FIRST, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FIRST, DATE_FORMAT(B.DATE_SHOW_FROM, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FROM, DATE_FORMAT(B.DATE_SHOW_TO, '%d.%m.%Y %H:%i:%s') DATE_SHOW_TO, B.FLYUNIFORM FLYUNIFORM, B.MAX_SHOW_COUNT MAX_SHOW_COUNT, B.SHOW_COUNT SHOW_COUNT, C.ID CONTRACT_ID, C.WEIGHT CONTRACT_WEIGHT, C.KEYWORDS CONTRACT_KEYWORDS FROM b_adv_type T INNER JOIN b_adv_banner B ON ( B.ACTIVE='Y' and B.TYPE_SID = T.SID and B.STATUS_SID = 'PUBLISHED' and (B.FOR_NEW_GUEST is null or B.FOR_NEW_GUEST='Y') and (ifnull(B.MAX_SHOW_COUNT,0)>ifnull(B.SHOW_COUNT,0) or ifnull(B.MAX_SHOW_COUNT,0)=0) and (ifnull(B.MAX_CLICK_COUNT,0)>ifnull(B.CLICK_COUNT,0) or ifnull(B.MAX_CLICK_COUNT,0)=0) and (ifnull(B.MAX_VISITOR_COUNT,0)>ifnull(B.VISITOR_COUNT,0) or ifnull(B.MAX_VISITOR_COUNT,0)=0) and (B.DATE_SHOW_FROM<=now() or B.DATE_SHOW_FROM is null or length(B.DATE_SHOW_FROM)<=0) and (B.DATE_SHOW_TO>=now() or B.DATE_SHOW_TO is null or length(B.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_banner_2_site BS ON ( BS.BANNER_ID = B.ID and BS.SITE_ID = 'en') INNER JOIN b_adv_contract C ON ( C.ID = B.CONTRACT_ID and C.ACTIVE='Y' and (ifnull(C.MAX_SHOW_COUNT,0)>ifnull(C.SHOW_COUNT,0) or ifnull(C.MAX_SHOW_COUNT,0)=0) and (ifnull(C.MAX_CLICK_COUNT,0)>ifnull(C.CLICK_COUNT,0) or ifnull(C.MAX_CLICK_COUNT,0)=0) and (ifnull(C.MAX_VISITOR_COUNT,0)>ifnull(C.VISITOR_COUNT,0) or ifnull(C.MAX_VISITOR_COUNT,0)=0) and (C.DATE_SHOW_FROM<=now() or C.DATE_SHOW_FROM is null or length(C.DATE_SHOW_FROM)<=0) and (C.DATE_SHOW_TO>=now() or C.DATE_SHOW_TO is null or length(C.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_contract_2_site CS ON ( CS.CONTRACT_ID = B.CONTRACT_ID and CS.SITE_ID = 'en') INNER JOIN b_adv_contract_2_type CT ON ( CT.CONTRACT_ID = C.ID and (CT.TYPE_SID = 'ALL' or CT.TYPE_SID = T.SID)) INNER JOIN b_adv_banner_2_weekday BW ON ( BW.BANNER_ID = B.ID and BW.C_WEEKDAY='FRIDAY' and BW.C_HOUR = '7') INNER JOIN b_adv_contract_2_weekday CW ON ( CW.CONTRACT_ID = C.ID and CW.C_WEEKDAY='FRIDAY' and CW.C_HOUR = '7') LEFT JOIN b_adv_banner_2_group UG1 ON ( (UG1.BANNER_ID = B.ID and UG1.GROUP_ID in (2) and UG1.GROUP_ID<>2) ) LEFT JOIN b_adv_banner_2_page BP1 ON ( BP1.BANNER_ID = B.ID and BP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_banner_2_page BP2 ON ( BP2.BANNER_ID = B.ID and BP2.SHOW_ON_PAGE='N' and '/en/media-center/news/7510/index.php' like concat(BP2.PAGE, '%')) LEFT JOIN b_adv_contract_2_page CP1 ON ( CP1.CONTRACT_ID = C.ID and CP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_contract_2_page CP2 ON ( CP2.CONTRACT_ID = C.ID and CP2.SHOW_ON_PAGE='N' and '/en/media-center/news/7510/index.php' like concat(CP2.PAGE, '%')) LEFT JOIN b_adv_banner_2_stat_adv BA ON BA.BANNER_ID = B.ID LEFT JOIN b_adv_banner_2_country BC ON BC.BANNER_ID = B.ID AND ( ( (B.STAT_TYPE is null OR length(B.STAT_TYPE)=0 OR B.STAT_TYPE='COUNTRY') AND BC.COUNTRY_ID='' ) OR ( B.STAT_TYPE='REGION' AND BC.COUNTRY_ID='' AND BC.REGION='' ) OR ( B.STAT_TYPE='CITY' AND BC.CITY_ID='0' ) ) WHERE T.ACTIVE = 'Y' and ( B.STAT_COUNT is null or B.STAT_COUNT = 0 or BC.BANNER_ID is not null ) and BP2.ID is null and CP2.ID is null and (BP1.ID is null or '/en/media-center/news/7510/index.php' like concat(BP1.PAGE, '%')) and (CP1.ID is null or '/en/media-center/news/7510/index.php' like concat(CP1.PAGE, '%')) and (BA.STAT_ADV_ID is null or BA.STAT_ADV_ID='0') and (BC.COUNTRY_ID is null or BC.COUNTRY_ID='') and ( (B.SHOW_USER_GROUP = 'Y' and UG1.GROUP_ID is not null) or (B.SHOW_USER_GROUP <> 'Y' and UG1.GROUP_ID is null) ) ORDER BY B.TYPE_SID desc, C.ID desc [Got error 28 from storage engine]

DB query error.
Please try later.