Database browsing, analysis and manipulation - easier than ever!

<body bgcolor="#000000" text="#C0C0C0" link="#0080FF"> <p><font face="Arial" size="2">Manifold® Database Commander™ is a universal command and control console for working with almost any database.  Commander allows you to see your data and relationships in the data with greater power and ease of use than ever before.</font></p> <p><font face="Arial" size="2">Database Commander is not just some dumb little database browser: it contains a new approach to understanding databases of spectacular sophistication and power, all tamed for your ease of use within a sensible, point-and-click interface.</font></p> <p><font color="#FF0000" face="Arial" size="3"><b>Recent Press Coverage </b>  </font></p> <blockquote> <ul> <li><font face="Arial" size="2">Read a <b><a href="../../press/reviews/cps_cmdr.html">review of Database Commander</a></b> by Computer Programming Specialists, Inc. for </font><font size="2"><font face="Arial">the <a href="http://www.cpsweb.com/zinehome.htm" target="_blank"><b>dataBASE d-zine</b></a>.</font> </font> </li> <li><font face="Arial" size="2">See the <a href="http://www.spatialnews.com/reviews/commander/" target="_blank"><b>review of Database Commander</b></a> by <b><a href="http://www.spatialnews.com" target="_blank">Spatial News</a></b> editor Glenn Letham.</font></li> </ul> </blockquote> <p><b><font face="Arial" size="3" color="#008000">Database Commander Functions:</font></b></p> <ul> <li><b><font face="Arial" size="3">Browse</font></b><font face="Arial" size="2"> almost any data file or database, even SQL Server!</font></li> <li><b><font face="Arial" size="3">Find</font><font face="Arial" size="2"> </font></b><font face="Arial" size="2">data easily and intuitively, even when you are not sure exactly what you seek.</font></li> <li><font face="Arial" size="3"><b>Transform</b></font><font face="Arial" size="2"> data at will with a point and click, without any programming, even including type changes or format changes.</font></li> <li><font face="Arial" size="2">Perform sophisticated </font><b><font face="Arial" size="3">analysis</font></b><font face="Arial" size="2"> without having to write complex SQL queries or database programs.</font></li> <li><font face="Arial" size="2">Run </font><font face="Arial" size="3"><b>statistics</b></font><font face="Arial" size="2"> on fields and automatically report results.</font></li> <li><font face="Arial" size="2">Do any level of </font><b><font face="Arial" size="3">SQL</font></b><font face="Arial" size="2"> desired, even using text files or tables from HTML pages.</font></li> <li><b><font face="Arial" size="3">Chart </font></b><font face="Arial" size="2">fields using "group by" methods, and see what records are in the chart by simply clicking on the chart.</font></li> <li><b><font face="Arial" size="3">Harvest</font></b><font face="Arial" size="2"> data from Web sites for use in your own databases.</font></li> </ul> <p><font face="Arial" size="2"><b>Beta tester's comment: </b>"Again a great product in Manifold-like manner!  I did not expect such a complex application behind the easy-to-use interface."  See the <b><a href="../../news/testimonials.html">Testimonials</a> </b> page for more user comments.</font></p> <p><b><font face="Arial" size="3" color="#008000">Manifold Database Commander introduces SEVEN major new innovations never before seen in database work.</font></b></p> <p><font face="Arial" size="2">For a visual tour of Database Commander<b> </b>via screen shot thumbnails, visit our <b><a href="cmdr_sample_dialogs.html" target="_self">Sample Database Commander Screens</a></b> page.  The sample screens page shows major dialogs and cool functions in thumbnails for fast loading.  Click on a thumbnail to see a more detailed view.</font></p> <p><font face="Arial" size="2">Visit the <a href="http://www.manifold.net/online_store.html" target="_top"><strong>Manifold.net Online Store</strong></a><em> right now</em> to order Database Commander.  Database Commander may be purchased and downloaded within minutes for instant gratification! </font></p> <p><font face="Arial" size="4" color="#008000">Seven Major Commander Innovations</font></p> <div align="left"> <table border="0" cellpadding="0" cellspacing="5" width="584"> <tr> <td align="right" width="130" valign="top"></td> <td width="32" valign="top" align="center"><b><font color="#000000" size="3" face="Arial">1</font></b></td> <td width="392" valign="top" align="left"><b><font color="#000000" size="3" face="Arial">"More Like This"</font></b>  - <font color="#000000" face="Arial" size="2">Click on record or cell and ask for "more like this" and Commander will find more like that.  Commander knows what fields you are looking at as well as what the actual contents are in the database.  An electric mix of artificial intelligence and automated "fuzzy" searching goes on behind the scenes to make life easier for you.  <b>Example: </b>Find more records like that customer in France.</font></td> </tr> <tr> <td align="right" width="130" valign="top"></td> <td width="32" valign="top" align="center"><b><font color="#000000" size="3" face="Arial">2</font></b></td> <td width="392" valign="top" align="left"><font size="3" face="Arial"><b>"Click-back" Charting</b></font><font size="1"><b><font face="Arial Special G1">™</font></b><font size="3" face="Arial"> </font></font><font face="Arial" size="2">- Database Commander creates "live" charts where the items in the chart are "handles" back into the data.  Click on a bar in a Commander bar chart to see the records that make up that bar.  They'll automatically be highlighted back in the table.  <b>CTRL-click</b> on several bars to highlight multiple bars at once.  This works with other chart styles too!  <b>Example:</b> Find all the shipments in the "Wednesday" bar in the bar chart.</font></td> </tr> <tr> <td align="right" width="130" valign="top"></td> <td width="32" valign="top" align="center"><font size="3" face="Arial"><b>3</b></font></td> <td width="392" valign="top" align="left"><b><font size="3" face="Arial">Decision Support System</font></b><font face="Arial" size="2"> - Real life database searches involve flexible criteria with multiple tradeoffs.  Manifold Decision Support System makes it easy to search databases using flexible criteria, just like in real life.  This easy to use system uses point-and-click "presets" to make it easy to specify profiles such as "average", "high" and so on.  It's the most advanced flexible search capability ever offered for database searching.  <b>Example:</b> Find US Counties where Hispanic income is "high" and White income is "low".</font></td> </tr> <tr> <td align="right" width="130" valign="top"></td> <td width="32" valign="top" align="center"><font size="3" face="Arial"><b>4</b></font></td> <td width="392" valign="top" align="left"> <p style="line-height: 100%; margin: 0" align="left"><b><font size="3" face="Arial">Active Columns</font><font face="Arial Special G1" size="1">™</font></b><font face="Arial Special G1" size="2"> - Write any formula in Formula Builder and give it a name.  It instantly appears in the table as a column with that name at the top and is automatically computed "on the fly" for each record.  It's like a spreadsheet, but easier, and it's set up to work with databases.  Better still, the formula can use any Visual Basic scripting or ActiveX construct, such as Functions and more. Click on the thumbnail for an easy to understand example. </font></p> <p style="line-height: 100%; margin: 0" align="left"><font face="Arial Special G1" size="2"> <b>Example: </b>Add a "discounted price" column to the table.</font><font face="Arial Special G1" size="2"> </font></p> </td> </tr> <tr> <td align="right" width="130" valign="top"></td> <td width="32" valign="top" align="center"><font size="3" face="Arial"><b>5</b></font></td> <td width="392" valign="top" align="left"><font size="3" face="Arial"><b>"Click-back" Analysis Bars</b> </font><font face="Arial" size="2">- Analysis bars report the results of a statistical, logical or math operation at the bottom of a table view. Clicking on the <b>Highlight</b> button in an Analysis bar will instantly highlight all records that are picked out by that analysis.  For example, an Analysis bar might report there are 780 records with a <b>Quantity</b> field greater than 30.  Click on the <b>Highlight</b> bar and you will see each such record highlighted. </font></td> </tr> <tr> <td align="right" width="130" valign="top"></td> <td width="32" valign="top" align="center"><font size="3" face="Arial"><b>6</b></font></td> <td width="392" valign="top" align="left"><b><font size="3" face="Arial">Transformer Toolbar</font></b><font face="Arial" size="2"> - Transformer makes it easy to change data throughout an entire field at once.  <b>Example: </b>Increase the "Unit Price" field in all records by 10%... instantly, without any programming or need to write update queries in SQL.   Transformer can copy one field to another, even transforming field types (such as numeric to text or text to numeric) "on the fly" during the copy. Over 100 operations provide a rich set of point-and-click commands to apply to text, numbers or even dates.  Copy just the month or year field out of a date, for example, with a single click.</font></td> </tr> <tr> <td align="right" width="130" valign="top">  <p> </td> <td width="32" valign="top" align="center"><font size="3" face="Arial"><b>7</b></font></td> <td width="392" valign="top" align="left"><b><font size="3" face="Arial">Selection Combinations</font><font face="Arial" size="2"> </font></b><font face="Arial" size="2">- Selection is at once the easiest and among the most subtle new ideas in Database Commander. The Selection is a table view pane that opens up underneath the main table view.   Records that are highlighted in the main view can be placed in the Selection as well using Replace, Add, Subtract and other combinations.  Because records can be highlighted in sophisticated ways in the main view, this means that the Selection can be a highly refined and sophisticated choice of records from the database.  Commander can then transform only those records in the selection, analyze only them, chart them, or even save the records in the Selection to a new data file.</font> <p><font face="Arial" size="2">The first example shows how to add records to the Selection.  The second example shows how the other combination buttons (<b>Replace</b>, <b>Add</b>, <b>Subtract</b>, <b>Invert</b> and <b>Intersect</b>) work as well.</font></p> </td> </tr> </table> </div> <p><b><font face="Arial" size="2">Highlights:</font></b></p> <ul> <li><font face="Arial" size="2"> <B>Browse</B> any database to see the <B>structure</B>, <B>properties</B> and <B>content</B> of database <B>tables</B>,<B> relations</B>, <B>queries</B>, <B>fields</B> and <B>records</B>.</font></li> <li><font face="Arial" size="2"> <B>Find</B> data using automatic "<B>more like this</B>" searches that find more records like the one highlighted.</font></li> <li><font face="Arial" size="2"> <B>Zero In</B> on desired records using "<B>fuzzy logic</B>" searches that simultaneously incorporate many flexible criteria.</font></li> <li><font face="Arial" size="2"> <B>Analyze </B>any field in any table or any selection using point-and-click statistics and logic.</font></li> <li><font face="Arial" size="2"><B>Change</B> database data using a global transformer that includes over 100 string, date, currency, numeric and Boolean operations.</font></li> <li><font face="Arial" size="2"> <B>Copy</B> and <B>Paste</B> database tables, relations, queries and records between Commander sessions or other applications.</font></li> <li><font face="Arial" size="2"> <B>Transform </B>database field types and data using math, string commands or logic without update queries.</font></li> <li><font face="Arial" size="2"><b>Search and Replace</b> within database fields.</font></li> <li><font face="Arial" size="2"> <B>Transmute</B> databases from nearly any format into <B>Microsoft .mdb</B> format.</font></li> <li><font face="Arial" size="2"> <B>Search</B> using <B>SQL</B> in simple one-line toolbars or full "expert" <B>SQL</B>.</font></li> <li><font face="Arial" size="2"><b>"Drag and Drop" SQL Query Builder</b> for easy, syntactically correct SQL queries: Templates too!</font></li> <li><font face="Arial" size="2"> <B>Select</B> records using a variety of visual, SQL, Boolean or analytic combinations to create an exact Selection desired.</font></li> <li><font face="Arial" size="2"> <B>Display</B> Active Columns™ that automatically report the results of Decision Support System or ActiveX formulas for any record. Active Columns are like adding a column to a database table that automatically performs any logic desired.</font></li> <li><font face="Arial" size="2"><b>"Drag and Drop" Formula Builder</b> to create Visual Basic scripting / ActiveX formulas for use within Active Columns.</font></li> <li><font face="Arial" size="2"> <B>Chart</B> databases using records or automatic grouping for "<B>drill up</B>" functionality.</font></li> <li><font face="Arial" size="2"> <B>Connect</B> to Microsoft <b> OLAP</b> facilities for immediate views of OLAP cubes (optional Manifold OLAP Connection required.)</font></li> <li><font face="Arial" size="2"> <B>Display </B>data in <B>3D</B> tables, charts and surfaces using spectacular 3D rendered graphics (optional Manifold 3D View Studio required).</font></li> <li><font face="Arial" size="2"><b>Calculate </b>killer statistics without complex statistics packages.  Just point and click!</font></li> <li><font face="Arial" size="2"><b>Harvest</b> data from web pages for use in your own databases.</font></li> </ul> <P><b><font face="Arial" size="2">Directly Supported Database Formats:</font></b></P> <ul> <li><font face="Arial" size="2">Microsoft Access and Access 2000</font></li> <li><font face="Arial" size="2">dBase III, IV, V</font></li> <li><font face="Arial" size="2">Paradox 3.x, 4.x, 5.x</font></li> <li><font face="Arial" size="2">FoxPro 2.0, 2.5, 2.6, 3.0</font></li> <li><font face="Arial" size="2">Excel 3.0, 4.0, 5.0, 97</font></li> <li><font face="Arial" size="2">Lotus WK1, WK2, WK3</font></li> <li><font face="Arial" size="2">Text: .asc, .csv, .tab, .txt</font></li> <li><font face="Arial" size="2">HTML</font></li> <li><font face="Arial" size="2">Via ODBC: Visual FoxPro, SQL Server 6.5 and 7.0, Oracle, Sybase, Btrieve, and numerous others.</font></li> </ul> <p><b><font face="Arial" size="2">Major Sub Systems:</font></b></p> <ul> <li><font face="Arial" size="2">Decision Support System</font></li> <li><font face="Arial" size="2">"More Like This" automatic Artificial Intelligence / Fuzzy searching</font></li> <li><font face="Arial" size="2">Formula Builder with Active Columns for any table or Query</font></li> <li><font face="Arial" size="2">SQL Query Builder with SQL Assistant and preset templates</font></li> <li><font face="Arial" size="2">Analysis Bars for hundreds of "point and click" analytic findings</font></li> <li><font face="Arial" size="2">Transformer Toolbar for global changes to fields and databases</font></li> <li><font face="Arial" size="2">Selection logic using Replace, Add, Subtract, Invert and Intersect combinations</font></li> <li><font face="Arial" size="2">"Living" Chart that embeds handles for database objects in the chart</font></li> </ul> <p><b><font face="Arial" size="2">See more thumbnail pictures of cool Database Commander screens in the <a href="cmdr_sample_dialogs.html">Sample Database Commander Screens Page</a></font></b></p> <p><font face="Arial" size="2"><b>See a <a href="../../cases/commander/dealers/dealers.html">Case Study</a> of "harvesting" a competitor's dealer database from the web.</b> The Case Study presents a step-by-step procedure with thumbnail illustrations (click to see full-sized screen shots) of harvesting data from a web site, converting the dealer list into a handy database, and making formatting conversions for easy use.</font></p> <p><font face="Arial"><small>Manifold Commander revolutionizes data manipulation for any database, even text file or HTML databases.  No more update queries! Over 200 functions can change data throughout Tables or Queries, convert fields and present statistics, with <strong>point-and-click</strong> choice boxes automating every move.   All you need is Manifold Database Commander. It's easy, it's fun, and it will <strong>save you time and money!</strong>   Hey, that's great!  Only <strong>$145</strong>  </small></font></p> <p><font face="Arial"><small>Read the <a href="userman/start_commander.html" target="_blank"><b>Database Commander User Manual</b></a>.</small></font></p> <p><font face="Arial"><small><strong>Easy Math - </strong>Have you ever needed to change data throughout an entire database column?  Perhaps you've got a Table that gives Lengths and Widths of products in inches and you need to convert into centimeters.   You'll need to multiply each value by a conversion factor.  The usual way of doing this is to import into a SQL-capable database package and then write an update query.   No way!  Use Database Commander and simply <strong>point-and-click</strong> to make the changes you need.  Cool!</small></font></p> <p><b><font face="Arial">Now Shipping as a Download + CD Package</font></b></p> <p><font face="Arial" size="2">Database Commander is <b>shipping today</b> from our Online Store or Telephone Orders as a <b>Download + CD</b> product.  This means that you get an immediate email back to you providing download instructions and unlock code so you can download and begin using Database Commander right away.  In addition, we'll ship Database Commander to you in the CD version.  </font></p> <p><b><font face="Arial" size="2">The CD Version Includes:</font></b></p> <ul> <li><font face="Arial" size="2">Getting Started booklet</font></li> <li><font face="Arial" size="2">All example databases used in the documentation.</font></li> <li><font face="Arial" size="2">Bonus Demographic Datasets, including World statistics from the Statistical Abstract of the United States, City County Databook, USA Counties and more.  These are the same datasets provided with Manifold System.  See the <a href="../../intro/demo_datasets.html"><b>Demographic Datasets</b></a> product page for detailed information.</font></li> <li><font face="Arial" size="2">Complete, paginated, indexed documentation in Microsoft Word .doc format.</font></li> <li><font face="Arial" size="2">Handsome DVD style slimline "clamshell" cover/box to protect your Commander CD.</font></li> <li><font face="Arial" size="2">Surrealistic cover artwork.</font></li> </ul> <p><font face="Arial" size="2">The <b>$145</b> base price of Database Commander includes shipping by <b>Priority Mail</b> anywhere in the US and by <b>Global Priority</b> mail to 33 countries worldwide [First class mail used to all locations not served by <b>Global Priority</b>].</font></p> <p><font face="Arial" size="2">Still unsure about Database Commander?  <b><a href="commander_trial.html">Download the Trial Edition</a></b> today and take a closer look.</font></p> <p><a href="http://www.manifold.net/online_store.html" target="_top"><img src="../btn_purchase_now.png" width="100" height="52" alt="btn_purchase_now.png (2836 bytes)" align="left" border="0"></a><font face="Arial" size="2">Visit the <a href="http://www.manifold.net/online_store.html" target="_top"><strong>Manifold.net Online Store</strong></a><em> right now</em> to order Database Commander.  Database Commander may be purchased and downloaded within minutes for instant gratification! </font></p> <p align="center"><font face="Arial" color="#0080FF"><strong>Browser Errors?  No Frames?  Javascript Meltdown?</strong></font></p> <p align="center"><img src="../../home/skull.png" width="100" height="75" alt="'Them that dies is the downrev ones' - Long John Silver"></p> <p align="center"><strong><font face="Arial" color="#0080FF"><small>Now is the time to modernize your system!  </small></font></strong></p> <p><small><font face="Arial" color="#C0C0C0">The </font><font face="Arial" color="#FF0000"><strong>manifold.net</strong></font><font face="Arial" color="#C0C0C0"> web site requires a frames-capable browser which can also handle one or two lines of elementary Javascript. Pre-"4" series  browsers are pretty buggy and often choke.   No problem!  You can get a free upgrade right now. </font></small></p> <p><font face="Arial" color="#C0C0C0"><small>Click below:</small></font></p> <blockquote> <p><small><strong><font face="Arial" color="#0080FF"><a href="http://www.microsoft.com/ie/download/">Microsoft Free Browser Site</a></font><font face="Arial" color="#0000FF"> </font></strong><font face="Arial" color="#C0C0C0">- Usually accessible, but phenomenally popular and occasionally returns a "Server too busy" message.  Try again later.     IE4 is very cool, but If you are light on disk space, don't ask for all the possible add-ons and accessories.  Our first choice.</font></small></p> <p><small><strong><font face="Arial" color="#0000FF"><a href="http://www.netscape.com">Netscape Free Browser Site</a></font><font face="Arial" color="#00FF00"> </font></strong><font face="Arial" color="#C0C0C0">- No problems getting in here (hmm, ... there's a message in that), but you must drill down into the download section. The icons in the new Navigator 4 toolbars are pretty goofy and the options are not what we'd like, but nonetheless a workmanlike product.</font></small></p> </blockquote> <p><font face="Arial" color="#C0C0C0"><small>A note for our international colleagues:    Both of the above sites have strange logic to filter out downloads of "strong" crypto versions of their browsers to what are not verifiably US located systems.  This may cause problems even with US users who are working from behind proxy servers or other firewalls.  No problem! Download the 40-bit lobotomized version for now. </small></font></p> </body>