TweetFollow Us on Twitter

Inside Out II
Volume Number:9
Issue Number:3
Column Tag:Tools of the Trade

Inside Out II

An industrial strength database engine

By Kirk Chase, MacTech Magazine Regular Contributing Author

Introduction

Inside Out II (referred to hereafter as “ISO”) is an industrial strength database engine for the Macintosh. [This review is on version 2.1.1. Version 2.2 will be released by the time you read this. - Ed.] ISO has some unique features that make it desirable for developers.

• It’s fast.

• It’s flexible.

• It holds all data in a single file (or extension files if the volume is pressed for space).

• It can handle large database sizes (up to 256 gigabytes of data).

• It can handle multiple users.

• It can operate over the network.

Starting Out

Upon receiving the ISO package, I opened it and was impressed. Sierra Software laid the manual out very well. It comes in a 3-ring binder for easy page changes. The first major section gives installation, examples, and background information. The next major section reviews important database topics and functions. The last major section goes through each function in ISO and gives an example of it.

The manual, though, was surprisingly disappointing in places (I don’t think I’ve ever seen the perfect manual). ISO is laid out so well that I felt it could have spent a little more time in places. For example, I looked at the “Getting Started” section that comprised both the installation and the examples. It seemed rather “skimpy” for such an important section.

I quickly installed ISO and tried out the examples. The examples you’ll find are of your typical flat databases. The examples demonstrated the basic functions without a great deal of overhead, but I really felt an example of hierarchical databases, sets, and some more sophisticated database queries could have been added. A database construction “walk through” example would have been great.

Please keep in mind, that I was very happy overall with ISO and the manual. Section two did a very good job of discussing the ideas and functions of an ISO database. Section three contains a reference to all ISO procedures and an example showing how it is implemented.

Basic ISO

An ISO database consists of a single physical file with the possibility of multiple “extension” files. These extension files can be considered as overflow files when disk space runs low. Within the database, several types of logical files may exist. They are as follows:

• Unstructured files - files that are accessed like data forks

• Static blocks - which are accessed like resources

• Structured records - the database portion of the database

ISO allows you to have any number or combination of these “logical” files in your database-very nice. Here is an example of how one might use all these logical file types. A drafting program may have a database of structured records for materials and costs for a particular project. The project itself could be kept in an unstructured file. Static blocks could be used to keep project specific globals such as cost totals, new views of the project, and security access variables.

As a developer, you no doubt have dealt with the data fork and resources (static blocks). I will concentrate on the database features of ISO.

Building a Database

ISO is for developing relational and flat databases. Applications that work with the databases may either be single or multi-user in design. ISO provides different resources for single-user and multi-user applications.

The development phases for creating your application are as follow:

• Design your database structure.

• Generate the schema resources that define your database with all its files, fields, keys and views.

• Generate the header files for the views you created.

• Create an application with the debugging resources ISO provides along with the schema resources created.

• Develop your application in a debugging environment.

• Finally, replace the debugging feature of your resources and code with the normal resources to generate the final application.

The Schema Editor

Resources are used to define the files and record structures of the database. One drawback of ISO is that these resources must be in the application itself. [The schema resource can also be in the database file. - Ed.] One benefit is that 4th Dimension can browse databases with an external. ISO is for specific database applications. You will not be disappointed with ISO.

A major step in database development is designing the files, fields, keys, and so on used in the database. You do this with the Schema Editor provided by ISO. I will be up front with you. The Schema Editor is quite weak in its user-interface design. It feels as if it had been created as an afterthought and is not up to par with the rest of ISO. You may want to use Rez instead to generate your resources. Still, the Schema Editor does produce a good set of reports on your schema that are handy for documentation. [Version 2.2 will have a new Schema Editor. Some of these concerns may be addressed in this new version. - Ed.]

Figure 1. Index Record IDs and Connection Fields

File Types

The first thing you do in the Schema Editor is to create file types. File types define the record structure of a file. They include field definitions, key definitions, the index record ID field, and the number of connection fields.

