• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

The Database Objects

Four primary objects need to be defined before we can start creating SQL. This might seem a bit trivial if you're used to working with databases, but if this is all new to you, it might help clarify things a little bit. Within UltraDev, you have access to four remote structures:

Databases— These are the container elements, which are defined when creating a connection. A database itself doesn't contain data—it does, however, contain other elements that actually hold the information.

Tables— They hold the actual data in the database. The type of information held in a table is defined when a table is created. Multiple tables can exist within a single database and can be related to one another in order to form a normalized structure.

ViewsThink of a view as a virtual table. If you perform a single complex query repeatedly, it might be easier to define it as a view. A view is nothing more than a query that, for all intents and purposes, appears to the outside world as a table. Each time this table is accessed, the SQL query used to create it is executed and the data returned, as if it were a real table.

Stored Procedures— These are program subroutines that are stored on the remote database server. Like a view, a stored procedure isn't a storage place for actual data, but a virtual construct. Stored procedures can be used to process data and return the result directly into UltraDev as if the data were a standard recordset. Unfortunately, different database servers support different programming languages for writing stored procedures. If you want to remain truly portable, keep as much of the code as possible written in SQL.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint