﻿{"id":3678,"date":"2009-06-03T14:23:27","date_gmt":"2009-06-03T13:23:27","guid":{"rendered":"http:\/\/www.b-consulting.com\/en\/?p=3678"},"modified":"2016-10-05T14:27:12","modified_gmt":"2016-10-05T13:27:12","slug":"illuminate-unveils-latest-version-of-groundbreaking-correlation-database-technology-that-automatically-designs-and-builds-data-warehouses","status":"publish","type":"post","link":"https:\/\/www.b-comm.fr\/en\/2009\/06\/03\/illuminate-unveils-latest-version-of-groundbreaking-correlation-database-technology-that-automatically-designs-and-builds-data-warehouses\/","title":{"rendered":"illuminate Unveils Latest Version of Groundbreaking Correlation Database Technology That Automatically Designs and Builds Data Warehouses"},"content":{"rendered":"<p class=\"spip\"><strong class=\"spip\">iLuminate 4.0 offers world\u2019s fastest performance, lowest cost of ownership from low deployment costs, and near-zero maintenance\u2014as well as the Holy Grail in analytics: train-of-thought analysis\u2122.<\/strong><\/p>\n<p><em>MINNEAPOLIS, Minn. and BARCELONA, SPAIN on 3 June 2009<\/em><\/p>\n<p class=\"spip\">illuminate Solutions (<a class=\"spip_out\" href=\"http:\/\/www.illuminateinc.com\/\">http:\/\/www.illuminateinc.com<\/a>) today announced the release of its iLuminate correlation database technology. Testing indicates that it beats by an order of magnitude any data warehouse or data mart vendors\u2019 benchmarks in the areas most important to customers: Time-to-analytics\u2122, time-to-answer\u2122, and total cost of ownership (TCO).<\/p>\n<p class=\"spip\">&#8220;<i class=\"spip\">For too long, customers have been told to measure a vendor\u2019s performance by what the vendors themselves think is important\u2014speeds and feeds,&#8221;<\/i> said Kirsten Chapman, illuminate\u2019s chief marketing and alliances officer. &#8220;<i class=\"spip\">Who cares about how fast data can be loaded into a database if it\u2019s not usable? And although query performance is important, it\u2019s only an interim step. What really matters is getting to the answer you need so you can make a decision. Query speed is only one aspect of that.<\/i>&#8220;<\/p>\n<p class=\"spip\">Chapman encourages customers to start demanding benchmarks that reflect what\u2019s important to them\u2014usability, answers and cost\u2014rather than what vendors say is important.<\/p>\n<p class=\"spip\"><strong class=\"spip\">Why illuminate beats all vendors in customer-centric benchmarks<\/strong><\/p>\n<p class=\"spip\"><strong class=\"spip\">Fastest time-to-analytics<\/strong>\u2014the time it takes to design, build, integrate, and deliver raw data in a usable form for analysis and exploration. Includes metric of load-speed. With iLuminate 4.0, customers can deploy a completely optimized, 100 percent flexible data warehouse or data mart of nearly any size in one-tenth the total time and cost\u2014or less. There is no need for physical database design and programming or optimization techniques\u2014the technology creates a data-generated data model on the fly while it\u2019s loading data. When the load in complete, the data is ready for train-of-thought user analysis. iLuminate 4.0 load-speed is comparable to or faster than every other vendor\u2019s when customer usability requirements are considered.<\/p>\n<p class=\"spip\"><strong class=\"spip\">Fastest time-to-answer<\/strong>\u2014the time it takes from the moment a user begins to analyze an issue to the time the user has the answer needed to make a decision. Includes metric of query speed. With iLuminate 4.0, users can do train-of-thought analysis from the moment they determine a need until they get the answer. All data is indexed for user access and gives them never-before-seen query types to explore data without hitting the limits of fixed data model structures that require IT intervention in order for the analysis to continue. iLuminate query performance is clocked at 20x or more faster than column databases such as Sybase IQ and Vertica and up to 60x faster than relational databases like Oracle, DB2, Teradata and Netezza.<\/p>\n<p class=\"spip\"><strong class=\"spip\">Lowest TCO<\/strong>\u2014the combination of hardware, software, and labor for implementation and ongoing maintenance of an analytics system. With iLuminate 4.0 requiring no physical design, programming or optimization, labor costs are a small fraction of any other vendors\u2019 implementation costs. iLuminate also offers near-zero maintenance costs in two ways: 1) all data is indexed and available, so no IT projects are required to keep the system relevant, 2) new data sources are integrated and indexed on the fly during the load process, eliminating the need for re-architecting and optimizing the system.<\/p>\n<blockquote>\n<p class=\"spip\">&#8220;<i class=\"spip\">At first, we were skeptical that the software would do what illuminate said it would do<\/i>,&#8221; said Bram Millenaar, Manager ICT at Neckermann.com, a large European online retailer. &#8220;<i class=\"spip\">To our great surprise, the POC proved it really works as advertised, so we bought it immediately. We\u2019re extremely impressed with its fast deployment and the performance and flexibility of illuminate\u2019s correlation database. There\u2019s nothing else like it<\/i>.&#8221;<\/p>\n<\/blockquote>\n<p class=\"spip\"><strong class=\"spip\">New iLuminate 4.0 features<\/strong><\/p>\n<p class=\"spip\">64-bit architecture allows for nearly unlimited scalability and faster query performance;<\/p>\n<p class=\"spip\">Enhanced multi-threading enables a larger number of users simultaneous database access;<\/p>\n<p class=\"spip\">Web services architecture allows for managed services and cloud deployments;<\/p>\n<p class=\"spip\">LDAP\/Active Directory-based users and privileges management plugs into customers\u2019 existing production environments; and Public APIs (Java, .Net, C++) enable easy development of custom analytic applications.<\/p>\n<p class=\"spip\"><strong class=\"spip\">iLuminate 4.0 Query Performance Results<\/strong><\/p>\n<p class=\"spip\">iLuminate 4.0 database technology uses groundbreaking value-based storage (VBS), which stores data values only once and uses a sophisticated indexing system to logically connect all data correlations and relationships. The database\u2014actually the indexing system itself\u2014is created on the fly during the load process and is inherently compact and ultra-fast since all data is accessed at index speed.<\/p>\n<p class=\"spip\">Testing Environment:<\/p>\n<p class=\"spip\">Hardware\u2014cost $6,100 USD: one Dell 2900 Server, two dual core 2.66 Ghz processors, 10 Gbs RAM, six 300 Gbs 15,000 RPM disks in raid 5;<\/p>\n<p class=\"spip\">Database\u2014sources: retail ERP (90% total source data), one Access database (&lt;9% total source data), two Excel spreadsheets (&lt;1% total source data); total records: approximately 1.3 billion; extracted data size: approximately 350 Gbs;<\/p>\n<p class=\"spip\">Data preparation before loading: None<\/p>\n<p class=\"spip\">Testing Results Query Types:<\/p>\n<p class=\"spip\">Scan-type query: &lt;.01 seconds on entire database. Simulates a scan rate of more than 10 billlion records per second, compared to Netezza\u2019s 650 million records per second on proprietary hardware.<\/p>\n<p class=\"spip\">Look-up-type query: .3 seconds on entire database shows speed of large response set size.<\/p>\n<p class=\"spip\">Multi-qualification query-type: .2 seconds on entire database shows speed of large intermediate results.<\/p>\n<p class=\"spip\">Product affinity-type query: 1.6 seconds on 772,836,787 record database. Comparable to Vertica\u2019s 60-second mean result on a 100 Gb database tested on similar commodity hardware configuration.<\/p>\n<blockquote>\n<p class=\"spip\">&#8220;<i class=\"spip\">As close as I am to the technology, even I was surprised with the benchmarks<\/i>,&#8221; said illuminate\u2019s CTO Joe Foley. &#8220;<i class=\"spip\">But when you consider that everything is accessed at index speed, it really makes sense that we have a quantum leap in performance. Even with this record-breaking speed, what\u2019s important to users is this time-to-answer metric<\/i>.&#8221;<\/p>\n<\/blockquote>\n<p class=\"spip\">Foley emphasized that illuminate\u2019s real value is its ability to give users train-of-thought analysis so they can keep working a problem until they\u2019re satisfied that they have what they need to make a decision. It eliminates running into the walls inherent in fixed database models that require special IT projects to work around them.<\/p>\n<p class=\"spip\">illuminate\u2019s sales process is focused on driving customers to do Proof-of-Concepts (POCs) in order to prove that its claims are true: automatic data warehouse design and build, as well as 100 percent query flexibility with world\u2019s fastest performance.<\/p>\n<p class=\"spip\"><strong class=\"spip\">illuminate Products, Pricing and Distribution<\/strong><\/p>\n<p class=\"spip\"><strong class=\"spip\">iLuminate 4.0<\/strong>\u2014correlation database engine. Price based on number of records loaded. Starts at $41,900 for up to 35 million records. Concurrent connection fees apply and start at $2,750 for up to four connections;<\/p>\n<p class=\"spip\"><strong class=\"spip\">iCorrelate<\/strong>\u2014exploration and analysis tool. Price is $8,000 per seat; and<\/p>\n<p class=\"spip\"><strong class=\"spip\">iLook&amp;Load<\/strong>\u2014quick data profiling and loading tool. Price is $10,000 per tool.<\/p>\n<p class=\"spip\">illuminate sells its products exclusively through an alliance network. Its partners are highly respected and experienced IT consulting firms that complete an illuminate-delivered intensive certification program and exam in order to be qualified to install and support its products. Presently, the company is building its partner network in Europe, Latin America and North America.<\/p>\n<p class=\"spip\">\n","protected":false},"excerpt":{"rendered":"<p>iLuminate 4.0 offers world\u2019s fastest performance, lowest cost of ownership from low deployment costs, and near-zero maintenance\u2014as well as the Holy Grail in analytics: train-of-thought analysis\u2122. MINNEAPOLIS, Minn. and BARCELONA, SPAIN on 3 June 2009 illuminate Solutions (http:\/\/www.illuminateinc.com) today announced the release of its iLuminate correlation database technology. Testing indicates that it beats by an [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":626,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4272,4816],"tags":[4819,4812,969,1412,2172,702,4817,4807,4821,4820,4825,4824,4822,4827,4826,4818,514,4823,499,4803],"class_list":["post-3678","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-2009-year","category-illuminate-client-en","tag-analysis","tag-correlation-database","tag-data","tag-database","tag-databases","tag-erp","tag-illuminate","tag-iluminate","tag-labor-costs","tag-lowest-tco","tag-neckermann","tag-netezza","tag-optimization","tag-poc","tag-proff-of-concept","tag-raw-data","tag-tco","tag-teradata","tag-test","tag-time-to-analytics"],"_links":{"self":[{"href":"https:\/\/www.b-comm.fr\/en\/wp-json\/wp\/v2\/posts\/3678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.b-comm.fr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.b-comm.fr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.b-comm.fr\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.b-comm.fr\/en\/wp-json\/wp\/v2\/comments?post=3678"}],"version-history":[{"count":1,"href":"https:\/\/www.b-comm.fr\/en\/wp-json\/wp\/v2\/posts\/3678\/revisions"}],"predecessor-version":[{"id":3679,"href":"https:\/\/www.b-comm.fr\/en\/wp-json\/wp\/v2\/posts\/3678\/revisions\/3679"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.b-comm.fr\/en\/wp-json\/wp\/v2\/media\/626"}],"wp:attachment":[{"href":"https:\/\/www.b-comm.fr\/en\/wp-json\/wp\/v2\/media?parent=3678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.b-comm.fr\/en\/wp-json\/wp\/v2\/categories?post=3678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.b-comm.fr\/en\/wp-json\/wp\/v2\/tags?post=3678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}