Querying Databases in Microsoft SQL Server 2005

This hands-on tutorial should help you in understanding the interface available for querying MS SQL Server 2005 databases. Some of the major features will be discussed as related to their use rather than going into a lot of details. Querying the database is one of the most basic activities that is routinely and frequently performed.

Krishnaswamy, Jayaram. ASP Free (2006). Articles>Information Design>Databases>SQL

SQL Cookbook: Advanced Searching  

Some types of searching operations stand apart from others in that they represent a different way of thinking about searching. Perhaps you're displaying a result set one page at a time. Half of that problem is to identify (search for) the entire set of records that you want to display. The other half of that problem is to repeatedly search for the next page to display as a user cycles through the records on a display. Your first thought may not be to think of pagination as a searching problem, but it can be thought of that way, and it can be solved that way; that is the type of searching solution this chapter is all about.

Molinaro, Anthony. O'Reilly and Associates (2001). Articles>Information Design>Databases>Search

SQL Functions

A function is a special type of command word in the SQL99 command set. In effect, functions are one-word commands that return a single value. The value of a function can be determined by input parameters, as with a function that averages a list of database values. But many functions do not use any type of input parameter.

Kline, Kevin and Daniel Kline. O'Reilly and Associates (2001). Articles>Information Design>Databases>SQL

SQL Tuning  

Even if the vast number of end users leads to high calculation loads outside the database, you can generally throw hardware at the application load (the load outside the database, that is), hanging as many application servers as necessary off the single central database.

Tow, Dan. O'Reilly and Associates (2001). Articles>Information Design>Databases>SQL

Using the SQLXML Data Type

If you're a Java 2 Enterprise Edition (J2EE) developer, you'll want to preview the SQLXML technology, currently in development. Check out procedures to create an XML document, store an XML document in a relational database, retrieve an XML document from a database, and navigate an XML document with the SQLXML Java data type.

Vohra, Deepak. IBM (2006). Articles>Information Design>Databases>XML

Using Topic Maps to Extend Relational Databases

Topic Maps provide a very flexible and robust way to add arbitrary data to a relational databases at runtime. Moreover, Topic Maps come with a predefined exchange mechanism (the XML Topic Maps (XTM) interchange syntax) to allow data to be exported to XML.

de Graauw, Marc. XML.com (2003). Articles>Information Design>Databases>XML

VB.NET Application with SQL Anywhere 10 Database

This article by Jayaram Krishnswamy shows how you can develop a VB.NET 2.0 application using the integration features provided by the SQL Anywhere database. The SQL Anywhere tools are directly accessible without going out of the Visual Studio 2.O IDE. The article describes a window application with two examples developed with this easy to use integration interface.

Krishnaswamy, Jayaram. Packt (2007). Articles>Information Design>Databases>SQL

Work with XML in Microsoft Access 2003

If you are a Microsoft Access user, you'll be happy to know that you can export Access 2003 data as XML.

O'Reilly and Associates (2005). Articles>Information Design>Databases>Microsoft Access

Working With External Data Sources in FileMaker Pro 9

FileMaker 9 opens up ODBC data in a revolutionary way, via the new feature External SQL Data Source. You can work with external data in your FileMaker Pro solutions as if it is FileMaker Pro data.

Stars, Jonathan. FileMaker Advisor (2007). Articles>Information Design>Databases>SQL

XML Development Resources

XML will change the way you develop and integrate your databases.

Trytten, Chris. FileMaker Advisor (2002). Articles>Information Design>Databases>XML

XQuery

XQuery speeds up the process of finding information contained in an XML document, which is very handy when dealing with long XML documents. This article, the first of two parts, will teach you how to write XQuery expressions.

Dev Articles (2006). Articles>Information Design>Databases>XML

XQuery, Concluded

XQuery speeds up the process of finding information contained in an XML document -- which is very handy when dealing with long XML documents. This article, the second of two parts, will teach you how to write XQuery expressions.

Dev Articles (2006). Articles>Information Design>Databases>XML

Cyberabstracts: A Portal on the Subject of Abstracting Designed to Improve Information Literacy Skills    

With the overall purpose of improving the information literacy skills of librarianship and information science students, an academic portal specifically centred on abstracts and abstracting resources is proposed. We take the existing literature, together with our knowledge and experience of abstract/abstracting topics and web-based technologies to conceive the research design. The research mainly consists of the selection, assessment and web-display of the most relevant abstracts on knowledge management, information representation, natural language processing, abstract/abstracting, modelling the scientific document, information retrieval and information evaluation. The resulting Cyberabstracts portal presents its products consistently and includes reference, abstract, keywords, assessment and access to the full document. Improvement opportunities for this unique subject-based gateway, representing much more than a mere subject catalogue, are uncovered as the starting point on a planned route towards excellence.

Pinto, Maria. Journal of Information Science (2008). Articles>Information Design>Databases>Metadata

Developing an Information Management Strategy: The Foundation Stone for an EDRMS    

