Latest news from Factil

Factil to develop Proof of Concept for improving child safety

No comments

Factil is very pleased to announce that we have been awarded a grant to develop a Proof of Concept system for sharing information nationally to ensure child safety, under the Australian Government’s Business Research Innovation Initiative (BRII). The Proof of Concept grants were approved by the Minister for Industry, Innovation and Science, Minister Sinodinos, in September 2017.  The BRII set five challenges, sourced from Australian Government departments, to solve problems that do not have current commercial solutions.  Previously, Factil had successfully completed a feasibility study for the child safety challenge in this initiative, and the Proof of Concept grant was obtained through a competitive process based on the results of the feasibility study.

Factil’s Proof of Concept proposal was based on our world-leading technology and capability for information modeling, data integration and application development automation.  The Proof of Concept project will develop a secure, scalable, inter-agency data sharing system that provides matching, ranking and disclosure controls for information about children at risk and persons of interest.  When complete, the solution will significantly limit the danger faced by vulnerable children by providing a secure, scalable and easy to use mechanism to share relevant child safety information nationally.

For more about the BRII, please visit:
www.business.gov.au/BRII

To view the Minister’s media release, please visit:
https://prod-minister-industry-gov-au.industry.slicedtech.com.au/ministers/sinodinos/media-releases/nine-businesses-share-875-million-solve-government-policy-and

Graeme PortFactil to develop Proof of Concept for improving child safety
read more

Factil to present at Data Modeling Zone, Dusseldorf, Germany – 23 & 24 October 2017

No comments

Factil will be exhibiting and presenting a talk at the Data Modeling Zone Conference in Dusseldorf, Germany, 23 and 24 October 2017.

Graeme Port will be be speaking on the topic of “Fact-Based Data Integration“.

Full details about the conference can be found here.

Here is the abstract of the talk:

Fact-Based Modeling is an effective approach for defining the structure and semantics of stored data. We show that a fact-based integration language can be compiled into data transformation code for moving data in data warehouse environments.

We will apply this approach in Data Vault data warehouse environments and show that automated transformation code generation from a fact-based integration language reduces cost, contains fewer errors, and supports change and agility.

 

Graeme PortFactil to present at Data Modeling Zone, Dusseldorf, Germany – 23 & 24 October 2017
read more

Factil to present at DAMA Melbourne – 17 May 2017

No comments

Factil will be presenting a talk at the DAMA Melbourne meeting on 17 May 2017.

Graeme Port will be be speaking on the topic of “Fact-Based Data Integration“.

Full details and registration can be found here.

Here is the abstract of the talk:

Fact-Based Modeling is an effective approach for defining the structure and semantics of stored data. In this talk we will show that a fact-based integration language can be used to automatically generate integration code for moving data through an information supply chain.

We will apply this approach in two scenarios:

  • a Data Vault data warehouse environment, and
  • a project for sharing information nationally for child safety

We will show that automated integration code generation from a fact-based integration language reduces cost, contains fewer errors, and supports a high rate of change and agility.

If you are interested in getting a copy of the presentation of the talk, please get in touch with us at factil@factil.io

Graeme PortFactil to present at DAMA Melbourne – 17 May 2017
read more

Factil to conduct feasibility study for improving child safety

No comments

We are very pleased to announce that Factil has been awarded a grant to conduct a Feasibility Study for sharing information nationally to ensure child safety.  The grant was awarded through the Australian Government Business Research Innovation Initiative (BRII). The BRII programme set five challenges, sourced from Australian government departments, to solve problems that do not have current commercial solutions.  Factil was successful in a competitive process to obtain a feasibility study grant for the problem of sharing information between state- and territory-based community service agencies for matching and sharing information about children at risk and persons of interest so as to ensure child safety.

Factil’s feasibility study proposal was based on our world-leading technology and capability for information modeling, data integration and application development automation.  The feasibility study will focus on four areas of technical risk for the project:

  • Information security and sharing in compliance to Australian security and privacy legislation
  • Data extraction, matching and integration from Agency Systems
  • Agency application UI integration and ease of use
  • Accessibility in low-internet areas

The proposed solution will be scalable, provide a seamless experience to the users of existing systems, and demonstrate the cutting edge information modelling and data integration processes and technology developed by Factil.

Subject to a successful feasibility study, a Proof of Concept (POC) system will be developed to demonstrate how the solution will be used to facilitate information sharing between state- and territory-based community service agencies.  When complete, the solution will significantly limit the danger faced by vulnerable children by providing and secure, scalable and easy to use mechanism to share relevant child safety information nationally.

For more about the BRI program, please visit:

http://prod-minister-industry-gov-au.industry.slicedtech.com.au/ministers/sinodinos/media-releases/grants-support-innovative-ideas-small-and-medium-businesses

Graeme PortFactil to conduct feasibility study for improving child safety
read more

Factil to deliver Fact-Based Modeling Workshop – Canberra – 1 May 2017

No comments

