Database and Information Retrieval Portal

 

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

Fast, reliable data access for ODBC, JDBC, ADO.NET and XML
Predictive Analytics World 2011, 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

JReport Enables Cloud Database Reporting for Database.com
Jinfonet Software has announced that it's JReport software is available as a reporting solution for users of Database.com, Saleforce.com and Force.com.

Xeround Jumps into Cloud Database Arena with Elastic MySQL Offering
Xeround has announced a MySQL-compatible database that has been adapted to provide the scalability and elasticity of cloud databases. Xeround supports auto-scaling Database_as_a_Service (DaaS) on the Amazon EC2 web service.

Data Warehouse Landscape Designates Teradata and IBM as Industry Leaders
Information Difference has produced the data warehouse landscape for Q4 2010. Vendors were ranked according to technology and market strength, which was based on breadth of partner network, data warehouse revenues, financial strength, growth, and geographic coverage.

  

Sentrigo Releases Version 4.1 of Hedgehog Enterprise Database Security Suite
Sentrigo released version 4.1 of Hedgehog Enterprise, an integrated software suite for database activity monitoring and vulnerability assessment. Version 4.1 adds support for Sybase and MySQL databases in Hedgehog DBScanner, which checks for 4,000 potential weaknesses.

Oracle Applications Available in Amazon Cloud
Amazon has announced the availability of several Oracle applications on Amazon Elastic Compute Cloud (EC2). The list of available applications includes Oracle PeopleSoft, Oracle E-Business Suite and J.D. Edwards Enterprise One software. 

Databases, Mainframes and Hardware Acceleration
Writing for the Database Blog at Dr. Dobb's, Ken North discusses hardware solutions for accelerating web services and database processing. Part II of "Specialty Hardware, Databases, Mainframes, and Service-Oriented Architecture (SOA)" discusses specialty processors, including the zIIP and zAAP, that can handle Java and XML workloads. 

Predictive Analytics World to Run March 14-15 in San Francisco
Predictive Analytics World features a lineup of 30 speakers and a program that includes two tracks with case studies from leading enterprises. The conference will run March 14-15 at the San Francisco Marriott Marquis Hotel. Post-conference workshops will run March 16 and 17, 2010.
 

Progress Software JDBC Driver for Enterprise Cloud Database from Salesforce.com
Progress Software has announced drivers for salesforce.com's database in the cloud. The JDBC driver for database.com is in beta test. An ODBC driver will be available in the second quarter of 2011.

GigaSpaces XAP Provides Cloud-Data Center Hybrid Infrastructure for Social Casino
GigaSpaces announced the first cloud-based social casino platform uses the GigaSpaces eXtreme Application Platform (XAP). Yazino has built a bridge between social gaming and online gambling that requires scalability for more than 500,000 players.

Google to Upgrade Google App Engine with Hosted SQL
Google has announced support for hosted SQL databases using Google App Engine for Business. SQL support is expected to be available by the second quarter of 2011.

Databases for Public and Private Cloud Computing
As cloud computing gained momentum, attention inevitably turned to hosting databases in the cloud. Issues such as horizontal scaling, the model best suited for public and private clouds, have prompted the development of a new generation of data stores. In "Databases in the Clouds: Elysian Fields or Briar Patch?", Ken North discusses the new data stores. He also examines cloud computing with SQL platforms, column-oriented databases, RDF stores and tuple spaces variants.

  

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.

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.

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.

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


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

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.

Ingres VectorWise Performance Boost for Analytics Sparks Interest
Ingres Corporation has expanded into Japan in a partnership with New Systems Technology. The Ingres platform has been gaining traction after being supplemented by new performance boosting technology from the VectorWise Project. It added the column-oriented MonetDB/X100 database research project. Intel provided support for the Ingres VectorWise effort that focused Intel Xeon 5500 series processors. The Ingres VectorWise database kernel optimized for the Xeon 5500 resulted in an 80X performance boost on some decision support queries.

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

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.

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.

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 Exposes Cardholder Data
The credit card information for 110,000 cardholders has been exposed in a security breach at a New York tourism company, Twin America LLC (d.b.a., City Sights NY). The company's web server, which contained payment card data, was compromised using SQL injection. In this instance, it appears poor coding practices combined with storage of cardholder data was a recipe for disaster.

Protection of Personal Identifying Data in Databases
Breaches of databases containing cardholder happen on a repetitive basis. "SQL Injection and Data Theft" discusses the issues and information from recent surveys of IT personnel.

Major Security Patch Updates from SAP and Oracle
SAP has released a major security patch update as a result of a code scan of 280 million lines of code. The update includes patches to Business Suite applications and the NetWeaver platform. Oracle released Critical Patch Updates in October and is scheduled to do the next critical patch release on January 18, 2011.

Arrest for Terrorism Heightens IT Globalization Concerns
Anti-terrorist police in India arrested a software engineer employed in the hi-tech center at Bangalore as a member of the LeT terrorist group linked to the 2006 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 the SQL:2003 standard.

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

Dana Florescu  discusses XQuery.

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.

Video screen on Palm Zire 72

Featured Links

Oracle Drops UltraSPARC Processor with Transactional Memory
Prior to the deal to be acquired by Oracle, Sun Microsystems planned to ship a new UltraSPARC processor that provides transactional memory. By supporting atomic transactions, it promised to reduce bottlenecks in database servers. Ken North take a closer look at Rock transaction processing and database price/performance. 

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 13-Feb-2011.
© 2010, 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.