It's about the data.
Data is the core of your business. Your data needs to be clear, secure, correct, reliable, and available. To achive that you need expertise in data. Corlogic brings decades of experience to help you achieve your goals.
Services
- Performance and Query Tuning
This is our most common request. Corlogic can help with tuning of specific queries to meet your Service Level Agreements, as well as analyzing the overall workload to determine the best usage of resources.
- Database and Data Warehouse Design
Good database design is necessary for maintainable, performant applications. Corlogic can help you organize your data before it becomes a problem, bridging the gap between your subject matter experts and database design.
- ETL and Data Pipelines
Any large data system will have a variety of sources, and a variety of destinations. Knowing the best ways to manage those data flows is key to business performance.
- Data Lifecycle Management
Data that was important today may not be in a few months. Regulations may require that data be retained, or deleted. Corlogic can help you organize your data to accomodate prioritization, regulatory requirements, access, and other data lifecycle needs.
- Upgrades
Newer versions of databases promise new features and performance improvements, but carry risks in terms of gregressions, feature deprecations, and the downtime of performing the upgrade. Corlogic has experience with planning and execuring upgrades, as well as the triage and mitigations of regressions after an upgrade.
- Migrations
Whether it's moving OLTP data to a Data Warehouse, archiving older data from active storage to cold storage, or changing database technologies altogether, Corlogic can help.
- Data Privacy
The increasing importance of data privacy Regulations (CCPA, GDPR, etc) presents risks and obligations for every business. Sensitive information is often lurking in unexpected places in data systems. Corlogic can help you find those places and develop a mitigation process.
- Data Quality Analysis
Real data has flaws. Data entry mistakes are made, file formats often go unenforced. Your application code needs to check for invalid data everywhere that the database cannot. Corlogic can help you to clean your existing data and create rules to prevent invalid data from returning.
Industries
- Ad Tech
Views, attention, engagement, customer acquisition.
- Education
Enrollment, attendance, assessments, and vaccination compliance.
- Finance
Positions and trades, forex, cryptocurrency, KYC, SARs, fraud.
- Privacy and Governance
GDPR, CCPA, HIPAA.
- Real Estate
Geospatial data, housing capacity and occupancy, land use.
- Retail
Inventory, bills of materials, customer customization of products.
Technologies
- PostgreSQL
Corlogic specializes in PostgreSQL, and has made several community contributions including code in core PostgreSQL, extensions, and documentation.
- Snowflake
Many new data warehouses leverage Snowflake's parallel scalability, especially when used in tandem with an OLTP database of record. Corlogic has experience with database design as well as ETLs from OLTP databases using several methods including change data capture.
- Oracle
Whether you are looking to stay or migrate away from Oracle, Corlogic has decades of experience with Oracle.
- SQLServer
A mainstay of websites and applications. Corlogic has developed for and tuned SQLServer, done migrations from SQLServer to PostgreSQL and MySQL, and even has SQLServer's ancestor Sybase.
- Redshift
The data warehouse most integrated with AWS services. Often the best solution for infrequent data warehouse needs. Corlogic understands the capabilities, and limitations of Redshift and where it is best used within an organization.
- Vertica
Distributed speed and high compression are the hallmarks of a Vertica data warehouse. Corlogic has handled multi-terrabyte Vertica installations, and can help you push it to the limit.
- MySQL
Many businesses start out on the ubiquitous and quirky MySQL. Corlogic can help you maintain your existing system as well as migrate to more featureful databases.
- SQLite
Sometimes the smallest solution is the best. Just because the database is only meant for one use does not mean that the database should skip good design.