Script-Less Development System (SLDS)

Slide1: 

Institute of Graduate Studies & Research By: Mohamed M. Abu Elella Shalaby

Slide2: 

Companies that intend to automate their business processes into database systems must follow one of the two development approaches: Develop Tailor Software System Implement Readymade ERP System

Slide3: 

To design and implement a system for Automatic Database Applications Development to develop organizational database systems. System fulfills the following: Optimize Development and Implementation Processes. Reduce Development Time and Resources. Eliminate Classical Designing and Programming Tasks. Flexible for further Improvements and Modifications. Satisfying business processes Integrity.

Slide4: 

This study introduces a third approach: Develop Tailor ERP System In-house By Company Business Experts. Based on: Script-Less Development System (SLDS)

Slide11: 

What You See Is What You Get

Slide12: 

Software Development Approaches Develop Tailor System Implement Ready Made ERP System Develop Tailor ERP System In-House Development Models Development Tools RAD Tools CASE Tools Or Or DBMS DBMS ERP Package DBMS (Engine) BDM SLCS SLDM SLDS Using New Development Approach

Slide13: 

Using SLDM BDM SLCS Business Perspectives Business Solution Business Modeling Approve Training Business Company Describe SLDS Operation with Continuous feedback and improvements

Slide14: 

SLDM SLCS Development Models CASE and RAD Tools DBMS DBMS DBMS ERP System BDM ER Model Second Approach Third Approach First Approach Business Solution S L D S

Slide15: 

Database systems development life cycle Business Companies Software Development Companies

Slide17: 

Entity List Entity Attributes Definer Entity Attributes Value Container Entities’ Views Insert Entity Record Update Entity Record Delete Entity Record Fill Entity Record Missing Attributes Retrieve Entity Record Basic Run-time Functions

Slide21: 

Organizations Modules Entities Transactions Processes Outputs Attributes Properties Business Rules Attributes Properties Business Rules Attributes Properties Business Rules Related Transactions & Processes in Sequence Attributes Formats Computes Arguments &Conditions Simple Analysis Forms (SAF) Detailed Analysis Forms (DAF) Meta Data (Business processes configuration) Business Scenario Development-time Declare List

Slide22: 

Meta Data (Business processes configuration) Run-Time Login User Organization Mode Administration Development-Time Run-Time Organization Modules Object Types List of one type of objects for one module Entities Transactions Processes Outputs Object Running Interface Security & Administration Data (Users, Permissions, Organization Access and Tracking) Data Containers (Daily users’ entries) Retrieve as per request Verify

Slide23: 

Data Containers (Daily users’ entries) Security & Administration Data (Users, Permissions, Organization Access and Tracking) Meta Data (Business processes configuration) Database Server Internet LAN Client Central Database Client

Slide26: 

Is able to be adopted with business processes changes automatically in run time. Improves requirement determination and remove communication gab. Can be much faster for small and medium projects that do not require the full process of development. Increases knowledge worker participation and sense of ownership. Increases speed of systems development. SLDS

Slide27: 

Record Space = 3 + 40 + 100 + 2 + 1 = 146 bytes

Slide28: 

Record Storage Space = 4+2+3+4+2+40 +4+2+100 +4+2+2 +4+2+1 = (4+2) 5 + (3+40+100+2+1) = 6 Attributes No + Relational Record Space Record Storage Space = 30 + 146 = 176 bytes RSS [BDM] = 6A + RSS [RDM] ESS [BDM] = 6A R + ESS [RDM]

Slide30: 

SLDS suitable for medium and small business companies. SLDS builds a whole database system without writing script in-house, by: Their own internal business experts Their own resources In short time Without any software development experts Without software development companies SLDS still requires some of the future work, such as: Reduce database storage space Enhance performance in inserting, retrieving and deleting records Create an independent DBMS interface to work with known DBMS such as Oracle, Sybase, Informix, MS SQL, etc.

Slide32: 

1.

Slide33: 

1. Animation in diagrams if required. DONE 2. Simple example to declare and simplify the main idea after objective. DONE 3. O/P SLDS screens after example. DONE 4. Storage and performance points in evaluation & discussion. DONE 5. To remove slide No 27 (attribute properties). DONE