Back to subdatabases, with tools

Our last query ? select find_record(i) from unid_node where a = -145 limit 2 was fast enough in reaching records containing a certain type of property, provided we added a generic partial symbol (-145) targeting this type. Now we must notice that it's exactly what does a subdatabase. No need to describe our properties for … Continue reading Back to subdatabases, with tools

Advertisements

A golden ratio of data management

Until now we learned that Unidatab is a complicated engine that makes the act of looking for information slower and clumsier. Our last query for instance involved isolating a set of values sharing the same type from a much larger set (symbols). This kind of query is slow when the sets are numerous. No comparison with a classical db. … Continue reading A golden ratio of data management

How to retrieve information

Defining good and better ways of extracting information from an SQL base is a field of investigation in itself, however there are some peculiarities in the structure of Unidatab, that make it unexpected to people used to classical SQL databases. What kinds of output can we then expect from Unidatab? In this post we are … Continue reading How to retrieve information

More about properties and types

As we can grasp it now the node table is mess: nodes don't appear in the order of their chain but according to the moment in which they were created. Though located in another table, symbols look like nodes but constitute another type of entry. But of what types are we talking about in this … Continue reading More about properties and types

How to delete a record: flyers and junk

? select remove_record(-214) 4 This function takes care of cleaning the base (more precisely the symbol table) from occurences of the deleted record, replacing them by 0. It only accepts valid record ids (identification numbers) and returns the number of nodes deleted (not the number of nodes modified). Flyers and junks The record contains symbols … Continue reading How to delete a record: flyers and junk

Structure of the node table 3: more about symbols

In the previous example we saw a symbol and discovered that a symbol is similar to an  entry of the node table: ? select show_symbol(-170): i a d n t u -170 53 1 0 1355779205 admin #Unid default set ? select * from unid_symbol where i = -170 a    d    i    n    t    u   … Continue reading Structure of the node table 3: more about symbols