All too often organizations have a fragmented approach to Information Management Documents/data is duplicated in many places and users are expected to enter the same information many times. Developing an Information Management Strategy is the foundation stone that should be in place before considering cost justifying or implementing Electronic Document and Records Management System (EDRMS).

Waldron, Martin. Business Information Review (2008). Articles>Knowledge Management>Information Design>Databases

Novel Fuzzy Information Proximity Measures    

As a measure of information shared between two fuzzy pattern vectors, the fuzzy information proximity measure (FIPM) plays an important part in fuzzy pattern recognition, fuzzy clustering analysis and fuzzy approximate reasoning. In this paper, two novel FIPMs are set up. Firstly, an axiom theory about the FIPM is given, and different expressions of the FIPM are discussed. A new FIPM is then proposed based on the axiom theory of the FIPM and the concept of fuzzy subsethood function. Two concepts based on the idea of Shannon information entropy, fuzzy joint entropy (FJE) and fuzzy conditional entropy (FCE), are proposed and the basic properties of FJE and FCE are given and proved. Finally, classical similarity measures such as dissimilarity measure (DM) and similarity measure (SM) are studied, and two new measures, fuzzy absolute information measure (FAIM) and fuzzy relative information measure (FRIM), are set up, which can be used as measures of the proximity between fuzzy sets A and B.

Ding, Shi-Fei, Shi-Xiong Xia, Feng-Xiang Jin and Zhong-Zhi Shi. Journal of Information Science (2007). Articles>Information Design>Databases>Search

Extend Enumerated Lists in XML Schema

The addition of new values to a list is a common and necessary requirement. Schema designers often seek to build into the architecture a means to permit additional values that were unknown at design time. How can schema designers create an enumerated value list that is extensible and easy to implement? Discover several approaches used to achieve this goal.

Kiel, W. Paul. IBM (2008). Articles>Information Design>XML>Databases

Interview with the Creator of the EServer TC Library

Tom Johnson has an interview the site's creator, Geoff Sauer, who explains some of the details behind the site. I found the discussion of their taxonomy particularly interesting, as it's a problem I've struggled with in my own site.

Soltsys, Keith. Core Dump (2008). Articles>TC>Information Design>Databases

XQuery in Relational Database Systems

Relational database systems (and the related standards body ANSI/INCITS H2) are busy adding XML support. One of the main components of such XML extensions will be support for the upcoming XML query language XQuery. The presentation will outline how XQuery and XML conceptually fit into a relational database environment. It will cover the organization of the XML in the database, how to type it using W3C XML Schema, how to query it both in conjunction with SQL and using top-level XQuery. It will present the concepts, talk about new developments in the ISO/ANSI SQL/XML standards and present some demos of XQuery in the upcoming Microsoft® SQL Server 2005.

Rys, Michael. IDEAlliance (2004). Articles>Information Design>Databases>XML

XML, Queries, and Databases

XML has dramatically changed the way we exchange and store data, and a new crop of standards promises to change the way we query data. On today's Internet, most data is queried and stored using relational databases, exchanged as XML, and displayed as HTML. For those who need to use XML and databases together, the last five years have been chaotic, creative, interesting, and often frustrating. Every major database vendor has added XML support, but each vendor takes a very different approach, and sometimes changes that approach dramatically from one version to the next. Today, the vendors seem to be lining up behind XQuery and the SQL/XML mappings - is this just the latest wave of marketing hype, or has the industry now found its way?

Robie, Jonathan. IDEAlliance (2004). Articles>Information Design>Databases>XML

Integrating Messaging and Databases to Implement Service Architectures

There has been much debate over two quite different approaches to implementing XML services. The "web services" approach leverages a rather large and not yet stabilized stack of formats and protocols built on top of SOAP that promise secure, reliable operations; the "REST" or "Plain old XML over HTTP" approach keeps the basic formats and operations quite simple, but puts the burden for any security or end-to-end reliability on the application developer rather than the computing infrastructure. This presentation considers a third approach which complements many of the ideas in both WS and REST but uses an XML-capable DBMS as the messaging hub or service broker. This makes it feasible to support asynchronous, loosely coupled communications between service requesters and providers.

Champion, Michael. IDEAlliance (2005). Articles>Information Design>Databases>XML

Migrating from MS SQL Server 2008 to EnterpriseDB

With many database vendor products in the market and data intensive applications using them, it is often required to port the application to use the data or, migrate the data so that the application can use it. Migration of data is therefore one of the realities of the IT Industry. Some of the author's previous articles on migration can be found at the link.

Krishnaswamy, Jayaram. Packt (2009). Articles>Information Design>Databases>SQL

Programmatically Creating SSRS Report in Microsoft SQL Server 2008

The process of programmatically creating the SQL Server Reporting Services (SSRS) tabular report is described. You will be creating a very simple report using the provided code. The approach is to introduce the programming by creating the three parts of a report: connection, dataset, and layout. Excerpt from the book, "Learning SQL Server 2008 Reporting Services.'

Krishnaswamy, Jayaram. Packt (2009). Articles>Information Design>Databases>Reports