LakeHouse

It integrates data storage, SQL queries, analytical processing and access to data sets in different formats.

Key capabilities

A first look at what you can do with this product.

  1. Data query

    Answer questions about your data through reusable queries.

  2. Time travel

    Check previous versions and play analyses with the same context.

  3. Storage format

    Explore large data sets through analytical queries.

  4. Data dump

    Share results in formats that can be used by other areas and tools.

  5. Load of information

    Incorporate new data sets to put them at the service of analysis.

  6. integration

    Take the data to the analysis tools your organization already uses.

Features of LakeHouse

Choose a category or search across all product features. Browse the results page by page.

25 features

The search includes all categories.

All features

Technical features 5 features

Extended data types

Technical features

they have access to a wider range of data than the WareHouse data, allowing them to access system records, audio, video and files.

Data transmission

Technical features

allow real-time reporting when supporting online analytics, especially when used with integration products.

Schemes

Technical features

LakeHouse data applies schematics to data, which helps standardize large volumes of data.

BI compatibility and analysis

Technical features

Since data from a LakeHouse data goes through cleaning and integration, they are useful for analysis.

Open Architecture

Technical features

It describes an open architecture oriented to interoperability between technologies.

Data Lake 9 features

Semi-structured data format

Data Lake

open table format for large analytical data sets.

Data query

Data Lake

It allows you to consult data using SQL.

Hidden Partition

Data Lake

Manages data partitions without requiring the user to specify them in each query.

Evolution of Partitions

Data Lake

you can update the layout of a table as data volume or query patterns change.

Time travel

Data Lake

allows reproducible queries that use exactly the same table snapshot or allows users to easily examine changes.

version reversal

Data Lake

allows users to quickly correct problems by restoring tables to a correct state.

Advanced Filtering

Data Lake

Data files are reduced with column and partition level statistics, using table metadata.

Management of Versions

Data Lake

Object-level version control is a significant evolution compared to SAN and NAS version control approaches.

Governance and compliance

Data Lake

Maintains metadata and retention policies to support data governance.

Data WareHouse (Columnar Database) 5 features

Storage format

Data WareHouse (Columnar Database)

It uses column storage to optimize scanning and aggregation operations, improving query performance.

Indexing

Data WareHouse (Columnar Database)

It employs advanced indexing techniques, including bitmap and invert indexes, to accelerate query processing by allowing filtering and recovery.

query language

Data WareHouse (Columnar Database)

an SQL dialect designed for analytical queries, which allows users to perform complex aggregations and filtering with a familiar syntax.

Scalability

Data WareHouse (Columnar Database)

It features a distributed architecture with specialized nodes (e.g., Broker, Historical, Real Time, Coordinator) that can be scaled independently to handle...

Security

Data WareHouse (Columnar Database)

Includes authentication, role-based access control and LDAP integration.

Functional features 6 features

Query interface

Functional features

It provides a unified query interface from the browser.

Data dump

Functional features

Ability to dump queries into different file formats, CSV, JSON, XML.

Data download

Functional features

It allows you to publish a catalogue of compressed data downloads with categories and access configurable by users, organizations and permissions.

Load of information

Functional features

It allows you to load data sets via a web interface for processing in the warehouse or the data lake.

Access to the platform

Functional features

Allows access via encrypted web connection or VPN.

integration

Functional features

The system can be integrated via REST API with analytics systems such as Tableau and Power BI.

Part of the IFINDIT platform

Explore how it relates to other products and shared capabilities.

Persons and equipment

Consultation · Analysis · Information management

Sources of information

Documents and repositories
Databases
Applications and APIs

A functional view of IFINDIT and its shared capabilities. Each product connects different needs of the organization.

Download SVG diagram

Let's talk about your information.

Tell us what you need to find, analyze or organize. Discover IFINDIT with the Creangel team.

Image