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.â¦
241556
Cody Caughlan has created a project that brings one of the popular features of Ruby on Rails to the world of PHP5 - database migrations.   One of the cool things I like about Ruby on Rails is the use of "migrations" for maintaining your DB. Migrations have proven to be pretty handy in keeping a local database in sync with the work of other developers. [...] Because migrations are incremental and they are done in a structured manner, it is a great way of pushing out new DB changes to the production database servers.   His framework, Ruckusing Migrations, is a modular framework that makes use of some of the more advanced features of PHP5. It's portable (via an adapter interface) and uses a generic task interface (task files) to load functionality into the framework. There's also plenty of API hooks to allow for a developer to easily create their own custom operations.   Check out the project homepage for more information.
557949
A tool to manage database changes and refactorings. All changes to a database are stored in XML files that are stored in version control with other source code. A graphical IDE is also available   LiquiBase 1.2 has been released. Major features include:      * Support for H2 database     * Support for InterSystems Cache` database     * Support for  change     * Improved error messages     * tag can contain a  tag     * Change log file references can be absolute     * SQL in  tag can be ; or 'go' delimited     * New clearCheckSums command in command line migrator     * Support for version 0.5 of the LiquiBase IDE and Eclipse Plugin  Many bugs have been fixed as well, including:      * Sybase support fixes     * Handle --defaultsFile correctly     * Handle command line parameters correctly on Windows systems     * Other bug fixes  Upgrading is simply a matter of replacing the liquibase.jar file. To take advantage of newer change log features, change your XSD declaration to:    Download LiquiBase 1.2 from:  http://www.liquibase.org/download.html
205560
Over the next two years network based storage virtualization will remain a niche, while thin provisioning will enjoy rapid adoption in the enterprise. And, applying network-based storage virtualization to pool arrays isn't likely to improve this environment if efficient utilization hasn't already been achieved.
283633
JasperSoft&#39;s next upgrade of its open-source business intelligence suite, due out Nov. 1, will improve the ability for users to create their own customized reports.
643578
Data no longer satisfies 'hungry' Sybase US software tools builder Sybase plans to move beyond its database roots and challenge the leaders in enterprise software development.â¦
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.
123912
This  is very interesting:  "As large MediaWiki deployments may gain performance using Memcached, at some level cost of RAM to store all objects becomes too high. In order to balance resource usage and take more use of Apache server disks, Tugela, the distributed cached on-disk hash database, has arrived."  So Tugela  is like memcached but backed by a disk-based btree.  Since most memcached installs are usually backed by MySQL we would just be duplicating some of the work that MySQL already does. Of course this is probably being a bit unfair.  There wouldn't be any locking in this situation.  I'd like to see benchmarks though.  I'm pretty sure it wouldn't be able to beat an InnoDB install.   ...
374389
TechWeb - IBM plans to fold the in-memory database vendor into its information management software division. Solid's technology can be used in speeding up business intelligence software.
61931
A handy list of rules One of the major discussion points at Bloor Research's recent conference on "Data Warehousing: the rise of the appliance" was a discussion of the rules (though they might equally be regarded as reference points rather than rules) that might apply to data warehouse appliances as opposed to enterprise data warehouses.â¦
319638
In this new tutorial on PHPBuilder.com, Ken Lin demonstrates how to import some data from an MS Access database into the most recent version of MySQL (version 5).   In this article, I will discuss whether or not to migrate your MS Access data to MySQL. Then, I will cover about the considerations, planning, and preparations which should made before migrating your data.   He follows the (good) practice of plan first, shoot later when approaching the subject. He talks about the differences between the two systems, when to and not to make the import jump, and some steps to do to prepare things for the leap.   He choses the Navicat tool to make the transition, stepping through the process the import wizard will follow to make the push much easier than a manual import/export.
110583
A look at Oracle, ParAccel and Calpont A lot has been happening on the data warehousing front lately. Earlier this summer, Oracle announced its Information Appliance initiative and, in particular, a partnership with PANTA Systems. Then, more recently, ParAccel has announced a product re-positioning, Calpont is finally talking about its entry into the market, and both DATAllegro and Netezza have announced new product releases. In this article I am going to discuss Oracle, ParAccel and Calpont (for reasons which will become obvious) while in the second part I will direct my attention towards DATAllegro and Netezza.â¦
663615
AgileWiki explores new knowledge representation. The current effort is on implementing a copy-on-write OODBMS with support for fast deep copies, b-trees, large extensible hashes, simple lists, bush structures and calendars.   CowDb is a new kind of Object Store based on Copy-On-Write technology. It supports fast deep copies, b-trees and large extensible hashes.   http://agilewiki.wiki.sourceforge.net/CowDb
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.
228023
Open-source database provider MySQL will add features aimed at simplifying management for large companies with tens or hundreds of servers, the company announced Wednesday. A final 5.1 release is in the offing.
519884
Marco Tabini (of php|architect) has posted some thoughts to his blog about the PHP4 end-of-life announcement and its relations to the current push to go PHP5 - mainly how it relates to hosting providers.   I'm sure that a large number are owners of small hosting firms - which, by far, provide the vast majority of PHP-powered websites that Netcraft carefully tracks for us - that sell cheap shared hosting. [...] If you provide shared-hosting plans, it's likely that your servers are still running PHP 4. Upgrading to PHP 5 is a logistical nightmare for two reasons: first, you don't necessarily know that you'll be able to properly set up and secure your systems; second, you don't know that your customers' applications will keep on running.   Both reasons can cause very different kinds of hassles for the hoster, especially when it comes to their customers. As Marco puts it "hell hath no fury like a customer scorned". When things are going smoothly, everything's good, but the second that you try to explain that the update is what's good for them, all they see are things breaking and freak out.   He suggests only one real solution - make the move and tell the customers now that things are changing. Help them all you can (with information about updated software and resources) but ultimately it's up to them to make the change.
496442
Should businesses replace post-mortems with âpre-mortems?â Adopt âcounterintuitive management practices?â And more...