180 likes | 302 Views
DiDP the emerging Database Standard Database Seminar. Karsten Noack, President & CEO. What we had. We hat to do everything by hand. ... but we used our data in a straightforward and uncomplicated manner. SCHEME „A“. SCHEME „A“. SCHEME „A“. SCHEME „A“. SCHEME „A“. Database.
E N D
DiDP the emerging Database Standard Database Seminar Karsten Noack, President & CEO
What we had ... We hat to do everything by hand .... ... but we used our data in a straightforward and uncomplicated manner.
SCHEME „A“ SCHEME „A“ SCHEME „A“ SCHEME „A“ SCHEME „A“ Database ... and what we got! Database applications are really highly useful ... ... as long nothing has to be changed !
Questions ... Why can we only communicate comfortably with data bases, if someone has written a program for exactly this specific communication? ? Is it really important to find a better way programming? Perhaps the program is the problem itself ? Do we need programmed applications at all?
What we need ... We need: • Flexibility for the user • Flexible, step-by-step development • Flexible (ad-hoc) access to data and functions and at the same time: • Restrictive business logic • High data security and availability • Centralized or decentralized data storage in relational databases
The conclusion ... It means, we need a logical 3 tier architecture ! Presentation (User Interface) Programmed Application Business Logic (Meta data) Database Database
meta data Direct processing ... The logical 3 tier architecture allows a “direct” processing of the data! Individual programming Direct Data Processing use of programmed applications prefabricated functionality rigidly programmed specialized application Fachdatenbank Fachdatenbank Fachdatenbank Fachdatenbank item database item database
DiDP - Basics The Principle of Direct Data Processing (DiDP) About 1000precompiled standardizedfunctions SCOPELAND meta data interpreter Client / Application Server Meta data ascontrol parameters for the standardized functions Database Server advanced meta data Structures, relations Properties Business logic Processing logic Workflow model
Finalize presentation layout The application generates itself in runtime Object view as a tree Save SCOPELAND applet applets DiDP - Basics How Direct Data Processing (DiDP) works Database as a relational net item database meta database advanced meta data
DiDP - Ad hoc access Ad hoc mode, not only for developers: flexibility for power users ! Read & Write, according to the application logic ! active data view Personal Scope Global Scope
DiDP - Applications Applications are linked applets, each maintains its flexibility ! applet applet applet applet applet applet
Workflow (status dependence of steps, defined status settings) Events / Steps (external processing steps: macros, programs,... internal steps: temporary “Enabling” of business rules) Business Rules (status depending operating rules and properties of data: calculations, settings, plausibility, warnings, proposals, rights, and privileges) Static Properties (description and classifying of data, status non-depending (general) properties of data, relations according to the ER-model Advanced Meta Data
Target The Range of Custom Database Applications SCOPELAND Excels Here Business Process Automation Management Information Custom Applications Information and decision oriented applications Operation and transaction oriented applications
Target Today´s Trend: Standard Software for Custom Applications SCOPELAND Excels Here Doc Management Up to now: 100 % individual programming ! Business Intelligence Office Autom - Workflow Data Warehouse Workflow Products Data Wareh. Products
Application Example Complex Information and Data Storage Systems OLAP-analyses, aggregation, transformation Item data business applications Ad-hoc access to all available data Ad-hoc- import/export Periodic import/export Aggregated Data Company Information hkh ? hkh Aggregated Data hkh Aggregated Data Evolutionary development bulk Data complex structures item data
Application Example Workflow-Technology for Item Data Applications Application of business processes based on process models Processing of structured item data Document- Management electronic files item data status data electronic archive
SCOPELAND SCOPELAND is the first full functioned DiDP application www.scopeland.com knoack@scopeland.com