- Details
- Written by Xuan Tinh P
- Category: Uncategorised
- Hits: 11178
Welcome to DBDesigner.co.uk.
This site is dedicated to telling you how effective DBDesigner can be at creating new software for you and your business. There are sections for both technical and non-technical people: Just find what you are comfortable reading.
DBDesigner is a tool that allows a skilled operator to describe your business need to a computer such that the computer can itself write most of the software you need.
Normally, writing software takes alot of time, alot of money and significant risk that the project won't actually be useful. DBDesigner accelerates this by writing around 2/3 of the finished application at the end of the consultation with the client- and that consultation might only take a few hours. DBDesigner significantly reduces the risk as the first version of the software can be installed and tested within minutes. DBDesigner cuts the costs as there is much less need for expensive programming staff.
We explore all these points in more detail elsewhere- enjoy browsing and then contact us to arrange an appointment.
DBDesigner is currently only in use by Data Technologies Ltd as they are the company who wrote it.
This email address is being protected from spambots. You need JavaScript enabled to view it.on 0115 840 5500 to learn more.
- Details
- Written by Xuan Tinh P
- Category: Uncategorised
- Hits: 5408
Hopefully you are looking at this page because you are interested in having some software written just for you and your business.
Put simply, DBDesigner is a tool that cuts the cost, timescale and risk of getting bespoke business database software.
It is currently only used by Data Technologies Ltd as it's a hugely valuable piece of intellectual property and we want to get the benefit of it ourselves, at least for now.
How can you take advantage of DBDesigner? It's simple:
- Book an appointment with a consultant.
- Describe your business to him.
- Review the draft system, usually that day.
- Accept the quotation for a completed system.
DBDesigner does many things to make buying bespoke cheaper, easier to visualise, and less risky- but you can't really see how without getting a demonstration.
This email address is being protected from spambots. You need JavaScript enabled to view it.on 0115 840 5500 to learn more.
- Details
- Written by Xuan Tinh P
- Category: Uncategorised
- Hits: 5443
DBDesigner uses several technologies together to achieve so much so quickly.
The core technology is DBDesigner 6 itself which allows us to write, compile, publish and execute source code for maintaining databases.
DBDesigner 6 was written using DBDesigner 5, which in turn was written using DBDesigner 4, which was written using DBDesigner 3, which was written with DBDesigner 2, which was written with DBDesigner 1, which was written the hard way! Each version has added more features and these have been used to expand the product with each generation.
The core language of DBDesigner is Delphi XE from Embarcadero Technologies as this met our requirements for performance and stability. We also make significant use of 3rd party components for DBDesigner itself and the applications we create from it as they offer more flexibility than some of the standard components.
As a database product, we rely on database engines to store and retrieve data for ourselves and our customers. We have tested extensively with Microsoft SQL Server but it will also run with most other standard SQL database engines.
We connect to databases using SQL as it is both fast and flexible. We use SQLLite through ODBC for local storage within DBDesigner, though not within finished applications.
We use File Transfer Protocol (FTP) to make new releases available, and to download these new releases at client sites.
This email address is being protected from spambots. You need JavaScript enabled to view it. on 0115 840 5500 to learn more.
- Details
- Written by Xuan Tinh P
- Category: Uncategorised
- Hits: 4185
Database tables are similar to the sorts of tables you'll find in books, such as this:
| CustomerID | Name | Address | |
| 1 | Smith Ltd | Manston, Yorkshire | This email address is being protected from spambots. You need JavaScript enabled to view it. |
| 2 | Wigglesworth Ltd | Leeds, Yorkshire | This email address is being protected from spambots. You need JavaScript enabled to view it. |
| 3 | William J Seymour | Azusa Street, LA, USA | This email address is being protected from spambots. You need JavaScript enabled to view it. |
This shows you both the table design, ie what columns it has in it, and table data.
When a database table is being designed, we would not normally expect specific data to be in it- users like to have their own data in their database! There are exceptions, such as internal-use-only data, such as some accounting codes, but they are notable by their rarity.
So, what makes for a good table design?
1. The right fields.
This might sound trivial, but making sure that your "Customers" table doesn't have details of specific orders means that your customers won't be restricted to just one order each! Similarly making sure that the customer's address is part of the Customers table and not the "Products" table would also be good!
2. The right indexes.
An index to a table is a bit like an index in a book- it allows you to find things quickly. Tables should normally have what is called a "Primary Key"- this is an index that should be unique so that no two records have the same value, so that they can be found quickly, such as by using the CustomerID. Tables can also have a large number of "Secondary Indexes" that also allow data rows (called "records") to be found quickly, such as finding all the customers with a particular surname, but normally they have less than 3.
3. The right help.
DBDesigner supports the entry of help fields as the table is being designed so that the finished program can show the user a hint if he puts the mouse cursor over a field or table.
This email address is being protected from spambots. You need JavaScript enabled to view it. on 0115 840 5500 to learn more.
- You are here:
-
Home
-
Introduction
- Uncategorised