DatabaseJournal.com Staff

by Alexander Yanushkevich and Bryan Hinds Find out how to bring back manageability and responsiveness using Database Partitioning on your current ”Non-Partitioned” system. As your Data warehouse and OLTP databases explode in growth from gigabytes to terabytes, beyond any initial design and planning, the responsiveness of the database and the manageability begin to suffer. The […]

[From SearchServerVirtualization] An increasing number of VMware shops have expressed interest in migrating their Oracle applications off dedicated physical machines and onto virtual machines (VMs), but Oracle’s virtualization-unfriendly licensing and support policies don’t make the move easy. Just like any complex application, a lot of apps from the Redwood City, Calif.-based Oracle consist of database, […]

[From Builder AU] In previous versions of SQL Server, you have to create separate statements if you need to insert, update, or delete data in one table based on certain conditions in another table. With MERGE, you can include the logic for these data modifications in one statement. The article continues at http://www.builderau.com.au/program/sqlserver/soa/Using-SQL-Server-2008-s-MERGE-statement/0,339028455,339283059,00.htm

[From MySQL AB] MySQL data load and search are very important business requirements in any Windows or Internet web application development. In general, any application needs to show a result set of data and/or a single record to the end-users. In Windows applications it is very popular to show a result set of data by […]

by Alex Bubernak Oracle is always improving life for DBAs and developers with each release of the RDBMS. 10g has many new features to help troubleshoot and tune the database. Starting with 10g, Oracle has introduced Advisors. These Advisors are part of the ADDM (Automatic Database Diagnostic Monitor) and run in the background as long […]

[From internetnews.com] Oracle’s October Critical Patch Update (CPU) addresses 51 vulnerabilities spread across the company’s product portfolio, a marked improvement over last year’s update. It also introduces an update to the system it uses to score the severity of vulnerabilities. Oracle’s namesake database products, which have 27 disclosed vulnerabilities, get the majority of the 51 […]

[From MSDN] Microsoft SQL Server today announced the general availability of the SQL Server 2005 JDBC v1.2 driver release. This release continues Microsoft’s commitment to the JAVA community and non-Microsoft centric programming platforms. The driver can be found at http://msdn.microsoft.com/data/jdbc. The article continues at http://msdn.microsoft.com/data/jdbc

[From MySQL AB] London — October 16, 2007 — MySQL AB, developer of the open source database, today announced that Internet and mobile networks security provider F-Secure has signed a MySQL Enterprise Unlimited contract for extensive use of MySQL as its backend database for its security offerings. This morning’s announcement was made at the annual […]

[From SearchOracle] It would be just like Oracle to try and outbid SAP for business intelligence (BI) software maker Business Objects — but SAP executives are hoping that it just doesn’t happen. Their concerns are understandable given Oracle’s track record and the fact that SAP’s $6.8 billion bid for Business Objects is still subject to… […]

[From The Database Column] While preparing for a seminar course I’m giving on Data Warehousing this Fall, I reviewed the The Data Warehouse Toolkit (2nd Ed) by Ralph Kimball and Margy Ross (the Amazon.com link is here). Long considered the Bible of data warehouse design, this book offers several schema design strategies for relational database […]

[From MySQL AB] MySQL AB today announced its plans to optimize the MySQL Enterprise Server for the SAP NetWeaver platform. At the SAP TechEd ’07 event being held in Las Vegas this week, MySQL and SAP AG also announced that the sales and support of the MaxDB database will revert back to SAP, in order […]

[From MySQL AB] Many web developers view development of C programs as a bit of a black art. Development of programs in a compiled language such as C is vastly different from the development of applications in a scripting language. To familiarize more developers with the MySQL C API, we present a three-part series of […]