A directory of resources inthe field of technical communication.

Articles>Information Design>Databases

49 found. Page 1 of 2.

About this Site | Advanced Search | Localization | Site Maps
 

1 2  NEXT PAGE »

 

1.
#25373

Access a MySQL Database Behind Firewalls with the LibMyWitch Control

Till now there was no efficient way to embed the access to the MySQL database into a VB application.

Richter, Dirk. VBMySQL.com (2004). Articles>Information Design>Databases>SQL

2.
#35048

Acrobat 9: PDF Data to Excel

Rather than exporting a whole document out of Acrobat, I'll focus on a table within a PDF page. Suppose you'd like to have this table's data in a spreadsheet so you can manipulate it. There's no need to retype the data into Excel. All you need to do is use Acrobat's Selection tool to highlight the content you wish to export.

Mankin, David R. Blogs.com (2009). Articles>Information Design>Databases>Adobe Acrobat

3.
#29628

Building a Database of Graphic Files Using Microsoft Access   (PDF)

Many technical communicators manage large collections of graphic files and must keep track of which graphics are used in which deliverables. An effective tool for managing a collection of graphic files is a relational database management system (RDMS) such as Microsoft Access. Before the database can be built in Access, it is necessary to 1) create detailed functional requirements and 2) build a high-level conceptual model from which the database relations (tables) can be derived. A spreadsheet program can be used to build the conceptual model and generate the relations. Normalization checks should be performed on the relations before the database is implemented in Access.

Lowe, Richard B. STC Proceedings (2005). Articles>Information Design>Databases>Microsoft Access

4.
#34194

Consistency-Preserving Caching of Dynamic Database Content   (PDF)

With the growing use of dynamic web content generated from relational databases, traditional caching solutions for throughput and latency improvements are ineffective. We describe a middleware layer called Ganesh that reduces the volume of data transmitted without semantic interpretation of queries or results. It achieves this reduction through the use of cryptographic hashing to detect similarities with previous results. These benefits do not require any compromise of the strict consistency semantics provided by the back-end database. Further, Ganesh does not require modifications to applications, web servers, or database servers, and works with closed-source applications and databases. Using two benchmarks representative of dynamic web sites, measurements of our prototype show that it can increase end-to-end throughput by as much as twofold for non-data intensive applications and by as much as tenfold for data intensive ones.

Tolia, Niraj and M. Satyanarayanan. WWW 2007 (2007). Articles>Web Design>Information Design>Databases

5.
#28508

Creating the Relationship-Centric Organization: Nonprofit CRM

Are you storing data about your constituents in three, five, even ten different databases? If so, you're not alone ' but it's costing you in time, lost revenue and decreased impact. Paul Hagen describes how to get all your data into one place with an integrated CRM strategy.

Hagen, Paul. IdealWare (2006). Articles>Information Design>Databases>CRM

6.
#32295

Cyberabstracts: A Portal on the Subject of Abstracting Designed to Improve Information Literacy Skills   (peer-reviewed)   (members only)

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

7.
#37062

Database as a Symbolic Form

After the novel, and subsequently cinema privileged narrative as the key form of cultural expression of the modern age, the computer age introduces its correlate - database. Many new media objects do not tell stories; they don't have beginning or end; in fact, they don't have any development, thematically, formally or otherwise which would organize their elements into a sequence. Instead, they are collections of individual items, where every item has the same significance as any other.

Manovich, Lev. UCSB (2001). Articles>Writing>Databases>Information Design

8.
#27614

Database Modelling in UML - Part 1

When it comes to providing reliable, flexible and efficient object persistence for software systems, today's designers and architects are faced with many choices. From the technological perspective, the choice is usually between pure Object-Oriented, Object-Relational hybrids, pure Relational and custom solutions based on open or proprietary file formats (eg. XML, OLE structured storage). From the vendor aspect Oracle, IBM, Microsoft, POET and others offer similar but often-incompatible solutions. This article is about only one of those choices, that is the layering of an object-oriented class model on top of a purely relational database. This is not to imply this is the only, best or simplest solution, but pragmatically it is one of the most common, and one that has the potential for the most misuse.

Sparks, Geoffrey. Methods and Tools. Articles>Information Design>Databases>UML

9.
#24997

Database Templates with MySQL

Once you've built several MySQL databases, you'll learn some shortcuts to database design. Why stop there? Take this trick a step further and put together a generic database with a set of empty, standard tables. With a well-designed MySQL template, you can quickly assemble the basics of any database as needed. A template also allows you to focus on the more interesting aspects of a database project.

Dyer, Russell. O'Reilly and Associates (2004). Articles>Information Design>Databases>SQL

10.
#27633

Designing Your Own XML Schema: Learn the Essentials

This is the first article in a series which guides you in designing XML Schemas right from the basics without any hurdles.

Chaterjee, Jagadish. Dev Articles (2006). Articles>Information Design>Databases>XML

11.
#32309

Developing an Information Management Strategy: The Foundation Stone for an EDRMS   (peer-reviewed)   (members only)

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

12.
#25374

Effective Data Filtering

