didp the emerging database standard database seminar
DESCRIPTION
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. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/1.jpg)
DiDP the emerging Database Standard Database Seminar
Karsten Noack, President & CEO
![Page 2: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/2.jpg)
What we had ...
... but we used our data in a straightforward and uncomplicated manner.
We hat to do everything by hand ....
![Page 3: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/3.jpg)
SCHEME „A“
SCHEME „A“
SCHEME „A“
SCHEME „A“
SCHEME „A“
Database applications are really highly useful ...
Database
... and what we got!
... as long nothing has to be changed !
![Page 4: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/4.jpg)
??Why can we only communicate comfortably with data bases, if someone has written a program for exactly this specific communication?
Questions ...
Is it really important to find a better way programming?Perhaps the program is the problem itself ?
Do we need programmed applications at all?
![Page 5: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/5.jpg)
What we need ...
Flexibility for the user
Flexible, step-by-step development
Flexible (ad-hoc) access to data and functions
Restrictive business logic
High data security and availability
Centralized or decentralized data storage in relational databases
and at the same time:
We need:
![Page 6: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/6.jpg)
The conclusion ...
Presentation(User Interface)
Business Logic(Meta data)
DatabaseDatabase
ProgrammedApplication
It means, we need a logical 3 tier architecture !
![Page 7: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/7.jpg)
Direct Data Processing
Fachdatenbank
Fachdatenbank
Fachdatenbank
Fachdatenbank
Individual programming
rigidly programmed specialized application
prefabricatedfunctionality
item database item database
use of programmedapplications
Direct processing ...
The logical 3 tier architecture allows a “direct” processing of the data!
meta data
![Page 8: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/8.jpg)
SCOPELANDmeta data interpreter
Structures, relationsPropertiesBusiness logicProcessing logicWorkflow model
Client / Application Server
Database Server
About 1000 precompiled standardized functions
Meta data as control parameters for the standardized functions
advancedmeta data
The Principle of Direct Data Processing (DiDP)
DiDP - Basics
![Page 9: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/9.jpg)
item database meta database
Database as a relational net
Object view
as a tree
advancedmeta data
How Direct Data Processing (DiDP) works
DiDP - Basics
The applicationgenerates itself
in runtime
applets
SaveSCOPELAND
applet
Finalizepresentation layout
![Page 10: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/10.jpg)
active data view
Personal Scope
Global Scope
Ad hoc mode, not only for developers:
flexibility for power users !
DiDP - Ad hoc access
Read & Write,according to the application logic !
![Page 11: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/11.jpg)
appletapplet
applet appletapplet
applet
DiDP - Applications
Applicationsare linked applets,each maintains its flexibility !
![Page 12: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/12.jpg)
Workflow
Events / Steps
Business Rules
Static Properties
(status dependence of steps, defined status settings)
(external processing steps: macros, programs,... internal steps: temporary “Enabling” of business rules)
(status depending operating rules and properties of data: calculations,settings, plausibility, warnings, proposals, rights, and privileges)
(description and classifying of data, status non-depending (general) properties of data, relations according to the ER-model
Advanced Meta Data
![Page 13: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/13.jpg)
Target
BusinessProcess
Automation
ManagementInformation
The Range of Custom Database Applications
Information and decisionoriented applications
Operation and transactionoriented applications
CustomApplications
SCOPELAND Excels Here
![Page 14: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/14.jpg)
Target
Today´s Trend: Standard Software for Custom Applications
SCOPELAND Excels Here
Data Wareh.Products
Bu
sin
ess I
nte
llig
en
ce
Doc M
an
ag
em
en
t
Offi
ce A
uto
m -
Work
flow
Workflow
Products
Up to now: 100 %individual programming !
Data
Ware
hou
se
![Page 15: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/15.jpg)
hkh
hkh
Company Information
hkh
?
Ad-hoc-import/export
Aggregated Data
Aggregated Data
Aggregated Data
Complex Information and Data Storage Systems
Item databusiness applications
OLAP-analyses, aggregation, transformation
Ad-hoc access to all available data
complex structuresbulk Data item data
Periodicimport/export
Evo
lutio
nary
d
evel
opm
ent
Evo
lutio
nary
d
evel
opm
ent
Application Example
![Page 16: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/16.jpg)
item data status data electronic archive
Workflow-Technology for Item Data Applications
Application of business processesbased on process models
Processing of structured item data
Document- Managementelectronic files
Application Example
![Page 17: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/17.jpg)
SCOPELAND
SCOPELAND is the first full functioned DiDP application
www.scopeland.com
![Page 18: DiDP the emerging Database Standard Database Seminar](https://reader034.vdocuments.us/reader034/viewer/2022051019/5681506d550346895dbe695b/html5/thumbnails/18.jpg)
Your questions please ...