Database management system DBMS architecture design and strategy
- July 14, 2008
Selecting a new database? Don't base choices on outdated preconceptions or superfluous criteria. Learn how to avoid common "worst practices" when choosing a database engine.
- February 28, 2008
In an interview, IDC database analyst Carl Olofson offers his analysis of recent developments involving IBM's DB2 software along with predictions of what's coming next.
- December 11, 2007
Putting together a comprehensive data migration plan now can help firms avoid serious downtime later, according to experts.
- December 04, 2007
Data migration processes are slowly evolving from hand-coded scripts toward packaged applications. Find out why more companies are using tools for data migration.
- October 23, 2007
Gartner's data warehouse DBMS Magic Quadrant 2007 includes familiar names offering new technologies that meet the demands of old IT mantras.
- August 03, 2007
IBM today announced plans to buy Princeton Softech -- which makes data management, archiving and classification software -- to bolster its Information on Demand initiative.
- May 30, 2007
IBM's DB2 9 Viper can manage XML and relational data in one database. An analyst says IBM's architecture is unique -- and that other vendors might not appreciate the challenge.
- December 19, 2006
Data management skills are in demand, but inconsistent job titles and descriptions can make finding data management jobs tough. Learn what employers seek and how DAMA may help.
- December 14, 2006
Oracle's Database 11g enhancements focus on XML DB and include a new binary XML data type, a new XML index and enhanced support for XQuery and other emerging standards
- September 28, 2006
The new version of Berkeley DB, the embeddable database Oracle acquired along with open source stalwart Sleepycat Software, promises better performance and the ability to do upgrades on the fly. But does Oracle really have open source street ...
- September 25, 2006
Gartner's new Magic Quadrant for data warehouse software and DBMS systems finds that mixed workloads, new appliances and pricing pressures are all affecting the market.
- August 10, 2006
Restoring your SQL Server 7.0 or 2000 machine to 2005 may be fairly straightforward. Restoring an earlier version is another story entirely. Edgewood Solutions' Greg Robidoux explains how to restore an older database to a new SQL Server 2005.
- August 02, 2006
Write and run SQL Server stored procedures more effectively. This collection of FAQs will start you on the path to working with useful T-SQL routines.
- August 02, 2006
Discover syntax differences between SQL Server and MySQL, code for a timestamp automation workaround and why it's important to keep your version of MySQL current.
- August 01, 2006
SQL Server 2005 index partitioning allows you to distribute the load for a given index across multiple files to improve performance. Contributor Serdar Yegulalp explains how it differs from SQL Server 2000 partition views and how to create an index ...