This article discusses writing software that helps the user effectively work with large amounts of data. The approach that I will describe is called filtering.

Rowe, Robert. VBMySQL.com (2004). Articles>Information Design>Databases

13.
#28660

Envisioning the Whole Digital Person

As a human society, we're quite possibly looking at the largest surge of recorded information that has ever taken place, and at this point, we have only the most rudimentary tools for managing all this information--in part because we cannot predict what standards will be in place in 10, 50, or 100 years.

Follett, Jonathan. UXmatters (2007). Articles>User Centered Design>Information Design>Databases

14.
#27286

The Essentials of a Database Quality Process   (PDF)   (peer-reviewed)

Many steps are involved in the process of turning an initial concept for a database into a finished product that meets the needs of its user community. In this paper, we describe those steps in the context of a four-phase process with particular emphasis on the quality-related issues that need to be addressed in each phase to ensure that the final product is a high quality database. The basic requirements for a successful database quality process are presented with specific examples drawn from experience gained in the Standard Reference Data Program at the National Institute of Standards and Technology.

Blakeslee, Dorothy M. and John Rumble, Jr. Data Science Journal (2003). Articles>Information Design>Databases>Usability

15.
#22589

Examining XML

Buzz about the value and implications of XML has reached an all-time high, with lofty claims of its potential to transform business and society, doing everything from simple document formatting to curing the common cold. I don't recommend you empty your medicine cabinet just yet. However, do take seriously the developments surrounding XML and its associated technologies. While XML might not merit all the hyperbole, it remains useful. Knowing how to apply this simple meta-language can help you create solutions that will give you a strong competitive advantage.

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

16.
#36268

Expanded Information Retrieval Using Full-Text Searching   (peer-reviewed)   (members only)

The value of full text for expanding information retrieval was examined. Two full-text databases were used: Textpresso for neuroscience and ScienceDirect. Queries representing different categories were used to search different text fields (titles, abstracts, full text and, where possible, keywords). Searching the full-text field relative to the commonly used abstracts field increases retrievals by one or more orders of magnitude, depending on the categories selected. For phenomena-type categories (e.g. blood flow, thermodynamic equilibrium, etc.), retrievals are enhanced by about an order of magnitude. For infrastructure-type categories (e.g. equipment types, sponsors, suppliers, databases, etc.), retrievals are enhanced by well over an order of magnitude, and sometimes multiple orders of magnitude. Use of combination terms along with proximity specification capability is a very powerful feature for retrieving relevant records from full-text searching, and can be useful for applications like literature-related discovery.

Kostoff, Ronald N. Journal of Information Science (2010). Articles>Information Design>Databases>Search

17.
#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

18.
#28522

Generating and Hosting a SQL Server Reporting Services Report Using SQL Server 2005 Business Intelligence Development Studio

A step-by-step must read article on SQL 2005 Reporting Services which creates a report and hosts it on an intranet server.

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

19.
#38030

The Importance of Chunking for Sorting

If you want to be able to sort information by various classification schemes, such as by most popular, or by role, or by problem, your content has to be chunked in a granular enough way to facilitate the various means of sorting.

Johnson, Tom H. I'd Rather Be Writing (2011). Articles>Information Design>Databases

20.
#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

21.
#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

22.
#27632

Introduction to Relations in XML Schema

This is the first article in a series concentrating on implementing relations for designing robust XML schema definitions.

Chaterjee, Jagadish. Dev Articles (2006). Articles>Information Design>Databases>XML

23.
#31816

Migrating from Microsoft SQL Server and Access to MySQL

In this article I will cover the basics of migrating an application from an Access or SQL Server database to MySQL. We'll start with various reasons why you should (or should not) migrate your existing Access or SQL Server database to MySQL, then cover the planning stages of an application migration. Next we will look at the tools and methods for migrating your actual data from Access/MSSQL to MySQL, followed by some general guidelines for modifying your client application from a Microsoft database to MySQL. Finally, we'll look at some considerations to make when deploying your new MySQL database and application.

Hillyer, Mike. MySQL (2007). Articles>Information Design>Databases>SQL

24.
#34151

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

25.
#25623

Misconceptions About Integrated Project Databases

The notion of an integrated project database (IPDB) has existed for decades. Over that time many projects have been undertaken to develop the technologies and frameworks required to implement an IPDB. Also over that time, there has been promotion of the benefits and impacts that IPDB systems will have on the industry. As there are still no industrially stable IPDB systems in existence, the industry's perception of what they are and what they can do has diverged from many of the original presentations. It is also clear that researchers and de-velopers involved in IPDB development have many different ideas about what constitutes an IPDB and what is, or is not, possible to create. This paper aims to describe misconceptions which are growing up around IPDB systems, and presents the authors' view of reality (informed by the opinions of the UK network of experts in ob-jects and integration (URL-1 1999) which was run by the DETR).

Amor, Robert and Ihsan Faraj. ITcon (2001). Articles>Information Design>Databases

 
 NEXT PAGE »

 

Follow us on: TwitterFacebookRSSPost about us on: TwitterFacebookDeliciousRSSStumbleUpon