Git Product home page Git Product logo

steema-bi-samples's Introduction

TeeBI

Datamining, Visualization, Machine-Learning, Big data

What is TeeBI ?

A simple class to implement in-memory database complex structures to provide:

  • Ultra fast speed (every column or field is a simple array)

  • Import data from files, databases, objects (ORM) in one or few lines of code

  • Automatic relationships between columns (master-detail), indexes and foreign keys

  • SQL-like high-speed queries and summaries by code or "select" scripts

  • Geographic database (Countries, States, Provinces...) to automatically create summary queries and TeeChart world maps

  • Transparent remote web server fast data access (compressed binary streams)

  • Automatic visualizations of complex structures (charts, grids and more)

  • Interactive Dashboards rendered to screen (desktop and mobile) and HTML Web pages

  • Data export (csv,pdf,html,xml,excel,json), comparisons and manipulations

  • Machine-learning and statistics (native data pass to R Language and Python Scikit)

  • Big-data ready, billions of cells supported

  • Multi-platform (Windows, Mac OSX, Android, iOS, Linux and more)

  • Supported development environments:

    • Embarcadero RAD Studio 11.3 Alexandria, and from Studio XE4 and up (Delphi and C++)
    • Lazarus / FreePascal

Getting started

Related

steema-bi-samples's People

Contributors

davidberneda avatar ladyviolet86 avatar pepjorge avatar yerayalonso avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

steema-bi-samples's Issues

Delay-loaded TDataset import

A boolean parameter in TBIDB Import method to not load all Dataset records, but just create and return a TDataItem filled with the structure of the Dataset (fields and subfields).

In this delayed mode, records will be loaded just-in-time when they are necessary (for example when calculating a query or presenting the TDataItem on a grid or chart).

This mechanism is already working when loading TDataItem from a binary file or stream (mydata.databi) so it should be easy to implement for both TDataSet and TConnection sources. The only issue here is the source dataset might be closed or destroyed before data has been loaded, in that case the TDataItem should not attempt to load data and just keep itself empty.

Refreshing the data items is also very easy, just call MyData.UnloadData and the internal delay-load flag will be reset, the data item will be emptied, and it'll load a new refreshed copy of the database data the next time is necessary

TObjectExpression support for complex expressions

TObjectExpression currently supports Object + field or property ( Edit1, 'Text' )

The enhancement is to support free expressions like:

'Button1.Width * 42 + (Panel1.Position.X / 3)'

A possible syntax:
var E : TExpression;
E:= TObjectExpression.From(Self, ' ......the expression...');
Caption:= E.Value;

The "Self" parameter is the "root" starting object, collection or component where to look for references in the expression (in this example, the Form owner of Button1 and Panel1)

Not installing

First, can't find TeeBIRecompile.exe.
Then when trying to install in Delphi XE6 errors apears in BI.Arrays.pas
[dcc32 Error] BI.Arrays.pas(644): E2029 Declaration expected but end of file found
and more after them.

Is it a jok?

Is it a jok?
All Pascal end with implantation !!
No souce

TeeBI.bpl build errors because of empty implementation section in the units

TeeBI.bpl build errors because of empty implementation section in the units:

