Database Management
Relational Database Management Systems (RDBMSs) continue to do the heavy lifting in data management, while newer database management systems are taking on prominent roles as well. NoSQL database systems such as Key-Value, Column Family, Graph, and Document databases, are gaining acceptance due to their ability to handle unstructured and semi-structured data. MultiValue, sometimes called the fifth NoSQL database, is also a well-established database management technology which continues to evolve to address new enterprise requirements.
Database Management Articles
Altova, creator of XMLSpy, the industry-leading XML editor, announced the availability of Version 2009 of the Altova MissionKit, an integrated suite of XML, database, data integration, and UML tools.
Posted February 10, 2009
Occasionally the database under design becomes more than a one-off project. For example, the data mart or data warehouse might act as a profit center for the organization, and as a solution sold to many customers. The possibility exists to capture a basic truth for a given industry in a simple universal design exactly suiting everyone. But unless the situation really qualifies as a valid "one-size-fits-all" circumstance, one needs a level of customization within the architecture.
Posted January 15, 2009
Staffing the DBA organization is not a simple matter. Several non trivial considerations must be addressed, including the size of the DBA staff and the reporting structure for the DBAs.
Posted January 15, 2009
SQL Server has supported VLDBs (very large databases) for some time now. Back in the SQL Server 2000 days, I recall hearing multi-terabyte databases were unusual but doable. Now, they are commonplace, while databases in the hundreds of terabytes inhabit the part of the map that says "there be dragons." While VLDBs are quite common on SQL Server today, highly scalable systems that can be flexibly extended in the same fashion as Oracle/RAC are less so. So, how do you design a highly available architecture for SQL Server if it's not like Oracle/RAC.
Posted January 15, 2009
Complex Event Processing is only a few years old, but it is rapidly entering the mainstream in a large number of fields that require continuous analysis of large volumes of real-time data.
Posted January 15, 2009
Database administrators are critically important contributors in modern enterprises, ensuring that key infrastructure is performing optimally in support of the organization's goals. Like employees in every department, the best DBAs are constantly seeking to increase the value of their contributions and, correspondingly, to increase their compensation and to advance in their organizations. Increasing knowledge and skills and taking more important responsibilities are time-honored methods for career advancement. Here are 10 concrete suggestions for DBAs looking to get ahead.
Posted January 15, 2009
Netezza, a leader in data warehouse and analytic appliance, has announced its collaboration with Microsoft and the first part of its high-performance data integration strategy for Microsoft Business Intelligence As a result, according to the vendors, Microsoft customers can now take advantage of Netezza's high-speed terascale analytic capabilities and extend the value of their existing Microsoft BI investment, and Netezza customers will now have more choice through tighter integration and technology compatibility with Microsoft's SQL Server 2008.
Posted January 13, 2009
Oracle has announced world record multi-node SPECjAppServer2004 benchmark results for Oracle Fusion Middleware. The combination of Oracle WebLogic Server, a component of Oracle Fusion Middleware, together with Oracle Database 11g on mission-critical HP Integrity server blades running HP-UX 11i v3 delivered the record-breaking results.
Posted January 06, 2009