ISO supports a wide variety of data types, including handles to variable length data such as PICTs. Table 1 shows the supported field types. You may wish to make a copy of it and keep it handy so you do not have to search the manual again and again.

In developing a relational database, ISO uses index record IDs and connection fields. An index record ID is used for uniquely identifying each record; they are never used twice in a particular file. To establish a one-to-many relationship between two files, you include the index record ID in the parent file, and, in the child file, you specify a connection for each file in the relation. This forms a connection like in Figure 1.

For example, a database keeping track of sales contacts may have a parent file on company address information. Each record would have an index ID number. The child file may contain contact information for the individual. This contact file would contain a connection field to hold the id number of the company record. This establishes a link, or a relationship between the two files.

Keys are used to access records sequentially through your database. Although you can create sets of records and sort them anyway you wish, keys provide a quick way of accessing the records without the need for sorting.

After creating the file types, you then create the logical files and assign them a file type. More than one file can be of the same file type. Then you specify the connections between files for ISO. These connections will then aid ISO in helping maintain hierarchical relationships.

All this editing is done in a modeless environment. I suppose I am use to 4th Dimension, but I really wish the Schema Editor had a more graphical user-interface. I am consoled by the fact that schema definitions are usually done once (not!). I would recommend that you carefully design your database first before using the editor.

Each field of the database must begin on a word boundary. If you do not design your database carefully, you may end up with a lot of empty space. For example, if your database had fields that were defined as a boolean, a general byte field of 5 bytes, an array of three booleans, followed by an integer, ISO would generate the following structure to access this file type:

typedef char   Gnrl5[6];

struct TestView {
 char   b1;
 char filler1;
 Gnrl5  g1;
 char   b2to4[3];
 char   filler2;
 short  i1;
};

Note there is a byte of padding at the end of the general field and after each of the boolean fields. So a little bit of planning can save a lot of memory.

Views

Views are the final thing created in the Schema Editor. Views are how you actually access records in files. Views give you great power and flexibility. Views allow you to do the following:

• They allow you to define exactly which files, fields, and keys you will be using. This allows custom trimming and joining of files.

• They allow for automatic conversion of fields from the way they are stored to the format you need.

• They define which operations (insertion, deletion, updating, etc.) a file in that view can participate in.

• Most importantly, they allow for automatic record finding of files that have connections.

Table 1. ISO Data Types

FieldData typeDomainSizeNull value
StringAlphanumericASCII values1 + string size “”
bytes (pascal
based string)
IntegerSigned integer-32,768 32,7672 bytes0
Long integersigned integer±2,147,483,6474 bytes0
CompSigned integer±9,223,372,036,854,775,8078 bytes0
Realsigned real±3.402823466E384 bytes0
(7 or 8 digits of precision)
Doublesigned real±1.7E3088 bytes0
(15 or 16 digits of precision)
Extendedsigned real±1.1E493210 bytes0
(19 or 20 digits of precision)
Short datemonth/year32,768BC to 32767AD4 bytesJanuary, 1000 AD
Long datemm/dd/yy32,768BC to 32767AD6 bytesJanuary 1, 2000000 BC
Date & Timemm/dd/yy/timeMac DateTimeRec14 bytesJanuary 1, 1904, 12:00:00AM
BooleanTrue/False0, 11 or 2 bytesFalse
HandleHandle to variableHandle8 + handle sizeNIL
length data
GeneralByte0 255min of 2 bytes0

From the previous example, if the individual contact information includes the company address information in the same view, then when the individual information is read, the company information is automatically read in. This built-in feature for relational databases is a BIG plus. It saves you plenty of coding. Views are a very powerful feature of ISO

The creation of views is the real weak point of the Schema Editor. In many places within the editor, you may drag an item over from one window to another to reduce typing duplicate information. Views are essentially duplicates of the record types you just created. Unfortunately it is here that you can’t drag a file type to a view type!

Another feature left out is the ability to shuffle around the fields of a file type or view after you have spent the time typing it in. I hope ISO is listening. These two features alone would improve the Schema Editor 200%.

Database Development

