|
DDS-Lite is the Database Designer's choice for the modeling
and forward engineering of relational databases. Used by professionals
and students throughout the world for more than six years. Database Design
Studio-Lite (DDS-Lite) has
a solid reputation for being feature-packed database modeling software that is easy
to use and great value for money.
Based upon the Chen Entity Relationship Diagram (ERD), DDS-Lite adds
features that make it the leader in Enhanced Entity Relationship Diagram
modeling.
|
|
|
Feature List
|
|
•
|
Enhanced Entity Relationship Diagram modeling allows
you to design a fully relational database, complete with Cascading Referential
Integrity Constraints, Indexes, Checks, Defaults and Unique constraints.
|
|
•
|
Data Structure Diagram that is created automatically
from the Enhanced Entity Relationship Diagram shows the complete table structure.
|
|
•
|
Data Definition Language (DDL) Scripts for creating,
dropping and loading the database can be quickly and easily generated for all
of the supported database servers.
|
|
•
|
Supports All Major Databases including Oracle,
DB2, SQL Server, Informix, Sybase (ASA and ASE), MySQL, PostgreSQL, Interbase, Access,
SQLBase, Ingres, ANSI and Pervasive SQL.
|
|
•
|
Template Language to define the Data Definition
Language scripts allows you to create the scripts exactly as you want them.
|
|
•
|
Project Manager for managing the files that
are used and generated by the application. Full support for Windows
Shell such as delete to the recycle bin, drag and drop, file renaming
etc.
|
|
•
|
Integrate Tools from the Database vendors to
execute the Data Definition Language scripts directly within the application.
|
|
•
|
Cross DBMS Target Compatibility allows you to
design once and create for all. No need to concern yourself with vendor
specific variations to SQL syntax. All is handled by the application.
|
|
•
|
Java Source Code can be created directly from
the Enhanced Entity Relationship Diagram to contain the Data Definition
Language for any of the supported database targets. Source code can be
compiled and executed from within the DDS-Lite environment.
|
|
•
|
Visual Basic Source Code can also be created
directly from the Enhanced Entity Relationship Diagram.
|
|
•
|
SQL Editors with syntax hi-lighting, context
sensitive auto-complete of SQL words. Build and Run environment integrated
with the DBMS vendor tools.
|
|
•
|
ODBC Management within the Project Manager
allows you to have direct access to your most used ODBC connections.
These can be opened directly in
SQL Console.
|
|
•
|
Reports are created in grid views that can
be saved as Microsoft® Excel® or HTML format.
|
|
•
|
Flexible Datatype Mapping allows you to add
and remove Target DBMS datatypes, include datatype modifiers, and create
auto-increment datatypes.
|
|
•
|
User Defined Types or domains are now an
integral part of the Entity Relationship Diagram editing environment.
|
|
•
|
Datastore allows you to create sample data
for testing your model. The referential constraints are enforced to
ensure the data complies with the model. The data can be exported to
data files, insert directly into the database through an ODBC connection,
or formatted into SQL insert scripts.
|
|
•
|
Load Data Scripts allow you to load data
directly into the database.
|
|
•
|
Drag and Drop File Management is integrated
into the Project Manager and Editing windows.
|
|
•
|
Tutorial Exercises will enable you to straighten
the learning curve and have you productive within a few hours of using the
software.
|
|
•
|
Unlimited Email Support is provided for all
registered users of DDS-Lite. Coupled with free upgrades to minor release
versions, guarantees that you will always have the latest software and
full support backup whenever you need it. We want you to be a success.
|
|
|
Latest News
|
|
•
|
May 20, 2005
DDS-Lite 2.21.3 is now available for
free trial,
purchase or
free upgrade.
|
|
•
|
View some Screen Shots.
|
|
Other Software
|
|
•
|
DDS-Pro is the big-brother of DDS-Lite
adding Reverse Engineering, Views, Triggers, Procedures and much more.
Tell me more...
|
|
•
|
SQL Console is the only tool you need to
query an ODBC compliant database. Feature-rich with drag and drop
SQL query builder, context sensitive auto-complete of SQL keywords and
table or view columns, function editor, grid, text or file output, multiple
result sets and much, much more...
Tell me more...
|
|
Useful Links
|
|
|
Frequently Asked Questions
Download DDS-Lite Demo
Download SQLConsole Demo
Register Your Software
Referential Integrity
|
|
Opt-in Newsletter
|
|
|
Submit your email address to receive the Chilli Source
monthly newsletter
(our privacy policy).
|
|
|
|
|
|
Customer Comments
|
|
Philip Avery. I felt I had to write to congratulate you on a great piece of software (version 2.10.0).
Very much better than version 1 and a joy to use. I have come back to it
after using ER/Studio, and find that it is a much better development
environment and semantically so much richer.
|
|
Dr. Bob Jarman, Department of Mathematics and Computer Science, Augusta State University.
I have used DDS as a teaching and modeling tool for nearly three years in several courses: Database Design, Special Topics in Databases, and Senior Systems Design. In today's visually oriented GUI environment, I have not found a better tool to illustrate teaching points as well as get a design job done. My students have used DDS to design and generate MS Access, MS SQL Server, and ORACLE databases without a problem.
DDS is especially valuable for relational design and illustrating associations between entities. Upper level students quickly grasp concepts and move forward on their own to use DDS in designing projects, generating SQL scripts for schema creation, and testing SQL queries against data stores based upon the student's database design. It's not unusual for students to purchase individual licenses to take DDS with them upon graduation.
|
|
Lindsay Smith, Deputy Head of School & Director of Undergraduate Studies, Monash University.
The complete DDS package is very powerful, highly configurable and of great assistance in our educational program. Further, given the financial constraints of students and tertiary faculties DDS has the extra feature, against many similar CASE tools, of being very moderately priced - it is thus excellent value for money. Students find the package easy to use and a significant aid in understanding the fundamental process of database design via ER's and subsequent database creation and loading. We have found the staff at ChilliSource to be responsive to suggestions as to how the product may be improved to assist our teaching program and equally helpful and responsive in dealing with installation troubleshooting or advice.
Without reservation, I recommend this excellent product to fellow educational professionals.
|
|
Rock-Tenn Inc.
DDS-Lite has similar function(s) to S-DESIGNOR and ERWIN at a great price. All developers should have this tool !!
|
|
Collins Informatik
DDS-Lite is easy and intuitive to use. The best thing is the preparation of the
database create statement. So it is easy to test the ERD and also easy to set up the new database if I had to change something.
Normally in development when realising the application, the developer will find some faults in the data model. So he has to change the model, add some fields and change some attributes. With DDS, he will do it in the model because it is the easiest way to correct the database.
|
|
