(Baron Schwartz) Global transaction IDs are being considered for a future version of MySQL. A global transaction ID lets you determine a server’s replication position reliably, among other benefits. This is great when you need to switch a replica to another master, or any number of other needs.
Other News
IBM and big data: an introduction
(Philip Howard) IBM probably (almost certainly) has the largest portfolio of products spanning the big data space. It has DB2 (or Smart Analytics Systems), Netezza, Informix, Hadoop (with HDFS) and BigInsights (Hadoop with GPFS) to store the data or, if the data is too big and too fast you can use I
Using inline view to better query joined tables
(Dan Clamage) I have a table called ENTITY with columns srcID, entID, occurrence and histflag. I want to get the rows with the max value in column ‘occurrence’ for each entID. I have accomplished this with the following:
Get More Robust Access Control, Courtesy of Semantic Technology
(Jennifer Zaino) At JPMorgan Chase, application security and semantic web technology are teaming up. David C. Laurance, who works in the former area at the financial services giant, is pursuing an initiative with semantic technology vendor Clark & Parsia, and its CTO Evren Sirin, that’s focused on a
Concept of Pattern Matching in FSharp
(Alok Pandey) Pattern Matching is one of the most important tools of F Sharp programming. It allows a programmer to make different computations, depending on matching patterns. It decomposes data structures into their component parts. It is similar to a if..else or switch statement in C or C++. It a
SQL Server Denali SSIS Enhancements Part 2 of 2
(Arshad Ali) I heard there are couple of enhancements in SQL Server Denali for SSIS. What are these enhancements and how do they improves the usability, productivity, manageability and performance of SQL Server Integration Services? Learn about these items and more in this tip.
JSON Compared to XML
JSON Compared to XML XML is a much older specification and has been used for over a decade. JSON is much newer, requiring a much smaller string to define an object and the data the string contains. XML was designed to define, organize and contain data. JSON was designed to pass objects from one process to another in the form […]
Checking on the Progress of Large DML Commands in MySQL Using Perl – Part Two
(Tony Darnell) In part one, I showed you how to use a Perl script to insert a million rows of dummy data into a table. I needed a large database in order to test a Perl script that I would use to monitor the activity when running a large DML statement.
Legacy application migration best practices
(George Lawton) IT organizations have many options available for using improvements in new hardware, software and services to either speed legacy applications, save money, or both. One transitional strategy has been to simply wrapper Web interfaces around existing legacy applications.
Grid and RAC Notes
(Hemant K Chitale) This is a place-holder for miscellaneous notes on 11gR2 Grid and RAC.