The next phase after creating the schema resources is to develop the database itself. ISO provides a large library of routines (a fact you’ll admit to as you add the many project libraries needed for compilation).

I will cover the following topics:

• Opening/Creating Databases

• Record Management

• Sets of Records

• Lock Management

• Miscellaneous Features

Opening and Creating Databases

Creating a new database or opening an existing database is as easy as opening up a file. You can assign a password to the database and specify a recovery mode at this point.

Database recovery is an extremely important issue. ISO has three types of recovery. No recovery means that transaction results are stored only in memory and actually written to the database when the transaction is completed, the memory buffer is full, or the buffer is flushed. This means that if the computer went down in the midst of a transaction, the database may be left in an unknown state.

Overflow recovery creates a physical file to keep transaction results that overflow when the memory buffer is full. This still has the possibility of losing information. Full protection keeps a full record of transactions in a physical file.

Normally when an operation is done, the results are written to the database. You may, for speed improvements, turn this off until a number of transactions have occurred and then flush this buffer. ISO contains recovery procedures to attempt to recover from a crash.

Table 2. Lock Compatibility

Record Management

Records are accessed by keys. Therefore you need to have at least one key to access records (a key can be one you defined, the insert record ID, or a connection key). To access records you do essentially the following:

1. Open the structure record file with the view you will be using.

2. Create and initialize a buffer to hold a record.

3. Select the key you will be using to access the records

4. Perform any operations needed such as finding, creating, modifying or deleting a record.

5. Release any locks that were created.

You can get to a particular record by reading the first, nth, or last record by key order. You can also find the first, last, or range of records by one or more key values. There are also many routines supplied for performing operations in looping conditions. For example, you could find the records that meet a particular criterion then delete the current record and automatically go to the next record that meets the find criterion.

Records may also be accessed in a non-sequential order by setting the current record to the record with a particular ID or address.

If a particular view is needed and is not defined in the current schema, you can dynamically create views with the needed fields and keys. These dynamically created views are temporary and are not permanently recorded in your resource fork. However, you can store these views in static blocks to be used the next time the application runs.

Records Sets

At first, I was a little confused about what sets were when I read the ISO manual. It gave me an idea of what they were, but it took me a couple of times through the manual to understand, and appreciate them more fully.

A set is simply a collection of records. Now if that seems a little obvious, let me rephrase that. A set is a structure that holds a collection of references to records in a defined order. This means that the structure does not normally hold the record data themselves. It may optionally hold an array of these collected records through a particular view, but it appears that this is really for temporary conditions such as when sorting the set.

You will use sets extensively in your search functions. ISO allows you to find records and add them to a particular set. You can then perform normal set operations with other sets such as unions, intersections, differences, and exclusive or’s. Finally, you can read the data, do the work necessary such as sorting, and release the memory to the data.

One feature that might be useful is a procedure to change the view the set is based on once the set is already built. I imagine that this routine could deallocate the memory associated with a set and change the view the set is based on. This would allow for dynamic changes of the view from a finding/sorting view to a working view. It looks like the routines are there to do it yourself, but I would rather not monkey around with structures when I don’t have complete knowledge of how they operate.

Lock Management

Lock management is a difficult issue among databases. Not only is there the overhead question associated with lock granularity (files and records may be locked with ISO and there is a method to lock fields), but with multiple users there is the problem of deadlocks. For example, a deadlock occurs in the following situation:

1. Person A locks record 1

2. Person B locks record 2,

3. Person A tries to get record 2 but fails since person B has record 2.

4. Person A then waits for Person B to record 2 to be released.

5. Person B tries to get record 1 but fails since person A has it.

6. Person B waits for person A to release record 1

DEADLOCK! These two people will wait forever since each has a resource the other needs to continue. The only recourse is for both to release their locks, wait a random amount of time, and try again.

To ensure database integrity, the safest approach is the following:

1. Attempt to gain the appropriate locks needed for all records involved in a transaction.

2. If you fail to obtain a lock, determine the reason.

a. Deadlock is detected

b. Someone else has a lock.

3. If there is a deadlock, you must release all your locks and try again.

