Newsletters




Business Intelligence and Analytics

The world of Business Intelligence and Analytics is evolving quickly. Increasingly, the emphasis is on real-time Business Intelligence to enable faster decision making, and on Data Visualization, which enables data patterns to be seen more clearly. Key technologies involved in preparing raw data to be used for Business Intelligence, Reporting and Analytics – including ETL (Extract, Transform, and Load), CDC (Change Data Capture), and Data Deduplication – support a wide range of goals within organizations.



Business Intelligence and Analytics Articles

jBASE International has introduced an enhancement to its jEDI Development Kit that improves the jQL performance for the entire jEDI suite. Recent benchmark results demonstrated performance levels very close to-and in some cases surpassing-native jBASE files.

Posted November 18, 2009

Integrating technology from its acquisition of GoldenGate Software into the Oracle Data Integration suite of solutions, Oracle has announced Oracle GoldenGate, which delivers low-impact real-time data integration and replication technology to Oracle Fusion Middleware and provides a comprehensive, heterogeneous data integration platform.

Posted November 17, 2009

IBM announced what it says is the world's largest private cloud computing environment for business analytics, supporting more than a petabyte of information, or the equivalent to 20 million four-drawer filing cabinets filled with text, which stacked end-to-end would circle the entire planet. The analytics cloud will be made available for both internal IBM use and as services for customers. The internal deployment for IBM employees is called Blue Insight, while the customer offering—based on a similar architecture—is called IBM Smart Analytics.

Posted November 17, 2009

SharePoint360 recently announced that it has been accepted into a Microsoft early adoption program for new upcoming business intelligence products. While early adoption programs span many technologies and generally only engage Microsoft customers, SharePoint360 says it was selected as a result of its work in highlighting Microsoft SQL Server 2008 R2 within Microsoft SharePoint Server.

Posted November 17, 2009

Panorama Software, a provider of proactive Business Intelligence (BI) solutions, has announced its plans for the next release of its flagship product suite NovaView. Panorama's next release will extend its Microsoft SQL Server Analysis Services support to natively support Microsoft's new PowerPivot technology (formerly known as Project Gemini). SQL Server Analysis Services (SSAS) is Microsoft's online analytical processing (OLAP) technology, and PowerPivot is the name for Microsoft's next major update to SSAS.

Posted November 17, 2009

IBM announced what its says is the world's largest private cloud computing environment for business analytics, supporting more than a petabyte of information, or the equivalent to 20 million four-drawer filing cabinets filled with text, which stacked end-to-end would circle the entire planet. The analytics cloud will be made available for both internal IBM use and as services for customers. The internal deployment for IBM employees is called Blue Insight, while the customer offering—based on a similar architecture—is called IBM Smart Analytics.

Posted November 16, 2009

Southeast Community College is using Informer, decreasing the time required for data evaluation and collection, Entrinsik has announced. Using Informer, time required for data evaluation and collection decreased dramatically and Southeast was able to create one record with all the required elements and then export to an Excel macro file for additional data manipulation, much of which can now be done using the "Add Calculations" feature of Informer 4.0. "The whole process from start to upload is now just a few minutes compared to an hour previously," notes Duane Roth, IT programmer/analyst, at the college.

Posted November 11, 2009

Informatica today announced version 9 of its data integration platform with the theme of "Enabling the Data-Driven Enterprise." The Informatica platform is a comprehensive offering that provides for enterprise data integration, cloud data integration, B2B data exchange, and data quality across the whole enterprise. Major new features in version 9 of the platform focus on the areas of SOA-based data services, pervasive data quality, and Business-IT collaboration.

Posted November 10, 2009

Quest Software announced two significant product releases in the SQL Server performance management space at PASS Summit last week in Seattle. The latest release of Spotlight on SQL Server Enterprise, Quest's monitoring and diagnostics tool, now featuring business intelligence monitoring, coupled with the debut of Foglight for SQL Server, enables database administrators to proactively detect, diagnose and resolve SQL Server performance issues.

Posted November 10, 2009

Aster Data, a provider of data warehousing solutions for "big data" applications, yesterday announced Aster Data Version 4.0, which the company describes as the industry's first "Massively Parallel Data-Application Server." Aster Data 4.0 allows companies to embed applications inside Aster Data's MPP (massively parallel processing) data warehouse, so businesses can now store, analyze and speed processing of terabytes to petabytes of data. The ability to push applications down into the MPP database also opens a new opportunity for companies to deliver new interactive, big data applications.

Posted November 03, 2009

