标签

 database 

相关的文章:

掌握数据库管理与优化的技巧,提升数据处理效率和性能,包括Oracle Database、SQL Server、MongoDB等数据库的设计、配置和操作。

亚马逊AWS官方博客 -

借助 Oracle Database Gateway 实现 Amazon RDS Oracle 透明访问异构数据库

本方案借助 Oracle Database Gateway 的 ODBC 组件实现从 Amazon RDS Oracle 向目前各主流关系数据库的透明访问(如 RDS MySQL,RDS PostgreSQL,RDS SQLServer,Redshift 等)。不需要修改应用程序就可以完成 Oracle 与其它异构数据库的分布式事务部署。 相比通过 DMS 或者其它工具在数据库之间同步数据的方案,本方案更高效成本更低,且完全可以避免数据不一致,同步延迟等问题。

本文介绍了如何通过配置Oracle Database Gateway和ODBC实现从Oracle访问其他数据库引擎。文章提供了详细的部署和配置步骤,并给出了MySQL、PostgreSQL、SQL Server和Redshift的示例配置。通过创建数据库链接,可以在Oracle中读写其他数据库的数据,实现透明访问,提高效率,降低成本,并避免数据不一致和同步延迟的问题。需要注意网络带宽对大结果集的影响。

相关推荐 去reddit讨论

Percona Database Performance Blog -

What is a Cloud-Native Database? Everything You Need to Know

A cloud-native database isn’t just a database that happens to be sitting in the cloud; it’s built from the ground up to harness the full potential of cloud computing. Unlike traditional databases only adapted to operate in the cloud, cloud-native databases are designed to work with the cloud’s distributed architecture to optimize performance, manage resources […]

云原生数据库是为充分利用云计算潜力而构建的数据库,通过与云的分布式架构协同工作,优化性能、动态管理资源,并能根据需求无缝扩展。它具有快速高效处理大量实时数据的能力,支持快速应用开发,确保高可用性和可靠的灾难恢复能力,并具有成本效益。云原生数据库的特点包括微服务架构、容器化、声明性API和云原生监控工具。在金融、医疗、游戏、供应链物流、教育、社交媒体等领域广泛应用。选择云原生数据库时需要考虑需求、性能、可扩展性、成本、迁移等因素。

相关推荐 去reddit讨论

Planet MySQL -

Three common MySQL database design mistakes

Learn about a few common mistakes when designing your MySQL database schema.

这篇文章讨论了数据库设计中的一些常见错误,包括选择不合适的数据类型、过多或过少使用索引以及存储半结构化数据的最佳方法。文章强调了选择适当的数据类型以容纳现有数据和潜在增长的重要性,并提到了MySQL中的一些常见错误和解决方法。此外,文章还介绍了使用JSON列类型存储JSON数据的优势。最后,文章提到了一个解决ID列空间不足的方法,即将ID重新设置为负数。总的来说,设计一个能够应对增长的数据库是一项复杂的任务,需要注意各种潜在的错误和挑战。

相关推荐 去reddit讨论

Devart Blog -

Best SQL Server GUI Tools for Database Management

In this review, we will explore some of the most beneficial and user-friendly GUI solutions for SQL Server databases tailored for macOS users. The post Best SQL Server GUI Tools for Database Management appeared first on Devart Blog.

本文介绍了适用于macOS的SQL Server图形用户界面(GUI)工具,包括dbForge Studio for SQL Server、Navicat for SQL Server、DataGrip、DbVisualizer、Beekeeper Studio、RazorSQL和SQLPro for MSSQL。这些工具帮助用户更高效地开发、管理和维护SQL Server数据库。选择适合自己工作流程的GUI工具时,需要考虑功能集、兼容性、用户友好性、支持和价格等因素。

相关推荐 去reddit讨论

Devart Blog -

How to Backup and Restore a PostgreSQL Database

This article contains a comprehensive guide on backing up and restoring data and schema using a command-line tool and a user-friendly GUI tool — dbForge Studio for PostgreSQL. Here, you will discover carefully selected theoretical material designed to broaden your knowledge on the subject, complemented by practical examples to provide you with a hands-on learning experience. The post How to Backup and Restore a PostgreSQL Database appeared first on Devart Blog.

