CURRENT TREND 2010

SYNCRODANT ANNOUNCES HETEROGENEOUS DATABASE INTEGRATOR

Syncordant, a data integration company, has announced the release of its new enterprise-class product, the Data Integrator. The new product enables a single, real-time, customizable view into multiple heterogeneous databases distributed anywhere in the world.

According to Syncordant, customers using its Data Integrator can begin productive work within hours of installation. The Data Integrator can feed applications, report writers, query tools, or web portals, and it is not necessary to transfer or copy data from different databases into a central one to query the Data Integrator. The product queries in place from wherever the data is located.

Another benefit of the Data Integrator is that advanced data ownership and security features can limit general access and define overall visibility. For example, the data owner can limit general access to a resource, and the Syncordant administrator can further narrow visible schema elements and assign appropriate privileges to different users and groups.

Additionally, if a certain database system needs to be swapped out, the Data Integrator can abstract the data layer so that databases can be seamlessly changed. This abstraction of the data layer can also simplify the work of application builders and integrators. Business intelligence applications are able to essentially build apps that provide near real-time results-a real-time data warehouse. Furthermore, the Data Integrator supports and can integrate the most popular dialects (such as Oracle, MySQL, DB2, MS SQL Server, and others) of remote stored procedures.

When companies merge or are acquired, often they are on different databases, and it can take weeks or months to integrate systems based on those databases. "The acquiring company or the merging companies want to be able to share data, and there is really not any simple, easy way to do it," Richard Preston, president and CEO of Syncordant, tells 5 Minute Briefing. "It is a consulting project, but with ours you can within hours figure out what is in each database and come up with your own schema and get information that you need to run your own business from multiple databases from anywhere in the world. It is kind of like a virtual screen in a sense that is customizable. And, a lot of people, we think, are going to stop right there, they are not going to worry about migrating to different databases," says Preston. "The fact of the matter is you ought to spend your time going forward and doing things that are going to help your business in the future."

http:\\www.dbta.com/Articles/Editorial/News-Flashes/Syncrodant-Announces-Heritogeneous-Database-Integrator-60942.aspx

assign_04

ATTACHING MENUS TO

FORMS AND REPORTS

When you have created your custom menus,you must attch them to their corresponding forms and reports. This is a simple matter of setting the Menu Bar property for each form and report.In Acces for Windows, you can change the menu bar of a form and runtime using VBA code

Creating Shortcut Menus

Microsoft has added an exciting new feature to Access for some Windows:Shortcut menus.

Shortcut menus are menus that appear when you right click on an object.You have probably been taking advantage of shortcut menus in many applications including the design environment of Access 2.0,now you can give your application’s users this valuable time-saver.

You can assign shortcut menus form and you can assign a different shortcut menu to every control on a form.You create shortcut menusthe same way you create standard menus: by first creating the top-level menu macro and then creating the submenu macros. You can create only one AddMenu action for the top-level macro. If you create more than one top-level menu by using additional Add menu actions.

Creating menu accelerator keys by using

Key Assignment macros

