Separation into these areas is standard because it allows the separation of the processing load across multiple servers. Servers are usually configured differently based on the processes that they will run. Online servers may have faster processors and more memory, whereas reporting and warehouse servers will have more disk space and faster I/O channels. The data model shall: Provide a conceptual description of the objects (e.g., FBO, Product, Ingredient, etc.) in the system’s • domain and their relationships. Provide a blueprint for creating the database structure. • Guide implementation of code units that access the database. • Guide performance enhancements in data access operations. • Serve as input for automatic generation of database schema and data access code. • Facilitate stakeholder communication in domain analysis and requirements elicitation tasks. • The solution should support traditional integration Business Messaging protocols like XML, Should support verification of data integrity before the data is loaded into the package tables Should support standard transport protocols like http, https, Data Validity The solution should have the ability to assign validation on specific fields based on entries in the data validation reference file Field level validations Data Mining The solution should generate MIS reports for senior management based on user requirements, periodically (monthly, quarterly, half yearly, annually) and customized The solution should include an open source data mining tool that provides bottom-up, data analysis. The solution shall use data mining algorithms to uncover business data and reveal hidden trends The solution should include a Rule Data Cleansing/Enhancement tool Database Optimization Data Currency Data Currency is a measure of how recent the data is. This requirement answers the question, when the application responds to a request for data, how current must the data be? This has to be described for each type of data request. For this PAS there has to be a separate database as the database has multiple tables that consist of data of FBO’ s, Products, ingredients, additives, NOC’ s PA’s etc.
Separation into these areas is standard because it allows the separation of the processing load across multiple servers. Servers are usually configured differently based on the processes that they will run. Online servers may have faster processors and more memory, whereas reporting and warehouse servers will have more disk space and faster I/O channels. The data model shall: • Provide a conceptual description of the objects (e.g., FBO, Product, Ingredient, etc.) in the system’s domain and their relationships. • Provide a blueprint for creating the database structure. • Guide implementation of code units that access the database. • Guide performance enhancements in data access operations. • Serve as input for automatic generation of database schema and data access code. • Facilitate stakeholder communication in domain analysis and requirements elicitation tasks. The solution should support traditional integration Business Messaging protocols like XML, Should support verification of data integrity before the data is loaded into the package tables Should support standard transport protocols like http, https, Data Validity The solution should have the ability to assign validation on specific fields based on entries in the data validation reference file Field level validations Data Mining The solution should generate MIS reports for senior management based on user requirements, periodically (monthly, quarterly, half yearly, annually) and customized The solution should include an open source data mining tool that provides bottom-up, data analysis. The solution shall use data mining algorithms to uncover business data and reveal hidden trends The solution should include a Rule Data Cleansing/Enhancement tool Database Optimization Data Currency Data Currency is a measure of how recent the data is. This requirement answers the question, when the application responds to a request for data, how current must the data be? This has to be described for each type of data request. For this PAS there has to be a separate database as the database has multiple tables that consist of data of FBO’ s, Products, ingredients, additives, NOC’ s PA’s etc.