Dbank

Time Series Database Management
For Microsoft Windows.

Additional Features

> Time Series Object Model

> XLA Add-in for Ms Excel

> SQL Engine

> Data Warehousing

 

 

DBank's Time Series Object Model

When Dbank is installed in Windows 9x/NT, the setup program installs a dynamic link library (“readdb.dll”) which defines a time-series object (COM) that can be used from Microsoft Visual Basic, Visual Basic for Applications, Power Builder, and Visual C++.

Dbank’s time-series object essentially extends these languages so that they can define, understand, and manipulate Dbank time-series objects directly

Much like one would define an integer in Microsoft Visual Basic, the time-series object enables a programmer to define a “time-series” object with predefined attributes, rules and procedures.

These attributes and procedures allow a programmer to create Dbank data banks, revise existing time series in a data bank, extract fundamental properties of these series, and manipulate a set of time-series as a unit. More importantly, the full power of these languages can be used to directly manipulate time-series saved in Dbank data banks.

Accessing Dbank’s Time-Series Object From VB/VBA

Before you can access Dbank’s time-series object model, you need to (a) install Dbank; and (b) activate a reference to the dynamic link library that actually defines the object (“readdb.dll”, typically saved in the Windows system area).

From VB, click on “Project”, then “References” and select “Read and Write Dbank Time Series Files” by checking the appropriate check box.

From VBA (e.g., Microsoft Excel), click on “Tools”, followed by “References” and select “Read and Write Dbank Time Series Files”.

Defining a Time-Series Object From Visual Basic/Visual Basic for Applications

Dbank’s time-series object is called “dbTimeSeries”. Much like any other objects in Visual Basic, VB/VBA’s Dim statement is used to declare a new time-series object. Thus:

Dim X as New dbTimeSeries

Reading/Writing Dbank Time-Series Variables

A fully qualified time-series name in Dbank has the following form (optional components are indicated using {}):

{<ServerName>}Database{:}{[Group]}SeriesName

where:

<ServerName> = Name of an accessible Microsoft SQL Server, e.g., <ORION>

Database = Name of the SQL or Access database to store the time-series

Group = time-series group or container

SeriesName = time-series name

If <ServerName> is omitted, Dbank user the Microsoft Access engine to store time series. For example,

“c:\Program Files\Dbank32\example[ace]a”

implies that the time-series “a” can be found in the Microsoft Access database

“c:\Program Files\Dbank32\example.mdb”

in the group called “[ace]”. As another example,

“<ORION>example[ace]a”

implies that the time-series “a” can be located in the database “example” that exists on the Microsoft SQL Server called “ORION”. Again, the time-series belongs to the group called “[ace]”.

Reading the series is then a simple matter of invoking the object's Read method, viz

X.Read

Saving an object is equally simple. The programmer needs to invoke the save object:

X.Save

For further instruction, download:

>Dbank's Time Series Object Model (PDF Manual)

 

| Copyright © 1994-2011 | TSDM Pte Ltd | Time Series Data Management for Windows | Contact TSDM |