BizFirstAi Platform · Enterprise Data

605+ tables. 48 domains.
Built for enterprise.

DataOcean is the pre-built enterprise data backbone that powers the entire BizFirstAI platform — and yours. Multi-tenant, audit-ready, and optimised from day one.

Built on SQL Server 2019+ Enterprise · 100% Multi-Tenant · Production-proven

605+ Tables
48 Data Domains
1,200+ Foreign Keys
2,500+ Indexes
<10ms Lookup Time
100% Multi-Tenant

Building an enterprise data model from scratch takes years.

Most teams underestimate the complexity — and pay for it with 18-month delays, compliance gaps, and technical debt that never goes away.

Schema Design Hell

Designing 600+ tables — with correct relationships, constraints, indexes, and partitioning — takes a senior DBA team 12 to 24 months. And that's before a single line of application code is written.

Missing Audit Compliance

HIPAA, SOX, and GDPR require immutable audit trails baked in from day one — not retrofitted. Adding audit columns to a live production database is one of the most painful migrations there is.

Multi-Tenancy Nightmare

Adding TenantID safely to a live system — without breaking every query, view, stored procedure, and index — is one of the hardest database migrations in existence. DataOcean has TenantID on every single one of its 605 tables from the start.

Every data domain your enterprise needs. Already designed.

Don't spend 18 months designing your data model. DataOcean ships 48 logical data domains — fully normalised, indexed, and multi-tenant — out of the box.

AI Agent 33 tables
  • AIAgent
  • AIAgentInstruction
  • AIKnowledgeBase
  • AIAgentProfile
  • AIAgentTeam
AI Channel 43 tables
  • AIChannel
  • AIMessageQueue
  • AIWebhookDeliveryLog
  • AIChannelConfig
  • AIChannelSubscription
AI Conversation 25 tables
  • AIConversation
  • AIConversationMessage
  • AIConversationState
  • AIConversationParticipant
Process & Workflow 75 tables
  • Process
  • ProcessElement
  • ProcessConnection
  • ProcessExecutionTrace
  • 60+ node types
IAM & Identity 40 tables
  • User
  • Role
  • Permission
  • Organization
  • SSOProvider
Marketplace 35 tables
  • MarketplacePackage
  • PackageReview
  • PackageRating
  • Publisher
  • PackageDownload
Community & Engagement 12 tables
  • RewardGrant
  • RewardRule
  • ReputationScore
  • CommunityActivity
Forms & Atlas 8 tables
  • Form
  • FormDataRecord
  • FormCategory
  • FormField
Security & Compliance 4 tables
  • SecurityPolicy
  • NodeCapabilityPolicy
  • AuditLog
  • ComplianceRecord
Payments & Billing 10 tables
  • PaymentTransaction
  • Invoice
  • PaymentGateway
  • Subscription
Observability 15 tables
  • ExecutionLog
  • PerformanceMetric
  • ErrorTracking
  • AlertRule
Extended Systems 117 tables
  • AIFunction
  • AILLM
  • AIMCP
  • AIMonitor
  • AIScheduler

+28 more domains Analytics, notifications, tagging, file storage, versioning, localization, reporting, integrations, and more — all following the same enterprise-grade pattern.

Every table follows the same battle-tested pattern.

Consistency at scale. All 605 tables share the same foundational columns — no surprises when you query any domain.

Standard columns — present on all 605 tables Every Domain
TenantID UNIQUEIDENTIFIER · NOT NULL · FK Row-level multi-tenant isolation. Every query is tenant-scoped. No data leakage between tenants is architecturally possible.
ResID UNIQUEIDENTIFIER · NOT NULL · DEFAULT NEWID() Distributed system identity. Stable GUID for replication, federation, and external system referencing independent of surrogate keys.
Deleted & Archived BIT · NOT NULL · DEFAULT 0 Soft delete and soft archive — data is never hard-deleted. Filtered indexes on Deleted=0 keep active queries fast.
CreatedOn & CreatedBy DATETIME2 / UNIQUEIDENTIFIER · NOT NULL Immutable creation timestamp and actor. Set on INSERT, never updated. Full audit trail foundation for SOX, HIPAA, and GDPR.
LastModifiedOn & LastModifiedBy DATETIME2 / UNIQUEIDENTIFIER · NOT NULL Tracks every change — when it happened and who made it. Combined with triggers, creates a complete chronological audit history.
SourceAppID & DataDomainID UNIQUEIDENTIFIER · NULLABLE · FK Data segmentation identifiers. Track which application, domain, and segment originated each record — critical for multi-app platforms.
ClientAccountID UNIQUEIDENTIFIER · NULLABLE · FK Optional client-level partitioning within a tenant. Enables B2B2C architectures where tenants serve their own downstream clients.
DataSegmentID & AppDomainID UNIQUEIDENTIFIER · NULLABLE · FK Fine-grained data segmentation for complex multi-product, multi-domain enterprise deployments. Zero-code data partitioning.

