Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2

Business needs often necessitate data migration from a smaller, less secure database to a higher end, faster database server with a more reliable availability. A typical scenario is the migration of data from a desktop sized database such as MS Access or Fox Pro to any other higher end database servers such as MS SQL Server, Oracle, DB2 or SQL Anywhere Server. Oracle SQL Developer 1.2 with this latest version is sometimes called the Migration version as it supports migrating data from three vendors (MySQL, SQL Server and MS Access) to an Oracle database. In fact, it has been designed to migrate from more than one version of MS Access. This feature was not available in the version 1.1 of this tool.

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

A Millennial Paradigm for Documentation: the Scroll!

Although some zealots have proposed eliminating printed information entirely in favor of online help systems, Adobe Acrobat files, and even e-books, discarding printed books may prove less effective than simply modernizing them. Scrolls are the logical successors to books.

Hart, Geoffrey J.S. Geoff-Hart.com (2001). Articles>Documentation>Information Design

Mira la Blogosfera

La visualización de weblogs se sirve de metáforas espaciales como el mapamundi o las líneas de metro de una ciudad. Aparentemente algo tan desligado de la localización requiere de ella para establecer una referencia.

Dursteler, Juan Carlos. InfoVis (2004). (Spanish) Articles>Information Design

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

Mobile Phones: Europe's Next Minitel?

Europe's cellular phone system is far superior to that in the United States. However, telephones will not be the platform for the mobile Internet. Given this, Europe's advantage may in fact be an obstacle to real innovations, as France's experience with Minitel shows.

Nielsen, Jakob. Alertbox (2001). Design>Information Design>Wireless Web

Mobile: The State of the Art

The world of mobile phones is a jungle of technologies with few established standards that, in some ways, resembles the early days of personal computing. Here the author presents an impressionistic landscape of this world, a glimpse of the near future, and thoughts on what it might mean for IAs.

Smith, Shawn. Boxes and Arrows (2002). Articles>Information Design>Wireless Web

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

Modeling Information for Three-Dimensional Space: Lessons Learned from Museum Exhibit Design    

Perhaps these concerns sound familiar: visitors complain that they cannot find information of interest. One observes, 'I know there's information about that type of robotics here, but darned if I can find it;' visitors enter the site but don't stay particularly long. Some might even express an interest in the subject; let's say it's modern art. But they leave almost as quickly as they enter without paying much attention to the artwork that the designers painstakingly displayed; other visitors spend hours at the site but never seem to notice particular sections. For example, a visitor might be thoroughly familiar with the content on radios but oblivious to the section on industrial hardware. These observations could describe visitors to Web sites. Actually, these observations describe museum visitors. The connections between the two are discussed in this article.

Carliner, Saul. Technical Communication Online (2001). Design>Information Design>Usability

Modeling Information in Electronic Space: An Introduction to This Special Issue    

Organizing content for delivery on the computer screen challenges us to design our information in an imagined three dimensions. As mobile devices respond to the surrounding world, our content also needs to adjust to the real physical environment around our user. Our rhetorical space has changed, and in this special issue, authors wrestle with the ways in which we think, move, and design differently as we explore these virtual and real worlds. One team suggests showing the user the structure of the information gradually in search forms. Another author suggests that merging object-oriented thinking with visual language may offer us a way to consider structure and format together, while granting each its own distinct qualities. Focusing on mobile devices, one author sketches out the challenges we face in this new rhetorical space, and another highlights the idea of embeddedness, the fact that our devices are enmeshed within a content-rich world that we move through. Our final contributor takes us to museums, to

Price, Jonathan R. Technical Communication Online (2001). Design>Information Design>User Interface>Web Design

Models, Processes, and Techniques of Information Design

Although graphic design and document design are important aspects of it, information design has a much broader focus than just the appearance of information. Its ultimate focus is on the effectiveness of that information.

Carliner, Saul. Saul Carliner Studio. Design>Information Design>TC

Monitoring Order: Visual Desire, the Organization of Web Pages, and Teaching the Rules of Design  

Monitoring Order looks at two potential sources -- writings about book design and writings about visual arrangement in painting -- for helping teachers of writing think about teaching visual composition for Web pages; both sources are problematic but suggest directions for further study.

Wysocki, Anne Frances. Kairos (1998). Articles>Web Design>Information Design>Visual Rhetoric

Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps

This tutorial shows how SQL Server 2005 can be migrated to SQL Server 2008 quite easily by manually detaching the database from SQL Server 2005 and attaching it to SQL Server 2008. This is a much easier process than the 'Copy Database Wizard' which has two procedures one of which is the same as the manual process but carried out under the guidance of a wizard and the other which does not require the stopping of the Source server.

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

