SQL/XML and Information Retrieval

 

Research ] News ] Videos ] Security ] Data Access ] Server Watch ] Education ] About ]

Fast, reliable data access for ODBC, JDBC, ADO.NET and XML
Predictive Analytics World 2009, San Francisco
Need an expert for Java, XML and Web Services projects?
88x31 CTIX Logo - Clear Background
Got SOX compliance?
Movielink Logo 88x31
IBM eserver xSeries 306m 8849 - P4 3.4 GHz
Memory
PROLIANT BL20P G3 XEON 3.6G 2P
iTunes Logo 88x31-1

 


News, Spotlight (RSS 2.0) SQL/XML news RSS feed logo Add to My Yahoo!  
Video Programs (RSS 2.0) (Media RSS) Webcast and podcast RSS feed logo Add to My Yahoo!  
MP3 audio (MP3) / podcasts (RSS 2.0) Tech Talk RSS feed logo Add to My Yahoo!  

Spotlight

Fortinet Updates FortiDB Database Security Appliances
Fortinet, a provider of unified threat management solutions, announced new features of its FortiDB™ database security appliance. The appliance now provides 24x7 monitoring and provides a complete audit trail, enabling organizations to comply with the Payment Card Industry-Data Security Standard (PCI-DSS).
 

Videos Explore Cloud Computing, Business Intelligence, Service Modeling, WADL, XQuery, ADO.NET and Data Services
Videos, slides and podcasts of recent conference presentations have been published for on-demand playback on the World Wide Web. Videos recorded at DataServices World in New York and San Jose feature speakers such as Geoff Brown (m2mi), Dr. Michael Carey (University of California, Irvine), Peter Coffee (salesforce.com), Dr. Stefanos Damianakis (Netrics), Parand Darugar (Yahoo!), Mike Gorman (Whitemarsh), Mark Hapner (Sun Microsystems), Dr. Carlo Innocenti (DataDirect), Susan Malaika (IBM), Ken North (KNComputing), Dr. William O'Connell (IBM), Mike Pizzo (Microsoft), Tom Tague (Thomson Reuters) and Jeff Vroom (Adobe). The videos are  available for media players that support the Flash, Windows Media, MP4 and QuickTime formats, as well as 3GP for mobile phones.

ITTIA Announces ITTIA DB-SQL for Embedded Applications
ITTIA announced ITTIA DB-SQL, a database manager for the i.MX family of processors for Freescale Semiconductor.  i.MX processors and ITTIA SB-SQL support the Linux and Microsoft Windows CE platforms.
 

Predictive Analytics World Set to Run February 18-19, 2009 in San Francisco
Conference Chair Eric Siegel, PhD has announced the agenda for Predictive Analytics World. The inaugural event features a lineup of 20 speakers and a program that includes case studies from leading enterprises. The conference will run February 18-19, 2009 at the Hotel Nikko in San Francisco.

Continuent Announces Tungsten Database Scale-Out Stack
Continuent has released Continuent Tungsten to advanced scalability and data replication capabilities. The Tungsten ScaleOut stack includes components for replication, cluster services management and performance testing. Continuent Tungsten's replication capabilities support distributing data for scalability and performance. Tungsten also supports cross-site clustering for disaster recovery.

Updates to SQLSummit.com Driver Catalogs
SQLSummit.com continues to provide the most comprehensive catalog of database drivers, providers and XQuery engines. There have been recent additions to the list of JDBC drivers, ODBC drivers, ADO.NET Data Providers and IBM DB2 Extenders.

Navigation and XPath Holding Back the SQL/XML Database Industry
Michael M. David discusses flaws in the implementation of XML support for modern databases. He explores limitations imposed by single-leg, linear hierarchical processing, an approach used with XPath navigation of document content. He discusses global views, multi-leg queries and using hierarchical semantics to increase data value. Michael illustrates with examples of non-procedural processing using a hierarchical XML processor.