Attunity, a provider of real-time data integration and event capture software, has introduced a suite of Operational Data Replication (ODR) solutions integrated with Microsoft SQL Server Integration Services (SSIS) which is designed to enable customers to replicate data in real-time across a set of heterogeneous data sources at an affordable price point. The solutions are designed to enhance business intelligence, improve business operations, and reduce total costs.

Posted November 03, 2009

IBM recently announced new business analytics offerings designed to help clients better manage and control their unstructured and structured data in a unified manner, while providing valuable insight into their content across the enterprise. The volume of unstructured data found on websites and social networking sites, in digital files, portals, databases and customer comments, is increasing exponentially. Typically, organizations manage this unstructured information separately from their structured data found in applications and databases. By compiling and analyzing both structured and unstructured information, organizations can garner business insights from unlimited volumes of text from emails, documents, blogs, wikis and websites and change the way they do business.

Posted November 03, 2009

IBM announced an expansion of its enterprise mashup portfolio that incorporates the latest version of IBM Mashup Center and a new offering called IBM Cognos 8 Mashup Service.

Posted November 02, 2009

Sybase, Inc. last week reported financial results for the third quarter ended September 30, 2009. "The team continued to execute very well and enabled us to deliver our best-ever third quarter results in the company history," John Chen, chairman, CEO and president of Sybase, said during an earnings call announcing the results. The company achieved third quarter records in total revenue, operating income, operating margin, net income, EPS, and cash flow from operations.

Posted October 29, 2009

Noetix Corp., a software provider that automatically generates business intelligence content from enterprise applications, recently introduced Noetix Analytics for Oracle E-Business Suite, a packaged analytics solution that greatly speeds the process of implementing a data warehouse. Noetix has been providing content for real-time reporting for Oracle applications for 15 years, and the addition of packaged analytics now enables them to deliver an end-to-end business intelligence solution for Oracle applications.

Posted October 28, 2009

Johnstone Supply is the leading cooperative wholesale distributor of brand-name products, expert technical knowledge and superior customer service to the Heating, Ventilation, and Air Conditioning and Refrigeration (HVACR) industry, with more than 340 locally owned and operated stores nationwide.

Posted October 28, 2009

Southeast Community College is using Informer, decreasing the time required for data evaluation and collection, Entrinsik has announced.

Posted October 28, 2009

David Roper has been named vice president of sales at Kore Technologies. Kore provides a range of professional services and applications for the Rocket Software U2 and Microsoft SQL Server databases. Key products include KommerceServer, an advanced framework for building e-commerce web solutions, and Kourier Integrator, an application designed for system integration and business automation.

Posted October 28, 2009

Just days after Rocket Software completed the purchase of the UniData and UniVerse Servers and Tools assets from IBM, Susie Siegesmund, now vice president and general manager for the U2 brand under Rocket, took time to talk about why the timing was right for this move and what customers and partners can expect under the new ownership. Here, some excerpts from that interview. Read the full interview in the December issue of Database Trends and Applications.

Posted October 28, 2009

Endeca Technologies, Inc., a search applications software company, announced that it will OEM PowerCenter and PowerExchange from Informatica Corporation, and that it has expanded its relationship with SAP Business Objects. Endeca will integrate Informatica's PowerCenter and PowerExchange with its Information Access Platform for improved enterprise search, and will integrate SAP Business Object's Xcelsius software and Intelligent Search software for faster and easier deployment of search applications and query federation inside the enterprise.

Posted October 27, 2009

Attunity Ltd., a provider of real-time data integration and event data capture software, introduced a set of solutions based on a new concept coined ‘Operational Data Replication' (ODR), designed to enable the large market of Oracle customers to replicate data in real-time to and from Oracle databases, at an affordable price point. The solutions, designed to enhance business intelligence (BI), improve business operations and reduce total costs, were presented at last week's Oracle Open World conference.

Posted October 21, 2009

Yesterday marked the beginning of the annual Teradata Partners User Group conference with a flurry of announcements from the enterprise data warehousing leader focused on new product innovations and partner developments. "Information is power, but intelligence is transformative," James Vollmer, president of the Partners steering committee, announced to a buzzing room after stepping out of a custom Teradata-orange muscle car during the opening keynote.

Posted October 20, 2009

Noetix Corp., a software provider that automatically generates business intelligence content from enterprise applications, has completed the acquisition of privately-held business analytics company, Jaros Technologies Corp., for an undisclosed sum.

Posted October 13, 2009

