lotus notes

收集常见问题汇总，供实际使用参考

Oracle is one of the most widely used database management systems, offering a rich set of features and powerful performance. This Oracle Study Note covers the basics of database management and SQL, providing an in-depth exploration of key concepts. Data Dictionary: Oracle's data dictionary consists of a series of views and tables that store information about database objects, privileges, and other metadata. For example, dba_tablespaces provides the status of all tablespaces, dba_users displays user information, user_sys_privs lists system privileges for users, and user_tab_privs_made records table permissions granted to other users. Other views, such as user_col_privs_made and user_role_privs, help monitor and manage column-level and role-based permissions. SQL Statements: SQL is the language used to interact with Oracle. It includes commands for creating users, modifying user properties (such as passwords and default tablespaces), granting and revoking privileges, creating and managing objects (like tables, columns, and constraints), and performing data operations (insert, update, delete). For instance, CREATE USER creates a new user, ALTER USER modifies user attributes, GRANT and REVOKE manage privileges, and INSERT INTO, UPDATE, and DELETE FROM are used to manipulate data. Constraints and Indexes: Oracle offers various types of constraints, such as NOT NULL, PRIMARY KEY, UNIQUE, FOREIGN KEY, and CHECK, which ensure data integrity and consistency. Indexes speed up data retrieval. Views and Synonyms: A view is a virtual table based on one or more tables, simplifying complex queries and protecting data. A synonym provides an alias for objects, allowing users to access different objects with the same name, improving database accessibility. Transactions and Rollbacks: In Oracle, a transaction is a group of logical operations that must either all succeed or all fail, ensuring data consistency. Use COMMIT to commit a transaction, ROLLBACK to undo changes, and SAVEPOINT to set a rollback point. SQL Utility Commands: Useful SQL commands include DESCRIBE (to view table structure), SELECT * FROM dual (for connection testing), SPOOL (to save query results to a file), SHOW (to display session settings), and HELP (to provide help information).

在做Maven时，才知道Oracle的驱动jar还要收费，所有Maven中央就没有需要自己安装，现在记录下来备用！

Level 4 Database Engineer Knowledge Overview 1. Basic Knowledge 1. Database Technology Basic Concepts- Definition: Database technology focuses on the efficient storage, management, processing, and retrieval of data.- Development History: Database technology originated in the 1960s and gradually became a core component of modern information systems as computer technology advanced. 2. Information and Data- Information: Information reflects the state and changes of objects in the world, describing the relationships and interactions between them.- Data: Data is a collection of symbols used to record information, serving as the carrier of information. Data Processing and Data Management Data Processing: Involves operations such as classifying, collecting, organizing, and storing data. Data Management: Refers to the classification, collection, organization, encoding, storage, retrieval, and maintenance of data. 3. Database System- Database: A structured, shared collection of data stored on a computer for long-term use.- Database Management System (DBMS): A software system that manages data between the user and the operating system.- Database System (DBS): The entire system that includes hardware, software, and users. 2. Database Application System Analysis and Planning 1. Software Engineering and Software Lifecycle- Software Lifecycle: Includes stages such as requirement analysis, design, implementation, testing, operation, and maintenance.- Database System Lifecycle: Includes requirement analysis, conceptual design, logical design, physical design, implementation & deployment, and operation & maintenance. 2. Database Development Methods and Tools- Development Methods: Such as the Waterfall Model, Spiral Model, etc.- Development Tools: Tools for database design, management, etc. 3. Database Application Architecture- Client/Server (C/S) Structure: The client handles the user interface, while the server processes the data.- Browser/Server (B/S) Structure: The browser acts as the client, and the server handles data processing. 3. Database Design and Implementation 1. Conceptual Design- Use methods like the ER model for conceptual design.- Entities, attributes, and relationships in the ER model.- Represented using Entity-Relationship diagrams (ERD). 2. Logical Design- Transform the conceptual design into a specific data model supported by a DBMS.- Choice between relational models, network models, and hierarchical models. 3. Physical Design- Based on logical design, focus on the physical storage and access methods.- Design of storage structures, indexing strategies, etc. 4. Database Object Implementation and Operations- Creation and use of database objects such as tables, views, stored procedures.- Application of SQL language. 4. Database

注意，这是notes哦~~不是书，McAndrew的书很好，但是我也只是在图书馆里看过，始终没有下载到，这个是notes，也算是对书的一些补充，我们上课的时候老师都是以这本书说的~~

ORACLE_OCP10g学习笔记，主要涉及OCP认证学习的关键知识点与技巧。将分享有关ORACLE OCP 10g认证的复习经验，包括重要概念、常见问题以及实用资源，帮助考生高效备考。主要内容包括：数据库架构与管理性能优化与故障排除备份与恢复策略SQL与PL/SQL优化技巧通过系统化学习和实践，达到OCP认证考试要求。本笔记将引导学习者通过实践与理论相结合的方式，轻松掌握考试必备内容。

SQL Server Reporting Services (SSRS)关键概念和重要要点

在matlab中实现leetcode-notes 42.收集雨水左指针aur右指针lo, paani toh un logo ke bich me hi bharega, toh minimum kaunsa hai woh paani woh building ke upper aayega。 public int trap( int [] A ){ int a = 0 ; int b = A . length - 1 ; int max = 0 ; int leftmax = 0 ; int rightmax = 0 ; while (a <= b){ leftmax = Math . max(leftmax, A [a]); rightmax = Math . max(rightmax, A [b]); if (leftmax < rightmax xss=removed>

Version 12.2.0.1.0 Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications oracle-instantclient12.2-basiclite-12.2.0.1.0-1.x86_64.rpm (52,826,628 bytes) (cksum - 888077889)

Bi-LSTM MATLAB Code – DataScience-Notes 数据科学笔记。提供有关数据科学的笔记、代码和实例，涵盖数学、统计、机器学习、深度学习等基础知识及相关应用场景。参考资料已在最后列出。大部分代码采用Python编写，涉及的库及框架包括： NumPy、SymPy、Scikit-learn、Gensim、TensorFlow 1.X、TensorFlow 2.X 和 MXNet。部分数值分析代码则使用MATLAB编写。 注释：- (notebook): Jupyter Notebook 文件链接- (MATLAB): 相应的 MATLAB 代码链接- (md): Markdown 文件链接- (link): 外部链接 目录1. Prerequisite Knowledge (必备知识)- 1.1 Basic Concepts Related to Mathematics and Python Implementation (数学相关基础概念和Python实现)- Vector and Determinant (向量和行列式)- Matrix (矩阵及其运算)