Middleware Under a Microscope in White Paper
A 90-page white paper from Ken North Computing, LLC discusses the role and importance of data access middleware. "Middleware in Action: Industrial Strength Data Access " describes how middleware plugs into architectures for distributed applications and services, including SOA and ESB. It explains defining characteristics of best-of-breed data access middleware, including features for performance and scalability. The report, and a separate executive summary (HTML ), provide a features checklist for compiling a report card for database drivers and data providers.

1968 Survey of Database Systems Uncovered
A cache of documents in a URS Project-70 folder has prompted Ken North to write about first-generation database technology. His report includes the CODASYL database systems survey of September 1968.

Reshaping and Restructuring XML
Michael M. David returns to SQLSummit.com to explore two approaches to transforming XML hierarchical data structures. He explains the difference between restructuring and reshaping XML data, with the latter driven by the semantics of the data structure.

Eclipse, Wiki and Agile Development
In an exclusive podcast interview, Ward Cunningham discusses the Eclipse Foundation, his EclipseCon 2006 keynote presentation and collaborative software development. The podcast / audio interview runs 20 minutes.

Moving Beyond Java
This WebServicesSummit.com interview with Bruce Tate explores why new programming languages are gaining favor with the database developer community. Bruce observes that developers are abandoning Java in favor of lightweight solutions for creating web applications. He discusses the Spring framework, Ruby on Rails and issues related to application development frameworks.

Security Flaws Undermine Database, E-Mail and Networking Infrastructure
Researchers have recently uncovered security vulnerabilities in the OpenSSL toolkit that's deployed on 60% of the web servers on the Internet. The potential problems include buffer overruns, denial-of-security attacks, forging of digital certificates and compromising of confidential information. Ken North discusses these OpenSSL vulnerabilities, recent research about an RSA attack based on Simple Branch Prediction Analysis, and the effect on digital certificates used for authentication and secure communications.

XML in Focus
The latest release of IBM DB2 adds an XML type, new indexing methods and other capabilities for operating with XML in databases. Ken North takes a look at DB2 pureXML technology and implications for SOA, web services and content processing.

CWD4ALL for Modeling SQL and Multidimensional Data
CWD4ALL for SQL Developer is the latest edition of Ikan Group's CWD4ALL data modeling tool. It enables DBAs and developers to use entity attribute relationship modeling to create models. The product supports reverse engineering and modeling for SQL and OLAP databases.

Open Source BI Poised for Great Leap Forward
The availability of open source business intelligence (BI) software has improved dramatically in the past two years. A recent survey by Ventana Research reports surprising levels of adoption and plans for open source BI. In this article about open source BI software, Ken North discusses trends, LAMP, Eclipse and what's available from open source BI projects.


News SQLSummit.com XML News Feed  SQLSummit.com News Feed (RSS 2.0)       

EnterpriseDB Raises $10 Million from IBM and Other Investors
EnterpriseDB has raised $10 million in series C financing from IBM, Charles Rivers Ventures, Fidelity Ventures and Valhalla Partners. EnterpriseDB offers services for PostgreSQL, a version known as Postgres Plus, and PostgreSQL Plus Advanced Server for Linux and AIX.

LogiXML Adds ETL Tool to Web-Based BI Product Line
LogiXML, Inc. release of LogiETL, an extract, transform and load tool for putting enterprise data into a consistent format to support integration with a variety of applications. LogiETL is a Web-based data integration tool that can transfer data from disparate sources, including SQL databases, web services, Excel and XML files, RSS/ATOM feeds, Amazon SimpleDB, Google Docs, and Google Spreadsheets.

Sun UltraSPARC Processor's Transactional Memory to Revolutionize Database Servers
Sun Microsystems plans to ship a new UltraSPARC processor, code-named Rock, that will introduce transactional memory. By supporting atomic transactions, it promises to reduce bottlenecks in database servers. Ken North take a closer look at Rock transaction processing and database price/performance.