[dcc32 Error] BI.Arrays.pas(541): E2029 Declaration expected but end of file found
[dcc32 Error] BI.Arrays.pas(58): E2065 Unsatisfied forward or external declaration: 'TDataOrderHelper.ToString'
[dcc32 Error] BI.Arrays.pas(69): E2065 Unsatisfied forward or external declaration: 'TDataMap.Clear'
[dcc32 Error] BI.Arrays.pas(70): E2065 Unsatisfied forward or external declaration: 'TDataMap.Count'
[dcc32 Error] BI.Arrays.pas(79): E2065 Unsatisfied forward or external declaration: 'TInt32Map.GetItem'
[dcc32 Error] BI.Arrays.pas(83): E2065 Unsatisfied forward or external declaration: 'TInt32Map.AddMap'
[dcc32 Error] BI.Arrays.pas(84): E2065 Unsatisfied forward or external declaration: 'TInt32Map.AsString'
[dcc32 Error] BI.Arrays.pas(85): E2065 Unsatisfied forward or external declaration: 'TInt32Map.Clear'
[dcc32 Error] BI.Arrays.pas(86): E2065 Unsatisfied forward or external declaration: 'TInt32Map.Find'
[dcc32 Error] BI.Arrays.pas(93): E2065 Unsatisfied forward or external declaration: 'TInt64Map.GetItem'
[dcc32 Error] BI.Arrays.pas(97): E2065 Unsatisfied forward or external declaration: 'TInt64Map.AddMap'
[dcc32 Error] BI.Arrays.pas(98): E2065 Unsatisfied forward or external declaration: 'TInt64Map.AsString'
[dcc32 Error] BI.Arrays.pas(99): E2065 Unsatisfied forward or external declaration: 'TInt64Map.Clear'
[dcc32 Error] BI.Arrays.pas(100): E2065 Unsatisfied forward or external declaration: 'TInt64Map.Find'
[dcc32 Error] BI.Arrays.pas(107): E2065 Unsatisfied forward or external declaration: 'TSingleMap.GetItem'
[dcc32 Error] BI.Arrays.pas(111): E2065 Unsatisfied forward or external declaration: 'TSingleMap.AddMap'
[dcc32 Error] BI.Arrays.pas(112): E2065 Unsatisfied forward or external declaration: 'TSingleMap.AsString'
[dcc32 Error] BI.Arrays.pas(113): E2065 Unsatisfied forward or external declaration: 'TSingleMap.Clear'
[dcc32 Error] BI.Arrays.pas(114): E2065 Unsatisfied forward or external declaration: 'TSingleMap.Find'
[dcc32 Error] BI.Arrays.pas(121): E2065 Unsatisfied forward or external declaration: 'TDoubleMap.GetItem'
[dcc32 Error] BI.Arrays.pas(125): E2065 Unsatisfied forward or external declaration: 'TDoubleMap.AddMap'
[dcc32 Error] BI.Arrays.pas(126): E2065 Unsatisfied forward or external declaration: 'TDoubleMap.AsString'
[dcc32 Error] BI.Arrays.pas(127): E2065 Unsatisfied forward or external declaration: 'TDoubleMap.Clear'
[dcc32 Error] BI.Arrays.pas(128): E2065 Unsatisfied forward or external declaration: 'TDoubleMap.Find'
[dcc32 Error] BI.Arrays.pas(136): E2065 Unsatisfied forward or external declaration: 'TExtendedMap.GetItem'
[dcc32 Error] BI.Arrays.pas(140): E2065 Unsatisfied forward or external declaration: 'TExtendedMap.AddMap'
[dcc32 Error] BI.Arrays.pas(141): E2065 Unsatisfied forward or external declaration: 'TExtendedMap.AsString'
[dcc32 Error] BI.Arrays.pas(142): E2065 Unsatisfied forward or external declaration: 'TExtendedMap.Clear'
[dcc32 Error] BI.Arrays.pas(143): E2065 Unsatisfied forward or external declaration: 'TExtendedMap.Find'
[dcc32 Error] BI.Arrays.pas(153): E2065 Unsatisfied forward or external declaration: 'TDateTimeMap.GetItem'
[dcc32 Error] BI.Arrays.pas(157): E2065 Unsatisfied forward or external declaration: 'TDateTimeMap.AddMap'
[dcc32 Error] BI.Arrays.pas(158): E2065 Unsatisfied forward or external declaration: 'TDateTimeMap.AsString'
[dcc32 Error] BI.Arrays.pas(159): E2065 Unsatisfied forward or external declaration: 'TDateTimeMap.Clear'
[dcc32 Error] BI.Arrays.pas(160): E2065 Unsatisfied forward or external declaration: 'TDateTimeMap.Find'
[dcc32 Error] BI.Arrays.pas(172): E2065 Unsatisfied forward or external declaration: 'TTextMap.GetItem'
[dcc32 Error] BI.Arrays.pas(176): E2065 Unsatisfied forward or external declaration: 'TTextMap.AddMap'
[dcc32 Error] BI.Arrays.pas(177): E2065 Unsatisfied forward or external declaration: 'TTextMap.AsString'
[dcc32 Error] BI.Arrays.pas(178): E2065 Unsatisfied forward or external declaration: 'TTextMap.Clear'
[dcc32 Error] BI.Arrays.pas(179): E2065 Unsatisfied forward or external declaration: 'TTextMap.Find'
[dcc32 Error] BI.Arrays.pas(187): E2065 Unsatisfied forward or external declaration: 'TBooleanMap.AsString'
[dcc32 Error] BI.Arrays.pas(275): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Append'
[dcc32 Error] BI.Arrays.pas(276): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Append'
[dcc32 Error] BI.Arrays.pas(277): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Compare'
[dcc32 Error] BI.Arrays.pas(278): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Copy'
[dcc32 Error] BI.Arrays.pas(279): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Copy'
[dcc32 Error] BI.Arrays.pas(280): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Count'
[dcc32 Error] BI.Arrays.pas(281): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Delete'
[dcc32 Error] BI.Arrays.pas(282): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Empty'
[dcc32 Error] BI.Arrays.pas(283): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.ExistsBefore'
[dcc32 Error] BI.Arrays.pas(284): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Insert'
[dcc32 Error] BI.Arrays.pas(285): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Map'
[dcc32 Error] BI.Arrays.pas(286): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Resize'
[dcc32 Error] BI.Arrays.pas(287): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Sort'
[dcc32 Error] BI.Arrays.pas(288): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Sort'
[dcc32 Error] BI.Arrays.pas(289): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Stats'
[dcc32 Error] BI.Arrays.pas(290): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Swap'
[dcc32 Error] BI.Arrays.pas(291): E2065 Unsatisfied forward or external declaration: 'TBooleanArrayHelper.Zero'
[dcc32 Error] BI.Arrays.pas(296): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.GuessOrder'
[dcc32 Error] BI.Arrays.pas(298): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Append'
[dcc32 Error] BI.Arrays.pas(299): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Append'
[dcc32 Error] BI.Arrays.pas(300): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Copy'
[dcc32 Error] BI.Arrays.pas(301): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Copy'
[dcc32 Error] BI.Arrays.pas(302): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Count'
[dcc32 Error] BI.Arrays.pas(303): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Delete'
[dcc32 Error] BI.Arrays.pas(304): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Empty'
[dcc32 Error] BI.Arrays.pas(305): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.ExistsBefore'
[dcc32 Error] BI.Arrays.pas(306): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.IndexOf'
[dcc32 Error] BI.Arrays.pas(307): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.IndexOf'
[dcc32 Error] BI.Arrays.pas(308): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Insert'
[dcc32 Error] BI.Arrays.pas(309): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Map'
[dcc32 Error] BI.Arrays.pas(310): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.MaxLength'
[dcc32 Error] BI.Arrays.pas(311): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Resize'
[dcc32 Error] BI.Arrays.pas(312): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Sort'
[dcc32 Error] BI.Arrays.pas(313): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Sort'
[dcc32 Error] BI.Arrays.pas(314): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Stats'
[dcc32 Error] BI.Arrays.pas(315): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Swap'
[dcc32 Error] BI.Arrays.pas(316): E2065 Unsatisfied forward or external declaration: 'TTextArrayHelper.Zero'
[dcc32 Error] BI.Arrays.pas(321): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Distribution'
[dcc32 Error] BI.Arrays.pas(322): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.GuessOrder'
[dcc32 Error] BI.Arrays.pas(324): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Append'
[dcc32 Error] BI.Arrays.pas(325): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Append'
[dcc32 Error] BI.Arrays.pas(326): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Copy'
[dcc32 Error] BI.Arrays.pas(327): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Copy'
[dcc32 Error] BI.Arrays.pas(328): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Count'
[dcc32 Error] BI.Arrays.pas(329): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Delete'
[dcc32 Error] BI.Arrays.pas(330): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Empty'
[dcc32 Error] BI.Arrays.pas(331): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.ExistsBefore'
[dcc32 Error] BI.Arrays.pas(332): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Insert'
[dcc32 Error] BI.Arrays.pas(333): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Map'
[dcc32 Error] BI.Arrays.pas(334): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Maximum'
[dcc32 Error] BI.Arrays.pas(335): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Mean'
[dcc32 Error] BI.Arrays.pas(336): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Minimum'
[dcc32 Error] BI.Arrays.pas(337): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Resize'
[dcc32 Error] BI.Arrays.pas(338): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Sort'
[dcc32 Error] BI.Arrays.pas(339): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Sort'
[dcc32 Error] BI.Arrays.pas(340): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Stats'
[dcc32 Error] BI.Arrays.pas(341): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.StdDeviation'
[dcc32 Error] BI.Arrays.pas(342): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Swap'
[dcc32 Error] BI.Arrays.pas(343): E2065 Unsatisfied forward or external declaration: 'TDateTimeArrayHelper.Variance'
[dcc32 Fatal Error] BI.Arrays.pas(344): E2226 Compilation terminated; too many errors

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.