A directory of resources inthe field of technical communication.


51-74 of 102 found. Page 3 of 5.

About this Site | Advanced Search | Localization | Site Maps


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.



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


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


MobiLink Synchronization Wizard in SQL Anywhere 10

MobiLink is a technology that can help multiple databases synchronized, a key requirement for mobile access to data. The article shows you how to create a model that can be deployed to access data on a SLQ 2005 Server remotely with a SQL Anyhwhere database. A forth coming article descibes the deployment details.

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


The MySQL Roadmap – What's Planned?

MySQL is old news ...or is it? In this fast-paced expose, Blane looks at where MySQL is now, and what's planned in Versions 4.1 and 5 - including the exciting developments of MySQL Cluster and Stored Procedures!

Warrene, Blane. SitePoint (2004). Articles>Information Design>Databases>Open Source


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   (peer-reviewed)   (members only)

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


The New Breed of Version Control Systems

CVS, part of the glue that holds open source development together, is showing its age. Many competitors have emerged recently, fixing misfeatures and adding new ideas. Shlomi Fish explores several current open source version control systems that may be better than CVS for your needs.

Fish, Shlomi. O'Reilly and Associates (2004). Articles>Content Management>Programming>Databases


A New Enhancement to the R-Tree Node Splitting   (peer-reviewed)   (members only)

The performance of spatial queries depends mainly on the underlying index structure used to handle them. R-tree, a well-known spatial index structure, suffers largely from high overlap and high coverage resulting mainly from splitting the overflowed nodes. Assigning the remaining entries to the underflow node in order to meet the R-tree minimum fill constraint (Remaining Entries problem) may induce high overlap or high coverage. This is done without considering the geometric features of the remaining entries and this may cause a very non-optimized expansion of that particular node. This paper presents a solution to the above problem. The proposed solution to this problem distributes rectangles as follows: (1) assign m entries to the first node, which are nearest to the first seed; (2) assign other m entries to the second node, which are nearest to the second seed; (3) assign the remaining entries one by one to the nearest seed. Several experiments on real data, as well as synthetic data, show that the proposed splitting algorithm outperforms the efficient version of the original R-tree in terms of query performance.

Al-Badarneh, Amer F., Qussai Yaseen and Ismail Hmeidi. Journal of Information Science (2010). Articles>Information Design>Databases


The NoSQL Ecosystem

Unlike most of the other projects in this book, NoSQL is not a tool, but an ecosystem composed of several complimentary and competing tools. The tools branded with the NoSQL monicker provide an alternative to SQL-based relational database systems for storing data. To understand NoSQL, we have to understand the space of available tools, and see how the design of each one explores the space of data storage possibilities.

Marcus, Adam. Architecture of Open Source Applications, The (2013). Articles>Information Design>Databases>SQL


Novel Fuzzy Information Proximity Measures   (peer-reviewed)   (members only)

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


One-One, One-Many and Many-Many Relations in XML Schema

This article is the second in a series that shows you how to implement relations for designing robust XML schema definitions.

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


PHP and MySQL: An Introduction

MySQL combined with PHP is a powerful tool. However, most beginners won’t know where to start, on how to extract the data from their databases, or what have you. There is just about 50 MySQL functions in PHP, all used to help you accomplish what you need with PHP. However, you’re probably not going to use them all, and below I’ll explain the key features.

Webtint (2009). Articles>Web Design>Databases>PHP


PostgreSQL vs. MySQL vs. Commercial Databases: It's All About What You Need

Can you trust the leading open-source database engines, PostgreSQL and MySQL, to deliver the performance and features that the Oracles, SQL Servers, and DB2s of the world do? Not just yet, but they could offer enough to meet your needs. Find out how they stack up against each other, as well as against the commercial alternatives.

Conrad, Tim. DevX.com (2004). Articles>Information Design>Databases>Open Source


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


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


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


Refining Data Tables

Many articles have been written on what is probably the single most ubiquitous interface element within Web applications today: the form. Forms justifiably get a lot of attention because their design is critical to successfully gathering input from users. Registration forms are the gatekeepers to community membership. Checkout forms are how eCommerce vendors close deals. But what goes in must eventually come out, and the information users provide to Web applications often makes its way back to users in the form of tabular data.

Wroblewski, Luke. UXmatters (2006). Design>Web Design>Forms>Databases


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


SQL Cookbook: Advanced Searching   (PDF)

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


Review: SQL Server Integration Services Using Visual Studio

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides you with the basic knowledge that you should have before you move on to more advanced ETL [Extraction, Transformation, and Loading]. The book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. This guide provides the building blocks describing each block by way of an example as well as describing the nuts and bolts that bind the blocks. A majority of SSIS tasks are covered in this book and they are described fully in the summary of table contents section. You start building packages right from Chapter 2 and continue on to Chapter 20 gathering and building upon your knowledge in each step.

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


SQL Tuning   (PDF)

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


Staying Competitive Through Continuous Improvement: The Business Information Service at ABN AMRO   (peer-reviewed)   (members only)

Case study describing the realignment of the Business Information Service (BIS) in ABN AMRO. Explains the reasons for change and the plans to incorporate the concept of continuous improvement, helping to ensure the service constantly evolves to meet demands of the organization. Includes a description of the bank and its operations and explains the role of the BIS within it. Explains how the service will be realigned to embrace the principles of continuous improvement, covering changes in both the Research and Support Services sections, and outlines how these changes will be achieved. Concludes that to make a difference, such change must be a constant.

Beattie, Jacqueline. Business Information Review (2007). Articles>Knowledge Management>Databases>Case Studies


Storing Hierarchical Data in a Database

Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own CMS: there will be a moment that you'll want to store hierarchical data in a database. And, unless you're using a XML-like database, tables aren't hierarchical; they're just a flat list. You'll have to find a way to translate the hierarchy in a flat file.

Van Tulder, Gijs. SitePoint (2004). Design>Web Design>Information Design>Databases


A Study of Instructions for Information Systems: Variations on a Minimalist Theme   (PDF)

To perform complex tasks, workplace computer users have to know how to control their programs and adapt program capabilities to the needs of their job goals and methods. I inquired into the instructional information that will help users learn such adaptive computing for complex data processing tasks by interviewing twelve experienced database users and analyzing twenty-five exchanges between experts and users on a database helpline network. Findings show that instructions may help users emulate expert approaches to adaptive computing for complex tasks by providing enough substantial technical information to help clarify task problems, goals, methods and analogies and presenting it in the form of rules of thumb, general procedures, and task-to-program explanations.

Mirel, Barbara E. STC Proceedings (1993). Articles>Documentation>Databases>Minimalism


Synchronize MySQL Data Using SQLyog Job Agent

As MySQL developers, we are often required to keep two databases in complete sync with one another.

Chand, Karam. SitePoint (2004). Design>Information Design>Databases>SQL



Follow us on: TwitterFacebookRSSPost about us on: TwitterFacebookDeliciousRSSStumbleUpon