Open and Closed Programming Worlds.

The perils of Vivek Haldar – his article (http://blog.vivekhaldar.com/post/5542454900/the-perils-of-closed-worlds) covers the idea that a computer language or system can be a closed or open world.

To some extent, this is true. For instance, JAVA can be considered a closed world, as it has it’s own tool set and virtual machine. Vivek uses Unix as the example of a open world, a loosely coupled system of programs and utilities which can be split apart and run on multiple systems; Unix being only one of many.

The multivalued database systems definitely fall into the closed world category. Considering that the heritage of all mvdbms comes from PICK, which was a standalone operating system with a database and programming tools added. Is this an issue? Vivek considers that all closed worlds eventually die; the multivalued market is not large, but also not dead yet. But then, it is so closed, that only VAR’s can get full access to development tools anyway. Maybe this is how it has survived for so long.

On another note, the Programming as Theory-Building sounds very interesting.

This content is published under the Attribution-Noncommercial-No Derivative Works 3.0 Unported license.

Posted in Uncategorized | Leave a comment

What happened in 1986?

I have been rather busy of late, doing a bit of reading and a lot of research regarding the NF² or The Nested Relational Model.

While browsing my old Universities library last year, I discovered an old text book on the subject of Object-Oriented Database Management by Kemper & Moerkotte. What is of real interest is that “Chapter 6 – Extensions of Relational DBMSs” has a rather good coverage of the “6.6 – The Nested Relational Model NF2″ with a bunch of references or citations to papers all written around about 1986.

So, what happen within the database academic world in the mid 1980′s that NF² was all the rage?

Continue reading

This content is published under the Attribution-Noncommercial-No Derivative Works 3.0 Unported license.

Posted in General, mvdbs, Publications, RANT, SQL, Technologies | Tagged , | Leave a comment

Document Paradigm in UniBasic

Yet again, while running around the great inter-web, I found an interesting article which compares different database paradigms. The comparisons provided are between relational, document, key/value, and column-oriented databases. This lead me to thinking back to a comment that someone recently said to me that they use UniVerse as a document store database.

At the time, I thought – what the … But then again, there just might be something in this:

Continue reading

This content is published under the Attribution-Noncommercial-No Derivative Works 3.0 Unported license.

Posted in Idea!, mvdbs, SystemBuilder, Techniques, UniBasic | Tagged , , | Leave a comment

Microsoft to standardize NoSQL?

An interesting news item from Computer World points to an article in the ACM magazine about Microsoft wanting to standardize NoSQL – similar to SQL (Structured Query Language) and how this gained traction for relational databases.

This also leads to what a NoSQL database actually is – and is U2 a NoSQL database?

I personally believe that U2 and PICK type databases , in general, are not NoSQL.

They are DDERDBMS – Dictionary Driven Entity Relationship DataBase Management Systems.

Just rolls off the tongue…

This content is published under the Attribution-Noncommercial-No Derivative Works 3.0 Unported license.

Posted in General | Tagged | Leave a comment

Free eBook on Database Team Development

Well, the focus of the book is on Microsoft SQL-Server, but there are some ideas there, which may be of interest to U2 people.

Have a look at – http://www.red-gate.com/products/sql-development/sql-source-control/entrypage/assets/RG_Guide_to_SQL_Server_Dev.pdf

This content is published under the Attribution-Noncommercial-No Derivative Works 3.0 Unported license.

Posted in Free-bees, Publications, SQL, Techniques | Leave a comment

Knuth Humor

I recently purchased Donald Knuth’s ‘The Art of Computer Programming: Volume 3: Sorting and Searching”.  It’s a heavy read, but has some rather good bits.

Also Knuth has a sense of humor which lightens the reading a wee bit, so I am glad to find an article which lists one-liner jokes about Knuth – http://jjinux.blogspot.com/2011/03/humor-donald-knuth-jokes.html

This content is published under the Attribution-Noncommercial-No Derivative Works 3.0 Unported license.

Posted in Blogroll, General | Tagged | Leave a comment

How to time travel with @DATE

Way back in Feb. 2008, I started to write this article about an interesting @DATE pass-by-reference issue. Then I got sidetracked. So, this bug existed in whatever version was trialware at that time.

Guess what? It still exists in 10.3.7.0 on MS-Windows. So, here is how to time travel with @DATE.

Continue reading

This content is published under the Attribution-Noncommercial-No Derivative Works 3.0 Unported license.

Posted in Bugs, Code, mvdbs, U2, unFeature, UniBasic | Tagged , , , | Leave a comment

Cult of Excel

I have written about the use of MS-Excel before (see related posts at end), so an article on the weirder uses of MS-Excel is not out of order- http://www.computerworld.com/s/article/9211699/Use_Microsoft_Excel_for_Nearly_Everything .

As most IT people have found, I also repeatedly find MS-Excel used for all sorts of patchwork business processes. Some have even been clever. But the MS-Excel silo issue always raises it ugly head.

This content is published under the Attribution-Noncommercial-No Derivative Works 3.0 Unported license.

Posted in General, Techniques | Tagged | Leave a comment

DRY Subroutines

The principle of DRY has been around for sometime. When applied to the PICK/U2 environment, there are two main methods of implementation via routines – internal subroutines (GOSUB) and external subroutines (SUBROUTINE/FUNCTION).

But the relationship between these two methods and in particular between SUBROUTINE and FUNCTION is rather interesting.

Continue reading

This content is published under the Attribution-Noncommercial-No Derivative Works 3.0 Unported license.

Posted in Code, Idea!, mvdbs, SystemBuilder, Techniques, UniBasic, UniVerse | Tagged , , | Leave a comment

UniVerse 11.1 Non-Feature Alert

Within the New Features documentation of UniVerse 11.1 is a section call Miscellaneous New Features which explains how to use a subroutine within a indexed field for auditing – index-based subroutines! This method of calling a subroutine during file access is suggested as a light-weight alternative to triggers.

Do Not Do This.

Rocket Software have released a U2 Techconnect Alert regarding a similar process,  as usage may result in locks which do not release.

It’s a pity, as I thought that the idea was interesting and had some uses.

And it’s nice of them to make it public rather than a VAR only tech note.

This content is published under the Attribution-Noncommercial-No Derivative Works 3.0 Unported license.

Posted in Bugs, mvdbs, News Items, Rocket Software, unFeature | Tagged , | Leave a comment