📅 2024-09-16 — Session: Enhanced NoSQL Schemas for Diverse Applications
🕒 17:35–18:25
🏷️ Labels: Nosql, Schema, Adaptation, Flexibility, Scalability
📂 Project: Dev
⭐ Priority: MEDIUM
Session Goal:
The session aimed to design and refine NoSQL schemas to enhance flexibility, scalability, and adaptability across various domains such as budget resolution, legal documents, personnel management, and public program tracking.
Key Activities:
- Developed a detailed NoSQL schema for organizing budget resolution documents, focusing on references, considerations, articles, and annexes.
- Updated the schema to enhance flexibility and scalability, grouping related items into collections for easy expansion.
- Generalized the schema to accommodate various legal documents, ensuring adaptability for references, agreements, and administrative actions.
- Designed a schema for document management, covering key details like references, offers, adjudications, agreements, and financial information.
- Updated the schema for administrative and personnel management, introducing sections for personnel designations, resignations, and asset declarations.
- Adapted the schema for health-related entities, including fields for personnel assignments, pension contributions, and budget structures.
- Outlined adaptations for public program tracking and schema modifications for designation and budget tracking.
- Enhanced the schema for handling legal references in personal designations and budget.
- Proposed adaptations for public rewards schema in security resolutions and schema enhancements for Ministry of Security agreements.
- Detailed schema adaptations for handling new legal instruments like ‘comodatos’ and ‘licitaciones’.
- Merged structures for tender processes to avoid redundancy and ensure clarity.
Achievements:
- Successfully created and refined multiple NoSQL schemas to cater to diverse organizational needs, ensuring scalability and adaptability.
Pending Tasks:
- Further testing and validation of the proposed schema adaptations in real-world scenarios to ensure robustness and efficiency.