Aster Data, a provider of data analytics and management platforms for "big data" applications, has announced the availability of a new Aster-Hadoop Data Connector, which utilizes Aster's patent-pending SQL-MapReduce capabilities for two-way, high-speed, data transfer between Apache Hadoop and Aster Data's massively parallel data warehouse.

Posted October 13, 2009

MITS, developer of advanced reporting and business intelligence software for the MultiValue database market, has introduced version 7.1 of MITS Discover, the company's OLAP business intelligence system. This latest release includes new capabilities for increased ease of use and enhanced user productivity, as well as new database support.

Posted October 13, 2009

As my regular readers know, I am an avid reader, especially of technology books. And every now and then I review some of the more interesting database-related books in the DBA Corner column.

Posted October 13, 2009

Pentaho Corporation, a commercial open source business intelligence and data integration software vendor, has announced the acquisition of technology assets from LucidEra, a pioneer in software-as-a-service (SaaS) business intelligence. The new technology will be packaged as "Pentaho Analyzer Enterprise Edition" and extends Pentaho's capabilities to enable business users to intuitively analyze information, adding another SaaS-ready product to Pentaho's BI portfolio.

Posted October 07, 2009

Kalido, a provider of information management software for enterprise data governance, announced that the latest version of the Kalido Information Engine which will be generally available by the end of October 2009. The Kalido Information Engine is a business model-driven, best-practice based platform that can automatically feed information to end-users through their business intelligence tools. With the engine, users can quickly model business scenarios, and deliver reliable, consistent and accurate data. It includes such features as workflow, embedded data matching, a full audit trail, role-based security, and more.

Posted October 07, 2009

IBM announced the launch of its New York-based IBM Business Analytics Solution Center, part of a network of global analytics centers addressing the growing demand for the complex capabilities needed to build smarter cities and help clients optimize all manner of business processes and business decisions.

Posted October 05, 2009

Talend, a provider of data integration, ETL, and data quality software, recently announced it has acquired all rights to the master data management (MDM) technology of Amalto Technologies. As a result of this acquisition, Talend says it will be the first company to offer an open source MDM solution, providing organizations with the exact features and benefits found in proprietary MDM solutions, at a fraction of the cost. The MDM technology is a complement to Talend's open source data integration and data quality solutions, and will speed open source MDM time to market.

Posted September 29, 2009

Sybase and HCL Technologies Ltd., a global IT services provider, have formed a strategic alliance to provide customers with real time operational business intelligence. Under this new partnership, HCL will provide business-aligned IT value services around Sybase's high performance and proven data warehouse and analytics platform for improved efficiencies and decision-making across all facets of an enterprise.

Posted September 23, 2009

At the Sybase Techwave Symposium in Washington, D.C., last month, Sybase announced the availability of its data management and analytics servers, including Sybase SQL Anywhere, Sybase IQ, and Sybase Adaptive Server Enterprise, for the Amazon Elastic Compute Cloud (EC2) environment. With these products, customers will have the ability to quickly develop and deploy on-demand data systems for mobile, analytics and transactional applications.

Posted September 23, 2009

The world's first OLTP Database Machine was unveiled yesterday by Larry Ellison, CEO of Oracle, with John Fowler, Sun executive vice president, during a live webcast. "For a long time we have been working with Sun and this is the latest output of that partnership—Oracle Exadata version 2, hardware by Sun and software by Oracle," said Ellison.

Posted September 16, 2009

Quest Software has introduced a new version of Toad for Data Analysts, a multi-platform tool designed for IT and business professionals who need to quickly access, understand and report on data.

Posted September 15, 2009

IBM recently launched IBM Cognos Express, an all-in-one business intelligence and planning solution specifically built and priced for midsized clients. Deployed in just a matter of hours, the new solution offers clients a low-cost and low-risk, integrated approach to planning, analyzing and reporting performance, identifying trends, and ultimately helping them make smarter business decisions.

Posted September 15, 2009

Entrinsik, Inc., a provider of web-based operational reporting and analysis solutions, has announced the launch of the Informer Channel on YouTube. The new channel will feature video clips demonstrating features of the company's web-based reporting software used by thousands around the world.

Posted September 14, 2009

Why do business decision makers need to wait for IT to deliver performance reports on the business? Why can't they build their own reports, and gain rapid access to answer the questions they have?

Posted September 14, 2009

