|
|
Definition:
DB Manager is an integrated, programming
environment for managing data
base.
If we have to be more precise that could
have hardly been called a definition because
the product in its latest versions is also
used as an Integrated Development Environment
(IDE) used in the creation of final
applications.
What is the purpose of DB Manager:
First of all that is the possibility
to explore,
support the ability to modify
and create
Tables. It is even accepted that
database
can be taken as a number of tables
which
have certain logical or other
types of connections
in between.
A typical feature of the product is that
even XML (but not only that Document Object
Model) can be looked upon and modified in
the form of tables.
Example:
If you have already worked with some of the
office sets, which inevitably has made you
use kinds of tables. Representing information
in the forms of tables is easy to access
and comprehend. Tables are mostly used when
certain verifications or presentations are
necessary.
This is a well-trained practice in some economic
sectors but things are different in technical
and scientific sectors.
Imagine that your task is to arrange all
the constructive documents of a certain object
which for example can be the new model of
a press. That task would be much more difficult
if the object was a car or a plane. In that
case more text documents should be added
(some technological maps, for example) as
well as some constructive drawings and not
only catalogue number, name, price, size
and number.
You have to agree that is a difficult
task
takes a lot of time and human
abilities.
Here come to help the mighty
systems operating
with bases of Oracle, MS SQL,
DB2, InterBase,
MS Access, dBase, Paradox and
others which
need some specialized knowledge.
If you are
not acquainted with relating
databases in
details and the way they work
then you should
seek consultants. That is necessary
because
the language of SQL which is
responsible
for managing the databases is
a separate
product having its own specific
nature.
Let us take it for granted that you have
enough knowledge of working with MS Excel
or some other similar product. If you were
in the possession of a program which would
help you to edit the tables in databases
in a way close to the way it is done with
some electronic tables then your process
of learning would have taken so little time
and wouldn1t interfere with your working
process.
It is often necessary to add
to each record
its accompanying graphic drawing
or text
documents. It is not that simple
with the
office packets and they also
have another
purpose of usage.
If your company is a small or medium one
and it is working in the development or production
sphere then DB Manager would replace successfully
all the expensive systems of management and
control of the processes and document turnovers.
In common words the basic purpose of DB Manager
is to help you to operate the content of
different data base no matter where they
are located or what format they have.
The system has either good application
for
Microsoft Windows as well as
for Linux platforms.
DB Manager in its corporative
versions can
be also offered like versions
for Novell
and UNIX.
The test results can guarantee
the equally
high level reliability in every
of the mentioned
operating systems. |
|
|
 |
|
| DB Manager Standart Table |
|
| Contents ... |
|
|
What isn't DB Manager
It is important to know that DB Manager is
not simply an electronic table. Although
the bigger part of the information is formed
in kinds of tables that is the result of
many conversions which remain hidden for
the final user.
Integrated environment isn't database.
It can communicate with all kinds of database
(remote - by means of local net or internet
or such as situated on your computer and
called local).
The user decides what type of Database Development
System DBDS (look in the perspective chapter)
to use and where to be situated the system
according to the specific needs. It is important
to be known that while working with remote
database some of the conversions will be
executed on the work station and then the
changes will be inserting in the server.
Note: It is not an obligatory condition (it
is quite possible direct changes on the server
to be done)
DB Manager is not a text processing program.
It supports a set of text editors but this
aims more likely making the more of the professional
developers less complicated. Practically
there are no problems with transmitting of
ASCII, UNICODE and RTR files and their following
processing. However it is important paying
attention on used code tables, especially
when languages different from English are
used.
DB Manager is not a 3D editor.
The editor in its basic versions allows only
Bitmap and JPEG master images loading. In
the higher versions except those two you
can process also Enhanced Metafiles (.emf),
Icons (.ico) and other as well as. Vector
images like the ones supported by AutoCAD
and 3D studio formats for example.
DB Manager is not a HTML editor.
Even though it has options for
converting
tables as a HTML files in its
highest versions
are supported such as Java script
libraries,
dynamic web-applications developing
system,
etc. DB Manager is not intended
for web-pages
work out. You could use it as
a support mean,
while working with a distant
management of
a huge database on on-line support.
DB Manager is not a RAD System.
Although DB Manager allows building
up a
final applications it is not
a RAD system
and does not claim to be. Its
possibilities
for creating attractive applications
with
a beautiful interface should
not be considered
at all. |
|
| Contents ... |
|
Editors of shapes and final applications
With the assistance of IDE you can develop
independent final applications as well to
create a very attractive interface. |
|
 |
|
| DB Manager Custom Design Application |
|
| There are no limits referring the used graphic
forms. It is important to know that the editor
creating the forms is accessible only for
the versions that includes information coding
systems, graphic images much searching systems
or either golden or platinum subscription. |
|
| Contents ... |
|
Local database management
Definition:
When talking of local bases we have in mind
all the tables where the processing is completed
at the final user.
In common when local database
are concerned
we'll have in mind tables (files)
of dBase,
Paradox, FoxPro and ASCII (drivers
suitable
for them are included in each
version of
Windows - see ODBC). Even in
cases when the
data is on a server (that is
accepted to
be called "file server"
but this
is a conditioned definition)
the processing
is done at the final user. When
a final server
is used the information is sent
to the different
clients by the means of a set
of rules amongst
which competition is the most
important and
thus the priority of execution
is defined
in case that the users are more
than one.
Regardless of that DB Manager
gives the possibility
for the data to be processed
which has no
difference from the work with
actual applications.
ANSI/ISO Local SQL are used for
the purpose.
A great flexibility is obtained
in that way.
The advantage of that kind of
database is
their safety. If damage happens
to one of
the tables it will not concern
the rest of
them.
It would be of interest to a
lot of people
the possible unification of a
common mass
of tables in different formats
(heterogenic
connection).
Technical information for example
can be
saved in tables written in Paradox
and the
accounting information can be
saved in files
of Dbase. That gives the possibility
of uniting
of the tables in a common, text
unit by the
means of SQL Editor.
Another interesting possibility
is the formation
of forms containing both kinds
of information
(fig.2)
You can learn some more about
that kind of
unifications in the corresponding
examples
in the units.
For sure one of the biggest advantages
of
the system is the automatic converting
of
each table in a XML document
which guarantees
the transfer of information on
different
platforms without any problems.
Anyhow it is necessary for you
to know that
the standards have brought certain
limits
which should be taken in mind.
For example it is not possible
for you to
use directly in a XML document
data of the
Auto increment (automatic counter)
but DB
Manager gives the possibility
of change the
type of margin and the transfer
of contained
information.
For more information you can
see the section
concerning the use of tables
or get acquainted
with the articles on the topic.
|
|
| Contents ... |
|
Server applications and bases remote from
the data
Definition:
Remote bases from the data are all the information
units which are situated on a separate server
which we get access to by the means of local
net or internet.
These types of data basically need operations
of SQL (Structured Quiery Language) which
gives the possibility of creating and using
the relation database.
The relation database are being
managed by
Database Management Systems which
aquire
the possession of the necessary
kinds of
licence. Some of them, My SQL
for example
can fuond for free.
DB Manager communicates with
the relation
database by the means of drivers
not directly.
Due to its specific character
DB Manager
can be installed either on the
server (the
final users operate by a browser
or a specialised
application as clients), or directly
upon
the working station. That decision
is quite
specific and the exact needs
should be taken
in mind in advance. |
|
| Contents ... |
|
Basic functions
The basic functions of the system can be
generally divided into three groups as it
follows:
- Working with tables and database
- Creating of forms and final applications
- Editoring functions with common purpose
Each of these three groups can
function in
relative independance.
The user`s interface is different
for the
different versions of the product
but this
doesn`t affect the fulfilment
and algorythm
of work. Those differences are
provoked by
the fact that concerning some
of the versions,
the Binary Large Objects, the
margins are
used to save certain audio files,
films or
formatted text whose processing
needs specific
requires. |
|
 |
