#28382
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
#30825
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
#23809
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
#22330
Released in January 1998, MySQL is an open source relational database management system (RDBMS). It's based around the Structured Query Language (SQL), and is best for managing the content of the database as opposed to transactions, as MySQL does not support COMMIT or ROLLBACK. One of the biggest drawbacks of MySQL is it's lack of support for referential integrity, no stored procedures, no triggers, and no sub-queries. MySQL is free, and may be downloaded from download section at MySQL.
Lemon, Gez. Juicy Studio. Articles>Information Design>Databases>SQL
#27631
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
#25906
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
#27944
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
#27059
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
#27057
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
#27058
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
#22406
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
#22404
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
#27748
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
#22750
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
#29299
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
#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
#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
#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
#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