4. If a person holds a lock, you may wait patiently and perhaps inform him of your need, or you can cancel the request.

5. If you gain all the locks you need, perform your operations quickly and release your locks.

ISO has a sophisticated method of locking and deadlock detection. There are many levels of locks. The routines that access the records have a lock parameter. You have the option of obtaining locks asynchronously. There are even routines to pass messages to other clients informing them of your need for a lock.

A lock may be requested for a file or a record. There are various lock types. Some locks may be compatible with other locks. This would allow multiple people to work on the same record/file at the same time. Table 2 shows lock permission compatibility and their meaning. To see if the locks are compatible, suppose person A has a lock on the record/file with one of the permission along the left-side of Table 2. If person B tries to lock the record/file with a permission across the top, then the lock is granted if the intersection of these 2 permissions is “Y”.

Locks may be issued on fields of a structured record file by creating a custom file lock constant. There is a maximum of 6 of these types of locks. Care must be taken that all applications that use the database honor the custom lock.

Miscellaneous Features

I have not even discussed half the features available in ISO. It is so rich in power that a single review can not cover every feature. Among them:

• There are sets of routines for managing unstructured files and static blocks.

• You can query and update a database structure. Unfortunately, there are no routines for updating the schema resources in your application.

• There are data encryption and compression routines.

• An advanced messaging system for multi-user support.

• Extensive debugging features like that of source level debuggers.

Purchase Price

I left the ISO’s purchase price last on my list of items to discuss. This package is not one of your “low-end” products. The purchase price for a single user development package is $595; for the multi-user package it is $795. I suggest that you buy the multi-user version.

Probably the biggest item that unsettled me was the royalties. Royalties on applications that use ISO are $35-$50 for corporate use, and 2-5% of revenue for commercial developers. So you will need to add this to the cost. I know I am quibbling over a small royalty when the product is so useful, but I feel that code resources, compilers, and the like should be royalty free.

I would like to reemphasize that ISO is fast and powerful. Products that are likely to require the powerful features of ISO are probably not going to quibble over royalties. Since ISO is very powerful, it can be very complex as well. ISO deals very well with the “complexity vs. power” issue. ISO makes simple tasks easy to implement. Yet, there are routines for those who wish to “run in where angels fear to tread.”

Conclusion

Inside Out II is an industrial strength database engine. It is designed for the creation of custom databases. There are no routines given to query foreign databases (using SQL for an example). The major weaknesses I felt include:

• The data dictionary is kept in the application and not with the database. A generic database application cannot easily examine databases and provide generic utilities.

• The Schema Editor is not very user-friendly.

• The product lacks hierarchical database examples.

• Your application is either multi-user with ISO’s LockServer application running, or it is single user.

The advantages I felt include:

• The view mechanism and its automatic look up of related records.

• Its simplicity in design.

• Its speed of operation.

• Its multi-user capability with messaging.

• Numerous hooks for developers.

I feel that ISO is the product for anyone developing applications with strong database needs. ISO’s price and power make it perfect for the developer audience it is aiming for.

For more information

Inside Out II

Sierra Software Innovations,923 Tahoe Blvd., Suite 102

Incline Village, NV 89451-9443

(702) 832-0300 or USA (800) 621-0631 for sales

Cost: Single User $595, Multi-user $795

(volume discounts available)

Royalties: $50/user (with special cases)

 
AAPL
$113.99
Apple Inc.
+1.98
MSFT
$47.88
Microsoft Corpora
-0.26
GOOG
$534.03
Google Inc.
+5.26

MacTech Search:
Community Search:

Software Updates via MacUpdate