Sun Microsystems Acquires MySQL for $1 Billion
In a deal Sun CEO Jonathan Schwartz described as the "most important acquisition in the company's history", Sun Microsystems is acquiring the open-source database company MySQL AB. Ken North takes a closer look at the MySQL acquisition, and past acquisitions of database companies.
 

IBM Acquires Solid Information Technology and SolidDB In-Memory Database
IBM has reached an agreement to acquire Solid Information Technology, the in-memory database company. Annual revenues for Solid are not a compelling reason for buying the company, but Solid has a transactional storage engine certified for MySQL. SolidDB is a prime competitor of the TimesTen in-memory database product acquired by Oracle.

Fast, reliable data access for ODBC, JDBC, ADO.NET and XML

More news from SQLSummit.com

Security

SQL injection, buffer overruns, and process injection are serious problems. CIOs, CTOs, system architects, developers, and DBAs need to be aware of the threats. Try our security topic for news,  alerts, more information and a list of helpful resources.

SQL Injection Vulnerability with JBoss Seam
Secunia has issued an advisory for JBoss Seam users that warns of an SQL injection vulnerability. The org.jboss.seam.framework.Query class has a flaw that enables a malicious user to exploit the "order" parameter of the getRenderedEjbql() method. Input to the parameter is not properly sanitized to prevent SQL injection attacks. The vulnerability affects JBoss Seam versions before 2.0.0 GA.

MySQL Denial of Service Vulnerability with InnoDB Engine
MySQL installations using the InnoDB engine are vulnerable to denial of service (DoS) attacks by malicious users. The problem is a function in ha_innodb.cc that can trigger an assertion error by the InnoDB engine and crash the server. The vulnerability affects MySQL 4.1.20, 5.0.44 and 5.1.17.

Authentication Vulnerability Affects DB2 9.1
An IBM DB2 9.1 security vulnerability can be exploited to trigger memory corruption or launch a denial of service attack. IBM has released DB2 9.1 fix pack 3a that corrects the problem.

Oracle Employee Arrest for Terrorism Heightens IT Globalization Concerns
Anti-terrorist police in India have arrested an Oracle employee as a member of the LeT terrorist organization and a suspect in recent Mumbai train bombings. The LeT terrorist arrest is one of a series of events, including the HSBC call center fraud and the MphasiS/Citibank scandal, that have marred the IT industry march to globalization.

SSL Auditing, Security Taxonomy
Kevin Dick discusses a security taxonomy of distributed systems in a podcast and video programs released by WebServicesSummit.com. Kevin is CEO of Network Resonance, the company that recently patented a secure SSL auditing technology (more).

At an SDSIC web services conference, a panel of experts discussed security. Topics included browser vulnerabilities, XML injection, SQL injection, and security problems related to federated identities. Presentations and interviews recorded at the conference discuss security issues.

Webcasts and Mobile Video

Michael Rys (Microsoft) discusses SQL Server 2005 (Yukon), XQuery and SQL:2003.

Blake Dournaee (Sarvega) discusses XML security and gateways

Gord Watts (GridIron Software) discusses application acceleration with grids

Elliottte Rusty Harold discusses the future of Java and XML. 

Rebecca Dias (Microsoft) discusses advanced web services

Jim Melton (Oracle) discusses the future of SQL/XML

Dana Florescu  discusses XQuery

Video screen on Palm Zire 72

Featured Links

Platform-Neutral Solution to Native XML Integration with SQL
IBM, Microsoft and Oracle have taken the SQL:2003 path to integrating native XML with SQL. Michael M. David presents an alternative approach to hierarchical processing for any SQL DBMS that implements the 1992 or 1999 SQL standard. He explains platform-neutral XML integration using left outer join, lowest common ancestor and sorted outer union techniques (more).

SQL/XML
WebServicesSummit.com released two (MP3 audio) podcasts of an expert panel discussion featuring Ron Bourret (XML-DBMS), Dana Florescu (Oracle), Michael Kay (Saxonica), Jonathan Robie (DataDirect Technologies) and Michael Rys (Microsoft). The panelists discuss XQuery, SQL/XML, native XML databases and XML-enabled databases (more).