Consistency at scale. No surprises.

Authorization that enterprises actually need.

Four independent, composable authorization layers — from coarse role-based access down to per-element human-in-the-loop gates.

1
RBAC — Role-Based Privilege System
Traditional role-based access control. Assign roles to users and groups. Roles carry privilege sets that grant access to resources, actions, and data domains across the platform.
2
ABAC — Attribute-Based Scope Hierarchy
Fine-grained access control based on attributes of users, resources, and context. Supports scope hierarchies — global, tenant, organization, department, project — with policy inheritance and override at every level.
3
Node Capabilities — Per-Element Permissions
Every node and element in a process or workflow can carry its own capability policy. Read, write, execute, and delegate permissions at the individual node level — not just at the resource level.
4
Actor Assignment — Human-in-the-Loop Gates
Assign specific human actors to workflow steps. The process cannot proceed until the assigned actor approves, reviews, or completes the step. Essential for regulated industries requiring manual sign-off.

Sub-100ms at enterprise scale.

Every SLA is backed by 2,500+ tuned indexes, filtered covering indexes, and a schema designed from the ground up for read throughput.

Operation Type Description SLA Target
Single Record Lookup PK or unique index lookup, single row <10ms
Multi-Record Query Filtered list, 100–1,000 rows <50ms
Complex Join 5–10 table join with filters <100ms
Aggregate / Report Query GROUP BY, SUM, COUNT, date ranges <500ms
Full-Text Search FTS across indexed text columns <200ms
Tenant Isolation Query All queries with TenantID filter <15ms overhead
Audit Trail Read Retrieve full change history for a record <100ms

2,500+ indexes, optimized filtered indexes on Deleted=0, covering indexes for common joins — designed for throughput. Every query plan reviewed and tuned.

What enterprises build on DataOcean.

From AI-powered workflows to regulated financial platforms, DataOcean's 48 domains cover the full breadth of enterprise application needs.

Finance · HR · Compliance

Enterprise Process Automation

Build approval workflows, compliance sign-off chains, and HR onboarding processes on top of the Process & Workflow domain — 75 pre-built tables covering every node type, execution trace, and connection.

Go from concept to production workflow in days, not months.

ISVs · B2B2C Platforms

Multi-Tenant SaaS Platform

Launch a full multi-tenant SaaS product on top of DataOcean's IAM (40 tables), Marketplace (35 tables), and Payments (10 tables) domains. TenantID isolation is already built in — no migration required.

Multi-tenancy that scales from 10 to 10,000 tenants without schema changes.

SOX · HIPAA · GDPR

Regulatory Compliance

Audit trails, soft delete, immutable record history, and actor assignment are baked into every table. Security & Compliance domain provides the SecurityPolicy and AuditLog infrastructure required by most enterprise regulators.

Pass your compliance audit with schema-level evidence, not application-layer workarounds.

AI Platforms · Automation

AI-Powered Workflows

Combine the AI Agent (33 tables), AI Conversation (25 tables), and AI Channel (43 tables) domains to build production-grade AI automation with conversation history, knowledge base retrieval, and multi-channel delivery — all persisted with full audit.

AI agents that know your data — because the data model was designed for AI from day one.

Designed for regulated industries.

DataOcean's audit, compliance, and multi-tenancy architecture was built with the strictest industry requirements in mind.

Financial Services

  • SOX audit trail compliance
  • Transaction ledger integrity
  • Multi-entity isolation
  • Approval workflow automation

Healthcare

  • HIPAA audit logging
  • Patient record isolation
  • Clinical workflow automation
  • Provider credentialing

Manufacturing

  • Supply chain traceability
  • Quality control workflows
  • Multi-plant data isolation
  • Vendor management

Government

  • GDPR compliance
  • FoI audit capabilities
  • Cross-agency data isolation
  • Citizen service workflows

Stop designing. Start building.

DataOcean gives your team a complete enterprise data foundation — so you can focus on your product, not your schema.