Oracle. Ещё один способ партиционирования больших и нагруженных таблиц
Всем привет! Меня зовут Ольга и я разработчик в Ингосстрахе. В этой статье-туториале хочу поделиться способом партиционирования оооочень большой таблицы в Oracle 12c. Итак, погнали.
В жизни любой давно функционирующей системы наступает момент, когда уже невозможно хранить все исторические данные без разбору и пора думать, что это надо как-то поделить. Старое отправить на архивный или отчетный сервер, а оперативный слой существенно проредить. И самый очевидный и распространенный путь – партиционировать таблицу, а старые секции перенести на другое хранилище.
Читать: https://habr.com/ru/post/666254/
Всем привет! Меня зовут Ольга и я разработчик в Ингосстрахе. В этой статье-туториале хочу поделиться способом партиционирования оооочень большой таблицы в Oracle 12c. Итак, погнали.
В жизни любой давно функционирующей системы наступает момент, когда уже невозможно хранить все исторические данные без разбору и пора думать, что это надо как-то поделить. Старое отправить на архивный или отчетный сервер, а оперативный слой существенно проредить. И самый очевидный и распространенный путь – партиционировать таблицу, а старые секции перенести на другое хранилище.
Читать: https://habr.com/ru/post/666254/
How to connect SuperTokens to a MySQL or to a PostgreSQL database
This is only applicable if you are self-hosting the SuperTokens core service.
There are several methods for how you might want to run SuperTokens along with a database.
Please feel free to navigate to the correct section based on your setup. In eac...
Read: https://supertokens.hashnode.dev/how-to-connect-supertokens-to-a-mysql-or-to-a-postgresql-database-cl3bknpf505ahx2nveryr1bra
This is only applicable if you are self-hosting the SuperTokens core service.
There are several methods for how you might want to run SuperTokens along with a database.
Please feel free to navigate to the correct section based on your setup. In eac...
Read: https://supertokens.hashnode.dev/how-to-connect-supertokens-to-a-mysql-or-to-a-postgresql-database-cl3bknpf505ahx2nveryr1bra
Discover new insights from your data using SQL Server Integration Services (SSIS) and Amazon Neptune
Read: https://aws.amazon.com/blogs/database/discover-new-insights-from-your-data-using-sql-server-integration-services-ssis-and-amazon-neptune/
Read: https://aws.amazon.com/blogs/database/discover-new-insights-from-your-data-using-sql-server-integration-services-ssis-and-amazon-neptune/
Enable near real-time notifications from Amazon Aurora PostgreSQL by using database triggers, AWS Lambda, and Amazon SNS
Read: https://aws.amazon.com/blogs/database/enable-near-real-time-notifications-from-amazon-aurora-postgresql-by-using-database-triggers-aws-lambda-and-amazon-sns/
Read: https://aws.amazon.com/blogs/database/enable-near-real-time-notifications-from-amazon-aurora-postgresql-by-using-database-triggers-aws-lambda-and-amazon-sns/
From Core Banking to Componentized Banking: Temenos Transact Benchmark with MongoDB
Read: https://www.mongodb.com/blog/post/from-core-banking-componentized-banking-temenos-transact-benchmark-mongodb
Read: https://www.mongodb.com/blog/post/from-core-banking-componentized-banking-temenos-transact-benchmark-mongodb
The Insider's Guide to MongoDB World 2022
Read: https://www.mongodb.com/blog/post/insiders-guide-mongodb-world
Read: https://www.mongodb.com/blog/post/insiders-guide-mongodb-world
Atlas Charts Adds a Dedicated Hub for Managing Embedded Charts and Dashboards
Read: https://www.mongodb.com/blog/post/atlas-charts-adds-dedicated-hub-managing-embedded-charts-dashboards
Read: https://www.mongodb.com/blog/post/atlas-charts-adds-dedicated-hub-managing-embedded-charts-dashboards
Explore Deep in 4.6 Billion GitHub Events
4.6 billion is literally an astronomical figure. The richest star map of our galaxy, brought by Gaia space observatory, includes just under 2 billion stars. What does a view of 4.6 billion GitHub events really look like? What secrets and values can b...
Read: https://hashnode.com/post/explore-deep-in-46-billion-github-events-cl3cat62p076zx2nveuz6ce3d
4.6 billion is literally an astronomical figure. The richest star map of our galaxy, brought by Gaia space observatory, includes just under 2 billion stars. What does a view of 4.6 billion GitHub events really look like? What secrets and values can b...
Read: https://hashnode.com/post/explore-deep-in-46-billion-github-events-cl3cat62p076zx2nveuz6ce3d
Sql Joins
👋🏾, welcome back.
Definition
This clause is used to combine rows from two or more tables, based on a related column between them.
Different Types of SQL Joins
INNER JOIN: returns records that have matching values in both tables
LEFT(OUTER) JOIN:...
Read: https://yusrastack.hashnode.dev/sql-joins
👋🏾, welcome back.
Definition
This clause is used to combine rows from two or more tables, based on a related column between them.
Different Types of SQL Joins
INNER JOIN: returns records that have matching values in both tables
LEFT(OUTER) JOIN:...
Read: https://yusrastack.hashnode.dev/sql-joins
Apache ShardingSphere Enterprise User Case: Zhongshang Huimin’s Transaction Middle Platform Architecture
The FMCG (fast moving consumer-goods) industry can no longer meet current development requirements. The traditional way of only upgrading the end of the supply chain cannot achieve high-quality business development. Huimin focuses on order fulfillmen...
Read: https://apacheshardingsphere.com/apache-shardingsphere-enterprise-user-case-zhongshang-huimins-transaction-middle-platform-architecture
The FMCG (fast moving consumer-goods) industry can no longer meet current development requirements. The traditional way of only upgrading the end of the supply chain cannot achieve high-quality business development. Huimin focuses on order fulfillmen...
Read: https://apacheshardingsphere.com/apache-shardingsphere-enterprise-user-case-zhongshang-huimins-transaction-middle-platform-architecture
Why Choose TiDB to Support OSS Insight
Many times we hope that our data access becomes more real-time. It has diffrrent meanings for various industries. For logistics, it means that resource allocation can be carried out with a faster frequency. For e-commerce, it means quicker adjustment...
Read: https://hashnode.com/post/why-choose-tidb-to-support-oss-insight-cl3ctd1ry08fvy3nvbtqb7k8p
Many times we hope that our data access becomes more real-time. It has diffrrent meanings for various industries. For logistics, it means that resource allocation can be carried out with a faster frequency. For e-commerce, it means quicker adjustment...
Read: https://hashnode.com/post/why-choose-tidb-to-support-oss-insight-cl3ctd1ry08fvy3nvbtqb7k8p
Should you use Raw SQL or an ORM?
Interacting with databases is super crucial in becoming a badass developer. Whether you want to be a front-end, back-end or full-stack developer, you would encounter databases because most dynamic applications rely on user data. And you don’t want to...
Read: https://thinkpanda.hashnode.dev/should-you-use-raw-sql-or-an-orm
Interacting with databases is super crucial in becoming a badass developer. Whether you want to be a front-end, back-end or full-stack developer, you would encounter databases because most dynamic applications rely on user data. And you don’t want to...
Read: https://thinkpanda.hashnode.dev/should-you-use-raw-sql-or-an-orm
Collaborative User Story Mapping with Avion and MongoDB
Read: https://www.mongodb.com/blog/post/collaborative-user-story-mapping-avion-mongodb
Read: https://www.mongodb.com/blog/post/collaborative-user-story-mapping-avion-mongodb
Deploy a high-performance database for containerized applications: Amazon MemoryDB for Redis with Kubernetes
Read: https://aws.amazon.com/blogs/database/deploy-a-high-performance-database-for-containerized-applications-amazon-memorydb-for-redis-with-kubernetes/
Read: https://aws.amazon.com/blogs/database/deploy-a-high-performance-database-for-containerized-applications-amazon-memorydb-for-redis-with-kubernetes/
Open Banking: How to Future-Proof Your Banking Strategy
Read: https://www.mongodb.com/blog/post/open-banking-how-future-proof-your-banking-strategy
Read: https://www.mongodb.com/blog/post/open-banking-how-future-proof-your-banking-strategy
How Shaadi.com reduced costs and improved performance with DynamoDB
Read: https://aws.amazon.com/blogs/database/how-shaadi-com-reduced-costs-and-improved-performance-with-dynamodb/
Read: https://aws.amazon.com/blogs/database/how-shaadi-com-reduced-costs-and-improved-performance-with-dynamodb/
SaaS Insight for Building a Real-time CRM Application
Background
To store large volumes of real-time user data like email and provide insights is not easy. If your application is layered on top of Gmail to automatically extract and organize the useful information buried inside of our inboxes.
It became ...
Read: https://hashnode.com/post/saas-insight-for-building-a-real-time-crm-application-cl3dss9tx00gs07nvegkx8y5a
Background
To store large volumes of real-time user data like email and provide insights is not easy. If your application is layered on top of Gmail to automatically extract and organize the useful information buried inside of our inboxes.
It became ...
Read: https://hashnode.com/post/saas-insight-for-building-a-real-time-crm-application-cl3dss9tx00gs07nvegkx8y5a
MongoDB & IIoT: A 4-Step Data Integration
Read: https://www.mongodb.com/blog/post/mongodb-iiot-4-step-data-integration
Read: https://www.mongodb.com/blog/post/mongodb-iiot-4-step-data-integration
Comparing DynamoDB and Fauna for multi-region data stores
One of the critical architectural decisions you must make when designing modern applications is selecting the right data storage technology. Not only can this decision be expensive to change later, but it also deeply affects your application’s availa...
Read: https://fauna.hashnode.dev/comparing-dynamodb-and-fauna-for-multi-region-data-stores-cl3eo4mdq02kur1nvhjzp9568
One of the critical architectural decisions you must make when designing modern applications is selecting the right data storage technology. Not only can this decision be expensive to change later, but it also deeply affects your application’s availa...
Read: https://fauna.hashnode.dev/comparing-dynamodb-and-fauna-for-multi-region-data-stores-cl3eo4mdq02kur1nvhjzp9568
Migrate your SAP ASE (Sybase ASE) database to Amazon RDS for SQL Server
Read: https://aws.amazon.com/blogs/database/migrate-your-sap-ase-sybase-ase-database-to-amazon-rds-for-sql-server/
Read: https://aws.amazon.com/blogs/database/migrate-your-sap-ase-sybase-ase-database-to-amazon-rds-for-sql-server/