|
| DB Manager Control panel
(Demo Version 1.0.0) |
|
The control panels themselves don`t possess
anything extraordinary. Even if we have to
be honest they look a bit old fashioned.
That effect is deliberately sought
in the
demo version because it doesn`t
include the
extended graphic interface of
the product.
The main idea is the user to
be aquainted
with the possibilities of the
product getting
working conditions similar to
the ones of
the office packets.
This is a basic arangement, but
every one
of the users can easy rearange
the panels
according to his own needs.
Eccept from the so called fast
keys/see the
information in the respective
chapter/ the
management can be executed also
directly
from the keybord or with the
assistans of
group of menus. |
|
 |
|
| DB Manager Table Menu (Demo Version 1.0.0) |
|
|
Note: In the prescribed exsamples one canot
see the functions related with the writing
systems as well as those relataed with graphic
forms building up, because of their specific
strucrure.
What looks like difficult to
understand at
first sight to the users and
the editor of
theAlies Manager and also the
options for
the generating of forms for applications
and results. In order to prevent
the possibility
of some involuntary mistakes
it certain buttons
can be activated only by some
defined procedures
of the final user.
The leading module is for printing
tables
and there is also a "quick
print"
function besides the standard
ones.
Another novelty is applied by
the moulds
of printing result forms. They
help the preparation
of the results from the repots.
The result
forms are similar to the formatted
text documents.
In spite that similarity the
moulds are not
text documents but something
much more complicated.
Each of the automatically generated
margins
communicates directly with the
result content
of the application sent for the
database.
The last of the printing modules
is connected
with the printing of text, XML
and HTML documents
possessing a good quality. Those
documents
use the so called "standard"
printing. |
|
| Contents ... |
|
|
Extra functions and potentialities
Както вече многократно бе споменавано освен
безплатната demo версия, системата се предлага
и в още три разновидности.
На практика може да изберете
между закупуване на лиценз, или абонамент
за определена версия, което в редица случаи е
икономически е по-изгодно.
Абонаментите могат да бъдат
стандартен, сребърен, златен и платинен.
За последните два
вида се предвиждат
допълнителни преференции.
Повече информация
може да получите
в специализираните публикации,
имащи отношение
към продукта. |
|
 |
|
| A derivative web-form built up by a mould
variety |
|
| Contents ... |
|
What is included in the separate versions
As one can see in Table 1 each
of the versions
maintains a certain number of
modules. Each
user chooses personally the scheme
which
he or she prefers.
One of the varieties of different
options
which are offered is the system
for scripting
of information.
No matter that some of the tables
can be
locked up to the margin level
that doesn't
always mean security of the information.
In connection with the solving
of this problem
we offer several basic forms
of scripting.
The algorithms in use are different
and they
also have a great number of varieties.
As far as the modules for building
a graphic
interface are concerned, they
have a certain
relation to the Multimedia Database. |
|
| Тable |
|
| № |
Version |
Local Database |
Client-Server |
Graphic Interface |
Final Aplications |
Multimedia |
| 1 |
Demo |
 |
 |
|
|
|
| 2 |
Standard |
|
|
|
|
|
| 3 |
Client-Server |
|
|
|
|
|
| 4 |
Professional |
|
|
|
|
|
| 5 |
Enterprise |
|
|
|
|
|
| 6 |
Multimedia |
|
|
|
|
|
| 7 |
Gnosys |
|
|
|
|
|
|
|
Note: You don't need to possess a subscription
card in order to get the demo version. You
can download an installation program from
our official sight or some other server which
is included in the list.
The demo version contains quite
a limited
number of functions for work
with tables
and printing options.
Gnosys if offered for subscription
only and
it contains a system for coding
and decoding
of the information, an editor
which helps
the creating of scripting algorithms,
a control
system for the client-server
applications
and some others which cannot
be found in
any of the other versions.
There is an intended learning
course for
the clients of that version. |
|
| Contents ... |
|