Although menu access keys(the keys that open pull-down menus when combined with the Alt key) and menu item hot keys(the shortcut keys for selecting a menu item from an open pull-down menu make it easy to select a menu item power users are always looking for faster shortcuts.To make your application as efficient as possible you need to give your users the ability to select an item with one key or key combination an accelerator key.

Unlike menu item hot keys which are only active while a pull-down menu is open accelerator keys are active at all times. An accelerator key may be one key such as the Delete key or it may be a key combined with Shift, Ctrl or Alt.

Creating intuitive accelerator keys

Microsoft offers a program for designating applications as Microsoft Office Compatible. All Microsoft Office Compatible applications share three characteristics:

*Common menu structures

*Common menu structures

*Common accelerator key definitions

For an application to be certified Microsoft Office Compatible. It not only needs to have accelerator keys but the accelerator keys must also be consistent with the other Microsoft Office products.For example, if you have a print menu item,you must use the Ctrl+P accelerator key. Even if you don’t plan on submitting your application for Office Compatibility certification,you should still attempt to use the same accelerator keys as Office,where applicable. This cnsistency lowers the learning curve for your application and helps your users become more productive in less time.

Adding accelerator keys to your application should be simple; unfortunately,it’s not.If you attempted to add accelerator keys to your application while using Access 2.0and became extremely frustrated,be aware that you will be frustrated again. If you attempt to add acceleratorkeys to your Access for Windows application.

ASSIGN_02

WORLD OCEAN DATABASE 2009
World Ocean Database 2009 (WOD09) is an update of World Ocean
Database 2005 (WOD05). All data are available online presorted by 10 °
geographic squares, by year or by user specified criteria. If you would like
to receive the entire data set on DVD please contact NODC Services.
For any questions about this product, please e-mail OCLhelp desk.
_____________________________________________________________

CheatBook DataBase 2009 FREEWARE - (45,2 MB)

CheatBook-DataBase 2009 - The encyclopedia of game cheats. A die hard gamer would get pissed if they saw someone using cheats and walkthroughs in games, but you have to agree, sometimes little hint or the "God Mode" becomes necessary to beat a particularly hard part of the game. If you're an avid gamer and want a few extra weapons and tools the survive the game, CheatBook DataBase is exactly the resource you would want.

CheatBook-DataBase 2009 is a freeware cheats code tracker that makes hints, Tricks, Tips and cheats (for PC, Walkthroughs, Playstation, Playstation 2, Playstation 3, Sega, Nintendo 64, Nintendo DS, DVD, Gameboy Advance, Gameboy Color, N-Gage, Nintendo DS, XBox, XBox 360, Gamecube, Dreamcast, Super Nintendo, Wii, Sony PSP) easily accessible from one central location.

If you're an avid gamer and want a few extra weapons or lives to survive until the next level, this freeware cheat database can come to the rescue. Covering more than 16.000 Games , this database represents all genres and focuses on recent releases. Games are listed alphabetically in the left-hand window. When you click on a game name, the relevant cheat is displayed in a editor window, with convenient buttons that let you print the selection or save any changes you've made. In the latest past many users of the CheatBook- DataBase and readers of the monthly being published magazine have sent to us small error messages and suggestions for improvement again and again. First of all we say "Thank you very much!" to all of you! Due to this assistance and the permanent sending in of new and revised cheats the CheatBook is ever increasing and becoming more and more voluminous.

Many of the suggestions which we received are now realized in the new version 2009.

- comfortable adding of individual cheats
- cheats can be edited more easily now
- separate section with solutions
- files and images can be stored
- simple survey of informations about the cheat
- statistics
- comfortable filter conditions
- consoles cheats added
- 17 different consoles now possible
- search machine was revised
- link manager
- history log - News and Updates
- private user data base
- Import old Own Bases
- Skins

The program is small and setup is a snap. Once CheatBook-Database is on your hard drive, use it as much as you want because it's free.

Release date January 2. 2009

CheatBook-DataBase 2009 is Freeware for Win95/98/2000/NT/XP/Vista All Cheats inside from first CHEATBOOK Jan.98 until January 01/2009

____________________________________________________________________

Human Protein Reference Database--2009 update.

Human Protein Reference Database (HPRD--http://www.hprd.org/), initially described in 2003, is a database of curated proteomic information pertaining to human proteins. We have recently added a number of new features in HPRD. These include PhosphoMotif Finder, which allows users to find the presence of over 320 experimentally verified phosphorylation motifs in proteins of interest. Another new feature is a protein distributed annotation system--Human Proteinpedia (http://www.humanproteinpedia.org/)--through which laboratories can submit their data, which is mapped onto protein entries in HPRD. Over 75 laboratories involved in proteomics research have already participated in this effort by submitting data for over 15,000 human proteins. The submitted data includes mass spectrometry and protein microarray-derived data, among other data types. Finally, HPRD is also linked to a compendium of human signaling pathways developed by our group, NetPath (http://www.netpath.org/), which currently contains annotations for several cancer and immune signaling pathways. Since the last update, more than 5500 new protein sequences have been added, making HPRD a comprehensive resource for studying the human proteome.

____________________________________________________________________

---

Natural Medicines Comprehensive Database 2009

Natural Medicines Comprehensive Database covers details like ingredients, effectiveness, safety, interactions, manufacturer, etc.

Natural Medicines Comprehensive Database 2009 gives you everything you want to know about herbs, vitamins, minerals, supplements, including the most evidence-based data on interactions, uses, safety, efficacy, and includes ratings on efficacy and ratings on safety including safety in pregnancy, children, and lactation. Also the most practical, easy to use, source of names, brand names, ingredients, manufacturers, cautions and adverse effects.

The Database provides all of the clinically relevant information in an easy-to-use format. Hundreds of monographs have been updated and thousands of new references are added each year. This latest update is based on the 2009 print edition with additional features, enhanced functionality and ongoing updates!

This resource was created by the editors of Pharmacist's Letter and Prescriber's Letter. These seasoned drug information professionals have been analyzing drug information and publishing drug advisory Letters for over 20 years. Natural Medicines Comprehensive Database 2009 is now recognized as the scientific gold-standard for evidence-based information on this topic.

Key Features

• Provides users scientifically reliable evidence-based data presented in an easy-to-use, practical manner.
• New references are cited, new drug interactions have been added.
• Safety and effectiveness ratings have been altered for several products based on important new findings.
• Cotnains potential interactions between any natural product and any drug.
• Gives details of brand names, ingredients, effectiveness, safety, interactions, manufacturer, etc.

____________________________________

Silkworm nucleotide databases - Current trends and future prospects

The domesticated silkworm, Bombyx mori serves as an ideal representative of lepidopteran species for a variety of scientific studies. As a result, databases have been created to organize information pertaining to the silkworm genome that is subject to constant updating. Of these, four main databases are important for store nucleotide information in the form of genomic data, ESTs and microsatelites. These databases also store data related to other lepidoptera and important insects, which help in insect biological research. Though a considerable amount of nucleotide data is currently available, there is a paucity of data related to silkworm and other lepidopteran proteins. Hence, the focus of this article is to present the current status of nucleotide databases of silkworm, avenues for improvement and possibilities for databases that could be created in the future.

The silkworm Bombyx mori, is a monophagous insect, which feeds on the leaf of the MorusBombyx mandarina, which is found in northern India, Southern and Southeastern parts of Asia. The Bombyx mori has an estimated haploid nuclear genome size of 530 Mb broken into 28 chromosomes. species, commonly known as mulberry. Bred in captivity for over 5000 years, it is now fully domesticated. Silk cocoons from this species are the source of commercial silkyarn. Its closest and only wild relative is the

The B. mori genome is considered as a central model for insect species and is important in comparative and functional genomics studies for lepidopteran species, providing a solid foundation for integrating biological information of lepidopteran and even insects in generalDrosophila melanogaster). and is second only to fruitfly (

Many basic physiological processes of insects are conserved, in spite of the evolutionary process. Thus the biological sequences of the silkworm are of importance as, their study could help to further elucidate the function of gene homologs and facilitate studies of insect domestication, morphogenesis, endocrinology, reproduction, behavior and immunity. Genomic data helps understand the organization of genes in the genome, their clustering and regulatory patterns in common functions or pathways. The ESTs and cDNA sequences help identify and annotate all the genes that can be expressed in the silkworm at various stages of development thus aiding in elucidating its metabolic functioning and gene expression profile. In addition we can analyze the organization of exons, introns, alternate splice sites and regulatory regions in the genes, which are important in biological studies . Information on microsattelites and non-coding regions too has its importance in studies elucidating evolutionary relationships, mapping and population genetics and forensic studies. Thus silkworm databases are essential for insect biology studies.

In light of these needs, a few databases have been created to store the data generated from genomic and cDNA sequencing operations carried out on the B. mori. To date, there are four major databases, that store nucleotide data, that are available in the public domain. Of these, two are genomic databases: the Silkworm KnowledgeBase hosted by the Beijing Genomics Institute (BGI) in China and the Silkworm Genome Database hosted by the Insect Genetics and Bioscience (IGB) lab at the University of Tokyo in Japan . The IGB lab also hosts the EST database for the silkworm namely, the Silk Base. This database contains all the EST sequences expressed in B. mori at various stages of growth and development, in various tissues. Another database, namely the Silk moth Microsatellite Database (SilkSatDb) hosted by the Centre for DNA Fingerprinting and Diagnostics at Hyderabad, India is a relational database of microsatellites extracted from available EST and Whole Genome Shotgun (WGS) Sequences of B. mori. The database stores three kinds of data: the microsatellite repeats found in the B. mori EST, WGS sequences and details pertaining to each sequence and information on the primers developed for each of these microsatellites.
The Silkworm KnowledgeBase (Silk Db) is a web-based repository for the curation, integration and study of silkworm genetic and genomic data maintained by many key institutes in China, mainly the Beijing Genomics Institute (BGI). After the generation of the ~6X draft genome sequence of B. mori, the database now provides data in the form of an integrated map of contigs, cDNAs, clusters of expressed sequence tags (ESTs), transposable elements (TEs), mutants, single nucleotide polymorphisms (SNPs) and functional annotations of genes with assignments to InterPro domains and Gene Ontology (GO) terms on a genome wide scale . The database aims to provide a comprehensive knowledgebase about the silkworm and present the silkworm genome and related information in a systematic and graphical way for the convenience of in-depth comparative genomics studies.


____________________________________________________________________

Human Immunodeficiency Virus Reverse Transcriptase and Protease Sequence Database

[My paper] R W Shafer, D Stevenson, B Chan

Division of Infectious Diseases, Stanford University Medical Center, Stanford, CA 94305, USA. rshafer@cmgm.stanford.edu

The HIV RT and Protease Sequence Database is an on-line relational database that catalogues evolutionary and drug-related human immunodeficiency virus reverse transcriptase (RT) and protease sequence variation (http://hivdb.stanford.edu). The database contains a compilation of nearly all published HIV RT and protease sequences including International Collaboration database submissions (e.g., GenBank) and sequences published in journal articles. Sequences are linked to data about the source of the sequence sample and the anti-HIV drug treatment history of the individual from whom the isolate was obtained. The database is curated and sequences are annotated with data from 180 literature references. Users can retrieve additional data and view alignments of sequences sets meeting specific criteria.
____________________________________________________________________

Plant cis-acting regulatory DNA elements (PLACE) database:

[My paper] K Higo, Y Ugawa, M Iwamoto, T Korenaga

Department of Genetic Resources, National Institute of Agrobiological Resources, 2-1-2 Kannondai, Tsukuba,Ibaraki 305, Japan. kenhigo@abr.affrc.go.jp

PLACE (http://www.dna.affrc.go.jp/htdocs/PLACE/) is a database of nucleotide sequence motifs found in plant cis-acting regulatory DNA elements. Motifs were extracted from previously published reports on genes in vascular plants. In addition to the motifs originally reported, their variations in other genes or in other plant species in later reports are also compiled. Documents for each motif in the PLACE database contains, in addition to a motif sequence, a brief definition and description of each motif, and relevant literature with PubMed ID numbers and GenBank accession numbers where available. Users can search their query sequences for cis-elements using the Signal Scan program at our web site. The results will be reported in one of the three forms. Clicking the PLACE accession numbers in the result report will open the pertinent motif document. Clicking the PubMed or GenBank accession number in the document will allow users to access to these databases, and to read the of the literature or the annotation in the DNA database. This report summarizes the present status of this database and available tools.

ASSIGN_01

Hierarchical refers to systems that are organized in the shape of a pyramid, with each row of objects linked to objects directly beneath it. Hierarchical systems pervade everyday life. The army, for example, which has generals at the top of the pyramid and privates at the bottom, is a hierarchical system.Hierarchical systems are as popular in computer systems as they are in other walks of life. The most obvious example of a hierarchical system in computers is a file system, in which directories have files and subdirectories beneath them. Such a file organization is, in fact, called a hierarchical file system . Many data structures for storing information are hierarchical in form. Menu-driven programs are also hierarchical, because they contain a root menu at the top of the pyramid and submenus below it. WHILE...

A relational database matches data by using common characteristics found within the data set. The resulting groups of data are organized and are much easier for people to understand.Such a grouping uses the relational model (a technical term for this is schema). Hence, such a database is called a "relational database."The software used to do this grouping is called a relational database management system. The term "relational database" often refers to this type of software.Relational databases are currently the predominant choice in storing financial records, manufacturing and logistical information, personnel data and much more.