{"id":1243,"date":"2010-05-06T07:00:14","date_gmt":"2010-05-06T15:00:14","guid":{"rendered":"http:\/\/www.formtek.com\/blog\/?p=1243"},"modified":"2010-05-06T07:00:14","modified_gmt":"2010-05-06T15:00:14","slug":"business-intelligence-dynatrek-enables-federated-database-access","status":"publish","type":"post","link":"https:\/\/formtek.com\/blog\/business-intelligence-dynatrek-enables-federated-database-access\/","title":{"rendered":"Business Intelligence (BI): DynaTrek Enables Federated Database Access"},"content":{"rendered":"

\"Dynatrek\"<\/a>DynaTrek<\/a>, a Tokyo-based company, has developed a technique<\/a> to dramatically speed up data access across an environment of distributed databases. \u00a0DynaTrek provides capabilities typically found in tools and systems used for performing Business Intelligence, Data Warehousing and ETL Data Transformation. \u00a0The technology is being used by 350 Japanese organizations, particularly in the areas of government, finance, manufacturing and telecommunication. \u00a0It has been used to build applications for business adminstration, accounting, production management, marketing, CRM and others. \u00a0One of the newest DynaTrek customers in Japan is currently in the process of migrating their customer service and call center operations from\u00a0SAP Business Objects<\/a> to DynaTrek, allowing them a plan to reduce the total number of BI servers needed from 15 to just 2; hence, reduce power consumption and save on maintenance fees.<\/p>\n

Key to the DynaTrek product is their\u00a0patented technology<\/a> that allows them to create very efficient SQL queries that favor the use of the SQL UNION operator over the much more computationally demanding SQL JOIN operator. \u00a0The result is that queries are dramatically faster, and that means that queries and decision making can be performed in real time.<\/p>\n

Two main advantages of the DynaTrek technology are that:<\/p>\n