Graeme Port will be delivering a full-day workshop on Fact-Based Modeling in Canberra Australia on 1 May 2017.

Traditional data modelling tools, textbooks and database management systems focus on Entity-Relation Modelling (ER Modelling).  This approach has been successful for modelling operational databases and some stages of data warehouses over several decades.  However, the demands of modern data environments are exposing significant limitations to this approach including: ease of comprehension, restrictions to relational-only data, limited capability for data integration definition and poor support for schema and code automation.

Fact-Based Modelling approaches and tools are emerging that provide:

  • Early development of easily understood data models
  • Inherent support for both relational (SQL) and non-relational (NoSQL) data
  • A powerful language for data integration business rules
  • Automated generation of both schema and transformation code across the full length of the information supply chain

Fact-Based Modelling starts from the perspective of typical business users and what they would say or write about their environment.  A defined method is applied to establish a formal information model of the environment that is precise, concise and expressed in the language of the business.  The information model applies equally well to relational and non-relational data.

From the information model, a wide range of outputs can be generated, including database schemas in different forms, data access APIs, meta data for the export to other modelling tools, and business documentation including business glossaries.

Data integration definition and automation is one of the biggest challenges in modern data environments.  With Fact-Based Modeling, the information model provides the vocabulary for implementation-independent data integration business rules.

Factil has pioneered the development of a web-based information modeling platform for the automatic generation of a wide range of schemas, APIs, metadata, transformation code and business documentation from fact-based information models and data integration logic.

In this training course, attendees will:

  • Be introduced to Fact-Based Modelling approach and how it contrasts and complements traditional ER Modelling
  • Learn the basic steps of the Fact-Based modelling process
  • Apply the process in the Factil web-based information modelling environment
  • Automatically generate range of schemas, APIs, metadata, transformation code and business documentation
  • Learn how these techniques can be applied in existing data environments and toolsets

Who should attend:

  • Business Analysts wishing to learn powerful information modelling techniques that can be used to support and formalise requirements gathering and verification
  • Data Modellers faced with the limitations of traditional data modelling approaches seeking more powerful tools for defining models and generating modelling outputs
  • Enterprise and Data architects faced with the challenges of integrating data from a range of internal and external sources and seeking a unifying framework and approach.
Graeme PortFactil to deliver Fact-Based Modeling Workshop – Canberra – 1 May 2017
read more

Company name change to Factil

No comments

With the start of the new year, Infinuendo has changed its name to Factil.

Factil is short for “Fact-based Information Logic” and represents the focus of the company on information modeling and data integration logic based on the Fact-Based Modeling approach.  The name is short, and (we hope) memorable.

Stay tuned for more announcements from Factil in 2017.

Graeme PortCompany name change to Factil
read more

Factil to present at Enterprise Data World – Atlanta – 6 April 2017

No comments

Factil will be presenting a talk at the Enterprise Data World conference in Atlanta Georgia USA on 6 April 2017.

Graeme Port will be be speaking on the topic of “Conceptual Data Transformation: Code Generation from Source to Information Mart“.

Brief Description:

Fact-Based Modeling is an effective approach for managing conceptual data semantics. We show that a Fact-Based Modeling conceptual query language can be used to automatically generate transformation code and build information marts in both Data Vault and cloud-based data warehouse environments.

Abstract:

A modern data architecture manages data in many different forms:

  • Normalized data
  • Non-relational data
  • Semi-structured data available from diverse sources and a range of formats
  • Data Vault data
  • Dimensional data in information marts for reporting/business intelligence

The variety of forms and volume of data means that data transformation is a complex and costly aspect of any modern data environment.

Previously we have shown that Fact-Based Modeling can be used as a unified modeling approach managing conceptual data semantics across all these different forms.  In this talk we will focus on showing that a Fact-Based Modeling conceptual query language can be used to automatically generate transformation code from source, through a data warehouse and to information marts. 

We will apply this approach in two distinct environments:

  • A traditional data warehouse based on Data Vault
  • A cloud-based data warehouse

and show that automated transformation code generation from a conceptual query language reduces cost, contains fewer errors, and supports change/agility.

Graeme PortFactil to present at Enterprise Data World – Atlanta – 6 April 2017
read more

Infinuendo to present at DAMA Canberra – 29 November 2016

No comments

Infinuendo will be presenting a talk at the DAMA Canberra meeting on 29 November 2016.

Graeme Port will be be speaking on the topic of “Data Modeling – the foundation of effective Data Management“.

Full details can be found here.

Here is the abstract of the talk:

Data Management is of critical concern to the Australian Federal Government. The Government has shown its commitment to transforming digital delivery and developing data skills and capability, though a wide range of initiatives and measures. These include the Australian Government Public Data Policy Statement and the recently announced APS Data Skills and Capability Framework.