本文介绍了使用命令行和GUI工具备份和恢复PostgreSQL数据和模式的方法。使用pg_dump命令行工具备份单个数据库,使用pg_dumpall备份所有数据库。使用dbForge Studio for PostgreSQL GUI工具导出数据到不同文件格式,并通过模式比较功能备份数据库模式。还介绍了从CSV文件导入数据到PostgreSQL数据库的方法。

相关推荐 去reddit讨论

解道jdon.com -

基于Oracle Database 23c和UCP的新Spring JDBC客户端源码配置

这个开源项目是Spring 6.1.x中提供了新的 Spring JDBC 客户端 ( JdbcClient ),点击标题这个案例展示了 Spring 6.1.x 中提供的新 Spring JDBC 客户端 (JdbcClient)。它是对框架的一个有趣的补充,因为它提供了一个出色的流畅接口作为使用 JDBC 的高级抽象。鉴于其优雅的 JDBC 方法,作为 Java 开发人员,了解其详细信息是很有趣的,因为它为 Java 开发人员提供了开箱即用的 Java 流畅接口。新的 JdbcClient新的 JdbcClient(org.springframework.jdbc.core.simple.

这个开源项目是Spring 6.1.x中提供的新的Spring JDBC客户端(JdbcClient),它提供了一个出色的流畅接口作为使用JDBC的高级抽象。新的JdbcClient接口为查询/更新语句提供了统一的界面,并提供了灵活的字段映射支持。此外,还新增了SimplePropertyRowMapper,用于将记录转换为指定映射目标类的新实例。该项目还提供了一个完整的代码示例,需要连接到Oracle数据库实例并执行DDL脚本来创建表。

相关推荐 去reddit讨论

Devart Blog -

SQL Database Design Basics With Examples

Discover how to populate a database with data by means of Data Generator for SQL Server, and search for database data and objects with the free dbForge Search tool. I will use dbForge Studio for SQL Server to implement charts for my examples, and dbForge Data Pump to import and export data. The post SQL Database Design Basics With Examples appeared first on Devart Blog.

本文介绍了关系数据库设计的基础知识,包括不同关系的实现方式和数据库的规范化与反规范化。还讨论了招聘服务数据库模式的设计,提供了示例和表结构、列、约束和索引的定义方法。下一部分将介绍数据填充。

相关推荐 去reddit讨论

MongoDB -

MongoDB Named a Leader in the 2023 Gartner® Magic Quadrant™ for Cloud Database Management Systems

MongoDB is proud to be named a Leader in the 2023 Gartner® Magic Quadrant for Cloud Database Management Systems (CDBMS). We believe this makes MongoDB the only dedicated application database provider recognized as a Leader for two years running. At MongoDB, our focus on serving the needs of the community and adopters of the developer data platform drives our innovation and product ethos. This year it has led to an unprecedented level of new features and capabilities. Most acutely now, senior executives and decision makers want to exploit data and AI to transform their organizations. Yet most enterprises struggle in this endeavor due to the complexity of their database management systems that inhibit their developers from achieving strategic and critical objectives rather than aiding them. The foundational concept behind MongoDB’s developer data platform has been to overcome the most critical challenges around enterprise data, such as the unification of data across multiple applications, data synchronization, complexity with multitudes of workload-specific tools and technologies, vendor lock-in for proprietary formats, poor interoperability, and duplicate efforts across cloud platforms. The most recent innovations on our platform simplify your operational, transactional, and AI-powered workloads and maintain the kind of flexibility and openness that allows your organization to stay agile as you scale with cost-efficiency, transparency, and security in mind. It’s not like there aren’t other phones or other cars, but how it’s all packaged together in a way that’s so compelling and so user-friendly and enables people to do what they want to do, is essentially what differentiates MongoDB. There’s other [tools] out there, but it’s very clunky for a developer to connect their vector data to their metadata, to their core data, to be able to orchestrate all that, then figure out how to do the embeddings and all that. It just becomes a very convoluted process.1 Dev Ittycheria, MongoDB CEO - November 2023 “Gartner defines the market for cloud database management systems (DBMSs) as the market for software products that store and manipulate data and that are primarily delivered as software as a service (SaaS) in the cloud. Cloud DBMSs may optionally be capable of running on-premises, or in hybrid, multicloud, or intercloud configurations.” To help users understand this emerging technology landscape, Gartner published its first Magic Quadrant for Cloud Database Management Systems back in 2020. Three years on and after evolving criteria to reflect how enterprise needs are changing, Gartner has named MongoDB as a Leader for the second consecutive year for the latest 2023 Magic Quadrant. Source:  Gartner We believe MongoDB was named a Leader in this report partly because of new capabilities such as Vector Search and Queryable Encryption, that have been brought to market to meet the ever-increasing demand for new applications and workloads. In addition to listening to developers’ and their organizations’ needs for new capabilities, MongoDB’s product teams have also been obsessed with ensuring new functionality does not equate to increased complexity, nor forsake the tenet of intuitive ease of use. Capabilities such as the Stable API ensure that applications are future-proofed to work with subsequent MongoDB releases, something unprecedented and unique today. Now, Relational Migrator enables new adopters to migrate their existing applications and workloads in a prescriptive and guided manner that encourages best practices and sound architectural design. A tailored holistic approach - people, process, and technology Digital transformation and change management can be an arduous and daunting prospect, particularly in the absence of expertise and guidance from those who have walked the same path previously. While technology is an enabler, such initiatives will fail without due consideration for the appropriate skills and promotion of tried-and-tested best practices. At MongoDB, this is an intrinsic element to how we embrace and welcome new adopters of our developer data platform — a defacto standard for document database-oriented application development. In 2023, we launched two new programs to ensure developers and their organizations new to MongoDB are set up for success. The first was Atlas for Industries to help organizations accelerate cloud adoption and modernization by utilizing industry-specific expertise, programs, partnerships, and integrated solutions. No less than seven vertical-specific solutions were launched in 2023 covering Atlas for Financial Services, Government, Manufacturing and Automotive, Retail, Healthcare, Insurance, and Telecommunications. In each instance, organizations and their teams gain access to expert-led architectural design reviews, partner integrations and toolchains, innovation workshops, professional services teams, and dedicated training to ensure the relevant knowledge is harnessed and proliferates throughout the entire organization. The second initiative was the MongoDB AI Innovators Program, which provides organizations building AI-powered applications and technology with access to expert technical support and guidance, MongoDB Atlas credits, collaboration opportunities via our partner ecosystem, and joint go-to-market activities with MongoDB to accelerate innovation and time to market. The program consists of two tracks: one for early-stage ventures and another for more established companies. Both provide opportunities to join a community of founders and developers while gaining access to dedicated resources, training, and counsel from subject matter experts. Realizing the value of MongoDB The success of those taking advantage of MongoDB’s developer data platform is abundant, as evidenced when one looks at adopters among the most successful of enterprises across all industries: 64 of the Fortune 100 192 of the Fortune 500 457 of the Fortune 2000 The community of MongoDB users have also spoken on Gartner Peer Insights™; 94% of MongoDB users who provided reviews to Gartner Peer Insights platform said they would recommend us2 (based on 49 ratings with an average of 4.6 out of 5 stars in the last 12 months, as of 15 January, 2023). Source:  Gartner Peer Insights An ecosystem of interoperability Having a well-architected data platform is foundational, however working in a vacuum is another potential pitfall. Every organization, new or established, has infrastructure that must integrate and work together. At MongoDB, we realize it is critical that your application database works as a well-oiled component alongside the rest of your tooling ecosystem. It is imperative that technology partners work seamlessly with one another and in a coordinated and consistent manner. For this reason, MongoDB has cultivated a partner ecosystem; a collaborative approach spanning innovative and bleeding edge pioneers of genAI, established and ubiquitous cloud providers, and a further 1000+ technology and service integration partners. The value of system integrators (SI) is something MongoDB does not underestimate. In the last 12 months, MongoDB has certified over 10,000 SI Associates and Architects. These certifications enable our SI partners to accelerate our clients’ AI journeys by enabling sound design approaches, ensuring best practices are followed, and expediting delivery. Data accessibility is a critical element and our certification programs rapidly enable SIs to enable organizations to meet these challenging demands. Quantity is one thing, but what of the quality of these partnerships? It’s worth noting that MongoDB is the only independent software vendor (ISV) featured in each of the top four cloud providers’ consoles and start up programs. Our efforts have not only been recognised by the leading analyst firms but by our top tier technology partners as evidenced by the awards received in 2023 alone: AWS EMEA Marketplace Partner of the Year AWS ISV Partner of the Year for ASEAN AWS ISV Partner of the Year for Chile AWS ISV Partner of the Year for Taiwan Google Cloud Technology Partner of the Year for Data Management Google Cloud Data — Smart Analytics Technology Partner of the Year MongoDB also signed a strategic partnership with Microsoft in 2023. This followed a four-year extension to a strategic global partnership with Alibaba. MongoDB has worked closely with AWS to enhance the value offered via AI-powered AWS CodeWhisperer and Bedrock collaborative efforts. The importance of a unified ecosystem to enable generative AI use cases on the same stack that supports traditional transactional and analytical use cases is critical to ensure simplification, lower latency, and cost containment. Sanjeev Mohan, SanjMo Principal, and former Gartner Research VP - Big Data and Advanced Analytics In his Spotlight document3, Mohan lauds MongoDB for its extensive integration with the ever-expanding ecosystem of large language model (LLM) providers as well as ISVs developing and deploying the AI value chain. Evaluating a leader in Magic Quadrant for Cloud Database Management Systems “Which are the competing players in the major technology markets? How are they positioned to help you over the long haul? A Gartner Magic Quadrant is a culmination of research in a specific market, giving you a wide-angle view of the relative positions of the market’s competitors. By applying a graphical treatment and a uniform set of evaluation criteria, a Magic Quadrant helps you quickly ascertain how well technology providers are executing their stated visions and how well they are performing against Gartner’s market view." 4 MongoDB’s take: Given that they encompass technical, commercial, operational and strategic considerations, Gartner’s evaluation of 19 cloud DBMS vendors against 15 criteria (seven on execution and eight on vision) is comprehensive and extensive. Our market presence, above-market growth rates, and establishment as a nonrelational database standard have been consistently highlighted as strengths by several analyst firms and research organizations prior to the publication of this report5. It is our opinion that our placement as a Leader in this Magic Quadrant is a reflection of these trends as well as our holistic approach to supporting the MongoDB community. Visit the Gartner website to obtain the full report (requires Gartner subscription)6. Getting started on your cloud journey MongoDB Atlas is engineered to help you make the shift to the cloud. We would appreciate the opportunity to understand more about your key transformation initiatives and workshop ideas with your teams to accelerate delivery. In the interim, your engineers and developers can familiarize themselves with MongoDB right away by signing up for a free account on MongoDB Atlas. Have them create a free database cluster, load your own data or our sample data sets, and explore what’s possible within the platform. Following on from our enhanced MongoDB University program, launched in November 2022, and in June 2023 MongoDB partnered with digital learning providers, such as Coursera and LinkedIn Learning, to make our software development courses available to more students worldwide. Additionally, the MongoDB Developer Center hosts an array of resources including tutorials, sample code, videos, and documentation. 1 Source: SiliconANGLE article, November 2023: “MongoDB looks to enable developers to do more sophisticated analytics”, Ryan Stevens 2 Gartner® and Peer Insights™ are trademarks of Gartner, Inc. and/or its affiliates. All rights reserved. Gartner Peer Insights content consists of the opinions of individual end users based on their own experiences, and should not be construed as statements of fact, nor do they represent the views of Gartner or its affiliates. Gartner does not endorse any vendor, product or service depicted in this content nor makes any warranties, expressed or implied, with respect to this content, about its accuracy or completeness, including any warranties of merchantability or fitness for a particular purpose. 3 Source: SanjMo article, December 2023: “Spotlight: Evaluating MongoDB Atlas Vector Search”, Sanjeev Mohan 4 Source: Gartner, January 2023: “Positioning technology players within a specific market” 5 Source: Forrester Wave: Translytical Data Platforms, Q4 2022, ISG (Ventana Research) Operational Data Platforms 2023 Value Index and DB-Engines 6 Gartner and Magic Quadrant are registered trademarks of Gartner, Inc. and/or its affiliates in the U.S. and internationally and is used herein with permission. All rights reserved. Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose. The Gartner logo is a trademark and service mark of Gartner, Inc., and/or its affiliates, and is used herein with permission. All rights reserved.

MongoDB被评为2023年Gartner云数据库管理系统魔力象限的领导者。公司专注于满足开发者数据平台的社区和采用者的需求,推出了新的功能和能力。MongoDB的开发者数据平台旨在解决企业数据的统一、同步和复杂性等挑战。公司还推出了帮助组织加速云采用和构建AI应用的计划。MongoDB拥有强大的合作伙伴生态系统,并获得了顶级云提供商的认可。该公司的成功可从其被财富100、财富500和财富2000公司采用中看出。

相关推荐 去reddit讨论

Planet PostgreSQL -

Tristen Raab: JSON in PostgreSQL: Revolutionizing Data Flexibility in Your Database

Introduction In this blog, we’ll go over PostgreSQL’s implementation and handling of JSON objects. Having some experience with Linux, Postgres, and JSON is necessary as we’ll not only be going over these new features but also how to implement them. This blog was written using PostgreSQL 16 (Development Version) running on Ubuntu 23.04. First I’ll go over some background on JSON as a short refresher, then move on to how we use JSON in Postgres, followed by what helpful functions we can use to interact with JSON objects. Background The JavaScript Object Notation (JSON) is an open standard file format for storing information in key, value pairs. It boasts a lightweight and language-independent format that is both human-legible and easy for machines to generate and parse. Its main advantage and why it has become so ubiquitous for data storage is its seamless interoperability between applications. This lends itself well to web applications as often we need two programs to communicate and each might be using a different language for its implementation. As long as each program has a way to parse JSON files, they should be able to communicate effectively regardless of what software or hardware the other is using. Now that we see how great JSON is for data storage, let’s look at how we can have it as part of ou Postgres database. Using JSON PostgreSQL has two datatypes for storing JSON data in a table, json and jsonb. The json type stores JSON data as a string, so when it is read back the receiving application will need to convert the text back into a JSON object. The jsonb type on the other hand stores JSON objects directly as their binary representation. When we store a JSON object as jsonb, PostgreSQL maps the JSON types to its own datatypes, these follow from the PostgreSQL documentation: JSON primitive type PostgreSQL type Notes string [...]

本文介绍了PostgreSQL对JSON对象的实现和处理方式。JSON是一种存储键值对信息的开放标准文件格式,具有轻量级和语言无关的特点。PostgreSQL有两种数据类型用于在表中存储JSON数据,分别是json和jsonb。json类型将JSON数据存储为字符串,而jsonb类型直接将JSON对象存储为二进制表示。PostgreSQL还提供了一些函数和操作符,用于访问和操作JSON对象。通过创建具有JSON数据类型的表,我们可以使用这些函数和操作符来查询和操作JSON对象。此外,PostgreSQL还实现了更强大的函数,用于转换和检索JSON对象的信息。总之,JSON数据类型是一种非常灵活和互操作的对象,可以简化应用程序之间的数据传递。

相关推荐 去reddit讨论

Devart Blog -

How to Create a Database in SQL Server

Microsoft SQL Server is known as a relational database management system (RDBMS). It's designed to store and manage substantial amounts of data efficiently. The system provides many features and tools required to develop and administer databases. That's why SQL Server is a popular solution among developers and enterprises for completing different tasks in the field of data. The post How to Create a Database in SQL Server appeared first on Devart Blog.

Microsoft SQL Server是一种强大的关系型数据库管理系统,用于高效存储和管理大量数据。它提供了许多功能和工具,用于开发和管理数据库。SQL Server在数据领域的不同任务中是一种受欢迎的解决方案。创建SQL Server数据库对于有效管理数据非常重要。

相关推荐 去reddit讨论

热榜 Top10

...
Dify.AI
...
观测云
...
LigaAI
...
白鲸技术栈
...
ShowMeBug
...
eolink
...
天勤数据

推荐或自荐