Time to rewrite DBMS, says Ingres founder
466955
Abandon SQL Database management systems (DBMS) are 20 years out of date and should be completely rewritten to reflect modern use of computers.â¦
726252
Microsoft's release of updates for database application is accompanied by rule change for use on virtual servers.
713518
InfoWorld - Ingres will take different approaches to supporting soft appliances that combine its database with applications from JasperSoft and Alfresco Software.
618882
php|architect has a new posting this morning serving as a reminder to all of those wanting to go to the International PHP Conference (and MySQL ComCon Europe 2004) - time is running out to register.
569891
Jeff Jones, director of strategy for IBM&#39;s DB2 Universal Database, says IBM is wielding affordability and automation as it prepares for battle in the new world of second-generation databases.
431270
Over on PHPMac.com there's a new article seeking to help you install PHPMyAdmin for MySQL multiuser environments.
219229
You don't bring me flowers anymore International florist FTD is calling on fellow Oracle users to switch database vendors. It dumped the company in favor of EnterpriseDB in its latest project, after meeting with "indifference" from the enterprise giant.â¦
200433
An enhanced multi-threaded syslogd, supporting reliable syslog over TCP and RFC 3195, writing to MySQL databases, fully configurable output formats (with great timestamps), ability to filter on anything, and on-the-wire message compression.   Hi all,  Rsyslog 3.11.2 has just been released. Now it has the ability to convert text files into syslog. This is done by the imfile plugin, which monitors text files. A new libdbi-based output plugin has been written. This adds six additional databases (including Firebird and Oracle) to the supported database set. Also contains small bug fixes. Version 3.11.2 is a recommended release for all version 3 users.  Doc for new Modules:    http://www.rsyslog.com/doc-omlibdbi.html    http://www.rsyslog.com/doc-imfile.html  Changelog:    http://www.rsyslog.com/Article175.phtml  Download:    http://www.rsyslog.com/Downloads-req-getit-lid-79.phtml  I hope this release is useful. As always, feedback is appreciated.  Best regards, Rainer Gerhards
675185
In a new entry on his blog today, Marco Tabini introduces us to 5 PHP Performance Tips that we "probably don't want to hear".   I thought it might be interesting to write an article about the performance-enhancing tips you probably don't want to hear about - that is, those that are most likely to produce measurable (and durable) results but do require some effort on your part.   His list consists of:  You Don't Need To Plan Ahead In Order To Have A Plan Combat Database Abuse Do You Really Need A Database Anyway? Scale Horizontally Refactor To Scale Vertically  For each, he explains the title and gives a bit of validation to the point. There's some great mentions of tools that you can use to help accomplish them too - a profiler, the Lucene and Xapian full-text databases, and Lustre.
607777
Sometimes developers just don't think about how much trouble they'd cause with a rewrite of existing software. They think that moving up to the latest and greatest is the way to go, and that it makes perfect sense to say out with the old and in with the new. Aaron Wormus disagrees. Well, sometimes - it depends on the circumstances, really.   At ZendCon I talked about "Planning a PHP 4 to PHP 5 codebase rewrite, a practical approach". The talk was based on my own experience, as well as famous discussion of the topic such as Joel Spolsky's "Things you should never do" and the examination of "famous" platform rewrites.   Aaron gives an example of a large company making a move from a COBOL system out to C for a mission critical system. Based on his tale, they didn't put the thought needed into making this move - new development time, keeping old developers on staff, etc - besides the fact that customers don't like change and making a move to another platform is almost definitely going to be noticed by them.
313418
As strange as it may sound, in some cases, it may be possible to avoid database recovery entirely. You might even question the wisdom of building enormous monolithic databases. There are a growing number of examples of application environments that employ an architecture consisting of multiple smaller databases with a common parallel query layer, making protection as well as scalability easier.
670884
Why a standard single-file SQL format is necessary and how SQLite can get us there.
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
579125
On the Windows Skills blog, there's a new post that talks about the use of a SQLite database (via PHP) to handle the assault that Digg.com can dish out to a popular webiste.   Physical memory was limited and Apache and MySQL soon started to fight for every remaining byte and eventually the page was unavailable. After this experience I started to look for a alternative for the database storage and I found an interesting one: SQLite.   He mentions some of the features the database has including zero-configuration, a simple API, and the portability of having a single database in a single file. The next step was getting it to work with his Apache/PHP5 installation and to run some statistics on it. The results show SQLite pulling ahead of MySQL (INNODB) by a bit and MySQL (MYISAM) by a good bit.
319681
(InfoWorld) - Open-source database vendor Ingres Corp. Wednesday named Infor Global Solutions as its first ERP (enterprise resource planning) partner since Ingres spun off from CA Inc. more than a year ago. Roger Burkhardt, president and chief operating officer at Ingres, positioned the move as signaling "the first step" in what he said will be a burgeoning relationship with Infor. The partnership is not exclusive and he also expects Ingres to strike similar relationships with other enterprise applications players, with a particular focus on meeting the needs of different vertical industries. Ingres represents an alternative to other databases in the market, including those from proprietary relational players Oracle Corp. and Microsoft Corp., which also have their own applications businesses. Open-source vendor Ingres has no intention of buying an ERP company and so doesn't present a competitive threat to potential applications partners, Burkhardt said. Ingres and Infor are collaborating on developing open-source software to run on the Ingres 2006 open-source database and Ingres Enterprise Access middleware, which is currently a proprietary-source product. Infor is in the process of certifying its Adage ERP software, targeted at process manufacturers to run on both Ingres' database and middleware. Ingres has a long-standing relationship with Infor and the previous owner of Adage, SCT, according to Burkhardt. Initially known as Agilysis, Infor came into being in June 2002 when its private equity backer Golden Gate Capital bought SCT's processing manufacturing and distribution division. In other company news, Ingres is close to releasing its first new product as an independent company. Currently known asÂ Project Icebreaker, the new product is a combination of the Ingres database with a version ofÂ rPath's distribution of the Linux operating system. The software's aim is to decrease the amount of time users have to spend on IT maintenance work by delivering patches and updates for both the database and OS in a single maintenance stream. "Project Icebreaker is on target," Burkhardt said. "We're getting good feedback from our beta testers." He expects Project Icebreaker to become generally available early in 2007, he added. Though still in beta testing, the new offering has already led Ingres into new customer opportunities, Burkhardt said. The vendor's hearing a lot of interest from companies keen to build additional functionality on top of Project Icebreaker and the concept is also getting plenty of play with SAAS (software-as-a-service) providers, he added. Burkhardt joined Ingres in July from the New York Stock Exchange (NYSE) where he spent six years as chief technology officer. He has welcomed the freedom of working at a privately funded company unfettered by government regulations. By contrast, at the NYSE, "We couldn't even dismantle a product that had failed without a sign-off from Washington," he quipped. Â
515520
"Stinger" update of DB2 will focus on automatic administration and an improvement in clustered performance.
524773
InfoWorld - Ingres began offering a software bundle on Wednesday&#160;to make it easier for developers to build Eclipse-based applications on top of the Ingres 2006 open-source database.