Within data management, Data Modeling is concerned with discovering, analysing, and documenting the concepts, relationships, constraints and operations on data. The data model provides:

  • the core vocabulary for communication between business and IT regarding the structure and semantics of data,
  • the foundation all data management disciplines including data governance, data architecture, database development (relational and NoSQL), data integration, data warehousing and data quality, and
  • the essential meta-data for sharing and using data within an organisation, for managing the data received by an organisation, and for making open data useful.

To get the data right, business needs to understand and verify data models as much as IT. To truly understand the capabilities and limits of a BI system, you need to have at least a rudimentary concept of the way your data is structured, from a conceptual viewpoint. The same applies to anyone attempting to work with Open Data.

Today, for many data projects, appropriate data modeling is carried out too late in a project or as an afterthought. We will present an alternative approach, where data modeling is first carried out at the requirements stage of the project, and provides benefits to stakeholder engagement, building a system fit-for-purpose, and commercial arrangements for later stages. This approach uses an advanced form of data modeling that delivers useful artefacts from the requirements stage through to implementation.

DAMA is the world-wide leading organisation of data management professionals. Data Modeling is one of the key functions of the DAMA Data Management Body of Knowledge. The DAMA Canberra Branch is sponsoring Steve Hoberman, one of leading educators in the world to Canberra in February 2017 to present his Data Modeling Master Class, and Advanced Data Modeling Challenges Workshop.

 

If you are interested in getting a copy of the presentation of the talk, please get in touch with us at infinuendo@infinuendo.com

Graeme PortInfinuendo to present at DAMA Canberra – 29 November 2016
read more

Infinuendo to present at Data Modeling Zone – Berlin and Portland – October 2016

No comments

Infinuendo will be presenting at the two upcoming Data Modeling Zone conferences – Berlin, Germany, 11 October 2016, and Portland, Oregon, 19 October 2016.

Cliff will be be speaking on the topic of “How to compose a fact-based model into any kind of schema” at both conferences.

Here is the abstract of the talk:

Fact-based modeling is not just a powerful business communication tool, it is the one true ring of power for the data modeler. By working with a fully decomposed schema in “elementary form”, we avoid making a commitment to any particular kind of composite schema. This presentation will show how different composition rules applied to a fact-based schema will generate an entity-relational, star, snowflake, hierarchical, object-oriented, XML or graph schema.

Cliff will also be presenting a workshop on the topic of “Business Information Modeling using the fact-based approach” at the Portland conference.

Most modeling languages are effective for communicating only with people who have been trained to read and interpret the details. However, fact-based languages are deeply rooted in natural speech. They build a complete vocabulary for the business – not just a glossary of terms – and can be used directly with untrained business personnel. This radically improves the depth and breadth of the business dialogue.

As each new fact is encountered, the modeler adds appropriate elements to an Object Role Model diagram, which makes it easy to verbalize to natural language. Alternatively, the new fact can be expressed directly in the structured natural language form of the Constellation Query Language, which is immediately readable to business users but can also be understood by the computer. This makes it possible to describe any factual situation precisely, to ask or answer any factual question, and to elaborate detailed business rules about possible or allowable situations.

This presentation will introduce you to the approach and to these two languages, peeking at the respective software tools which generate physical schemas. A group exercise will challenge you to apply it to model a sample problem. The attendee will learn to use verbalization and fact-based analysis to understand any subject material, and to communicate it at a deep conceptual level with those less expert in the field.

If you are interested in getting a copy of the presentation of the talk, please get in touch with us at infinuendo@infinuendo.com

Graeme PortInfinuendo to present at Data Modeling Zone – Berlin and Portland – October 2016
read more

Infinuendo to present at Enterprise Data World – San Diego – 20 April 2016

No comments

Infinuendo will present at the 2016 Enterprise Data World Conference in San Diego on the topic of “Conceptual Modeling for Data Vaults”.

Here is the abstract of the talk:

Data Vault has become a key technology in the enterprise data pipeline because it is focused on business needs, provides an agile and manageable integration process, and meets historical reporting requirements. A modern architecture manages enterprise data in multiple different forms:

* Normalized data held in operational systems
* Semi-structured data available from diverse sources
* Data Vault data in the enterprise data warehouse
* Dimensional data in data marts for reporting/business intelligence

None of these forms provides a viable solution to the problem of managing data semantics throughout the lifecycle, which leads to the resultant transformation processes being slow, ad-hoc and degrading the value of the data asset. We show how Fact-Based Modeling can be used as a unified modeling approach that maintains conceptual integrity across the entire data lifecycle.  Because a Fact-Based Model is more fully decomposed than other forms of model, it can be used as a Rosetta Stone to describe all the other composite forms. We can generate the transformations required to perform a Data Vault “decomposition” from the source systems. In fact, all forms of decomposition and re-composition can be unified around the underlying semantics of the conceptual data model, including the design of normalized, messaging, vault or dimensional schemas, and the generation of ETL code to transform between these forms.

If you are interested in getting a copy of the presentation, please get in touch with us at infinuendo@infinuendo.com

Graeme PortInfinuendo to present at Enterprise Data World – San Diego – 20 April 2016
read more