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

Advertisements

How to modify information

No surprise that with various recording levels, Unidatab provides also various means of modifying information.  Let' start by looking at how we can change some input data and we'll admit that we should better act on properties and types. Changing data Since pure data is only entered once and not duplicated, we understand that changing … Continue reading How to modify 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

How to create a record

In the previous example we were trying to append a symbol to a record called 'myrecord'. Let's see how to create this record. We can do this conveniently through make_record(): ? select make_record('myrecord','test') -204 How does this new record, which only has a title and a format, look like: ? select send_full_record(-204,1) -204 63 -201 … Continue reading How to create a record

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

Structure of the node table 2: symbols

From the previous example we can extract ids that bear the function show_symbol. ? select show_record('unid_home') show_record('unid_home')        : i a d n t u -195 59 -195 -196 1355779205 admin -196 -170 -195 -198 1355779205 admin -198 -197 -196 -200 1362506937 admin -200 -199 -198 0 1365953523 admin Within records, the column named a … Continue reading Structure of the node table 2: symbols