Once a lesser-known category of software, databases have become a more and more important part of technical communication practice. Today databases often drive documentation collections, including content management systems and wikis. The most sophisticated databases tend to employ the SQL language.
#30756
Vendor View: An Interview with Greg Simidian 
Interview with Greg Simidian, Managing Director of company information vendor Perfect Information. Discusses the company itself and how it has changed over the years, concentrating particularly on its customer relations. Considers relations between vendors and intermediaries generally, covering contract negotiation and the impact of end users, and also considering recruitment and skills issues for the information industry. Speculates on the future of the industry, considering social networking in particular. Reflects on Greg Simidian's previous career, considering the benefits of working for both mainstream and niche information providers.
Simidian, Greg. Business Information Review (2007). Articles>Interviews>Databases>Case Studies
#30681
Web Enabling Data on a SQL Anywhere Server using a Native Web Service
Exposing server data to intranet/internet, an attractive and much needed method has become possible due to the native web services, services that can be created on the database itself to which HTTP or Soap requests can be made. SQL Anywhere server, even in version 9.0 [present version SQL Anywhere 10] possessed this built-in capability of being able to expose data on the database server to HTTP requests.
Krishnaswamy, Jayaram. Code Project, The (2008). Articles>Documentation>Databases>SQL
#30657
Why (Almost) Every Web Site Needs an RDBMS
When your Web application reaches a certain size, it needs a good database design behind it. And in fact, this 'certain size' is much smaller than almost every small-site developer thinks. Relational Data Base Management Systems (RDBMSes) need not be restrictive or over-architected, as their bad reputation sometimes brings developers to fear. A bit of thought toward what your site does quickly turns into a sensible schema design, and it is easy to leave open expandable storage mechanisms like a configuration table within an RDBMS back end.
Mertz, David. IBM (2007). Articles>Web Design>Server Side Includes>Databases
#27036
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
#30115
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
#28616
Working With External Text Files in Microsoft Access 2007
Step-by-step procedure explained with a large number of screen shots. Both linking and importing are described.
Krishnaswamy, Jayaram. OfficeUsers.org (2007). Articles>Software>Databases>Microsoft Access
#30114
XML will change the way you develop and integrate your databases.
Trytten, Chris. FileMaker Advisor (2002). Articles>Information Design>Databases>XML
#27660
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
#27661
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
#32129
Retrieving Data on a SQL Anywhere Server Using AJAX
The article shows how an AJAX call can be made to a resource on the SQL Anywhere Server using stored procedures and web services.
Krishnaswamy, Jayaram. Ajax World (2008). Articles>Web Design>Databases>Ajax
#32130
Visual Studio 2008 and SQL Anywhere 11 Integration
Describes how Panorma (now SQL Anywhere 11) is installed as well as the integration features with .NET Framework.
Krishnaswamy, Jayaram. Hodentek (2008). Articles>Web Design>Databases
#32231
Data Pager Control [.NET Framework 3.5] in Visual Studio 2008
When query results exceed the display area then you resort to scrolling and wish you had some way to limit the number of results displayed and comfortable to view without scrolling. Paging functionality which provides an answer to this is therefore a much desired feature. The Data Pager Control in Visual Studio 2008 provides this functionality when you create an ASP.NET web form under .NET Framework 3.5. It can be configured automatically using the GUI, or it can be installed manually after installing the ListView. In this article both of them are described. While the number of items displayed in a list can be declaratively coded, it is possible to set it at page load time as well.
Krishnaswamy, Jayaram. Packt (2008). Articles>Web Design>Databases
#32295
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
#32309
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
#32312
Narrative enquiry: A way to get organizations (and the people in them) talking and acting differently: An account of methods of intervention to enquire into conditions surrounding records management and filing to catalyze change
Sparknow, Paul Corney and Victoria Ward Sparknow. Business Information Review (2008). Articles>Knowledge Management>Databases>Workflow
#32323
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
#32597
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
#32967
Data Modeling: Finding the Perfect Fit 
If you ask an application developer what the most important task is in developing new or enhanced applications for institutional data and processes, almost every time they will tell you it is the initial analysis of client requirements. Before purchasing any software, before storing a single byte of data in a database, analysis of the client's requirements is paramount to developing the appropriate solution.
McLellan, Tim. IslandNet (1995). Articles>Information Design>Databases
#33090
Providing Intranet Access to Records
Many organisations are attempting to clarify the relationship between the corporate intranet, and their document/records management system. While this is a broader issue of information management with an organisation, there are some short-term activities that can be taken to create a working relationship between these two platforms. This briefing outlines a simple scenario in which the intranet helps staff find key corporate information, while the documents accessed are stored in the document/records management system.
Robertson, James. Step Two (2005). Articles>Web Design>Intranets>Databases
#33380
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
#33782
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
#33786
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
#33792
Anatomy of a Native XML Database
Most people in the XML community are aware of the term, "Native XML Database." Fewer are aware of the design details and implementation trade-offs made in construction of a native XML database. This paper focuses on issues surrounding storage in a native XML database. The format of stored XML, as well as the granularity of stored documents, has a large effect on database design and scalability, as well as how a system may be used by an application. Indexing of stored information is another topic that is at the core of XML database performance.
Feinberg, George. IDEAlliance (2004). Articles>Information Design>Databases>XML
#33828
Native XML Databases in the Real World
Based on a broad survey of native XML database companies, this presentation describes how native XML databases are being used in the real world, including descriptions of why native XML databases succeeded and relational and other technologies failed.
Bourret, Ronald. IDEAlliance (2005). Articles>Information Design>Databases>XML
#33838
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
