Banks and Credit bureaus
Posted by Oleg Solovyev on Aug 7, 2011
According to Russian legislation every bank has to report to one of the credit bureaus (CB). The reported credit histories (CH) contain info on credit amount, monthly payments and other information. Any bank can request your credit information to assess consumer credit worthiness and decide whether to issue you another loan or not.
Consumers with good credit histories can get a new loan with a lower interest rate. But one has to know which CB stores its credit history and what banks can request that history from CB. If your credit history is poor for example you had delinquent loans you better look for a bank that don’t request your credit history.
Text mining log files
Posted by Oleg Solovyev on Dec 13, 2009
The problem described in this article was solved during the DWH optimization project. At the beginning of the project the DWH was too slow and users often complained that it takes too much time to execute a query. We have started DWH optimization with the development of a set of indexes. There were very few indexes at that time.
One should create indexes for those tables that are read most often. The problem is that many SAS DBA’s don’t know how often the tables are queried. We also had neither data schema nor lists of users and tables that users have access to.
