This is a brief introduction to the Ultimate Database (UDB) system.
Consisting of a cloud based back-end and dynamic user defined front end, Ultimate Database is a system that can create shared, tiered online multi-user systems with comparative ease. As the system is entirely web based, you can access your systems and business critical data on whatever device you have internet access. Be that a phone, desktop or other device with a compatible browser.
We will be making more of these tutorials to help you design and develop different elements of your site using the extensive tool set. Let's start with looking at the Administration interface. This is where the bulk of building your application will be done.
1 - How to access the Admin Area.
To access the admin area go to account and check that dev mode is on, if dev mode is on it will say ‘Dev Mode Off’, if it is off it will say ‘Dev Mode On’, to turn it on or off simply click it. Once Dev Mode is on a new option will appear in the account menu, so go to Account > Admin. This will open the admin area. If you have never used the admin area before it will show the Sites list, here you can click on the site you want to access and it will take you to the Content and Component section.
2 - Content Section.
The content section holds things like the Main Pages, any lists you want displayed on the pages and any menu groups you want displayed on menus.
3 - Component Section.
The component section holds components that add to the content section. These are things like HTML templates, CSS style pages and JavaScript scripts.
4 - Lists.
Lists are sort of like files in windows, they hold data. There are 2 types of list; Data Lists and App Lists. Data Lists only hold Objects. App lists can hold Data Lists, Groups and Relationships but generally don’t hold Objects.
5 - Objects.
Objects are things like Pages or Products, they could be documents or reports uploaded by users. These objects allow data to have properties and be defined by type of variable and required input field format (e.g. List or Input Box).
6 - Groups
Groups allow you to form collections of related objects.
7 - Relationships.
Relationships are used to associate objects from one list with objects in another, for example if I had a list of product objects and a list of product type objects I could define a relationship from Product objects to Product Type objects, this would allow me to define a product type relationship when making a new product. I can then use this on my website to create a sort by type of product.
Application List
Data List
Item
UDB Guide
Tutorial 0: Introduction
Ultimate Database (UDB) consists of a cloud-based back end and a dynamic, user-defined front end. UDB can create shared, tiered, online, multi-user systems. Because UDB systems are entirely web-based, users can access their systems and business-critical data from any device with internet access, including phones, desktop computers, and other devices with a compatible browser.
UDB tutorials cover the design and development of different elements of a site using the UDB tool set. The Administration interface is where most application building is performed.
1. Accessing the Admin Area
Open the Account menu.
Check the development mode status:
If development mode is on, the menu displays Dev Mode Off.
If development mode is off, the menu displays Dev Mode On.
Click the displayed development mode option to turn development mode on or off.
When development mode is on, a new option appears in the Account menu.
Select Account > Admin to open the Admin Area.
If the Admin Area has not been used before, it displays the Sites list. Select the site to access it. UDB then opens the site's Content and Component sections.
2. Content Section
The Content section contains:
Main Pages
Lists to be displayed on pages
Menu groups to be displayed in menus
3. Component Section
The Component section contains components that add to the Content section, including:
HTML templates
CSS style pages
JavaScript scripts
4. Lists
Lists hold data. UDB has two types of lists:
UDB list types
List type
Contents
Data List
Holds Objects only.
App List
Can hold Data Lists, Groups, and Relationships. App Lists generally do not hold Objects.
5. Objects
Objects can represent Pages, Products, documents, or reports uploaded by users.
Objects allow data to have properties and to be defined by:
The type of variable
The required input-field format, such as a List or Input Box
6. Groups
Groups form collections of related Objects.
7. Relationships
Relationships associate Objects from one list with Objects in another list.
Example: Product and Product Type lists
Suppose one list contains Product Objects and another list contains Product Type Objects. A relationship can be defined from Product Objects to Product Type Objects. When creating a new Product, this relationship allows a Product Type relationship to be defined. The relationship can then be used on a website to create a product sort-by-type feature.
