relational: search

Adding non-atomic XML data to relational databases causes mayhem. But what is atomic data, and is it time we changed the relational model?

Adding non-atomic XML data to relational databases causes mayhem. But what is atomic data, and is it time we changed the relational model?

MetaTrieval Software Breaks Out of Stealth Mode - Releases Enterprise Ready MetaData Search and Query Tool for Relational Databases!

Every once in a great while a product comes along that genuinely makes life far easier and much more productive. Such a software product has just been released, solving one of the most important, but little appreciated problems confronting IT departments and other information-seeking business users: Finding and Retrieving Data Stored in Relational Databases. With MetaTrieve these tasks become exceedingly simple.

iBATIS, Hibernate, and JPA: Which is right for you?

Object-relational mapping in Java is a tricky business, and solutions like JDBC and entity beans have met with less than overwhelming enthusiasm. But a new generation of ORM solutions has since emerged. These tools allow for easier programming and a closer adherence to the ideals of object-oriented programming and multi-tiered architectural development. Learn how Hibernate, iBATIS, and the Java Persistence API compare based on factors such as query-language support, performance, and portability across different relational databases.

Working with the XML Data Type of SQL Server

With the growing use of XML data, the need for the coexistence of relational data and XML data is also growing. The classic approach of storing XML data as physical disk files is unsuitable and tedious in many situations. No wonder modern database engines are geared to store XML documents right along with the rest of the relational data. To that end, the XML data type introduced in SQL Server 2005 is a great addition to the database engine. Prior to SQL Server 2005, developers often used VARCHAR or TEXT column types to store XML documents and fragments. Although this approach served well as far as data storage is concerned, it proved to be poor in terms of querying and manipulating the XML data. This article will give you a jump start in using the XML data type of SQL server and will teach you how XML data can be manipulated with the help

Working with the XML Data Type of SQL Server

With the growing use of XML data, the need for the coexistence of relational data and XML data is also growing. The classic approach of storing XML data as physical disk files is unsuitable and tedious in many situations. No wonder modern database engines are geared to store XML documents right along with the rest of the relational data. To that end, the XML data type introduced in SQL Server 2005 is a great addition to the database engine. Prior to SQL Server 2005, developers often used VARCHAR or TEXT column types to store XML documents and fragments. Although this approach served well as far as data storage is concerned, it proved to be poor in terms of querying and manipulating the XML data. This article will give you a jump start in using the XML data type of SQL server and will teach you how XML data can be manipulated with the help

Manage relational data with the Java Persistence API

Broadband Service Provider Trident SR Sdn. Bhd.

Post-Relational Databases Flying Under the Radar

NEWPORT BEACH, Calif.—In the modern IT world, SQL and XML have become such key components in the database sector that it’s difficult to remember a time when they weren’t part of the architectural story.

Data Integration and the Insurance Industry: Querying Data from XML and Relational Sources

ACORD standards are currently used by numerous insurance and reinsurance companies worldwide. Complying with these standards can be challenging, however, as The ACORD XML standards are defined through a set of extensive XML Schema requiring companies to create and interpret messages defined according to those XML Schemas.

Data Integration and the Insurance Industry: Querying Data from XML and Relational Sources

ACORD standards are currently used by numerous insurance and reinsurance companies worldwide. Complying with these standards can be challenging, however, as The ACORD XML standards are defined through a set of extensive XML Schema requiring companies to create and interpret messages defined according to those XML Schemas.

Data Integration and the Insurance Industry: Querying Data from XML and Relational Sources

ACORD standards are currently used by numerous insurance and reinsurance companies worldwide. Complying with these standards can be challenging, however, as The ACORD XML standards are defined through a set of extensive XML Schema requiring companies to create and interpret messages defined according to those XML Schemas.

XML Performance: A Surprising Ace in the Hole

Relational database storage brings RDBMS strengths to XML data. But older clumsier storage methods left application performance an open question. Two years after IBM introduced pureXML in DB2 9, that question has been answered.

IBM WebRB increases web developer productivity

Web Relational Blocks Software, Personal Edition (WebRB-PE), from IBM alphaWorks, is a browser-based visual editor and run-time environment that enables developers to visually assemble Web applications without adding any imperative code.

Blog Post: Who Owns Your CRM Data?

NetSuite offers no out-of-the box relational export, and they make it hard to get your data out of the system through other means. A reasonable person could conclude that NetSuite uses these "features" as sales tactics to lock the user into their system. Other online CRM vendors seem to have a much more reasonable approach to "your" data.

Blog Post: Who Owns Your CRM Data?

NetSuite offers no out-of-the box relational export, and they make it hard to get your data out of the system through other means. A reasonable person could conclude that NetSuite uses these "features" as sales tactics to lock the user into their system. Other online CRM vendors seem to have a much more reasonable approach to "your" data.

Database Development in Rational Application Developer 7

Rational Application Developer 7.0 offers a wide range of tools to work effectively with relational databases. In this article, you will learn how to establish a database connection, set up a data development project, and work with SQL Builder.

Canadian Photo Retailer Develops New Online Presence

Black's is working with a new partner, ATG (Art Technology Group, Inc), known for its use of next-generation relational behavioral modeling logic to recommend merchandise and content to customers.

Red Hat Makes a GPL-Compatible Patent Deal

Bruce Perens writes "Red Hat has settled patent suits with Firestar Software, Inc., Amphion, and Datatern on a patent covering the Object-Relational Database Model, which those companies asserted was used in the jBoss Hibernate package — not in Red Hat Linux. The settlement is said to protect upstream developers and derivative works of the upstream software, thus protecting the overall Open Source community. Full terms of the settlement and patent licenses are not available at this time."

RedHat Makes a GPL-Compatible Patent Deal

Bruce Perens writes "Red Hat has settled patent suits with Firestar Software, Inc., Amphion, and Datatern on a patent covering the Object-Relational Database Model, which those companies asserted was used in the jBoss Hibernate package — not in Red Hat Linux. The settlement is said to protect upstream developers and derivative works of the upstream software, thus protecting the overall Open Source community. Full terms of the settlement and patent licenses are not available at this time."

Red Hat looks out for OSS community with patent settlement

Red Hat announced today that it has settled a patent dispute with Firestar and DataTern over two patents, including one that covers object-relational database mapping—a technique that is used in Hibernate, a component of the JBoss middleware stack. Red Hat says that the terms of the settlement will offer broad protection for upstream developers, all derivatives, and downstream distributors, as well as Red Hat's customers.

Hamsterdb: a Small, Fast Database That Won't Weigh You Down

Cristoph Rupp's hamsterdb is a lightweight, embedded database engine designed for ease of use, high performance, stability, and portability. In the database world, you have typically two extremes. On the high end, you have the full-featured and sometimes unwieldy Relational DBMS with SQL and a daemon/server process (such as Oracle). On the low end, there are b+tree-based systems, which are essentially just a database engine that is linked into the application and usually are without SQL support. As a lightweight database engine, hamsterdb fits into the latter category. It is very fast, but only supports the minimum needed operations. Specifically, it is embeddable, and therefore does not have the external dependencies or installation hassles of an SQL server.

Search took 0.02 seconds.