Microsoft SQL Server has been a favorite for years for organizations that want to implement business intelligence (BI) functionality - even in traditionally non-Microsoft shops. Especially since the SQL Server 2005 release, the ROI of a Microsoft solution coupled with the ease of implementation has driven healthy adoption of the DBMS for BI. And the integration of SQL Server 2008 with Microsoft Office, SharePoint Server, and PerformancePoint Services for delivering BI to end users has created an even stronger end-to-end platform.

Posted September 14, 2009

IT management software company CA, Inc. today announced that it has signed a definitive agreement to acquire privately held NetQoS Inc., a provider of network performance management and service delivery solutions, for $200 million.

Posted September 14, 2009

Information Builders (IBI), a provider of business intelligence (BI) solutions, announced support for IBM System z/OS computer Integrated Information Processor (zIIP) in Focus 7.6.10 and WebFocus 7.7. Information Builders says that its zIIP chip support represents the first and only BI platform optimized for the mainframe environment.

Posted September 08, 2009

Oracle Database 11g Release 2 is generally available and downloadable today from the Oracle Technology Network (OTN). Improvements have been made in all key areas, with a general emphasis on helping customers lower their IT infrastructure costs.

Posted September 01, 2009

Pentaho Corporation, a commercial open source business intelligence and data integration software vendor, has announced the release of Pentaho BI Suite Version 3.5, which includes new report and dashboard design capabilities for both business and IT users, as well as technical and packaging changes to enable broad use of Pentaho for embedded business intelligence by OEMs and SaaS providers. In addition to the new software, Pentaho is also offering a new report migration service that enables the conversion of reporting from proprietary business intelligence platforms to the lower-cost Pentaho reporting tools.

Posted September 01, 2009

Entrinsik, Inc., a provider of web-based operational reporting and analysis solutions, has announced the launch of the Informer Channel on YouTube. The new channel will feature video clips demonstrating features of the company's web-based reporting software used by thousands around the world.

Posted August 26, 2009

MicroStrategy Inc., a provider of business intelligence software, has announced that its latest product release, MicroStrategy 9, runs on the VMware virtualization platform. MicroStrategy customers can now deploy MicroStrategy 9 BI applications on VMware-based virtual machines. This will enable applications to achieve the hardware efficiencies, streamlined operations, and low cost of operation available through virtualization.

Posted August 25, 2009

InterSystems Corporation yesterday introduced technology additions to its InterSystems CACHÉ high-performance object database. Available now in CACHÉ 2009, the new features provide enhanced web services security, reporting, and system management and monitoring.

Posted August 18, 2009

RightScale, Jaspersoft, Talend and Vertica have announced an integrated solutions stack intended to enable customers to increase agility and lower costs by combining the power of the cloud, a high-performance analytical database, and BI and data integration software. RightScale is a cloud computing management provider and offers a fully automated cloud management platform that enables customers to design, deploy, and manage business-critical applications on the cloud. Vertica provides the analytical database which is based on column-structure architecture. The BI software is provided by open source BI vendor Jaspersoft, and the data integration software by open source vendor Talend. This BI stack is an example of the power of collaboration among vendors to deliver integrated solutions, and by focusing their efforts on delivering BI on the cloud, customers now have tools to help them move quickly with BI projects.

Posted August 18, 2009

Four top Microsoft SQL Server executives will present keynote addresses at the Professional Association for SQL Server's PASS Summit Unite 2009 conference, Nov. 2-5.

Posted August 18, 2009

Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 provided a much-needed equivalent to Oracle's long-standing and capable V$ and X$ system views. SQL Server 2008 has provided another dramatic improvement to its instrumentation with Extended Events (also known as XEvents) that promises to offer even greater opportunities to tune, trace and troubleshoot the inner workings of a SQL Server application. All of this stands in stark contrast with the anemic instrumentation offered in SQL Server Analysis Services, Microsoft's wonderful multi-dimensional data repository that is a free feature-set within the SQL Server product.

Posted August 14, 2009

Netezza Corporation, a provider of data warehouse and analytic appliances, has introduced the Netezza TwinFin appliance, the first in a family of new blade server-based appliances. The TwinFin appliance scales to more than a petabyte of user data and delivers significantly better performance over competing solutions. The TwinFin appliance is also priced very reasonably per terabyte, which resets the bar on price-performance in the industry.

Posted August 04, 2009

Vertica, a column-oriented analytic database technology provider, has announced a new release of its Analytic Database product with new features for performance gains, increases in scale, and advanced analytics. The primary new features consist of a next-generation column-store architecture called FlexStore, MapReduce technology for advanced ETL loading and analytical processing, and load balancing via IPVS.

Posted August 04, 2009

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82

Sponsors