Data warehousing: upgrade, extend or replace?
448788
Compressed thinking The B-eye Network recently conducted a survey on behalf of Dataupia. which asked, among other things, companies whether they would consider a "rip and replace" approach to solving whatever data warehousing problems they might have. Seventy-five per cent of respondents said no.â¦
372831
Many organizations allocate large resources to implement and deploy packaged ERP, CRM and SCM applications. Now these organizations need to move away from operational efficiency gains achieved and into leveraging their data for performance management and business intelligence.
688126
Users will be able to upgrade between versions just by purchasing a new product key.
497080
IBM on September 17 will ship the first major upgrade to its DB2 Universal Database data management platform in nearly two years, focusing on functional automation, advanced clustering and Web services deployment.
363882
Migrating to the new Red Hat Enterprise Linux 5 distribution can cause things to break if youre not aware of the changes. Here are the four major new categories of upgrades you'll need to plan for.
304430
The Story: With three of the largest competitors in the field taken over by software giants, you?d think that the best days of the business intelligence market were over. You?d be wrong.[ Slideshow: 2007's top underreported tech stories ]                                                    Far from heralding the death of BI, the loss of Business Objects, Cognos and Hyperion to SAP, IBM and Oracle may well signal ?a golden age for business intelligence,? says AMR Research analyst John Hagerty.Sure, that?s a brave statement. But the BI market has never been as narrow as many people assumed. There are significant players left, including SAS, SPSS, MicroStrategy, Actuate, and dozens of smaller, often specialized, vendors. ?Go beyond the core tools of reporting and analysis and you?ll see lots of data-mining and statistical tool vendors, as well as industry-specific developers,? says IDC analyst Dan Vesset.The acquisitions of the big guys now creates space for those other companies to flourish, says Rob Tholemeier, a former industry analyst turned private investor. The same thing happened to the database market, he notes: ?There are more database companies around now than when Informix was purchased.? BI, Tholemeier says, is likely to follow the same course. ?Innovation will come from the outside [companies] as the big guys expand their scale and scope,? concurs AMR?s Hagerty. Pricing, of course, is a major concern as markets consolidate. But because the supply of BI software is still ample, given the large number of independents, buyers still have significant leverage, says Vesset ? though that could change further out, he adds. Moreover, it will take the platform vendors some time to integrate their acquisitions, both in terms of code and business process. And while that process plays out, prices aren?t likely to spike.The Bottom Line: As investor Tholmeier puts it, ?Clearing out the old-timers leaves a huge vacuum for the dozens of innovative players ready to strut their stuff. The business intelligence industry is dead. Long live BI.? That change presents both a challenge for IT to understand the new BI, and the opportunity to drive BI?s benefits to a greater portion of the company.Complete list of 2007 underreported stories: 1.? Java is becoming the new Cobol 2.? Sun Microsystems is back in the game 3.? Hackers take aim at Mac OS X 4.? There are some threats you can worry less about 5.? Companies may have found a way around H-1B visa limits 6.? Open source?s new commercial strategy 7.? End-to-end Ethernet finally arrives 8.? Blade servers arrive for the masses 9.? BI is dead; long live BI 10. Balance of power shifts to software buyers
356371
PeopleSoft wants its customers to get &quot;aggressive&quot; with software upgrades to increase efficiency and cost benefits. In the context of current corporate maneuvering in the enterprise-software world, the word takes on some extra flavor.
537120
(InfoWorld) - SAP AG is making a major change in the way it delivers ERP (enterprise resource planning) applications to customers, breaking with the traditional approach of upgrading the entire software release every 12 to 18 months. Instead, SAP committed Tuesday to keeping the current version of its ERP software, mySAP ERP 2005, in place through 2010 and providing new functionality via a steady stream of optional enhancement packages. The vendor made the announcement at its TechEd developer conference taking place in Las Vegas this week. SAP determined the new strategy in response to customer demands, according to Peter Graf, executive vice president of solution marketing for SAP. "The customer is in a dilemma," he said. "They want the least distraction to their business possible, while continually innovating in a very short time frame." Not having to upgrade entire SAP ERP applications on a regular basis and being able to choose which functionality to take on via the optional enhancement packages should help ease the pain, Graf added. MySAP 2005 will act as "a stable backbone" on top of which customers can add new functionality from SAP and its partners, Graf said. It's a very different approach from the several hundred product enhancements the vendor showcased in mySAP ERP 2005, he added. The first enhancement package is due to ship in December. It will include new functionality around talent management and financial collaboration, new composite applications, enterprise services, industry-specific capabilities and possible extensions to SAP's NetWeaver integration platform, Graf said. MySAP is based on NetWeaver. Going forward, SAP will likely issue enhancement packages once every quarter or two, with each package grouped around a particular theme. "We'll make sure we deliver them in a very focused way," Graf said. "For example, we'd say this package is all around talent management. If you want it, go for it. If you're not interested, don't use it." Other enhancement packages will includeÂ CRM (customer relationship management)Â andÂ Project Muse, a new GUI (graphical user interface) to mySAP applications developed through a partnership with Adobe Systems Inc.'s Macromedia business unit. SAP begun making mySAP ERP 2005 generally available in May at its Sapphire user conference in Orlando. So far, 200 to 300 customers are live with the latest ERP software version, Graf said, with several thousand other users live on the earlier release, mySAP 2004. SAP is hoping that users on older versions of its software, notably R/3 4.6C and 4.7, will also rapidly move to mySAP ERP 2005. While the message at Sapphire from SAP executives to its users was to adopt mySAP 2005 sooner rather than later, the message from TechEd is rather more blunt. "There's no mySAP ERP 2007. This is it. Move," Graf said. Â
479963
Do people normalise database designs in phones? Blog I was interested to read Ian Murphy's story about SQL Anywhere. Despite the availability of embedded databases, it seems to me that the database (in the DBMS sense) hasn't really come to mobile devices like phones yet. This is largely because of resource constraints - they're back in the 1970s mindset before enterprise databases really took off, using clever file systems for data storage (remember VSAM?).â¦
661620
(InfoWorld) - Managing transportation logistics is all about handling scale. As transportation management services firm Transplace added consumer goods companies such as Del Monte, Office Depot, Home Depot, Auto Zone, and DirecTV as customers, it needed to quickly bring server capacity online. Already planning a hardware refresh to support continued growth, CTO Vince Biddlecomb decided to bring in server virtualization at the same time so that he'd have a more scalable, flexible platform for that anticipated growth. Biddlecomb uses EMC VMware on his Sun servers mainly to support Oracle databases and J2EE applications on BEA's WebLogic Web server. He liked the fact that the technology was operating system- and hardware-agnostic, as his datacenter supports a range of technologies. And he found the virtualization approach to be less complex than, for example, running his Oracle databases on an IBM Power6-based System p 570 server, which he had considered initially. "We have all 12 instances sit on two logical partitions. We can configure the CPU and memory for each, and share when they are not busy," Biddlecomb says. But adopting virtualization required a deeper investment in datacenter hardware, Biddlecomb discovered, because virtualization changes the fundamental character of what is being supported. "You look at it as a pool of memory and CPUs. You just drop a couple VMs to increase capacity," he says. But treating servers as instances of capacity from a large pool of resources means that pool has to be kept available and running well. To do so, Biddlecomb discovered he needed to beef up the network I/O capabilities of the physical servers to avoid network traffic contention across the VMs sharing those ports. "We put more NICs in to them, since there is more network activity going on," he says. He also discovered he needed to beef up his SAN storage to support all the VMs that began to be created and to provide sufficient failover capacity in case of failure. "You can very quickly suck up 500GB or 1TB of storage for the VMs," Biddlecomb says. Although you no longer need storage in the servers themselves, you need more storage in the SAN, and that storage tends to be costlier. The more fine-grained your servers, the more storage you need, Biddlecomb notes. He likes to have more, smaller virtual servers so that each has a specific purpose that lets it be added or deleted easily without worrying about other applications that could be affected. But with 20GB of overhead for each virtual server, that approach can quickly eat up storage. Altogether, the use of virtualization roughly doubles the cost of a physical server, Biddlecomb says. He spends about $12,000 for a Dell server with extra NICs, plus $6,000 for VMware, and $5,000 for the associated enterprise storage. Because he had already planned to replace all his servers, there was no additional sticker shock from the fact that all physical servers needed CPUs from the same family, but most enterprises would require a complete server refresh. "You need to commit to building that infrastructure," he says. Biddlecomb also notes that the CPU-family restriction will limit how he can deploy virtualization in the future, and force him to forgo incremental technology improvements until the next server refresh. He's already been forced to do so: "We'll stick with our Intel servers even though the AMD [Barcelona-class Opteron] servers look to be better for memory management." One way he will work around that limitation in the future is to put physical servers into one of two clusters, one inside the DMZ and one outside. That way, he can stage his hardware refreshes by cluster, rather than do everything at once. Ultimately, Biddlecomb sees the use of virtualization as cost-neutral when it comes to the hardware side. "But you get a large savings in administration," he says. He has about 120 virtual servers spread out over 30 servers, administered by just two people. Virtualization special report Case study: Credit Suisse Case study: Nationwide Insurance Case study: Purdue University Case study: Stonebridge Bank
207362
IBM rolls out a new version of its database software aimed at users of Linux and Unix. Also: Toyota and Nissan join to standardize car electronics & hellip;. Nokia launches three new camera phones & hellip;. and more.
273030
Business Objects, an SAP company, unveiled today the next iteration of its business intelligence platform, XI 3.0.Bigger and in some ways better than previous versions, it includes so many features that it may be a bit daunting to some users.Leveraging Business Objects' acquisition of InXight Software in May 2007, XI 3.0 ties together structured information with unstructured information."Now you can read through e-mails, Web pages, and documents to understand text and extract sentiment from text," said Franz Aman, vice president for business intelligence platform, product marketing at Business Objects.Josh Greenbaum, principal at Enterprise Applications Consulting, called the ability to include unstructured data a significant improvement in the platform. "It is an acknowledgement that data comes from all kinds of applications and all kinds of formats," he said.The technology parses and organizes unstructured data so that users can apply more traditional, i.e. more statistically-oriented, methods to the data.Greenbaum said that although it is a "somewhat artificial" structure, it does lend itself to data analysis, and he called that an enormous improvement for businesses that have grown so much more complex over the years. "ERP used to be about one activity, closing the books every quarter," he saidTraceability is another key feature in XI 3.0. The technology can trace back the so-called lineage of data in order to give users better insight into how the data was created, what transformation it might have gone through, and whether or not is was merged with another data set.While knowing the lineage of data is a must-have for regulatory and compliance, it is also essential to good business, said Greenbaum, noting that it is a vast improvement over the old days when executives sat around arguing over the data in a single cell in a spreadsheet.The lineage capability is only available to those who buy the optional Business Objects Data Services that combine Data Integrator and Data Quality components.Another significant improvement in the platform is a technology dubbed Polestar that gives non-technical users the ability to do complex searches and to make natural language queries. "You don't have to be a special user with SQL knowledge to find information," said Aman.??However, Greenbaum said that while XI does a good job in elevating the accessibility and comprehensiveness of BI it is also a "bit of a Swiss Army knife." "What haven't they put into this product?" he wondered.Nevertheless, it should also replace all the departmental one-off solutions that are typically floating around a company, according to Greenbaum.While XI 3.0 was in development long before Business Objects was acquired by SAP in January 2007, there are some unique linkages between XI 3.0 and SAP applications, said Aman. For example, XI is more tightly intertwined with the SAP Business Warehouse and offers faster performance when users tap into data that comes from R3 or the Warehouse than if the data was from a non-SAP source.Also, XI can tap into SAP's use of metadata so that if a user in North America searches for Total Revenue, and a user in France is looking for the same information, despite the fact that the French use a phrase other than Total Revenue, both will get back the same information because of the metadata layer.Business Objects 3.0 will be available later in the first quarter. Later in the year, it will also be available as a SaaS offering.
144070
The software maker is in the midst of a major revamp to its search product. Over the coming weeks, the company will make more changes, including to the engine itself. Whether the changes add up to more eyeballs is an open question.
341241
That's Multi-Dimensional eXpressions to you, guv Since when did application developers need to know about an analytical querying language like MDX? Since February 27th, next year. Thatâs when Microsoft will launch SQL Server 2008. Of course, youâll still have breathing space because, as we are painfully aware, launching and actually delivering products are, in Microsoftâs world, now completely different eventsâ¦..â¦
560877
Adam Bosworth complains  about the current lack of quality and scalable databases in our industry.  "About five years ago I started to notice an odd thing. The products that the database vendors were building had less and less to do with what the customers wanted."  "It is this. Users of databases tend to ask for three very simple things:"  "1) Dynamic schema so that as the business model/description of goods or    services changes and evolves, this evolution can be handled seamlessly in a    system running 24 by 7, 365 days a year ..."  "2) Dynamic partitioning of data across large dynamic numbers of machines. A    lot people people track a lot of data these days. ..."  "3) Modern indexing. ...
574333
Letter Can collective database licensing cure this tragedy of the commons?
9867
PC Magazine - The open-source embeddable database now boasts multi-version concurrency control, no-downtime upgrades and a pre-built replication framework to simplify development of highly available applications.