Google Drive 1.18.7821.2489 - File backu...
Google Drive is a place where you can create, share, collaborate, and keep all of your stuff. Whether you're working with a friend on a joint research project, planning a wedding with your fiancé, or... Read more
Eye Candy 7.1.0.1203 - 30 professional P...
Eye Candy renders realistic effects that are difficult or impossible to achieve in Photoshop alone, such as Fire, Chrome, and the new Lightning. Effects like Animal Fur, Smoke, and Reptile Skin are... Read more
MegaSeg 5.9.4 - Professional MP3 DJ appl...
MegaSeg is a complete solution for pro audio/video DJ mixing, radio automation, and music scheduling with rock-solid performance and an easy-to-use design. Mix with visual waveforms and Magic... Read more
Parallels Desktop 10.1.2 - Run Windows a...
Parallels Desktop is simply the world's bestselling, top-rated, and most trusted solution for running Windows applications on your Mac. With Parallels Desktop for Mac, you can seamlessly run both... Read more
GarageSale 6.9.1 - Create outstanding eB...
GarageSale is a slick, full-featured client application for the eBay online auction system. Create and manage your auctions with ease. With GarageSale, you can create, edit, track, and manage... Read more
Quicksilver 1.2.2 - Application launcher...
Quicksilver is a light, fast and free Mac application that gives you the power to control your Mac with keystrokes alone. Quicksilver allows you to find what you need quickly and easily, then act... Read more
Mac DVDRipper Pro 5.0.1 - Copy, backup,...
Mac DVDRipper Pro is the DVD backup solution that lets you protect your DVDs from scratches, save your batteries by reading your movies from your hard disk, manage your collection with just a few... Read more
ClamXav 2.7 - Free virus checker, based...
ClamXav is a free virus checker for OS X. It uses the tried, tested, and very popular ClamAV open source antivirus engine as a back end. I hope you like and use ClamXav a lot and that it helps keep... Read more
FoldersSynchronizer 4.2 - Synchronize or...
FoldersSynchronizer is a popular and useful utility that synchronizes and backs-up files, folders, disks and boot disks. On each session you can apply special options like Timers, Multiple Folders,... Read more
Waltr 1.0.6 - Drag-and-drop any media fi...
WALTR is designed to make it easy to upload and convert any music or video file to an iPad or iPhone format for native playback. It supports a huge variety of media file types, including MP3, MP4,... Read more

Latest Forum Discussions

See All