Misuse of Object-Relational Mapping
In this editorial, Shahid N. Shah discusses the current state of data modeling and the misapplication of object-relational modeling. He's writing about information technology in the healthcare industry, but his commentary is valid for other segments (more).

Database Developer: MySQL Ready for Prime Time
A decade of development has moved MySQL out of the bare-bones DBMS category, enlarged its user base, and turned MySQL AB into a profitable company. MySQL 5.0, the newest version, is a great leap forward. There have been enhancements to the tool sets, storage engines, types and metadata. MySQL 5.0 includes features enterprise developers have come to expect from commercial SQL products (more).

Using Database Plug-ins with Oracle, DB2, SQL Server
An SQL database is more than a passive data container. Microsoft has announced SQL Server 2005 will embed the Common Language Runtime (CLR). Developers using IBM DB2, Oracle and Sybase can embed Java classes in databases. Read more about "Logic in the Database".

Got SOX?
Information systems are under the microscope today. Cathy Mugford of Control Consulting Corporation explains Sarbanes-Oxley compliance, controls and tools.

Data Access
There are new sources for drivers and providers on the list of .NET data providers, JDBC drivers, OLE DB Providers and XQuery Engines and ProcessorsData Access Workshop presentations about ODBC, JDBC and OLE DB.

XQuery in Five Minutes
Dana Florescu's presentation at CIDR 2005 discusses declaritivity and other characteristics.

Business Integration Journal logo "Plugging SQL and ODBC into Integration Frameworks". Interested in an open source SQL DBMS? Read about "Java, SQL, Cloudscape and Derby" in Dr. Dobb's Journal.

XQuery and SQL: Vive la Différence
This article in DB2 magazine discusses XQuery, SQL and the XQuery API for Java (XQJ).
                  Russian flag Ukraine flag Cyrillic translation       United Kingdom flag USA flag DB2 original

Now available: Updated ODBC driver, JDBC driver, .NET data provider lists.

Austrian flag Germany flag Switzerland flag ODBC, JDBC und die Suche nach der Black Box
China flag Singapore flag Taiwan flag ODBC, JDBC and the Search for a Black Box

Audio and Video Content Webcast and podcast RSS feed logo

  • JP Morgenthal (Software AG) discusses integration technologies and RFID
  • Bob Bickel (JBoss, Inc.) discusses middleware, J2EE vs. .NET, Open Source, and aspect-oriented programming with Java and C#
  • John Goodson (DataDirect Technologies) discusses trends in data access middleware and query APIs for XML (XQJ).
  • Dean Guida (Infragistics) discusses trends in mobility and presentation frameworks, .NET, Microsoft Longhorn and Avalon. 
  • Clive Finkelstein discusses information engineering, portals and data warehouses
  • Interview with Thor Larholm (PivX) about security issues and vulnerabilities.
  • Interview with Dave McComb about semantics, ontologies and modeling. 
  • Interview with Peter Aiken (Virginia Commonwealth University) about DM3
  • Interview with Geoff Brown (Oracle) about grid computing
  • Interview with Ed Julson (Sun) about service-oriented architectures, web services, ebXML
  • Interview with Dr. Tushar Hazra about portals, model-driven architecture, best-of-breed software
  • Keynote at Enterprise Data Forum 2003
  • Roundtable discussion with Bob Bickel (JBoss), Dean Guida (Infragistics), John Goodson (DataDirect)

 Visit XML, Semantics and Web Services portal (WebServicesSummit.com) Visit grid computing technology portal (GridSummit.com)
 

This page was last updated on 07-Feb-2009.
© 2009, North Summit Media. All rights reserved.

This article (Adobe PDF) discusses the characteristics of industrial-strength middleware for database access.

 

   

This white paper (Adobe PDF) discusses the role and importance of middleware for accessing SQL databases.