Moving from Information Transfer to Knowledge Creation: A New Value Proposition for Technical Communicators    

'What do technical communicators do?' asks the ambitious question on the Society for Technical Communication's FAQ Web page (STC 2001). The answer lists typical job titles for technical communicators and then says, 'All these professionals take technical information and make it understandable to those that need it.' This description is consistent with the way that many technical communicators describe their role, that of transferring information from those who have it (subject matter experts or SMEs) to those who need it, and they define the value of the technical communicator as packaging that information to be more accessible and more readily understood by the user. This article first reviews the current literature that addresses the value of the technical communicator. Whereas those discussions focus on what is delivered to the user (reader), this article examines the value the technical communicator adds by creating organization (internal) knowledge. The article then examines the philosophical underpinnings that support any discussion of knowledge and defines the role of technical communicators as creators of knowledge. Finally, it offers an expanded value proposition for technical communicators and examines its practical implications.

Hughes, Michael A. Technical Communication Online (2002). Design>Information Design>Content Management>SMEs

MSXML, Concluded

This article, the third of three parts, explains what MSXML is and how to access an XML document using JavaScript.

Keogh, Jim and Ken Davidson. ASP Free (2006). Articles>Information Design>XML>Microsoft Windows

MSXML, Continued

This article, the second of three parts, explains what MSXML is and how to access an XML document using JavaScript.

Keogh, Jim and Ken Davidson. ASP Free (2006). Articles>Information Design>XML>Microsoft Windows

MSXML Tutorial

This article, the first of three parts, explains what MSXML is and how to access an XML document using JavaScript.

Keogh, Jim and Ken Davidson. ASP Free (2006). Articles>Information Design>XML>Microsoft Windows

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

The Myth of 'Seven, Plus or Minus 2'

This article proposes that the optimal number of menu items cannot be reduced to the generalized 'Magic Seven, Plus or Minus Two' (7±2). The author proposes that instead, when planning a site information architecture, the two most important considerations are breadth versus depth and the display of information.

Kalbach, James. Dr. Dobb's (2002). Articles>Information Design>History>Cognitive Psychology

Naked

Every content producer cowers before twin demons. On one side stands the publisher’s mandate: you must make your deadline. Readers expect it, and readers lose trust if you’re late to market. On the other side stands the editor’s prime directive: you must publish worthwhile material. Readers expect it, and readers lose trust if you publish filler simply because an issue is due. Publish junk once, and you lose a few discerning people. Do it continually, and you lose everybody.

Zeldman, Jeffrey. List Apart, A (2001). Design>Information Design>Web Design

Navigating Isn't Fun

The artless Websites created during the Web's infancy were of necessity built only with simple HTML tags, and were forced to divide up their functionality and content into a maze (a web?) of separate pages. This made a navigation scheme an unavoidable component of any Website design, and of course, a clear, visually arresting navigation scheme was better than an obscure or hidden one. But many Web designers have incorrectly deduced from this that users want navigation schemes. Actually, they'd be happy if there were no navigation at all.

Cooper, Alan. Cooper Interaction Design (2001). Design>Web Design>Information Design>Usability

Navigation: An Often Neglected Component of Web Authorship

Web authors should follow web design conventions that account for the variety of ways users will try to navigate through their pages. While usability testing is the best way to ensure your site is really operating as you intend it to, this page offers a basic overview of basic navigation principles that most visitors will expect on most pages that they visit.

Jerz, Dennis G. Seton Hill University (2000). Design>Web Design>Information Design>Usability

Navigation Blindness

Most web development projects put a lot of effort into the design of navigation tools. But fact is that people tend to ignore these tools. They are fixated on getting what they came for and simply click on links or hit the back button to get there.

Olsen, Henrik. GUUUI (2005). Articles>User Interface>Information Design

The Need for Architect/Construction Worker Dichotomies in Information Architecture as a Profession  

I would suggest that before we adopt the 'information architect' model and concede the construction worker (role of 'other') to many members of our field in order to negotiate management positions for a few, that we look to other professions to see how they have resisted this dichotomy. It may be argued, perhaps, that professions such as medicine and the law have managed to avoid successfully such hierarchical dichotomies -- at least in part. At the least, we should debate the possible implications of such systems more rigorously than we have to date.

Sauer, Geoffrey. CPTSC Proceedings (2002). Presentations>Information Design>Workplace