Forget the Gloves – It’s a Cage Match in...
Forget the Gloves – It’s a Cage Match in Real Boxing’s Underground Update Posted by Jessica Fisher on December 23rd, 2014 [ permalink ] | Read more »
Who Wore it Best? Best of 2014
It’s the end of the year, so it’s time for some arbitrary internet awards! In this wrap-up episode of Who Wore it Best? we present our winners for the best, worst, and flat-out weirdest cloned games that graced the App Store in 2014. [ Who... | Read more »
Now You Can Explore Mayan Temples in Ass...
Now You Can Explore Mayan Temples in Assassin’s Creed Pirates’ Newest Update Posted by Jessica Fisher on December 23rd, 2014 [ permalink ] | Read more »
Soft Design aims to do free-to-play righ...
They say a team is only as big as its fans and that’s also certainly the case with video games, judging from the sales certain AAA ‘heavyweights’ get year-after-year. Soft Design took that principle as a core design philosophy and worked closely... | Read more »
Bogga Christmas Tree
Bogga Christmas Tree By Amy Solomon on December 23rd, 2014 Our Rating: Universal App - Designed for iPhone and iPad Bogga Christmas Tree allows young children to trim a tree, any time or place.   | Read more »
Opera Coast 4.0 Launches on iOS with 4 N...
Opera Coast 4.0 Launches on iOS with 4 New Features Posted by Jessica Fisher on December 23rd, 2014 [ permalink ] Universal App - Designed for iPhone and iPad | Read more »
Cricket Kids: Christmas Presents
Cricket Kids: Christmas Presents By Amy Solomon on December 23rd, 2014 Our Rating: Universal App - Designed for iPhone and iPad Cricket Kids: Christmas Presents allows children to play with digital toys opened for the Christmas... | Read more »
Lara Croft & Tomb Raider Mobile Bund...
Lara Croft & Tomb Raider Mobile Bundle – Only $4.99 Posted by Jessica Fisher on December 23rd, 2014 [ permalink ] Lara Croft is coming to you in | Read more »
SimCity BuildIt Review
SimCity BuildIt Review By Nadia Oxford on December 23rd, 2014 Our Rating: :: BUILDING AN OK TOMORROWUniversal App - Designed for iPhone and iPad SimCity BuildIt is a competent city-building game, but its free-to-play trappings are... | Read more »
SimCity Buildit – Tips, Tricks, and Stra...
Hello, Budding Mayors Want to know what we made of all this upgrading and inevitable waiting? Check out our SimCity BuildIt review! SimCity BuildIt is a city-building game from EA. Your job as mayor is to build houses for people to live in, industry... | Read more »

Price Scanner via MacPrices.net

Sony Fixing To Launch Large-Screen Android Ta...
Digitimes’ Aaron Lee and Joseph Tsai report that Sony, which last February exited the laptop computer market with the sale of its VIAO PC-making unit to a group of JApanese investors, is now expected... Read more
After Christmas sale: 13-inch Retina MacBook...
B&H Photo has new 13″ MacBook Pros on sale for up to $150 off MSRP as part of their Holiday pricing. Shipping is free, and B&H charges NY sales tax only: - 13″ 2.5GHz MacBook Pro: $1043 save... Read more
After Christmas sale: 15-inch Retina MacBook...
Adorama has 15″ Retina MacBook Pros on sale for up to $150 off MSRP. Shipping is free, and Adorama charges NY & NJ sales tax only: - 15″ 2.2GHz Retina MacBook Pro: $1899 save $100 - 15″ 2.5GHz... Read more
After Christmas sale: MacBook Airs for up to...
B&H Photo has 2014 MacBook Airs on sale for up to $120 off MSRP, for a limited time, for the Thanksgiving/Christmas Holiday shopping season. Shipping is free, and B&H charges NY sales tax... Read more
Apple now offering Certified Refurbished Mac...
The Apple Store is now offering Apple Certified Refurbished 2014 Mac minis, with models available starting at $419. Apple’s one-year warranty is included with each mini, and shipping is free: - 1.... Read more
Will Apple Build An A-series ARM Processor Po...
In computer terms, it’s been a very long time since the MacBook Air had a major redesign. More than four years have elapsed since Apple recast what had originally been more a pricy boutique device... Read more
iPhone 6s mini With Four-Inch Screen Rumored...
The Times of India’s Komal Mohan, citing a story in The Electronic Times of Taiwan, says that unnamed upstream supply chain sources report that Apple is gearing up to launch a new 4-inch screen... Read more
What’s The Current Value Of Your iOS Apps?
Basel, Switzerland based ConIT AG has announced AppZapp Notify and its free PC and Mac tool available for download. What is the present value of all my downloaded Apps? With AppZapp Notify, for the... Read more
PhatWare Releases WritePad Pro Advanced iOS W...
PhatWare Corporation has announced immediate availability of WritePad Pro 2.0, its advanced word processing, note-taking, and document management app which also takes full advantage of PhatWare’s... Read more
Last minute gift idea: Send an Apple Store Gi...
Send an Apple Store Gift Card by email this season, perhaps as a last minute Christmas gift. According to Apple, “Apple Store Gift Cards can be used to purchase Apple hardware and accessories at any... Read more

Jobs Board

Position Opening at *Apple* - Apple (United...
…Summary** As a Specialist, you help create the energy and excitement around Apple products, providing the right solutions and getting products into customers' hands. You Read more
Position Opening at *Apple* - Apple (United...
**Job Summary** Being a Business Manager at an Apple Store means you're the catalyst for businesses to discover and leverage the power, ease, and flexibility of Apple Read more
*Apple* Solutions Consultant (ASC) - Apple (...
**Job Summary** The ASC is an Apple employee who serves as an Apple brand ambassador and influencer in a Reseller's store. The ASC's role is to grow Apple Read more
Senior Event Manager, *Apple* Retail Market...
…This senior level position is responsible for leading and imagining the Apple Retail Team's global event strategy. Delivering an overarching brand story; in-store, Read more
*Apple* Store Leader Program (US) - Apple, I...
…Summary Learn and grow as you explore the art of leadership at the Apple Store. You'll master our retail business inside and out through training, hands-on experience, Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.